[MCOL-1058] cluster tester enhancements - check for mysql password and mariadb-libs package Created: 2017-11-29  Updated: 2023-10-26  Resolved: 2018-01-23

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.1.2
Fix Version/s: 1.1.3

Type: New Feature Priority: Minor
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-02

 Description   

cluster tester enhancements

1. check for mysql password
2. check that mariadb-libs package isnt installed



 Comments   
Comment by David Hill (Inactive) [ 2018-01-16 ]

added code to check if these mariadb packages are installed based on OS and report error if one of them is installed.

CENTOS6/7 = "mariadb-libs"
SUSE12 = "mariadb" , "libmariadb18"
UBUNTU16 = "mariadb-server" "libmariadb18"
DEBIAN 8/9 = "mariadb-server" "libmariadb18"

-------------------------------------------

results when not installed

./columnstoreClusterTester.sh

      • This is the MariaDB Columnstore Cluster System test tool ***
    • Validate local OS is supported

Local Node OS System Name : Debian GNU/Linux 9 (stretch)

    • Run MariaDB ColumnStore Dependent Package Check

Local Node - Passed, all dependency packages are installed
Local Node - Passed, all packages that should not be installed aren't installed

      • Finished Validation of the Cluster, all Test Passed ***

RESULTS WHEN ONE IS INSTALLED

./columnstoreClusterTester.sh

      • This is the MariaDB Columnstore Cluster System test tool ***
    • Validate local OS is supported

Local Node OS System Name : Debian GNU/Linux 9 (stretch)

    • Run MariaDB ColumnStore Dependent Package Check

Local Node - Passed, all dependency packages are installed
Failed, Local Node package mariadb-server is installed, please un-install

Failure occurred, do you want to continue? (y,n) > y

      • Finished Validation of the Cluster, Failures occurred. Check for Error/Failed test results ***
Comment by David Hill (Inactive) [ 2018-01-17 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/369

Comment by Ben Thompson (Inactive) [ 2018-01-17 ]

Reviewed / Merged

Comment by David Hill (Inactive) [ 2018-01-17 ]

for the MariaDB password check, I put in code that would do the following and only report an issue if the error code of password miss was reported, Error 1045.

On local and remote servers...
1. start mysqld
2. try to log into console and check for error return code of 1045 (password required)
If this error is reported, there is a password set and no /root/.my.cnf file.
script will then report this as an error..

Comment by Daniel Lee (Inactive) [ 2018-01-23 ]

Build verified: 1.1.3-1 Github source
/root/columnstore/mariadb-columnstore-server
commit e0ae0d2fecf9941887478d9aa669c8b2d1092090
Merge: 21ec501 2490ddf
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Fri Jan 19 12:39:05 2018 -0600
Merge pull request #84 from mariadb-corporation/MCOL-1159
MCOL-1159 Merge mariadb-10.2.12
/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 6c930a03070b3815995d1282233b06100a09bbb9
Merge: 63224a0 c1035da
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Mon Jan 22 16:26:34 2018 -0600
Merge pull request #374 from mariadb-corporation/MCOL-1060
MCOL-1060 - test tool change #2

Generated at Thu Feb 08 02:25:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.