21 Aug
2018
21 Aug
'18
1:31 p.m.
Hi everyone,
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?
Thanks in advance
Abdulaziz
21 Aug
21 Aug
1:48 p.m.
Hi,
I'm pretty sure that you just forgot to update table named - version. Just
try to dump it and see what it contains. It should contain record
version:9, but not 8 as it claims in error message.
With kind regards,
Jurijs
On Tue, Aug 21, 2018 at 2:32 PM Abdulaziz Alghosh <aziz647(a)gmail.com> wrote:
Hi everyone,
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?
Thanks in advance
Abdulaziz
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
2:06 p.m.
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/
3:25 p.m.
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(a)kamailio.org> wrote:
alias_db
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 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/
4:50 p.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/
2090
days inactive
2090
days old
4 comments
3 participants
participants (3)
-
Abdulaziz Alghosh -
Henning Westerholt -
Jurijs Ivolga