Re: setup.pl error in LedgerSMB 1.4-b5

[Paul Bente <..hidden..>]

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