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 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 do

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 do

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. Th

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

2011-12-15 Thread Pandu Poluan
On Dec 16, 2011 10:42 AM, "Joseph" 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 >

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

2011-12-15 Thread Pandu Poluan
On Dec 16, 2011 10:28 AM, "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, tha

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 check

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 MP

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..

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" wrote: > > > On Dec 16, 2011 5:46 AM, "Pandu Poluan" wrote: > > > > > > On Dec 15, 2011 8:52 PM, "Joseph" wrote: > > > > > > On 12/15/11 16:11, Pandu Poluan wrote: > > >> > > >> > > >> Hmmm... > > >> > > >> Have you GRANT the 'sql-ledger' user the CONNEC

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" wrote: > > > On Dec 15, 2011 8:52 PM, "Joseph" 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 inst

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

2011-12-15 Thread Pandu Poluan
On Dec 15, 2011 8:52 PM, "Joseph" 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 > > s

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 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 t

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

2011-12-15 Thread Pandu Poluan
On Dec 15, 2011 12:52 PM, "Joseph" wrote: > > On 12/15/11 12:23, Pandu Poluan wrote: >> >> On Dec 15, 2011 10:55 AM, "Joseph" 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 >>

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" 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

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

2011-12-14 Thread Pandu Poluan
On Dec 15, 2011 10:55 AM, "Joseph" 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, referer: http://

[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 w