Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Thu Mar 28, 2024 11:25 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
PostPosted: Sat Nov 29, 2008 4:54 am 
Offline
Newbie

Joined: Tue Apr 01, 2008 12:16 am
Posts: 6
I am getting a timeout with list.php (it was still listing software after the 30 second time out occurred). Is there a way to increase the 30 second timeout so I can pull the full list? Below is the error. Thanks ahead of time!

Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\OpenAudit\list.php on line 400


Top
 Profile  
Reply with quote  
PostPosted: Mon Dec 01, 2008 7:22 am 
I have had problems with slow queries, a number of the tables are not indexed on the search and join fields. Have a look at my performance post in the bugs forum,
viewtopic.php?f=8&t=3054
The sql bit at the end should make some queries, in particular the software ones, faster.
If you haven't got mysql query browser, then you could use myphpadmin if you are running xampp

Rgds

Server Info: Windows XP running XAMPP

Auditing: 4400 machines, mainly windows XP
W2K3: Active Directory


Top
  
Reply with quote  
PostPosted: Thu Jun 18, 2009 11:25 pm 
Offline
Contributor
User avatar

Joined: Thu Mar 02, 2006 4:41 am
Posts: 205
Location: Massachusetts
I'm running with SVN 1173 and getting the following error when trying to pull up the software register:

Fatal error: Maximum execution time of 30 seconds exceeded in D:\wamp\www\OpenAudit\software_register.php on line 27

Here is line 27:

[code]$result = mysql_query($sql, $db);[/code]

I'm assuming I have all of the search fixes discussed in that link since I'm running with the latest SVN updates.

Other than this, everything else seems to be working flawless for my new OA install with the WINVentory data of 1700+ systems imported.

Thank you

_________________
Server Info: running on a CentOS 7 vm
OA Version: 2.0.6 @ 500 devices


Top
 Profile  
Reply with quote  
PostPosted: Fri Jun 19, 2009 2:50 am 
Offline
Open-AudIT Fellow

Joined: Thu May 17, 2007 5:47 pm
Posts: 568
Location: Italy
Try increasing the "max_execution_time" directive in your php.ini, then restart Apache.

_________________
Edoardo


Top
 Profile  
Reply with quote  
PostPosted: Fri Jun 19, 2009 2:55 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
This could be an issue with your php.ini file, so far as OA is concerned, the list function waits 4 mins +

This is at the start of list.php (you could later this bit of code, but as I say, I think the issue lies elsewhere)

[code]
...
include_once("include.php");
$time_start = microtime_float();
// set an initial 4 min extra timeout
set_time_limit(240000);

$count_system_max="10000";
...
[/code]

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


Top
 Profile  
Reply with quote  
PostPosted: Wed Dec 16, 2009 1:29 am 
Offline
Contributor
User avatar

Joined: Thu Mar 02, 2006 4:41 am
Posts: 205
Location: Massachusetts
Hi- I edited the php.ini to 200 and it still doesn't work?

Fatal error: Maximum execution time of 200 seconds exceeded in D:\wamp\www\OpenAudit\software_register.php on line 27

_________________
Server Info: running on a CentOS 7 vm
OA Version: 2.0.6 @ 500 devices


Top
 Profile  
Reply with quote  
PostPosted: Thu Dec 17, 2009 12:27 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
I would increase both the php.ini and the list.php values to say 10 mins and if the problem persists, you either have an enormous database, a slow server or a database corruption. You can run the query manually from the MySQL command line, or look in the MySQL logs for further clues.

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group