How should I configure MySQL DB monitor?
Q: How to configure MySQL DB monitor?
A: In order to use MySQL DB monitor you need to install MySQL Client libraries on computer where IPHost Network Monitor is running. Here are the steps:
a) Download Connector/C (libmysqlclient), client library (Windows, 32bit):
Client libraries versions from 5.1.73 up to 6.1.6 (current) are supported by current IPHost Network Monitor v4 builds. If you need to get older client libraries, click «Looking for previous GA versions?» link.
b) Install at least MySQL Connector/C component on the computer where IPHost Network Monitor is running.
c) Append the client libraries directory path to the «PATH» environment variable, e.g.:
PATH=%PATH%;C:\Program Files (x86)\MySQL\MySQL Connector C 6.1\lib
Note: for permanent change, add the above path to libmysql.dll to system PATH via System Properties -> Advanced -> Environment Variables
Note: in order to avoid version conflict between MySQL libraries various versions installed on the computer, you can copy libmysql.dll to IPHost Network Monitor installation directory directly. In this case there is no need to modify the system path.
d) Stop the monitoring service and exit the IPHost Network Monitor Client. Start client and monitoring service.
e) The default port 3306 and non-secure connection (without SSL) are used by default.
f) If you use client libraries v 5.6 or newer and connect with a database that use old (pre-4.1.1) authentication protocol, you will receive the following error message: “Poll failed: Cannot connect to server: Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled)“. Set “Allow non-secure authentication” monitor parameter to “Yes” to allow client to use pre-4.1.1 authentication protocol, as in example below:
Important: In order to connect with a database using old (pre-4.1.1) authentication protocol, you should use 5.6.* libraries; 5.7* or later won’t work. 5.7.* and later work fine with default (new) authentication only.