Vidar Hatlemark wrote:
After a long week of reading every config file, how-to's (old, outdated, new, faulty and what not) and reading this mailing list archive and tried many test installs of freeradius I now ask for some help.
Short version: How to configure freeradius to populate the radacct mysql table. (need help)
I'm in the process of writing some more howto's on my web site. Check back in a week or so.
Am I supposed to send extra parameters to the server when logging in to get it to populate this table?
You're supposed to send accounting packets. They're not the same as authentication packets.
But in 2.0.5 I can't find the next two steps, cd /usr/share/doc/packages/freeradius/doc/examples/ mysql -uroot -p radius < mysql.sql
Which document says to do that?
In fact I can't find either the mysql.sql or the db_mysql.sql stated in the schema.sql header.
That's left over from it's previous name. You're supposed to import the "schema.sql" file.
So I imported the schema.sql from /usr/local/etc/raddb/sql/mysql/ folder. This gives me the radius tables that I need so far I guess. (or is this wrong?)
That's right.
Next up was sql.conf, added mysql credentials. Followed by editing the /usr/local/etc/raddb/sites-available/default, adding sql to the authorize and accounting.
It's there already. It's just commented out.
What's not - is understanding how the radacct table gets populated.
The client has to send accounting packets.
All I get is new entries in the /usr/local/var/log/radius/radacct/192.168.1.1/auth-detail-yyymmdd As shown here :
Tue Jul 22 14:06:55 2008 Packet-Type = Access-Request
Which are not accounting packets.
How do I redirect this (and more info) to populate the radacct table?
You don't. You use a client that sends accounting packets. If your client doesn't send accounting packets, then you can't populate the radacct table. Alan DeKok.