FAIL - Application at context path [/openboxes] could not be started

Ali_Muhamamd_Nizaman · June 12, 2020, 11:56am

Hello ,
I am newbie in Openboxes , i am trying to install it in my windows 10 machine.I am following video tutorial published at openboxes site.
I am getting an error while loading same in my local tomcat server

I am getting an error " Application at context path / openboxes" could not be started…!!!
Please guide , i have already consume a day to resolve this !!!

jmiranda · June 12, 2020, 1:15pm

Hey Ali

There are two common problems that seem to cause a lot of problems:

Using a version of Tomcat that was compiled with Java 8 instead of Java 7
Data source connection pool cannot be created because the application cannot find the openboxes-config.properties file

Can you post your tomcat logs here? I think the stdout and stderr should give me enough information.

Justin

Ali_Muhamamd_Nizaman · June 12, 2020, 3:48pm

Thanks alot for responding me , please help me,
These are the logs details with some other information.
Tomcat version 8.5.
openboxes-config.properties Files content

# Database connection settings
dataSource.username=openboxes
dataSource.password=openboxes
dataSource.url=jdbc:mysql://localhost:3306/openboxes?useSSL=false
# Used primarily with g:link when absoluteUrl is true (e.g. links in emails)
grails.serverURL=http://localhost:8080/openboxes
# OpenBoxes mail settings - disabled by default (unless you set up an SMTP server)
#grails.mail.enabled=true"

tomcat8-stderr.2020-06-12.log

2020-06-12 20:38:13 Apache Commons Daemon procrun stderr initialized.
12-Jun-2020 20:38:22.030 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/8.5.56
12-Jun-2020 20:38:22.223 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jun 3 2020 20:18:30 UTC
12-Jun-2020 20:38:22.223 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 8.5.56.0
12-Jun-2020 20:38:22.229 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows 10
12-Jun-2020 20:38:22.245 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
12-Jun-2020 20:38:22.245 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
12-Jun-2020 20:38:22.246 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\Program Files\Java\jre1.8.0_251
12-Jun-2020 20:38:22.246 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_251-b08
12-Jun-2020 20:38:22.247 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
12-Jun-2020 20:38:22.247 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 8.5
12-Jun-2020 20:38:22.248 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 8.5
12-Jun-2020 20:38:22.248 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 8.5
12-Jun-2020 20:38:22.249 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 8.5
12-Jun-2020 20:38:22.249 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 8.5\temp
12-Jun-2020 20:38:22.249 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
12-Jun-2020 20:38:22.249 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 8.5\conf\logging.properties
12-Jun-2020 20:38:22.250 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=256m
12-Jun-2020 20:38:22.250 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
12-Jun-2020 20:38:22.250 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort
12-Jun-2020 20:38:22.251 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512m
12-Jun-2020 20:38:22.251 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m
12-Jun-2020 20:38:22.251 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.2.24] using APR version [1.7.0].
12-Jun-2020 20:38:22.251 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
12-Jun-2020 20:38:22.252 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
12-Jun-2020 20:38:22.396 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.1g  21 Apr 2020]
12-Jun-2020 20:38:24.949 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
12-Jun-2020 20:38:25.801 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
12-Jun-2020 20:38:25.821 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 6114 ms
12-Jun-2020 20:38:25.973 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
12-Jun-2020 20:38:25.973 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.56
12-Jun-2020 20:38:26.086 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\openboxes.war]
12-Jun-2020 20:43:41.519 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.
12-Jun-2020 20:43:50.066 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
12-Jun-2020 20:43:50.067 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors
12-Jun-2020 20:43:50.132 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\openboxes.war] has finished in [324,047] ms
12-Jun-2020 20:43:50.132 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\manager]
12-Jun-2020 20:43:50.271 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\manager] has finished in [139] ms
12-Jun-2020 20:43:50.271 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\ROOT]
12-Jun-2020 20:43:50.304 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\ROOT] has finished in [33] ms
12-Jun-2020 20:43:50.323 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
12-Jun-2020 20:43:50.336 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 324521 ms
12-Jun-2020 20:44:28.613 INFO [http-nio-8080-exec-8] 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.
12-Jun-2020 20:44:37.282 SEVERE [http-nio-8080-exec-8] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
12-Jun-2020 20:44:37.284 SEVERE [http-nio-8080-exec-8] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors
12-Jun-2020 20:45:23.838 INFO [http-nio-8080-exec-2] 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.
12-Jun-2020 20:45:32.990 SEVERE [http-nio-8080-exec-2] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
12-Jun-2020 20:45:32.991 SEVERE [http-nio-8080-exec-2] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors
ed because it does not exist
Unable to load specified config location file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.properties : C:\WINDOWS\ServiceProfiles\LocalService\.grails\openboxes-config.properties (The system cannot find the path specified)
Unable to load specified config location file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.groovy : C:\WINDOWS\ServiceProfiles\LocalService\.grails\openboxes-config.groovy (The system cannot find the path specified)

