/etc/freeradius/sql/postgresql/admin.sql is in freeradius-postgresql 2.1.12+dfsg-1.2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | /*
* 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 WITH PASSWORD 'radpass';
/*
* 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;
GRANT ALL on radius.radpostauth TO radius;
|