Re: Re: PostgreSQL error with PHP

I rewrote the code. This is the code and errors. This is starting to get old, I have been working on this for over a week now. CODE: <html><head><title>Login</title> </head> <body> <?php $conn = "user=auth password=redhat dbname=auth host=localhost port=5432"; $dbconn = pg_connect($conn); echo "Connected Successfully"; ?> </body> </html> Error: Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? in /var/www/html/thomas/cis166ae/database/secretdb.php on line 11 Connected Successfully Thomas Thomas Bonham wrote:

I add the hostname and port, then I configure postgresql.conf and enable the port 5432 line in the config file. So this is the new code. <html><head><title>Login</title> </head> <body> <?php

        $conn = pg_connect("
    user=auth dbname=auth password=redhat host=thomas.example.com
    port=5432" ) or die ("Could not connect") ;
    echo "Connected Successfully";
    pg_close($conn);
       ?>

</body> </html> With the new error. Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "thomas.example.com" and accepting TCP/IP connections on port 5432? in /var/www/html/thomas/cis166ae/database/secretdb.php on line 10 Could not connect Thomas Robbert van Andel wrote:

You might need to include the hostname and port. -----Original Message----- From: Thomas Bonham [mailto:thomasbbonham@gmail.com] Sent: Sunday, June 26, 2005 6:48 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: PostgreSQL error with PHP Thanks for the help. The code now looks like this. CODE:

    <html><head><title>Login</title>

    </head>
    <body>
    <?php
        $conn = pg_connect("user=auth dbname=auth password=redhat")
    or die ("Could not connect") ;
    echo "Connectd Successfully";
    pg_close($conn);
        ?>
    </body>
    </html>

And now the error I get is the following. Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166ae/database/secretdb.php on line 8 Could not connect Thomas Robbert van Andel wrote:

The error is in your function pg_connect pg_connect("name=auth user=auth"); I'm not a PostgreSQL user but your connection string should be enclosed

into

by quotes. Documentation can be found at http://us3.php.net/manual/en/function.pg-connect.php Hope this helps, Robbert -----Original Message----- From: Thomas Bonham [mailto:thomasbbonham@gmail.com] Sent: Sunday, June 26, 2005 5:43 PM To: php-db@lists.php.net Subject: [PHP-DB] Re: PostgreSQL error with PHP I modafide the code some more and now with the following code I get this error. CODE: <html><head><title>Login</title> </head> <body> <?php

          pg_connect(name="auth"); (user="auth");

?> </body> </html> Parse error: parse error, unexpected '=' in /var/www/html/thomas/cis166ae/database/secretdb.php on line 8 Thanks Thomas Bonham wrote:

Hello All, I'm trying to get php to connect to my PostgreSQL database. The code that I'm using is below. <html><head><title>Login</title> </head> <body> <?php

     $conn = "dbname=auth user=auth";

$db = pg_connect ( $conn ); ?> </body> </html> Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166ae/database/secretdb.php on line 8 Below is how I set up my database. root@thomas # Su - postgres -bash-3.00$ createuser -D -A -E

      auth

-bash-3.00$ createdb auth Thanks Helping