pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Valentín Orfila <valentinorfila@gmail.com>
To: Kitty Yuen <kitty3a@gmail.com>
Cc: Matthew Terenzio <matt@jobsforge.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Problems in connecting to postgreSQL using PHP
Date: Wed, 14 Mar 2007 13:59:12 -0400
Message-ID: <6b8c0db0703141059w1c2aba32gfe7ebc310208279e@mail.gmail.com> (raw)
In-Reply-To: <b3efba5a0703131826p7acd85d6iea20813d01ecdb53@mail.gmail.com>
References: <b3efba5a0703112125s23b7eac1u60639be8ac06def4@mail.gmail.com>
	<f22361d85ef58b122d12731d3888a589@jobsforge.com>
	<b3efba5a0703121927p7247f399ueadc006d9a78a88f@mail.gmail.com>
	<6b8c0db0703130615m15eef49fj59fa34ab670c5fe9@mail.gmail.com>
	<b3efba5a0703131826p7acd85d6iea20813d01ecdb53@mail.gmail.com>

I already told you all I thought, but...

Below is the local config in my pg_hba and i just see you have one line more
than me, do you use Unix? if not, so erase that line and try again

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# IPv4 local connections:
host    all         all         127.0.0.1/32            trust

# IPv6 local connections:
localhost    all         all         ::1/128               trust




2007/3/13, Kitty Yuen <kitty3a@gmail.com>:
>
> Dear Valentín,
>
> I think I have already enabled the extension and found the extension in my
> pgsql.ini file in php.d folder. However, I still cannot connect to the
> database. I guess I have something to be config in the PostgreSQL. Do you
> have any ideas?
>
>
> Kitty3a
>
> On 3/13/07, Valentín Orfila <valentinorfila@gmail.com> wrote:
> >
> > OK. Now you have to activate the library to connect PHP to PostgreSQL,
> > this is in the php.ini file. In Windows 2000 it is in the following
> > folders: C:\WINNT and in the PHP installation folder, in my case:
> > C:\AppServ\php. Once you find this file you have to discomment this
> > extension: extension=php_pgsql.dll, to do that you are going to erase the
> > ";" at the beggining of the line.
> >
> > Look for this file (php.ini) in your O.S. and configured it. If you are
> > using Linux I guess it is in the etc/profile/php.config directory, but I0m
> > not sure.
> >
> > I'm attaching you my file:
> >
> >
> >  2007/3/12, Kitty Yuen <kitty3a@gmail.com>:
> > >
> > > Here are my error messages from PHP:
> > >
> > >
> > > [Mon Mar 12 16:01:26 2007] [error] [client 127.0.0.1] PHP Warning:   pg_connect()
> > > [<a href='function.pg-connect'>function.pg-connect</a>]: Unable to
> > > connect to PostgreSQL server: could not connect to server: Permission
> > > denied\n\tIs the server running locally and accepting\n\tconnections on Unix
> > > domain socket &quot;/tmp/.s.PGSQL.5432&quot;? in /var/www/html/try.php on
> > > line 3
> > >
> > > [Mon Mar 12 16:01:26 2007] [error] [client 127.0.0.1] PHP Warning:   pg_last_error()
> > > [<a href='function.pg-last-error'>function.pg-last-error</a>]: No
> > > PostgreSQL link opened yet in /var/www/html/try.php on line 4
> > >
> > > PHP Code:
> > >
> > >
> > > <?php
> > >
> > > // Connecting, selecting database
> > >
> > > $dbconn = pg_connect("dbname=test user=postgres")
> > >
> > >    or die('Could not connect: ' . pg_last_error());
> > >
> > >
> > >
> > > // Performing SQL query
> > >
> > > $query = 'SELECT * FROM haha';
> > >
> > > $result = pg_query($query) or die('Query failed: ' . pg_last_error());
> > >
> > >
> > >
> > > // Printing results in HTML
> > >
> > > echo "<table>\n";
> > >
> > > while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
> > >
> > >    echo "\t<tr>\n";
> > >
> > >    foreach ($line as $col_value) {
> > >
> > >        echo "\t\t<td>$col_value</td>\n";
> > >
> > >    }
> > >
> > >    echo "\t</tr>\n";
> > >
> > > }
> > >
> > > echo "</table>\n";
> > >
> > >
> > >
> > > // Free resultset
> > >
> > > pg_free_result($result);
> > >
> > >
> > >
> > > // Closing connection
> > >
> > > pg_close($dbconn);
> > >
> > >
> > >
> > > *pg_hba.cof*
> > >
> > > # TYPE  DATABASE    USER         CIDR-ADDRESS          METHOD
> > >
> > >
> > >
> > > # "local" is for Unix domain socket connections only
> > >
> > > local   all         all                                trust
> > >
> > >
> > >
> > > # IPv4 local connections:
> > >
> > > host    all         all          127.0.0.1/32          trust
> > >
> > > # IPv6 local connections:
> > >
> > > host    all         all          ::1/128               trust
> > >
> > > *postgresql.conf*
> > >
> > >
> > >
> > > #---------------------------------------------------------------------------
> > >
> > > # CONNECTIONS AND AUTHENTICATION
> > >
> > >
> > > #---------------------------------------------------------------------------
> > >
> > >
> > >
> > > # - Connection Settings -
> > >
> > >
> > >
> > > listen_addresses = 'localhost'             # what IP address(es) to
> > > listen on;
> > >
> > >                                         # comma-separated list of
> > > addresses;
> > >
> > >                                         # defaults to 'localhost', '*'
> > > = all
> > >
> > > port = 5432
> > >
> > > max_connections = 100
> > >
> > > # note: increasing max_connections costs ~400 bytes of shared memory
> > > per
> > >
> > > # connection slot, plus lock space (see max_locks_per_transaction).
> > > You
> > >
> > > # might also need to raise shared_buffers to support more connections.
> > >
> > > superuser_reserved_connections = 2
> > >
> > > unix_socket_directory = ''
> > >
> > > unix_socket_group = ''
> > >
> > > unix_socket_permissions = 0777              # octal
> > > bonjour_name = ''                     # defaults to the computer name
> > >
> > > Thanks a lot,
> > > Kitty3A
> > >
> > >
> > >
> > >
> > >
> > >
> > > On 3/12/07, Matthew Terenzio <matt@jobsforge.com > wrote:
> > > >
> > > > Could you provide any PHP errors or the pg_hba.conf ?
> > > >
> > > > On Mar 12, 2007, at 12:25 AM, Kitty Yuen wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I am trying to connect my postgreSQL with PHP in localhost. I have
> > > > > start up the server with -i flag (i.e. postmaster -D
> > > > > /usr/local/pgsql/data -i &) and edit the pg_hba.conf. However, I
> > > > still
> > > > > cannot connect with the database. But, when I tried to remote
> > > > access
> > > > > the database through SSH and I can connect with it.
> > > > >
> > > > > Would you please offer any suggestions or solutions?
> > > > >
> > > > > Manythanks,
> > > > > Kitty3A
> > > >
> > > >
> > >
> >
> >
> > --
> >
> > ***************************************************************************
> > Ministerio de Planificación y Desarrollo de la República Bolivariana de
> > Venezuela
> > Dirección de Planes de Personal
> >
> > José Valentín Orfila Briceño
> > Programador II
> >
> > Teléfonos: Celular: (0416) 4131418
> >
> > E-mail: valentinorfila@gmail.com
> >            valentinorfila@hotmail.com
> >            josevalentinorfila@yahoo.com
> >
> > Messenger: valentinorfila@hotmail.com
> >
> > Skype: valentinorfila
> >            valentinorfila@gmail.com
> > ***************************************************************************
> >
> >
> >
>