tomcat8-stdout.2020-06-12.log

2020-06-12 20:38:13 Apache Commons Daemon procrun stderr initialized.
12-Jun-2020 20:38:22.030 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/8.5.56
12-Jun-2020 20:38:22.223 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jun 3 2020 20:18:30 UTC
12-Jun-2020 20:38:22.223 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 8.5.56.0
12-Jun-2020 20:38:22.229 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows 10
12-Jun-2020 20:38:22.245 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
12-Jun-2020 20:38:22.245 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
12-Jun-2020 20:38:22.246 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\Program Files\Java\jre1.8.0_251
12-Jun-2020 20:38:22.246 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_251-b08
12-Jun-2020 20:38:22.247 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
12-Jun-2020 20:38:22.247 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 8.5
12-Jun-2020 20:38:22.248 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 8.5
12-Jun-2020 20:38:22.248 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 8.5
12-Jun-2020 20:38:22.249 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 8.5
12-Jun-2020 20:38:22.249 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 8.5\temp
12-Jun-2020 20:38:22.249 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
12-Jun-2020 20:38:22.249 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 8.5\conf\logging.properties
12-Jun-2020 20:38:22.250 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=256m
12-Jun-2020 20:38:22.250 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
12-Jun-2020 20:38:22.250 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort
12-Jun-2020 20:38:22.251 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512m
12-Jun-2020 20:38:22.251 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m
12-Jun-2020 20:38:22.251 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.2.24] using APR version [1.7.0].
12-Jun-2020 20:38:22.251 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
12-Jun-2020 20:38:22.252 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
12-Jun-2020 20:38:22.396 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.1g  21 Apr 2020]
12-Jun-2020 20:38:24.949 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
12-Jun-2020 20:38:25.801 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
12-Jun-2020 20:38:25.821 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 6114 ms
12-Jun-2020 20:38:25.973 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
12-Jun-2020 20:38:25.973 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.56
12-Jun-2020 20:38:26.086 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\openboxes.war]
12-Jun-2020 20:43:41.519 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.
12-Jun-2020 20:43:50.066 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
12-Jun-2020 20:43:50.067 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors
12-Jun-2020 20:43:50.132 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\openboxes.war] has finished in [324,047] ms
12-Jun-2020 20:43:50.132 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\manager]
12-Jun-2020 20:43:50.271 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\manager] has finished in [139] ms
12-Jun-2020 20:43:50.271 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\ROOT]
12-Jun-2020 20:43:50.304 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\ROOT] has finished in [33] ms
12-Jun-2020 20:43:50.323 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
12-Jun-2020 20:43:50.336 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 324521 ms
12-Jun-2020 20:44:28.613 INFO [http-nio-8080-exec-8] 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.
12-Jun-2020 20:44:37.282 SEVERE [http-nio-8080-exec-8] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
12-Jun-2020 20:44:37.284 SEVERE [http-nio-8080-exec-8] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors
12-Jun-2020 20:45:23.838 INFO [http-nio-8080-exec-2] 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.
12-Jun-2020 20:45:32.990 SEVERE [http-nio-8080-exec-2] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
12-Jun-2020 20:45:32.991 SEVERE [http-nio-8080-exec-2] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors
ed because it does not exist
Unable to load specified config location file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.properties : C:\WINDOWS\ServiceProfiles\LocalService\.grails\openboxes-config.properties (The system cannot find the path specified)
Unable to load specified config location file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.groovy : C:\WINDOWS\ServiceProfiles\LocalService\.grails\openboxes-config.groovy (The system cannot find the path specified)

