AW: Using a database schema other than the one created by db_mysql.sql
driessen at fblan.de
Tue Aug 2 23:09:47 CEST 2005
> Auftrag von Ana Bizarro
> Gesendet: Dienstag, 2. August 2005 22:35
> An: freeradius-users at lists.freeradius.org
> Betreff: Using a database schema other than the one created
> by db_mysql.sql
> We have a (mysql) database where we have usernames and
> passwords and I recently installed freeradius on our server.
> I would like the freeradius server to authenticate using the
> database but, obviously, our database schema is completely
> different than the one created by db_mysql.sql.
> All the documentation (and examples) I've seen so far mention
> the db_mysql.sql script (even in the RADIUS book) and I was
> wondering, if it's possible to use our own database, how do I
> tell RADIUS that "uid" in the users table is the username and
> "pwd" is the password?
> For the tables names, I'm assuming I can just change the
> sql.conf file and replace whatever is inside " " by our own
> table names
> usergroup_table = "usergroup"
> replace by
> usergroup_table = "users"
And for all the Other you write the SQL Statements to your Tablefields you
For a update like
Tablefield = '%s' for date and Time in this field for the AcctstopTime and
so on where is the Problem,
The Statements in the sql.conf are pure SQL.
And the Insert's as so too
Mit freundlichen Grüßen
Es liegt was in der Luft
Software & Computer
Tel.: 06708 660045 Fax 06708 661397
More information about the Freeradius-Users