Hello Federico,
This is strange.. So you do not have any errors in your opensips log ?
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. :)
If you enable query logging within your mysql server, do you see the
query successfully reaching the server and being executed ?
Regards,
Vlad Paiu
OpenSIPS Developer
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: jp...@fidelityvoice.com
To: users@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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
