Has anyone made a MySQL probe for the Dude?
do you mean to return a value stored in mysql table through snmp?
No, I needed a probe that checks if the MySQL DB is running.
So I made one ![]()
Name: mysql
Type: TCP
Port: 3306
Connect Only: unchecked
First Receive, Then Send: checked
Receive: 4|8
Send: close
NOTE: Seems that MySQL v.5x sends ether 4 or 8 as a response to a connection. You might need to change the ‘Receive:’ string to match what your MySQL version first responce.
I use a simple connect only tcp probe on port 3306 - that’s how I know if the service is started or not at least.
How did you figure out to put 4 or 8 in the receive field? It does not work for me, no matter what number I put there.
Would be nice if we could do a query, to check if the db is alive.
As for the 4 and 8, I used telnet and tcpdump. It clearly returns one of those numbers. And the probe works
at least for my mysql versions.