[OpenSIPS-Users] MySQL Prepared Error

[Bogdan-Andrei Iancu]

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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>