pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Self <jself@ci.newport-news.va.us>
To: pgsql-php@postgresql.org
Subject: Re: Not able to connect to server from PHP
Date: 23 Jan 2002 08:57:11 -0500
Message-ID: <1011794231.19776.1.camel@personnel_test> (raw)
In-Reply-To: <OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com>
References: <OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com>

Thanks for the tips everyone. I figured it out this morning. My
pg_hba.conf file had local set to peer sameuser instead of trust. I
don't know how that happened.

On Tue, 2002-01-22 at 16:11, timothy_maguire@hartehanks.com wrote:
> 
> on my server, I have 'http' registered as a user for my database.  you can
> try that.
> 
> Or you can add the user=username password=password to the pg_connect()
> function.
> 
> Tim.
> 
> Timothy P. Maguire
> Web Developer II
> Harte-Hanks
> 978 436 3325
> 
> 
> 
>                                                                                                              
>                       Jeff Self                                                                              
>                       <jself@ci.newport-        To:       timothy_maguire@hartehanks.com                     
>                       news.va.us>               cc:       pgsql-php@postgresql.org                           
>                                                 Subject:  Re: Not able to connect to server from PHP         
>                       01/22/2002 04:18                                                                       
>                       PM                                                                                     
>                                                                                                              
>                                                                                                              
> 
> 
> 
> 
> Ok, I tried this and this is the error message I get now:
> 
> Warning: Unable to connect to PostgreSQL server: FATAL 1: user
> "www-data" does not exist in /var/www/personnel/include/database.inc on
> line 9
> Could not connect to database.
> 
> www-data is the user and group for apache. I don't know what to make of
> this.
> 
> Here's my database.inc file:
> 
> <?php
> //
> // database.inc
> //
> // Database Information
> 
>  $dbname = "personnel";
> 
>  $conn = pg_pconnect("host=localhost port=5432 dbname=$dbname");
>  if (!$conn) {
>   echo "Could not connect to database.";
>   exit;
>  }
> ?>
> 
> 
> On Tue, 2002-01-22 at 15:54, timothy_maguire@hartehanks.com wrote:
> >
> > When I connect I don't like to use the user name attribute.  You might
> also
> > want to try the port attribute.
> >
> > Try something like this:
> >
> > $conn =pg_connect("host=localhost port=5432 dbname=personnel") or die
> > ("unable to connect to Internal DB");
> >
> > Tim.
> >
> > Timothy P. Maguire
> > Web Developer II
> > Harte-Hanks
> > 978 436 3325
> 
> --
> Jeff Self
> Information Technology Analyst
> Department of Personnel
> City of Newport News
> 2400 Washington Ave.
> Newport News, VA 23607
> 757-926-6930
> 
> HARTE- HANKS PRIVILEGED AND CONFIDENTIAL INFORMATION- if you are not the
> addressee or authorized to receive this for the addressee, you must not
> use, copy, disclose or take any action based on this message or any
> information herein and should delete this message.
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
-- 
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930




view thread (8+ messages)  latest in thread

Message-ID: <1011794231.19776.1.camel@personnel_test>
Permalink:  ../1011794231.19776.1.camel@personnel_test/
Also on:    postgresql.org/message-id/1011794231.19776.1.camel@personnel_test

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: jself@ci.newport-news.va.us
  Subject: Re: Not able to connect to server from PHP
  In-Reply-To: <1011794231.19776.1.camel@personnel_test>
  References: <OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com> <1011794231.19776.1.camel@personnel_test>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox