schema divergence in SQL flavours..

Peter Nixon listuser at
Mon Sep 17 23:11:22 CEST 2007

On Mon 17 Sep 2007, A.L.M.Buxey at wrote:
> hi,
> is there any particular reason why the mysql and postgres schema
> differ in their naming conventions for the radpostauth table?  this
> makes it more interesting for users to utilise, eg sql_log module
> as the values in radiusd.conf are the MySQL values in the radpostauth
> schema...and not postgresql's

OK. I have standardised the mysql names to match postgresql.

user -> username (To match the rest of the tables)
date -> authdate (Because 'date' is a reserved word in some SQL dialects)



Peter Nixon

More information about the Freeradius-Devel mailing list