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
