|
From: Jeff K. <jt...@ad...> - 2001-08-18 19:19:28
|
I need some assistance getting SQL-Ledger 1.6 to run on RH7.1 with PostgreSQL 7.1.x. I have database connection problems. I'm wondering if I need to do some sort of "GRANT ALL" on the postgres user or something. I've installed DBD::Pg and tested it successfully. There is a pgsqltest database as a result, in fact. I have (for the moment) postgres open with a blank password and listening with 'no authentication required', although I don't yet know how to tell the postgres-specific distinction between 'local connection' and localhost connection. How do I tell if postgres is listening on 5434? I easily can access postgres via webmin, for example. Database Host:localhost Port:5432 Database Administrator: postgres Password: (blank) Connect to: mypgdb (choose 'create database' results in:) Error! connectDBStart() -- connect() failed: Connection refused Likewise, I have a sql-ledger user with the following profile: Driver: Pg Host: localhost Name: mypgdb Port: 5432 User: postgres Password: (blank) (Logging in as this user results in:) Error! Database is offline; please try again later Looking at the 'Granted Priveledges" thru webmin, I see no tables having any explicitly granted priviledges. Isn't the 'postgres' user implicitly granted permission? Can anyone help me figure this out? I have to deploy this sql-ledger test ASAP. Thanks. |