#61 PostgreSQL Error
Attached is the HTML file outputted by calling
http://localhost/mydynaweb/htdocs/
Here is the error message for those not needing to
view the whole page:
--------------------------------------------
Warning: Unable to connect to PostgreSQL server:
connectDBStart() -- connect() failed: Connection
refused. Is the postmaster running (with -i)
at 'localhost' and accepting connections on TCP/IP
port 5432?
in /var/www/html/mydynaweb/htdocs/db/postgresql.php
on line: 44
------------------------------------------------
The script is having problems connecting to the DB.
I have tried to isolate the problem, here is what I
have done:
- Apache IS running, other scripts work fine.
- Allowing Port 5432 is fine
- DB is running as well, can su into postgres and
view tables and such
- DB has values from file
- Uncommented the /db/postgresql.php file and
commented the /db/mysql.php file in the core config
- Used GRANT to grant all permissions to public on DB
tables
- Wrote my own little PERL script to connect to the
mydynaweb DB, using the code from %man Pg. (Returned
connected, so I don't think it is a DB problem)
- Checked folder file permissions, all fine, tried
running as root, no change
- Have the right values for $dbName, $dbServer, etc.
- Tried hardcoding values (right and wrong) into the
db open function, get same error
So as far as I am concerned I am COMPLETELY set up
right on my end, all I can deduce is it must be your
connect code ;)
Specifically which versions of MDW OFICIALLY support
Postgresql? Do you have an idea when the next code
release w/ Postgresql support will be? Is it worth
it to wait, or should I go with the old release? I
guess I could go with old and upgrade.....we'll see
what features I miss out on with the old release.
Thanks letting me take your time and annoy ;-)
HTML Error Output (UNICODE)