I'm using Openser 1.0 and want to use MySql accounting. Looking at the documentation and Makefile, i understand that sql accounting is already built-in. When I put the following lines in my config file and start using 'setflag(1)' (e.g., after INVITE's to PSTN) , nothing happens. That is, the MySql 'acc' table stays empty. What other steps do i have to take to make openser log to the database ? I've tried using the setflag statement at other points too.

loadmodule "/usr/local/lib/openser/modules/mysql.so"
loadmodule "/usr/local/lib/openser/modules/acc.so"
#
# acc params
#
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", 1)
modparam("acc", "db_flag", 1)

# PBX traffic
if (uri=~"sip:[5-7][0-9]{2,3}@.*") {

         if (method=="INVITE"){
            log(1, "LOG: PBX call, contacting gateway...\n");
         };

         setflag(1);
         route(2);
         exit;
   };

Hilco de Lathouder

New Bridges
Voice Processing Engineers
Calandstraat 44
3316 EA Dordrecht
The Netherlands (timezone: GMT+1)
+31 (78) 6548787
(lathouder@newbridges.nl)