[OpenSIPS-Users] Simple ACC test with MySQL

David Santiago david.santiago at almiralabs.com
Wed Nov 10 12:16:30 CET 2010


Modified... and still no records in the ACC table nor errors in the syslog
(although I have set the debug level to 9).

On Wed, Nov 10, 2010 at 10:52 AM, David Santiago <
david.santiago at almiralabs.com> wrote:

> Hum... you're right, I'll modify it; although no errors appear in the
> syslog...
>
>
> On Fri, Nov 5, 2010 at 7:29 PM, Brett Nemeroff <brett at nemeroff.com> wrote:
>
>> David,
>> 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?
>> -Brett
>>
>>
>> On Fri, Nov 5, 2010 at 11:48 AM, David Santiago <
>> david.santiago at almiralabs.com> wrote:
>>
>>>  Hi,
>>>
>>> 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.
>>>
>>> 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):
>>>
>>> ...
>>> loadmodule "db_mysql.so"
>>> ...
>>> /* uncomment the following lines to enable DB accounting also */
>>> modparam("acc", "db_flag", 1)
>>> modparam("acc", "db_missed_flag", 2)
>>> modparam("acc", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")
>>> #Pointer to the DB
>>> modparam("acc", "db_extra", "from_uri=$fu; to_uri=$tu") #Extra data
>>> ...
>>>
>>> I have also modified the ACC table in order to add those fields specified
>>> in the last modparam instruction shown above:
>>>
>>> mysql -u root
>>> USE OPENSIPS;
>>> ALTER TABLE `acc` ADD `caller_id` CHAR( 64 ) NOT NULL ;
>>> ALTER TABLE `acc` ADD `callee_id` CHAR( 64 ) NOT NULL ;
>>>
>>> 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.
>>>
>>> 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.
>>>
>>> Am I wrong assuming that the ACC module is supposed to populate that
>>> table with the setting of flags upon INVITE and BYE requests?
>>>
>>>
>>> Regards,
>>> David
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20101110/d8f1e512/attachment.htm>


More information about the Users mailing list