[MCOL-4294] columnstore-docker-cluster: cej user not being able to be renamed through environment variable Created: 2020-09-03  Updated: 2020-09-21  Resolved: 2020-09-07

Status: Closed
Project: MariaDB ColumnStore
Component/s: Docker
Affects Version/s: None
Fix Version/s: 5.4.1

Type: Bug Priority: Major
Reporter: Jens Röwekamp (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Fixed Votes: 0
Labels: skysql
Environment:

mariadb/skysql-enterprise-columnstore-handoff sky-1.5.4-1 95e34753d40f



 Description   

The cross engine join user can't be renamed through its environment variable.

How to reproduce:

jens@ubuntu18:~/columnstore-docker-cluster$ cat .env
# S3 Variables
ASYNC_CONN=0
ANALYTICS_ONLY=1
USE_S3_STORAGE=0
S3_BUCKET=
S3_ENDPOINT=
S3_REGION=
S3_ACCESS_KEY_ID=
S3_SECRET_ACCESS_KEY=
 
# Host Variables
PM1=mcs1
PM2=mcs2
PM3=mcs3
MX1=mx1
 
# Credentials
CMAPI_KEY=
ADMIN_USER=
ADMIN_PASS=
CEJ_USER=skysql_cej
CEJ_PASS=
MAX_USER=
MAX_PASS=
REP_USER=
REP_PASS=

jens@ubuntu18:~/columnstore-docker-cluster$ docker-compose up -d
Creating network "columnstore-docker-cluster_default" with the default driver
Creating volume "columnstore-docker-cluster_data1" with default driver
Creating volume "columnstore-docker-cluster_data2" with default driver
Creating volume "columnstore-docker-cluster_data3" with default driver
Creating volume "columnstore-docker-cluster_storagemanager" with default driver
Creating mcs3 ... done
Creating mcs2 ... done
Creating mcs1 ... done
Creating mx1  ... done

jens@ubuntu18:~/columnstore-docker-cluster$ sleep 60 && docker exec -it mcs1 mariadb -e "SELECT user,host FROM mysql.user"
+-------------+-----------+
| User        | Host      |
+-------------+-----------+
| cej         | %         |
| idbrep      | %         |
| maxscale    | %         |
| mariadb.sys | localhost |
| mysql       | localhost |
| root        | localhost |
+-------------+-----------+


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