[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

setup.pl error in LedgerSMB 1.4-b5

Trying to install 1.4-b5 following the instructions in ledgersmb/INSTALL to use setup.pl to create a database.

I had a working ledgersmb-1.3.37 on Mac OS X 10.6, PostgreSQL 9.1.9, apache 2.2.22, Perl 5.8.9. Moved that ledgersmb directory to a backup and installed ledgersmb-1.4-b5 into directory ledgersmb. Edited ledgersmb-httpd.conf and ledgersmb.conf, ran sudo perl makefile.PL and sudo make install.

Run http://localhost/ledgersmb/setup.pl
Entered superuser: postgres with password and database: lsmbdb14.
It (correctly) stated database did not exist, would I like to create it? -> Yes

Error!
Base schema failed to load at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 605.
dbversion: 1.4.0, company:

psql shows that the database lsmbdb14 was created with owner postgres.

Apache error log has the following:

[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR:  function public.setting_get(unknown) does not exist, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] LINE 1: SELECT * FROM "public"."setting_get"('version'), referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1]                       ^, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] HINT:  No function matches the given name and argument types. You might need to add explicit type casts. at /Library/Perl/5.8.9/LedgerSMB.pm line 581., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] 2014/02/19 12:40:52 - ERROR - LedgerSMB::dberror /Library/Perl/5.8.9/LedgerSMB.pm (768) -- Logging SQL State 42883, error 7, string ERROR:  function public.setting_get(unknown) does not exist, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] LINE 1: SELECT * FROM "public"."setting_get"('version'), referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1]                       ^, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] HINT:  No function matches the given name and argument types. You might need to add explicit type casts., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] 2014/02/19 12:40:52 - ERROR - LedgerSMB::_error /Library/Perl/5.8.9/LedgerSMB.pm (645) -- Internal Database Error, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] More information has been reported in the error logs at /Library/Perl/5.8.9/LedgerSMB.pm line 771., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:52 2014] [error] [client 127.0.0.1] 2014/02/19 12:40:52 - ERROR - LedgerSMB::_error /Library/Perl/5.8.9/LedgerSMB.pm (646) -- dbversion: 1.4.0, company: template1, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:54 2014] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR:  relation "defaults" does not exist, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:54 2014] [error] [client 127.0.0.1] LINE 1: SELECT value FROM defaults WHERE setting_key = $1, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:54 2014] [error] [client 127.0.0.1]                           ^ at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 402., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:54 2014] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 403., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:54 2014] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR:  relation "defaults" does not exist, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:54 2014] [error] [client 127.0.0.1] LINE 1: SELECT fldvalue FROM defaults WHERE fldname = $1, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:54 2014] [error] [client 127.0.0.1]                              ^ at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 424., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:40:54 2014] [error] [client 127.0.0.1] DBD::Pg::st fetchrow_hashref failed: no statement executing at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 425., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] DBD::Pg::st execute failed: ERROR:  function public.setting_get(unknown) does not exist, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] LINE 1: SELECT * FROM "public"."setting_get"('version'), referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1]                       ^, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] HINT:  No function matches the given name and argument types. You might need to add explicit type casts. at /Library/Perl/5.8.9/LedgerSMB.pm line 581., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] 2014/02/19 12:42:02 - ERROR - LedgerSMB::dberror /Library/Perl/5.8.9/LedgerSMB.pm (768) -- Logging SQL State 42883, error 7, string ERROR:  function public.setting_get(unknown) does not exist, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] LINE 1: SELECT * FROM "public"."setting_get"('version'), referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1]                       ^, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] HINT:  No function matches the given name and argument types. You might need to add explicit type casts., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] 2014/02/19 12:42:02 - ERROR - LedgerSMB::_error /Library/Perl/5.8.9/LedgerSMB.pm (645) -- Internal Database Error, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] More information has been reported in the error logs at /Library/Perl/5.8.9/LedgerSMB.pm line 771., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:02 2014] [error] [client 127.0.0.1] 2014/02/19 12:42:02 - ERROR - LedgerSMB::_error /Library/Perl/5.8.9/LedgerSMB.pm (646) -- dbversion: 1.4.0, company: template1, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:04 2014] [error] [client 127.0.0.1] DBI connect('dbname="lsmbdb14"','postgres',...) failed: FATAL:  database "lsmbdb14" does not exist at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 108., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:04 2014] [error] [client 127.0.0.1] DBI connect('dbname="lsmbdb14"','postgres',...) failed: FATAL:  database "lsmbdb14" does not exist at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 108., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:41 2014] [error] [client 127.0.0.1] DBD::Pg::db do failed: ERROR:  language "plpgsql" already exists at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 574., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:41 2014] [error] [client 127.0.0.1] 2014/02/19 12:42:41 - ERROR - LedgerSMB::_error /Library/Perl/5.8.9/LedgerSMB.pm (645) -- Base schema failed to load at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 605., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:41 2014] [error] [client 127.0.0.1] 2014/02/19 12:42:41 - ERROR - LedgerSMB::_error /Library/Perl/5.8.9/LedgerSMB.pm (646) -- dbversion: 1.4.0, company: , referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:41 2014] [error] [client 127.0.0.1] Died at /Library/Perl/5.8.9/LedgerSMB.pm line 659., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:41 2014] [error] [client 127.0.0.1] Compilation failed in require at /Library/WebServer/Documents/ledgersmb/setup.pl line 8., referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:41 2014] [crit] [client 127.0.0.1] (13)Permission denied: /Library/WebServer/Documents/ledgersmb/css/gnome/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable, referer: http://localhost/ledgersmb/setup.pl
[Wed Feb 19 12:42:41 2014] [error] [client 127.0.0.1] File does not exist: /Library/WebServer/Documents/favicon.ico, referer: http://localhost/ledgersmb/setup.pl
 
Any ideas on completing this installation would be appreciated.

Best regards,
Paul Bente
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users