postgres admin.sql fixes

John Dennis jdennis at
Thu Jul 9 14:36:43 CEST 2009

On 07/09/2009 04:47 AM, Alan DeKok wrote:
> Wichert Akkerman wrote:
>> The postgresql/admin.sql that ships in current Debian stable
>> unfortunately does not work: psql does not accept the comment syntax
>> used, host/domain names in roles or database names in columns for GRANT
>> statements.
>    OK.
>> The attached patch below fixes this. There may still be problems with
>> missing GRANTs for the sequences, I'll recheck those tomorrow.
>> This might of course all be fixes in the current sourcetree, in which
>> case I apologize for the noise.
>    I've committed similar fixes, as the patch didn't apply to the current
> git tree.  Please check it out...

While we're in the process of fix SQL schema, as per an email a few 
days, it seems like MySQL no longer wants a length qualifier on the 
TIMESTAMP data type. There are a couple of places in 
/etc/raddb/sql/mysql which specify "timestamp(14)", according to the 
MySQL docs it should just be "timestamp". I haven't tested the change, 
just going from the docs and the reported error.

John Dennis <jdennis at>

Looking to carve out IT costs?

More information about the Freeradius-Devel mailing list