[root@pm1 ~]#  /usr/local/mariadb/columnstore/bin/columnstoreClusterTester.sh --ipaddr=172.20.2.205,172.20.2.206

*** This is the MariaDB Columnstore Cluster System test tool ***

** Validate local OS is supported

Local Node OS System Name : CentOS Linux 7 (Core)

** Run Ping access Test to remote nodes

172.20.2.205  Node Passed ping test

172.20.2.206  Node Passed ping test

** Run SSH Login access Test to remote nodes

172.20.2.205  Node Passed SSH login test using ssh-keys

172.20.2.206  Node Passed SSH login test using ssh-keys

** Run OS check - OS version needs to be the same on all nodes

Local Node OS Version : CentOS Linux 7 (Core)

172.20.2.205 Node OS Version : CentOS Linux 7 (Core)

172.20.2.206 Node OS Version : CentOS Linux 7 (Core)

** Run Locale check - Locale needs to be the same on all nodes

Local Node Locale : LANG=en_US.UTF-8

172.20.2.205 Node Locale : LANG=en_US.UTF-8

172.20.2.206 Node Locale : LANG=en_US.UTF-8

** Run SELINUX check - Setting should to be disabled on all nodes

Local Node SELINUX setting is Not Enabled

172.20.2.205 Node SELINUX setting is Not Enabled

172.20.2.206 Node SELINUX setting is Not Enabled

** Run Firewall Services check - Firewall Services should to be Inactive on all nodes

Local Node iptables service is Not Active

Local Node ufw service is Not Active

Local Node firewalld service is Not Active

Local Node firewall service is Not Active

172.20.2.205 Node iptables service is Not Enabled

172.20.2.205 Node ufw service is Not Enabled

172.20.2.205 Node firewalld service is Not Enabled

172.20.2.205 Node firewall service is Not Enabled

172.20.2.206 Node iptables service is Not Enabled

172.20.2.206 Node ufw service is Not Enabled

172.20.2.206 Node firewalld service is Not Enabled

172.20.2.206 Node firewall service is Not Enabled

** Run MariaDB ColumnStore Port (8600-8620) availibility test

172.20.2.205  Node Passed port test

172.20.2.206  Node Passed port test

** Run Date/Time check - Date/Time should be within 10 seconds on all nodes

Passed: 172.20.2.205 Node date/time is within 10 seconds of local node

Passed: 172.20.2.206 Node date/time is within 10 seconds of local node

** Run MariaDB ColumnStore Dependent Package Check

Local Node - Passed, all dependency packages are installed

172.20.2.205 Node - Passed, all dependency packages are installed

172.20.2.206 Node - Passed, all dependency packages are installed

[root@pm1 ~]# /usr/local/mariadb/columnstore/bin/postConfigure

This is the MariaDB ColumnStore System Configuration and Installation tool.

It will Configure the MariaDB ColumnStore System and will perform a Package

Installation of all of the Servers within the System that is being configured.

IMPORTANT: This tool should only be run on the Parent OAM Module

           which is a Performance Module, preferred Module #1

Prompting instructions:

        Press 'enter' to accept a value in (), if available or

        Enter one of the options within [], if available, or

        Enter a new value

A copy of the MariaDB ColumnStore Configuration file has been saved during Package install.

It's Configured for a Multi-Server Install.

You have an option of utilizing the configuration data from that file or starting

with the MariaDB ColumnStore Configuration File that comes with the MariaDB ColumnStore Package.

You will only want to utilize the old configuration data when performing the same

type of install, i.e. Single or Multi-Server

Do you want to utilize the configuration data from the saved copy? [y,n]  > n

===== Setup System Server Type Configuration =====

There are 2 options when configuring the System Server Type: single and multi

  'single'  - Single-Server install is used when there will only be 1 server configured

              on the system. It can also be used for production systems, if the plan is

              to stay single-server.

  'multi'   - Multi-Server install is used when you want to configure multiple servers now or

              in the future. With Multi-Server install, you can still configure just 1 server

              now and add on addition servers/modules in the future.

