Обсуждение: Problems in connecting to postgreSQL using PHP

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Hi!!! I'm Venezuelan and I don't know how to speak english very well, so excuse me if i make a mistake.

About the connection: Did you do your script by yourself?, or copied a functional one?

As Thomas Schindler said, send us any PHP errors or the pg_hba.conf ?

Here is my connection script, it is completly good check it out to see if you have anything wrong

<?  /*---------------*/
    $servidor = "localhost";
     $base = "databasename"; //change it
     $usuario = "postgresuser"; //change it
     $password = "postgresuser"; //change it
  
     pg_pconnect("host=$servidor dbname=$base user=$usuario password=$password");
  
?>

That's all what I can do for now

2007/3/12, Matthew Terenzio < matt@jobsforge.com>:

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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

[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

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

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

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

here is the script again

<?  /*---------------*/
    $servidor = "localhost";
     $base = "databasename"; //change it
     $usuario = "postgresuser"; //change it
     $password = "postgresuserpassword"; //change it
  
     pg_pconnect("host=$servidor dbname=$base user=$usuario password=$password");
  
?>

2007/3/12, Valentín Orfila <valentinorfila@gmail.com >:

Hi!!! I'm Venezuelan and I don't know how to speak english very well, so excuse me if i make a mistake.

About the connection: Did you do your script by yourself?, or copied a functional one?

As Thomas Schindler said, send us any PHP errors or the pg_hba.conf ?

Here is my connection script, it is completly good check it out to see if you have anything wrong

<?  /*---------------*/
    $servidor = "localhost";
     $base = "databasename"; //change it
     $usuario = "postgresuser"; //change it
     $password = "postgresuser"; //change it
  
     pg_pconnect("host=$servidor dbname=$base user=$usuario password=$password");
  
?>

That's all what I can do for now

2007/3/12, Matthew Terenzio < matt@jobsforge.com>:

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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

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