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

0

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
----------------------------------------------------------------------

mbourassa1's picture
Joined: Feb 1 2016 - 11:08am
Last seen: 1 year 1 week ago

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
----------------------------------------------------------------------

mbourassa1 - 1 year 4 months ago

3 Answers:

0

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

 

hozawa's picture
57710
Joined: Apr 24 2010 - 4:31pm
Last seen: 8 months 1 week ago
0

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's picture
Joined: Nov 26 2018 - 11:07pm
Last seen: 1 year 2 months ago
0

Just for others,

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

vrenaud's picture
Joined: Nov 26 2018 - 11:07pm
Last seen: 1 year 2 months ago
Feedback
randomness