[SR-Users] invalid version 8 for table aliases found, expected 9

[Henning Westerholt]

Am Dienstag, 21. August 2018, 15:25:44 CEST schrieb Abdulaziz Alghosh:
> No. To read this table I am using usrloc module :/
> So, We are using lookup() function of the registrar module whereas the
> aliases table (has version 8) was given as parameter but not location (has
> version 9).

Hello Abdulaziz,

> I got rid of this error by writing lookup("location") instead of
> lookup("aliases").
> 
> Thus, I have a new question :
> 
> Should one only use lookup() function of the registrar module along with
> usrloc module to query only the "location" table ?

Ok, I suspected this cause. :-) So generally you should use the location table 
with the lookup() function. 

> or
> Use only alias_db_lookup() function from alias_db module to query the
> "aliases" table ?

And use the alias_db_lookup() function for the alias table.

But it depends of course on the actual logic that you want to achieve in your 
cfg. Basically you can use every table with lookup() as long its compatible 
with the expected scheme from the location table and you set the proper 
version entry in the version table. For this you can specify the table name, 
e.g. if you have a business requirement for another table name.

> what I was exactly getting as an error is below:
> 
>  0(4231) ERROR: <core> [db.c:450]: db_check_table_version(): invalid
> version 8 for table aliases found, expected 9 (check table structure and
> table "version")
>  0(4231) ERROR: usrloc [dlist.c:649]: register_udomain(): error during
> table version check.
>  0(4231) ERROR: registrar [registrar.c:651]: domain_fixup(): failed to
> register domain
>  0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
> (code=-1) at cfg://etc/kamailio/kamailio.cfg:1065
>  0(4231) ERROR: <core> [core/rvalue.c:3860]: fix_rval_expr(): failure in
> cfg at line: 1065 col: 28
>  0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
> (code=-1) at cfg://etc/kamailio/kamailio.cfg:1271
>  0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
> (code=-1) at cfg://etc/kamailio/kamailio.cfg:1271
>  0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
> (code=-1) at cfg://etc/kamailio/kamailio.cfg:1271
>  0(4231) ERROR: <core> [core/route.c:1154]: fix_actions(): fixing failed
> (code=-1) at cfg://etc/kamailio/kamailio.cfg:1276

Best regards,

Henning

-- 
Henning Westerholt
https://skalatan.de/blog/