RE: [INTERFACES] newbie question about PHP
От | Jackson, DeJuan |
---|---|
Тема | RE: [INTERFACES] newbie question about PHP |
Дата | |
Msg-id | F10BB1FAF801D111829B0060971D839F2F3C8E@cpsmail обсуждение исходный текст |
Список | pgsql-interfaces |
try: pg_Connect("host=localhost user=$username password=$password port=5432 dbname=SomeDatabase") //[Note the lack of commas.] -DEJ > -----Original Message----- > From: Steve Doliov [SMTP:doliov@statsol.com] > Sent: Tuesday, June 23, 1998 11:22 PM > To: pgsql-novice@postgreSQL.org > Cc: pgsql-interfaces@postgreSQL.org > Subject: [INTERFACES] newbie question about PHP > > i am trying to connect to a database using webpages with embedded > php3.0 > > postmaster is running with the -i option > the database is running with the -u option > the web user is nobody, and user nobody has select privileges on > the given database. > from the shell, i can access the database as user nobody > $ psql -u mydatabase > Username: nobody > Password: xxxx > mydatabase=> > --------------- > <?PHP > $conn = pg_Connect("localhost", "5432", "user=nobody,password=demo", > "", "grocery"); > if (!$conn) { > echo "An error occurred.\n"; > exit; > } > .... > ?> > > this is what resulting page says: > > Warning: Unable to connect to PostgresSQL server: User authentication > failed in > /home1/s/statsol/public_html/test/test.phtml on line 21 > An error occurred. > > my user=,password= is obviously a hack, i am just looking for how to > specify it for the pgoptions part of the pg_connect; help with the > syntax would be much appreciated. > > thanks, > steve doliov
В списке pgsql-interfaces по дате отправления: