Thanks, Olle, will give it a go
Tony
From: "Olle E. Johansson" oej@edvina.net Date: Wednesday, 12 March 2025 at 15:06 To: "Kamailio (SER) - Users Mailing List" sr-users@lists.kamailio.org Cc: Olle E Johansson oej@edvina.net, Anthony Ford tony.ford@apalo.co.uk Subject: Re: [SR-Users] upgrading process
On 12 Mar 2025, at 15:30, Anthony Ford via sr-users sr-users@lists.kamailio.org wrote:
Hi
I need some help please.
I am very inexperienced with Kamailio, and am trying to work out how to upgrade without rewriting any of the current config.
I am going from 5.6.0 to 6.0.0 and wanted to know if I can run make install on every iteration i.e. 5.6.1, the 5.6.2 etc. until I need to make a bigger step, and may have to change tables etc.
In the document for upgrading 5.6.x to 5.7.x it says make change to Watch table, but I have no watch table.
For database migration:
Each table has a version number which should be documented in the README. So first, check which tables you are using (with active data), then check the version numbers in the “version” table that is an internal table that kamailio is using.
If there is a different version for the new Kamailio, then you need to compare schemas and adjust the tables. If the table versions are the same, you don’t need to change.
For 6.0 you can find the database schemas here for MySQL:
[cid:image001.png@01DB9361.3B162760] kamailio/utils/kamctl/mysql at 6.0 · kamailio/kamailiohttps://github.com/kamailio/kamailio/tree/6.0/utils/kamctl/mysql github.comhttps://github.com/kamailio/kamailio/tree/6.0/utils/kamctl/mysql
If you click on dialog-create, you’ll find an insert into the version table in the end
INSERT INTO version (table_name, table_version) values ('dialog_vars','1’);
So if you have no watcher table and are not using it, don’t worry. Focus on the database tables you use and check the versions. If you have an older version, update according to the schema for the database you are using.
/O