Select the type of System Server install [1=single, 2=multi] (2) > 2

===== Setup System Module Type Configuration =====

There are 2 options when configuring the System Module Type: separate and combined

  'separate' - User and Performance functionality on separate servers.

  'combined' - User and Performance functionality on the same server

Select the type of System Module Install [1=separate, 2=combined] (2) > 1

Seperate Server Installation will be performed.

NOTE: Local Query Feature allows the ability to query data from a single Performance

      Module. Check MariaDB ColumnStore Admin Guide for additional information.

Enable Local Query feature? [y,n] (n) > n

NOTE: The MariaDB ColumnStore Schema Sync feature will replicate all of the

      schemas and InnoDB tables across the User Module nodes. This feature can be enabled

      or disabled, for example, if you wish to configure your own replication post installation.

MariaDB ColumnStore Schema Sync feature, do you want to enable? [y,n] (y) > n

Enter System Name (columnstore-1) >

===== Setup Storage Configuration =====

----- Setup Performance Module DBRoot Data Storage Mount Configuration -----

There are 3 options when configuring the storage: internal, external, or gluster

  'internal' -    This is specified when a local disk is used for the DBRoot storage.

                  High Availability Server Failover is not Supported in this mode

  'external' -    This is specified when the DBRoot directories are mounted.

                  High Availability Server Failover is Supported in this mode.

  'GlusterFS' -   This is specified when GlusterFS Data Redundancy is installed

                  and you want the DBRoot directories to be controlled by glusterfs.

                  High Availability Server Failover is Supported in this mode.

Select the type of Data Storage [1=internal, 2=external, 3=GlusterFS] (1) > 1

===== Setup Memory Configuration =====

NOTE: Setting 'NumBlocksPct' to 70%

      Setting 'TotalUmMemory' to 50%

===== Setup the Module Configuration =====

----- User Module Configuration -----

Enter number of User Modules [1,1024] (1) > 1

*** User Module #1 Configuration ***

Enter Nic Interface #1 Host Name (unassigned) > um1

Enter Nic Interface #1 IP Address of um1 (172.20.2.206) >

Enter Nic Interface #2 Host Name (unassigned) >

----- Performance Module Configuration -----

Enter number of Performance Modules [1,1024] (1) > 1

*** Parent OAM Module Performance Module #1 Configuration ***

Enter Nic Interface #1 Host Name (pm1.xentio.lan) >

Enter Nic Interface #1 IP Address of pm1.xentio.lan (172.20.2.205) >

Enter Nic Interface #2 Host Name (unassigned) >

Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1) > 1

===== System Installation =====

System Configuration is complete, System Installation is the next step.

Would you like to continue with the System Installation? [y,n] (y) > y

Performing an MariaDB ColumnStore System install using RPM packages

located in the /root directory.

Next step is to enter the password to access the other Servers.

This is either your password or you can default to using a ssh key

If using a password, the password needs to be the same on all Servers.

Enter password, hit 'enter' to default to using a ssh key, or 'exit' >

----- Performing Install on 'um1 / um1' -----

Install log file is located here: /tmp/um1_rpm_install.log

MariaDB ColumnStore Package being installed, please wait ...

Failure with a remote module install, check install log files in /tmp

 cat  /tmp/um1_rpm_install.log

 ssh -v root@172.20.2.206 'time'

[root@pm1 ~]# ssh -v root@172.20.2.206 'time'

OpenSSH_7.4p1, OpenSSL 1.0.2k-fips  26 Jan 2017

debug1: Reading configuration data /etc/ssh/ssh_config

debug1: /etc/ssh/ssh_config line 58: Applying options for *

debug1: Connecting to 172.20.2.206 [172.20.2.206] port 22.

debug1: Connection established.

debug1: permanently_set_uid: 0/0

debug1: identity file /root/.ssh/id_rsa type 1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_rsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519 type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519-cert type -1

