[#1330] - [JasperServer WarFile Install Guide] some fixes, suggestions

Bug report
Project: Severity:
Component: Reproducibility:
Assigned to:

* suggestions :
* don't use the root account to import data into mysql but the jasperadmin account.
* call *.sh with a path (eg: ./js-import.sh) because '.' isn't in the PATH by default for lot of unix
* group webapp configuration (avoid first part before rdbms setup, and second part after)

* fixes :
* the web account don't match what it's imported into the database (eg: jasperadmin/password and not jasperadmin/NewPassord)
* add a link to http://jasperforge.org/sf/go/artf2585?nav=1
* precise that it works with jsp 2.0 and not jsp 2.1
* precise that jar of jdbc drivers must be copied (eg: into WEB-INF/lib)
* precise that sample data must be imported

following the pseudo-guide/script I use install:

unzip jasperserver-2.0.1-bin.zip
cd jasperserver-2.0.1-bin/

# -----------------------------------------------------------------------------
# setup rdbms
# -----------------------------------------------------------------------------
mysql -u root -p
mysql> create database jasperserver;
mysql> grant all on jasperserver.* to jasperadmin@localhost identified by 'jasperadminpwd';
mysql> quit;
mysql -u jasperadmin -pjasperadminpwd -D jasperserver < scripts/mysql/jasperserverCreate-mysql.ddl
mysql -u jasperadmin -pjasperadminpwd -D jasperserver < scripts/mysql/jasperserverCreateDefaultSecurity-mysql.sql

# setup sample data (optional)
mysql -u root -p
mysql> create database foodmart;
mysql> grant all on foodmart.* to jasperadmin@localhost;
mysql> create database sugarcrm;
mysql> grant all on sugarcrm.* to jasperadmin@localhost;
mysql> quit;
mysql -u jasperadmin -pjasperadminpwd -D sugarcrm < mysql/sugarcrm-mysql.sql
mysql -u jasperadmin -pjasperadminpwd -D foodmart < mysql/foodmart-mysql.sql
# update conf (to use the jasperadmin account)
vim config/js.jdbc.properties
cd scripts/
./js-import.sh --input-dir js-catalog
cd -

# -----------------------------------------------------------------------------
# install war
# -----------------------------------------------------------------------------
mkdir jasperserver-2.0.1
cd jasperserver-2.0.1/
jar xvf ../jasperserver.war
#fix a bug in 2.0.1 see http://jasperforge.org/sf/go/artf2585?nav=1
vim WEB-INF/applicationContext.xml
# add mysql jdbc driver
cp $HOME/.m2/repository/mysql/mysql-connector-java/5.0.5/mysql-connector-java-5.0.5.jar WEB-INF/lib/.
cd -

# ..., copy webapp to webapps dir, ... configure servlet engine

dwayneb's picture
Joined: Sep 24 2007 - 6:09am
Last seen: 15 years 8 months ago