On Mon, Jun 9, 2008 at 11:28 AM, Milton Calnek <[EMAIL PROTECTED]> 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.) > [EMAIL PROTECTED] > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
