[SR-Users] "Version" Table missing

[Daniel-Constantin Mierla]

Hello,

don't forget to keep the mailing list cc-ed for the discussions started 
there...

On 12/5/11 8:20 PM, mn3250 mn3250 wrote:
> Had to modify /usr/local/etc/kamailio/kamctlrc and everything started 
> to work.
Was it just setting DBENGINE and then running kamdbctl create or was 
some other kind of modification?

Cheers,
Daniel

>
> On Mon, Nov 28, 2011 at 4:15 PM, Daniel-Constantin Mierla 
> <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>
>     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  <mailto: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
>
>

-- 
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/20111205/e0e5e945/attachment.htm>