Hello,
I had a problem that sometimes I got a blank email message from jffnms:
NMS <interface-client_shortname> <interface-interface>
<interface-description> <alarm-type_description>
<alarm-state_description>
So I (think) found the problem:
When the alarms table is empty, the first alarm will have id 1, and
then the trigger_analize will execute the following query:
SELECT alarms.*,
(alarms.date_stop - alarms.date_start) as duration,
interfaces.host as interface_host,
interfaces.interface as interface_interface,
clients.name as interface_client,
interfaces.client as interface_client_id,
interfaces.type as interface_type,
types.description as type_description,
alarm_states.state as alarm_state,
alarm_states.description as state_description
FROM interfaces, alarms, types, alarm_states, clients
WHERE (1=1)
and alarms.interface = interfaces.id
and interfaces.client = clients.id
and alarms.type = types.id
and alarms.active = alarm_states.id
and alarms.id > 1
and alarms.id = 1
order by alarms.id desc
LIMIT 0,100
As you can see, the two last statements from the WHERE is not going to
work. A workaround is to make a record in the alarms database table,
and the problem is solved.
Pieter Veenstra
GN-IX
[EMAIL PROTECTED]
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
jffnms-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
