[OpenSIPS-Users] MySQL Prepared Error

ibrahim tunali ibrahimtunali at gmail.com
Tue Feb 3 16:25:03 CET 2009 

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