Freeradius and mysql
Hello, I've installed freeradius and I've configured it to comunicate with mysql...all work fine, but I don't understand the meaning of the mysql database structure and all the possible values I can put in the database...if someone could illuminate me. Thanks in advance
"Mario Casola" <mario.casola@picsi.it> wrote:
Hello, I've installed freeradius and I've configured it to comunicate with mysql...all work fine, but I don't understand the meaning of the mysql database structure and all the possible values I can put in the database...if someone could illuminate me.
doc/rlm_sql Run the server in debugging mode, and send it packets. The text it prints out "foo = bar" is pretty much what you put into SQL. if you need to know what the text is, buy the O'Reilly book. Alan DeKok.
quick, very short and uncomplete answer :) *check tables:information which have to be checked from freeRADIUS, like user & password *reply tables:information which freeRADIUS sends back to your NAS (e.g. IP-pool, data rate etc.) *acct tables: here are the accounting information stored by freeRADIUS usergroup: assigning users to groups nas: for your NAS information (IP, secret, snmp community etc.) regards, Olaf -- Olaf Schaefer <olaf_freeradius@ojsch.de>
participants (3)
-
Alan DeKok -
Mario Casola -
Olaf Schaefer