Problem of date in the status tables of NagMin Re: [Nagios-users] Use of Nagmin and nagios tables

[carole verdon]

Thank you for your response.

In fact, for the email problem, it was enough to correct the notify 
commands removing all the backslashes before the double-quote 
characters:  \" must be change to " instead.

I have got another problem with informations comprising a date that 
doesn't display correctly.

For example, in host status table, parameters "Last Update" is good but 
"Last Check", "Last State Change" display "Thu Jan 1 01:33:24 1970" and 
"Last Notification" displays "1970-01-01 01:00:00".

When i edit host status table for one host, i have the right data, those 
which correspond to my nagios mysql database. But when i
want save those informations, i obtain the following error message:

SQL update `hoststatus` set `host_name` = 'xxxx' , `host_status` = 'UP'
, `last_update` = '2004-05-03 14:58:07' , `last_check` = '2004-05-03
09:41:49' , `last_state_change` = '2004-04-30 17:21:36' ,
`problem_acknowledged` = '0' , `time_up` = '231570' , `time_down` = '0'
, `time_unreachable` = '0' , `last_notification` = '0' ,
`current_notification` = '0' , `notifications_enabled` = '1' ,
`event_handler_enabled` = '1' , `checks_enabled` = '1' , `plugin_output`
= '(Host assumed to be up)' , `flap_detection_enabled` = '1' ,
`is_flapping` = '0' , `percent_state_change` = '0.00' ,
`scheduled_downtime_depth` = '0' , `failure_prediction_enabled` = '1' ,
`process_performance_data` = '1' where failed : You have an error in
your SQL syntax near '' at line 1


I don't known how to solve this problem.

Can you help me, please?????

Carole.

Patrick Proy wrote:

>Hi,
>
>  
>
>>How can i indicate to nagios to read in the NagMin database and not in the
>>    
>>
>configuration files? 
>
>You can't, Nagios has it's database in text files in $nagiosdir/etc/ and
>Nagmin in a Mysql database.
>The Activate button translates the Nagmin database into nagios text files
>and reloads nagios.
>
>  
>
>>Since NagMin runs, i don't receive mail alerts
>>    
>>
>
>Check your mail command in the "commands" table in Nagmin, maybe they where
>not correctly imported by Nagmin. (I had this problem once with an older
>version of Nagmin).
>
>Patrick
>nagios at proy.org
>
>-----Message d'origine-----
>De : nagios-users-admin at lists.sourceforge.net
>[mailto:nagios-users-admin at lists.sourceforge.net] De la part de carole
>verdon
>Envoyé : vendredi 30 avril 2004 18:07
>À : nagios-users at lists.sourceforge.net
>Objet : [Nagios-users] Use of Nagmin and nagios tables
>
>Hi,
>
>Does someone use nagmin to configure nagios?
>
>I use nagios v1.2 et nagmin v2.1.0 on solaris 8.
>I have modified Service table to add a new service, then i click on Reload
>button. A this moment, nagios don't take into account those modifications.
>If i click on Activate button, then nagios takes them into account.
>
>How can i indicate to nagios to read in the NagMin database and not in the
>configuration files?
>
>I have got another problem with notifications. Since NagMin runs, i don't
>receive mail alerts. Why?
>
>Thanks you for help.
>
>Carole.
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest
>thing ever to hit the market... Oracle 10g. 
>Take an Oracle 10g class now, and we'll give you the exam FREE.
>http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
>_______________________________________________
>Nagios-users mailing list
>Nagios-users at lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/nagios-users
>::: Please include Nagios version, plugin version (-v) and OS when reporting
>any issue. 
>::: Messages without supporting info will risk being sent to /dev/null
>
>
>
>  
>

-- 
**********************************
VERDON Carole
Ingénieur Système
CICT - Université Paul Sabatier
118, route de Narbonne
31062 Toulouse Cedex
Tél.: 05.61.36.60.44
Fax: 05.61.52.14.58
Mail: verdon at cict.fr
**********************************	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20040503/dbc0270f/attachment.html>