jmiranda · June 12, 2020, 4:18pm

Alright so both of the problems I mentioned are showing up here. As well as a third, but we can ignore that one for now.

Using a version of Tomcat that was compiled with Java 8 instead of Java 7

12-Jun-2020 20:38:22.030 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/8.5.56

Tomcat 8.5.56 is most certainly compiled with Java 8 or 9 (not Java 7) so you need to download and install Tomcat 7 from

While the Ubuntu 18.04 installation instructions are specific to Ubuntu you can loosely follow them for the Windows installation.
https://docs.openboxes.com/en/develop/installation/ubuntu1804/tomcat/

You can ignore the Create Service section because the Windows Service is installed for you.

So Uninstall Tomcat 8 (if you’re only using it for OpenBoxes) and download Tomcat 7 from here.
https://tomcat.apache.org/download-70.cgi

The second issue

Data source connection pool cannot be created because the application cannot find the openboxes-config.properties file

is covered by the following two log statements

Unable to load specified config location file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.properties : C:\WINDOWS\ServiceProfiles\LocalService.grails\openboxes-config.properties (The system cannot find the path specified)
Unable to load specified config location file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.groovy : C:\WINDOWS\ServiceProfiles\LocalService.grails\openboxes-config.groovy (The system cannot find the path specified)

You need to create your openboxes-config.properties file here in order for the application to find it.

C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.properties

NOTE: This path might change when you install Tomcat 7, so check the logs again to see where the application is looking for it. With that said, I believe it should be the same.

The third problem (which may or may not cause problems) is that you are using Java 8. The version of Grails that we’re currently using only supports Java 7. We are working on an upgrade to Grails 3 but we’re a few months from finishing that up.

12-Jun-2020 20:38:22.246 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files\Java\jre1.8.0_251
12-Jun-2020 20:38:22.246 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_251-b08

So fix those first two issues and then let me know if you’re still encountering any issues.

Ali_Muhamamd_Nizaman · June 13, 2020, 4:53am

Dear, i have followed your instructions
1.Uninstall tomcat 8.5 and install 7.0
2. Place openboexes0config.properties file in your required file path . plz check screen shot

.
even though same issue persist.
"
FAIL - Application at context path [/openboxes] could not be started
"

tomcat7-stderr.2020-06-13.log

