[asterisk 11] drop and migrate sqlite2 to sqlite3

Bug #1040800 reported by Dimitri John Ledkov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
asterisk (Ubuntu)
Confirmed
Wishlist
Unassigned

Bug Description

As part of:
https://wiki.ubuntu.com/UbuntuDevelopment/BugFixingInitiative#Moving_away_from_sqlite

Asterisk was identified to use sqlite2:
http://people.canonical.com/~ubuntu-archive/transitions/sqlite

There are a couple of modules in both sqlite2 & sqlite3 variants.

res_config_sqlite is only available in sqlite2 variant.

This should be fixed, or dropped.

Changed in asterisk (Ubuntu):
status: New → Confirmed
importance: Undecided → Wishlist
tags: added: sqlite2
Revision history for this message
Paul Belanger (pabelanger) wrote :

res_config_sqlite3 already exists. So when we drop sqlite2 support, those modules in asterisk will just be disabled.

Revision history for this message
Dimitri John Ledkov (xnox) wrote :

Can this be treated as a request to package it?
Or am I missing something?

$ apt-get download asterisk-modules
Get:1 Downloading asterisk-modules 1:1.8.13.0~dfsg-1ubuntu1 [2,200 kB]
Fetched 1 B in 0s (5 B/s)
$ dpkg-deb -c asterisk-modules_1.8.13.0~dfsg-1ubuntu1_amd64.deb | grep sqlite
-rw-r--r-- root/root 18944 2012-06-20 06:35 ./usr/lib/asterisk/modules/cdr_sqlite3_custom.so
-rw-r--r-- root/root 36128 2012-06-20 06:35 ./usr/lib/asterisk/modules/res_config_sqlite.so
-rw-r--r-- root/root 14816 2012-06-20 06:35 ./usr/lib/asterisk/modules/cel_sqlite3_custom.so
-rw-r--r-- root/root 10488 2012-06-20 06:35 ./usr/lib/asterisk/modules/cdr_sqlite.so

Revision history for this message
Paul Belanger (pabelanger) wrote :

Not sure what you mean. When are we expected to drop sqlite2?

If sqlite2 is going to be removed, then we can just updated the asterisk package dependencies and remove it. Hence removing res_config_sqlite and cdr_sqlite.

Revision history for this message
Dimitri John Ledkov (xnox) wrote :

Right now, it's simply a MOTU Developer initiative. Not a concrete / release team approved goal.
I am trying to triange and find packages that:
* depend on sqlite2
* have not been ported to sqlite3 OR do not have sqlite3 equivalent packaged

Binary package asterisk-modules depends on both sqlite2 & 3.

Most of the modules in that package provide both sqlite2 & 3 versions of modules where appropriate.

There is: res_config_sqlite module which links against sqlite2 and there is no res_config_sqlite3 provided.

So if we do decide to drop sqlite2, then there will be loss of functionality (res_config_sqlite module) with no upgrade path, cause there is no res_config_sqlite3 module. Hence this wishlist bug to port that individual module.

Revision history for this message
Paul Belanger (pabelanger) wrote :

Right. It just means we have to bump Asterisk from 1.8 to 11, that is when res_config_sqlite3 was added, when we drop sqlite2 and require an upgrade path.

tags: added: asterisk-11
summary: - res_config_sqlite should be ported to sqlite3
+ [asterisk 11] drop and migrate sqlite2 to sqlite3
Revision history for this message
Dimitri John Ledkov (xnox) wrote :

Asterisk 11 has been released. What is the packaging plan? Debian first?

Revision history for this message
Paul Belanger (pabelanger) wrote :

Yes, Debian first. Then we can sync from them

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.