Help Conecting to a database from PHP

Hi All!

My PC has Slackware Linux 9.1 installed.

And Apache and PHP are working well....I can make and use the PHP functions=
in my web pages. Recently I've downloaded and installed PostgreSQL 7.3.2, =
it seems to work well too, I can make databases, tables and all...But when =
I try to use the PHP functions to connect to the database (pg_connect or pg=
_pconnect) it doesn't work. I've granted select permission to my user and n=
obody user in the table of the databse, and my pg_hba.conf seems to be ok (=
localhost all all trust ).
The browser even not give any error or something....it just don't work...

I think I'm using the function in the correct way: $conn =3D pg_connect ("l=
ocalhost","","","","mydbname");

I've tried too: $conn =3D pg_connect ("dbname=3Dmydbname");

with and without the port number (5432), and when I type: netstat -nat =
it shows:

0.0.0.0:5432 LISTEN

in the list

I'm starting the database server in this way: /usr/local/pgsql/bin/postmast=
er -i -D /usr/local/pgsql/data

thanks....

does somebody know what can I do?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Re: Help Conecting to a database from PHP

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello.

David Cruz Ramos (pon 1. grudzien 2003 16:41):
> And Apache and PHP are working well....I can make and use the PHP functio=
ns
> in my web pages. Recently I've downloaded and installed PostgreSQL 7.3.2,
> [...]
> nobody user in the table of the databse, and my pg_hba.conf seems to be ok
> ( localhost all all trust ). The browser even not give any error or
> something....it just don't work...

Maybe some error messages are in logfiles? Where are log files for yout=20
postgresql and for your web server?

I suppose you have used wrong format. The line in pg_hba.conf should read:
host all all 127.0.0.1 255.255.255.255 trust

> I think I'm using the function in the correct way: $conn =3D pg_connect
> ("localhost","","","","mydbname");

If I remember correctly this form has been deprecated...

> I've tried too: $conn =3D pg_connect ("dbname=3Dmydbname");
> [...]
> I'm starting the database server in this way:
> /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data
>
> thanks....
>
> does somebody know what can I do?

I suppose you may safely drop listening on TCP/IP connections. "local"=20
connections should be fine.
In that case insert a line into pg_hba.conf:
local all all trust
(...if you want to do it in fast but extremely unsecure way.)

Connecting from PHP you may try to use explicit username, hovewer I think y=
our=20
problem is in this pg_hba.conf's line with localhost.
Even if your hba_conf is OK, have you enabled "tcpip_socket" in=20
postgresql.conf?

Maybe there are conflicts with versions of modules used by PHP and your=20
postgres? Have you had an older version of PostgreSQL before? Have you=20
recompiled PHP, apache? Just guessing...

- --=20
[http://skoot.qi.pl for GPG keys]
"A computer programmer is someone who, when told to "Go to Hell", sees
the "Go to", rather than the destination, as harmful."
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/y3IxvkWo15WV1rkRAoGhAJ9l/mg/Pihier+tRELkAnO2s2fsjQCe LS9/
15SYAofmao6ttL4ezWUIFLw=3D
=3DEv/N
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org