debug1: Enabling compatibility mode for protocol 2.0

debug1: Local version string SSH-2.0-OpenSSH_7.4

debug1: Remote protocol version 2.0, remote software version OpenSSH_7.4

debug1: match: OpenSSH_7.4 pat OpenSSH* compat 0x04000000

debug1: Authenticating to 172.20.2.206:22 as 'root'

debug1: SSH2_MSG_KEXINIT sent

debug1: SSH2_MSG_KEXINIT received

debug1: kex: algorithm: curve25519-sha256

debug1: kex: host key algorithm: ecdsa-sha2-nistp256

debug1: kex: server->client cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: client->server cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: expecting SSH2_MSG_KEX_ECDH_REPLY

debug1: Server host key: ecdsa-sha2-nistp256 SHA256:AUzwld0RTZn2QbekZIcIqfzCxagXZ+nhsSyE9N99KVQ

debug1: Host '172.20.2.206' is known and matches the ECDSA host key.

debug1: Found key in /root/.ssh/known_hosts:24

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_NEWKEYS sent

debug1: expecting SSH2_MSG_NEWKEYS

debug1: SSH2_MSG_NEWKEYS received

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_EXT_INFO received

debug1: kex_input_ext_info: server-sig-algs=<rsa-sha2-256,rsa-sha2-512>

debug1: SSH2_MSG_SERVICE_ACCEPT received

debug1: Authentications that can continue: publickey,gssapi-keyex,gssapi-with-mic,password

debug1: Next authentication method: gssapi-keyex

debug1: No valid Key exchange context

debug1: Next authentication method: gssapi-with-mic

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Next authentication method: publickey

debug1: Offering RSA public key: /root/.ssh/id_rsa

debug1: Server accepts key: pkalg rsa-sha2-512 blen 279

debug1: Authentication succeeded (publickey).

Authenticated to 172.20.2.206 ([172.20.2.206]:22).

debug1: channel 0: new [client-session]

debug1: Requesting no-more-sessions@openssh.com

debug1: Entering interactive session.

debug1: pledge: network

debug1: client_input_global_request: rtype hostkeys-00@openssh.com want_reply 0

debug1: Sending environment.

debug1: Sending env LANG = en_US.UTF-8

debug1: Sending command: time

real    0m0.000s

user    0m0.000s

sys     0m0.000s

debug1: client_input_channel_req: channel 0 rtype exit-status reply 0

debug1: client_input_channel_req: channel 0 rtype eow@openssh.com reply 0

debug1: channel 0: free: client-session, nchannels 1

Transferred: sent 2856, received 2784 bytes, in 0.1 seconds

Bytes per second: sent 32874.5, received 32045.7

debug1: Exit status 0

DONE

Stop ColumnStore service                       ssh -v root@172.20.2.206 '/usr/local/mariadb/columnstore/bin/columnstore stop'

[root@pm1 ~]# ssh -v root@172.20.2.206 '/usr/local/mariadb/columnstore/bin/columnstore stop'

OpenSSH_7.4p1, OpenSSL 1.0.2k-fips  26 Jan 2017

debug1: Reading configuration data /etc/ssh/ssh_config

debug1: /etc/ssh/ssh_config line 58: Applying options for *

debug1: Connecting to 172.20.2.206 [172.20.2.206] port 22.

debug1: Connection established.

debug1: permanently_set_uid: 0/0

debug1: identity file /root/.ssh/id_rsa type 1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_rsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519 type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519-cert type -1

debug1: Enabling compatibility mode for protocol 2.0

debug1: Local version string SSH-2.0-OpenSSH_7.4

debug1: Remote protocol version 2.0, remote software version OpenSSH_7.4

debug1: match: OpenSSH_7.4 pat OpenSSH* compat 0x04000000

debug1: Authenticating to 172.20.2.206:22 as 'root'

debug1: SSH2_MSG_KEXINIT sent

debug1: SSH2_MSG_KEXINIT received

