postgres admin.sql fixes
jdennis at redhat.com
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
>> 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 redhat.com>
Looking to carve out IT costs?
More information about the Freeradius-Devel