List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:December 3 2003 11:52pm
Subject:Re: How to pass syslog data to a MySql Database?
View as plain text  
Have a  look on sourceforge.

I think it's called mylogd or something similar. It's syslogd with sql support in it.

Alternatively, a simple perl script will be able to parse the data and insert it manually
into a db.

--
me

  ----- Original Message ----- 
  From: elimachi@stripped 
  To: mysql@stripped 
  Sent: Thursday, December 04, 2003 1:42 AM
  Subject: How to pass syslog data to a MySql Database?



  Dear list: 

  I`m running a syslogd into my Linux box for logging all event send from our Cisco
routers, these event are logged in text format, for instance: 

  Dec  3 15:01:36 sin-trj 8351: Dec  3 15:01:35.322 BO: %SNMP-3-AUTHFAIL:Authentication
failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:38 sin-trj 8352: Dec  3 15:01:37.318 BO: %SNMP-3-AUTHFAIL:Authentication
failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:40 sin-trj 8353: Dec  3 15:01:39.318 BO: %SNMP-3-AUTHFAIL:Authentication
failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:42 sin-tnd 8286: Dec  3 15:01:41.328 BO: %SNMP-3-AUTHFAIL:Authentication
failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:42 nas-cbb-gisuq 10124: Dec  3 15:01:41.818 BO:%PQUICC-1-LOSTCARR: Unit 0,
lost carrier. Transceiver problem? 
  Dec  3 15:01:44 sin-tnd 8287: Dec  3 15:01:43.324 BO: %SNMP-3-AUTHFAIL:Authentication
failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:46 sin-tnd 8288: Dec  3 15:01:45.324 BO: %SNMP-3-AUTHFAIL:Authentication
failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:48 sin-tnd 8289: Dec  3 15:01:47.324 BO: %SNMP-3-AUTHFAIL:Authentication
failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:50 sin-tnd 8290: Dec  3 15:01:49.320 BO: %SNMP-3-AUTHFAIL:Authentication
failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:52 172.30.1.49 8234: Dec  3 15:01:51.601 BO:
%SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:54 172.30.1.49 8235: Dec  3 15:01:53.597 BO:
%SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:56 172.30.1.49 8236: Dec  3 15:01:55.589 BO:
%SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 
  Dec  3 15:01:58 172.30.1.49 8237: Dec  3 15:01:57.597 BO:
%SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 
  Dec  3 15:02:00 172.30.1.49 8238: Dec  3 15:01:59.589 BO:
%SNMP-3-AUTHFAIL:Authentication failure for SNMP req from host 10.1.10.12 

  I`d like to get some suggestion over how can I to load these text file to a MySql
database automatically. 
  Thank you for your help. 

  EDWIN LIMACHI N.
  DATACOM - Instalaciones
  Phone. 591-2-2123978
  Movil: 591-715-29967
  Fax: 591-2-2123975  





------------------------------------------------------------------------------


  -- 
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
How to pass syslog data to a MySql Database?elimachi4 Dec
  • Re: How to pass syslog data to a MySql Database?Chris Knipe4 Dec
  • Re: How to pass syslog data to a MySql Database?Daniel Kasak4 Dec