<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'>
<font class="Apple-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="Apple-tab-span" style="white-space:pre">                </span>&nbsp; &nbsp;113 Connect &nbsp; root@localhost on opensips_db</div><div style="font-family: Tahoma; font-size: 10pt; ">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 113 Prepare &nbsp; select password from subscriber where username=? AND domain=?</div><div style="font-family: Tahoma; font-size: 10pt; ">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 113 Execute &nbsp; 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="Apple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="Apple-style-span" face="Tahoma" size="2">Sep 16 08:53:18 oepnsips /usr/sbin/opensips[11530]: INFO:db_mysql:re_init_statement: &nbsp;query &nbsp;is &lt;insert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,time,from_uri,to_uri ) values (?,?,?,?,?,?,?,?,?)&gt;, ptr=(nil)</font></div><div><font class="Apple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="Apple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="Apple-style-span" face="Tahoma" size="2">Why this happens?</font></div><div><font class="Apple-style-span" face="Tahoma" size="2"><br></font></div><div><font class="Apple-style-span" face="Tahoma" size="2">This is my opensips.conf</font></div><div><font class="Apple-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="Apple-style-span" face="Tahoma" size="2"><br></font></div><br><div style="font-family: Tahoma; font-size: 10pt; "><hr id="stopSpelling">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>

  
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
    
    <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. &nbsp;That's Opensips letting you know
              it has initialized the prepared statement in the MySQL
              database. &nbsp;The ?s are part of the statement format.
              &nbsp;Depending on your config, you may see these for other
              modules in addition to acc. &nbsp;I see them a lot for dialog
              in my config after a restart. &nbsp;Once a statement has been
              initialized for each child process, you won't see them
              anymore. &nbsp;</div>
            <div><br>
            </div>
            <div>Are you sure the data isn't in the table? &nbsp;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:&nbsp;</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: &nbsp;query &nbsp;is
                            &lt;insert into acc (method,from</font>_tag,to_tag,callid,sip_code,sip_reason,time,from_uri,to_uri
                          ) values (?,?,?,?,?,?,?,?,?)&gt;, 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></body>
</html>