mike-h30 wrote on Sunday, April 20, 2008:
I keep getting the following error when I click ‘Create Dataset’ in SQL Ledger. I have installed SQL Ledger 2.6.27.
Error!
FATAL: Ident authentication failed for user "sql-ledger"
I followed the SQL Ledger install directions from Brady’s website - http://www.bradymd.com/appliance/manual3/#0.0.0.0.0.0.Install%20FreeB%200.11|outline.
I have attempted to delete and re-create user “sql-ledger” but to no avail. I have included my command line output as well as my Apache2 error log below. This is my first time having installed/used PostgreSQL.
Questions
1.) Can anyone determine what I am doing wrong from my output?
2.) Did I not setup the initial postgres user correctly?
3.) Should there be a "admin" user for PostgreSQL?
******** My Command Line Output *******************************
linux-7sni:~ # su postgres
postgres@linux-7sni:/root> psql --version
could not change directory to "/root"
psql (PostgreSQL) 8.1.11
contains support for command-line editing
postgres@linux-7sni:/root> dropuser sql-ledger
could not change directory to "/root"
DROP ROLE
postgres@linux-7sni:/root> exit
exit
linux-7sni:~ # /sbin/service postgresql restart
Shutting down PostgreSQLpostmaster stopped
done
Starting PostgreSQL done
linux-7sni:~ # su postgres
postgres@linux-7sni:/root> createuser -d -P sql-ledger
could not change directory to "/root"
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) y
CREATE ROLE
postgres@linux-7sni:/root> createlang plpgsql template1
could not change directory to "/root"
createlang: language "plpgsql" is already installed in database "template1"
postgres@linux-7sni:/root> exit
exit
linux-7sni:~ #
******* Apache2 Error Log ******************
[Sun Apr 20 15:14:13 2008] [error] [client 127.0.0.1] DBI connect(‘dbname=template1’,‘sql-ledger’,…) failed: FATAL: Ident authentication failed for user “sql-ledger”, referer: http://localhost/sql-ledger/admin.pl
[Sun Apr 20 15:14:13 2008] [error] [client 127.0.0.1] at SL/User.pm line 253, referer: http://localhost/sql-ledger/admin.pl