Jasperreports Server and remote MySql error

[pspjasper]

Hi all,

i'm trying to install Jasperreports Server cd 5.6.0

i follow all the istructions in the Jasperreports Server comunity project intallation guide and modify the mysql_master.properties as follow

dbType=mysql
dbHost=myremotehost (i ping it successfully)
dbUsername=jasperserver
dbPassword=jasperserver

when i run js-install-ce.sh test the log return this message

do-install-upgrade-test:
     [echo] Checking DBMS host and port:
     [echo] About to validate host: myremotehost
     [echo]   Host myremotehost is OK
     [echo] Done validating host: myremotehost
     [echo] About to validate port: myremotehost:3306
     [echo]   Port 3306 is OK
     [echo] Done validating port: myremotehost:3306
     [echo] Validating administrative database connection at jdbc:mysql://myremotehost:3306/mysql. Phase: [test]
     [echo] For JDBC driver the artifactId and version properties are set:
     [echo]   maven.jdbc.artifactId=mariadb-java-client
     [echo]   maven.jdbc.version=1.1.2
     [echo]   Specified JDBC driver jar exists
[advanced-sql] Failed to connect: Could not connect: Access denied for user 'jasperserver'@'ip address of my local host' (using password: YES)
     [echo] Connection failed:
     [echo]   SQLState: HY0000
     [echo]   Vendor specific error code: -1
     [echo]   Message: [Could not connect: Access denied for user 'jasperserver'@'ip address of my local host' (using password: YES)]

Why the substitution happens?

Thanks to all

[hozawa]

I've also encountered error with "test" and found that this is simply a bug in the script.

Just ignore error messages in "test" and do an js-install-ce.bat minimal

 

[pspjasper]

Thanks hozawa,

but i'm using AIX Version 6.1 and running js-install-ce.sh minimal the error is the same and the final message is BUILD FAILED

I am installing Jasperresport Server version 5.6.0, is the bug present in previous versions?

[hozawa]

In your "buildomatic" directory, try deleting "build_conf" and retrying the script.

[pspjasper]

Hi hozawa,

first thanks for your attention and help.

After a series of unsucessfull try the last log says:

test-ce-all-props:
     [echo] Checking properties:
     [echo]   dbType=mysql
     [echo]   dbHost=my.remote.db.server
     [echo]   dbUsername=jasperserver
     [echo]   dbPassword=**********
     [echo]   dbPort=3306
     [echo]   js.dbName=jasperserver
     [echo]   sugarcrm.dbName=sugarcrm
     [echo]   foodmart.dbName=foodmart
     [echo]   webAppNameCE=jasperserver
     [echo]   appServerType=tomcat6
     [echo]   appServerDir=/home/oracle/apachetomcat/apache-tomcat-6.0.36

...

do-install-upgrade-test:
     [echo] Checking DBMS host and port:
     [echo] About to validate host:  my.remote.db.server
     [echo]   Host my.remote.db.server is OK
     [echo] Done validating host: my.remote.db.server
     [echo] About to validate port: my.remote.db.server:3306
     [echo]   Port 3306 is OK
     [echo] Done validating port: my.remote.db.server:3306
     [echo] Validating administrative database connection at jdbc:mysql://my.remote.db.server:3306/mysql. Phase: [test]
     [echo] For JDBC driver the artifactId and version properties are set:
     [echo]   maven.jdbc.artifactId=mysql-connector-java
     [echo]   maven.jdbc.version=5.1.33-bin
     [echo]   Specified JDBC driver jar exists
[advanced-sql] Failed to connect: Access denied for user 'jasperserver'@'my.remote.ip.address' to database 'mysql'
     [echo] Connection failed:
     [echo]   SQLState: 42000
     [echo]   Vendor specific error code: 1044
     [echo]   Message: [Access denied for user 'jasperserver'@'my.remote.ip.address' to database 'mysql]

The string jdbc:mysql://my.remote.db.server:3306/mysql is used in buildomatic/bin/validation.xml in a variable named connectionURLOfDBToValidate initialized with the value of ${@{systemName}.jdbcUrl

If i use jasperserver instead of mysql in the url the connection works but i can't find where this configuration is set.

Someone has successfully installed the Jasper Server on AIX with remote mysql? If not my only choice are use local mysql or trying windows os?

Thanks.

[pspjasper]

Something has moved.

These the steps followed:

- change in build_conf/default/db.template.properties at line 10 admin.jdbcUrl=jdbc:mysql://intraweb.psp.stpauls.it:3306/mysql to admin.jdbcUrl=jdbc:mysql://intraweb.psp.stpauls.it:3306/jasperserver

- js-install-ce.sh minimal 3 times :

• 1st time do-install-upgrade-test Connection OK, recreate-js-db ask Database [jasperserver] already exists. Drop it and create new? and i select  y : BUILD FAILED Unknown database 'jasperserver'
• 2nd time do-install-upgrade-test Failed to connect: Unknown database 'jasperserver'
• jasperserver catalog createt via mysql Administrator
• 3rd time do-pre-install-test Connection OK, recreate-js-db ask Database [jasperserver] already exists. Drop it and create new? and i select n : BUILD SUCCESSFUL but no db tables created

- js-ant create-js.db

- js-ant init-js-db-ce

- js-ant import-minimal-ce

- js-ant deploy-webapp-ce

All of this end successfully but http://myAppServer:8080/jasperserver/ HTTP Status 404 - The requested resource is not available. and i'am working on it.

 

After all i don't know if the installation of the server is working and if yes if it is usefull. It was not easy and not so simple as the documentation says.