AW: Using a database schema other than the one created by db_mysql.sql

[Uwe Driessen]

> 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
> 
> Hi,
> 
> 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
> Like:
> usergroup_table = "usergroup"
> replace by
> usergroup_table = "users"
> 
> 
> Thanks,
> -Ana

And for all the Other you write the SQL Statements to your Tablefields you
have  
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 
    Drießen 
Es liegt was in der Luft
www.feilbingert.net
Uwe Drießen
Software & Computer
Lembergstraße 33
67824 Feilbingert
Tel.: 06708 660045 Fax 06708 661397
www.edv-driessen.de