2020-06-13 09:20:41 Apache Commons Daemon procrun stderr initialized.
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version name:   Apache Tomcat/7.0.104
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server built:          May 7 2020 19:31:18 UTC
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version number: 7.0.104.0
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Name:               Windows 10
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Version:            10.0
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Architecture:          amd64
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Java Home:             C:\Program Files\Java\jre1.8.0_251
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Version:           1.8.0_251-b08
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Vendor:            Oracle Corporation
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 7.0\temp
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 7.0\conf\logging.properties
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: exit
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: abort
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xms128m
Jun 13, 2020 9:20:47 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xmx256m
Jun 13, 2020 9:20:47 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [C:\Program Files\Apache Software Foundation\Tomcat 7.0\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jre1.8.0_251\bin;C:\Program Files\Java\jdk-13.0.2\bin;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\Program Files\Microsoft SQL Server\130\DTS\Binn\;C:\WINDOWS\ServiceProfiles\LocalService\AppData\Local\Microsoft\WindowsApps;.]
Jun 13, 2020 9:20:49 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Jun 13, 2020 9:20:49 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 5335 ms
Jun 13, 2020 9:20:50 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service [Catalina]
Jun 13, 2020 9:20:50 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.104
Jun 13, 2020 9:20:50 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\openboxes.war]
Jun 13, 2020 9:25:35 AM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Jun 13, 2020 9:25:45 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: One or more listeners failed to start. Full details will be found in the appropriate container log file
Jun 13, 2020 9:25:45 AM org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
WARNING: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [436] milliseconds.
Jun 13, 2020 9:25:45 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/openboxes] startup failed due to previous errors
Jun 13, 2020 9:25:45 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\openboxes.war] has finished in [295,444] ms
Jun 13, 2020 9:25:45 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\host-manager]
Jun 13, 2020 9:25:46 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\host-manager] has finished in [218] ms
Jun 13, 2020 9:25:46 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager]
Jun 13, 2020 9:25:46 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager] has finished in [525] ms
Jun 13, 2020 9:25:46 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT]
Jun 13, 2020 9:25:46 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT] has finished in [84] ms
Jun 13, 2020 9:25:46 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Jun 13, 2020 9:25:46 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 296728 ms
Jun 13, 2020 9:26:20 AM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Jun 13, 2020 9:26:27 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: One or more listeners failed to start. Full details will be found in the appropriate container log file
Jun 13, 2020 9:26:27 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/openboxes] startup failed due to previous errors

Unable to load specified config location file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.groovy : C:\WINDOWS\ServiceProfiles\LocalService\.grails\openboxes-config.groovy (The system cannot find the file specified)

tomcat7-stdout.2020-06-13.log

2020-06-13 09:20:41 Apache Commons Daemon procrun stdout initialized.
Using configuration locations [classpath:openboxes-config.properties, classpath:openboxes-config.groovy, file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.properties, file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.groovy] [production]
2020-06-13 09:25:38,204 [localhost-startStop-1] INFO  context.ContextLoader  - Root WebApplicationContext: initialization started
2020-06-13 09:25:38,244 [localhost-startStop-1] INFO  support.XmlWebApplicationContext  - Refreshing Root WebApplicationContext: startup date [Sat Jun 13 09:25:38 PKT 2020]; root of context hierarchy
2020-06-13 09:25:38,343 [localhost-startStop-1] INFO  xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2020-06-13 09:25:38,879 [localhost-startStop-1] INFO  support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@5d26c5d: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy
2020-06-13 09:25:41,145 [localhost-startStop-1] WARN  commons.GrailsApplicationFactoryBean  - Class with name [org.pih.warehouse.putaway.PutawayService] was not found, and hence not loaded. Possible empty class or script definition?
2020-06-13 09:25:44,449 [localhost-startStop-1] INFO  cfg.Environment  - Hibernate 3.3.1.GA
2020-06-13 09:25:44,457 [localhost-startStop-1] INFO  cfg.Environment  - hibernate.properties not found
2020-06-13 09:25:44,824 [localhost-startStop-1] INFO  cfg.Environment  - Bytecode provider name : javassist
2020-06-13 09:25:44,828 [localhost-startStop-1] INFO  cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
2020-06-13 09:25:45,204 [localhost-startStop-1] INFO  support.DefaultListableBeanFactory  - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@5d26c5d: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy
2020-06-13 09:25:45,214 [localhost-startStop-1] ERROR context.ContextLoader  - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluginManager' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.NullPointerException: Cannot invoke method getAt() on null object
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException: Cannot invoke method getAt() on null object
	... 5 more
