[OpenSIPS-Users] ACC Module Problem

[Federico Varela]

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