-- 
***************************************************************************
Ministerio de Planificación y Desarrollo de la República Bolivariana de
Venezuela
Dirección de Planes de Personal

José Valentín Orfila Briceño
Programador II

Teléfonos: Celular: (0416) 4131418

E-mail: valentinorfila@gmail.com
           valentinorfila@hotmail.com
           josevalentinorfila@yahoo.com

Messenger: valentinorfila@hotmail.com

Skype: valentinorfila
           valentinorfila@gmail.com
***************************************************************************

view thread (10+ messages)  latest in thread

Message-ID: <6b8c0db0703141059w1c2aba32gfe7ebc310208279e@mail.gmail.com>
Permalink:  ../6b8c0db0703141059w1c2aba32gfe7ebc310208279e@mail.gmail.com/
Also on:    postgresql.org/message-id/6b8c0db0703141059w1c2aba32gfe7ebc310208279e@mail.gmail.com

 · 

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: valentinorfila@gmail.com, kitty3a@gmail.com, matt@jobsforge.com
  Subject: Re: Problems in connecting to postgreSQL using PHP
  In-Reply-To: <6b8c0db0703141059w1c2aba32gfe7ebc310208279e@mail.gmail.com>
  References: <b3efba5a0703112125s23b7eac1u60639be8ac06def4@mail.gmail.com> <f22361d85ef58b122d12731d3888a589@jobsforge.com> <b3efba5a0703121927p7247f399ueadc006d9a78a88f@mail.gmail.com> <6b8c0db0703130615m15eef49fj59fa34ab670c5fe9@mail.gmail.com> <b3efba5a0703131826p7acd85d6iea20813d01ecdb53@mail.gmail.com> <6b8c0db0703141059w1c2aba32gfe7ebc310208279e@mail.gmail.com>

* 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