<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
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 class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4</a> ID=443166422] F=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4</a>
T=<a 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 class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4</a> ID=443166422] F=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4</a>
T=<a 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 class="moz-txt-link-freetext" href="sip:1.2.3.4">sip:1.2.3.4</a> ID=443166422] F=<a class="moz-txt-link-freetext" href="sip:+86xxxxx@1.2.3.4">sip:+86xxxxx@1.2.3.4</a>
T=<a 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 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>
</body>
</html>