Mismatch between clustercheck and xinetd response

[OliverKellyATech]

Hi guys,

Quick question; I am getting a mismatch between the clustercheck response (via cli) and the response returned via the mysqlchk xinetd request:

root@host:~# /usr/local/bin/clustercheck 
HTTP/1.1 200 OK
Content-Type: text/plain
Connection: close
Content-Length: 40

Percona XtraDB Cluster Node is synced.
root@host:~# curl -v http://localhost:9200/
* About to connect() to localhost port 9200 (#0)
*   Trying 127.0.0.1... connected
> GET / HTTP/1.1
> User-Agent: curl/7.22.0 (x86_64-pc-linux-gnu) libcurl/7.22.0 OpenSSL/1.0.1 zlib/1.2.3.4 libidn/1.23 librtmp/2.3
> Host: localhost:9200
> Accept: */*
> 
< HTTP/1.1 503 Service Unavailable
< Content-Type: text/plain
< Connection: close
< Content-Length: 44
< 

/etc/xinetd.d/mysqlchk is configured to simply call server=/usr/local/bin/clustercheck, as per the install instructions.

Any ideas?

[mike-sirs]

show your /etc/xinetd.d/mysqlchk

[vovans82]

This is happening for me too.

[Lovecannon]

For anyone else having this issue, I was able to fix it by changing the mysqlchk xinetd script to use the root user.

[iboxtech]

This is happening for me too.
Anyone can slove it ?

[sruslanas]

I have moved to another utility that is doing exactly the same, but with less effort (written in go, no xinetd required) https://github.com/leoleovich/clusterhc

[weeheavy]

Same problem here, even with the Percona-provided clustercheck script which is based on this here. Attempts like changing the xinetd user and making sure execute permissions are set on the MySQL socket directory didn't help.

Edit: Fixed by not quoting the password in the xinetd definition (in server_args):

Fails:

[...]
server = /usr/bin/clustercheck
server_args = clustercheck "the-password"
[...]

Works:

[...]
server = /usr/bin/clustercheck
server_args = clustercheck the-password
[...]

[metajiji]

Related issue https://bugzilla.redhat.com/show_bug.cgi?id=459553

And for use credentials from .cnf file as workaround use the wrapper script /usr/bin/clustercheck.wrapper like:

#!/bin/sh
/usr/bin/clustercheck "" "" $@

And xinetd config should be:

server = /usr/bin/clustercheck.wrapper
server_args = 0 /dev/null 0 /etc/mysqlchk.cnf

Dont amend chmod +x /usr/bin/clustercheck.wrapper