DBI connect dbname=template1 failed Permission denied

12-15-2011, 02:54 AM

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 what to look for?

--
Joseph

12-15-2011, 04:23 AM

On Dec 15, 2011 10:55 AM, "Joseph" <syscon780@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, referer: http://localhost/sql-ledger/admin.pl

>

> Anybody knows what to look for?

>

> --

> Joseph

>

Check pg_hba.conf

Rgds,

12-15-2011, 04:51 AM

On 12/15/11 12:23, Pandu Poluan wrote:

On Dec 15, 2011 10:55 AM, "Joseph" <syscon780@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, referer: http://localhost/sql-ledger/admin.pl
>
> Anybody knows what to look for?
>
> --
> Joseph
>

Check pg_hba.conf

Rgds,

I did, it is identical to my other working systems:
local all all trust

here are other details:

# psql -p 5432 -U postgres
psql (9.1.1)
Type "help" for help.

postgres=#

Available PostgreSQL Slots
9.1 * server-9.1.1 base-9.1.1

--
Joseph

12-15-2011, 08:11 AM

On Dec 15, 2011 12:52 PM, "Joseph" <syscon780@gmail.com> wrote:

>

> On 12/15/11 12:23, Pandu Poluan wrote:

>>

>> *On Dec 15, 2011 10:55 AM, "Joseph" <syscon780@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, referer: http://localhost/sql-ledger/admin.pl

>> *>

>> *> Anybody knows what to look for?

>> *>

>> *> --

>> *> Joseph

>> *>

>>

>> *Check pg_hba.conf

>>

>> *Rgds,

>

>

> I did, it is identical to my other working systems:

> local * all * * all * * * *trust

>

> here are other details:

>

> # psql -p 5432 -U postgres

> psql (9.1.1)

> Type "help" for help.

>

> postgres=#

> Available PostgreSQL Slots

> *9.1 * * * * * * * * * * * *server-9.1.1 base-9.1.1

>

Hmmm...

Have you GRANT the 'sql-ledger' user the CONNECT privilege to the database?

Rgds,

12-15-2011, 12:48 PM

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 'sql-ledger' user the CONNECT privilege to the
database?

Rgds,

How do I check it?

--
Joseph

12-15-2011, 12:52 PM

12-15-2011, 09:46 PM

On Dec 15, 2011 8:52 PM, "Joseph" <syscon780@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 postgresql-9.1

> # su - postgres

> postgres@syscon5 ~ $ createuser -d sql-ledger

> * y

> * y

> exit

>

> that was it.

>

> # psql -U postgres -l

> * * * * * * * * * * * * * * * * *List of databases

> * Name * *| *Owner * | Encoding | * Collate * | * *Ctype * *| * Access privileges * -----------+----------+----------+-------------+-------------+-----------------------

> *postgres *| postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | *template0 | postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | =c/postgres * * * * *+

> * * * * * | * * * * *| * * * * *| * * * * * * | * * * * * * | postgres=CTc/postgres

> *template1 | postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | =c/postgres * * * * *+

> * * * * * | * * * * *| * * * * *| * * * * * * | * * * * * * | postgres=CTc/postgres

> --

> Joseph

>

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

Rgds,

12-15-2011, 09:49 PM

On Dec 16, 2011 5:46 AM, "Pandu Poluan" <pandu@poluan.info> wrote:

>

>

> On Dec 15, 2011 8:52 PM, "Joseph" <syscon780@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 postgresql-9.1

> > # su - postgres

> > postgres@syscon5 ~ $ createuser -d sql-ledger

> > * y

> > * y

> > exit

> >

> > that was it.

> >

> > # psql -U postgres -l

> > * * * * * * * * * * * * * * * * *List of databases

> > * Name * *| *Owner * | Encoding | * Collate * | * *Ctype * *| * Access privileges * -----------+----------+----------+-------------+-------------+-----------------------

> > *postgres *| postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | *template0 | postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | =c/postgres * * * * *+

> > * * * * * | * * * * *| * * * * *| * * * * * * | * * * * * * | postgres=CTc/postgres

> > *template1 | postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | =c/postgres * * * * *+

> > * * * * * | * * * * *| * * * * *| * * * * * * | * * * * * * | postgres=CTc/postgres

> > --

> > Joseph

> >

>

> 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 does the offending line in admin.pl look like?

Rgds,

12-15-2011, 10:09 PM

On Dec 16, 2011 5:49 AM, "Pandu Poluan" <pandu@poluan.info> wrote:

>

>

> On Dec 16, 2011 5:46 AM, "Pandu Poluan" <pandu@poluan.info> wrote:

> >

> >

> > On Dec 15, 2011 8:52 PM, "Joseph" <syscon780@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 postgresql-9.1

