21 Aug
2018
21 Aug
'18
10:50 a.m.
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/