It looks as though you need to create your database users.

Try using the "createuser" command.

For more information: http://www.postgresql.org/docs/7.4/interactive/user-manag.html

Eddy


Mike-Olumide Johnson wrote:
Hello,

Have RADIUS setup and working properly.

While executing SQL got the following error:

'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'

Below is further ouputs from CLI

[EMAIL PROTECTED] data]# psql -U
psql: option requires an argument -- U
Try 'psql --help' for more information.
[EMAIL PROTECTED] data]# psql -u
psql: Warning: The -u option is deprecated. Use -U.
User name: root
Password:
psql: FATAL:  Database "root" does not exist in the system catalog.
[EMAIL PROTECTED] data]# psql -u
psql: Warning: The -u option is deprecated. Use -U.
User name: postgres
Password:
psql: FATAL:  IDENT authentication failed for user "postgres"

Will appreciate if someone can point me to how this problem could be
resolved.

Thanks in anticipation,
Mike


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to