[OpenSIPS-Users] ACC Module Problem

[Razvan Crainea]

Hi Federico,

Make sure that you set the corresponding flag for the SIP Requests you 
want to account.
Also, I saw you have two extra columns configured in the cfg. Have you 
added those columns into the database too? Because otherwise the mysql 
returns an error (can't find the 'from_uri' and 'to_uri') and the insert 
fails.

Regards,
Ra(zvan

On 09/15/2011 11:00 PM, Federico Varela wrote:
> Jeff, thanks for your reply.
> No, my acc table is empty (missed_calls table too).
>
> My connection with mysql is true (i use loadbalancer, registration 
> store in MySQL).
>
> Thanks.
> Federico
>
> ------------------------------------------------------------------------
> From: jpyle at fidelityvoice.com
> To: users at lists.opensips.org
> Date: Thu, 15 Sep 2011 15:13:06 -0400
> Subject: Re: [OpenSIPS-Users] ACC Module Problem
>
> Hi Federico,
>
> 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.
>
> Are you sure the data isn't in the table?  If it isn't, there isn't 
> any indication here as to why.
>
>
> - Jeff
>
>
>
> On Sep 15, 2011, at 3:07 PM, Federico Varela wrote:
>
>     Hello:
>     My name is Federico. I have a problem with Acc Module in Opensips 1.6.
>     I can complete a call perfectly, but opensips dont insert data in
>     mysql acc table.
>
>     My configuration is this:
>
>     modparam("acc", "early_media", 1)
>     modparam("acc", "report_ack", 1)
>     modparam("acc", "report_cancels", 1)
>     modparam("acc", "detect_direction", 0)
>     modparam("acc", "failed_transaction_flag", 3)
>     modparam("acc", "log_flag", 1)
>     modparam("acc", "log_missed_flag", 2)
>     modparam("acc", "db_flag", 1)
>     modparam("acc", "db_missed_flag", 2)
>     modparam("acc", "db_url","mysql://root:xxxx@localhost/opensips_db")
>     modparam("acc", "db_extra","from_uri=$fu; to_uri=$tu")
>
>     And, my log is this:
>
>     Sep 15 16:05:20 oepnsips /usr/sbin/opensips[6663]:
>     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)
>
>     Why in this SQL string, the values are "?"..
>
>     Thanks a lot!!!
>
>     Federico
>
>
>
> _______________________________________________ Users mailing list 
> Users at lists.opensips.org 
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> 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/20110915/38a06ebf/attachment-0001.htm>