Re: ledgersmb/setup.pl error

[Geordie <..hidden..>]

On Thu, 9 Apr 2015 22:45:27 -0400
Geordie <..hidden..> wrote:

> Hi
> Apparently something is amiss
> for I get this
> 
> Error!
> 
> Base schema failed to load at LedgerSMB/Database.pm line 614.
> 
> dbversion: 1.4.10, company: 
> 
> This is after the page asked to create a new database
> 
> Directions
> 
> thanks
> Geordie
> 
> ------------------------------------------------------------------------------
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live
> exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual-
> event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
> _______________________________________________ Ledger-smb-users
> mailing list ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

More information
Error Logs
Postgres
 ledgersmb@postgres ERROR:  function public.setting_get(unknown) does
not exist at character 15 2015-04-10 12:10:35 EDT [1520-2]
ledgersmb@postgres HINT:  No function matches the given name and
argument types. You might need to add explicit type casts. 2015-04-10
12:10:35 EDT [1520-3] ledgersmb@postgres STATEMENT:  SELECT * FROM
"public"."setting_get"('ignore_version') 2015-04-10 12:10:37 EDT
[1523-1] ledgersmb@Services FATAL:  database "Services" does not exist

Apache 2 error

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/04/10
12:24:55 - 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/04/10 12:24:55 - ERROR - LedgerSMB::_error LedgerSMB.pm
(650) -- Internal Database Error More information has been reported in
the error logs at LedgerSMB.pm line 776. 2015/04/10 12:24:55 - ERROR -
LedgerSMB::_error LedgerSMB.pm (651) -- dbversion: 1.4.10, company:
postgres


I added this stanza to /etc/apache2/conf-available/ledgersmb-httpd.conf

<Directory /usr/local/ledgersmb/css>
  Require ip 10.0.0.20/255.255.255.0
  Require all denied
</Directory>

and I received this error

[Fri Apr 10 12:25:27.124800 2015] [autoindex:error] [pid 1652:tid
139956869654272] [client 10.0.0.13:46311] AH01276: Cannot serve
directory /usr/local/ledgersmb/css/: No matching DirectoryIndex
(index.html,index.cgi,index.pl,index.php,index.xhtml,index.htm) found,
and server-generated directory index forbidden by Options directive,
referer: http://10.0.0.20/ledgersmb/setup.pl


/tmp/dbi.trace

HINT:  No function matches the given name and argument types. You might
need to add explicit type casts." (err#0) <-
DESTROY(DBI::st=HASH(0x47985b0))= ( undef ) [1 items] at LedgerSMB.pm
line 776 !! The ERROR '7' was CLEARED by call to commit method <-
commit= ( 1 ) [1 items] at App_State.pm line 172 <- disconnect= ( 1 )
[1 items] at App_State.pm line 173 <- disconnect= ( 1 ) [1 items] at
lsmb-request.pl line 89 <- DESTROY(DBI::db=HASH(0x4793588))= ( undef )
[1 items] at login.pl line 8 DBI::db=HASH(0x3bcce00) trace level set to
0x0/1 (DBI @ 0x0/0) in DBI 1.631-ithread (pid 1742) <- prepare('SELECT
* FROM "public"."setting_get"(?)')= ( DBI::st=HASH(0x3bd13a8) ) [1
items] at LedgerSMB.pm line 561 <- bind_param(1, 'ignore_version')= ( 1
) [1 items] at LedgerSMB.pm line 582 !! ERROR: 7 "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." (err#0) <- execute= ( undef ) [1 items] at LedgerSMB.pm line
586 ERROR: 7 "ERROR:  function public.setting_get(unknown) does not
exist LINE 1: SELECT * FROM "public"."setting_get"('ignore_version') ^

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users