Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-17 Thread Stroller
On 17 December 2011, at 02:13, Joseph wrote: ... I see that LedgerSMB is 1.3 is it stable? Any version of LedgerSMB will be better than any version of SQL-Ledger. Is there direct migration from SQL-Ledger 2.8.35 No idea off the top of my head. The plan for LedgerSMB was to be compatible

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-16 Thread Stroller
On 16 December 2011, at 03:20, Joseph wrote: … The SQL-Ledger developer was helping me out on this and he can not figure it out either. I'm sure it is not SQL-ledger as it is working perfectly on my other computers. It could be apache configuration, but I don't see how? Wait. Stop. This

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-16 Thread Joseph
On 12/16/11 18:57, Stroller wrote: On 16 December 2011, at 03:20, Joseph wrote: … The SQL-Ledger developer was helping me out on this and he can not figure it out either. I'm sure it is not SQL-ledger as it is working perfectly on my other computers. It could be apache configuration, but I

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-16 Thread Joseph
On 12/16/11 18:57, Stroller wrote: On 16 December 2011, at 03:20, Joseph wrote: … The SQL-Ledger developer was helping me out on this and he can not figure it out either. I'm sure it is not SQL-ledger as it is working perfectly on my other computers. It could be apache configuration, but I

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Pandu Poluan
On Dec 15, 2011 12:52 PM, Joseph syscon...@gmail.com wrote: On 12/15/11 12:23, Pandu Poluan wrote: On Dec 15, 2011 10:55 AM, Joseph syscon...@gmail.com wrote: I have postgresql up and running but when I try to connect via apache to postgresql I get an error: [error] [client

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Joseph
On 12/15/11 16:11, Pandu Poluan wrote: here are other details: # psql -p 5432 -U postgres psql (9.1.1) Type help for help. postgres=# Available PostgreSQL Slots A 9.1 * A A A A A A A A A A A server-9.1.1 base-9.1.1 Hmmm... Have you GRANT the

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Joseph
On 12/15/11 16:11, Pandu Poluan wrote: Hmmm... Have you GRANT the 'sql-ledger' user the CONNECT privilege to the database? Rgds, After installing postgresql I run: emerge --config =dev-db/postgresql-server-9.1.1 started postgresql-9.1 # su - postgres postgres@syscon5 ~ $ createuser

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Pandu Poluan
On Dec 15, 2011 8:52 PM, Joseph syscon...@gmail.com wrote: On 12/15/11 16:11, Pandu Poluan wrote: Hmmm... Have you GRANT the 'sql-ledger' user the CONNECT privilege to the database? Rgds, After installing postgresql I run: emerge --config =dev-db/postgresql-server-9.1.1 started

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Pandu Poluan
On Dec 16, 2011 5:46 AM, Pandu Poluan pa...@poluan.info wrote: On Dec 15, 2011 8:52 PM, Joseph syscon...@gmail.com wrote: On 12/15/11 16:11, Pandu Poluan wrote: Hmmm... Have you GRANT the 'sql-ledger' user the CONNECT privilege to the database? Rgds, After

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Pandu Poluan
On Dec 16, 2011 5:49 AM, Pandu Poluan pa...@poluan.info wrote: On Dec 16, 2011 5:46 AM, Pandu Poluan pa...@poluan.info wrote: On Dec 15, 2011 8:52 PM, Joseph syscon...@gmail.com wrote: On 12/15/11 16:11, Pandu Poluan wrote: Hmmm... Have you GRANT the 'sql-ledger'

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Joseph
On 12/16/11 05:49, Pandu Poluan wrote: Okay, according to the documentation on GRANT, =c/postgres means the public is granted CONNECT privilege, granted by the user postgres. So no problem there. Hmm... wonder what's wrong... Okay, I'm grasping at straws currently... how

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Joseph
On 12/16/11 06:09, Pandu Poluan wrote: Some thoughts : if the line is correct, the problem might be in how you configured Apache. Here's a reference : http://cpanforum.com/threads/1268 Rgds, Thanks for the pointer, that is interesting! How do I check if apache loaded multithreaded

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Joseph
On 12/15/11 20:28, Joseph wrote: On 12/16/11 06:09, Pandu Poluan wrote: Some thoughts : if the line is correct, the problem might be in how you configured Apache. Here's a reference : http://cpanforum.com/threads/1268 Rgds, Thanks for the pointer, that is interesting! How do I

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Pandu Poluan
On Dec 16, 2011 10:28 AM, Joseph syscon...@gmail.com wrote: On 12/16/11 06:09, Pandu Poluan wrote: Some thoughts : if the line is correct, the problem might be in how you configured Apache. Here's a reference : http://cpanforum.com/threads/1268 Rgds, Thanks for the pointer, that

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-15 Thread Pandu Poluan
On Dec 16, 2011 10:42 AM, Joseph syscon...@gmail.com wrote: On 12/15/11 20:28, Joseph wrote: On 12/16/11 06:09, Pandu Poluan wrote: Some thoughts : if the line is correct, the problem might be in how you configured Apache. Here's a reference : http://cpanforum.com/threads/1268

[gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-14 Thread Joseph
I have postgresql up and running but when I try to connect via apache to postgresql I get an error: [error] [client 127.0.0.1] DBI connect('dbname=template1','sql-ledger',...) failed: could not connect to server: Permission denied, referer: http://localhost/sql-ledger/admin.pl Anybody knows

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-14 Thread Pandu Poluan
On Dec 15, 2011 10:55 AM, Joseph syscon...@gmail.com wrote: I have postgresql up and running but when I try to connect via apache to postgresql I get an error: [error] [client 127.0.0.1] DBI connect('dbname=template1','sql-ledger',...) failed: could not connect to server: Permission denied,

Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

2011-12-14 Thread Joseph
On 12/15/11 12:23, Pandu Poluan wrote: On Dec 15, 2011 10:55 AM, Joseph syscon...@gmail.com wrote: I have postgresql up and running but when I try to connect via apache to postgresql I get an error: [error] [client 127.0.0.1] DBI connect('dbname=template1','sql-ledger',...)