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
