You might try connecting via tcp/ip rather than Unix sockets. I haven't
used LedgerSMB but I do use phpPgAdmin under chrooted Apache over
tcp/ip. (Same thing with phpMysqlAdmin.)
I tried getting phpMysqlAdmin to run over Unix sockets and that was an
exercise in frustration. Tcp/ip is the way to go with chrooted Apache,
though I'd be happy to learn how otherwise.
Make sure you have /var/postgres/data/pg_hba.conf configured to allow
connections over tcp/ip for localhost addresses. I think it does by
default but review the section at the bottom of the file to be sure.
--Aaron
On Jan 22, 2009, at 16:06, Chris Bennett wrote:
I can get LedgerSMB to work fine with httpd -u,
but can't it to work correctly with Apache chrooted.
I've added a tmp dir to chroot, imported the files from
/usr/lib /usr/local/lib
tried moving socket into chroot.
No luck. Seems to connect OK with PSQL, but database
creation is failing to work properly.
Not sure what to try next.