Log File -> cacti

[chewymix]

Hi

I have a script that gets connected oracle user numbers and puts them into a log file. How can i take this log file and import it into cacti?

thanks

[fmangeant]

I have a script that gets connected oracle user numbers and puts them into a log file. How can i take this log file and import it into cacti?

Hi

a simple setup (on Unix) would be :

- create a script /tmp/display_log.sh

Code: Select all

#!/bin/sh

cat /tmp/mylog.txt

- add this line to /etc/snmp/snmpd.conf :

Code: Select all

exec .1.3.6.1.4.1.2021.400 /bin/sh /tmp/display_log.sh

You can then get the output like this :

Code: Select all

# snmpwalk -v 1 -c public localhost .1.3.6.1.4.1.2021.400
UCD-SNMP-MIB::ucdavis.400.1.1 = INTEGER: 1
UCD-SNMP-MIB::ucdavis.400.2.1 = STRING: "/bin/sh"
UCD-SNMP-MIB::ucdavis.400.3.1 = STRING: "/tmp/display_log.sh"
UCD-SNMP-MIB::ucdavis.400.100.1 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.400.101.1 = STRING: "123"
UCD-SNMP-MIB::ucdavis.400.102.1 = INTEGER: 0
UCD-SNMP-MIB::ucdavis.400.103.1 = ""

In this example, the OID for the content of your log is .1.3.6.1.4.1.2021.400.101.1

On a Windows host, you can use NRPE (Nagios Remote Plugin Executor). Here's a nrpe.cfg sample file :

Code: Select all

command[display log]=c:\windows\system32\type c:\temp\mylog.txt"