postgreSQL permission problems

Fri, 28 Jun 2002 14:49:59 -0700

Srs, I just unsubscribe from this list, although I'm still receiving emails.
Can someone unsubscribe me?

-----Original Message-----
From: Mike Starke [mailto:meg@lilly.csoft.net]
Sent: Friday, June 28, 2002 2:29 PM
To: plug-discuss@lists.plug.phoenix.az.us
Subject: Re: postgreSQL permission problems

Right before Derek replied I figured out the pg_hba file right.
So her was right on. although I have it fairly wide open, I'm able to
get in and evaluate the program.

I do have one question: Someone posted earlier this week about
postgres utilizing the GRANT & REVOKE statements. In MySQL, it is pretty
straightforward (at least to me) what happens when you issue GRANT
statements.
How is this handled in postgreSQL? Does it make entries in a table
somewhere, or does
it manipulate the pg_hba file? Or?

v/r
mike

:On Fri, Jun 28, 2002 at 01:49:19PM -0700, Tom Emerson wrote:
 Mike, how is the postmaster started?  (postmaster is the postgresql 
 backend server)

 There is an option the postmaster needs in order to allow 
 network connections.

 Example, looking at the process list (ps ax):
 /usr/local/pgsql/bin/postmaster -i -D /web/pgsql

 The "-i" option seen here allows tcp connections, without it, quite a few 
 of the software's can't connect.  If you don't see this "-i" option, that 
 may be your problem.

 A typical startup command for the postmaster looks like this (but all on 
 one line!):
 su - postgres -c "/usr/local/pgsql/bin/postmaster -i -D /web/pgsql 
 >logfile 2>&1 &"

 On Fri, 28 Jun 2002, Mike Starke wrote:

 I am attempting to get SQL-Ledger up and running and am running
 into a few problems as it pertains to postgreSQL.

 I have done the following:

 1. As the user postgres (I'm on a debian sysem btw), I have done:
    'createuser mike'

 2. As the user 'mike' I have done:
    'createdb mydb'

 3. I can, as user 'mike' do:
    'psql mydb'
    and get to the command line utility.

 4. I have also ensured that I have the line"
    'tcpip_socket = 1'
    in /etc/postgresql.conf

 5. I have mucked around in /etc/postgresql/pg_hba.conf a bit and not sure
    what I have done in there.

 At any rate, when I fire up http://localhost/sqlledger.admin.pl, login, and
then try
 to "Create Dataset" under the user 'mike', my linux (mike) password, and
connect to 'mydb',
 I get the following error:FATAL 1: IDENT authentication failed for user
"mike".

 I'm suspect my problems lie within pg_hba.conf, but whatever I do (thinking
it is wide open)
 I continue to get the same error message.

 Can anyone offer some guidance here?

 v/r
 Mike
 ________________________________________________
 See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't
post to the list quickly and you use Netscape to write mail.

 PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
 http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss

 ________________________________________________
 See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't
post to the list quickly and you use Netscape to write mail.

 PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
 http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
________________________________________________
See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post
to the list quickly and you use Netscape to write mail.

PLUG-discuss mailing list  -  PLUG-discuss@lists.plug.phoenix.az.us
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss