[OpenSIPS-Users] INFO:db_mysql:re_init_statement: query is <select password, rpid from subscriber where username=?>, ptr=(nil)

[Vlad Paiu]

Hello,

This is not an ERROR, but an INFO message, saying that internally, 
OpenSIPS has re-initialised the prepared statement used for querying the 
DB. No need to worry about this.

Regards,

Vlad Paiu
OpenSIPS Developer


On 09/23/2011 10:21 AM, vivid333 wrote:
> hello:
>
>             A user register/de-register from Opensips, sometimes the 
> log output "INFO:db_mysql:re_init_statement:  query  is <select 
> password,rpid from subscriber where username=?>, ptr=(nil)" . I really 
> don't know what cause the error.
>
> ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
> Sep 23 10:57:26 sipserver2 /sbin/opensips[9570]: INFO:core:buf_init: 
> initializing...
> Sep 23 10:57:26 sipserver2 /sbin/opensips[9570]: New request - 
> [M=REGISTER RURI=sip:1.2.3.4 ID=443166422]  F=sip:+86xxxxx at 1.2.3.4 
> T=sip:+86xxxxx at 1.2.3.4 From_IP=114.247.10.73
> Sep 23 10:57:26 sipserver2 /sbin/opensips[9571]: INFO:core:buf_init: 
> initializing...
> Sep 23 10:57:26 sipserver2 /sbin/opensips[9571]: New request - 
> [M=REGISTER RURI=sip:1.2.3.4 ID=443166422]  F=sip:+86xxxxx at 1.2.3.4 
> T=sip:+86xxxxx at 1.2.3.4 From_IP=114.247.10.73
> Sep 23 10:57:26 sipserver2 /sbin/opensips[9573]: INFO:core:buf_init: 
> initializing...
> Sep 23 10:57:26 sipserver2 /sbin/opensips[9573]: New request - 
> [M=REGISTER RURI=sip:1.2.3.4 ID=443166422]  F=sip:+86xxxxx at 1.2.3.4 
> T=sip:+86xxxxx at 1.2.3.4 From_IP=114.247.10.73
> Sep 23 10:57:26 sipserver2 
> /sbin/opensips[9573]:*INFO:db_mysql:re_init_statement:  query  is 
> <select password,rpid from subscriber where username=?>, ptr=(nil)*
> Sep 23 10:57:26 sipserver2 /sbin/opensips[9573]: In Public IP.   
> Contact Value:<sip:+86xxxxx at 114.247.10.73:12460>
> Sep 23 10:57:26 sipserver2 /sbin/opensips[9573]: Registration 
> successful contact expire=<null> ;  header expire = 360
> /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 
>
>
>
>
>  Any help would be appreciated, thanks for your helps in advance.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110923/231bb236/attachment.htm>