Hi Ibrahim, I know, there was bug which is now fixed on the SVN....please update and test.
Regards, Bogdan ibrahim tunali wrote: > Hi Bogdan, > > I just have rebuild from SVN and previous mentioned problem seems to > solved. but this time it do not update correctly location table with > new expire timestamp. You can find detailed dump log at below. I > guess, it is not fill the "where" clause values on update query. > > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location > set > expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=? > where username=? AND contact=? AND callid=? AND domain=?| > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: prepared statement > successfully prepared > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: prepared statement > successfully set... > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement > run > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19; > buf=2009-02-05 12:35:13; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10; > buf=0.00 ; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=1; buf=2; > is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0; > is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64; > is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=25; > buf=Sipura/SPA1001-3.1.8(SEc); is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24; > buf=sip:195.174.30.145:57009; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4; > buf=NULL; is_null=1 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=23; > buf=udp:70.232.148.122:5060; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4; > buf=5183; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19; > buf=2009-02-05 11:35:13; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (11): len=19; > buf=NULL; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (12): len=10; > buf=NULL; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (13): len=1; > buf=NULL; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (14): len=1; > buf=NULL; is_null=0 > Feb 5 11:35:13 sip1 /usr/sbin/opensips[29557]: > DBG:registrar:build_contact: created Contact HF: Contact: > <sip:[email protected]:5466>;q=0;expires=3600;received="sip:195.174.30.145:57009" > > Best regards, > > Ibrahim TUNALI > > > > On Thu, Feb 5, 2009 at 11:06, Bogdan-Andrei Iancu > <[email protected]> wrote: > >> Hi Ibrahim, >> >> Could you post (or send privately) the entire opensips log, please? >> Again, have you fully updated from SVN (complete tree?) >> >> Thanks and regards, >> Bogdan >> >> ibrahim tunali wrote: >> >>> Hi Bogdan, >>> >>> Sorry for the late response. The error occurs when RE-register. >>> >>> I already register and location table row is ; >>> >>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+ >>> | id | username | domain | contact >>> | received | path | expires | q | >>> callid | cseq | last_modified | flags >>> | cflags | user_agent | socket | methods | >>> >>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+ >>> | 92 | 5559050777 | sip.nexalo.com | sip:[email protected]:5466 >>> | sip:195.174.30.145:61129 | NULL | 2009-02-03 16:15:28 | 0.00 | >>> [email protected] | 23551 | 2009-02-03 15:15:28 | 0 >>> | 64 | Linksys/SPA2100-3.3.6 | udp:81.21.166.171:5060 | 5183 | >>> >>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+ >>> >>> Error log; >>> >>> Feb 3 15:18:06 voipvserver /usr/sbin/opensips[2009]: >>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233674286) >>> Feb 3 15:18:06 voipvserver /usr/sbin/opensips[2009]: >>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 >>> (1) >>> Feb 3 15:18:06 voipvserver /usr/sbin/opensips[2009]: >>> ERROR:usrloc:db_update_ucontact: updating database failed >>> Feb 3 15:18:06 voipvserver /usr/sbin/opensips[2009]: >>> ERROR:usrloc:update_ucontact: failed to update database >>> >>> Best Regards, >>> >>> Ibrahim TUNALI >>> >>> >>> >>> >>> On Sat, Jan 31, 2009 at 08:00, Bogdan-Andrei Iancu >>> <[email protected]> wrote: >>> >>> >>>> Hi Ibrahim , >>>> >>>> It might be a stupid question, but are you 100% sure you did a complete >>>> update (for all modules and core files) from SVN ? >>>> >>>> Regards, >>>> Bogdan >>>> >>>> ibrahim tunali wrote: >>>> >>>> >>>>> Hi Bogdan, >>>>> >>>>> Thank you for quick reply. Detailed error; >>>>> >>>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]: >>>>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982) >>>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]: >>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 >>>>> (1) >>>>> >>>>> Best regards, >>>>> >>>>> Ibrahim TUNALI >>>>> >>>>> >>>>> >>>>> >>>>> On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu >>>>> <[email protected]> wrote: >>>>> >>>>> >>>>> >>>>>> Hi, >>>>>> >>>>>> This is because of the newly introduced prepared statements in mysql. >>>>>> But >>>>>> the error is in other place: >>>>>> >>>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type >>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1) >>>>>> >>>>>> I enhanced the err reporting, so please update from SVN and do get the >>>>>> log >>>>>> again. >>>>>> >>>>>> Thanks and regards, >>>>>> Bogdan >>>>>> >>>>>> >>>>>> >>>>>> ibrahim tunali wrote: >>>>>> >>>>>> >>>>>> >>>>>>> Hello, >>>>>>> >>>>>>> I got below DB error when re-registering with SVN build Opensips. I >>>>>>> would appreciate if you could check this issue >>>>>>> >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:usrloc:update_ucontact: exists callback for type= >>>>>>> UL_CONTACT_UPDATE >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location >>>>>>> set >>>>>>> >>>>>>> >>>>>>> expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=? >>>>>>> where username=? AND contact=? AND callid=? AND domain=?| >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement >>>>>>> successfully prepared >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement >>>>>>> successfully set... >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement >>>>>>> run >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19; >>>>>>> buf=2009-01-30 14:17:18; is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10; >>>>>>> buf=0.00 ; is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5; >>>>>>> buf=35581; is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0; >>>>>>> is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64; >>>>>>> is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21; >>>>>>> buf=Linksys/SPA2100-3.3.6; is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24; >>>>>>> buf=sip:193.192.116.18:64314; is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4; >>>>>>> buf=NULL; is_null=1 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22; >>>>>>> buf=udp:81.21.166.171:5060; is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4; >>>>>>> buf=5183; is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19; >>>>>>> buf=2009-01-30 13:17:18; is_null=0 >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 >>>>>>> (1) >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> ERROR:usrloc:db_update_ucontact: updating database failed >>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: >>>>>>> ERROR:usrloc:update_ucontact: failed to update database >>>>>>> >>>>>>> Regards, >>>>>>> Ibrahim TUNALI >>>>>>> >>>>>>> _______________________________________________ >>>>>>> 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
