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 Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
