<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
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.<br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">Vlad Paiu
OpenSIPS Developer</pre>
<br>
On 09/23/2011 10:21 AM, vivid333 wrote:
<blockquote cite="mid:4E7C3374.7020400@163.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
hello:<br>
<br>
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.<br>
<br>
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////<br>
Sep 23 10:57:26 sipserver2 /sbin/opensips[9570]:
INFO:core:buf_init: initializing...<br>
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</a>
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</a>
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</a>
From_IP=114.247.10.73<br>
Sep 23 10:57:26 sipserver2 /sbin/opensips[9571]:
INFO:core:buf_init: initializing...<br>
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</a>
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</a>
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</a>
From_IP=114.247.10.73<br>
Sep 23 10:57:26 sipserver2 /sbin/opensips[9573]:
INFO:core:buf_init: initializing...<br>
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</a>
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</a>
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</a>
From_IP=114.247.10.73<br>
Sep 23 10:57:26 sipserver2 /sbin/opensips[9573]:<b><font
color="#cc0000"> INFO:db_mysql:re_init_statement: query is
<select password,rpid from subscriber where username=?>,
ptr=(nil)</font></b><br>
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></a><br>
Sep 23 10:57:26 sipserver2 /sbin/opensips[9573]: Registration
successful contact expire=<null> ; header expire = 360<br>
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<br>
<br>
<br>
<br>
Any help would be appreciated, thanks for your helps in advance.<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>