[OpenSIPS-Users] MySQL Prepared Error

Bogdan-Andrei Iancu bogdan at voice-system.ro
Thu Feb 5 13:12:42 CET 2009


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:5559050777 at 192.168.2.240:5466
> | sip:195.174.30.145:61129 | NULL | 2009-02-03 16:15:28 | 0.00 |
> 9c49ba35-6abd360f at 192.168.2.240 | 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
> <bogdan at voice-system.ro> 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
>>> <bogdan at voice-system.ro> 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
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>
>>>>>
>>>>>
>>>>>           
>>>>         
>>>       
>>     
>
>   




More information about the Users mailing list