debug1: kex: algorithm: curve25519-sha256

debug1: kex: host key algorithm: ecdsa-sha2-nistp256

debug1: kex: server->client cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: client->server cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: expecting SSH2_MSG_KEX_ECDH_REPLY

debug1: Server host key: ecdsa-sha2-nistp256 SHA256:AUzwld0RTZn2QbekZIcIqfzCxagXZ+nhsSyE9N99KVQ

debug1: Host '172.20.2.206' is known and matches the ECDSA host key.

debug1: Found key in /root/.ssh/known_hosts:24

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_NEWKEYS sent

debug1: expecting SSH2_MSG_NEWKEYS

debug1: SSH2_MSG_NEWKEYS received

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_EXT_INFO received

debug1: kex_input_ext_info: server-sig-algs=<rsa-sha2-256,rsa-sha2-512>

debug1: SSH2_MSG_SERVICE_ACCEPT received

debug1: Authentications that can continue: publickey,gssapi-keyex,gssapi-with-mic,password

debug1: Next authentication method: gssapi-keyex

debug1: No valid Key exchange context

debug1: Next authentication method: gssapi-with-mic

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Next authentication method: publickey

debug1: Offering RSA public key: /root/.ssh/id_rsa

debug1: Server accepts key: pkalg rsa-sha2-512 blen 279

debug1: Authentication succeeded (publickey).

Authenticated to 172.20.2.206 ([172.20.2.206]:22).

debug1: channel 0: new [client-session]

debug1: Requesting no-more-sessions@openssh.com

debug1: Entering interactive session.

debug1: pledge: network

debug1: client_input_global_request: rtype hostkeys-00@openssh.com want_reply 0

debug1: Sending environment.

debug1: Sending env LANG = en_US.UTF-8

debug1: Sending command: /usr/local/mariadb/columnstore/bin/columnstore stop

bash: /usr/local/mariadb/columnstore/bin/columnstore: No such file or directory

debug1: client_input_channel_req: channel 0 rtype exit-status reply 0

debug1: client_input_channel_req: channel 0 rtype eow@openssh.com reply 0

debug1: channel 0: free: client-session, nchannels 1

Transferred: sent 2904, received 2824 bytes, in 0.1 seconds

Bytes per second: sent 37730.5, received 36691.0

debug1: Exit status 127

DONE

Erase MariaDB Columnstore Packages on Module                 ssh -v root@172.20.2.206 'rpm -e --nodeps $(rpm -qa | grep '^mariadb-columnstore') '

[root@pm1 ~]# ssh -v root@172.20.2.206 'rpm -e --nodeps $(rpm -qa | grep '^mariadb-columnstore') '

OpenSSH_7.4p1, OpenSSL 1.0.2k-fips  26 Jan 2017

debug1: Reading configuration data /etc/ssh/ssh_config

debug1: /etc/ssh/ssh_config line 58: Applying options for *

debug1: Connecting to 172.20.2.206 [172.20.2.206] port 22.

debug1: Connection established.

debug1: permanently_set_uid: 0/0

debug1: identity file /root/.ssh/id_rsa type 1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_rsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519 type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519-cert type -1

debug1: Enabling compatibility mode for protocol 2.0

debug1: Local version string SSH-2.0-OpenSSH_7.4

debug1: Remote protocol version 2.0, remote software version OpenSSH_7.4

debug1: match: OpenSSH_7.4 pat OpenSSH* compat 0x04000000

debug1: Authenticating to 172.20.2.206:22 as 'root'

debug1: SSH2_MSG_KEXINIT sent

debug1: SSH2_MSG_KEXINIT received

debug1: kex: algorithm: curve25519-sha256

debug1: kex: host key algorithm: ecdsa-sha2-nistp256

debug1: kex: server->client cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: client->server cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: expecting SSH2_MSG_KEX_ECDH_REPLY

debug1: Server host key: ecdsa-sha2-nistp256 SHA256:AUzwld0RTZn2QbekZIcIqfzCxagXZ+nhsSyE9N99KVQ

