js-install-ce.bat build failed [Could not connect: Access denied for user 'root'@'localhost' (using password: NO)]

[mbourassa1]

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-binbuildomatic>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-binbuildomaticbuild.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-binbuildomaticbinvalidation.xml:490: The following error occurred while executing this line:
E:jasperreports-server-cp-7.1.0-binbuildomaticbinvalidation.xml:371: The following error occurred while executing this line:
E:jasperreports-server-cp-7.1.0-binbuildomaticconf_sourcedbmysqldb.xml:70: The following error occurred while executing this line:
E:jasperreports-server-cp-7.1.0-binbuildomaticbinvalidation.xml:408: The following error occurred while executing this line:
E:jasperreports-server-cp-7.1.0-binbuildomaticbinvalidation.xml:465: Invalid username/password combination: [root/jasperadmin]. Treating problem with JDBC connection as unrecoverable

Total time: 1 second
Checking Ant return code: OK
----------------------------------------------------------------------

[mbourassa1]

Here is the complete error:

E:jasperreports-server-cp-7.1.0-binbuildomatic>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-binbuildomaticbuild.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-binbuildomaticbinvalidation.xml:490: The following error occurred while executing this line:
E:jasperreports-server-cp-7.1.0-binbuildomaticbinvalidation.xml:371: The following error occurred while executing this line:
E:jasperreports-server-cp-7.1.0-binbuildomaticconf_sourcedbmysqldb.xml:70: The following error occurred while executing this line:
E:jasperreports-server-cp-7.1.0-binbuildomaticbinvalidation.xml:408: The following error occurred while executing this line:
E:jasperreports-server-cp-7.1.0-binbuildomaticbinvalidation.xml:465: Invalid username/password combination: [root/jasperadmin]. Treating problem with JDBC connection as unrecoverable

Total time: 1 second
Checking Ant return code: OK
----------------------------------------------------------------------

[hozawa]

Yes, check if there's a "root" user in your mysql with access "localhost" and the root user has password.

 

[vrenaud]

Hi @mbourassa1,

Did you fixed you problem?

I have the same issue...

I checked that root user exist as localhost and has a password and everything is ok but I still have the same error message.

 

Thanks for your help.

[vrenaud]

Just for others,

I've uninstall basic mysql to install mariadb-server and it worked perfectly.