Using configuration locations [classpath:openboxes-config.properties, classpath:openboxes-config.groovy, file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.properties, file:C:\WINDOWS\ServiceProfiles\LocalService/.grails/openboxes-config.groovy] [production]
2020-06-13 09:26:21,504 [http-bio-8080-exec-4] INFO  context.ContextLoader  - Root WebApplicationContext: initialization started
2020-06-13 09:26:21,536 [http-bio-8080-exec-4] INFO  support.XmlWebApplicationContext  - Refreshing Root WebApplicationContext: startup date [Sat Jun 13 09:26:21 PKT 2020]; root of context hierarchy
2020-06-13 09:26:21,606 [http-bio-8080-exec-4] INFO  xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2020-06-13 09:26:21,729 [http-bio-8080-exec-4] INFO  support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@6d61ce5f: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy
2020-06-13 09:26:23,894 [http-bio-8080-exec-4] WARN  commons.GrailsApplicationFactoryBean  - Class with name [org.pih.warehouse.putaway.PutawayService] was not found, and hence not loaded. Possible empty class or script definition?
2020-06-13 09:26:26,822 [http-bio-8080-exec-4] INFO  cfg.Environment  - Hibernate 3.3.1.GA
2020-06-13 09:26:26,826 [http-bio-8080-exec-4] INFO  cfg.Environment  - hibernate.properties not found
2020-06-13 09:26:26,832 [http-bio-8080-exec-4] INFO  cfg.Environment  - Bytecode provider name : javassist
2020-06-13 09:26:26,835 [http-bio-8080-exec-4] INFO  cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
2020-06-13 09:26:27,119 [http-bio-8080-exec-4] INFO  support.DefaultListableBeanFactory  - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@6d61ce5f: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy
2020-06-13 09:26:27,129 [http-bio-8080-exec-4] ERROR context.ContextLoader  - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pluginManager' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.NullPointerException: Cannot invoke method getAt() on null object
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException: Cannot invoke method getAt() on null object
	... 3 more

I am not good tomcat log reader , plz help

Brijesh_Pandey · June 13, 2020, 5:53am

Hello Justin,

How are you doing ? Great to hear from you.

Extremely Sorry there was some interest issues on my side. Now my net is working fine.

Could you please specify what actually needs to you from my side ? I will love to help you.

Best Regards

Brijesh Pandey

jmiranda · June 13, 2020, 2:04pm

Ok so it looks like the third problem I mentioned is definitely causing this last issue. So uninstall Java 8 and install Java 7.

I would recommend installing the Zulu JVM.

And in case you haven’t watched the video, here’s an attempt I made to install on Windows a few years ago. It was Windows Server 2008 but most of the instructions should be applicable to your situation.
https://docs.openboxes.com/en/develop/installation/windows/

Ali_Muhamamd_Nizaman · June 15, 2020, 7:10am

Dear,
I have install above JDK version . Now getting different errors in log file which are related with database connectivity. Is their any other location in tomcat where i have to configure database credentials excluding openboxes-config.properties file… plz help

Stacktrace.log

Caused by: org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

tomcat7-stdout.2020-06-15.log

2020-06-15 11:41:57,925 [http-bio-8080-exec-3] INFO  c3p0.C3P0Registry  - Initializing c3p0-0.9.5.3 [built 27-January-2019 00:11:37 -0800; debug? true; trace: 10]
2020-06-15 11:41:58,709 [http-bio-8080-exec-3] INFO  impl.AbstractPoolBackedDataSource  - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hge2veaa1ep2jz1bih44n|3c604148, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge2veaa1ep2jz1bih44n|3c604148, idleConnectionTestPeriod -> 7200, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3306/openboxes?autoReconnect=true&zeroDateTimeBehavior=convertToNull&sessionVariables=storage_engine=InnoDB, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 14400, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 1800, maxPoolSize -> 100, maxStatements -> 180, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, preferredTestQuery -> SELECT 1, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 1, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
2020-06-15 11:48:40,791 [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1ep2jz1bih44n|3c604148]-HelperThread-#0] WARN  resourcepool.BasicResourcePool  - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@18c4693f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

jmiranda · June 15, 2020, 12:46pm

