FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Gentoo > Gentoo User

 
 
LinkBack Thread Tools
 
Old 12-15-2011, 02:54 AM
Joseph
 
Default DBI connect dbname=template1 failed Permission denied

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
 
Old 12-15-2011, 04:23 AM
Pandu Poluan
 
Default DBI connect dbname=template1 failed Permission denied

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,
 
Old 12-15-2011, 04:51 AM
Joseph
 
Default DBI connect dbname=template1 failed Permission denied

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
 
Old 12-15-2011, 08:11 AM
Pandu Poluan
 
Default DBI connect dbname=template1 failed Permission denied

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,
 
Old 12-15-2011, 12:48 PM
Joseph
 
Default DBI connect dbname=template1 failed Permission denied

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
 
Old 12-15-2011, 12:52 PM
Joseph
 
Default DBI connect dbname=template1 failed Permission denied

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
 
Old 12-15-2011, 09:46 PM
Pandu Poluan
 
Default DBI connect dbname=template1 failed Permission denied

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,
 
Old 12-15-2011, 09:49 PM
Pandu Poluan
 
Default DBI connect dbname=template1 failed Permission denied

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,
 
Old 12-15-2011, 10:09 PM
Pandu Poluan
 
Default DBI connect dbname=template1 failed Permission denied

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,
 
Old 12-16-2011, 02:20 AM
Joseph
 
Default DBI connect dbname=template1 failed Permission denied

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
 

Thread Tools




All times are GMT. The time now is 10:38 PM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org