Accounting into MySQL
Hi folks, I have an Ubuntu server 8.04.2 LTS running (pretty bare bones). I installed freeradius and freeradius-sql from the repositories (MySQL 5, all dependiencies, etc). For configuration I followed the SQL HOWTO on the FreeRADIUS Wiki page. I am able to successfully use NTRadPing Test Utility against the radius server when configured to use SQL as the back end. I also followed the instructions on the Frontios website and a few other websites, and by searching this groups mail archive on how to configure accounting into SQL, but I'm not getting any accounting information. Running freeradius -X I see the queries going to the database for authentication, but I don't see any insert/select into statements indicating accounting information being written to the database. I have some basic questions to better understand accounting into SQL. 1. Using NTRadPING, should I get entries in my radacct table? 2. I have uncommented the sql_log, and all the detail log sections, and in the accounting section, and uncommented the sql in the accounting section. What other changed are required assuming that I am already successfully authenticating from the radcheck table? 3. Is there a more detailed how-to on the internet (I guess my google-foo is not as good as others) specifically on accounting in mysql? 3.b) ... sepecifically on MAC authentication? Thanks so much! Tim
1. Using NTRadPING, should I get entries in my radacct table?
Are you sending accounting packets? If not - why should freeradius pass any request to accounting parts.
2. I have uncommented the sql_log, and all the detail log sections, and in the accounting section, and uncommented the sql in the accounting section. What other changed are required assuming that I am already successfully authenticating from the radcheck table?
Did you set the right user/password combination for access to mysql server? ( you probably did, else you would have seen errors while starting freeradius with -X switch ) Regards, E:S
I have some basic questions to better understand accounting into SQL.
1. Using NTRadPING, should I get entries in my radacct table?
No. Those are authentication, not accounting requests.
2. I have uncommented the sql_log, and all the detail log sections, and in the accounting section, and uncommented the sql in the accounting section. What other changed are required assuming that I am already successfully authenticating from the radcheck table?
You don't need all that. Just sql in accounting. Detail writes to files.
3. Is there a more detailed how-to on the internet (I guess my google-foo is not as good as others) specifically on accounting in mysql?
Configure sql connection details in sql.conf. Uncomment sql in accounting section of the default virtual server. That's it.
3.b) ... sepecifically on MAC authentication?
http://wiki.freeradius.org/Mac-Auth Ivan Kalik Kalik Informatika ISP
is it freeradius and freeradius-mysql ? ----- Original Message ----- From: "Tim Dressel" <tjdressel@gmail.com> To: <freeradius-users@lists.freeradius.org> Sent: Friday, May 15, 2009 3:53 AM Subject: Accounting into MySQL
Hi folks,
I have an Ubuntu server 8.04.2 LTS running (pretty bare bones). I installed freeradius and freeradius-sql from the repositories (MySQL 5, all dependiencies, etc). For configuration I followed the SQL HOWTO on the FreeRADIUS Wiki page. I am able to successfully use NTRadPing Test Utility against the radius server when configured to use SQL as the back end.
I also followed the instructions on the Frontios website and a few other websites, and by searching this groups mail archive on how to configure accounting into SQL, but I'm not getting any accounting information.
Running freeradius -X I see the queries going to the database for authentication, but I don't see any insert/select into statements indicating accounting information being written to the database.
I have some basic questions to better understand accounting into SQL.
1. Using NTRadPING, should I get entries in my radacct table?
2. I have uncommented the sql_log, and all the detail log sections, and in the accounting section, and uncommented the sql in the accounting section. What other changed are required assuming that I am already successfully authenticating from the radcheck table?
3. Is there a more detailed how-to on the internet (I guess my google-foo is not as good as others) specifically on accounting in mysql?
3.b) ... sepecifically on MAC authentication?
Thanks so much!
Tim - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Yes, both. 2009/5/14 EasyHorpak.com <info@easyhorpak.com>:
is it freeradius and freeradius-mysql ?
I'm doing some more testing using the suggestions from Edvin and Ivan (almost like the two ivan's), and will follow up. I think its just my misunderstanding of what accounting actually does. ;) Cheers,
participants (4)
-
EasyHorpak.com -
Edvin Seferovic -
Ivan Kalik -
Tim Dressel