13 Aug
2008
13 Aug
'08
1:35 p.m.
Hi guys,
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.
------------------------------------------------------------------------
Aug 14 00:06:03 localhost /sbin/kamailio[5139]: INFO:
[sip:davidloh@192.168.72.128](192.168.72.1) - [eyeBeam release 1100l
stamp 46319] entered
Aug 14 00:06:03 localhost /sbin/kamailio[5139]: DBG: Request [SUBSCRIBE]
from [sip:davidloh@192.168.72.128] (192.168.72.1)
Aug 14 00:06:03 localhost /sbin/kamailio[5139]:
_ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown
column 'str_doc_col' in 'field list'_
Aug 14 00:06:03 localhost /sbin/kamailio[5139]: ERROR:core:db_do_query:
error while submitting query
Aug 14 00:06:03 localhost /sbin/kamailio[5139]:
ERROR:rls:get_resource_list: while querying table xcap for
[uri]=sip:davidloh@192.168.72.128
Aug 14 00:06:03 localhost /sbin/kamailio[5139]:
ERROR:rls:rls_handle_subscribe: while attepmting to get a resource list
Aug 14 00:06:03 localhost /sbin/kamailio[5139]:
ERROR:rls:rls_handle_subscribe: occured in rls_handle_subscribe
------------------------------------------------------------------------
Have been google around for the solution but couldn't find any.
Appreciate if anyone could enlighten me on this.
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)
------------------------------------------------------------------------
loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "db_mysql.so"
loadmodule "presence.so"
loadmodule "presence_xml.so"
modparam("presence_xml", "force_active", 1)
modparam("presence_xml", "xcap_table", "xcap")
modparam("presence_xml", "pidf_manipulation", 0)
modparam("presence_xml", "integrated_xcap_server", 1)
modparam("presence", "presentity_table", "presentity")
modparam("presence", "active_watchers_table",
"active_watchers")
modparam("presence", "watchers_table", "watchers")
modparam("presence", "clean_period", 100)
modparam("presence", "server_address",
"sip:192.168.72.128:5060")
loadmodule "imc.so"
loadmodule "mi_xmlrpc.so"
modparam("mi_xmlrpc", "log_file",
"/var/log/kamailio-xmlrpc.log")
modparam("mi_xmlrpc", "port", 8080)
loadmodule "pua.so"
loadmodule "rls.so"
modparam("rls", "integrated_xcap_server", 1)
modparam("rls", "xcap_root",
"http://192.168.72.128/xcap-root:8080")
modparam("rls", "rls_event", "presence")
modparam("rls", "to_presence_code", 10)
loadmodule "xcap_client.so"
modparam("xcap_client", "xcap_table", "xcap")
modparam("xcap_client", "query_period", 50)
modparam("presence|presence_xml|imc|pua\rls", "db_url",
"mysql://myuserid:mypassword@localhost/kamailio")
...........
route[0] {
....
if (is_method("NOTIFY")) {
pua_update_contact();
route(4);
} else if (is_method("PUBLISH|SUBSCRIBE")) {
route(5);
}
route[5] {
if (!t_newtran()) {
sl_reply_error();
exit;
};
if(is_method("PUBLISH")) {
handle_publish();
t_release();
} else if( is_method("SUBSCRIBE")) {
$var(ret_code) = rls_handle_subscribe();
if($var(ret_code)==10) {
handle_subscribe();
}
t_release();
} else if(is_method("NOTIFY")) {
rls_handle_notify();
xlog("L_INFO", "DBG: RLS handle_notify()");
}
exit;
}
------------------------------------------------------------------------
Did I missed anything ?
Thanks,
David Loh