<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi guys,<br>
<br>
Since 1.4.0 released on Kamailio, I've been testing it on my
R&D server. With the introduction of RLS, I'm trying to implement
this module along with presence on my box, however, I'm having this
error messages whenever rls_handle_subscribe() been called.<br>
<br>
<hr size="2" width="100%">Aug 14 00:06:03 localhost
/sbin/kamailio[5139]: INFO: [<a class="moz-txt-link-freetext" href="sip:davidloh@192.168.72.128">sip:davidloh@192.168.72.128</a>](192.168.72.1)
- [eyeBeam release 1100l stamp 46319] entered<br>
Aug 14 00:06:03 localhost /sbin/kamailio[5139]: DBG: Request
[SUBSCRIBE] from [<a class="moz-txt-link-freetext" href="sip:davidloh@192.168.72.128">sip:davidloh@192.168.72.128</a>] (192.168.72.1)<br>
Aug 14 00:06:03 localhost /sbin/kamailio[5139]: <u>ERROR:db_mysql:db_mysql_submit_query:
driver error on query: Unknown column 'str_doc_col' in 'field list'</u><br>
Aug 14 00:06:03 localhost /sbin/kamailio[5139]: ERROR:core:db_do_query:
error while submitting query<br>
Aug 14 00:06:03 localhost /sbin/kamailio[5139]:
ERROR:rls:get_resource_list: while querying table xcap for
[uri]=<a class="moz-txt-link-freetext" href="sip:davidloh@192.168.72.128">sip:davidloh@192.168.72.128</a><br>
Aug 14 00:06:03 localhost /sbin/kamailio[5139]:
ERROR:rls:rls_handle_subscribe: while attepmting to get a resource list<br>
Aug 14 00:06:03 localhost /sbin/kamailio[5139]:
ERROR:rls:rls_handle_subscribe: occured in rls_handle_subscribe<br>
<hr size="2" width="100%"><br>
Have been google around for the solution but couldn't find any.
Appreciate if anyone could enlighten me on this.<br>
<br>
Meanwhile, I was wondering if any of could enlighten me on how to
get Kamailio + Presence + RLS works? No matter how I configure, SIP
client (eyeBeam) seems not able to pull out any buddies-list/anything
right from XCAP (integrated XCAP from Kamailio). Following is my
configuration (unnecessary part have been striped)<br>
<hr size="2" width="100%">loadmodule "sl.so"<br>
loadmodule "tm.so"<br>
loadmodule "db_mysql.so"<br>
<br>
loadmodule "presence.so"<br>
loadmodule "presence_xml.so"<br>
<br>
modparam("presence_xml", "force_active", 1)<br>
modparam("presence_xml", "xcap_table", "xcap")<br>
modparam("presence_xml", "pidf_manipulation", 0)<br>
modparam("presence_xml", "integrated_xcap_server", 1)<br>
<br>
modparam("presence", "presentity_table", "presentity")<br>
modparam("presence", "active_watchers_table", "active_watchers")<br>
modparam("presence", "watchers_table", "watchers")<br>
modparam("presence", "clean_period", 100)<br>
modparam("presence", "server_address", <a class="moz-txt-link-rfc2396E" href="sip:192.168.72.128:5060">"sip:192.168.72.128:5060"</a>)<br>
<br>
loadmodule "imc.so"<br>
<br>
loadmodule "mi_xmlrpc.so"<br>
modparam("mi_xmlrpc", "log_file", "/var/log/kamailio-xmlrpc.log")<br>
modparam("mi_xmlrpc", "port", 8080)<br>
<br>
loadmodule "pua.so"<br>
<br>
loadmodule "rls.so"<br>
modparam("rls", "integrated_xcap_server", 1)<br>
modparam("rls", "xcap_root", <a class="moz-txt-link-rfc2396E" href="http://192.168.72.128/xcap-root:8080">"http://192.168.72.128/xcap-root:8080"</a>)<br>
modparam("rls", "rls_event", "presence")<br>
modparam("rls", "to_presence_code", 10)<br>
<br>
loadmodule "xcap_client.so"<br>
modparam("xcap_client", "xcap_table", "xcap")<br>
modparam("xcap_client", "query_period", 50)<br>
<br>
<br>
modparam("presence|presence_xml|imc|pua\rls", "db_url",
"mysql://myuserid:mypassword@localhost/kamailio")<br>
<br>
...........<br>
<br>
route[0] {<br>
....<br>
<br>
if (is_method("NOTIFY")) {<br>
pua_update_contact();<br>
route(4);<br>
} else if (is_method("PUBLISH|SUBSCRIBE")) {<br>
route(5);<br>
}<br>
<br>
route[5] {<br>
if (!t_newtran()) {<br>
sl_reply_error();<br>
exit;<br>
};<br>
<br>
if(is_method("PUBLISH")) {<br>
handle_publish();<br>
t_release();<br>
} else if( is_method("SUBSCRIBE")) {<br>
$var(ret_code) = rls_handle_subscribe();<br>
if($var(ret_code)==10) {<br>
handle_subscribe();<br>
}<br>
t_release();<br>
} else if(is_method("NOTIFY")) {<br>
rls_handle_notify();<br>
xlog("L_INFO", "DBG: RLS handle_notify()");<br>
}<br>
<br>
exit;<br>
}<br>
<hr size="2" width="100%"><br>
Did I missed anything ?<br>
<br>
<br>
Thanks,<br>
David Loh<br>
</body>
</html>