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

[David Loh]

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 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080814/5ce015fb/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3241 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080814/5ce015fb/attachment.bin>