You might need to include the hostname and port. -----Original Message----- From: Thomas Bonham [mailto:thomasbbonham@xxxxxxxxx] Sent: Sunday, June 26, 2005 6:48 PM To: php-db@xxxxxxxxxxxxx Subject: Re: 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@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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
