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

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

vivid333
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=<a class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4 ID=443166422]  F=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4 T=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@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=<a class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4 ID=443166422]  F=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4 T=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@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=<a class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4 ID=443166422]  F=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4 T=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@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:<a class="moz-txt-link-rfc2396E" href="sip:+86xxxxx@114.247.10.73:12460"><sip:+86xxxxx@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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4 ID=443166422]  F=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4 T=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@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=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4 ID=443166422]  F=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4 T=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@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=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4 ID=443166422]  F=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4 T=<a moz-do-not-send="true" class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@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:<a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="sip:+86xxxxx@114.247.10.73:12460"><sip:+86xxxxx@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 [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users