Freeradius and Postgresql
Hi All,
Have setup RADIUS using freeRadius-1.0.1 and its working perfectly. The
setup also works fine with mikrotik NAS to deploy hotspot.
Installed Postresql. 'Service postgresql status' shows its running. Created
a table named 'radius', each time I try to execute SQL from my webmin
interface, I get the following error;
'Output from SQL commands in file
/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_pos
tgresql.sql .. psql: Warning: The -u option is deprecated. Use -U. User
name: Password:
/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_pos
tgresql.sql: Permission denied '
Any ideas to help resolve this?
Thanks in advance,
Mike
Mike-Olumide Johnson
234-803 33133324
"Mike-Olumide Johnson" <mjohnson@mdobonline.com> writes:
'Output from SQL commands in file
/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_ pos
tgresql.sql .. psql: Warning: The -u option is deprecated. Use -U.
That means what it says.
/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_ pos
tgresql.sql: Permission denied '
That does not look like a Postgres error message at all --- looks more
like an operating-system file permissions violation. Check whether you
have execute permission on the script, for instance.
regards, tom lane