Re: [OpenSER-Users] Log errors when processing a contact list with RLSmodule

Hi Anca, I fixed rls_presentity table and changed openser.cfg so that it works according the behaviour you described. Now the database error does not appear anymore, but changes in the presence status of group members are still not notified to the user subscribed to that group. Also, I keep having those strange notifies towards directions belonging to the xmpp domain, and some tables (active_watchers, pua) keep growing with tens of similar entries that maybe should overwrite previous ones. Attached you can see the part of the log that is repeated when resending those notifies over and over, with some errors in it. I attach my openser.cfg too. Please, give it a look and tell me if there is still something wrong in it that could explain all this. I had problems getting presence modules from svn. First I updated just the presence module and built all modules again, but when I started openser there were some names in presence module it could not resolve or something like that. To avoid incompatibility problems I downloaded and compiled everything from svn. I also created openser schema again with the new scripts, but some errors appear when handling subscribe methods, you can see them attached too. It starts with the following one: Apr 21 11:22:07 comm ./openser[30276]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown column 'str_doc_col' in 'field list' Thanks and regards, Pablo -----Mensaje original----- De: Anca Vamanu [mailto:anca@voice-system.ro] Enviado el: viernes, 18 de abril de 2008 16:45 Para: Pablo Guijarro Enríquez CC: users(a)lists.openser.org Asunto: Re: [OpenSER-Users] Log errors when processing a contact list with RLSmodule Hi Pablo, There was a copy paste mistake in rls_presentity table script that wrongly set update column as unique. I have fixed that . Moreover, while testing xmpp presence gateway myself, I found a bug in presence. It affected notifications for presence.winfo sent immediately after receiving a Subscribe for presence.winfo and when the fallback2db parameter was not set. It was quite a old bug, also found in 1.3 branch. Thank you for these two. So, please update to the svn version of the presence modules, or apply the small patch. As for the retransmissions of the Notify please make sure that 'pua_xmpp_notify' is called on it. As an important note, the Notifies for winfo that are for the pua_xmpp module do not have the 'xmpp-gw' domain in the R-URI, but the servers address. And, I have noticed that you use RLS also. RLS should not handle Notifies for presence.winfo, but only for presence. And even more, it should not handle those triggered and expected by pua_xmpp. Thanks and regards, Anca Vamanu Pablo Guijarro Enríquez wrote: published <1208448754.sip:group.354354.contacts@openser.domain.388800503>;boundary=eU3 <1208448754.sip:group.354354.contacts@openser.domain.388800503> both with