[OpenSIPS-Users] ACC Module Problem

[Federico Varela]

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 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110915/b495f77a/attachment.htm>