PostgreSQL DBI DBD::Pg Access Problem

From: Samizdatt <Samizdatt(at)earthlink(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL DBI DBD::Pg Access Problem
Date: 2001-12-24 01:31:38
Message-ID: 3C26857A.761B5693@earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


*************** Configuration Info ******************
I'm using:

SuSE PPC Linux v7.3 on an Apple iBook
PostgreSQL v7.1.3
Perl v5.6.1
DBI v1.20
DBD::Pg v1.01
Apache v1.3.20
Apache DBI v0.88

I created 2 users in addition to postgres with the createuser command. These users have actual corresponding accounts on the system.

(1)postgres - can create users and databases
(2)root - can create databases
(3)wwwrun - is just the web server account that can neither create databases nor users

I modified the pg_hba.conf to temporarily allow connections from all users on the box by adding the following lines to the file:

local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 10.10.10.50 255.255.255.255 trust

Postmaster runs as "/usr/bin/postmaster -i -B 512 -D/var/lib/pgsql/data"
******************************************************

*************** Problem ******************************

I can connect to any of the PostgreSQL databases through any of the 3 user accounts using psql, but I can only connect to the databases with my web server cgi & command line Perl DBI/DBD::Pg applications by including "postgres" as the user in my DBI database handles. I'd like to be able to connect to the databases using the wwwrun user account that is restricted from creating both users and databases in my DBI based applications and cgi scripts.

Since the pg_hba.conf is set to allow any user with an account in the PostgreSQL database to connect from my box, and I can connect to any of the databases through any of the 3 accounts using psql, shouldn't my DBI based cgi & command line Perl applications be able to connect to the same databases using any of the 3 postgres user accounts I created using createuser? Now, only including "postgres" as the user in my DBI/DBD::Pg database handles allows my cgi & command line programs to access my PostgreSQL databases.
*****************************************************

Thank you for any assistance.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-12-24 03:13:39 Re: PostgreSQL DBI DBD::Pg Access Problem
Previous Message Marc Spitzer 2001-12-23 19:42:07 Re: Shipping database help desperately needed