On Mon, Dec 5, 2011 at 6:41 AM, <
ledger-smb-users-requ...@lists.sourceforge.net> wrote:
> Send Ledger-smb-users mailing list submissions to
> ledger-smb-users@lists.sourceforge.net
>
> 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
> ledger-smb-users-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> ledger-smb-users-ow...@lists.sourceforge.net
>
> 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 <steven.marsh...@tatylee.com>
> Subject: Re: [Ledger-smb-users] Performance Issues w/Ledgersmb 1.3.x
> To: "ledger-smb-users@lists.sourceforge.net"
> <ledger-smb-users@lists.sourceforge.net>
> Message-ID: <-2911352646302640092@unknownmsgid>
> 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 <steven.marsh...@tatylee.com>
> Subject: Re: [Ledger-smb-users] Performance Issues w/Ledgersmb 1.3.x
> To: "ledger-smb-users@lists.sourceforge.net"
> <ledger-smb-users@lists.sourceforge.net>
> Message-ID:
> <CAMBekoP73Y8n6CmYjcKWJyFR=jdpajv9b2pvb5pyrazi9lk...@mail.gmail.com
> >
> 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 <steven.marsh...@tatylee.com>
> Subject: [Ledger-smb-users] Premature end of script headers: setup.pl
> To: ledger-smb-users@lists.sourceforge.net
> Message-ID:
> <cambekonomh9ewzfq33f3ez9_qefe0yvrleqlsvcjr_9oylu...@mail.gmail.com
> >
> 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<steven.marsh...@tekmerge.com>
> .
> 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 <steven.marsh...@tatylee.com>
> Subject: Re: [Ledger-smb-users] Premature end of script headers:
> setup.pl
> To: "ledger-smb-users@lists.sourceforge.net"
> <ledger-smb-users@lists.sourceforge.net>
> Message-ID: <7841493188343244475@unknownmsgid>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On Dec 4, 2011, at 8:30 PM, Steven Marshall <steven.marsh...@tatylee.com>
> 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<steven.marsh...@tekmerge.com>
> .
> 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
> Ledger-smb-users@lists.sourceforge.net
> 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
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
> End of Ledger-smb-users Digest, Vol 63, Issue 5
> ***********************************************
>
------------------------------------------------------------------------------
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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
