PostgreSQL error with PHP
| From: | Thomas Bonham | Date: | Sun, 26 Jun 2005 22:49:32 +0000 |
| Subject: | PostgreSQL error with PHP | ||
| Groups: | php.db php.db php.db | ||
| Request: | Send a blank email to php-db+get-39777@lists.php.net to get a copy of this message | ||
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