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
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* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com
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
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* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com
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
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
The script runs successfully on the agent. How are the results of the script on the agent sent back to the server? It doesn't seem that they are through SNMP. Is it possible that the applications expect a password-less SSH configuration?
Geoff
On Wed, Nov 25, 2015 at 8:43 AM, Adam Armstrong adama@memetic.org wrote:
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
*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* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com
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
_______________________________________________ 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
Observium connects to the client on the unix agent port 36602.
You can test if this works by telnetting to 36602 on the client machine from the Observium server.
adam. On 25/11/2015 19:00:14, Geoff Johnson geoff.johnson@coanda.ca wrote: The script runs successfully on the agent. How are the results of the script on the agent sent back to the server? It doesn't seem that they are through SNMP. Is it possible that the applications expect a password-less SSH configuration?
Geoff
On Wed, Nov 25, 2015 at 8:43 AM, Adam Armstrong <adama@memetic.org [mailto:adama@memetic.org]> wrote:
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 [mailto: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 [tel:604-420-0367%20x231] M: 778-888-4047 [tel:778-888-4047] F: 604-420-0368 [tel: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 [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
So it seems obvious now that the Unix Agent is a requirement for all applications, but given that this was the first time I'd set up an application it wasn't initially. At least not to me. Seems to work fine once that's done.
Thanks, Geoff
On Wed, Nov 25, 2015 at 11:24 AM, Adam Armstrong adama@memetic.org wrote:
Observium connects to the client on the unix agent port 36602.
You can test if this works by telnetting to 36602 on the client machine from the Observium server.
adam.
On 25/11/2015 19:00:14, Geoff Johnson geoff.johnson@coanda.ca wrote: The script runs successfully on the agent. How are the results of the script on the agent sent back to the server? It doesn't seem that they are through SNMP. Is it possible that the applications expect a password-less SSH configuration?
Geoff
On Wed, Nov 25, 2015 at 8:43 AM, Adam Armstrong adama@memetic.org wrote:
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
*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* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com
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
_______________________________________________ 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
_______________________________________________ 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
participants (3)
-
Adam Armstrong -
Geoff Johnson -
Spencer Ryan