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

Re: Ledger-smb-users Digest, Vol 63, Issue 5





On Mon, Dec 5, 2011 at 6:41 AM, <..hidden..> wrote:
Send Ledger-smb-users mailing list submissions to
       ..hidden..

To subscribe or unsubscribe via the World Wide Web, visit
       https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
or, via email, send a message with subject or body 'help' to
       ..hidden..

You can reach the person managing the list at
       ..hidden..

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Ledger-smb-users digest..."


Today's Topics:

  1. Re: Performance Issues w/Ledgersmb 1.3.x (Steven Marshall)
  2. Re: Performance Issues w/Ledgersmb 1.3.x (Steven Marshall)
  3. Premature end of script headers: setup.pl (Steven Marshall)
  4. Re: Premature end of script headers: setup.pl (Steven Marshall)


----------------------------------------------------------------------

Message: 1
Date: Sun, 4 Dec 2011 15:11:45 -0200
From: Steven Marshall <..hidden..>
Subject: Re: [Ledger-smb-users] Performance Issues w/Ledgersmb 1.3.x
To: "..hidden.."
       <..hidden..>
Message-ID: <..hidden..>
Content-Type: text/plain; charset="iso-8859-1"

Setup.pl initial load (login page) doesn't hit PostgreSQL so we can

rule that part out.


Anything prior to login is basically mostly loading the relevant Perl

libs, rendering the template and sending it to the browser.


So a few notes on your test cases:

1)  There seems to be significant overhead to sending it out over the

network (adding 9 sec. to average load time)

2)  You don't see a lot of CPU time so what are your load averages?

In particular what percentage of CPU time is spent waiting for I/O

returns?  There's a lot more I/O in the cases where you are having

trouble than in the other cases.  Is something up there?


Typically I would start by watching top while you are running these

tests.  Looking at general CPU stats, plus anything going on in the

process list.  High wait times would be consistent with some sort of

I/O problem.  But something is going on....


If that failed, I would filter the process list only to those owned by


Thanks, that helps me better understand where to begin looking.  I
will follow your suggestions and see what I can find.


I found something very interesting. I created a test HTML page containing
solely text called testpage.html.  I dropped this file in two locations.
 One in the Apache root directory (/srv/www/htdocs/) and the other in the
ledgersmb directory (/user/local/ledgersmb/).  I changed ownership of the
file to wwwrun:www.  I then ran the following tests:

*Test 1:*
*
*
*URL*: http://192.168.1.10/testpage.html

*Results*: Page loaded almost instantaneously.


*Test 2:*

*URL*: http://192.168.1.10/ledgersmb/testpage.html

*Results*: Page loaded in about 14 seconds

It seems to be choking on page loads for files that reside in the ledgersmb
directory.  My ledgersmb-httpd.conf is located in my ledgersmb directory at
/usr/local/ledgersmb.  I had added my "Include
/usr/local/ledgersmb/ledgersmb-httpd.conf" to the bottom of
default-server.conf.

Steven
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 2
Date: Sun, 4 Dec 2011 18:18:39 -0200
From: Steven Marshall <..hidden..>
Subject: Re: [Ledger-smb-users] Performance Issues w/Ledgersmb 1.3.x
To: "..hidden.."
       <..hidden..>
Message-ID:
       <CAMBekoP73Y8n6CmYjcKWJyFR=..hidden..>
Content-Type: text/plain; charset="iso-8859-1"

>
> I found something very interesting. I created a test HTML page containing
> solely text called testpage.html.  I dropped this file in two locations.
>  One in the Apache root directory (/srv/www/htdocs/) and the other in the
> ledgersmb directory (/user/local/ledgersmb/).  I changed ownership of the
> file to wwwrun:www.  I then ran the following tests:
>
> *Test 1:*
> *
> *
> *URL*: http://192.168.1.10/testpage.html
>
> *Results*: Page loaded almost instantaneously.
>
>
> *Test 2:*
>
> *URL*: http://192.168.1.10/ledgersmb/testpage.html
>
> *Results*: Page loaded in about 14 seconds
>
> It seems to be choking on page loads for files that reside in the
> ledgersmb directory.  My ledgersmb-httpd.conf is located in my ledgersmb
> directory at /usr/local/ledgersmb.  I had added my "Include
> /usr/local/ledgersmb/ledgersmb-httpd.conf" to the bottom of
> default-server.conf.
>
> Steven
>

I believe I have solved the issue.  I am still testing just to make sure,
but it appears that my issue was in ledgersmb-httpd.conf.  In the section
where by default you "Allow from localhost", I had changed to the following
adding two additional "Allow from" statements so that I could connect
remotely to Ledgersmb:

Order Deny, Allow
Allow from 127.0.0.1
Allow from localhost
Allow from 192.168.1
Deny from All
.
.
.

It appears that it was struggling with the multiple "Allow from"
statements. Based on Apache documentation I believe I should have been able
to do it this way, but I decided to change it to the following, using just
one "Allow from" statement and separating the addresses with spaces, and my
performance issue cleared up.  This is what my modified version that works
looks like:

Order Deny, Allow
Allow from 192.168.1 localhost 127.0.0.1
Deny from All


--
Best Regards,
Steven Marshall
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 3
Date: Sun, 4 Dec 2011 20:29:35 -0200
From: Steven Marshall <..hidden..>
Subject: [Ledger-smb-users] Premature end of script headers: setup.pl
To: ..hidden..
Message-ID:
       <..hidden..>
Content-Type: text/plain; charset="iso-8859-1"

Just setup and brand new Ledgersmb 1.3.7 server with PostgreSQL 9.1 and
Perl 5.14.2.  Ran setup.pl via the browser.  I get to the last step and
when I click Next, I get the following error:
Server error!

