Freeradius 2.0.5 - configure to use mysql radacct table instead of file

[Vidar Hatlemark]

Hi

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)
And based on the info in the table, make a php page to list online user 
with the ability to kick them off. (will be able to do this by my self, 
if radacct table is the right place to do this)
Am I supposed to send extra parameters to the server when logging in to 
get it to populate this table?

Long version:

My system is Slackware 12.1
Kernel 2.6.24.5
mysql 5.0.51b
php 5.2.5
Apache 2.2.8

And FreeRadius 2.0.5 from tar.gz source.

What I've done so far:

Extracted and doing the configure, make, make install.

mysql -uroot -p
  CREATE DATABASE radius;
  GRANT ALL ON radius.* TO radius at localhost IDENTIFIED BY "radpass";
  exit

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

In fact I can't find either the mysql.sql or the db_mysql.sql stated in 
the schema.sql header.
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?)

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.

And added my pfSense to the client list aswell as my client pc (for 
NRradPing tool test).
client 192.168.1.1 {
  secret = testing123
  nastype = other
}
client 192.168.1.11 {
  secret = testing123
  nastype = other
}

Then manually added a user to the radcheck table.
id= 1
UserName= testuser
Attribute= Cleartext-Password
Value= testpasswd
Op= :=

Testing this from pfSense' captive portal with radius support works.
(And the NTradPing tool from my client pc)
I'm also able to kick out the user from pfSense captive portal status page.

And now to my problems/questions.

I'm building this into a small webtool for admin the users (daloRadius 
only gave me plenty of sql errors and since I'm able to write my own in 
php I will).
So far, adding the users to the radcheck table is easy.

What's not - is understanding how the radacct table gets populated.
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
        NAS-IP-Address = 88.88.54.181
        NAS-Identifier = "router.local.lan"
        User-Name = "testuser"
        Service-Type = Login-User
        NAS-Port-Type = Ethernet
        NAS-Port = 0
        Framed-IP-Address = 192.168.1.11
        Called-Station-Id = "00:0d:9d:xx:xx:xx" (masked out to hide the mac)
        Calling-Station-Id = "00:50:8d:xx:xx:xx" (masked out to hide the 
mac)

How do I redirect this (and more info) to populate the radacct table? 
(See the short version question on top of this post)

Thank you for reading this long post.
Feel free to ask any question about my setup, sorry if I've not included 
enough already.

Kind regards