[SR-Users] "Version" Table missing

[Daniel-Constantin Mierla]

Hello,

can you check inside MySQL server if database voip1 has a table named 
version?

What is the kamailio version you are using? How did you create the 
database, with kamdbctl create?

Cheers,
Daniel

On 11/28/11 2:59 PM, mn3250 mn3250 wrote:
> Hi,
> Looks like the table "Version" is missing in the sql create script.
>  0(18594) DEBUG: db_mysql [km_my_con.c:94]: opening connection: 
> mysql://xxxx:xxxx@localhost/voip1
>  0(18594) DEBUG: db_mysql [km_my_con.c:121]: connection type is 
> Localhost via UNIX socket
>  0(18594) DEBUG: db_mysql [km_my_con.c:122]: protocol version is 10
>  0(18594) DEBUG: db_mysql [km_my_con.c:123]: server version is 5.0.77-log
>  0(18594) DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result 
> set at 0x2ba27ac440b0
>  0(18594) DEBUG: db_mysql [km_res.c:68]: 1 columns returned from the query
>  0(18594) DEBUG: <core> [db_res.c:155]: allocate 8 bytes for result 
> names at 0x2ba27ac44140
>  0(18594) DEBUG: <core> [db_res.c:165]: allocate 4 bytes for result 
> types at 0x2ba27ac441a8
>  0(18594) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for 
> RES_NAMES[0] at 0x2ba27ac44210
>  0(18594) DEBUG: db_mysql [km_res.c:92]: 
> RES_NAMES(0x2ba27ac44210)[0]=[table_version]
>  0(18594) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
>  0(18594) DEBUG: db_mysql [km_res.c:169]: no rows returned from the query
>  0(18594) DEBUG: <core> [db.c:385]: no row for table location found
>  0(18594) ERROR: <core> [db.c:421]: invalid version 0 for table 
> location found, expected 1004 (check table structure and table "version")
> Anyone has the correct file?
> Thanks
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
Kamailio Advanced Training, Dec 5-8, Berlin: http://asipto.com/u/kat
http://linkedin.com/in/miconda -- http://twitter.com/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20111128/e0ad8531/attachment-0001.htm>