Hello,
I want to upgrade my both Kamailio from 4.4 to 5.1 I have to upgrade the SQL structure before running the 5.1 release.
But my SQL servers are synchronized - Kamailio 4.4 can works with the 5.1 SQL structure ?
On Mon, Aug 13, 2018 at 10:52:59AM +0000, Nicolas Breuer wrote:
I want to upgrade my both Kamailio from 4.4 to 5.1 I have to upgrade the SQL structure before running the 5.1 release.
But my SQL servers are synchronized - Kamailio 4.4 can works with the 5.1 SQL structure ?
If there are no version breaking changes between 4.4 and 5.1 (depends on the modules used, for me there were no breaking changes), you can use the version_table directive in the config to point to an other table that stores the version fields, e.g. version_table="version44"
Set this directive in the 4.4.x machines. Update the tables/config according to https://www.kamailio.org/wiki/install/upgrade/4.4.x-to-5.0.0 and https://www.kamailio.org/wiki/install/upgrade/5.0.x-to-5.1.0 On the upgrade 5.1.x remove the directive and if you did everything correctly it should work (tm)/I worked for me (tm).
Just put version_table="version44" in Kamailio.conf ?
Thanks
-----Message d'origine----- De : sr-users sr-users-bounces@lists.kamailio.org De la part de Daniel Tryba Envoyé : lundi 13 août 2018 15:23 À : Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Objet : Re: [SR-Users] Upgrade from 4.4 to 5.1
On Mon, Aug 13, 2018 at 10:52:59AM +0000, Nicolas Breuer wrote:
I want to upgrade my both Kamailio from 4.4 to 5.1 I have to upgrade the SQL structure before running the 5.1 release.
But my SQL servers are synchronized - Kamailio 4.4 can works with the 5.1 SQL structure ?
If there are no version breaking changes between 4.4 and 5.1 (depends on the modules used, for me there were no breaking changes), you can use the version_table directive in the config to point to an other table that stores the version fields, e.g. version_table="version44"
Set this directive in the 4.4.x machines. Update the tables/config according to https://www.kamailio.org/wiki/install/upgrade/4.4.x-to-5.0.0 and https://www.kamailio.org/wiki/install/upgrade/5.0.x-to-5.1.0 On the upgrade 5.1.x remove the directive and if you did everything correctly it should work (tm)/I worked for me (tm).
On Mon, Aug 13, 2018 at 02:16:36PM +0000, Nicolas Breuer wrote:
Just put version_table="version44" in Kamailio.conf ?
I tried ammend my message, but (hopefully) more clear:
version_table points to an alternate table in the database that contains the versions of the other tables. If both kamailio 4.x and 5.x just look at the same table ("version") at least 1 will fail (on restart due to static checks against the versions listed per module).
So copy the current (4.4.x) table to "version44": create table version44 select * from version (or whatever you sql backend understands). Set this for the machines that will stay at 4.4.x and follow the upgrade path for the other(s).
-
Daniel Tryba -
Nicolas Breuer