[MCOL-4978] Add support of encrypted CEJ passwords to CMAPI Created: 2022-01-31  Updated: 2022-03-29  Resolved: 2022-02-23

Status: Closed
Project: MariaDB ColumnStore
Component/s: cmapi
Affects Version/s: cmapi-1.5, cmapi-1.6
Fix Version/s: cmapi-1.6.2

Type: Task Priority: Blocker
Reporter: Alan Mologorsky Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2021-17

 Description   

In MCS 6.2.3 added feature for CEJ password encryption.
Need to support both versions: encrypted and raw CEJ passwords.

 Comments   
Comment by Daniel Lee (Inactive) [ 2022-02-23 ]

Build tested, CMAPI 6.1.2 (encrypted key support)

Chear text key works fine.

Instruction on where and how to specify key is needed.

Comment by Daniel Lee (Inactive) [ 2022-02-23 ]

Build verified: 6.3.1 (b3885), CMAPI 1.6.2 (b612)

Verified on a 3-node cluster
Verified both clear-text and encrypted CEJ password.

1. Create a 3-node cluster
2. set user password in MariaDB
3. Use mcsSetConfigure to set CEJ password in Columnstore.xml
4. Run mcsShutdown, mcsStart, mcsStatus
5. Verify CEJ password has been broadcasted to all 3 nodes
6. Create Columnstore lineitem table
7. cpimport 10g dbt3 lineitem source to ensure data in all dbroots
8. Create a innodb table t1
9. Insert rows into t1
10. Run query joining innodb and Columnstore tables.

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