Re: [SR-Users] Question on Database Version Table

2019-11-15 Thread David Villasmil
Nevermind, got it. ~# grep "INSERT.*version" /usr/share/kamailio/mysql/* > /usr/share/kamailio/mysql/acc-create.sql:INSERT INTO version (table_name, > table_version) values ('acc','5'); > /usr/share/kamailio/mysql/acc-create.sql:INSERT INTO version (table_name, > table_version) values ('acc_cdrs',

Re: [SR-Users] Question on Database Version Table

2019-11-15 Thread David Villasmil
Hello All, I need to do a version upgrade from 5 to 5.2. I read about the version_table parameter and i know i can create it and set the versions there. But where do i get the correct versions for the table? i.e.: location is version N? Thanks all! Regards, David Villasmil email: david.villasm

Re: [SR-Users] Question on Database Version Table

2019-06-19 Thread Daniel-Constantin Mierla
On 18.06.19 22:11, Alex Balashov wrote: > On Tue, Jun 18, 2019 at 10:09:56PM +0200, Daniel-Constantin Mierla wrote: > >> Where did you meet such situation? > I wish I could remember. It's been in various times over the years, but > I never filed a bug report--probably because I didn't really perc

Re: [SR-Users] Question on Database Version Table

2019-06-18 Thread Alex Balashov
On Tue, Jun 18, 2019 at 10:09:56PM +0200, Daniel-Constantin Mierla wrote: > Where did you meet such situation? I wish I could remember. It's been in various times over the years, but I never filed a bug report--probably because I didn't really perceive it as a bug consciously. :-) If I had to gu

Re: [SR-Users] Question on Database Version Table

2019-06-18 Thread Daniel-Constantin Mierla
On 18.06.19 21:50, Alex Balashov wrote: > 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. Where did you meet such situation? A missing but expected column should end up in

Re: [SR-Users] Question on Database Version Table

2019-06-18 Thread Alex Balashov
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, depe

Re: [SR-Users] Question on Database Version Table

2019-06-18 Thread JR Richardson
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

Re: [SR-Users] Question on Database Version Table

2019-06-18 Thread Daniel-Constantin Mierla
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 deplo

Re: [SR-Users] Question on Database Version Table

2019-06-18 Thread Alex Balashov
Hi JR, A Kamailio of a given version will want the version table entries it expects for its version, and will blow up on boot if it does not find them. But it is safe to update them while Kamailio is running, as long as you acknowledge that Kamailio will not start properly if it crashes or is rest

[SR-Users] Question on Database Version Table

2019-06-18 Thread JR Richardson
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 | trust