Hi Visu, There was a bug in presence module - of not setting which table to use before the update query - this was noticeable only when using sphere_enable since the processing of sphere changed the table. Since this feature is not that much used, this problem was not noticed until now . I will fix it in the svn. Please update from svn branch 1.5 or trunk if you use trunk.
Thanks and regards, Anca Visu.M wrote: > Team, > > I am trying to use sphere based presence rules. > openXCAP is my xcap server. sipsimpleclient is the client. > (I set the enable_sphere_check parameter in server). > I am getting the following error, when publishing from the client. > My PA with RLS, openXCAP and client are co-located in the same machine. > > Mar 31 11:53:34 [25349] ERROR:db_mysql:db_mysql_submit_query: driver > error on query: Unknown column 'domain' in 'where clause' > Mar 31 11:53:34 [25349] ERROR:core:db_do_update: error while > submitting query > > Mar 31 11:53:34 [25349] ERROR:presence:update_presentity: updating > published info in database > Mar 31 11:53:34 [25349] ERROR:presence:handle_publish: when updating > presentity > > Follow the links for complete log and my config file. > Please let me know, where the error is. > Log file : http://www.cc.gatech.edu/~vmahali1/logs/log-opensips.txt > <http://www.cc.gatech.edu/%7Evmahali1/logs/log-opensips.txt> > Config file : http://www.cc.gatech.edu/~vmahali1/logs/opensips.cfg > <http://www.cc.gatech.edu/%7Evmahali1/logs/opensips.cfg> > Presence rules for cnn: > http://www.cc.gatech.edu/~vmahali1/logs/pres-rules-sphere.xml > <http://www.cc.gatech.edu/%7Evmahali1/logs/pres-rules-sphere.xml> > published information for cnn: > http://www.cc.gatech.edu/~vmahali1/logs/published-info-cnn.txt > <http://www.cc.gatech.edu/%7Evmahali1/logs/published-info-cnn.txt> > Thanks in advance, > Visu M > ------------------------------------------------------------------------ > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
