Re: Re: PostgreSQL error with PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx] Sent: Sunday, June 26, 2005 5:43 PM
To: php-db@xxxxxxxxxxxxx
Subject:  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



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux