-----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 # 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 # IPv6 local connections: host all all ::1/128 ident sameuser 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
