You can manually run the script (or the agent script) on the client machine to see if it runs.
adam. On 25/11/2015 01:42:16, Geoff Johnson geoff.johnson@coanda.ca wrote: 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 [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 [mailto: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 [mailto:sryan@arbor.net] Arbor Networks +1.734.794.5033 [tel:%2B1.734.794.5033] (d) | +1.734.846.2053 [tel:%2B1.734.846.2053] (m) www.arbornetworks.com [http://www.arbornetworks.com/]
On Mon, Nov 23, 2015 at 7:43 PM, Geoff Johnson <geoff.johnson@coanda.ca [mailto:geoff.johnson@coanda.ca]> wrote:
The instructions for configuring the MySQL application at https://observium.org/w/Application/MySQL [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 [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium