I have installed tomcat 9 and MySql 8.0.
I would like to install jasper server 7.1 with js-install-ce.bat
When I execute js-install-ce.bat test, I get this error: [Could not connect: Access denied for user 'root'@'localhost' (using password: NO)]
I think the problem is with the '(using password: NO)' because the user 'root' have a password.
If I use an other user who have no password, I get a build sucessfully.
What I need to do for Using password: Yes ?
Thank you
Here is the complete error:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic>js-install-ce.bat test
Writing to log file: logs/js-install-ce_2018-10-18_04-34_16961.log
----------------------------------------------------------------------
Running JasperReports Server install script at 2018-10-18_04-34
----------------------------------------------------------------------
[test]
Running pre-install-test-ce Ant task
----------------------------------------------------------------------
Buildfile: E:\jasperreports-server-cp-7.1.0-bin\buildomatic\build.xml
[echo] Filtering properties (cleaning out blank spaces)
[echo] chkIfPackageManagedTomcat: check if package managed tomcat
[echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory
[echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands
[echo] chkIfPackageManagedTomcat: check if package managed tomcat
[taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found.
[echo] using settings file: E:/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xml
test-ce-all-props:
[echo] Checking properties:
[echo] dbType=mysql
[echo] dbHost=localhost
[echo] dbUsername=root
[echo] dbPassword=**********
[echo] dbPort=3306
[echo] js.dbName=jasperserver
[echo] sugarcrm.dbName=sugarcrm
[echo] foodmart.dbName=foodmart
[echo] webAppNameCE=jasperserver
[echo] appServerType=tomcat
[echo] appServerDir=E:\apache-tomcat-9.0.12
check-dbtype-ce:
test-appServerType-ce:
do-install-upgrade-test:
[echo] Checking DBMS host and port:
[echo] About to validate port: localhost:3306
[echo] Port 3306 is OK
[echo] Done validating port: localhost:3306
[echo] Validating administrative database connection at jdbc:mysql://localhost: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.6.3
[echo] Specified JDBC driver jar exists
[advanced-sql] Failed to connect: Could not connect: Access denied for user 'root'@'localhost' (using password: NO)
[echo] Connection failed:
[echo] SQLState: 28000
[echo] Vendor specific error code: 1045
[echo] Message: [Could not connect: Access denied for user 'root'@'localhost' (using password: NO)]
BUILD FAILED
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\bin\validation.xml:490: The following error occurred while executing this line:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\bin\validation.xml:371: The following error occurred while executing this line:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\conf_source\db\mysql\db.xml:70: The following error occurred while executing this line:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\bin\validation.xml:408: The following error occurred while executing this line:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\bin\validation.xml:465: Invalid username/password combination: [root/jasperadmin]. Treating problem with JDBC connection as unrecoverable
Total time: 1 second
Checking Ant return code: OK
----------------------------------------------------------------------
Here is the complete error:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic>js-install-ce.bat test
Writing to log file: logs/js-install-ce_2018-10-18_04-34_16961.log
----------------------------------------------------------------------
Running JasperReports Server install script at 2018-10-18_04-34
----------------------------------------------------------------------
[test]
Running pre-install-test-ce Ant task
----------------------------------------------------------------------
Buildfile: E:\jasperreports-server-cp-7.1.0-bin\buildomatic\build.xml
[echo] Filtering properties (cleaning out blank spaces)
[echo] chkIfPackageManagedTomcat: check if package managed tomcat
[echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory
[echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands
[echo] chkIfPackageManagedTomcat: check if package managed tomcat
[taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found.
[echo] using settings file: E:/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default/maven_settings.xml
test-ce-all-props:
[echo] Checking properties:
[echo] dbType=mysql
[echo] dbHost=localhost
[echo] dbUsername=root
[echo] dbPassword=**********
[echo] dbPort=3306
[echo] js.dbName=jasperserver
[echo] sugarcrm.dbName=sugarcrm
[echo] foodmart.dbName=foodmart
[echo] webAppNameCE=jasperserver
[echo] appServerType=tomcat
[echo] appServerDir=E:\apache-tomcat-9.0.12
check-dbtype-ce:
test-appServerType-ce:
do-install-upgrade-test:
[echo] Checking DBMS host and port:
[echo] About to validate port: localhost:3306
[echo] Port 3306 is OK
[echo] Done validating port: localhost:3306
[echo] Validating administrative database connection at jdbc:mysql://localhost: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.6.3
[echo] Specified JDBC driver jar exists
[advanced-sql] Failed to connect: Could not connect: Access denied for user 'root'@'localhost' (using password: NO)
[echo] Connection failed:
[echo] SQLState: 28000
[echo] Vendor specific error code: 1045
[echo] Message: [Could not connect: Access denied for user 'root'@'localhost' (using password: NO)]
BUILD FAILED
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\bin\validation.xml:490: The following error occurred while executing this line:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\bin\validation.xml:371: The following error occurred while executing this line:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\conf_source\db\mysql\db.xml:70: The following error occurred while executing this line:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\bin\validation.xml:408: The following error occurred while executing this line:
E:\jasperreports-server-cp-7.1.0-bin\buildomatic\bin\validation.xml:465: Invalid username/password combination: [root/jasperadmin]. Treating problem with JDBC connection as unrecoverable
Total time: 1 second
Checking Ant return code: OK
----------------------------------------------------------------------