Re: Problems in connecting to postgreSQL using PHP

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(at)gmail(dot)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(at)gmail(dot)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(at)jobsforge(dot)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(at)gmail(dot)com
> valentinorfila(at)hotmail(dot)com
> josevalentinorfila(at)yahoo(dot)com
>
> Messenger: valentinorfila(at)hotmail(dot)com
>
> Skype: valentinorfila
> valentinorfila(at)gmail(dot)com
> ***************************************************************************
>
>
>