Account is not compiled with MySQL support by default. Simply uncomment the line
# DEFS+=-DSQL_ACC
and recompile again.
 
But actually, if you want to leverage Acc module for CDR, you'll get disappointed probably. In normal situation, you have no problem. The trouble is, your account information is based on the SIP message exchange through the ser proxy. If a called failed after establishment and no further message is sent by UAC and UAS. If ser proxy queries both side of a call at certain intervals, that will be ok. However, I am not sure if SIP supports such status query.
 
Younger Wang
----- Original Message -----
From: Greg Fausak
To: 'Director General: NEFACOMP' ; 'serusers'
Sent: Monday, July 07, 2003 2:38 PM
Subject: RE: [Serusers] Accounting with SER

Syslog is a standard unix facility.
Normally, in a standard linux install, you will see
a file named /var/log/messages.  That is where the
accounting information will be written.
 
You can groom this, for instance, if you want to
direct the messages from SER to a special file, using
the syslog facility.  You will need to look at the manual
page, ie:
 
man syslog.conf
 
to get some ideas about this.
 
The syslog entries are enabled with the lines:
 
...
loadmodule "/usr/ser/lib/ser/modules/acc.so"
...
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", 1 )
modparam("acc", "log_fmt", "miocfsu" )
...
 
route
{
...
                setflag(1);
                setflag(2);
...
 
}
 
I can't comment on the accounting module for mysql, but I imagine
that is described by the accounting README.txt file in the appropriate
module directory.
 
Our implementation scans the syslog files and writes into a postgres
database the call accounting stuff.
 
There is a bit of a learning curve involved with this.  However, the
programming documentation is very good and this list is great for
when you get stumped, but only then :-)
 
---greg
Greg Fausak
Addaline.com, Inc.
 
-----Original Message-----
From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Director General: NEFACOMP
Sent: Monday, July 07, 2003 3:17 PM
To: serusers
Subject: [Serusers] Accounting with SER

I would like to get more information on accounting with SER.
 
Ok, I followed the documentation about accounting but it doesn't give enough information about how to retrieve the accounting information. It just says that Reports are by DEFAULT sent to the syslog facility. Where is that syslog? How do I retreive that information? Is it possible to put that information in the MySQL database? How?
That is by DEFAULT; so, is it possible to change that default location?
 
Some gurus will realize how NEWBIE I am in the Linux World.
Please help me.
 
 
Thanks,
__________________________________
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: dg@nefacomp.net
http://www.nefacomp.net/


_______________________________________________
Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers