# Percona XtraDB-Cluster 5.6.21-70.1-56 on CentOS 6.6 Second node won't connect to it.

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-5-6-21-70-1-56-on-centos-6-6-second-node-wont-connect-to-it/4068>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 23, 2015, 11:22am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-6-21-70-1-56-on-centos-6-6-second-node-wont-connect-to-it/4068 "2015-02-23T11:22:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![NeonNexxus](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@NeonNexxus](https://forums.percona.com/u/NeonNexxus)\
**Post date:** [February 23, 2015, 11:22am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-6-21-70-1-56-on-centos-6-6-second-node-wont-connect-to-it/4068/1 "2015-02-23T11:22:50Z")

</div>

Hello everyone.  
In advanced thanks for this community. It has always been helpful for me.  
Here is my Servers Configuration. I know this post will be a bit long but please bear with me.

Server A.  
OS = CentOS = 6.6 Final  
Memory = 4GB  
Processors = 4  
HDD = 30GB to start of space on /var partition  
The root part “/” has 5.8 GB avail from 8 so only 20% used.  
NIC with IP = 192.168.101.12

Server B.  
OS = CentOS = 6.6 Final  
Memory = 4GB  
Processors = 4  
HDD = 30GB to start of space on /var partition  
The root part “/” has 5.8 GB avail from 8 so only 20% used.  
NIC with IP = 192.168.101.13

Server A … here is my.cnf for this server …  
File attached due to size of post

Server B … here is my.cnf for this server …  
File attached due to size of post

On Server A I run … netstat -tuln and I get …

Active Internet connections (only servers)  
Proto Recv-Q Send-Q Local Address Foreign Address State  
tcp 0 0 0.0.0.0:22 0.0.0.0:\* LISTEN  
tcp 0 0 0.0.0.0:4567 0.0.0.0:\* LISTEN  
tcp 0 0 :::22 :::\* LISTEN  
tcp 0 0 :::3306 :::\* LISTEN

On Server A I stop the service and then I tail /var/lib/mysql/MySQL-Cluster0.err while starting and I get this … NOTE \*\* starting the node with command … /etc/init.d/mysql bootstrap-pxc

Here is the log …  
Log attached due to post size. Thanks

Now.  
On both servers I have IPtables turned off and there is no firewall in between since they sit on an internal network as you all can see.  
Now I still tail the log file while trying to connect the second node and this is what I get …

Here is the log from the bootstrapped node. First node… SERVER A  
File attached due to post size

Now I go to the Server A (first node) and check  
less /var/lib/mysql/innobackup.backup.log

and I get this …

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy  
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under  
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:  
[url][Percona XtraBackup - MySQL Database Backup Software](http://www.percona.com/xb/p%5B/url%5D)

150223 11:25:54 innobackupex: Connecting to MySQL server with DSN ‘dbi:mysql:;mysql\_read\_default\_file=/etc/my.cnf;mysql\_read\_default\_group=xtrabackup;mysql\_socket=/var/run/mysqld/mysqld.sock’ (using password: NO).  
innobackupex: got a fatal error with the following stacktrace: at /usr//bin/innobackupex line 3004  
main::mysql\_connect(‘abort\_on\_error’, 1) called at /usr//bin/innobackupex line 1539  
innobackupex: Error: Failed to connect to MySQL server: DBI connect(‘;mysql\_read\_default\_file=/etc/my.cnf;mysql\_read\_default\_group=xtrabackup;mysql\_socket=/var/run/mysqld/mysqld.sock’,‘’,…) failed: Access denied for user ‘root’@‘localhost’ (using password: NO) at /usr//bin/innobackupex line 2988

Again ports 22 - 3306 - 4444 - 4567 - 4568 are all open I double checked that already.  
I have read every thread and tried everything for the past 2 days …  
Sorry if I missed anything and for the long post but I tried to be specific as I could.  
Thanks in advanced to everyone.

PS On Server A (node 1) root already has a password and sstuser is created with the same pass as on node 2 cnf file plus on both servera (Server a & B) under mysql DB mysql user with all rights its created too.

Thank you  
Ed

[Server-A\_my.cnf.txt](https://forums.percona.com/uploads/short-url/2eDhObmj5RTAaG1LBmwoUU5CIba.txt) (2.6 KB)

[Server-B\_my.cnf.txt](https://forums.percona.com/uploads/short-url/3XRv4QN9bZrM6SIBotf03e8MPnI.txt) (2.72 KB)

[Server-A\_var\_lib\_mysql\_log.txt](https://forums.percona.com/uploads/short-url/bkEk5U3MpJuVLKEpSHcLRu8NQv5.txt) (8.94 KB)

[Server-A-Log-while-second-node-joining.txt](https://forums.percona.com/uploads/short-url/4VGLMJQ88WpZIF5qOa4GIN71zs9.txt) (7 KB)
