# sst/ist not working properly

**URL:** <https://forums.percona.com/t/sst-ist-not-working-properly/5965>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [October 30, 2017, 3:25pm UTC](https://forums.percona.com/t/sst-ist-not-working-properly/5965 "2017-10-30T15:25:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ramzeyphysiq](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramzeyphysiq/32/1193_2.png) [@ramzeyphysiq](https://forums.percona.com/u/ramzeyphysiq)\
**Post date:** [October 30, 2017, 3:25pm UTC](https://forums.percona.com/t/sst-ist-not-working-properly/5965/1 "2017-10-30T15:25:48Z")

</div>

i get the following error when trying to get my second node to join the the first boostrapped node. below is my config

2017-10-30T20:19:21.748969Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘172.16.99.182’ --datadir ‘/physiq/mysql/data/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1891’ ‘’ )  
which: no openssl in (/usr/sbin:/sbin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin)  
2017-10-30T20:19:22.356645Z 0 [ERROR] WSREP: Failed to read ‘ready ’ from: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘172.16.99.182’ --datadir ‘/physiq/mysql/data/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1891’ ‘’  
Read: ‘‘openssl’ not found in PATH’  
2017-10-30T20:19:22.361146Z 0 [ERROR] WSREP: Process completed with error: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘172.16.99.182’ --datadir ‘/physiq/mysql/data/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1891’ ‘’ : 2 (No such file or directory)  
2017-10-30T20:19:22.361282Z 1 [ERROR] WSREP: Failed to prepare for ‘xtrabackup-v2’ SST. Unrecoverable.  
2017-10-30T20:19:22.361323Z 1 [ERROR] Aborting

[mysqld]  
datadir=/physiq/mysql/data  
log-error=/var/log/mysqld.log

# replication and binlog related options

user=mysql  
wsrep\_provider=/usr/lib64/libgalera\_smm.so  
wsrep\_cluster\_name=pxc-cluster  
wsrep\_cluster\_address=gcomm://172.16.99.181,172.16.99.182,172.16.99.183

wsrep\_node\_address=172.16.99.182  
wsrep\_node\_name=lxc-rdbms-02

wsrep\_sst\_method=xtrabackup-v2  
wsrep\_sst\_auth=sstuser:s3cret

log\_error\_verbosity=3  
default\_storage\_engine=InnoDB  
innodb\_autoinc\_lock\_mode=2  
pxc\_encrypt\_cluster\_traffic=ON  
ssl-ca=/physiq/mysql/ca.pem  
ssl-cert=/physiq/mysql/server-cert.pem  
ssl-key=/physiq/mysql/server-key.pem

Once I enable ssl and sst on my perconadb cluster i get the following message when my second node tries to join up with the bootstrapped node. I have no clue how to troubleshoot this as I dont see anything on the boostrapped node indicating a problem.

2017-10-30T19:56:57.291819Z 0 [Note] WSREP: Flow-control interval: [141, 141]  
2017-10-30T19:56:57.291835Z 0 [Note] WSREP: Trying to continue unpaused monitor  
2017-10-30T19:56:57.291847Z 0 [Note] WSREP: Shifting OPEN → PRIMARY (TO: 0)  
2017-10-30T19:56:57.291934Z 2 [Note] WSREP: State transfer required:  
Group state: 0191138b-bdac-11e7-b22c-9f7765bc7e83:0  
Local state: 00000000-0000-0000-0000-000000000000:-1  
2017-10-30T19:56:57.291959Z 2 [Note] WSREP: New cluster view: global state: 0191138b-bdac-11e7-b22c-9f7765bc7e83:0, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 3  
2017-10-30T19:56:57.291973Z 2 [Note] WSREP: Setting wsrep\_ready to true  
2017-10-30T19:56:57.291985Z 2 [Warning] WSREP: Gap in state sequence. Need state transfer.  
2017-10-30T19:56:57.291995Z 2 [Note] WSREP: Setting wsrep\_ready to false  
2017-10-30T19:56:57.292092Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘172.16.99.182’ --datadir ‘/physiq/mysql/data/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘780’ ‘’ )  
which: no openssl in (/usr/sbin:/sbin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin)  
2017-10-30T19:56:57.973232Z 0 [ERROR] WSREP: Failed to read ‘ready ’ from: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘172.16.99.182’ --datadir ‘/physiq/mysql/data/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘780’ ‘’  
Read: ‘‘openssl’ not found in PATH’  
2017-10-30T19:56:57.977945Z 0 [ERROR] WSREP: Process completed with error: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘172.16.99.182’ --datadir ‘/physiq/mysql/data/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘780’ ‘’ : 2 (No such file or directory)  
2017-10-30T19:56:57.978156Z 2 [ERROR] WSREP: Failed to prepare for ‘xtrabackup-v2’ SST. Unrecoverable.  
2017-10-30T19:56:57.978189Z 2 [ERROR] Aborting

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [October 31, 2017, 9:17am UTC](https://forums.percona.com/t/sst-ist-not-working-properly/5965/2 "2017-10-31T09:17:02Z")

</div>

> [@ramzeyphysiq;49967](#):
>
> i get the following error when trying to get my second node to join the the first boostrapped node. below is my config
> 
> Read: ‘‘openssl’ not found in PATH’

As error indicates, install openssl packages for your OS
