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

[Vidar Hatlemark]

Alan DeKok wrote: I'm in the process of writing some more howto's on my web site. Check back in a week or so. Thank you, updated and more/better documentation is always a welcomed addition to this fine project. You're supposed to send accounting packets. They're not the same as authentication packets. I see, so no extra config is needed to route the accounting info from the file it now uses into the mysql radacct table? Since I got the radacct log files I guess I'm sending it wrong? (file instead of sql, even though it reads the sql?) Or am I supposed to both get that file with access request AND when the clients sends back the accounting packets then it will fill out the radacct table? I'm asking so detailed because I expected pfSense to behave and send the accounting packets right. I guess it doesn't since radacct is still empty. 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? The following states that I'll find the mysql.sql in that path. http://wiki.freeradius.org/SQL_HOWTO And in the schema.sql header it says : myslq -uroot -prootpass radius < db_mysql.sql If your client doesn't send accounting packets, then you can't populate the radacct table. Alan DeKok. So, when I log into the Captive Portal in pfSense using the user in my radius mysql table and the radacct tables doesn't get populatet - that's supposed to be a fault from pfSense? Sinse it only gives back the authentication packets logged in the radacct file... I'll have to digg into what pfSense is sending back. Thank you for this information. Kind regards (sorry, failed to send this to the list aswell, so here it is)

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html