安装完成后,会在最上层菜单中多了eazyBI
初始化
点击插件管理 》eazyBI 展开,点击configure 或者 点击最上层菜单 》eazyBI 》右上角setting,进入数据库连接配置
注意这里会提示字符集问题:解决方案 https://confluence.atlassian.com/adminjiraserver/setting-properties-and-options-on-startup-938847831.html
数据库准备
连接数据库之前,我们需要为eazyBI单独的创建单独的连接数据库的用户,并且拥有创建数据库及对创建数据后对表处理的所有权限。
以下是创建数据库及用户的脚本信息
mysql
GRANT ALL PRIVILEGES ON 'eazybi_jira%'.* TO 'eazybi_jira'@'%' IDENTIFIED BY 'password'; |
说明
在eazybi里每创建一个account,都会在数据库实例中创建一个库,所以每个库都要做上的授权。在一些版本中以上的语句有时候并不生效,可以为系统一次性多创建一些库。
每一个account对应的库,大致规则 如下 eazybi_jira_dwh_N
CREATE DATABASE eazybi_jira_dwh_1 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_2 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_3 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_4 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_5 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_6 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_7 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_8 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_9 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE DATABASE eazybi_jira_dwh_10 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_1.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_2.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_3.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_4.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_5.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_6.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_7.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_8.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_9.* TO 'eazybi_jira'@'%'; GRANT ALL PRIVILEGES ON eazybi_jira_dwh_10.* TO 'eazybi_jira'@'%'; |
postgreSQL
CREATE ROLE eazybi_jira PASSWORD 'secret' LOGIN CREATEDB; |
ORACLE
CREATE USER eazybi_jira IDENTIFIED BY secret DEFAULT TABLESPACE users; GRANT CONNECT, RESOURCE TO eazybi_jira; |