Problem with traptime in camm 1.6.5

[matexoman]

Hi all

We have installed camm (1.6.5) to monitor some CISCO devices snmp traps. We think all is configured correctly but we have an issue with taps time.

In /etc/snmp/snmptt.ini whe have:

Code: Select all

date_time_format = %Y-%m-%d %H:%M:%S
date_time_format_sql = %Y-%m-%d %H:%M:%S
stat_time_format_sql = %Y-%m-%d %H:%M:%S
use_trap_time = 1

In /var/log/messages we have :

Code: Select all

Dec 28 12:33:49 localhost snmptrapd[9551]: 2009-12-28 12:33:49 10.111.255.10(via 10.111.255.10) TRAP, SNMP v1, community eepl02 	SNMPv2-SMI::enterprises.9.9.43.2 Enterprise Specific Trap (1) Uptime: 205 days, 13:18:57.80 	SNMPv2-SMI::enterprises.9.9.43.1.1.6.1.3.210 = INTEGER: 1	SNMPv2-SMI::enterprises.9.9.43.1.1.6.1.4.210 = INTEGER: 2	SNMPv2-SMI::enterprises.9.9.43.1.1.6.1.5.210 = INTEGER: 3

Dec 28 12:33:53 localhost snmptt[0]: .1.3.6.1.4.1.9.9.43.2.0.1 Normal "Status Events" 10.111.255.10 - Notification of a configuration management event as recorded in ccmHistoryEventTable. 1 2 3

And in the /var/log/snmp/snmptt.log we have:

Code: Select all

2009-12-28 12:33:49 .1.3.6.1.4.1.9.9.43.2.0.1 Normal "Status Events" 10.111.255.10 - Notification of a configuration management event as recorded in ccmHistoryEventTable. 1 2 3
[code]

But in the database all traps are dated as "0000-00-00 00:00:00" and in the cam all traptime are 1930-11-30 00:00:00  and obviously we cant use this field to manage traps...

Somebody can help us with this problem ? Any idea of where can be the problem ?

[matexoman]

We changed table plugin_camm_snmptt the traptime variable type datetime to varchar. With this in the table is the date the trap but not in the expected format (I think):

The date format is:

Wed Dec 30 09:30:09 2009

When I understand that putting in snmptt.ini:

date_time_format =% Y-% m-% d% H:% M:% S
date_time_format_sql =% Y-% m-% d% H:% M:% S
stat_time_format_sql =% Y-% m-% d% H:% M:% S
use_trap_time = 1


The date should appear in the specified format, but we could enforce.
Now the problem is that the GUI does not see any date, even if it appears correctly when you expand each of the trap. Any way to make that date appears on the web?

[gthe]

Excuse me - just now I have little free time because of the Christmas holidays.
And in the remaining tables of the field with the date written correctly? (plugin_camm_snmptt_stat and plugin_camm_snmptt_unk)