Openwrt Sqlite No Write Radacct Table
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./* *
On 3 Jun 2015, at 16:11, Bruno D'Ambrosio <brunodambrosio2011@hotmail.it> wrote:
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.*
Yeah.... the Sqlite implementation in 2 was only half complete. Try FreeRADIUS v3.0.8. -Arran Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
Hi Arran Thanks for your message. Sqlite for Openwrt attitude_adjustment 12.09 with freeradius2-mod-sqlite 2.2.0-1, not function for this version? Best Regards Bruno D'Ambrosio
Bruno, Doesn't works. -- Jorge Pereira On Wed, Jun 3, 2015 at 7:19 PM, Bruno D'Ambrosio < brunodambrosio2011@hotmail.it> wrote:
Hi Arran Thanks for your message. Sqlite for Openwrt attitude_adjustment 12.09 with freeradius2-mod-sqlite 2.2.0-1, not function for this version?
Best Regards Bruno D'Ambrosio
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Arran Cudbard-Bell -
Bruno D'Ambrosio -
Jorge Pereira