部署Tableau Server & Mysql On

部署Tableau Server

在单个机器上安装Tableau
https://onlinehelp.tableau.com/current/guides/everybody-install-linux/en-us/everybody_admin_intro.htm

配置防火墙
Before you install…

如何通过网页登录控制台
Sign in to Tableau Services Manager Web UI

TIPS

add user to sudo group
https://askubuntu.com/questions/7477/how-can-i-add-a-new-user-as-sudoer-using-the-command-line

download file in linux command
command line - How to download a file from a website via terminal? - Ask Ubuntu

tbcmd所在的位置
shell> which tabcmd
shelll> /etc/profile.d/tabcmd.sh

添加初始化的admin账号
tabcmd initialuser ‑‑server localhost:80 ‑‑username

shell> tabcmd initialuser --accepteula ‑‑server 138.68.170.205:808 ‑‑username 'tabuser'

linux 创建用户并添加到sudo

adduser <username>
sudo adduser <username> sudo
or
usermod -aG sudo <username>

tabcmd command not found

shell> source /etc/profile.d/tabcmd.sh

数据库驱动列表
Driver Download | Tableau Software

下载驱动,安装驱动

shell> wget ‘https://downloads.tableau.com/drivers/linux/deb/shell> tableau-driver/tableau-postgresql-odbc_9.5.3_amd64.deb’
shell> sudo gdebi tableau-postgresql-odbc_9.5.3_amd64.deb

动态库无法加载的问题
myodbc-installer: error while loading shared libraries: libodbc.so.2: cannot open shared object file: No such file or directory

mysql

shell> cp bin/* /usr/local/bin
shell> cp lib/* /usr/local/lib

在linux上安装mysql
MySQL :: A Quick Guide to Using the MySQL APT Repository

从这个
https://dev.mysql.com/downloads/repo/apt/
中找到，

shell> wget ‘https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb’

shell> sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

更新apt的包信息

shell> sudo apt-get update

使用下面的命令安装mysql，并启用/查看/关闭 服务

shell> sudo apt-get install mysql-server
shell> sudo service mysql start
shell> sudo service mysql status
shell> sudo service mysql stop

一句话的命令

shell> wget ‘https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb’

shell> sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

shell> sudo apt-get update
shell> sudo service mysql status

连接我刚才安装好的mysql

mysql -h 138.68.170.205 -u root -p

mysql -h localhost -u root -p

linux 查看端口占用情况

ps -aux | grep mysql

查看mysql端口占用情况

mysql -h localhost -u root -p
mysql> show global variables like 'port';

遇到无法连接mysql的情况
ERROR 1130 (HY000): Host '222.93.215.182' is not allowed to connect to this MySQL server

update user set host='138.68.170.205';
sudo service mysql start

设置授权账号

mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY'mypassword' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'sa'@'%' IDENTIFIED BY'bglass11' WITH GRANT OPTION;

mysql> CREATE USER 'sa'@'%' IDENTIFIED BY 'bglass11';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'sa'@'%';

caching_sha2_password 错误

使用navicat的客户端连接mysql的时候，报下面的错误：
2059 - Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(../Frameworks/caching_sha2_password.so, 2)

两种方法解决这个问题，一个是更新本地的连接mysql的客户端，另一种是更改加密方式。

更新本地navicat客户端，我本地的版本号是：navicat premium 12.0.16,更新到12.0.26支持mysql 8的SHA2 connection.
May 10 2018Navicat for MySQL (macOS) version 12.0.26

• Supported to connect MySQL 8 using SHA2 connection.

第二种：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码

mysql> select host,user,plugin from mysql.user;  #查看更改后的结果

mysql> FLUSH PRIVILEGES; #刷新权限

修改之前是：

+-----------+------------------+-----------------------+
| host      | user             | plugin                |
+-----------+------------------+-----------------------+
| %         | sa               | caching_sha2_password |

修改之后是：

+-----------+------------------+-----------------------+
| host      | user             | plugin                |
+-----------+------------------+-----------------------+
| %         | sa               | mysql_native_password |