Open-AudIT
https://www.open-audit.org/phpBB3/

[FIXED] installed software report ERR_CONNECTION_RESET error
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6431
Page 1 of 1

Author:  shanimal [ Fri Apr 10, 2015 5:20 am ]
Post subject:  [FIXED] installed software report ERR_CONNECTION_RESET error

Hi-
Not sure when this started but recently I was asked to run some reports on installed software. Unable to generate this report with Community and Enterprise editions, error is the same and attached. Running version 1.6.2
thanks

p.s. I deleted all alerts but no change, issue still exists

Attachments:
OAE-Reset.JPG
OAE-Reset.JPG [ 56.11 KiB | Viewed 4229 times ]
OAC-Reset.JPG
OAC-Reset.JPG [ 58.88 KiB | Viewed 4229 times ]

Author:  Mark [ Fri Apr 10, 2015 9:09 am ]
Post subject:  Re: [help] installed software report ERR_CONNECTION_RESET er

I'd suspect it's timing out.
How many computers (Win / Lin / OSX / AIX / etc) in your DB?
A linux PC can have literally a couple of thousand of software entries.

I am working on enabling paging in dataTables. Hence the front end would request 10 / 100 / 1000 rows at a time and be much more responsive. Currently it simply downloads ALL rows to the browser - which if there are 10's of thousands.....

You could look at the php.ini and extend the timeouts. Specifically check out max_execution_time and memory_limit. And naturally you can always throw more hardware at it :-)

Another thing to check is the non-current rows in the database. You can see them on the menu -> Admin -> Database Maintenance page. You can also click the X icon and delete them.

Author:  shanimal [ Fri Apr 10, 2015 11:56 pm ]
Post subject:  Re: [help] installed software report ERR_CONNECTION_RESET er

I think that was it. We have @ 500 systems and 25 of those are RHEL and I added most of these recently which probably caused this. I changed the timeout, bumped up the memory setting, and fixed the timezone in the php.ini and restarted apache, now I have access to installed software list again. You are correct, the list is huge. Thank you

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/