<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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.<br>
<br>
<br>
loadmodule "/usr/local/lib/openser/modules/mysql.so"<br>
loadmodule "/usr/local/lib/openser/modules/acc.so"<br>
#<br>
# acc params<br>
#<br>
modparam("acc", "log_level", 1)<br>
modparam("acc", "log_flag", 1)<br>
modparam("acc", "db_flag", 1)<br>
<br>
<div class="moz-signature"># PBX traffic<br>
if (uri=~<a class="moz-txt-link-rfc2396E"
href="sip:%5B5-7%5D%5B0-9%5D%7B2,3%7D@.*">"sip:[5-7][0-9]{2,3}@.*"</a>)
{<br>
<br>
if (method=="INVITE"){<br>
log(1, "LOG: PBX call, contacting gateway...\n");<br>
};<br>
<br>
setflag(1);<br>
route(2);<br>
exit;<br>
};<br>
<br>
<style>
BODY {
font-family: Arial;
font-size: 10pt;
color: 000000;
background-position: top left;
background-repeat: no-repeat;
}
</style>
<hr align="left" width="50%">
<table style="border-width: 0pt; border-collapse: collapse;" border="0"
bordercolor="#111111" cellpadding="0" cellspacing="0" width="62%">
<tbody>
<tr>
<td style="border-style: none; border-width: medium;" width="37%">
<font face="Arial" size="2"> Hilco de Lathouder<br>
<br>
New Bridges<br>
<i>Voice Processing Engineers</i><br>
</font> <font face="Arial" size="1"> Calandstraat 44<br>
3316 EA Dordrecht<br>
The Netherlands (timezone: GMT+1)<br>
+31 (78) 6548787<br>
(<a href="mailto:lathouder@NewBridges.nl">lathouder@newbridges.nl</a>)</font></td>
<td style="border-style: none; border-width: medium;" width="63%">
<p> </p>
<p><font face="Arial" size="2"><a
href="http://www.databadge.net/igv2005/reg/?link=61dba23572386211a324"
target="_blank"> <br>
</a></font> </p>
<p> </p>
</td>
</tr>
</tbody>
</table>
<p> </p>
<p> </p>
</div>
</body>
</html>