Help in connecting to a database with PHP

From: "Michael J(dot) McGillick" <mmcgillick(at)attbi(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Subject: Help in connecting to a database with PHP
Date: 2002-05-27 06:07:20
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATMX1T/YgGEKM6LUYbjsZU8KAAAAQAAAAE7U800jk30SH8CZ2ndzvnQEAAAAA@attbi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Hi:

I'm trying to learn how to set up a .php file to connect to my
PostgreSQL database. From the command line, I can connect, open and work
in the database on my machine. However, if I create a .php page with the
following information:

$db = pg_connect("dbname=baseball user=postgres");

I get the following error message:

Warning: Unable to connect to PostgreSQL server: FATAL 1: IDENT
authentication failed for user "postgres" in /var/www/html/baseball.php
on line 10.

I'm running a stock Red Hat Linux 7.3 machine with PostgreSQL version
7.2. I have verified that from the command line, I can switch to the
user postgres and connect to the database with no problems. I can view
data, add and delete records, etc.

I'd appreciate some help in trying to track down what I'm doing wrong.
I've spent the past few days looking at documentation from various web
sites, and nothing seems to jump out as the culprit.

- Michael

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Ludwig Lim 2002-05-27 08:55:52 Re: Help in connecting to a database with PHP
Previous Message Keary Suska 2002-05-24 17:42:14 Re: Inventory