From: | Mariusz Pekala <skoot(at)qi(dot)pl> |
---|---|
To: | <pgsql-php(at)postgresql(dot)org> |
Cc: | "David Cruz Ramos" <dcruz(at)redcolombia(dot)com(dot)co> |
Subject: | Re: Help Conecting to a database from PHP |
Date: | 2003-12-01 16:53:43 |
Message-ID: | 200312011754.17463.skoot@qi.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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 functions
> 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
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 = pg_connect
> ("localhost","","","","mydbname");
If I remember correctly this form has been deprecated...
> I've tried too: $conn = pg_connect ("dbname=mydbname");
> [...]
> 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"
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 your
problem is in this pg_hba.conf's line with localhost.
Even if your hba_conf is OK, have you enabled "tcpip_socket" in
postgresql.conf?
Maybe there are conflicts with versions of modules used by PHP and your
postgres? Have you had an older version of PostgreSQL before? Have you
recompiled PHP, apache? Just guessing...
- --
[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+tRELkAnO2s2fsjQCeLS9/
15SYAofmao6ttL4ezWUIFLw=
=Ev/N
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Spiegelberg | 2003-12-01 17:40:31 | Re: error on Database insert (off-topic) |
Previous Message | David Cruz Ramos | 2003-12-01 15:41:37 | Help Conecting to a database from PHP |