debug1: Host '172.20.2.206' is known and matches the ECDSA host key.

debug1: Found key in /root/.ssh/known_hosts:24

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_NEWKEYS sent

debug1: expecting SSH2_MSG_NEWKEYS

debug1: SSH2_MSG_NEWKEYS received

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_EXT_INFO received

debug1: kex_input_ext_info: server-sig-algs=<rsa-sha2-256,rsa-sha2-512>

debug1: SSH2_MSG_SERVICE_ACCEPT received

debug1: Authentications that can continue: publickey,gssapi-keyex,gssapi-with-mic,password

debug1: Next authentication method: gssapi-keyex

debug1: No valid Key exchange context

debug1: Next authentication method: gssapi-with-mic

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Next authentication method: publickey

debug1: Offering RSA public key: /root/.ssh/id_rsa

debug1: Server accepts key: pkalg rsa-sha2-512 blen 279

debug1: Authentication succeeded (publickey).

Authenticated to 172.20.2.206 ([172.20.2.206]:22).

debug1: channel 0: new [client-session]

debug1: Requesting no-more-sessions@openssh.com

debug1: Entering interactive session.

debug1: pledge: network

debug1: client_input_global_request: rtype hostkeys-00@openssh.com want_reply 0

debug1: Sending environment.

debug1: Sending env LANG = en_US.UTF-8

debug1: Sending command: rpm -e --nodeps $(rpm -qa | grep ^mariadb-columnstore)

debug1: client_input_channel_req: channel 0 rtype exit-status reply 0

debug1: client_input_channel_req: channel 0 rtype eow@openssh.com reply 0

rpm: no packages given for erase

debug1: channel 0: free: client-session, nchannels 1

Transferred: sent 2904, received 2776 bytes, in 1.2 seconds

Bytes per second: sent 2456.6, received 2348.3

debug1: Exit status 1

[root@pm1 ~]# DONE

Copy New MariaDB Columnstore Package to Module              ssh -v root@172.20.2.206 'rm -f /root/mariadb-columnstore-*.rpm'

OpenSSH_7.4p1, OpenSSL 1.0.2k-fips  26 Jan 2017

debug1: Reading configuration data /etc/ssh/ssh_config

debug1: /etc/ssh/ssh_config line 58: Applying options for *

debug1: Connecting to 172.20.2.206 [172.20.2.206] port 22.

debug1: Connection established.

debug1: permanently_set_uid: 0/0

debug1: identity file /root/.ssh/id_rsa type 1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_rsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519 type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519-cert type -1

debug1: Enabling compatibility mode for protocol 2.0

debug1: Local version string SSH-2.0-OpenSSH_7.4

debug1: Remote protocol version 2.0, remote software version OpenSSH_7.4

debug1: match: OpenSSH_7.4 pat OpenSSH* compat 0x04000000

debug1: Authenticating to 172.20.2.206:22 as 'root'

debug1: SSH2_MSG_KEXINIT sent

debug1: SSH2_MSG_KEXINIT received

debug1: kex: algorithm: curve25519-sha256

debug1: kex: host key algorithm: ecdsa-sha2-nistp256

debug1: kex: server->client cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: client->server cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: expecting SSH2_MSG_KEX_ECDH_REPLY

debug1: Server host key: ecdsa-sha2-nistp256 SHA256:AUzwld0RTZn2QbekZIcIqfzCxagXZ+nhsSyE9N99KVQ

debug1: Host '172.20.2.206' is known and matches the ECDSA host key.

debug1: Found key in /root/.ssh/known_hosts:24

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_NEWKEYS sent

debug1: expecting SSH2_MSG_NEWKEYS

debug1: SSH2_MSG_NEWKEYS received

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_EXT_INFO received

debug1: kex_input_ext_info: server-sig-algs=<rsa-sha2-256,rsa-sha2-512>

debug1: SSH2_MSG_SERVICE_ACCEPT received

