At 12:08 14-10-99 +0200, Edouard DESSIOUX wrote:
> I'm using apache postgres and php,
> I created a database called "manip"
> and i want to acces this database via a web page
> I use the following php script to connect to the base:
> <?php $database = pg_connect ("dbname=manip port=5432"); ?>
use pg_connect ("dbname=manip user=USERNAME password=PASSWORD port=5432")
> And i obtain :
> Warning: Unable to connect to PostgresSQL server: FATAL 1: Database www does
> not exist in pg_database in
> /www/dooz.corp.intrinsec.com/mail/essai.php3 on line 3
if you don't declare user then the connection will be made with the user
running php/apache: in this case 'www'.
the connection fails because the username is not correct and I guess pg then
tries to connect you to your own database, named after the user: 'www'
In response to
pgsql-interfaces by date
|Next:||From: Jan Wieck||Date: 1999-10-15 11:54:11|
|Subject: Re: Scripts (was Re: [HACKERS] Re: [INTERFACES] Next release is 7.0(?))|
|Previous:||From: Michael Meskes||Date: 1999-10-15 11:22:39|
|Subject: Re: [INTERFACES] ecpg - example code|