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:[EMAIL PROTECTED] 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.

[EMAIL PROTECTED] # Su - postgres

-bash-3.00$ createuser -D -A -E
       auth
-bash-3.00$ createdb auth

Thanks Helping



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to