So this error is just stating that OpenBoxes cannot create the database connection pool. This happens because the credentials in openboxes-config.properties are invalid or because OpenBoxes cannot find the openboxes-config.properties file.

Can you attach the full stdout and street logs for today? There should be an option to upload those files.

Ali_Muhamamd_Nizaman · June 15, 2020, 5:44pm

Yes, (unable to write both file logs in on msg due to characters limit , sending another log in other msg)

*tomcat7-stderr.2020-06-15.log

2020-06-15 21:29:30 Apache Commons Daemon procrun stderr initialized.
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version name:   Apache Tomcat/7.0.104
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server built:          May 7 2020 19:31:18 UTC
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version number: 7.0.104.0
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Name:               Windows 10
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Version:            10.0
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Architecture:          amd64
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Java Home:             C:\Program Files\Zulu\zulu-7\jre
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Version:           1.7.0_262-b10
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Vendor:            Azul Systems, Inc.
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 7.0

I have followed word by word of your video tutorial, I am trying my hit and try in various directions !!!
is their any way to edit jdbc connectivity file which hold database credentials and put correct credentials?
is their any way so that we just write sql quires in open boxes database and then start open-boxes tomcat instance or can we know root password which is used by openboxes source code so that i can put that root password and then start openboxes instance…?
can you share me your skype i want to share my “any desk” remote access…
Plz help …

Ali_Muhamamd_Nizaman · June 15, 2020, 5:45pm

tomcat7-stdout.2020-06-15.log

2020-06-15 21:29:30 Apache Commons Daemon procrun stdout initialized.
Using configuration locations [classpath:openboxes-config.properties, classpath:openboxes-config.groovy, file:C:\Windows\ServiceProfiles\LocalService/.grails/openboxes-config.properties, file:C:\Windows\ServiceProfiles\LocalService/.grails/openboxes-config.groovy] [production]
2020-06-15 21:37:37,403 [localhost-startStop-1] INFO  context.ContextLoader  - Root WebApplicationContext: initialization started
2020-06-15 21:37:37,440 [localhost-startStop-1] INFO  support.XmlWebApplicationContext  - Refreshing Root WebApplicationContext: startup date [Mon Jun 15 21:37:37 PKT 2020]; root of context hierarchy
2020-06-15 21:37:37,530 [localhost-startStop-1] INFO  xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2020-06-15 21:37:38,341 [localhost-startStop-1] INFO  support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@49056629: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy
2020-06-15 21:38:07,380 [localhost-startStop-1] WARN  commons.GrailsApplicationFactoryBean  - Class with name [org.pih.warehouse.putaway.PutawayService] was not found, and hence not loaded. Possible empty class or script definition?
2020-06-15 21:38:21,734 [localhost-startStop-1] INFO  cfg.Environment  - Hibernate 3.3.1.GA
2020-06-15 21:38:21,739 [localhost-startStop-1] INFO  cfg.Environment  - hibernate.properties not found
2020-06-15 21:38:21,739 [localhost-startStop-1] INFO  cfg.Environment  - Bytecode provider name : javassist
2020-06-15 21:38:21,751 [localhost-startStop-1] INFO  cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
2020-06-15 21:38:28,789 [localhost-startStop-1] INFO  annotation.ClassPathBeanDefinitionScanner  - JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning
2020-06-15 21:38:34,077 [MLog-Init-Reporter] INFO  log.MLog  - MLog clients using slf4j logging.
2020-06-15 21:38:39,593 [localhost-startStop-1] INFO  c3p0.C3P0Registry  - Initializing c3p0-0.9.5.3 [built 27-January-2019 00:11:37 -0800; debug? true; trace: 10]
2020-06-15 21:38:40,583 [localhost-startStop-1] INFO  impl.AbstractPoolBackedDataSource  - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hge2veaa1fadw8bj0jmfa|32a6cf5b, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge2veaa1fadw8bj0jmfa|32a6cf5b, idleConnectionTestPeriod -> 7200, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3306/openboxes?autoReconnect=true&zeroDateTimeBehavior=convertToNull&sessionVariables=storage_engine=InnoDB, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 14400, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 1800, maxPoolSize -> 100, maxStatements -> 180, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, preferredTestQuery -> SELECT 1, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 1, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
2020-06-15 21:45:38,844 [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1fadw8bj0jmfa|32a6cf5b]-HelperThread-#0] WARN  resourcepool.BasicResourcePool  - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3352a79e -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.GeneratedConstructorAccessor59.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2105)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2030)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2046)
	... 18 more
