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

13 Aug 2008


      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