Re: [Kamailio-Users] Error: driver error on query: Unknown column 'str_doc_col' in 'field list' ??

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 ------------------------------------------------------------------------ _______________________________________________ Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users