1
0
-1

Hi,

I tried installation joget v6 

followed https://dev.joget.org/community/display/KBv6/Installation+on+Linux

but I got error at database setting

 

 

ERROR: Could not initialize the database, please ensure the database is running and the settings are correct.Show Details

Cannot create PoolableConnectionFactory (Could not connect: Access denied for user root @ localhost )

how can I check the problem ?

 

 

 

 

 

tomcat log.

parallels@parallels-Parallels-Virtual-Platform:/joget/joget-linux-6.0.13$ sudo tail -f apache-tomcat-8.5.23/logs/catalina.out at org.apache.tomcat.util.net.AbstractJsseEndpoint.init(AbstractJsseEndpoint.java:245) at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:620) at org.apache.coyote.http11.AbstractHttp11Protocol.init(AbstractHttp11Protocol.java:66) at org.apache.catalina.connector.Connector.initInternal(Connector.java:997) ... 13 more 24-Dec-2018 00:38:02.824 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1417 ms 24-Dec-2018 00:38:02.980 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 24-Dec-2018 00:38:02.981 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.23 24-Dec-2018 00:38:03.078 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/jwdesigner.war] 24-Dec-2018 00:38:05.426 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. 24-Dec-2018 00:38:05.973 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/jwdesigner.war] has finished in [2,892] ms 24-Dec-2018 00:38:05.980 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/jw.war] 24-Dec-2018 00:38:15.378 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. WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.aspectj.weaver.loadtime.ClassLoaderWeavingAdaptor (file:/joget/joget-linux-6.0.13/wflow/aspectjweaver-1.8.5.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain) WARNING: Please consider reporting this to the maintainers of org.aspectj.weaver.loadtime.ClassLoaderWeavingAdaptor WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release INFO 24 Dec 2018 00:38:25 org.joget.commons.util.SetupManager - Using base directory: ./wflow/ ERROR 24 Dec 2018 00:38:28 org.joget.commons.spring.web.CustomContextLoaderListener - ===== Error initializing WebApplicationContext ===== INFO 24 Dec 2018 00:38:28 org.displaytag.filter.ResponseOverrideFilter - Filter initialized. Response buffering is enabled 24-Dec-2018 00:38:29.289 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/jw.war] has finished in [23,308] ms 24-Dec-2018 00:38:29.292 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/examples] 24-Dec-2018 00:38:29.784 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/examples] has finished in [491] ms 24-Dec-2018 00:38:29.784 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/docs] 24-Dec-2018 00:38:29.832 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/docs] has finished in [48] ms 24-Dec-2018 00:38:29.833 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/manager] 24-Dec-2018 00:38:29.910 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/manager] has finished in [77] ms 24-Dec-2018 00:38:29.912 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/ROOT] 24-Dec-2018 00:38:29.963 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/ROOT] has finished in [51] ms 24-Dec-2018 00:38:29.968 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/host-manager] 24-Dec-2018 00:38:30.043 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/joget/joget-linux-6.0.13/apache-tomcat-8.5.23/webapps/host-manager] has finished in [75] ms 24-Dec-2018 00:38:30.059 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 27233 ms 24-Dec-2018 00:38:30.109 SEVERE [main] org.apache.catalina.core.StandardServer.await StandardServer.await: create[localhost:8005]: java.net.BindException: Address already in use (Bind failed) at java.base/java.net.PlainSocketImpl.socketBind(Native Method) at java.base/java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:437) at java.base/java.net.ServerSocket.bind(ServerSocket.java:381) at java.base/java.net.ServerSocket.<init>(ServerSocket.java:243) at org.apache.catalina.core.StandardServer.await(StandardServer.java:441) at org.apache.catalina.startup.Catalina.await(Catalina.java:758) at org.apache.catalina.startup.Catalina.start(Catalina.java:704) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:355) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:495) 24-Dec-2018 00:38:30.114 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-8080"] 24-Dec-2018 00:38:30.115 INFO [main] org.apache.catalina.core.StandardService.stopInternal Stopping service [Catalina] INFO 24 Dec 2018 00:38:31 org.joget.apps.app.web.ThreadCleaner - cleaned 108 values in ThreadLocals 24-Dec-2018 00:38:31.617 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["http-nio-8080"] 24-Dec-2018 00:38:31.618 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-8080"]

 

 

app-datasource-default.properties

workflowDriver=com.mysql.jdbc.Driver

workflowUrl=jdbc\:mysql\://localhost\:3307/jwdb?characterEncoding\=UTF-8

workflowUser=root

profileName=

workflowPassword=

 

 

 

 

 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Can you confirm that you have a MySQL database running at 3306 with the credential you specified? Error shown basically tells you that and it has problem talking to the database.

      1. leka2002

        I added -skip-grant-tables it works

      2. Sam Louis

        where did you put that -skip-grant-tables option?

      CommentAdd your comment...