debug1: Authentications that can continue: publickey,gssapi-keyex,gssapi-with-mic,password

debug1: Next authentication method: gssapi-keyex

debug1: No valid Key exchange context

debug1: Next authentication method: gssapi-with-mic

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Next authentication method: publickey

debug1: Offering RSA public key: /root/.ssh/id_rsa

debug1: Server accepts key: pkalg rsa-sha2-512 blen 279

debug1: Authentication succeeded (publickey).

Authenticated to 172.20.2.206 ([172.20.2.206]:22).

debug1: channel 0: new [client-session]

debug1: Requesting no-more-sessions@openssh.com

debug1: Entering interactive session.

debug1: pledge: network

debug1: client_input_global_request: rtype hostkeys-00@openssh.com want_reply 0

debug1: Sending environment.

debug1: Sending env LANG = en_US.UTF-8

debug1: Sending command: rm -f /root/mariadb-columnstore-*.rpm

debug1: client_input_channel_req: channel 0 rtype exit-status reply 0

debug1: client_input_channel_req: channel 0 rtype eow@openssh.com reply 0

debug1: channel 0: free: client-session, nchannels 1

Transferred: sent 2888, received 2716 bytes, in 0.1 seconds

Bytes per second: sent 19777.3, received 18599.4

debug1: Exit status 0

DONE[root@pm1 ~]# scp -v /root/mariadb-columnstore*1.0.16-1*rpm root@172.20.2.206:.

Executing: program /usr/bin/ssh host 172.20.2.206, user root, command scp -v -d -t .

OpenSSH_7.4p1, OpenSSL 1.0.2k-fips  26 Jan 2017

debug1: Reading configuration data /etc/ssh/ssh_config

debug1: /etc/ssh/ssh_config line 58: Applying options for *

debug1: Connecting to 172.20.2.206 [172.20.2.206] port 22.

debug1: Connection established.

debug1: permanently_set_uid: 0/0

debug1: identity file /root/.ssh/id_rsa type 1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_rsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519 type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519-cert type -1

debug1: Enabling compatibility mode for protocol 2.0

debug1: Local version string SSH-2.0-OpenSSH_7.4

debug1: Remote protocol version 2.0, remote software version OpenSSH_7.4

debug1: match: OpenSSH_7.4 pat OpenSSH* compat 0x04000000

debug1: Authenticating to 172.20.2.206:22 as 'root'

debug1: SSH2_MSG_KEXINIT sent

debug1: SSH2_MSG_KEXINIT received

debug1: kex: algorithm: curve25519-sha256

debug1: kex: host key algorithm: ecdsa-sha2-nistp256

debug1: kex: server->client cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: client->server cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: expecting SSH2_MSG_KEX_ECDH_REPLY

debug1: Server host key: ecdsa-sha2-nistp256 SHA256:AUzwld0RTZn2QbekZIcIqfzCxagXZ+nhsSyE9N99KVQ

debug1: Host '172.20.2.206' is known and matches the ECDSA host key.

debug1: Found key in /root/.ssh/known_hosts:24

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_NEWKEYS sent

debug1: expecting SSH2_MSG_NEWKEYS

debug1: SSH2_MSG_NEWKEYS received

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_EXT_INFO received

debug1: kex_input_ext_info: server-sig-algs=<rsa-sha2-256,rsa-sha2-512>

debug1: SSH2_MSG_SERVICE_ACCEPT received

debug1: Authentications that can continue: publickey,gssapi-keyex,gssapi-with-mic,password

debug1: Next authentication method: gssapi-keyex

debug1: No valid Key exchange context

debug1: Next authentication method: gssapi-with-mic

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Next authentication method: publickey

debug1: Offering RSA public key: /root/.ssh/id_rsa

debug1: Server accepts key: pkalg rsa-sha2-512 blen 279

debug1: Authentication succeeded (publickey).

Authenticated to 172.20.2.206 ([172.20.2.206]:22).

debug1: channel 0: new [client-session]

