[SR-Users] Question on Database Version Table

[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','2');
> /usr/share/kamailio/mysql/acc-create.sql:INSERT INTO version (table_name,
> table_version) values ('missed_calls','4');
> /usr/share/kamailio/mysql/alias_db-create.sql:INSERT INTO version
> (table_name, table_version) values ('dbaliases','1');
> /usr/share/kamailio/mysql/auth_db-create.sql:INSERT INTO version
> (table_name, table_version) values ('subscriber','7');
> /usr/share/kamailio/mysql/avpops-create.sql:INSERT INTO version
> (table_name, table_version) values ('usr_preferences','2');
> /usr/share/kamailio/mysql/carrierroute-create.sql:INSERT INTO version
> (table_name, table_version) values ('carrierroute','3');
> /usr/share/kamailio/mysql/carrierroute-create.sql:INSERT INTO version
> (table_name, table_version) values ('carrierfailureroute','2');
> /usr/share/kamailio/mysql/carrierroute-create.sql:INSERT INTO version
> (table_name, table_version) values ('carrier_name','1');
> /usr/share/kamailio/mysql/carrierroute-create.sql:INSERT INTO version
> (table_name, table_version) values ('domain_name','1');
> /usr/share/kamailio/mysql/cpl-create.sql:INSERT INTO version (table_name,
> table_version) values ('cpl','1');
> /usr/share/kamailio/mysql/dialog-create.sql:INSERT INTO version
> (table_name, table_version) values ('dialog','7');
> /usr/share/kamailio/mysql/dialog-create.sql:INSERT INTO version
> (table_name, table_version) values ('dialog_vars','1');
> /usr/share/kamailio/mysql/dialplan-create.sql:INSERT INTO version
> (table_name, table_version) values ('dialplan','2');
> /usr/share/kamailio/mysql/dispatcher-create.sql:INSERT INTO version
> (table_name, table_version) values ('dispatcher','4');
> /usr/share/kamailio/mysql/domain-create.sql:INSERT INTO version
> (table_name, table_version) values ('domain','2');
> /usr/share/kamailio/mysql/domain-create.sql:INSERT INTO version
> (table_name, table_version) values ('domain_attrs','1');
> /usr/share/kamailio/mysql/domainpolicy-create.sql:INSERT INTO version
> (table_name, table_version) values ('domainpolicy','2');
> /usr/share/kamailio/mysql/drouting-create.sql:INSERT INTO version
> (table_name, table_version) values ('dr_gateways','3');
> /usr/share/kamailio/mysql/drouting-create.sql:INSERT INTO version
> (table_name, table_version) values ('dr_rules','3');
> /usr/share/kamailio/mysql/drouting-create.sql:INSERT INTO version
> (table_name, table_version) values ('dr_gw_lists','1');
> /usr/share/kamailio/mysql/drouting-create.sql:INSERT INTO version
> (table_name, table_version) values ('dr_groups','2');
> /usr/share/kamailio/mysql/group-create.sql:INSERT INTO version
> (table_name, table_version) values ('grp','2');
> /usr/share/kamailio/mysql/group-create.sql:INSERT INTO version
> (table_name, table_version) values ('re_grp','1');
> /usr/share/kamailio/mysql/htable-create.sql:INSERT INTO version
> (table_name, table_version) values ('htable','2');
> /usr/share/kamailio/mysql/imc-create.sql:INSERT INTO version (table_name,
> table_version) values ('imc_rooms','1');
> /usr/share/kamailio/mysql/imc-create.sql:INSERT INTO version (table_name,
> table_version) values ('imc_members','1');
> /usr/share/kamailio/mysql/ims_charging_create.sql:INSERT INTO version
> (table_name, table_version) values ('ro_session','6');
> /usr/share/kamailio/mysql/ims_dialog-create.sql:INSERT INTO version
> (table_name, table_version) values ('dialog_in', 7), ('dialog_out', 7),
> ('dialog_vars', 7);
> /usr/share/kamailio/mysql/ims_usrloc_pcscf-create.sql:INSERT INTO version
> (table_name, table_version) values ('location','6');
> /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version
> (table_name, table_version) values ('contact','6');
> /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version
> (table_name, table_version) values ('impu','6');
> /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version
> (table_name, table_version) values ('impu_contact','6');
> /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version
> (table_name, table_version) values ('subscriber','6');
> /usr/share/kamailio/mysql/ims_usrloc_scscf-create.sql:INSERT INTO version
> (table_name, table_version) values ('impu_subscriber','6');
> /usr/share/kamailio/mysql/lcr-create.sql:INSERT INTO version (table_name,
> table_version) values ('lcr_gw','3');
> /usr/share/kamailio/mysql/lcr-create.sql:INSERT INTO version (table_name,
> table_version) values ('lcr_rule_target','1');
> /usr/share/kamailio/mysql/lcr-create.sql:INSERT INTO version (table_name,
> table_version) values ('lcr_rule','3');
> /usr/share/kamailio/mysql/matrix-create.sql:INSERT INTO version
> (table_name, table_version) values ('matrix','1');
> /usr/share/kamailio/mysql/mohqueue-create.sql:INSERT INTO version
> (table_name, table_version) values ('mohqcalls','1');
> /usr/share/kamailio/mysql/mohqueue-create.sql:INSERT INTO version
> (table_name, table_version) values ('mohqueues','1');
> /usr/share/kamailio/mysql/msilo-create.sql:INSERT INTO version
> (table_name, table_version) values ('silo','8');
> /usr/share/kamailio/mysql/mtree-create.sql:INSERT INTO version
> (table_name, table_version) values ('mtree','1');
> /usr/share/kamailio/mysql/mtree-create.sql:INSERT INTO version
> (table_name, table_version) values ('mtrees','2');
> /usr/share/kamailio/mysql/pdt-create.sql:INSERT INTO version (table_name,
> table_version) values ('pdt','1');
> /usr/share/kamailio/mysql/permissions-create.sql:INSERT INTO version
> (table_name, table_version) values ('trusted','6');
> /usr/share/kamailio/mysql/permissions-create.sql:INSERT INTO version
> (table_name, table_version) values ('address','6');
> /usr/share/kamailio/mysql/pipelimit-create.sql:INSERT INTO version
> (table_name, table_version) values ('pl_pipes','1');
> /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version
> (table_name, table_version) values ('presentity','5');
> /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version
> (table_name, table_version) values ('active_watchers','12');
> /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version
> (table_name, table_version) values ('watchers','3');
> /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version
> (table_name, table_version) values ('xcap','4');
> /usr/share/kamailio/mysql/presence-create.sql:INSERT INTO version
> (table_name, table_version) values ('pua','7');
> /usr/share/kamailio/mysql/purple-create.sql:INSERT INTO version
> (table_name, table_version) values ('purplemap','1');
> /usr/share/kamailio/mysql/registrar-create.sql:INSERT INTO version
> (table_name, table_version) values ('aliases','8');
> /usr/share/kamailio/mysql/rls-create.sql:INSERT INTO version (table_name,
> table_version) values ('rls_presentity','1');
> /usr/share/kamailio/mysql/rls-create.sql:INSERT INTO version (table_name,
> table_version) values ('rls_watchers','3');
> /usr/share/kamailio/mysql/rtpengine-create.sql:INSERT INTO version
> (table_name, table_version) values ('rtpengine','1');
> /usr/share/kamailio/mysql/rtpproxy-create.sql:INSERT INTO version
> (table_name, table_version) values ('rtpproxy','1');
> /usr/share/kamailio/mysql/sca-create.sql:INSERT INTO version (table_name,
> table_version) values ('sca_subscriptions','2');
> /usr/share/kamailio/mysql/siptrace-create.sql:INSERT INTO version
> (table_name, table_version) values ('sip_trace','4');
> /usr/share/kamailio/mysql/speeddial-create.sql:INSERT INTO version
> (table_name, table_version) values ('speed_dial','2');
> /usr/share/kamailio/mysql/standard-create.sql:INSERT INTO version
> (table_name, table_version) values ('version','1');
> /usr/share/kamailio/mysql/topos-create.sql:INSERT INTO version
> (table_name, table_version) values ('topos_d','1');
> /usr/share/kamailio/mysql/topos-create.sql:INSERT INTO version
> (table_name, table_version) values ('topos_t','1');
> /usr/share/kamailio/mysql/uac-create.sql:INSERT INTO version (table_name,
> table_version) values ('uacreg','3');
> /usr/share/kamailio/mysql/uid_auth_db-create.sql:INSERT INTO version
> (table_name, table_version) values ('uid_credentials','7');
> /usr/share/kamailio/mysql/uid_avp_db-create.sql:INSERT INTO version
> (table_name, table_version) values ('uid_user_attrs','3');
> /usr/share/kamailio/mysql/uid_domain-create.sql:INSERT INTO version
> (table_name, table_version) values ('uid_domain','2');
> /usr/share/kamailio/mysql/uid_domain-create.sql:INSERT INTO version
> (table_name, table_version) values ('uid_domain_attrs','1');
> /usr/share/kamailio/mysql/uid_gflags-create.sql:INSERT INTO version
> (table_name, table_version) values ('uid_global_attrs','1');
> /usr/share/kamailio/mysql/uid_uri_db-create.sql:INSERT INTO version
> (table_name, table_version) values ('uid_uri','3');
> /usr/share/kamailio/mysql/uid_uri_db-create.sql:INSERT INTO version
> (table_name, table_version) values ('uid_uri_attrs','2');
> /usr/share/kamailio/mysql/uri_db-create.sql:INSERT INTO version
> (table_name, table_version) values ('uri','1');
> /usr/share/kamailio/mysql/userblacklist-create.sql:INSERT INTO version
> (table_name, table_version) values ('userblacklist','1');
> /usr/share/kamailio/mysql/userblacklist-create.sql:INSERT INTO version
> (table_name, table_version) values ('globalblacklist','1');
> /usr/share/kamailio/mysql/usrloc-create.sql:INSERT INTO version
> (table_name, table_version) values ('location','9');
> /usr/share/kamailio/mysql/usrloc-create.sql:INSERT INTO version
> (table_name, table_version) values ('location_attrs','1');

Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337


On Fri, Nov 15, 2019 at 3:19 PM David Villasmil <
david.villasmil.work at gmail.com> wrote:

> 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.villasmil.work at gmail.com
> phone: +34669448337
>
>
> On Wed, Jun 19, 2019 at 8:35 AM Daniel-Constantin Mierla <
> miconda at gmail.com> wrote:
>
>>
>> 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 perceive it
>> > as a bug consciously. :-) If I had to guess, I think it was in usrloc.
>>
>> I do not remember such issue reported or encountered for usrloc module,
>> which is one quite popular. But it gets close to 20 years for usrloc, so
>> a lot could have happened along the time ...
>>
>> The version table is rather ancient basic check just to try to avoid
>> having kamailio starting ok, and then at runtime printing a lot of error
>> messages and not functioning properly. Probably it should be improved
>> somehow -- db api v2 tried to come with another approach, but that
>> direction was not followed much.
>>
>> Cheers,
>> Daniel
>>
>> --
>> Daniel-Constantin Mierla -- www.asipto.com
>> www.twitter.com/miconda -- www.linkedin.com/in/miconda
>>
>>
>> _______________________________________________
>> Kamailio (SER) - Users Mailing List
>> sr-users at lists.kamailio.org
>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20191115/9f3f8f32/attachment.html>