Connecting to Postgres using PHP

[Anon]

Hi.I have php4 and Postgresql installed in my linux machine.Both of them are running just fine.When i compliled PHP,i did so with psql.Now my problem is that i want to write a code using php which connects to my Postgre database.I got some tutorial which explains how to its as follows:
$conn = pg_connect( "host=localhost user=username password=password dbname=phonelist"); doing the neccessary replacements.When i do it,i get the following error:
Warning: Unable to connect to PostgreSQL server: PQconnectPoll() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port 5432? in /wwwdocs/html/connect.php3 on line 7
I think the problem is coming in coz of the way i start my postgre.I start it as follows
/usr/local/pgsql/bin/pg_ct1 - /home/postgres/database start.
Please tell me what am doing wrong.
Thanks alot

[Anon]

Not that I know alot about postgres, but I have to start it with the "allow TCP connections on" to connect from PHP. Its probably the connect string that allows it to connect via the UNIX sockets (or whatever they are called). So that was my bandaid to connect..

so <path to pgsql>/bin/pg_ctl <path_to_db_files> -o -i

Cheers,
Sean.

[Anon]

Hi.

The problem is probably just what postgres tells you. You are running postgres without the -i flag which makes tcp/ip connections available. Try adding it like:

/usr/local/pgsql/bin/pg_ct1 -o '-i' /home/postgres/database start

Good luck!

[Anon]

Thanks so much Fredrik.Trying what you suggested gave an error:
Invalid operation mode
I however tried this(<path to pgsql>/bin/pg_ctl <path_to_db_files> -o -i) from Sean and i guess it worked coz the error was't there anymore.
However now am getting another error ie
Parse error: parse error in /wwwdocs/html/connect.php3 on line 21
where line 21 is the line after the ie the end of my file.Could you be having an idea whats wrong.Line 21 is the line immediately after my html closing tag and so blank.
Thanks

[Anon]

Thanks Sean.I guess that worked.The error dissapeared but am getting a new one now.I have Explained it in my second mail.
Please advise.
Thanks

[Anon]

Probably a missing end of loop/if ('}'), semi colon, quote... etc.

Cheers,

[smarlowe]

Note that you'll need to edit the $PGDATA/pg_hba.conf to include your own web server as one of the machines allowed to connect to the database.

[Anon]

Hi

It is a bit hard to really say what is wrong without the code. As Scott Marlowe writes you must add you ip-no in the pg_hba.conf file like:

host all 123.133.144.176 255.255.255.255 trust
(all on one line).

This however should probably stop you from connecting so the error should occur where you are trying to connect and not at the end. Perhaps you have an @ where you talk to the database? It supresses error msges so remove it and you might get some help.

Probably it is some kind of silly error like Sean says. If you want me to have a look at the code you email me it (at [e-mail]).

Fredrik

[Anon]

Hi.
Thanks so much for your help.
I managed to fix the last problem i reported.It was just an ommitted }.
However when i fixed that i realised that that the initial problem of connecting to my Postgres persisted.You told me to add the ip number in pg_hba.conf.Is this the ip no of my linux server where postgres is installed ?.The code i was using to connect is as follows
<?php
//setup connection variables
$conn=pg_connect ("host=localhost user=gwamae password=longlasting dbname = customers");
?>
In this case customers is a database which i created and gwamae is my username in the linux server and longlasting is the password.
After running the above below is the error i get:
Warning: Unable to connect to PostgreSQL server: PQconnectPoll() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port 5432? in /wwwdocs/html/connect.php3 on line 7
Please Help
Thanks

[fjutt]

Hmm...

The ip you shall set in pg_hba.conf is the ip number of the computers that shall be allowed to connect to postgres using tcp/ip. In this case the computer that are running the php (ther server and not the client running the browser). Probably this is the same computer as the one the db is running on (if you don't have a special db server). Make sure that both 127.0.0.1 (localhost) and the ip number it goes by in the big big world is in this file. Restart postgres afterwards to be sure the change is applied (not sure if this is necessary).

You should also try to change the pg_connect to use ip number instead of localhost. Not sure if this will make any difference (shouldn't if you hostsfile is correct).

Hope this helps. Ask again otherwise 🙂

Fredrik

[Anon]

Hi all,
I had the same error message and fixed it adding a "-i" option near the line 42 that starts the postmaster, in the file "/etc/rc.d/init.d/postgres", after "/usr/sbin/postmaster".

---

Marcelo Carvalho Fernandes
Smart Tech Consulting
Rio de Janeiro - Brasil
www.smartech.com.br

Fredrik Hultkrantz wrote:

Hmm...

The ip you shall set in pg_hba.conf is the ip number of the computers that shall be allowed to connect to postgres using tcp/ip. In this case the computer that are running the php (ther server and not the client running the browser). Probably this is the same computer as the one the db is running on (if you don't have a special db server). Make sure that both 127.0.0.1 (localhost) and the ip number it goes by in the big big world is in this file. Restart postgres afterwards to be sure the change is applied (not sure if this is necessary).

You should also try to change the pg_connect to use ip number instead of localhost. Not sure if this will make any difference (shouldn't if you hostsfile is correct).

Hope this helps. Ask again otherwise 🙂

Fredrik