Hi Ibrahim, I found the bug - please update and test again.
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
