Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
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.
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
Hi
Recently I install few database tool like MySQL Community Server 8.0.13 , MySQL Installer , XAMPP , 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
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)