Thread: Freeradius and Postgresql

Freeradius and Postgresql

From

"Mike-Olumide Johnson"

Date:

30 January 2005, 20:56:28

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

Re: Freeradius and Postgresql

From

Tom Lane

Date:

30 January 2005, 22:05:57

"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