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
root@mj data]# psql -U psql: option requires an argument -- U Try 'psql --help' for more information. [root@mj 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. [root@mj 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 majordomo@xxxxxxxxxxxxxx
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
