~# 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');
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!On Wed, Jun 19, 2019 at 8:35 AM Daniel-Constantin Mierla <miconda@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@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users