I've done this and the MySQL application does not show up for the host, and if I manually run the poller there is no <<mysql>> section in the output. I'm using the SVN release of Observium and the server I'm trying to monitor is Debian 6 with MySQL version 5.1.something. I have tested with the firewall disabled, using the user/pass set explicitly in a mysql.cnf file, and without using the one provided in the agent-local directory.

Couple of questions. Does the version of MySQL matter? Is there a good way other than the poller to check against the server to see if it's authenticating correctly? Aside from logging in using the credentials in the /etc/mysql/debian.cnf file, I've done that and it works.


Geoff Johnson

Coanda Research & Development Corporation
401-6741 Cariboo Rd., Burnaby, BC, Canada, V3N 4A3

T: 604-420-0367 x231
M: 778-888-4047
F: 604-420-0368
http://www.coanda.ca

This email (including any attachments) is private and confidential and may contain proprietary information which is provided for the intended recipient only. If you have received this in error, please contact the sender immediately and delete any copies of the email and / or attachments. Thank you.

On Mon, Nov 23, 2015 at 5:01 PM, Spencer Ryan <sryan@arbor.net> wrote:
It needs to be run on every host running MySQL that you want to monitor, as that is the user the script uses to connect and collect metrics with.


Spencer Ryan | Senior Systems Administrator | sryan@arbor.net
Arbor Networks

On Mon, Nov 23, 2015 at 7:43 PM, Geoff Johnson <geoff.johnson@coanda.ca> wrote:
The instructions for configuring the MySQL application at https://observium.org/w/Application/MySQL are unclear about where the database user must be created. Do the user create steps need to be done on every host running MySQL that you want to monitor, or just once on the Observium server? I assume that it's the former, just looking for clarification.

Thanks,
Geoff

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium



_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium