error while using sphere parameter in presence rules.

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

error while using sphere parameter in presence rules.

Visu.M
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
Config file : http://www.cc.gatech.edu/~vmahali1/logs/opensips.cfg
Presence rules for cnn: http://www.cc.gatech.edu/~vmahali1/logs/pres-rules-sphere.xml
published information for cnn: http://www.cc.gatech.edu/~vmahali1/logs/published-info-cnn.txt

Thanks in advance,
Visu M

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: error while using sphere parameter in presence rules.

Anca Vamanu-2
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
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users