hi Henning,

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).

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 ? or Use only alias_db_lookup() function from alias_db module to query the "aliases" table ?

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 Abdul

On Tue, Aug 21, 2018 at 2:06 PM, Henning Westerholt hw@kamailio.org wrote:

Am Dienstag, 21. August 2018, 13:31:36 CEST schrieb Abdulaziz Alghosh:

...

i am trying to start kamailio 5.1.4 after the migration from Kamailio

3.0.3

...

but getting newly the following error:

ERROR: <core> [db.c:450]: db_check_table_version(): invalid version 8

for

...

table aliases found, expected 9 (check table structure and table

"version")

...

Allegedlly, this error is because of a wrong version of "aliases"

table. I

...

followed the Upgrade process starting from 3.0.3 till 5.1.x and I

altered

...

the structure of my aliase table accordinglly. The last new version of aliases is 8 as it is described at the upgrade

from

...

4.2.x to 4.3.0

Even though, the error here says that the newest version is 9:

May someone help me to find out if the aliases table's structure was renewed in between ?? Is there any modification in the data types?

Hello Abdulaziz,

version 8 is the current version of the alias table, even in git master.

$ kamailio/src> grep "version" lib/srdb1/schema/aliases.xml

<?xml version="1.0" encoding="UTF-8"?>

<version>8</version>

I am a bit confused, do you actually try to read this table from the

alias_db

module? Because I was not able to find a version check here in the code.

Version 9 is only used from location table.

Please quote a bit more lines of your error here.

Best regards,

Henning

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