Hi Auxilium,

Thanks for your patience.

After analysing the logs, we suspect that Python path given in the mysql_monitoring.py was not correct. Due to that, Site24x7LinuxAgent, couldn't able to execute the plugin successfully and thrown the below error.

1. mysql_monitoring.py 2023-01-12 16:34:53,679   Worker 3,  plugin out - {'result': False, 'timedout': False, 'error': '/bin/sh: 1: Syntax error: "(" unexpected\n', 'exit_code': 2} | error out - {'status': 0, 'msg': '/bin/sh: 1: Syntax error: "(" unexpected\n'}

To solve this issue, please follow the below steps.

1. Open the terminal, execute command "which python3". It will give result of python3 path.

2. Copy the path, open and edit the mysql_monitoring.py, in the first line of the script with shebang character "#!" replace the path with copied one. 

Eg : #!/usr/local/bin/python3

Once done, please wait for next data collection the plugin will be shown in the Site24x7 web client. To navigate Site24x7 portal -> Server -> Plugin Integration -> Check your MySQL monitor.

Suppose if there is no change in python3 path, for further analysis please execute the mysql_monitoring script manually as below format. This format is exactly how our Site24x7LinuxAgent executes the plugin, hence it will be helpful find exact error. 

./mysql_monitoring.py --host=“<hostname>“ --port="3306" --username="<username>" --password="<password>"

Note: The parameter should be same as configuration given in mysql_monitoring.cfg. 

Please post this script output in the community thread. We will help to analyse the issue. 

Regards,

Muralikrishnan

Product Manager

Site24x7

2. /opt/site24x7/monagent/plugins/mysql_monitoring$ which python3
3. /usr/bin/python3

2. /opt/site24x7/monagent/plugins/mysql_monitoring$ sudo cat mysql_monitoring.py
3. #!/usr/bin/python3

2. /usr/bin/python3: can't open file './mysql_monitoring.py': [Errno 13] Permission denied

