Bug #56975 Connector/PHP plugin - No error is logged
Submitted: 23 Sep 2010 15:58 Modified: 26 Nov 2010 16:17
Reporter: Diego Medina Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Connector Plugins Severity:S3 (Non-critical)
Version:1.0 OS:Any
Assigned to: Stefan Hinz CPU Architecture:Any

[23 Sep 2010 15:58] Diego Medina
Description:
There may be cases when a customer disabled the PHP error reporting on the PHP.INI file, if they did this, they will not see errors generated by the MySQL Query Analyzer plugin.

If anyone does not see the plugin working and does not see any errors either, make sure that the php.ini file has this entry:

log_errors = ON

How to repeat:
1- Install PHP and enable the plugin
2- Install and start an agent and service manager
3- set log_errors = OFF on your php.ini file
4- use a php script to send some queries to the mysqld server, but use a user that has no privileges to the mysql.inventory table
5- you will not see any error anywhere, and you also won't see any queries on the dashboard

6- enable log_errors = On and restart apache
7- run your script again and you will see errors logged to the apache error log file
[23 Sep 2010 15:59] Diego Medina
This bug os so that we add an entry to the documentation
[23 Sep 2010 16:29] Enterprise Tools JIRA Robot
Diego Medina writes: 
changing status so that it ends up on documenting
[26 Nov 2010 16:17] Tony Bedford
No changelog entry has been added because the plugin has not been released in any of the MySQL Enterprise Monitor versions.