The server encountered an internal error and was unable to complete your
request.

Error message:
Premature end of script headers: setup.pl

If you think this is a server error, please contact the
webmaster<..hidden..>
.
Error 500192.168.1.10
Sun 04 Dec 2011 08:07:16 PM BRST
Apache/2.2.21 (Linux/SUSE)


In my Apache error_log file I get the following errors:

[Sun Dec 04 20:06:44 2011] [error] [client 192.168.1.51] sh:
/tmp/ledgersmb/dblog: No such file or directory, referer:
http://192.168.1.10/ledgersmb/setup.pl
[Sun Dec 04 20:07:18 2011] [error] [client 192.168.1.51] DBI
connect('dbname=StallusBoutique_Test','',...) failed: FATAL:  database
"StallusBoutique_Test" does not exist at scripts/setup.pl line 535,
referer: http://192.168.1.10/ledgersmb/setup.pl
[Sun Dec 04 20:07:18 2011] [error] [client 192.168.1.51] Can't call method
"quote_identifier" on an undefined value at
/usr/lib/perl5/site_perl/5.14.2/LedgerSMB.pm line 767., referer:
http://192.168.1.10/ledgersmb/setup.pl
[Sun Dec 04 20:07:18 2011] [error] [client 192.168.1.51] Compilation failed
in require at /usr/local/ledgersmb/setup.pl line 8., referer:
http://192.168.1.10/ledgersmb/setup.pl
[Sun Dec 04 20:07:18 2011] [error] [client 192.168.1.51] Premature end of
script headers: setup.pl, referer: http://192.168.1.10/ledgersmb/setup.pl


My database is not created.  I also noticed that the log file dblog also
doesn't get created so not sure where else to look for additional logging.
 I was previously successful creating a company database with an earlier
version of Ledgersmb and PostgreSQL 9.0, but had to setup new server with
the newer version of PostgreSQL 9.1.  Not sure if that might be related.  I
didn't set the contrib parameter in ledgersmb.conf since PostgreSQL 9.1
doesn't have one.  It does still have the default value though.
--
Best Regards,
Steven Marshall
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

Message: 4
Date: Sun, 4 Dec 2011 20:41:39 -0200
From: Steven Marshall <..hidden..>
Subject: Re: [Ledger-smb-users] Premature end of script headers:
       setup.pl
To: "..hidden.."
       <..hidden..>
Message-ID: <..hidden..>
Content-Type: text/plain; charset="iso-8859-1"

On Dec 4, 2011, at 8:30 PM, Steven Marshall <..hidden..>
wrote:

Just setup and brand new Ledgersmb 1.3.7 server with PostgreSQL 9.1 and
Perl 5.14.2.  Ran setup.pl via the browser.  I get to the last step and
when I click Next, I get the following error:
Server error!

The server encountered an internal error and was unable to complete your
request.

Error message:
Premature end of script headers: setup.pl

If you think this is a server error, please contact the
webmaster<..hidden..>
.
Error 500192.168.1.10
Sun 04 Dec 2011 08:07:16 PM BRST
Apache/2.2.21 (Linux/SUSE)


In my Apache error_log file I get the following errors:

[Sun Dec 04 20:06:44 2011] [error] [client 192.168.1.51] sh:
/tmp/ledgersmb/dblog: No such file or directory, referer:
http://192.168.1.10/ledgersmb/setup.pl
[Sun Dec 04 20:07:18 2011] [error] [client 192.168.1.51] DBI
connect('dbname=StallusBoutique_Test','',...) failed: FATAL:  database
"StallusBoutique_Test" does not exist at scripts/setup.pl line 535,
referer: http://192.168.1.10/ledgersmb/setup.pl
[Sun Dec 04 20:07:18 2011] [error] [client 192.168.1.51] Can't call method
"quote_identifier" on an undefined value at
/usr/lib/perl5/site_perl/5.14.2/LedgerSMB.pm line 767., referer:
http://192.168.1.10/ledgersmb/setup.pl
[Sun Dec 04 20:07:18 2011] [error] [client 192.168.1.51] Compilation failed
in require at /usr/local/ledgersmb/setup.pl line 8., referer:
http://192.168.1.10/ledgersmb/setup.pl
[Sun Dec 04 20:07:18 2011] [error] [client 192.168.1.51] Premature end of
script headers: setup.pl, referer: http://192.168.1.10/ledgersmb/setup.pl


My database is not created.  I also noticed that the log file dblog also
doesn't get created so not sure where else to look for additional logging.
 I was previously successful creating a company database with an earlier
version of Ledgersmb and PostgreSQL 9.0, but had to setup new server with
the newer version of PostgreSQL 9.1.  Not sure if that might be related.  I
didn't set the contrib parameter in ledgersmb.conf since PostgreSQL 9.1
doesn't have one.  It does still have the default value though.
Steven you need contrib according to me (i am not professional engineer)
Pls take a look at the following lines which are in the Ubuntu tutorial. If I did not use this no database loaded!

sudo gedit /usr/local/ledgersmb/ledgersmb.conf

Change line 79 /usr/share/pgsql/contrib into /usr/share/postgresql/8.4/contrib

Maybe option to use postgres-8.4


Kind regards

Frans


--
Best Regards,
Steven Marshall



------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


As a followup, I just recalled that in an earlier version of Ledgersmb
1.3.x, one of the steps in setup.pl was to create a user and select their
permissions.  That step was missing in my case using version 1.3.7.  I'm
not sure if that is related but wanted to mention it.
-------------- next part --------------
An HTML attachment was scrubbed...

------------------------------

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d

------------------------------

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


End of Ledger-smb-users Digest, Vol 63, Issue 5
***********************************************