debug1: Requesting no-more-sessions@openssh.com

debug1: Entering interactive session.

debug1: pledge: network

debug1: client_input_global_request: rtype hostkeys-00@openssh.com want_reply 0

debug1: Sending environment.

debug1: Sending env LANG = en_US.UTF-8

debug1: Sending command: scp -v -d -t .

Sending file modes: C0600 12084192 mariadb-columnstore-1.0.16-1-x86_64-centos7-client.rpm

Sink: C0600 12084192 mariadb-columnstore-1.0.16-1-x86_64-centos7-client.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-client.rpm                                                                                                                   100%   12MB  92.1MB/s   00:00

Sending file modes: C0600 124240 mariadb-columnstore-1.0.16-1-x86_64-centos7-common.rpm

Sink: C0600 124240 mariadb-columnstore-1.0.16-1-x86_64-centos7-common.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-common.rpm                                                                                                                   100%  121KB  51.3MB/s   00:00

Sending file modes: C0600 18820 mariadb-columnstore-1.0.16-1-x86_64-centos7-gssapi-client.rpm

Sink: C0600 18820 mariadb-columnstore-1.0.16-1-x86_64-centos7-gssapi-client.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-gssapi-client.rpm                                                                                                            100%   18KB  18.2MB/s   00:00

Sending file modes: C0600 46440 mariadb-columnstore-1.0.16-1-x86_64-centos7-gssapi-server.rpm

Sink: C0600 46440 mariadb-columnstore-1.0.16-1-x86_64-centos7-gssapi-server.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-gssapi-server.rpm                                                                                                            100%   45KB  35.8MB/s   00:00

Sending file modes: C0600 56741196 mariadb-columnstore-1.0.16-1-x86_64-centos7-libs.rpm

Sink: C0600 56741196 mariadb-columnstore-1.0.16-1-x86_64-centos7-libs.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-libs.rpm                                                                                                                     100%   54MB 109.1MB/s   00:00

Sending file modes: C0600 2280924 mariadb-columnstore-1.0.16-1-x86_64-centos7-platform.rpm

Sink: C0600 2280924 mariadb-columnstore-1.0.16-1-x86_64-centos7-platform.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-platform.rpm                                                                                                                 100% 2227KB 106.7MB/s   00:00

Sending file modes: C0600 76465836 mariadb-columnstore-1.0.16-1-x86_64-centos7-server.rpm

Sink: C0600 76465836 mariadb-columnstore-1.0.16-1-x86_64-centos7-server.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-server.rpm                                                                                                                   100%   73MB 126.6MB/s   00:00

Sending file modes: C0600 1245144 mariadb-columnstore-1.0.16-1-x86_64-centos7-shared.rpm

Sink: C0600 1245144 mariadb-columnstore-1.0.16-1-x86_64-centos7-shared.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-shared.rpm                                                                                                                   100% 1216KB 113.4MB/s   00:00

Sending file modes: C0600 6876964 mariadb-columnstore-1.0.16-1-x86_64-centos7-storage-engine.rpm

Sink: C0600 6876964 mariadb-columnstore-1.0.16-1-x86_64-centos7-storage-engine.rpm

mariadb-columnstore-1.0.16-1-x86_64-centos7-storage-engine.rpm                                                                                                           100% 6716KB 123.1MB/s   00:00

debug1: client_input_channel_req: channel 0 rtype exit-status reply 0

debug1: channel 0: free: client-session, nchannels 1

debug1: fd 0 clearing O_NONBLOCK

debug1: fd 1 clearing O_NONBLOCK

Transferred: sent 156035536, received 37144 bytes, in 1.4 seconds

Bytes per second: sent 112708320.3, received 26830.0

debug1: Exit status 0

DONE

Install MariaDB Columnstore Packages on Module               ssh -v root@172.20.2.206 'rpm -ivh -h --force mariadb-columnstore*1.0.16-1*rpm '

