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

Hi again, As you know from the other thread, most pua_xmpp problems have been solved. They were caused by a wrong routing script. Now with RLS, I have almost fixed the problem about contacts presence status not being notified to the user subscribed to the list they belong. It was much the same issue: notifies from contacts in the list were not handled by RLS module, but by pua_xmpp one. However, only one first notify is sent to the user subscribed to the list, carrying contacts presence information at that point. Subsequent changes in their presence status are no notified to that user. Though the notifies generated by these changes are handled by the RLS module nothing else happens, and nothing is sent to the list watcher. What can be this due to? The table rls_watchers is empty, may it tell you something. Regards, Pablo -----Mensaje original----- De: Pablo Guijarro Enríquez [mailto:pge@moviquity.com] Enviado el: lunes, 21 de abril de 2008 16:52 Para: 'Anca Vamanu' CC: &#39;users(a)lists.openser.org&#39; Asunto: 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