1
0
-1

Hi

Recently I install few database tool like MySQL Community Server 8.0.13MySQL InstallerXAMPP , and MariaDB 10.3 Series . All because i want to look into the database in joget that i'm using, which i'm failed. I'm not sure what i did but all were default setting during installed. Now, even after i uninstall back all the tool, i still get this error code.

Here my app_datasource-default.properties

workflowDriver=com.mysql.jdbc.Driver
workflowUrl=jdbc\:mysql\://localhost\:3306/jwdb?characterEncoding\=UTF-8
workflowUser=root
profileName=
workflowPassword=

Here from joget.log

INFO 17 Jan 2019 16:02:46 org.joget.commons.util.SetupManager - Using base directory: ./wflow/
INFO 17 Jan 2019 16:02:48 org.joget.commons.util.DynamicDataSource - profileName=default, url=jdbc:mysql://localhost:3306/jwdb?characterEncoding=UTF-8, user=root
ERROR 17 Jan 2019 16:02:48 org.joget.commons.spring.web.CustomContextLoaderListener - ===== Error initializing WebApplicationContext =====
INFO 17 Jan 2019 16:02:48 org.displaytag.filter.ResponseOverrideFilter - Filter initialized. Response buffering is enabled

Here from localhost.log

* Action: org.owasp.csrfguard.action.Log
* Parameter: Message = potential cross-site request forgery (CSRF) attack thwarted (user:%user%, ip:%remote_ip%, method:%request_method%, uri:%request_uri%, error:%exception_message%)
* Action: org.owasp.csrfguard.action.Error
* Parameter: Message = Security Violation.
* Parameter: Code = 403
* Action: org.owasp.csrfguard.action.Rotate

Here from catalina.log

INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
SEVERE [localhost-startStop-1] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool.
java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'root'@'localhost' (using password: NO)
Caused by: java.sql.SQLException: Could not connect: Access denied for user 'root'@'localhost' (using password: NO)

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, the error saying "Access denied for user 'root'@'localhost' (using password: NO)" means that your database user credentials are incorrect so you need to check that.

      1. Sam Louis

        Hi, can you show me how to check database credentials properly? I'd google so many thing, but wasn't sure what's wrong with my database. I can't even access database through mariadb command prompt, it said the same thing. When I typed "mysql SHOW DETAIL" at mariadb-10.3.9-win32/bin, it said my port was 3307, so i tried to change app_datasource-default.properties, from workflowUrl=jdbc\:mysql\://localhost\:3306/jwdb?characterEncoding\=UTF-8 to workflowUrl=jdbc\:mysql\://localhost\:3307/jwdb?characterEncoding\=UTF-8, but nothing happen

      CommentAdd your comment...