BambooBSC

Install on Windows

install step video: https://www.youtube.com/watch?v=pM3q9udreDo 

Install on Linux

1. must first install the MySQL and JDK8

# apt-get install mysql-server
# apt-get install oracle-java8-jdk
# java -version

java version "1.8.0" Java(TM) SE Runtime Environment (build 1.8.0-b132) Java HotSpot(TM) Client VM (build 25.0-b70, mixed mode)

config MySQL root account's password

# mysqladmin -u root -p password

2. Config MySQL enable lower_case_table_names=1

# service mysql stop
# vi /etc/mysql/my.cnf

add lower_case_table_names=1

[mysqld]
lower_case_table_names=1

and save my.cnf

# service mysql restart

3. Get bambooBSC environment file

# cd /home/pi
# wget --no-check-certificate https://github.com/billchen198318/bamboobsc/releases/download/v0.6.1/bamboobsc-0.6.1.7z

4. Install P7ZIP

# apt-get install p7zip

5. Extract the archive

# p7zip -d bamboobsc-0.6.1.7z

6. Import bbcore.sql to MySQL

# cd /home/pi/bamboobsc-06/
# mysql -u root -p

mysql> create database bbcore;
mysql> exit;

# mysql bbcore -u root -p < bbcore.sql

7. Config applicationContext-dataSource.properties

config A ( CORE system ).
/home/pi/bamboobsc-06/apache-tomcat-7.0.65/webapps/core-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties

config B (Balanced Scorecard system ).
/home/pi/bamboobsc-06/apache-tomcat-7.0.65/webapps/gsbsc-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties

config C (Simple OLAP system ).
/home/pi/bamboobsc-06/apache-tomcat-7.0.65/webapps/qcharts-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties

config D (Mobile web ).
/home/pi/bamboobsc-06/apache-tomcat-7.0.65/webapps/gsbsc-mobile-web/WEB-INF/classes/applicationContext/conf/applicationContext-dataSource.properties

settings dataSource.user and dataSource.password 
dataSource.user is MySQL account
dataSource.password is MySQL password

example:

dataSource.user=root
dataSource.password=password

8. The need to create the directory folder, for upload and report source file need.

# cd /var
# mkdir gsbsc gsbsc/upload gsbsc/jasperreport

9. Run bambooBSC

# cd /home/pi/bamboobsc-06/apache-tomcat-7.0.65/bin
# chmod a+x catalina.sh
# chmod a+x shutdown.sh
# chmod a+x startup.sh

add JAVA_OPTS="-Xmx700M -client -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -XX:GCTimeRatio=2 -XX:AdaptiveSizePolicyWeight=90" to catalina.sh

# ./startup.sh

Wait a few minutes, 
Use google Chrome or Firefox browser (no support IE) input url ( [IP-Address]:[Port]/core-web/index.action ) example (if server IP-Address is 192.168.1.100) :
192.168.1.100:8080/core-web/index.action 

the log file on /tmp/