<div>A large number of my log messages come in and the $HOST variable is an IP address. I am creating a mysql table for each unique host. The problem is, mysql does not allow table names with periods in them, or at least I can't figure out how to make it.
</div>
<div> </div>
<div>Is there a way in the syslog-ng.conf file that I can use regexp to change <a href="http://10.1.1.1">10.1.1.1</a> to 10_1_1_1 for example? Or does anyone happen to know how to make mysql accept `10.1.1.1` as a valid table name?
</div>
<div> </div>
<div>Thanks!</div>
<div> </div>