2020-06-15 21:45:38,844 [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1fadw8bj0jmfa|32a6cf5b]-HelperThread-#1] WARN  resourcepool.BasicResourcePool  - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@777a9064 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.GeneratedConstructorAccessor59.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2105)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2030)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2046)
	... 18 more
2020-06-15 21:45:38,891 [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1fadw8bj0jmfa|32a6cf5b]-HelperThread-#0] WARN  resourcepool.BasicResourcePool  - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@4c5681f1 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2020-06-15 21:45:38,894 [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1fadw8bj0jmfa|32a6cf5b]-HelperThread-#1] WARN  resourcepool.BasicResourcePool  - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@4c5681f1 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2020-06-15 21:45:38,984 [localhost-startStop-1] ERROR context.ContextLoader  - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'lobHandlerDetector' while setting bean property 'lobHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'lobHandlerDetector' while setting bean property 'lobHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	... 5 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'lobHandlerDetector' while setting bean property 'lobHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	... 5 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'lobHandlerDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	... 5 more
Caused by: org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	... 5 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
	... 5 more
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
	
	... 15 more

Ali_Muhamamd_Nizaman · June 15, 2020, 5:54pm

stderr log

2020-06-15 21:29:30 Apache Commons Daemon procrun stderr initialized.
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version name:   Apache Tomcat/7.0.104
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server built:          May 7 2020 19:31:18 UTC
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version number: 7.0.104.0
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Name:               Windows 10
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Version:            10.0
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Architecture:          amd64
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Java Home:             C:\Program Files\Zulu\zulu-7\jre
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Version:           1.7.0_262-b10
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Vendor:            Azul Systems, Inc.
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 7.0\temp
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 7.0\conf\logging.properties
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -XX:MaxPermSize=256m
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: exit
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: abort
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xms512m
Jun 15, 2020 9:29:35 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xmx1024m
Jun 15, 2020 9:29:35 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [C:\Program Files\Apache Software Foundation\Tomcat 7.0\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Zulu\zulu-7\jre\bin;C:\Program Files\Java\jdk-13.0.2\bin;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\Program Files\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files\Zulu\zulu-7\bin\;C:\WINDOWS\ServiceProfiles\LocalService\AppData\Local\Microsoft\WindowsApps;.]
Jun 15, 2020 9:29:36 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Jun 15, 2020 9:29:37 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3324 ms
Jun 15, 2020 9:29:37 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service [Catalina]
Jun 15, 2020 9:29:37 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.104
Jun 15, 2020 9:29:37 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\openboxes.war]
Jun 15, 2020 9:37:31 PM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Jun 15, 2020 9:45:38 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: One or more listeners failed to start. Full details will be found in the appropriate container log file
Jun 15, 2020 9:45:38 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/openboxes] startup failed due to previous errors
Jun 15, 2020 9:45:39 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
SEVERE: The web application [/openboxes] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Jun 15, 2020 9:45:39 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1fadw8bj0jmfa|32a6cf5b]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 9:45:39 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1fadw8bj0jmfa|32a6cf5b]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 9:45:39 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1fadw8bj0jmfa|32a6cf5b]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 9:45:39 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1fadw8bj0jmfa|32a6cf5b]-DeferredStatementDestroyerThread-#0] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 9:45:39 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 9:45:39 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\openboxes.war] has finished in [961,874] ms
Jun 15, 2020 9:45:39 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\docs]
Jun 15, 2020 9:45:39 PM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Jun 15, 2020 9:45:39 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\docs] has finished in [665] ms
Jun 15, 2020 9:45:39 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\host-manager]
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\host-manager] has finished in [246] ms
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager]
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager] has finished in [379] ms
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT]
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT] has finished in [141] ms
Jun 15, 2020 9:45:40 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Jun 15, 2020 9:45:40 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 963774 ms
Jun 15, 2020 9:45:41 PM org.apache.catalina.loader.WebappClassLoaderBase findResourceInternal
INFO: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
Jun 15, 2020 9:54:30 PM org.apache.catalina.startup.TldConfig execute
INFO: 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.
Jun 15, 2020 10:01:50 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: One or more listeners failed to start. Full details will be found in the appropriate container log file
Jun 15, 2020 10:01:50 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/openboxes] startup failed due to previous errors
Jun 15, 2020 10:01:51 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
SEVERE: The web application [/openboxes] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Jun 15, 2020 10:01:51 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1faz35d1qilioe|6adbccb9]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 10:01:51 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1faz35d1qilioe|6adbccb9]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 10:01:51 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1faz35d1qilioe|6adbccb9]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 10:01:51 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge2veaa1faz35d1qilioe|6adbccb9]-DeferredStatementDestroyerThread-#0] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 10:01:51 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak.
Jun 15, 2020 10:01:54 PM org.apache.catalina.loader.WebappClassLoaderBase findResourceInternal
INFO: Illegal access: this web application instance has been stopped already. Could not load []. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
 verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:04 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:09 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:09 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:09 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:13 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:13 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:13 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:17 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:17 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:17 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:21 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:21 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:21 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:25 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:25 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:25 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:30 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:30 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:30 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:34 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:34 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:34 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:38 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Mon Jun 15 21:39:38 PKT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Unable to load specified config location classpath:openboxes-config.properties : class path resource [openboxes-config.properties] cannot be opened because it does not exist
