pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mariusz Pekala <skoot@qi.pl>
To: pgsql-php@postgresql.org
Cc: David Cruz Ramos <dcruz@redcolombia.com.co>
Subject: Re: Help Conecting to a database from PHP
Date: Mon, 1 Dec 2003 17:53:43 +0100
Message-ID: <200312011754.17463.skoot@qi.pl> (raw)
In-Reply-To: <3219C8BE8C5DCB4E95503D8E6B0BE901682512@sred01exs.redcolombia.local>
References: <3219C8BE8C5DCB4E95503D8E6B0BE901682512@sred01exs.redcolombia.local>

-----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-----





view thread (2+ messages)

Message-ID: <200312011754.17463.skoot@qi.pl>
Permalink:  ../200312011754.17463.skoot@qi.pl/
Also on:    postgresql.org/message-id/200312011754.17463.skoot@qi.pl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: skoot@qi.pl, dcruz@redcolombia.com.co
  Subject: Re: Help Conecting to a database from PHP
  In-Reply-To: <200312011754.17463.skoot@qi.pl>
  References: <3219C8BE8C5DCB4E95503D8E6B0BE901682512@sred01exs.redcolombia.local> <200312011754.17463.skoot@qi.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox