Re: postgres help.

["Chris Travers" <..hidden..>]

On Mon, Jun 9, 2008 at 11:28 AM, Milton Calnek <..hidden..> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> I'm having troubles setting my postgres server.
>
> I'm trying to run ledger on a Centos 5 (aka rhel 5) system, with
> postgres 8.1.11.
>
> I can connect to the ledger db as users ledgersmb, postgres, root
> and apache. Everyone but ledgersmb is a superuser:
>
> As root I can connect to ledgersmb db as user root, but not as user
> ledgersmb. ie:
> psql -d ledgersmb -> works
> psql -U ledgersmb -d ledgersmb -W -> does not work.
>
> This is from pg_dumpall:
>
> CREATE ROLE apache;
> ALTER ROLE apache WITH SUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
> CREATE ROLE ledgersmb;
> ALTER ROLE ledgersmb WITH NOSUPERUSER INHERIT NOCREATEROLE CREATEDB
> LOGIN PASSWORD 'md5ab61fc5b6b7ef0f56920f335e02265b1';
> CREATE ROLE postgres;
> ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
> CREATE ROLE root;
> ALTER ROLE root WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
>
>
> My pg_hba.conf files follows:
> I added the md5/pam lines in an effort
>
> # "local" is for Unix domain socket connections only
> local   all         all                               ident sameuser
> local   all         all                               md5
> local   all         all                               pam

^^^^ Only the first match is recognized.

Change the top line to:

local   postgres   all                  ident  sameuser

Get rid of the last line (pam).

> # IPv4 local connections:
> host    all         all         127.0.0.1/32          ident sameuser
> host    all         all         127.0.0.1/32          md5
> host    all         all         127.0.0.1/32          pam

Get rid of the top and bottom lines.

> # IPv6 local connections:
> host    all         all         ::1/128               ident sameuser

I don;t think we use ipv6 addresses so this shouldn't matter for lsmb.

>
>
> tia.
>
> - --
> Milton Calnek BSc, A/Slt(Ret.)
> ..hidden..
> 306-717-8737
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
>
> iD8DBQFITXZqHgnbf2T2QqMRAiyCAKCAM6yfYChXpMSsHY6wdmJsd5XLOwCeIAZn
> gF6ai0L77BkZSh9KMKxspMY=
> =RQNi
> -----END PGP SIGNATURE-----
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>