HI Hilco,

even if the DB support is by default compiled, it is not also enabled - you need to set the db_url parameter is enable it. I guess is an documentation error - its default value is NULL.

regards, bogdan

Hilco de Lathouder wrote:

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 mailto:lathouder@NewBridges.nl)

http://www.databadge.net/igv2005/reg/?link=61dba23572386211a324

---

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users