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]
