From d3b10c6c836e53845c6b5d735c60f758e24e6c35 Mon Sep 17 00:00:00 2001 From: "Alan T. DeKok" Date: Thu, 9 Jul 2009 10:46:14 +0200 Subject: [PATCH] Use postgresl style comments Based on patch from Wickert Akkerman --- raddb/sql/postgresql/admin.sql | 54 +++++++++++++++++++++++------------------- 1 file changed, 29 insertions(+), 25 deletions(-) diff --git a/raddb/sql/postgresql/admin.sql b/raddb/sql/postgresql/admin.sql index a544cf8..e7effa6 100644 --- a/raddb/sql/postgresql/admin.sql +++ b/raddb/sql/postgresql/admin.sql @@ -1,28 +1,32 @@ -# -*- text -*- -## -## admin.sql -- PostgreSQL commands for creating the RADIUS user. -## -## WARNING: You should change 'localhost' and 'radpass' -## to something else. Also update raddb/sql.conf -## with the new RADIUS password. -## -## WARNING: This example file is untested. Use at your own risk. -## Please send any bug fixes to the mailing list. -## -## $Id$ +/* + * admin.sql -- PostgreSQL commands for creating the RADIUS user. + * + * WARNING: You should change 'localhost' and 'radpass' + * to something else. Also update raddb/sql.conf + * with the new RADIUS password. + * + * WARNING: This example file is untested. Use at your own risk. + * Please send any bug fixes to the mailing list. + * + * $Id$ + */ -# -# Create default administrator for RADIUS -# -CREATE USER 'radius'@'localhost' WITH PASSWORD 'radpass'; +/* + * Create default administrator for RADIUS + */ +CREATE USER radius WITH PASSWORD 'radpass'; -# The server can read any table in SQL -GRANT SELECT ON radcheck TO 'radius'@'localhost'; -GRANT SELECT ON radreply TO 'radius'@'localhost'; -GRANT SELECT ON radgroupcheck TO 'radius'@'localhost'; -GRANT SELECT ON radgroupreply TO 'radius'@'localhost'; -GRANT SELECT ON radusergroup TO 'radius'@'localhost'; +/* + * The server can read any table in SQL + */ +GRANT SELECT ON radcheck TO radius; +GRANT SELECT ON radreply TO radius; +GRANT SELECT ON radgroupcheck TO radius; +GRANT SELECT ON radgroupreply TO radius; +GRANT SELECT ON radusergroup TO radius; -# The server can write to the accounting and post-auth logging table. -GRANT ALL on radius.radacct TO 'radius'@'localhost'; -GRANT ALL on radius.radpostauth TO 'radius'@'localhost'; +/* + * The server can write to the accounting and post-auth logging table. + */ +GRANT ALL on radius.radacct TO radius; +GRANT ALL on radius.radpostauth TO radius; -- 2.1.4