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

[Daniel-Constantin Mierla]

Hello,

there was a typo in the column name. Please take the latest version from 
SVN on branch 1.4 and try again.

You need a dedicated xcap server to communicate from your eyebeam -- see 
openxcap. Kamailio has not a integrated implementation xcap server, it 
is about either should act as xcap client to connect to a xcap server or 
pull data from database.

Cheers,
Daniel


On 08/13/08 20:35, David Loh wrote:
> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>   

-- 
Daniel-Constantin Mierla
http://www.asipto.com