user auth against mysql

richard lucassen mailinglists at
Wed Aug 9 20:55:05 CEST 2006

On Tue, 08 Aug 2006 17:44:22 -0400
Dennis Skinner <dskinner at> wrote:

> > Ok, so AFAIUI it would be better to dump the original db to a file
> > and populate a server which is set up according to the freeradius
> > schema. If possible of course (but that's a MySQL issue and beyond
> > the scope of this list of course)
> If the DB is MySQL 5, you *may* be able to create a view.  Otherwise,
> you may have to do what we did for a while.  We wrote a perl script to
> translate from one schema to the other and ran it every 10 minutes.
> Users were told to wait 10 mins before trying to login after an
> account change (reactivation, password update, etc).

I'm thinking of something similar. Fortunately running the script once a
day is ok. It's MySQL-4 btw.


It is better to remain silent and be thought a fool, than to speak
aloud and remove all doubt.

| Richard Lucassen, Utrecht                                        |
| Public key and email address:                                    |
|                         |

More information about the Freeradius-Users mailing list