Chris- Thank you for the suggestion. I tried two approaches and in both cases the base schema failed to load.
1. I inserted ‘use Carp::Always’ at line 30 in setup.pm and ran http://locallhost/ledgersmb/setup.pl in the browser as before. Generated the same error. The apache error log for the sequence after I selected “Yes” to create the database lsmbdb141 (not sure why stack trace info does not appear): [Thu Feb 20 15:40:32 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 [Thu Feb 20 15:40:32 2014] [error] [client 127.0.0.1] 2014/02/20 15:40:32 - 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 [Thu Feb 20 15:40:32 2014] [error] [client 127.0.0.1] 2014/02/20 15:40:32 - ERROR - LedgerSMB::_error /Library/Perl/5.8.9/LedgerSMB.pm (646) -- dbversion: 1.4.0, company: , referer: http://localhost/ledgersmb/setup.pl [Thu Feb 20 15:40:32 2014] [error] [client 127.0.0.1] Died at /Library/Perl/5.8.9/LedgerSMB.pm line 659., referer:http://localhost/ledgersmb/setup.pl [Thu Feb 20 15:40:32 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 [Thu Feb 20 15:40:32 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 2. I also ran prepare-company-database.pl from the command line: new-host-5:admin /Library/WebServer/Documents/ledgersmb$ sudo perl -MCarp::Always ./tools/prepare-company-database.pl --company lsmb14 DBD::Pg::db do failed: ERROR: language "plpgsql" already exists at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 574. LedgerSMB::Database::load_base_schema(LedgerSMB::Database=HASH(0x275b654), HASH(0x277a550)) called at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 533 LedgerSMB::Database::create(LedgerSMB::Database=HASH(0x275b654), HASH(0x276a92c)) called at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 725 LedgerSMB::Database::create_and_load(LedgerSMB::Database=HASH(0x275b654)) called at ./tools/prepare-company-database.pl line 154 Base schema failed to load at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 605. LedgerSMB::Database::load_base_schema(LedgerSMB::Database=HASH(0x275b654), HASH(0x277a550)) called at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 533 LedgerSMB::Database::create(LedgerSMB::Database=HASH(0x275b654), HASH(0x276a92c)) called at /Library/Perl/5.8.9/LedgerSMB/Database.pm line 725 LedgerSMB::Database::create_and_load(LedgerSMB::Database=HASH(0x275b654)) called at ./tools/prepare-company-database.pl line 154 In both cases the databases were created but the schemas were not loaded. postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ------------+-----------+----------+---------+-------+----------------------- lsmb14 | ledgersmb | UTF8 | C | C | lsmbdb14 | postgres | UTF8 | C | C | lsmbdb141 | postgres | UTF8 | C | C | merlintest | postgres | UTF8 | C | C | postgres | postgres | UTF8 | C | C | template0 | postgres | UTF8 | C | C | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | C | C | =c/postgres + | | | | | postgres=CTc/postgres (7 rows) (merlintest is the 1.3.37 db) Could this be a PostgreSQL problem? Best regards, Paul Bente On Feb 20, at 5:37 Chris Travers wrote: >That's really strange. I tried to reproduce and couldn't. > >If you have Carp::Always installed you can modify the LedgerSMB/Scripts/ >setup.pm and add the following line: > >use Carp::Always; > >Then your error message will be complete with a full stack trace, which >might enable us to narrow down your problem. ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
