Menu
▾
▴
sql-ledger-users
|
From: Michael H. <mh...@it...> - 2007-12-10 08:46:23
|
Hi Everybody,
Anybody else have trouble running trial balance or income
statement reports after upgrading to 2.8.8?
Don't believe anything else has changed on the server but now we
get an Apache error just for those two reports:
Internal Server Error
The server encountered an internal error or misconfiguration and was
unable to complete your request.
Please contact the server administrator, root@localhost and inform
them of the time the error occurred, and anything you might have done
that may have caused the error.
More information about this error may be available in the server
error log.
Apache/2.0.54 (Fedora) Server at itwerx.net Port 1080
We're on a cash basis if that helps, and everything else seems to be
working fine. Also noticed it takes a rather long time before the
error returns.
Thanks,
Michael
|
|
From: William M. <wi...@kn...> - 2007-12-10 14:01:08
|
On Mon, Dec 10, 2007 at 12:45:50AM -0800, Michael Hasse wrote: > Anybody else have trouble running trial balance or income > statement reports after upgrading to 2.8.8? I haven't seen this problem. We use accrual system. The output from your apache error log would greatly help. William -- Knowmad Technologies - Web Site Development & Programming W: http://www.knowmad.com | E: wi...@kn... P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee |
|
From: Michael H. <mh...@it...> - 2008-01-04 00:13:31
|
Hi William,
Thanks for the reply, and apologies for the slow response!
Here's the relevant httpd/error_log entry:
[Thu Jan 03 16:08:26 2008] [error] [client 192.168.1.212] Premature
end of script headers: rp.pl, referer: http://mydomain.net:8080/sql-
ledger/rp.pl?path=bin/mozilla&action=report&level=Reports--Income%
20Statement&login=acctg&js=1&report=income_statement
Thanks!
Michael
On Dec 10, 2007, at 6:00 AM, William McKee wrote:
> On Mon, Dec 10, 2007 at 12:45:50AM -0800, Michael Hasse wrote:
>> Anybody else have trouble running trial balance or income
>> statement reports after upgrading to 2.8.8?
>
> I haven't seen this problem. We use accrual system. The output from
> your apache error log would greatly help.
>
>
> William
>
> --
> Knowmad Technologies - Web Site Development & Programming
> W: http://www.knowmad.com | E: wi...@kn...
> P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee
>
> ----------------------------------------------------------------------
> ---
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
|
|
From: William M. <wi...@kn...> - 2008-01-07 20:55:08
|
On Thu, Jan 03, 2008 at 04:12:58PM -0800, Michael Hasse wrote: > [Thu Jan 03 16:08:26 2008] [error] [client 192.168.1.212] Premature > end of script headers: rp.pl, referer: http://mydomain.net:8080/sql- > ledger/rp.pl?path=bin/mozilla&action=report&level=Reports--Income% > 20Statement&login=acctg&js=1&report=income_statement Premature end of script headers usu indicates a problem with Apache configuration. Make sure that the script is set to executable. If you have suexec enabled in your Apache config, you'll want to read the suexec docs[1] for the reasons you could be getting this error. Good luck, William [1] http://httpd.apache.org/docs/2.0/suexec.html -- Knowmad Technologies - Web Site Development & Programming W: http://www.knowmad.com | E: wi...@kn... P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee |
|
From: Michael H. <mh...@it...> - 2008-01-07 21:21:36
|
We'll certainly check that, but why would it be any different for 2.8.x vs 2.6.x...? Maybe a new script file brought down during the upgrade that got defaulted to the wrong perms? Thanks, Michael On Jan 7, 2008, at 12:55 PM, William McKee wrote: > On Thu, Jan 03, 2008 at 04:12:58PM -0800, Michael Hasse wrote: >> [Thu Jan 03 16:08:26 2008] [error] [client 192.168.1.212] Premature >> end of script headers: rp.pl, referer: http://mydomain.net:8080/sql- >> ledger/rp.pl?path=bin/mozilla&action=report&level=Reports--Income% >> 20Statement&login=acctg&js=1&report=income_statement > > Premature end of script headers usu indicates a problem with Apache > configuration. Make sure that the script is set to executable. If you > have suexec enabled in your Apache config, you'll want to read the > suexec docs[1] for the reasons you could be getting this error. > > > Good luck, > William > > [1] http://httpd.apache.org/docs/2.0/suexec.html > > -- > Knowmad Technologies - Web Site Development & Programming > W: http://www.knowmad.com | E: wi...@kn... > P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee > > ---------------------------------------------------------------------- > --- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/ > marketplace > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Michael H. <mh...@it...> - 2008-01-08 05:34:54
|
Just an update on this. Permissions are all fine and the reports run
with no problems in our test company. Reading up a bit on the errors
it looks like a simple timeout problem where Apache is giving up on
the script before it finishes due to the amount of data we have
slowing the script down. (System resources are okay so we're not
running out of memory or anything).
Suggestions/advice are welcome and we'll keep plugging away at it
and post back if we figure it out.
Thanks,
Michael
On Jan 7, 2008, at 1:21 PM, Michael Hasse wrote:
> We'll certainly check that, but why would it be any different for
> 2.8.x vs 2.6.x...? Maybe a new script file brought down during the
> upgrade that got defaulted to the wrong perms?
>
>
> Thanks,
>
> Michael
>
>
>
> On Jan 7, 2008, at 12:55 PM, William McKee wrote:
>
>> On Thu, Jan 03, 2008 at 04:12:58PM -0800, Michael Hasse wrote:
>>> [Thu Jan 03 16:08:26 2008] [error] [client 192.168.1.212] Premature
>>> end of script headers: rp.pl, referer: http://mydomain.net:8080/sql-
>>> ledger/rp.pl?path=bin/mozilla&action=report&level=Reports--Income%
>>> 20Statement&login=acctg&js=1&report=income_statement
>>
>> Premature end of script headers usu indicates a problem with Apache
>> configuration. Make sure that the script is set to executable. If you
>> have suexec enabled in your Apache config, you'll want to read the
>> suexec docs[1] for the reasons you could be getting this error.
>>
>>
>> Good luck,
>> William
>>
>> [1] http://httpd.apache.org/docs/2.0/suexec.html
>>
>> --
>> Knowmad Technologies - Web Site Development & Programming
>> W: http://www.knowmad.com | E: wi...@kn...
>> P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee
>>
>> ---------------------------------------------------------------------
>> -
>> ---
>> Check out the new SourceForge.net Marketplace.
>> It's the best place to buy or sell services for
>> just about anything Open Source.
>> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/
>> marketplace
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ----------------------------------------------------------------------
> ---
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/
> marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
|
|
From: William M. <wi...@kn...> - 2008-01-08 14:01:46
|
On Mon, Jan 07, 2008 at 09:34:39PM -0800, Michael Hasse wrote: > Just an update on this. Permissions are all fine and the reports run > with no problems in our test company. Reading up a bit on the errors > it looks like a simple timeout problem where Apache is giving up on > the script before it finishes due to the amount of data we have > slowing the script down. (System resources are okay so we're not > running out of memory or anything). Interesting, I hadn't considered timeout error causing that message. > Suggestions/advice are welcome and we'll keep plugging away at it > and post back if we figure it out. Have you checked out the TimeOut directive[1]? I've seen some people comment the TimeOut does not affect CGI scripts, but Apache security tips[2] say the following: "As TimeOut is currently used for several different operations, setting it to a low value introduces problems with long running CGI scripts." I've seen others suggest using FastCGI. Keep us posted on your progress. Good luck, William [1] http://httpd.apache.org/docs/2.0/mod/core.html#timeout [2] http://httpd.apache.org/docs/trunk/misc/security_tips.html#dos -- Knowmad Technologies - Web Site Development & Programming W: http://www.knowmad.com | E: wi...@kn... P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee |
|
From: Michael H. <mh...@it...> - 2008-07-03 05:51:30
|
Months later, I'm getting back to this, (prodded by tax deadlines of
course! :)
I did check the timeout directive and raised it to some
ridiculous level to no avail, (and same duration of wait so I don't
think that's it).
Also don't think it's a record count issue as it was working fine
right up a month or two before the upgrade and we don't do THAT much
business.
I also opened a terminal session to the host server and watched
the stats as it was running and there were no issues with memory/swap/
etc running out or anything like that.
Somebody suggested checking another company in the system, (good
idea, my apologies for not doing that before posting! Brain fade...).
Unfortunately that company works just fine so I have to assume at
this point that I have a corrupt record somewhere/somehow.
So now the question is - are there any sort of scripts that can
be run to do a sanity check? Has anybody had to deal with bad
records and might have some tips to save a few hours of poring over
the DB structure?
Thanks!!!!!!!!!!!!
Michael
On Jan 8, 2008, at 6:01 AM, William McKee wrote:
> On Mon, Jan 07, 2008 at 09:34:39PM -0800, Michael Hasse wrote:
>> Just an update on this. Permissions are all fine and the reports run
>> with no problems in our test company. Reading up a bit on the errors
>> it looks like a simple timeout problem where Apache is giving up on
>> the script before it finishes due to the amount of data we have
>> slowing the script down. (System resources are okay so we're not
>> running out of memory or anything).
>
> Interesting, I hadn't considered timeout error causing that message.
>
>
>> Suggestions/advice are welcome and we'll keep plugging away at it
>> and post back if we figure it out.
>
> Have you checked out the TimeOut directive[1]? I've seen some people
> comment the TimeOut does not affect CGI scripts, but Apache security
> tips[2] say the following:
>
> "As TimeOut is currently used for several different operations,
> setting
> it to a low value introduces problems with long running CGI scripts."
>
> I've seen others suggest using FastCGI. Keep us posted on your
> progress.
>
>
> Good luck,
> William
>
> [1] http://httpd.apache.org/docs/2.0/mod/core.html#timeout
> [2] http://httpd.apache.org/docs/trunk/misc/security_tips.html#dos
>
> --
> Knowmad Technologies - Web Site Development & Programming
> W: http://www.knowmad.com | E: wi...@kn...
> P: 704.343.9330 | http://www.LinkedIn.com/in/williammckee
>
> ----------------------------------------------------------------------
> ---
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/
> marketplace
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X