pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: timothy_maguire@hartehanks.com
To: Jeff Self <jself@ci.newport-news.va.us>
Cc: pgsql-php@postgresql.org
Subject: Re: Not able to connect to server from PHP
Date: Tue, 22 Jan 2002 16:11:06 -0500
Message-ID: <OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com> (raw)


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.







view thread (8+ messages)  latest in thread

Message-ID: <OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com>
Permalink:  ../OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com/
Also on:    postgresql.org/message-id/OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com

 · 

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: timothy_maguire@hartehanks.com, jself@ci.newport-news.va.us
  Subject: Re: Not able to connect to server from PHP
  In-Reply-To: <OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com>
  References: <OF55EEA50A.022BFEEE-ON85256B49.00742D5B@hartehanks.com>

* 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