Submitted a pull request with some changes. As this wasn't working for me in Ubuntu 14+. I was receiving a 'Bad Substitution' error and a few other issues with with the script.
The main change was getting rid of the use of eval and correcting some syntax.
So, if you're having issues with this, try using what's here: https://github.com/henrylwilliams/mysql-gelf
I've got a pull request in to the main repository for this script, hopefully it will get pulled in soon. Arikogan may just want to make another branch for debian-based environments, however the updates should work across the board.
mocanal
about 4 years
ago
After configuring the input in Graylog Server and launch the script. I can see that my server receive data in Throughput / Metrics but when I go to Show received messages I can't see anything
pauldsmyth
over 4 years
ago
Excellent little utility, one little amendment to mysql-status.sh I've made for monitoring remote databases like RDS where you have no ability to run locally:
Line 11
-HOST=`hostname --long`
+HOST=[actual hostname]
Line 23
-STATUS_CMD="echo 'SHOW GLOBAL STATUS;' | mysql -u $MYSQL_USER -p$MYSQL_PASS"
+STATUS_CMD="echo 'SHOW GLOBAL STATUS;' | mysql -u $MYSQL_USER -p$MYSQL_PASS -h $HOST"
Submitted a pull request with some changes. As this wasn't working for me in Ubuntu 14+. I was receiving a 'Bad Substitution' error and a few other issues with with the script.
The main change was getting rid of the use of eval and correcting some syntax.
So, if you're having issues with this, try using what's here: https://github.com/henrylwilliams/mysql-gelf
I've got a pull request in to the main repository for this script, hopefully it will get pulled in soon. Arikogan may just want to make another branch for debian-based environments, however the updates should work across the board.