Public | Automated Build

Last pushed: 2 years ago
Short Description
Short description is empty for this repo.
Full Description

SpagoBI 5.1 on Tomcat 7 with postgres

##Status: Works, but requires manual DB setup

This is SpaboBi 5.1 running in Tomcat7 with configs updated for PostgreSQL DB

Uncluded SpagoBI engines:

  • SpagoBIBirtReportEngine
  • SpagoBIConsoleEngine
  • SpagoBIMobileEngine

###Postgres
Il personnaly use a postgres containeR.
This doc details how to launch spagobi with a postgres container
DB need to be created manually

Start a postgres container

docker run --name postgres -d -p 5432:5432 -p 2223:22 guilhem30/postgresql

Create spagobi user and db

createuser --no-createrole --no-superuser --pwprompt spagobi
createdb -O spagobi spagobi

Get postgres script from your version

wget http://download.forge.ow2.org/spagobi/postgres-dbscript-5.1.0_19012015.zip

Extract files and populate DB

psql -U spagobi -h localhost spagobi < PG_create.sql
psql -U spagobi -h localhost spagobi < PG_create_quartz_schema.sql

###To start use:

docker run -d --name <spagobi container> -p 8080:8080 --link <POSGRES container>: db -e JAVA_OPTS="-Dcatalina.db.pass=<DB PASS> -Dcatalina.db.username=<DB USER> -Dcatalina.db.url=jdbc:postgresql://db:5432/<DB NAME>" bretif/spagobi

Please change PASS, USER, IP, DATABASE of your postgres database with installed SpagoBi schema!

Example:

  • psql SpagoBI < PG_create.sql
  • psql SpagoBI < PG_create_quartz_schema.sql

TODO: Compile SpagobiFilter.jar on build AND DB setup

Docker Pull Command
Owner
bretif
Source Repository

Comments (3)
fgrove
3 years ago

In the command line to run the spagobi container a name, e.g. spagobi, is required after the –name option: docker run -d --name <container-name> -p 8080:8080 ...

bretif
3 years ago

when you launch postgresql container, do not specify --volumes-from odoodb, you do not need it.
I will update the readmu

cortezone
3 years ago

Hey, thanks for this but I get an error about odoodb not found when I'm pulling the image.
Status: Downloaded newer image for guilhem30/postgresql:latest
FATA[1024] Error response from daemon: container odoodb not found, impossible to mount its volumes.
I've searched the docker hub but not found it either. What gives?