SpagoBI

오픈소스 비즈니스 컨설팅
둘러보기로 가기 검색하러 가기

SpagoBI를 정리 합니다.

SpagoBI 개요

  • ObjectWeb(OW2)에서 프로젝트 진행
  • BIRT report 지원

CentOS에서 SpageBI 설치

사전 준비 사항

  • /etc/my.cnf
[mysqld]
port=3306
max_allowed_packet=16M
wget http://download.forge.objectweb.org/spagobi/mysql-dbscript-3.6.0_22102012.zip
unzip mysql-dbscript-3.6.0_22102012.zip

createDatabase spagobi spagobi spagobi  ????  ????
mysql -uspagobi -p -D spagobi < MySQL_create.sql
mysql -uspagobi -p -D spagobi < MySQL_create_quartz_schema.sql

cp  mysql-connector-java-5.1.25-bin.jar /usr/share/tomcat6/lib

SpageBI Server 설치

wget http://download.forge.objectweb.org/spagobi/All-In-One-SpagoBI-3.6.0-31102012.zip
unzip All-In-One-SpagoBI-3.6.0-31102012.zip
  • SpagoBI 파일을 배포 합니다.
chown -R root:tomcat SpagoBI-DEMO-3.6.0

cd SpagoBI-DEMO-3.6.0/webapps
//--- 모든 폴더에 있는 META-INF/context.xml 파일의 <Context 에 설정 정보 저장
mv SpagoBI* /usr/share/tomcat6/webapps

cd ../lib
mv  casclient.jar  /usr/share/tomcat6/lib
mv  commonj-twm.jar  /usr/share/tomcat6/lib
mv  concurrent.jar  /usr/share/tomcat6/lib
mv  el-api.jar  /usr/share/tomcat6/lib
mv  foo-commonj.jar  /usr/share/tomcat6/lib
mv  jsp-api.jar  /usr/share/tomcat6/lib
mv  servlet-api.jar  /usr/share/tomcat6/lib
mv  tomcat-dbcp.jar  /usr/share/tomcat6/lib

cd ..
mv  resources  /usr/share/tomcat6
  • vi /etc/tomcat6/server.xml
<GlobalNamingResources>
    <Resource name="jdbc/spagobi" username="spagobi" password="????"
        type="javax.sql.DataSource" driverClassName="org.gjt.mm.mysql.Driver"
        url="jdbc:mysql://localhost:3306/spagobi?useUnicode=true&characterEncoding=UTF-8"
        auth="Container" maxActive="20" maxIdle="10" maxWait="-1" />

    <Environment name="spagobi-resource-path" type="java.lang.String" value="/usr/share/tomcat6/resources" />
    <Environment name="spagobi-sso-class" type="java.lang.String" value="it.eng.spagobi.services.common.FakeSsoService" />
    <Environment name="spagobi-service-url" type="java.lang.String" value="http://192.168.56.102:8080/SpagoBI" />
    <Environment name="spagobi-host-url" type="java.lang.String" value="http://192.168.56.102:8080" />
 </GlobalNamingResources>
  • 사용자 : biadmin, bitest, bimodel, bidev, biuser (비밀번호는 아이디와 동일)

SpageBI Studio 설치

참고 문헌

  • 설치 매뉴얼