18 Jun
2019
18 Jun
'19
10:50 p.m.
It's probably also worth noting that Kamailio's DB layer offers
"unpredictable" reactions to columns which are missing and which the
given version expects to be there.
"Unpredictable" generally means a crash, but when it happens -- the
presence of columns isn't always validated at boot time, depends on the
module -- is the unpredictable part...
So, modernising your DB schema for built-in module tables, including
seldom-used tables which are nevertheless formally used to back some
module, is important when doing upgrades.
On Tue, Jun 18, 2019 at 02:46:27PM -0500, JR Richardson wrote:
Yep
version_table
Set the name of the table holding the table version. Useful if the
proxy is sharing a database within a project and during upgrades.
Default value is “version”.
Example of usage:
version_table="version44"
That's what I was looking for, perfect!
Yes, I added accountcode and notes to my table for internal use, was
just making notes on columns I need on the new version upgrade.
Thanks.
JR
On Tue, Jun 18, 2019 at 2:17 PM Daniel-Constantin Mierla
<miconda(a)gmail.com> wrote:
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
Hello,
like Alex said, you can have two version tables, one for each versions
of kamailio you play with and use in config the core parameter to set
the name of that table.
I am actually writing to say that address table never had accountcode
and notes columns. Likely they were added in your deployment for other
purposes or either the default column names were changed. The default
column names are listed at:
-
https://kamailio.org/docs/db-tables/kamailio-db-5.2.x.html#gen-db-address
These were the same for rather long time, iirc the recent version number
changed mainly due to with modifications done to the size, not due to
new columns.
Cheers,
Daniel
On 18.06.19 20:50, JR Richardson wrote:
> Hey All,
>
> I'm doing some upgrades and noticed database table version numbers
> have increased.
>
> database table adjustments:
> | address | production ver 3 | upgrade 5.2 ver 6 | need to add
> accountcode and notes column
> | dispatcher | production ver 3 | upgrade 5.2 ver 4 | need to add attr column
> | trusted | production ver 5 | upgrade 5.2 ver 6 | need to add
> ruri_pattern and priority column
>
> I run mysql master/slave so I'm concerned about the master database
> not having the correct version numbers or can I just update the
> version number in the table when I do the upgrade of the kamailio
> versions?
>
> Thanks.
>
> JR
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users