Milton, > I can connect to the ledger db as users ledgersmb, postgres, root > and apache. Everyone but ledgersmb is a superuser:
First of all, having apache be a superuser on the database is a very bad idea. It leaves your DB wide open to any SQL injection or HTTP compromise attacks. Having "root" as a superuser isn't a great idea either simply because you don't want queries running as "root". > 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. We need to see the error message you get when you try to connect. > # "local" is for Unix domain socket connections only > local all all ident sameuser > local all all md5 > local all all pam Ah, you've misunderstood how pg_hba.conf works. The first line which matches the host, user and db will be used, so you're never getting past "ident sameuser". This makes the -U switch useless. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ------------------------------------------------------------------------- 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