Unable to load specified config location classpath:openboxes-config.groovy : class path resource [openboxes-config.groovy] cannot be opened because it does not exist
Unable to load specified config location file:C:\Windows\ServiceProfiles\LocalService/.grails/openboxes-config.groovy : startup failed:
script15922400737331693796510.groovy: 1: unexpected token: : @ line 1, column 20.

jmiranda · June 16, 2020, 3:49am

Yeah that works for me. Send me an email to support@openboxes.com with your Skype username and I’ll contact you tomorrow. I’ll be online around 8:30am CDT.

Ali_Muhamamd_Nizaman · June 17, 2020, 8:37am

Its solved, Thanks mat

jmiranda · June 17, 2020, 1:34pm

@TheMahinda If you’re having an issue please let us know. Click on the New Topic button, provide your stderr and stdout logs and I’ll try to respond later today.

TheMahinda · June 17, 2020, 2:42pm

Thanks @jmiranda but I was able to complete installation and thus withdrew my post.

Great job with the video tutorial. Appreciated.

tendomart · May 30, 2021, 2:30pm

Hi @jmiranda am having a similar issue .

My system is ubuntu 20
OpenJDK-7 , tomcat-7 . I have tried to hack around all possible ways with no solution.

my properties file is at /opt/tomcat/.grails

and my properties file contents are

dataSource.username=openboxes
dataSource.password=************************
#dataSource.url=jdbc:mysql://localhost:3306/openboxes?useSSL=false
dataSource.url=jdbc:mysql://localhost:3306/openboxes

Used primarily with g:link when absoluteUrl is true (e.g. links in emails)

grails.serverURL=http://localhost:8080/openboxes

OpenBoxes mail settings - disabled by default (unless you set up an SMTP server)

#grails.mail.enabled=true

These are my Catalina.out logs are May 28, 2021 1:14:25 PM org.apache.catalina.core.AprLifecycleListener initINFO - Pastebin.com