[Users] MySql accounting in OpenSer 1.0

[Bogdan-Andrei Iancu]

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 at newbridges.nl <mailto:lathouder at NewBridges.nl>) 	
>
>  
>
>
> <http://www.databadge.net/igv2005/reg/?link=61dba23572386211a324>
>
>  
>
>  
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Users mailing list
>Users at openser.org
>http://openser.org/cgi-bin/mailman/listinfo/users
>  
>