[OpenSIPS-Users] ACC Module Problem

Fri Sep 16 15:49:29 CEST 2011

I can resolve it. I have an missing field (extra db) in mysql table.
Thanks a lot!!
Best Regards,Fede

From: fechebsd at hotmail.com
To: users at lists.opensips.org
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 at 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: vladpaiu at opensips.org
To: users at lists.opensips.org
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: 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

_______________________________________________
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/20110916/f14a5655/attachment.htm>