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