CGI's Stopped working. How to debug.

[Cian O'Sullivan]

Follow UP.
 
I turned logging on the MySQLD on temoprairly and could see the queries in the log file.
 
I noticed the query had the wrong name for the database.
 
040714  1:04:41      12 Connect     cian at HOSTNAME on mysql
                     12 Query       SELECT UNIX_TIMESTAMP(last_update) AS last_update, UNIX_TIMESTAMP(program_start) AS program_start, nagios_pid, daemon_mode, UNIX_TIMESTAMP(last_command_check) AS last_command_check, UNIX_TIMESTAMP(last_log_rotation) AS last_log_rotation, enable_notifications, execute_service_checks, accept_passive_service_checks, enable_event_handlers, obsess_over_services, enable_flap_detection, enable_failure_prediction, process_performance_data FROM programstatus
 
should be listed as nagios.  I dont know how my cgi.cfg changed but the databse was listed as mysql instead of nagios.
 
Going to see if NagMIN did it.
 

	-----Original Message----- 
	From: nagios-users-admin at lists.sourceforge.net on behalf of Cian O'Sullivan 
	Sent: Tue 7/13/2004 11:35 PM 
	To: nagios-users at lists.sourceforge.net 
	Cc: 
	Subject: [Nagios-users] CGI's Stopped working. How to debug.
	
	

	Hello,
	
	I have Nagios 1.2 Compiled with DB support (MySQL).  My CGI's all of a sudden stopped working giving me a Whoops!  Error: Could not read host and status information.  This literally happened in front of my eyes on an auto web refresh.
	
	The Database is working fine, and Nagios is writting to it properly. 
	
	I have checked teh CGI code to see if there is debugging built in that I can turn on and recompile, but I could not find it.  The SQL logs are too big, and there are no problems listed in the err-log.
	
	Does anyone have any suggestions on how to debug why I am getting this message.  i.e Is it because the CGI's cant connect to the DB? None of the built in cgi's work. 
	
	NagMIN scripts do work.  
	
	I am open to suggestions.
	
	Thanks
	
	Cian
	
	NHS^隊[){([ZrAÚ´yj)-Vv~):ÚŠxUn6Ø Ö¥_uޞǭ^rq^Æ—Ý¢b^j!yÞ·
	+)࢚hۧ؞X0ZrHZ&5"ˬz&j)b   bZ*,Ç«X(~zwilqzlX)ߣڂ*,Ç«^jÇ¢nuZ*,슉"*'9,!zzÞ¦x(z0h.+)w)e+$m观ǧ?ue 

N¬HS^µéšŠ[)¢{(­ç[ÈZrAÚ´âyø§‚Äëj)âž -µéÝVœv­¸ž~)à±:ÚŠx§€¶¬Uè°›¥Ën6õØ ŠÖ¥±é_uçޞǭ¢›^râq©^Æ—«¶Éè½éÝ¢ºbµÈ^²éæj×!yÙÞ·
+’)࢚h®Û§ŠØž±X¬ŠÜ0Á¹ZrHZµÊ&5¨"¢Ë¬z»&j)bž	b²ÓZ‚*,ºÇ«²X¬¶Ë(º·~Šàzw­†Ûi³ÿåŠËl²‹«qç讧zßåŠËlþX¬¶)ߣùÚ‚*,ºÇ«°ù^jÇ¢ÉnuãZ‚*,½ê슉é–è"ž÷«²*'½©Ý9,!zzÞ¦ŠíŠxŸ(¬²çŒzˁë0ŠØhºÛ.¦š+¶)àŠwèÂ)e®+$m观ǧ¶Ú?uëÿžée