[OpenSIPS-Users] MySQL Prepared Error

Bogdan-Andrei Iancu bogdan at voice-system.ro
Thu Feb 5 10:06:52 CET 2009


Hi Ibrahim,

Could you post (or send privately) the entire opensips log, please? 

Again, have you fully updated from SVN (complete tree?)

Thanks and 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