[SR-Users] Issue with version table
Daniel-Constantin Mierla
miconda at gmail.com
Thu Nov 3 20:46:10 CET 2011
Hello,
as I can see from the logs, the database where it tries to connect is
named asterisk. Does it have the the table version?
Cheers,
Daniel
On 11/3/11 5:12 PM, Lucas Alvarez wrote:
> Hi Daniel, thank you for quick response, kamailio doesn't start when I
> add the event_route for xcap_server, this are the errors:
>
> 0(5319) DEBUG: <core> [route.c:928]: fixing uac_req_send()
> 0(5319) DEBUG: <core> [route.c:928]: fixing xdbg()
> 0(5319) DEBUG: <core> [rvalue.c:2777]: RV fixing type 4
> 0(5319) DEBUG: <core> [route.c:928]: fixing isbflagset()
> 0(5319) DEBUG: <core> [route.c:928]: fixing fix_nated_contact()
> 0(5319) DEBUG: <core> [rvalue.c:2777]: RV fixing type 4
> 0(5319) DEBUG: <core> [route.c:928]: fixing fix_nated_sdp()
> 0(5319) DEBUG: <core> [route.c:928]: fixing append_hf()
> 0(5319) DEBUG: <core> [rvalue.c:2777]: RV fixing type 4
> 0(5319) DEBUG: <core> [route.c:928]: fixing t_is_canceled()
> 0(5319) DEBUG: <core> [route.c:928]: fixing xdbg()
> 0(5319) DEBUG: <core> [route.c:928]: fixing append_hf()
> 0(5319) DEBUG: <core> [rvalue.c:2777]: RV fixing type 4
> 0(5319) DEBUG: <core> [route.c:928]: fixing isbflagset()
> 0(5319) DEBUG: <core> [rvalue.c:2777]: RV fixing type 7
> 0(5319) DEBUG: <core> [rvalue.c:2777]: RV fixing type 4
> 0(5319) DEBUG: <core> [route.c:928]: fixing fix_nated_sdp()
> 0(5319) DEBUG: <core> [route.c:928]: fixing append_hf()
> 0(5319) DEBUG: <core> [route.c:928]: fixing xdbg()
> 0(5319) DEBUG: <core> [rvalue.c:2777]: RV fixing type 4
> 0(5319) DEBUG: <core> [route.c:928]: fixing www_authorize()
> 0(5319) DEBUG: <core> [db.c:285]: connection 0xa6d830 not found in pool
> 0(5319) DEBUG: db_mysql [km_my_con.c:94]: opening connection:
> mysql://xxxx:xxxx@localhost/asterisk
> 0(5319) DEBUG: db_mysql [km_my_con.c:121]: connection type is
> Localhost via UNIX socket
> 0(5319) DEBUG: db_mysql [km_my_con.c:122]: protocol version is 10
> 0(5319) DEBUG: db_mysql [km_my_con.c:123]: server version is
> 5.1.41-3ubuntu12.10-log
> 0(5319) DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result
> set at 0xa6da40
> 0(5319) DEBUG: db_mysql [km_res.c:68]: 1 columns returned from the query
> 0(5319) DEBUG: <core> [db_res.c:155]: allocate 8 bytes for result
> names at 0xa04c28
> 0(5319) DEBUG: <core> [db_res.c:165]: allocate 4 bytes for result
> types at 0xa017a8
> 0(5319) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for
> RES_NAMES[0] at 0xa6dad0
> 0(5319) DEBUG: db_mysql [km_res.c:92]:
> RES_NAMES(0xa6dad0)[0]=[table_version]
> 0(5319) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
> 0(5319) DEBUG: db_mysql [km_res.c:169]: no rows returned from the query
> 0(5319) DEBUG: <core> [db.c:372]: no row for table subscriber found
> 0(5319) ERROR: <core> [db.c:408]: invalid version 0 for table
> subscriber found, expected 6 (check table structure and table "version")
> 0(5319) ERROR: auth_db [authdb_mod.c:252]: error during table version
> check.
> 0(5319) DEBUG: <core> [db_pool.c:102]: removing connection from the pool
> 0(5319) ERROR: <core> [route.c:1161]: fixing failed (code=-1) at
> cfg:/usr/local/etc/kamailio/kamailio.cfg:1286
> 0(5319) ERROR: <core> [route.c:1161]: fixing failed (code=-1) at
> cfg:/usr/local/etc/kamailio/kamailio.cfg:1292
> ERROR: error -1 while trying to fix configuration
> 0(5319) DEBUG: presence_xml [presence_xml.c:329]: start
> 0(5319) DEBUG: tm [t_funcs.c:122]: DEBUG: tm_shutdown : start
> 0(5319) DEBUG: tm [t_funcs.c:125]: DEBUG: tm_shutdown : emptying hash
> table
> 0(5319) DEBUG: tm [t_funcs.c:127]: DEBUG: tm_shutdown : removing
> semaphores
> 0(5319) DEBUG: tm [t_funcs.c:129]: DEBUG: tm_shutdown : destroying
> tmcb lists
> 0(5319) DEBUG: tm [t_funcs.c:132]: DEBUG: tm_shutdown : done
> 0(5319) DEBUG: tls [tls_init.c:657]: tls module final tls destroy
> 0(5319) DEBUG: <core> [mem/shm_mem.c:236]: shm_mem_destroy
> 0(5319) DEBUG: <core> [mem/shm_mem.c:239]: destroying the shared
> memory lock
>
>
> And this is the event_route cfg I have copied from the guide, I will
> mark lines 1286 and 1292
>
> #!ifdef WITH_XCAPSRV
> #!define WITH_XHTTPAUTH
> event_route[xhttp:request] {
> xdbg("===== xhttp: request [$rv] $rm => $hu\n");
> #!ifdef WITH_XHTTPAUTH
> if (!www_authorize("xcap", "subscriber")) 1286
> {
> www_challenge("xcap", "0");
> exit;
> }
> #!endif
> if($hu=~"^/xcap-root/") 1292
> {
> set_reply_close();
> set_reply_no_connect();
> # xcap ops
> $xcapuri(u=>data) = $hu;
> if($xcapuri(u=>xuid)=~"^sip:.+ at .+")
> $var(uri) = $xcapuri(u=>xuid);
> else if($xcapuri(u=>xuid)=~".+ at .+")
> $var(uri) = "sip:" + $xcapuri(u=>xuid);
> else
> $var(uri) = "sip:"+ $xcapuri(u=>xuid) + "@" + $Ri;
> xlog("===== xhttp: $xcapuri(u=>auid) :
> $xcapuri(u=>xuid)\n");
> if($xcapuri(u=>auid)=="xcap-caps")
> {
> $var(xbody) =
> "<?xml version='1.0' encoding='UTF-8'?>
> <xcap-caps xmlns='urn:ietf:params:xml:ns:xcap-caps'>
> <auids>
> <auid>rls-services</auid>
> <auid>pidf-manipulation</auid>
> <auid>xcap-caps</auid>
> <auid>resource-lists</auid>
> <auid>pres-rules</auid>
> <auid>org.openmobilealliance.pres-rules</auid>
> </auids>
> <extensions>
> </extensions>
> <namespaces>
> <namespace>urn:ietf:params:xml:ns:rls-services</namespace>
> <namespace>urn:ietf:params:xml:ns:pidf</namespace>
> <namespace>urn:ietf:params:xml:ns:xcap-caps</namespace>
> <namespace>urn:ietf:params:xml:ns:resource-lists</namespace>
> <namespace>urn:ietf:params:xml:ns:pres-rules</namespace>
> </namespaces>
> </xcap-caps>";
> xhttp_reply("200", "ok",
> "application/xcap-caps+xml",
> "$var(xbody)");
> exit;
> }
> #!ifdef WITH_XHTTPAUTH
> # be sure auth user access only its documents
> if ($au!=$(var(uri){uri.user})) {
> xhttp_reply("403", "Forbidden", "text/html",
> "<html><body>$si:$sp</body></html>");
> exit;
> }
>
> #!endif
> switch($rm) {
> case "PUT":
> xcaps_put("$var(uri)", "$hu", "$rb");
> if($xcapuri(u=>auid)=~"pres-rules")
> {
> xlog("===== xhttp put:
> refreshing watchers for $var(uri)\n");
>
> pres_update_watchers("$var(uri)", "presence");
>
> pres_refresh_watchers("$var(uri)", "presence", 1);
> }
> exit;
> break;
> case "GET":
> xlog("===== xhttp: get $var(uri) =>
> $hu\n");
> xcaps_get("$var(uri)", "$hu");
> exit;
> break;
> case "DELETE":
> xcaps_del("$var(uri)", "$hu");
> if($xcapuri(u=>auid)=~"pres-rules")
> {
> xlog("===== xhttp del:
> refreshing watchers for $var(uri)\n");
>
> pres_update_watchers("$var(uri)", "presence");
>
> pres_refresh_watchers("$var(uri)", "presence", 1);
> }
> exit;
> break;
> }
> }
>
> # http ops
> xhttp_reply("200", "ok", "text/html",
> "<html><body>OK:
> $si:$sp</body></html>");
> exit;
> }
> #!endif
>
> Thanks in advance,
>
>
> Lucas
>
>
>
>
> On Thu, Nov 3, 2011 at 12:56 PM, Daniel-Constantin Mierla
> <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>
> Hello,
>
> xcap_server has nothing to do with subscriber table. Can you make
> sure you have all modules compiled at the same time, just in case
> you updated system libraries.
>
> You can run kamailio with debug=3 to see exactly where it fails
> and get more log messages.
>
> Cheers,
> Daniel
>
>
> On 11/3/11 4:26 PM, Lucas Alvarez wrote:
>> Hi, I've enabled xcap server in kamailio 3.1.3 and I'm stuck with
>> this error:
>>
>> 0(5073) ERROR: <core> [db.c:408]: invalid version 0 for table
>> subscriber found, expected 6 (check table structure and table
>> "version")
>>
>> I've already checked the version table and the table_name =
>> 'subscriber' has table_version = 6.
>> Any help will be appreciated.
>> Regards.
>>
>>
>> Lucas
>>
>>
>>
>> _______________________________________________
>> 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/20111103/06a45721/attachment-0001.htm>
More information about the sr-users
mailing list