<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
I can resolve it. <div>I have an missing field (extra db) in mysql table.</div><div><br></div><div>Thanks a lot!!</div><div><br></div><div>Best Regards,</div><div>Fede<br><br><div><hr id="stopSpelling">From: fechebsd@hotmail.com<br>To: users@lists.opensips.org<br>Date: Fri, 16 Sep 2011 12:54:47 +0000<br>Subject: Re: [OpenSIPS-Users] ACC Module Problem<br><br>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<style>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
</style>
<div dir="ltr">
<font class="ecxApple-style-span" face="Tahoma" size="2">Thanks for you reply.</font><div style="font-family:Tahoma;font-size:10pt"><br></div><div style="font-family:Tahoma;font-size:10pt">In my mysql log, i can see opensips query for registration phone, example:</div><div><div style="font-family:Tahoma;font-size:10pt"><span class="ecxApple-tab-span" style="white-space:pre"> </span> 113 Connect root@localhost on opensips_db</div><div style="font-family:Tahoma;font-size:10pt"> 113 Prepare select password from subscriber where username=? AND domain=?</div><div style="font-family:Tahoma;font-size:10pt"> 113 Execute select password from subscriber where username='TE003' AND domain='xxx.xxx.xxx.xxx'</div><div style="font-family:Tahoma;font-size:10pt"><br></div><div style="font-family:Tahoma;font-size:10pt">Although I can see ACC query in opensips logs, i don't view this query in mysql.log :</div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2">Sep 16 08:53:18 oepnsips /usr/sbin/opensips[11530]: INFO:db_mysql:re_init_statement: query is <insert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,time,from_uri,to_uri ) values (?,?,?,?,?,?,?,?,?)>, ptr=(nil)</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2">Why this happens?</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2">This is my opensips.conf</font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><div><br></div><div>modparam("acc", "early_media", 1)</div><div>modparam("acc", "report_ack", 1)</div><div>modparam("acc", "report_cancels", 1)</div><div>modparam("acc", "detect_direction", 0)</div><div>modparam("acc", "failed_transaction_flag", 3)</div><div>modparam("acc", "log_flag", 1)</div><div>modparam("acc", "log_missed_flag", 2)</div><div>modparam("acc", "db_flag", 1)</div><div>modparam("acc", "db_missed_flag", 2)</div><div>modparam("acc", "db_extra","from_uri=$fu; to_uri=$tu")</div><div>modparam("acc", "db_url","mysql://root:xxxxxx@localhost/opensips_db")</div><div>modparam("acc", "db_table_acc", "acc")</div><div><br></div><div><br></div><div>Thanks a lot!!</div><div>Fede</div><div><br></div><div><br></div></font></div><div><font class="ecxApple-style-span" face="Tahoma" size="2"><br></font></div><br><div style="font-family:Tahoma;font-size:10pt"><hr id="ecxstopSpelling">Date: Fri, 16 Sep 2011 11:30:40 +0300<br>From: vladpaiu@opensips.org<br>To: users@lists.opensips.org<br>Subject: Re: [OpenSIPS-Users] ACC Module Problem<br><br>
<title></title>
Hello Federico,<br>
<br>
This is strange.. So you do not have any errors in your opensips log
?<br>
If this is the case, it means that from OpenSIPS point of view, the
query succeeded, or at least that's what the mysqlclient library
said. :) <br>
<br>
If you enable query logging within your mysql server, do you see the
query successfully reaching the server and being executed ? <br>
<br>
Regards,<br>
<pre class="ecxmoz-signature">Vlad Paiu
OpenSIPS Developer</pre>
<br>
On 09/15/2011 11:00 PM, Federico Varela wrote:
<blockquote cite="mid:DUB113-W119B05F7A2CACA42E46796FD7070@phx.gbl">
<style>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
</style>
<div dir="ltr">
Jeff, thanks for your reply.
<div>No, my acc table is empty (missed_calls table too).</div>
<div><br>
</div>
<div>My connection with mysql is true (i use loadbalancer,
registration store in MySQL).</div>
<div><br>
</div>
<div>Thanks.</div>
<div>Federico</div>
<div><br>
<div>
<hr id="ecxstopSpelling">From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:jpyle@fidelityvoice.com">jpyle@fidelityvoice.com</a><br>
To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
Date: Thu, 15 Sep 2011 15:13:06 -0400<br>
Subject: Re: [OpenSIPS-Users] ACC Module Problem<br>
<br>
Hi Federico,
<div><br>
</div>
<div>That's not an error. That's Opensips letting you know
it has initialized the prepared statement in the MySQL
database. The ?s are part of the statement format.
Depending on your config, you may see these for other
modules in addition to acc. I see them a lot for dialog
in my config after a restart. Once a statement has been
initialized for each child process, you won't see them
anymore. </div>
<div><br>
</div>
<div>Are you sure the data isn't in the table? If it isn't,
there isn't any indication here as to why.</div>
<div><br>
</div>
<div><br>
</div>
<div>- Jeff</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
<div>
<div>On Sep 15, 2011, at 3:07 PM, Federico Varela wrote:</div>
<br class="ecxApple-interchange-newline">
<blockquote><span class="ecxApple-style-span" style="border-collapse:separate;font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;font-size:medium">
<div class="ecxhmmessage" style="font-size:10pt;font-family:Tahoma">
<div dir="ltr"><font class="ecxApple-style-span" face="Tahoma" size="2">Hello:</font>
<div style="font-family:Tahoma;font-size:10pt">My name is Federico. I have a problem
with Acc Module in Opensips 1.6.</div>
<div><font class="ecxApple-style-span" face="Tahoma" size="2">I can complete a call
perfectly, but opensips dont insert data in
mysql acc table.</font></div>
<div><font class="ecxApple-style-span" face="Tahoma" size="2"><br>
</font></div>
<div><font class="ecxApple-style-span" face="Tahoma" size="2">My configuration is
this:</font></div>
<div><font class="ecxApple-style-span" face="Tahoma" size="2"><br>
</font></div>
<div><font class="ecxApple-style-span" face="Tahoma" size="2">
<div>modparam("acc", "early_media", 1)</div>
<div>modparam("acc", "report_ack", 1)</div>
<div>modparam("acc", "report_cancels", 1)</div>
<div>modparam("acc", "detect_direction", 0)</div>
<div>modparam("acc",
"failed_transaction_flag", 3)</div>
<div>modparam("acc", "log_flag", 1)</div>
<div>modparam("acc", "log_missed_flag", 2)</div>
<div>modparam("acc", "db_flag", 1)</div>
<div>modparam("acc", "db_missed_flag", 2)</div>
<div>modparam("acc", "db_url","<a target="_blank">mysql://root:xxxx@localhost/opensips_db</a>")</div>
<div>modparam("acc",
"db_extra","from_uri=$fu; to_uri=$tu")</div>
<div><br>
</div>
<div>And, my log is this: </div>
<div><br>
</div>
</font></div>
<div><font class="ecxApple-style-span" face="Tahoma" size="2">Sep 15 16:05:20
oepnsips /usr/sbin/opensips[6663]:
INFO:db_mysql:re_init_statement: query is
<insert into acc (method,from</font>_tag,to_tag,callid,sip_code,sip_reason,time,from_uri,to_uri
) values (?,?,?,?,?,?,?,?,?)>, ptr=(nil)</div>
<div><br>
</div>
<div>Why in this SQL string, the values are
"?"..</div>
<div><br>
</div>
<div>Thanks a lot!!!</div>
<div><br>
</div>
<div>Federico</div>
</div>
</div>
</span></blockquote>
</div>
<br>
</div>
<br>
_______________________________________________
Users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></div>
</div>
</div>
<pre><fieldset class="ecxmimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users</div></div> </div>
<br>_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users</div></div> </div></body>
</html>