Note: This bug is displayed in read-only format because
the product is no longer active in Red Hat Bugzilla.
RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Description of problem:
The MySQL resource agent logs a lot of error messages to the system log. These messages are generated by the monitor action.
--- snip ---
Oct 6 17:35:57 HOST lrmd: [1513]: info: RA output: (rsc_core_mysql:0:monitor:stderr) ERROR
Oct 6 17:35:57 HOST lrmd: [1513]: info: RA output: (rsc_core_mysql:0:monitor:stderr) 1045 (28000)
Oct 6 17:35:57 HOST lrmd: [1513]: info: RA output: (rsc_core_mysql:0:monitor:stderr) : Access denied for user 'root'@'localhost' (using password: NO)
--- snip ---
There is a configuration which controlls if the script will log in to mysql or just execute a PID check (kill -0). This option does not fully work in the shipped implementation. A bugfix was released upstream:
https://github.com/ClusterLabs/resource-agents/commit/259cb54f1a47a527085e3138955b4cc26b62d37c
Version-Release number of selected component (if applicable):
resource-agents-3.0.12-15.el6.x86_64
How reproducible:
create a simple cluster (a single node is enough)
create a mysql resource
primitive rsc_mysql ocf:heartbeat:mysql \
params binary="..." client_binary="..." config="/etc/my.cnf" pid="..." socket="..." datadir="..." user="mysql" group="mysql" \
op monitor interval="30s" timeout="70s" depth="0" \
op start interval="0" timeout="120s" \
op stop interval="0" timeout="120s"
Set a password for the mysql root user.
Actual results:
in syslog:
Oct 6 17:44:30 HOST mysql[25802]: INFO: MySQL monitor succeeded
Oct 6 17:44:58 HOST lrmd: [1513]: info: RA output: (rsc_x3_mysql:0:monitor:stderr) ERROR
Oct 6 17:44:58 HOST lrmd: [1513]: info: RA output: (rsc_x3_mysql:0:monitor:stderr) 1045 (28000)
Oct 6 17:44:58 HOST lrmd: [1513]: info: RA output: (rsc_x3_mysql:0:monitor:stderr) : Access denied for user 'root'@'localhost' (using password: NO)
Expected results:
in syslog:
Oct 6 17:44:30 HOST mysql[25802]: INFO: MySQL monitor succeeded
Additional info:
The resource agent for MySQL (/usr/lib/ocf/resource.d/heartbeat/mysql) can monitor a MySQL Server with a simple PID check and a more complex SQL Query. For the SQL query to work you have to specify a username and a password which the script uses to access mysql. You can chose, if you want to execute the SQL check by setting $OCF_CHECK_LEVEL to a Value > 0. This should disable all SQL based checks.
Comment 2RHEL Program Management
2011-10-07 16:04:10 UTC
Since RHEL 6.2 External Beta has begun, and this bug remains
unresolved, it has been rejected as it is not proposed as
exception or blocker.
Red Hat invites you to ask your support representative to
propose this request, if appropriate and relevant, in the
next release of Red Hat Enterprise Linux.