Hum... you're right, I'll modify it; although no errors appear in the syslog...<br><br><div class="gmail_quote">On Fri, Nov 5, 2010 at 7:29 PM, Brett Nemeroff <span dir="ltr"><<a href="mailto:brett@nemeroff.com">brett@nemeroff.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">David,<div>If you bump up the debug on your server and make a call, it'll display a nice message that will indicate that it's missing fields. Have you tried that?<br>
-Brett</div><div><br><br><div class="gmail_quote"><div><div></div><div class="h5">
On Fri, Nov 5, 2010 at 11:48 AM, David Santiago <span dir="ltr"><<a href="mailto:david.santiago@almiralabs.com" target="_blank">david.santiago@almiralabs.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div><div></div><div class="h5">
Hi,<br><br>I'm trying to generate CDRs in an OpenSIPS test server. I have checked the stored procedure that comes with opensips-cp to perform this task and have noticed that queries the ACC table in order to populate the CDRS table.<br>
<br>Well, first things first. I have used the basic opensips.cfg.sample configuration (I will not copy it entirely here), adding the changes required to use mysql with the acc module (after having compiled with mysql support, of course):<br>
<br>...<br>loadmodule "db_mysql.so"<br>...<br>/* uncomment the following lines to enable DB accounting also */<br>modparam("acc", "db_flag", 1)<br>modparam("acc", "db_missed_flag", 2)<br>
modparam("acc", "db_url", "mysql://opensips:opensipsrw@localhost/opensips") #Pointer to the DB<br>modparam("acc", "db_extra", "from_uri=$fu; to_uri=$tu") #Extra data<br>
...<br><br>I have also modified the ACC table in order to add those fields specified in the last modparam instruction shown above:<br><br>mysql -u root<br>USE OPENSIPS;<br>ALTER TABLE `acc` ADD `caller_id` CHAR( 64 ) NOT NULL ;<br>
ALTER TABLE `acc` ADD `callee_id` CHAR( 64 ) NOT NULL ;<br><br>After those changes, I'm calling from a voip provider that is linked to the OpenSIPS test server, in order to send it an INVITE, which is being received as I have been able to debug with tcpdump.<br>
<br>BUT... no data is being inserted in the ACC table. I can successfully log into the database with the credentials used in the "db_url" parameter.<br><br>Am I wrong assuming that the ACC module is supposed to populate that table with the setting of flags upon INVITE and BYE requests?<br>
<br><br>Regards,<br><font color="#888888">David<br>
</font><br></div></div><div class="im">_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></div></blockquote></div><br></div>
</blockquote></div><br>