I was wondering if you could get all the loing to goto a odbc database or something?
I was thinking to a mySQL database that way it could have more of a history and or other programs could pull from the data to graph or what ever. I know I would greatly appreciate it!
If you have a command line program that does the thing you can easily create a new notification, that executes your program with some parameters on interesting events
I guess I’ll have to read up a bit more on it so I can utilize it better. Thanks for the info on where to start.
Any examples on how to create a connection to mysql?
Regards
Didn’t think I would ever say this but read the mysql doc’s mysqladmin is the command line for mysql. Otherwise just need to find a command line client that can do this.
But this isnt available from the CLI of routeros.
Im referring to making a connection to a mysql server from a Mikrotik router to use in scripting etc…
If you are speaking about logging events to ODBC…
IE proxy, system info events etc…
Then it is done for you (if you use windows…)
Use syslog2ODBC.. (source forge)…
It is a syslog server that pumps the syslog data to an ODBC compliant database…
IE MySQL, SQL server, Access Etc…
Thank you.
Was researching avenues such as http://www.rsyslog.com/, which is along same lines but for unix/linux.
Pity it is not built in, but at least there is a way to kind of work around it.
Appreciate the input!