Openwrt Sqlite No Write Radacct Table

Bruno D'Ambrosio brunodambrosio2011 at hotmail.it
Thu Jun 4 00:11:29 CEST 2015


Hi Mate

It is for days that I can not solve the problem in subject.

I installed "*freeradius****2.2.0-1*" with mod "*sqlite3*" system 
"*OpenWRT*" version "*attitude_adjustment****/ 12.09*" but after you 
configure the following files:

*- /Sql.conf/**
**-/Dialup.conf/**
**-/Radius.conf /**
**-//Sites/Defaulft/*

running the test:
*- 
echo*"Acct-Status-Type=Start,Acct-Session-Id=testing,NAS-IP-Address=127.0.0.1,Client-IP-Address=127.0.0.1,Acct-Unique-Session-Id=test" 
*|* radclient -c 1 -r 2 -t 1 -x 127.0.0.1 acct testing123

*The table "RADACCT" is not updated.*



Below is a small code query written by me, to check a evenutale writing:
- *accounting_start_query = "INSERT INTO radacct (radacctid, 
acctsessionid, acctuniqueid, nasipaddress) \**
**           values ('18', 'testing', '5debd18abc4f9899', '127.0.0.1');"*



Here's the code of the original query file "Diaulp.conf" (MySQL):
*- accounting_start_query = " \**
**          INSERT INTO ${acct_table1} \**
**            (acctsessionid,    acctuniqueid,     username, \**
**             realm,            nasipaddress,     nasportid, \**
**             nasporttype,      acctstarttime, acctstoptime, \**
**             acctsessiontime,  acctauthentic, connectinfo_start, \**
**             connectinfo_stop, acctinputoctets, acctoutputoctets, \**
**             calledstationid,  callingstationid, acctterminatecause, \**
**             servicetype,      framedprotocol, framedipaddress, \**
**             acctstartdelay,   acctstopdelay, xascendsessionsvrkey) \**
**          VALUES \**
**            ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \**
**             '%{SQL-User-Name}', \**
**             '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', \**
**             '%{NAS-Port-Type}', '%S', NULL, \**
**             '0', '%{Acct-Authentic}', '%{Connect-Info}', \**
**             '', '0', '0', \**
**             '%{Called-Station-Id}', '%{Calling-Station-Id}', '', \**
**             '%{Service-Type}', '%{Framed-Protocol}', 
'%{Framed-IP-Address}', \**
**             '%{%{Acct-Delay-Time}:-0}', '0', 
'%{X-Ascend-Session-Svr-Key}')"

*/You can kindly help me solve this problem?/**/THANKS./*
*
/Best Regards//
//Bruno D'Ambrosio./*
*


More information about the Freeradius-Users mailing list