Re: Debian LSMB 1.4.11 install

[Geordie <..hidden..>]

On Thu, 07 May 2015 07:08:14 -0400
Robert James Clay <..hidden..> wrote:

> 
>    What's showing up in the logs and in /tmp/ledgersmb/ about that?
There are no logs in /tmp/ledgersmb, I am assuming I am missing
something. There wasn't any in 1.3.46 either Both in LXC containers if
that is an issue

Sorry for whats next Apache 2 logs

[Thu May 07 20:01:44.572536 2015] [authz_core:debug] [pid 477:tid
140496072591104] mod_authz_core.c(809): [client 10.0.0.13:60209]
AH01626: authorization result of Require ip 10.0.0.0/255.255.255.0:
granted, referer: http://10.0.0.23/ledgersmb/setup.pl [Thu May 07
20:01:44.572553 2015] [authz_core:debug] [pid 477:tid 140496072591104]
mod_authz_core.c(809): [client 10.0.0.13:60209] AH01626: authorization
result of <RequireAny>: granted, referer:
http://10.0.0.23/ledgersmb/setup.pl DBD::Pg::st execute failed: ERROR:
function public.setting_get(unknown) does not exist LINE 1: SELECT *
FROM "public"."setting_get"('ignore_version') ^ HINT:  No function
matches the given name and argument types. You might need to add
explicit type casts. at LedgerSMB.pm line 586. 2015/05/07 20:01:45 -
ERROR - LedgerSMB::dberror LedgerSMB.pm (773) -- Logging SQL State
42883, error 7, string ERROR:  function public.setting_get(unknown)
does not exist LINE 1: SELECT * FROM
"public"."setting_get"('ignore_version') ^ HINT:  No function matches
the given name and argument types. You might need to add explicit type
casts. 2015/05/07 20:01:45 - ERROR - LedgerSMB::_error LedgerSMB.pm
(650) -- Internal Database Error More information has been reported in
the error logs at LedgerSMB.pm line 776. 2015/05/07 20:01:45 - ERROR -
LedgerSMB::_error LedgerSMB.pm (651) -- dbversion: 1.4.11, company:
postgres [Thu May 07 20:01:45.591271 2015] [deflate:debug] [pid 477:tid
140496072591104] mod_deflate.c(855): [client 10.0.0.13:60209] AH01384:
Zlib: Compressed 301 to 215 : URL /ledgersmb/login.pl, referer:
http://10.0.0.23/ledgersmb/setup.pl [Thu May 07 20:01:45.598008 2015]
[authz_core:debug] [pid 477:tid 140496064198400] mod_authz_core.c(809):
[client 10.0.0.13:60211] AH01626: authorization result of Require ip
127.0.0.1: denied, referer: http://10.0.0.23/ledgersmb/setup.pl [Thu
May 07 20:01:45.605644 2015] [authz_core:debug] [pid 478:tid
140496080983808] mod_authz_core.c(809): [client 10.0.0.13:60212]
AH01626: authorization result of Require ip 127.0.0.1: denied, referer:
http://10.0.0.23/ledgersmb/setup.pl [Thu May 07 20:01:45.642098 2015]
[authz_host:error] [pid 477:tid 140496064198400] [client
10.0.0.13:60211] AH01753: access check of 'localhost'
to /ledgersmb/setup.pl failed, reason: unable to get the remote host
name, referer: http://10.0.0.23/ledgersmb/setup.pl [Thu May 07
20:01:45.642149 2015] [authz_core:debug] [pid 477:tid 140496064198400]
mod_authz_core.c(809): [client 10.0.0.13:60211] AH01626: authorization
result of Require host localhost: denied, referer:
http://10.0.0.23/ledgersmb/setup.pl [Thu May 07 20:01:45.642158 2015]
[authz_core:debug] [pid 477:tid 140496064198400] mod_authz_core.c(809):
[client 10.0.0.13:60211] AH01626: authorization result of Require ip
10.0.0.0/255.255.255.0: granted, referer:
http://10.0.0.23/ledgersmb/setup.pl [Thu May 07 20:01:45.642164 2015]
[authz_core:debug] [pid 477:tid 140496064198400] mod_authz_core.c(809):
[client 10.0.0.13:60211] AH01626: authorization result of <RequireAny>:
granted, referer: http://10.0.0.23/ledgersmb/setup.pl [Thu May 07
20:01:45.665984 2015] [authz_host:error] [pid 478:tid 140496080983808]
[client 10.0.0.13:60212] AH01753: access check of 'localhost'
to /ledgersmb/setup.pl failed, reason: unable to get the remote host
name, referer: http://10.0.0.23/ledgersmb/setup.pl [Thu May 07
20:01:45.666027 2015] [authz_core:debug] [pid 478:tid 140496080983808]
mod_authz_core.c(809): [client 10.0.0.13:60212] AH01626: authorization
result of Require host localhost: denied, referer:
http://10.0.0.23/ledgersmb/setup.pl [Thu May 07 20:01:45.666036 2015]
[authz_core:debug] [pid 478:tid 140496080983808] mod_authz_core.c(809):
[client 10.0.0.13:60212] AH01626: authorization result of Require ip
10.0.0.0/255.255.255.0: granted, referer:
http://10.0.0.23/ledgersmb/setup.pl [Thu May 07 20:01:45.666042 2015]
[authz_core:debug] [pid 478:tid 140496080983808] mod_authz_core.c(809):
[client 10.0.0.13:60212] AH01626: authorization result of <RequireAny>:
granted, referer: http://10.0.0.23/ledgersmb/setup.pl DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist LINE 1:
SELECT value FROM defaults WHERE setting_key = $1 ^ at
LedgerSMB/Database.pm line 408. DBD::Pg::st fetchrow_hashref failed: no
statement executing at LedgerSMB/Database.pm line 409. DBD::Pg::st
execute failed: ERROR:  relation "defaults" does not exist LINE 1:
SELECT fldvalue FROM defaults WHERE fldname = $1 ^ at
LedgerSMB/Database.pm line 430. DBD::Pg::st fetchrow_hashref failed: no
statement executing at LedgerSMB/Database.pm line 431.

What bothers me is this line
authorization result of Require host localhost: denied and
authorization result of Require ip 127.0.0.1: denied
I also saw this 1.3.46

Interestingly Ledgersmb gave password permission problems when I
commented out 127.0.0.1

> > Apache2 in Debian needs a modification to get localhost and
> > 127.0.0.1 to work.
> 
>    Why do you think so?

Some thing I read when I was trying to remember/solve the ServerName
syntax 

and postgresql errors

\2015-05-07 20:01:45 EDT [577-1] postgres@postgres ERROR:  function
public.setting_get(unknown) does not exist at character 15 2015-05-07
20:01:45 EDT [577-2] postgres@postgres HINT:  No function matches the
given name and argument types. You might need to add explicit type
casts. 2015-05-07 20:01:45 EDT [577-3] postgres@postgres STATEMENT:
SELECT * FROM "public"."setting_get"('ignore_version') 2015-05-07
20:01:47 EDT [583-1] postgres@try1 ERROR:  relation "defaults" does not
exist at character 19 2015-05-07 20:01:47 EDT [583-2] postgres@try1
STATEMENT:  SELECT value FROM defaults WHERE setting_key = $1
2015-05-07 20:01:47 EDT [583-3] postgres@try1 ERROR:  relation
"defaults" does not exist at character 22 2015-05-07 20:01:47 EDT
[583-4] postgres@try1 STATEMENT:  SELECT fldvalue FROM defaults WHERE
fldname = $1

Any way I am still having trouble connecting to the database

Geordie

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users