Cluster failed to start on RHEL 6.2

Hi! So i was trying to set up a little XtraDB cluster on RHEL 6.2 but can’t even start mysql daemon with pretty default settings
Error log shows me the following:

130711 13:43:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130711 13:43:16 mysqld_safe Skipping wsrep-recover for empty datadir: /var/lib/mysql
130711 13:43:16 mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
130711 13:43:16 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
130711 13:43:16 [Note] WSREP: Read nil XID from storage engines, skipping position init
130711 13:43:16 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
130711 13:43:16 [Note] WSREP: wsrep_load(): Galera 2.6(r152) by Codership Oy <info&#64;codership.com> loaded succesfully.
sh: ip: command not found
130711 13:43:16 [ERROR] WSREP: Failed to read output of: 'ip addr show | grep -E '^\s*inet' | grep -m1 global | awk '{ print $2 }' | sed 's/\/.*//''
130711 13:43:16 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address.
130711 13:43:16 [Warning] WSREP: Guessing address for incoming client connections failed. Try setting wsrep_node_incoming_address explicitly.
130711 13:43:16 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat
130711 13:43:16 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
130711 13:43:16 [Note] WSREP: Preallocating 134219048/134219048 bytes in '/var/lib/mysql//galera.cache'...
130711 13:43:16 [Note] WSREP: Passing config to GCS: base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
130711 13:43:16 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
130711 13:43:16 [Note] WSREP: wsrep_sst_grab()
130711 13:43:16 [Note] WSREP: Start replication
130711 13:43:16 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
130711 13:43:16 [Note] WSREP: protonet asio version 0
130711 13:43:16 [Note] WSREP: backend: asio
130711 13:43:16 [Note] WSREP: GMCast version 0
130711 13:43:16 [Note] WSREP: (133a5a59-ea1f-11e2-9843-36ec04bfc440, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
130711 13:43:16 [Note] WSREP: (133a5a59-ea1f-11e2-9843-36ec04bfc440, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
130711 13:43:16 [Note] WSREP: EVS version 0
130711 13:43:16 [Note] WSREP: PC version 0
130711 13:43:16 [Note] WSREP: gcomm: connecting to group 'xtradb_cluster', peer ''
130711 13:43:16 [ERROR] WSREP: Permission denied
130711 13:43:16 [ERROR] WSREP: failed to open gcomm backend connection: 13: error while trying to listen 'tcp://0.0.0.0:4567?socket.non_blocking=1', asio error 'Permission denied': 13 (Permission denied)
at gcomm/src/asio_tcp.cpp:listen():813
130711 13:43:16 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():195: Failed to open backend connection: -13 (Permission denied)
130711 13:43:16 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1289: Failed to open channel 'xtradb_cluster' at 'gcomm://': -13 (Permission denied)
130711 13:43:16 [ERROR] WSREP: gcs connect failed: Permission denied
130711 13:43:16 [ERROR] WSREP: wsrep::connect() failed: 6
130711 13:43:16 [ERROR] Aborting

130711 13:43:16 [Note] WSREP: Service disconnected.
130711 13:43:17 [Note] WSREP: Some threads may fail to exit.
130711 13:43:17 [Note] /usr/sbin/mysqld: Shutdown complete

130711 13:43:17 mysqld_safe mysqld from pid file /var/lib/mysql/HATSYSAID6.pid ended

and my.cnf is:

[mysqld]
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_address=gcomm://
wsrep_slave_threads=4
wsrep_sst_method=xtrabackup
wsrep_cluster_name=xtradb_cluster
wsrep_node_name=node1
binlog_format=ROW
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1

Installed from percona yum repo. There was known problems with mysql-libs so I had just erased it first with rpm -e --nodeps first
I really got no idea what’s wrong here. Everything was working great with Debian, so any kind of hint is greatly appreciated:)

Looks to me like it can’t find the node address for replication. Give specifying the address with the ‘wsrep_node_address’ parameter in the [mysqld] section a try:

wsrep_node_address = ip.address.of.node

Cheers!

Dirk

Hi! I had already tried that. It fixes the

[ERROR] WSREP: Failed to read output of: 'ip addr show

But unfortuantly doesn’t fix that Permission denied error:(

Hmm, strange… I’m not using RH myself, but did you have a look at the SElinux / apparmor thingies? First thing that comes to mind…

Ha…indeed! SElinux was installed and enabled there! RH still feels so different:)​
Thanks alot for the help