[root@pm1 ~]# ssh -v root@172.20.2.206 'rpm -ivh -h --force mariadb-columnstore*1.0.16-1*rpm '

OpenSSH_7.4p1, OpenSSL 1.0.2k-fips  26 Jan 2017

debug1: Reading configuration data /etc/ssh/ssh_config

debug1: /etc/ssh/ssh_config line 58: Applying options for *

debug1: Connecting to 172.20.2.206 [172.20.2.206] port 22.

debug1: Connection established.

debug1: permanently_set_uid: 0/0

debug1: identity file /root/.ssh/id_rsa type 1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_rsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_dsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ecdsa-cert type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519 type -1

debug1: key_load_public: No such file or directory

debug1: identity file /root/.ssh/id_ed25519-cert type -1

debug1: Enabling compatibility mode for protocol 2.0

debug1: Local version string SSH-2.0-OpenSSH_7.4

debug1: Remote protocol version 2.0, remote software version OpenSSH_7.4

debug1: match: OpenSSH_7.4 pat OpenSSH* compat 0x04000000

debug1: Authenticating to 172.20.2.206:22 as 'root'

debug1: SSH2_MSG_KEXINIT sent

debug1: SSH2_MSG_KEXINIT received

debug1: kex: algorithm: curve25519-sha256

debug1: kex: host key algorithm: ecdsa-sha2-nistp256

debug1: kex: server->client cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: client->server cipher: chacha20-poly1305@openssh.com MAC: <implicit> compression: none

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: kex: curve25519-sha256 need=64 dh_need=64

debug1: expecting SSH2_MSG_KEX_ECDH_REPLY

debug1: Server host key: ecdsa-sha2-nistp256 SHA256:AUzwld0RTZn2QbekZIcIqfzCxagXZ+nhsSyE9N99KVQ

debug1: Host '172.20.2.206' is known and matches the ECDSA host key.

debug1: Found key in /root/.ssh/known_hosts:24

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_NEWKEYS sent

debug1: expecting SSH2_MSG_NEWKEYS

debug1: SSH2_MSG_NEWKEYS received

debug1: rekey after 134217728 blocks

debug1: SSH2_MSG_EXT_INFO received

debug1: kex_input_ext_info: server-sig-algs=<rsa-sha2-256,rsa-sha2-512>

debug1: SSH2_MSG_SERVICE_ACCEPT received

debug1: Authentications that can continue: publickey,gssapi-keyex,gssapi-with-mic,password

debug1: Next authentication method: gssapi-keyex

debug1: No valid Key exchange context

debug1: Next authentication method: gssapi-with-mic

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Unspecified GSS failure.  Minor code may provide more information

No Kerberos credentials available (default cache: KEYRING:persistent:0)

debug1: Next authentication method: publickey

debug1: Offering RSA public key: /root/.ssh/id_rsa

debug1: Server accepts key: pkalg rsa-sha2-512 blen 279

debug1: Authentication succeeded (publickey).

Authenticated to 172.20.2.206 ([172.20.2.206]:22).

debug1: channel 0: new [client-session]

debug1: Requesting no-more-sessions@openssh.com

debug1: Entering interactive session.

debug1: pledge: network

debug1: client_input_global_request: rtype hostkeys-00@openssh.com want_reply 0

debug1: Sending environment.

debug1: Sending env LANG = en_US.UTF-8

debug1: Sending command: rpm -ivh -h --force mariadb-columnstore*1.0.16-1*rpm

error: Failed dependencies:

        jemalloc is needed by mariadb-columnstore-platform-1.0.16-1.x86_64

        libjemalloc.so.1()(64bit) is needed by mariadb-columnstore-platform-1.0.16-1.x86_64

        libjemalloc.so.1()(64bit) is needed by mariadb-columnstore-server-1.0.16-1.el7.centos.x86_64

        libjemalloc.so.1()(64bit) is needed by mariadb-columnstore-storage-engine-1.0.16-1.x86_64

ERROR: Failed dependencies

*** Installation ERROR