Dumping syslog-ng log files to mysql db
Hello, With recent addition of MYSQL DB to my logging infrastructure, would I be able to dump my previous logs collected from the by syslog-ng on the database? If I configure the source to be the local log file that has logs collected from devices over the network and the destination to be the DB, would I be loosing the source IP address when I log these to the DB and instead get the source of the message to be localhost or 127.0.0.1 instead of the original source? -- Thanks and regards, Anup
Anup Shetty <anupdshetty@gmail.com> writes:
If I configure the source to be the local log file that has logs collected from devices over the network and the destination to be the DB, would I be loosing the source IP address when I log these to the DB and instead get the source of the message to be localhost or 127.0.0.1 instead of the original source?
Depends on how you configure the destination. syslog-ng will put whatever you tell it to into the source address field of your database table. If you choose to put the original IP, as extracted from the log files, then you won't loose it. -- |8]
participants (2)
-
Anup Shetty
-
Gergely Nagy