2. /opt/site24x7/monagent/plugins/mysql_monitoring$ sudo python3 mysql_monitoring.py --host="******" --port="3306" --username="******" --password="*****"
3. {
4.     "aborted_clients": 196.0,
5.     "aborted_connects": 798.0,
6.     "application_queries": 227216274.0,
7.     "applog": {
8.         "logs_enabled": false
9.     },
10.     "blocks_not_flushed": 0.0,
11.     "buffer_pool_pages_data": 1335054.0,
12.     "buffer_pool_pages_dirty": 0.0,
13.     "buffer_pool_pages_flushed": 95754693.0,
14.     "buffer_pool_pages_free": 11100850.0,
15.     "buffer_pool_pages_total": 12451840.0,
16.     "buffer_pool_read_ahead": 188.0,
17.     "buffer_pool_read_ahead_evicted": 0.0,
18.     "buffer_pool_read_ahead_rnd": 0.0,
19.     "buffer_pool_read_requests": 9412496811.0,
20.     "buffer_pool_reads": 867169.0,
21.     "buffer_pool_wait_free": 0.0,
22.     "buffer_pool_write_requests": 3404102337.0,
23.     "cached": 78.0,
24.     "client_queries": 114663717.0,
25.     "com_delete": 837494.0,
26.     "com_insert": 22176798.0,
27.     "com_rollback": 141964.0,
28.     "com_update": 28832920.0,
29.     "commit": 59219202.0,
30.     "connected": 3.0,
31.     "connection_errors_max_connections": 0.0,
32.     "connection_usage": 0,
33.     "created": 81.0,
34.     "data_fsyncs": 193008294.0,
35.     "data_length": 0,
36.     "data_pending_fsyncs": 7640.0,
37.     "data_pending_reads": 0.0,
38.     "data_pending_writes": 0.0,
39.     "data_reads": 912572.0,
40.     "data_writes": 430637391.0,
41.     "delete_multi": 0.0,
42.     "disk_tables": 1110912.0,
43.     "free_blocks": 0,
44.     "free_memory": 0,
45.     "full_join": 7588630.0,
46.     "full_range_join": 0.0,
47.     "handler_delete": 194630007.0,
48.     "handler_rollback": 142036.0,
49.     "handler_update": 48334612.0,
50.     "handler_write": 347703094.0,
51.     "heartbeat_required": "true",
52.     "hits": 0,
53.     "in_cache": 0,
54.     "index_length": 0,
55.     "insert_select": 0.0,
56.     "inserts": 0,
57.     "key_reads": 0.0,
58.     "key_writes": 0.0,
59.     "log_waits": 3554.0,
60.     "log_write_requests": 2636084873.0,
61.     "log_writes": 333052184.0,
62.     "lowmem_prunes": 0,
63.     "max_connections": 20480.0,
64.     "max_data_length": 0,
65.     "max_execution_time_exceeded": 0.0,
66.     "max_used_connections": 92.0,
67.     "merge_passes": 0.0,
68.     "mysql_node_type": "Master",
69.     "not_cached": 0,
70.     "open_cache_hits": 336782017.0,
71.     "open_cache_misses": 13678.0,
72.     "open_cache_overflows": 1902.0,
73.     "open_files": 31.0,
74.     "open_files_usage": 0.002956390380859375,
75.     "open_tables": 6379.0,
76.     "os_log_fsyncs": 135622696.0,
77.     "os_log_pending_fsyncs": 0.0,
78.     "os_log_pending_writes": 0.0,
79.     "os_log_written": 253805127680.0,
80.     "pages_created": 3758934.0,
81.     "pages_read": 908886.0,
82.     "pages_written": 95754816.0,
83.     "plugin_version": "3",
84.     "prepared_stmt_count": 0.0,
85.     "range": 0.0,
86.     "range_check": 0.0,
87.     "read_first": 58079045.0,
88.     "read_key": 748834925.0,
89.     "read_requests": 0.0,
90.     "read_rnd": 257687939.0,
91.     "read_rnd_next": 3704269399.0,
92.     "reads": 0,
93.     "received": 19295192604.0,
94.     "replace_select": 0.0,
95.     "row_length": 0,
96.     "row_lock_time_avg": 0.0,
97.     "row_lock_waits": 0.0,
98.     "rows": 15154024.0,
99.     "rows_count": 0,
100.     "rows_deleted": 194481437.0,
101.     "rows_inserted": 264154037.0,
102.     "rows_read": 5456250067.0,
103.     "rows_updated": 48052880.0,
104.     "running": 0,
105.     "scan": 2166064.0,
106.     "select": 66020657.0,
107.     "select_range": 0.0,
108.     "select_scan": 74333740.0,
109.     "sent": 33596630493.0,
110.     "slave_running": 1,
111.     "slow_queries": 0.0,
112.     "table_locks_waited": 0.0,
113.     "tmp_files": 151.0,
114.     "tmp_tables": 43866226.0,
115.     "total_blocks": 0,
116.     "transactions": 59361166.0,
117.     "units": {
118.         "connection_usage": "%",
119.         "data_length": "bytes",
120.         "free_memory": "bytes",
121.         "index_length": "bytes",
122.         "max_data_length": "bytes",
123.         "open_files_usage": "%",
124.         "os_log_written": "bytes",
125.         "received": "bytes",
126.         "relay_log_space": "bytes",
127.         "row_count": "units",
128.         "row_length": "bytes",
129.         "row_lock_time_avg": "ms",
130.         "seconds_behind_master": "seconds",
131.         "sent": "bytes",
132.         "uptime": "seconds"
133.     },
134.     "update_multi": 0.0,
135.     "uptime": 3370304.0,
136.     "version": "8.0.31",
137.     "write_requests": 0.0,
138.     "writes": 51847212.0
139. }

Hi Auxilium,

Thanks for your response. 

Could you please check the following in the SIte24x7 web client?

To see the plugin monitor, login to your Site24x7 account. 

Navigate to Server > click the respective Server monitor > Plugin Integrations > click mysql_monitoring.py. 

This will take you to the MySQL monitoring details page where you will be able to see the metrics.

If the mysql_monitoring.py monitor doesn't show any data, please click the Reregister Plugins button to resume the data collection of the plugin. On the next data collection event, you will be able to see the data. 

 Please let us know if you were able to troubleshoot and if you face further issues.

Thank you,

Suraj D
Site24x7 Team

1. SELECT VERSION()

1. SELECT MYSQL_VERSION()

Hi Auxilium,

Any query change is not required. In the mysql_monitoring.py plugin file, you have to change the line at 280 from "data['version'] = result[0]" to "data['mysql_version'] = result[0]" as shown in the below image.

We already fixed the issue from our side in the Site24x7's plugin repository in the mysql_monitoring.py file. 

Alternatively, you can also delete the existing mysql_monitoring.py and perform the wget to get the new file and place it under "/plugin/mysql_monitoring/" folder.

Here's the link:

wget https://raw.githubusercontent.com/site24x7/plugins/master/mysql_monitoring/mysql_monitoring.py

Once done, re-register the plugin in the Site24x7 web client.

Navigate to Server > click the respective Server monitor > Plugin Integrations > click "Reregister Plugins

In the next data collection event, the mysql_monitoring.py will be added for monitoring.

We hope this will work.

If you face further issues, please reach out to support@site24x7.com and share the ticket ID. We'll prioritize and debug the issue.