> > > # su - postgres

> > > postgres@syscon5 ~ $ createuser -d sql-ledger

> > > * y

> > > * y

> > > exit

> > >

> > > that was it.

> > >

> > > # psql -U postgres -l

> > > * * * * * * * * * * * * * * * * *List of databases

> > > * Name * *| *Owner * | Encoding | * Collate * | * *Ctype * *| * Access privileges * -----------+----------+----------+-------------+-------------+-----------------------

> > > *postgres *| postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | *template0 | postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | =c/postgres * * * * *+

> > > * * * * * | * * * * *| * * * * *| * * * * * * | * * * * * * | postgres=CTc/postgres

> > > *template1 | postgres | UTF8 * * | en_US.UTF-8 | en_US.UTF-8 | =c/postgres * * * * *+

> > > * * * * * | * * * * *| * * * * *| * * * * * * | * * * * * * | postgres=CTc/postgres

> > > --

> > > Joseph

> > >

> >

> > 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 does the offending line in admin.pl look like?

>

> Rgds,

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,

12-16-2011, 02:20 AM

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 does the offending line in
admin.pl look like?

Rgds,

Hi Pandu,

Thanks for helping out on this. I'm pulling my hair trying to figure it out and I'm getting nowhere.

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?
I've compared file (using meld) setup with my working server and they are the same.
So it could be something do to with permission. As I copied apache configuration file using "meld" and meld program does not preserve ownership.

Here is amdin.pl script from SQL-Ledger

#!/usr/bin/perl -X
#
################################################## ####################
# SQL-Ledger ERP
# Copyright (C) 2006
#
# Author: DWS Systems Inc.
# Web: http://www.sql-ledger.com
#
################################################## #####################
#
# this script sets up the terminal and runs the scripts
# in bin/$terminal directory
# admin.pl is linked to this script
#
################################################## #####################

# setup defaults, DO NOT CHANGE
$userspath = "users";
$spool = "spool";
$templates = "templates";
$images = "images";
$memberfile = "users/members";
$sendmail = "| /usr/sbin/sendmail -t";
%printer = ();
########## end ###########################################

$| = 1;

eval { require "sql-ledger.conf"; };

if ($ENV{CONTENT_LENGTH}) {
read(STDIN, $_, $ENV{CONTENT_LENGTH});
}

if ($ENV{QUERY_STRING}) {
$_ = $ENV{QUERY_STRING};
}

if ($ARGV[0]) {
$_ = $ARGV[0];
}

%form = split /[&=]/;

# fix for apache 2.0 bug
map { $form{$_} =~ s/$// } keys %form;

# name of this script
$0 =~ tr////;
$pos = rindex $0, '/';
$script = substr($0, $pos + 1);

@scripts = qw(login.pl admin.pl custom_login.pl custom_admin.pl);

if (grep !/^Q$form{script}E/, @scripts) {
print "Content-Type: text/html

" if $ENV{HTTP_USER_AGENT};
print "
Access denied!
";
exit;
}

if (-f "$userspath/nologin" && $script ne 'admin.pl') {
print "Content-Type: text/html

" if $ENV{HTTP_USER_AGENT};
if (-s "$userspath/nologin") {
open(FH, "$userspath/nologin");
$message = <FH>;
close(FH);
print "
$message
";
} else {
print "
Login disabled!
";
}
exit;
}

if ($form{path}) {
$form{path} =~ s/%2f///gi;
$form{path} =~ s/..//g;

if ($form{path} !~ /^bin//) {
print "Content-Type: text/html

" if $ENV{HTTP_USER_AGENT};
print "
Invalid path!
";
exit;
}

$ARGV[0] = "$_&script=$script";
require "$form{path}/$script";
} else {

if (!$form{terminal}) {
if ($ENV{HTTP_USER_AGENT}) {
# web browser
$form{terminal} = "lynx";
if ($ENV{HTTP_USER_AGENT} !~ /lynx/i) {
$form{terminal} = "mozilla";
}
} else {
if ($ENV{TERM} =~ /xterm/) {
$form{terminal} = "xterm";
}
if ($ENV{TERM} =~ /(console|linux|vt.*)/i) {
$form{terminal} = "console";
}
}
}

if ($form{terminal}) {
$form{terminal} =~ s/%2f///gi;
$form{terminal} =~ s/..//g;

$ARGV[0] = "path=bin/$form{terminal}&script=$script";
map { $ARGV[0] .= "&${_}=$form{$_}" } keys %form;

require "bin/$form{terminal}/$script";

} else {

print "Content-Type: text/html

" if $ENV{HTTP_USER_AGENT};
print qq|
Unknown terminal
|;
}

}

# end of main

--
Joseph