pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: bruce <bedouglas@earthlink.net>
To: pgsql-novice@postgresql.org
To: pgsql-php@postgresql.org
Subject: Accessing Postgres db from apache using PHP
Date: Sun, 27 Jul 2003 18:00:14 -0700
Message-ID: <001501c354a3$9aee0b40$0301a8c0@Mesa.com> (raw)

Hi...

I'm new to Postgres... I've installed Postgres on a Linux RH 8.0 server. I'm
trying to access a pgsql db from an Apache website, using PHP(v-4.2.2). I've
taken a look at google and through the archives with no real luck...

I created a Linux user and given the user rights to the Postgres group.
I created a Linux user (gforge) and given it rights to the Postgres group.
Using the gforge user, I created a postgres user, using
	-> createuser gforge - W
I gave the user the password of ->gforge

I gave the user rights to add/create databases, but not add new users
I then installed a database.
	pgsql -U gforge -d gforge < gforge3.sql

At this point, I can see that I have a db in postgres....
I did a "\l" and it displayed:
	name	owner	encoding
-->>	gforge	gforge	sql_ascii


In my php code, I have....

$sys_dbhost = "localhost";
$sys_dbname = "gforge";
$sys_user = "gforge";
$sys_dbpasswd = "gforge";

i then do a:
	$tmp = "host=localhost dbname=gforge user=gforge password=gforge";
	$conn = @pg_connect($tmp);

at this point $conn is not set... it should be a resouce if I've connect to
the DB..!!!!!!!

So.. the question... Anybody have any idea as to what I've done wrong/left
out/etc...

Any pointers/comments/criticisms would be helpful.....
Any sample docs, or code that illustrates how this should be accomplished
would be helpful...


Thanks...

Bruce Douglas
(925) 866-2790
bedouglas@earthlink.net




view thread (13+ messages)  latest in thread

Message-ID: <001501c354a3$9aee0b40$0301a8c0@Mesa.com>
Permalink:  ../001501c354a3$9aee0b40$0301a8c0@Mesa.com/
Also on:    postgresql.org/message-id/001501c354a3$9aee0b40$0301a8c0@Mesa.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: bedouglas@earthlink.net, pgsql-novice@postgresql.org
  Subject: Re: Accessing Postgres db from apache using PHP
  In-Reply-To: <001501c354a3$9aee0b40$0301a8c0@Mesa.com>
  References: <001501c354a3$9aee0b40$0301a8c0@Mesa.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