I can resolve it. I have an missing field (extra db) in mysql table. Thanks a lot!! Best Regards,Fede
From: [email protected] To: [email protected] Date: Fri, 16 Sep 2011 12:54:47 +0000 Subject: Re: [OpenSIPS-Users] ACC Module Problem Thanks for you reply. In my mysql log, i can see opensips query for registration phone, example: 113 Connect root@localhost on opensips_db 113 Prepare select password from subscriber where username=? AND domain=? 113 Execute select password from subscriber where username='TE003' AND domain='xxx.xxx.xxx.xxx' Although I can see ACC query in opensips logs, i don't view this query in mysql.log : Sep 16 08:53:18 oepnsips /usr/sbin/opensips[11530]: 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 this happens? This is my opensips.conf 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_extra","from_uri=$fu; to_uri=$tu")modparam("acc", "db_url","mysql://root:xxxxxx@localhost/opensips_db")modparam("acc", "db_table_acc", "acc") Thanks a lot!!Fede Date: Fri, 16 Sep 2011 11:30:40 +0300 From: [email protected] To: [email protected] Subject: Re: [OpenSIPS-Users] ACC Module Problem 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: [email protected] To: [email protected] 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 [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
