[MCOL-4725] CS aliases not being sourced with initial installation Created: 2021-05-17  Updated: 2023-10-27  Resolved: 2023-10-27

Status: Closed
Project: MariaDB ColumnStore
Component/s: installation
Affects Version/s: 5.6.1
Fix Version/s: Icebox

Type: Bug Priority: Trivial
Reporter: Allen Herrera Assignee: Leonid Fedorov
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

We can make the initial user experience slightly better by having all CS aliases sourced automatically upon a fresh install. Thus not requiring the user exit and relogin as root

Tested on Centos 7 in AWS. t2.medium

Installed:
  MariaDB-columnstore-engine.x86_64 0:10.5.9_6_5.5.2-1.el7_9
 
Dependency Installed:
  boost-atomic.x86_64 0:1.53.0-28.el7   boost-chrono.x86_64 0:1.53.0-28.el7   boost-date-time.x86_64 0:1.53.0-28.el7      boost-filesystem.x86_64 0:1.53.0-28.el7   boost-regex.x86_64 0:1.53.0-28.el7
  boost-system.x86_64 0:1.53.0-28.el7   boost-thread.x86_64 0:1.53.0-28.el7   jemalloc.x86_64 0:3.6.0-1.el7               libicu.x86_64 0:50.2-4.el7_7              python3.x86_64 0:3.6.8-18.el7
  python3-libs.x86_64 0:3.6.8-18.el7    python3-pip.noarch 0:9.0.3-8.el7      python3-setuptools.noarch 0:39.2.0-10.el7
 
Complete!
[root@ip-172-31-9-10 centos]#
[root@ip-172-31-9-10 centos]#
[root@ip-172-31-9-10 centos]# alias
alias cp='cp -i'
alias egrep='egrep --color=auto'
alias fgrep='fgrep --color=auto'
alias grep='grep --color=auto'
alias l.='ls -d .* --color=auto'
alias ll='ls -l --color=auto'
alias ls='ls --color=auto'
alias mv='mv -i'
alias rm='rm -i'
alias which='alias | /usr/bin/which --tty-only --read-alias --show-dot --show-tilde'

Notice after you exit and relogin, the aliases are sourced

[root@ip-172-31-9-10 centos]# exit
exit
[centos@ip-172-31-9-10 ~]$ sudo su
[root@ip-172-31-9-10 centos]# alias
alias core='cd /var/log/mariadb/columnstore/corefiles'
alias cp='cp -i'
alias dbrm='cd /var/lib/columnstore/data1/systemFiles/dbrm'
alias egrep='egrep --color=auto'
alias fgrep='fgrep --color=auto'
alias grep='grep --color=auto'
alias l.='ls -d .* --color=auto'
alias ll='ls -l --color=auto'
alias ls='ls --color=auto'
alias mcsModule='cat /var/lib/columnstore/local/module'
alias mcsReadOnly='curl -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/mode-set --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' --data '\''{"timeout":20, "mode": "readonly"}'\'' -k | jq .'
alias mcsReadWrite='curl -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/mode-set --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' --data '\''{"timeout":20, "mode": "readwrite"}'\'' -k | jq .'
alias mcsShutdown='curl -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/shutdown --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' --data '\''{"timeout":60}'\'' -k | jq .'
alias mcsStart='curl -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/start --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' --data '\''{"timeout":60}'\'' -k | jq .'
alias mcsStatus='curl -s https://127.0.0.1:8640/cmapi/0.4.0/cluster/status --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' -k | jq .'
alias mv='mv -i'
alias rm='rm -i'
alias tcrit='tail -f /var/log/mariadb/columnstore/crit.log'
alias tdebug='tail -f /var/log/mariadb/columnstore/debug.log'
alias terror='tail -f /var/log/mariadb/columnstore/err.log'
alias tinfo='tail -f /var/log/mariadb/columnstore/info.log'
alias twarning='tail -f /var/log/mariadb/columnstore/warning.log'
alias which='alias | /usr/bin/which --tty-only --read-alias --show-dot --show-tilde'

Quick path
sudo yum install wget -y
wget https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup
chmod +x mariadb_es_repo_setup
sudo ./mariadb_es_repo_setup --token="xxxxxxxxxxxxxxxxxx" --apply --mariadb-server-version="10.5" --mariadb-maxscale-version=2.5
yum install epel-release -y
yum install python2 python2-PyMySQL python2-pip -y
yum install -y MariaDB-server MariaDB-backup MariaDB-shared MariaDB-client MariaDB-columnstore-engine mariadb-columnstore-cmapi
alias


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