silly problem i'm sure with MySQL

This support forum board is for support questions relating to Nagios Log Server, our solution for managing and monitoring critical log data.
Locked
User avatar
JohnFLi
Posts: 559
Joined: Mon Jun 17, 2013 3:11 pm

silly problem i'm sure with MySQL

Post by JohnFLi »

I am just trying out Nagios Log server for teh first time.
Getting it to read windows logs is nice and easy.....
Now I'm trying to get it to read MySQL stuff.

How do I get it to read when MySQL is installed on a Windows machine??
I tried setting it up for MySQL on a linux machine as well with no luck.
I went to +Log Source -> mySQL Setup, and followed those directions.... I don't see any logs from it.
The Script Setup ran fine without errors.

ANy idea?
Everybody is somebody else’s weirdo
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: silly problem i'm sure with MySQL

Post by hsmith »

I've noticed MySQL doesn't generate a ton of logs. Can you make sure that it's not just a lack of data being sent from the server?
Former Nagios Employee.
me.
User avatar
JohnFLi
Posts: 559
Joined: Mon Jun 17, 2013 3:11 pm

Re: silly problem i'm sure with MySQL

Post by JohnFLi »

ummmmmm....how?
Everybody is somebody else’s weirdo
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: silly problem i'm sure with MySQL

Post by hsmith »

Open the log file and see when the last time something happened was, and make sure it wasn't before you set up the log forwarding.
Former Nagios Employee.
me.
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: silly problem i'm sure with MySQL

Post by hsmith »

Also, for the Windows logs, you'll need to run the Windows File Wizard, and point it at your MySQL logs on Windows. The MySQL wizard was designed for Linux. We'll see if we can get them both working for you, though!
Former Nagios Employee.
me.
User avatar
JohnFLi
Posts: 559
Joined: Mon Jun 17, 2013 3:11 pm

Re: silly problem i'm sure with MySQL

Post by JohnFLi »

Great.....it appears that logging for the MySQL's wasn't turned on........oy
Everybody is somebody else’s weirdo
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: silly problem i'm sure with MySQL

Post by mcapra »

Is it ok if we mark this issue as resolved?
Former Nagios employee
https://www.mcapra.com/
User avatar
JohnFLi
Posts: 559
Joined: Mon Jun 17, 2013 3:11 pm

Re: silly problem i'm sure with MySQL

Post by JohnFLi »

you can close this item
Everybody is somebody else’s weirdo
Locked