Category: | Bug report |
Priority: | Normal |
Status: | Assigned |
Project: | Severity: | Minor |
Resolution: | Open |
|
Component: | Reproducibility: | Always |
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