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: [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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/[EMAIL PROTECTED]
