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@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/