user auth against mysql

[richard lucassen]

On Tue, 08 Aug 2006 17:44:22 -0400
Dennis Skinner <dskinner at bluefrog.com> 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.

R.

-- 
___________________________________________________________________
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:                                    |
| http://www.lucassen.org/mail-pubkey.html                         |
+------------------------------------------------------------------+