Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.16, 1.1.7
-
None
-
Multi-Server install
Description
columnstoreClusterTester tool pass the Dependent Package Check without taking in consideration the new introduced dependency from jemalloc and forthcoming installs and upgrades will fail
expected : jemalloc dependency is included in columnstoreClusterTester tool Dependent Package Check
run from the PM1 the columnstoreClusterTester tool
Depenancy Package Check pass but cs installation fail due to dependency on 1.0.16 from jemalloc
[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
|
|