[OpenSIPS-Users] error while using sphere parameter in presence rules.

[Anca Vamanu]

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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>