Re: Logging CDRs into MySQL
Ivan,
Thanks for your response. FreeRadisu is able to connect to the MySQL database
and write into the radacct table. However I am not ablle to set things up for
logging the VSA attributes into the database. How to edit the dialup.conf for
the VSA value logging. I edited the dialup.conf with the inset query for the
VSAs as follows:
accounting_start_query = " \
INSERT INTO ${acct_table1} \
(IPC_SESSION_ID, IPC_SERVICE_TYPE, IPC_SESSION_SEQUENCE_NUM, \
IPC_POS_TRANSPORT_PROTOCOL, IPC_POS_TRANSPORT_PORT,
IPC_POS_TRANSPORT_IP, \ ...
VALUES \
('%{IPC-Session-Id}', '%{IPC-Service-Type}', \
'%{IPC-Session-Sequence-Num}', \
'%{IPC-Pos-Transport-Protocol}', '%{IPC-Pos-Transport-Port}',
'%{IPC-Pos-Transport-IP}', \
..
I removes all other queries fom the dialup.conf and just have the above one but
to no avail.
Please suggest.
Regards,
Prabhu
On Thu, 06 Nov 2008 prabhu s sugumaran wrote :
>
>
>Hi,
>
>I am facing difficulties in integrating MySQL and FreeRadius for the
>accounting. I have setup the mysql with a database named 'radius'. I have also
>defined a table 'rt_cdr1' which is to be used to store the CDRs that come in
>the accounting request. I add the following statements in radiusd.conf.
>
>---
>
>accounting{
>detail
>sql
>}
>--
>
>Also in the mysql.conf I have the following :
>
>acct_table1="rt_cdr1"
>acct_table2="rt_cdr1"
>
>Is their any other configurations that needs to be done to make the free
>radius pump the accounting request into databas?..I serarched to no avail .
>
>The following is the output of 'radiusd -X -f' :
>
>
>
>[EMAIL PROTECTED] freeradius]#
>[EMAIL PROTECTED] freeradius]# /usr/local/sbin/radiusd -X -f
>FreeRADIUS Version 2.1.1, for host i686-pc-linux-gnu, built on Nov 5 2008 at
>14:56:50
>Copyright (C) 1999-2008 The FreeRADIUS server project and contributors.
>There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
>PARTICULAR PURPOSE.
>You may redistribute copies of FreeRADIUS under the terms of the
>GNU General Public License v2.
>Starting - reading configuration files ...
>including configuration file /usr/local/etc/raddb/radiusd.conf
>including configuration file /usr/local/etc/raddb/proxy.conf
>including configuration file /usr/local/etc/raddb/clients.conf
>including files in directory /usr/local/etc/raddb/modules/
>including configuration file /usr/local/etc/raddb/modules/wimax
>including configuration file /usr/local/etc/raddb/modules/detail.example.com
>including configuration file /usr/local/etc/raddb/modules/radutmp
>including configuration file /usr/local/etc/raddb/modules/etc_group
>including configuration file /usr/local/etc/raddb/modules/chap
>including configuration file /usr/local/etc/raddb/modules/attr_rewrite
>including configuration file /usr/local/etc/raddb/modules/mac2ip
>including configuration file /usr/local/etc/raddb/modules/inner-eap
>including configuration file /usr/local/etc/raddb/modules/ippool
>including configuration file /usr/local/etc/raddb/modules/logintime
>including configuration file /usr/local/etc/raddb/modules/attr_filter
>including configuration file /usr/local/etc/raddb/modules/counter
>including configuration file /usr/local/etc/raddb/modules/digest
>including configuration file /usr/local/etc/raddb/modules/always
>including configuration file /usr/local/etc/raddb/modules/smbpasswd
>including configuration file /usr/local/etc/raddb/modules/checkval
>including configuration file /usr/local/etc/raddb/modules/passwd
>including configuration file /usr/local/etc/raddb/modules/sradutmp
>including configuration file /usr/local/etc/raddb/modules/krb5
>including configuration file /usr/local/etc/raddb/modules/mschap
>including configuration file /usr/local/etc/raddb/modules/detail.log
>including configuration file /usr/local/etc/raddb/modules/linelog
>including configuration file /usr/local/etc/raddb/modules/preprocess
>including configuration file /usr/local/etc/raddb/modules/detail
>including configuration file /usr/local/etc/raddb/modules/realm
>including configuration file /usr/local/etc/raddb/modules/expr
>including configuration file /usr/local/etc/raddb/modules/ldap
>including configuration file /usr/local/etc/raddb/modules/files
>including configuration file /usr/local/etc/raddb/modules/acct_unique
>including configuration file /usr/local/etc/raddb/modules/echo
>including configuration file /usr/local/etc/raddb/modules/sql_log
>including configuration file /usr/local/etc/raddb/modules/mac2vlan
>including configuration file /usr/local/etc/raddb/module
Logging CDRs into MySQL
Hi,
I am facing difficulties in integrating MySQL and FreeRadius for the
accounting. I have setup the mysql with a database named 'radius'. I have also
defined a table 'rt_cdr1' which is to be used to store the CDRs that come in
the accounting request. I add the following statements in radiusd.conf.
---
accounting{
detail
sql
}
--
Also in the mysql.conf I have the following :
acct_table1="rt_cdr1"
acct_table2="rt_cdr1"
Is their any other configurations that needs to be done to make the free radius
pump the accounting request into databas?..I serarched to no avail .
The following is the output of 'radiusd -X -f' :
[EMAIL PROTECTED] freeradius]#
[EMAIL PROTECTED] freeradius]# /usr/local/sbin/radiusd -X -f
FreeRADIUS Version 2.1.1, for host i686-pc-linux-gnu, built on Nov 5 2008 at
14:56:50
Copyright (C) 1999-2008 The FreeRADIUS server project and contributors.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
You may redistribute copies of FreeRADIUS under the terms of the
GNU General Public License v2.
Starting - reading configuration files ...
including configuration file /usr/local/etc/raddb/radiusd.conf
including configuration file /usr/local/etc/raddb/proxy.conf
including configuration file /usr/local/etc/raddb/clients.conf
including files in directory /usr/local/etc/raddb/modules/
including configuration file /usr/local/etc/raddb/modules/wimax
including configuration file /usr/local/etc/raddb/modules/detail.example.com
including configuration file /usr/local/etc/raddb/modules/radutmp
including configuration file /usr/local/etc/raddb/modules/etc_group
including configuration file /usr/local/etc/raddb/modules/chap
including configuration file /usr/local/etc/raddb/modules/attr_rewrite
including configuration file /usr/local/etc/raddb/modules/mac2ip
including configuration file /usr/local/etc/raddb/modules/inner-eap
including configuration file /usr/local/etc/raddb/modules/ippool
including configuration file /usr/local/etc/raddb/modules/logintime
including configuration file /usr/local/etc/raddb/modules/attr_filter
including configuration file /usr/local/etc/raddb/modules/counter
including configuration file /usr/local/etc/raddb/modules/digest
including configuration file /usr/local/etc/raddb/modules/always
including configuration file /usr/local/etc/raddb/modules/smbpasswd
including configuration file /usr/local/etc/raddb/modules/checkval
including configuration file /usr/local/etc/raddb/modules/passwd
including configuration file /usr/local/etc/raddb/modules/sradutmp
including configuration file /usr/local/etc/raddb/modules/krb5
including configuration file /usr/local/etc/raddb/modules/mschap
including configuration file /usr/local/etc/raddb/modules/detail.log
including configuration file /usr/local/etc/raddb/modules/linelog
including configuration file /usr/local/etc/raddb/modules/preprocess
including configuration file /usr/local/etc/raddb/modules/detail
including configuration file /usr/local/etc/raddb/modules/realm
including configuration file /usr/local/etc/raddb/modules/expr
including configuration file /usr/local/etc/raddb/modules/ldap
including configuration file /usr/local/etc/raddb/modules/files
including configuration file /usr/local/etc/raddb/modules/acct_unique
including configuration file /usr/local/etc/raddb/modules/echo
including configuration file /usr/local/etc/raddb/modules/sql_log
including configuration file /usr/local/etc/raddb/modules/mac2vlan
including configuration file /usr/local/etc/raddb/modules/pap
including configuration file /usr/local/etc/raddb/modules/policy
including configuration file /usr/local/etc/raddb/modules/unix
including configuration file /usr/local/etc/raddb/modules/pam
including configuration file /usr/local/etc/raddb/modules/exec
including configuration file /usr/local/etc/raddb/modules/expiration
including configuration file /usr/local/etc/raddb/eap.conf
including configuration file /usr/local/etc/raddb/sql.conf
including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf
including configuration file /usr/local/etc/raddb/sql/mysql/counter.conf
including configuration file /usr/local/etc/raddb/policy.conf
including files in directory /usr/local/etc/raddb/sites-enabled/
including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel
including configuration file /usr/local/etc/raddb/sites-enabled/default
including dictionary file /usr/local/etc/raddb/dictionary
main {
prefix = "/usr/local"
localstatedir = "/usr/local/var"
logdir = "/usr/local/var/log/radius"
libdir = "/usr/local/lib"
radacctdir = "/usr/local/var/log/radius/radacct"
hostname_lookups = no
max_request_time = 30
cleanup_delay = 5
max_requests = 1024
allow_core_dumps = no
pidfile = "/usr/local/var/run/radiusd/radiusd.pid"
checkrad = "/usr/local/sbin/checkrad"
debug_level = 0
proxy_request
