Windows installation errors

Hi

I can’t start openboxes from tomcat application manager. Please help me . Sorry for bad english.

2021-06-20 22:05:10 Apache Commons Daemon procrun stderr initialized.
20-Jun-2021 22:05:10.967 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/10.0.7
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jun 8 2021 16:31:06 UTC
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 10.0.7.0
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows 10
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\Program Files\Java\jre1.8.0_291
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_291-b10
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 10.0
20-Jun-2021 22:05:10.969 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 10.0
20-Jun-2021 22:05:10.970 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 10.0
20-Jun-2021 22:05:10.970 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 10.0
20-Jun-2021 22:05:10.970 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 10.0\temp
20-Jun-2021 22:05:10.970 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
20-Jun-2021 22:05:10.970 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 10.0\conf\logging.properties
20-Jun-2021 22:05:10.971 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
20-Jun-2021 22:05:10.971 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort
20-Jun-2021 22:05:10.971 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms1024m
20-Jun-2021 22:05:10.971 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m
20-Jun-2021 22:05:10.974 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded Apache Tomcat Native library [1.2.30] using APR version [1.7.0].
20-Jun-2021 22:05:10.974 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true], UDS [true].
20-Jun-2021 22:05:10.978 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.1k  25 Mar 2021]
20-Jun-2021 22:05:11.241 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
20-Jun-2021 22:05:11.257 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [426] milliseconds
20-Jun-2021 22:05:11.284 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
20-Jun-2021 22:05:11.284 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/10.0.7]
20-Jun-2021 22:05:11.302 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 10.0\webapps\openboxes.war]
20-Jun-2021 22:05:19.426 INFO [main] 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.
20-Jun-2021 22:05:19.458 SEVERE [main] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
20-Jun-2021 22:05:19.639 WARNING [main] org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [181] milliseconds.
20-Jun-2021 22:05:19.639 SEVERE [main] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors
20-Jun-2021 22:05:19.650 INFO [main] org.apache.catalina.startup.HostConfig.deployWAR Deployment of web application archive [C:\Program Files\Apache Software Foundation\Tomcat 10.0\webapps\openboxes.war] has finished in [8,348] ms
20-Jun-2021 22:05:19.650 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 10.0\webapps\docs]
20-Jun-2021 22:05:19.678 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 10.0\webapps\docs] has finished in [28] ms
20-Jun-2021 22:05:19.679 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 10.0\webapps\manager]
20-Jun-2021 22:05:19.706 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 10.0\webapps\manager] has finished in [28] ms
20-Jun-2021 22:05:19.706 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 10.0\webapps\ROOT]
20-Jun-2021 22:05:19.722 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 10.0\webapps\ROOT] has finished in [16] ms
20-Jun-2021 22:05:19.725 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
20-Jun-2021 22:05:19.735 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [8477] milliseconds
20-Jun-2021 22:07:35.323 INFO [http-nio-8080-exec-6] 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.
20-Jun-2021 22:07:35.338 SEVERE [http-nio-8080-exec-6] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
20-Jun-2021 22:07:35.338 SEVERE [http-nio-8080-exec-6] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors
20-Jun-2021 22:08:37.817 INFO [http-nio-8080-exec-7] 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.
20-Jun-2021 22:08:37.831 SEVERE [http-nio-8080-exec-7] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
20-Jun-2021 22:08:37.831 SEVERE [http-nio-8080-exec-7] org.apache.catalina.core.StandardContext.startInternal Context [/openboxes] startup failed due to previous errors

Hey @datinhkhach

According to your logs you’re trying to deploy OpenBoxes on a Windows 10 system running Java 8 and Tomcat 10

Server version name:   Apache Tomcat/10.0.7
Server built:          Jun 8 2021 16:31:06 UTC
Server version number: 10.0.7.0
OS Name:               Windows 10
OS Version:            10.0
Architecture:          amd64
Java Home:             C:\Program Files\Java\jre1.8.0_291
JVM Version:           1.8.0_291-b10

Unfortunately, the latest version of OpenBoxes requires Java 7 and a version of Tomcat that was compiled with Java 7 (we recommend Tomcat 7).

We are working on migrating to Grails 3.3.10 (which supports Java 8+, Tomcat 9+), so we hope to remove this installation headache in the near future. However, the migration is taking longer than expected and we don’t have a timeline for completion yet.

1 Like

After few tries i can’t get openbox to work. please help me. Reinstalled : Tomcat7 , Zulu7.

  • Stderr log :
2021-07-04 23:37:01 Apache Commons Daemon procrun stderr initialized.
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version name:   Apache Tomcat/7.0.109
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server built:          Apr 22 2021 18:43:38 UTC
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version number: 7.0.109.0
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Name:               Windows 10
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Version:            10.0
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Architecture:          amd64
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Java Home:             C:\Program Files\Zulu\zulu-7\jre
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Version:           1.7.0_302-b01
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Vendor:            Azul Systems, Inc.
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 7.0\temp
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
Jul 04, 2021 11:37:01 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
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -XX:MaxPermSize=256m
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: exit
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: abort
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xms2048m
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xmx2048m
Jul 04, 2021 11:37:01 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: Loaded Apache Tomcat Native library [1.2.28] using APR version [1.7.0].
Jul 04, 2021 11:37:01 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
Jul 04, 2021 11:37:01 PM org.apache.catalina.core.AprLifecycleListener initializeSSL
INFO: OpenSSL successfully initialized [OpenSSL 1.1.1k  25 Mar 2021]
Jul 04, 2021 11:37:01 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-apr-8080"]
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 491 ms
Jul 04, 2021 11:37:01 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service [Catalina]
Jul 04, 2021 11:37:01 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.109
Jul 04, 2021 11:37:01 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\openboxes.war]
Jul 04, 2021 11:37:08 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.
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.properties : C:\Windows\ServiceProfiles\LocalService\.grails\openboxes-config.properties (Access is denied)
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)
Jul 04, 2021 11:43:44 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
Jul 04, 2021 11:43:44 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/openboxes] startup failed due to previous errors
Jul 04, 2021 11:43:44 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.
Jul 04, 2021 11:43:44 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge1adaivqit9j1sjru9c|55ce57c2]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak.
Jul 04, 2021 11:43:44 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge1adaivqit9j1sjru9c|55ce57c2]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak.
Jul 04, 2021 11:43:44 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge1adaivqit9j1sjru9c|55ce57c2]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak.
Jul 04, 2021 11:43:44 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge1adaivqit9j1sjru9c|55ce57c2]-DeferredStatementDestroyerThread-#0] but has failed to stop it. This is very likely to create a memory leak.
Jul 04, 2021 11:43:44 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.
Jul 04, 2021 11:43:44 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 [402,305] ms
Jul 04, 2021 11:43:44 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager]
Jul 04, 2021 11:43:44 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 [78] ms
Jul 04, 2021 11:43:44 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT]
Jul 04, 2021 11:43:44 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 [31] ms
Jul 04, 2021 11:43:44 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
Jul 04, 2021 11:43:44 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 402467 ms
log4j:WARN No appenders could be found for logger (com.mchange.v2.async.ThreadPoolAsynchronousRunner).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
log4j:WARN No appenders could be found for logger (com.mchange.v2.async.ThreadPoolAsynchronousRunner).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
log4j:WARN No appenders could be found for logger (com.mchange.v2.async.ThreadPoolAsynchronousRunner).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Jul 04, 2021 11:43:48 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.
  • Stdout log :
2021-07-04 23:37:01 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]
2021-07-04 23:37:09,460 [localhost-startStop-1] INFO  context.ContextLoader  - Root WebApplicationContext: initialization started
2021-07-04 23:37:09,478 [localhost-startStop-1] INFO  support.XmlWebApplicationContext  - Refreshing Root WebApplicationContext: startup date [Sun Jul 04 23:37:09 ICT 2021]; root of context hierarchy
2021-07-04 23:37:09,507 [localhost-startStop-1] INFO  xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2021-07-04 23:37:09,596 [localhost-startStop-1] INFO  support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@6984c578: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy
2021-07-04 23:37:10,872 [localhost-startStop-1] WARN  commons.GrailsApplicationFactoryBean  - Class with name [org.pih.warehouse.putaway.PutawayCompletedEventService] was not found, and hence not loaded. Possible empty class or script definition?
2021-07-04 23:37:10,873 [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?
2021-07-04 23:37:12,640 [localhost-startStop-1] INFO  cfg.Environment  - Hibernate 3.3.1.GA
2021-07-04 23:37:12,642 [localhost-startStop-1] INFO  cfg.Environment  - hibernate.properties not found
2021-07-04 23:37:12,644 [localhost-startStop-1] INFO  cfg.Environment  - Bytecode provider name : javassist
2021-07-04 23:37:12,646 [localhost-startStop-1] INFO  cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
2021-07-04 23:37:15,458 [localhost-startStop-1] INFO  annotation.ClassPathBeanDefinitionScanner  - JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning
2021-07-04 23:37:16,014 [MLog-Init-Reporter] INFO  log.MLog  - MLog clients using slf4j logging.
2021-07-04 23:37:17,210 [localhost-startStop-1] INFO  c3p0.C3P0Registry  - Initializing c3p0-0.9.5.3 [built 27-January-2019 00:11:37 -0800; debug? true; trace: 10]
2021-07-04 23:37:17,584 [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 -> 1hge1adaivqit9j1sjru9c|55ce57c2, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge1adaivqit9j1sjru9c|55ce57c2, 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 ]
2021-07-04 23:43:44,045 [C3P0PooledConnectionPoolManager[identityToken->1hge1adaivqit9j1sjru9c|55ce57c2]-HelperThread-#2] WARN  resourcepool.BasicResourcePool  - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@437328ce -- 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.GeneratedConstructorAccessor52.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.GeneratedConstructorAccessor49.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: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
	at sun.reflect.GeneratedConstructorAccessor39.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.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4914)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)
	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
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
	at sun.security.ssl.Handshaker.activate(Handshaker.java:482)
	at sun.security.ssl.SSLSocketImpl.kickstartHandshake(SSLSocketImpl.java:1429)
	at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1302)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1350)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1334)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186)
	... 23 more
2021-07-04 23:43:44,047 [C3P0PooledConnectionPoolManager[identityToken->1hge1adaivqit9j1sjru9c|55ce57c2]-HelperThread-#2] WARN  resourcepool.BasicResourcePool  - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@76d5ab05 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2021-07-04 23:43:44,069 [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
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
	... 5 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1469)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
	... 6 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	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 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: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4914)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)
	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)
	... 15 more
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186)
	... 20 more

@datinhkhach FYI, I’m moving your posts to a new thread since the other thread has already been resolved.

So it looks like you resolved the issue with Java / Tomcat versions. Huzzah!

INFO: Server version name:   Apache Tomcat/7.0.109
INFO: Server built:          Apr 22 2021 18:43:38 UTC
INFO: Server version number: 7.0.109.0
INFO: OS Name:               Windows 10
INFO: OS Version:            10.0
INFO: Architecture:          amd64
INFO: Java Home:             C:\Program Files\Zulu\zulu-7\jre
INFO: JVM Version:           1.7.0_302-b01
INFO: JVM Vendor:            Azul Systems, Inc.

The new issue is that the application cannot create a database connection pool.

2021-07-04 23:43:44,045 [C3P0PooledConnectionPoolManager[identityToken->1hge1adaivqit9j1sjru9c|55ce57c2]-HelperThread-#2] WARN  resourcepool.BasicResourcePool  - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@437328ce -- 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.

That is usually due to one of two factors:

  1. The database user was not created properly (unlikely if you followed the instructions)
  2. The application cannot find openboxes-config.properties (likely)

The way we diagnose this is to check the logs to see where the application is looking for the configuration files.

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.properties : C:\Windows\ServiceProfiles\LocalService\.grails\openboxes-config.properties (Access is denied)
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)

So you probably created openboxes-config.properties file under USER_HOME, but since Tomcat is installed as a service on Windows 10, the user is the LocalService account. Therefore, you’ll need to create the .grails directory under the LocalService directory (see below) and move your openboxes-config.properties file to this directory.

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

Restart Tomcat and you should be all set.

NOTE: Initial startup takes a loooong time (20+ minutes), so please check the logs to see when the database migration process has completed.

Database and openboxes-config.properties file is Ok , but same ploblem .



1

Copy the file in the screenshot below to C:\Windows\ServiceProfiles\LocalService/.grails/ and then restart Tomcat and let me know if that fixes the issue.

1

Sorry for missing information : All 3 location has “openboxes-config.properties” file too . User_Home.grails , Tomcat 7.0.grails, LocalService.grails. And not working . Im trying to setup Vmware machine with Windows Server, maybe work :frowning:
1
5
6

Can you repost stderr and stdout? Maybe stop Tomcat, delete the old files, and restart Tomcat so we get a fresh look.

It all looks good to me, but I’ve had issues in the past with Windows because it was doing some weird things with the properties file (i.e. user did not have permission, .grails directory was not set up properly, properties file was actually saved with a txt extension).

One other thing to do is open a command shell (powershell or otherwise) and try to get a detailed listing of the directories and file. I don’t know what the PowerShell command is, but can you provide a detailed listing of the .grails directory and openboxes-config.properties file. The command might be Get-ChildItem, but I’m not proficient in PowerShell.

Get-ChildItem C:\Windows\ServiceProfiles\LocalService/.grails
Get-ChildItem C:\Windows\ServiceProfiles\LocalService/.grails/openboxes-config.properties

You could even go up one more level to LocalService to make sure that the .grails folder was created properly.

Get-ChildItem C:\Windows\ServiceProfiles\LocalService

Sometimes Windows doesn’t create a proper hidden directory. I can’t remember if that’s when you create from the Windows Explorer or from the command line. But we might be able to see something obvious in the file listings.

It would also be helpful if we could check if you have permission to access the file as the LocalService user. That might require logging in as LocalService and then reading the file contents from the command line.

Get-Content C:\Windows\ServiceProfiles\LocalService/.grails/openboxes-config.properties

If you can, provide the output for all of those commands.

Otherwise, we could also jump on a screenshare session and I can try to troubleshoot with you.

Hi

I’m using personal computer and just 1 user with administrator permission . Deleted old log file and stop + start tomcat as you suggest : no working .
Stder Log :


2021-07-07 00:35:17 Apache Commons Daemon procrun stderr initialized.
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version name:   Apache Tomcat/7.0.109
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server built:          Apr 22 2021 18:43:38 UTC
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Server version number: 7.0.109.0
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Name:               Windows 10
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: OS Version:            10.0
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Architecture:          amd64
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Java Home:             C:\Program Files\Zulu\zulu-7\jre
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Version:           1.7.0_302-b01
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: JVM Vendor:            Azul Systems, Inc.
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 7.0
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 7.0\temp
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
Jul 07, 2021 12:35:18 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
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -XX:MaxPermSize=256m
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: exit
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: abort
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xms2048m
Jul 07, 2021 12:35:18 AM org.apache.catalina.startup.VersionLoggerListener log
INFO: Command line argument: -Xmx2048m
Jul 07, 2021 12:35:18 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: Loaded Apache Tomcat Native library [1.2.28] using APR version [1.7.0].
Jul 07, 2021 12:35:18 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
Jul 07, 2021 12:35:18 AM org.apache.catalina.core.AprLifecycleListener initializeSSL
INFO: OpenSSL successfully initialized [OpenSSL 1.1.1k  25 Mar 2021]
Jul 07, 2021 12:35:19 AM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-apr-8080"]
Jul 07, 2021 12:35:19 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1093 ms
Jul 07, 2021 12:35:19 AM org.apache.catalina.core.StandardService startInternal
INFO: Starting service [Catalina]
Jul 07, 2021 12:35:19 AM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.109
Jul 07, 2021 12:35:19 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\openboxes.war]
Jul 07, 2021 12:37:25 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.
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.properties : C:\Windows\ServiceProfiles\LocalService\.grails\openboxes-config.properties (Access is denied)
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)
Wed Jul 07 00:37:35 ICT 2021 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.
Wed Jul 07 00:44:10 ICT 2021 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.
Wed Jul 07 00:44:10 ICT 2021 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.
Jul 07, 2021 12:44:10 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
Jul 07, 2021 12:44:10 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/openboxes] startup failed due to previous errors
Jul 07, 2021 12:44:10 AM 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.
Jul 07, 2021 12:44:10 AM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge1abaiynk1zbjwphl1|63f8feb3]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak.
Jul 07, 2021 12:44:10 AM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge1abaiynk1zbjwphl1|63f8feb3]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak.
Jul 07, 2021 12:44:10 AM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
SEVERE: The web application [/openboxes] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->1hge1abaiynk1zbjwphl1|63f8feb3]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak.
Jul 07, 2021 12:44:10 AM 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.
Jul 07, 2021 12:44:10 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 [531,234] ms
Jul 07, 2021 12:44:10 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\manager]
Jul 07, 2021 12:44:10 AM 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.
Jul 07, 2021 12:44:10 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 [110] ms
Jul 07, 2021 12:44:10 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\ROOT]
Jul 07, 2021 12:44:11 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 [44] ms
Jul 07, 2021 12:44:11 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
Jul 07, 2021 12:44:11 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 531472 ms
log4j:WARN No appenders could be found for logger (com.mchange.v2.resourcepool.BasicResourcePool).
log4j:WARN No appenders could be found for logger (com.mchange.v2.resourcepool.BasicResourcePool).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

Stdout Log :


2021-07-07 00:35:17 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]
2021-07-07 00:37:26,740 [localhost-startStop-1] INFO  context.ContextLoader  - Root WebApplicationContext: initialization started
2021-07-07 00:37:26,757 [localhost-startStop-1] INFO  support.XmlWebApplicationContext  - Refreshing Root WebApplicationContext: startup date [Wed Jul 07 00:37:26 ICT 2021]; root of context hierarchy
2021-07-07 00:37:26,786 [localhost-startStop-1] INFO  xml.XmlBeanDefinitionReader  - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
2021-07-07 00:37:26,916 [localhost-startStop-1] INFO  support.DefaultListableBeanFactory  - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@7fa0898d: defining beans [grailsApplication,pluginManager,grailsConfigurator,grailsResourceLoader,grailsResourceHolder,characterEncodingFilter]; root of factory hierarchy
2021-07-07 00:37:28,615 [localhost-startStop-1] WARN  commons.GrailsApplicationFactoryBean  - Class with name [org.pih.warehouse.putaway.PutawayCompletedEventService] was not found, and hence not loaded. Possible empty class or script definition?
2021-07-07 00:37:28,616 [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?
2021-07-07 00:37:30,343 [localhost-startStop-1] INFO  cfg.Environment  - Hibernate 3.3.1.GA
2021-07-07 00:37:30,345 [localhost-startStop-1] INFO  cfg.Environment  - hibernate.properties not found
2021-07-07 00:37:30,347 [localhost-startStop-1] INFO  cfg.Environment  - Bytecode provider name : javassist
2021-07-07 00:37:30,349 [localhost-startStop-1] INFO  cfg.Environment  - using JDK 1.4 java.sql.Timestamp handling
2021-07-07 00:37:33,128 [localhost-startStop-1] INFO  annotation.ClassPathBeanDefinitionScanner  - JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning
2021-07-07 00:37:33,634 [MLog-Init-Reporter] INFO  log.MLog  - MLog clients using slf4j logging.
2021-07-07 00:37:34,858 [localhost-startStop-1] INFO  c3p0.C3P0Registry  - Initializing c3p0-0.9.5.3 [built 27-January-2019 00:11:37 -0800; debug? true; trace: 10]
2021-07-07 00:37:35,262 [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 -> 1hge1abaiynk1zbjwphl1|63f8feb3, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge1abaiynk1zbjwphl1|63f8feb3, 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 ]
2021-07-07 00:44:10,823 [C3P0PooledConnectionPoolManager[identityToken->1hge1abaiynk1zbjwphl1|63f8feb3]-HelperThread-#0] WARN  resourcepool.BasicResourcePool  - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@78ac2b15 -- 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.GeneratedConstructorAccessor49.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.GeneratedConstructorAccessor47.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: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
	at sun.reflect.GeneratedConstructorAccessor39.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.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4914)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)
	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
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
	at sun.security.ssl.Handshaker.activate(Handshaker.java:482)
	at sun.security.ssl.SSLSocketImpl.kickstartHandshake(SSLSocketImpl.java:1429)
	at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1302)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1350)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1334)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186)
	... 23 more
2021-07-07 00:44:10,825 [C3P0PooledConnectionPoolManager[identityToken->1hge1abaiynk1zbjwphl1|63f8feb3]-HelperThread-#0] WARN  resourcepool.BasicResourcePool  - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@49e263c is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2021-07-07 00:44:10,845 [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
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
	... 5 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1469)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
	... 6 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	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 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: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4914)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)
	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)
	... 15 more
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186)
	... 20 more

The stderr log file shows the issue. See the third line down (Access is denied)

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.properties : C:\Windows\ServiceProfiles\LocalService\.grails\openboxes-config.properties (Access is denied)
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)

So we just need to figure out how to give read access to the LocalService. I’ll check old threads to see if we’ve encountered this before.

@datinhkhach In case it wasn’t clear I believe the error indicates that we need to give access to this folder (and files) to LocalService account. It is not clear to me how that is done for the LocalService account.

We can try one more approach if you don’t figure out.

@jmiranda : I found the cause of the error and fixed it myself. Just open .grails folder and manually add the LOCAL SERVICE account to the Security Settings and give it full permissions.

@jmiranda i have ploblem with encoding charset while translate language . Openboxes use Cp1252 , can i change it to Unicode UTF-8 ?

i have ploblem with encoding charset while translate language . Openboxes use Cp1252 , can i change it to Unicode UTF-8 ?

Can you clarify what the problem is? What version of MySQL are you using?

OpenBoxes doesn’t require a specific character set. You need to set it when you create the database or else MySQL will choose a default. So I think in your case MySQL chose Cp1252 because that’s what was the default for your system?

FWIW I always use UTF8 by default for any database that I create in MySQL (5.5+). Did you include the default charset when you created the database?

mysql> create database openboxes default charset utf8;

If not, I believe you can apply the charset to the database and individual tables after the fact.

However, you might encounter some issues converting the database and tables to UTF8. If so, just create the database specifying the default charset.

For MySQL 5.7 use utf8

mysql> create database openboxes default charset utf8;

For MySQL 8 use utf8mb4

mysql> create database openboxes default charset utf8mb4;

Also, here are some known issues that I’ve encountered with MySQL 8. I don’t think I’ve run into any issues with a database newly created in MySQL 8. In other words, these issues were encountered with a database that was created in MySQL 5.7 and then upgraded to MySQL 8. So you may not encounter these yourself. If you do, please let me know.

Sorry for my poor English, I will use translator to explain my problem. I downloaded the messages.properties file following the instructions here: How to translate the UI in any language. Then I used google translate to test translating a few lines, then I copied the translated file into

C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\openboxes\WEB-INF\grails-app\i18n

I went back to the openboxes web interface and saw that there was a change, but the lines of text I tested to translate to my language were showing errors as shown in the picture:

text2

Checking the Openboxes system settings, the endcode charset is setting at cp1252, I think it’s a mistake in the java settings but haven’t found a way to fix it.

Sorry for my poor English, I will use translator to explain my problem.

Don’t apologize. Your English is great. It’s just hard to figure out the actual problem without more details info. So thank you for including the steps to reproduce and screenshots.

Interesting issue. The file.encoding is definitely not an OpenBoxes specific property. Your OS / JVM / Tomcat instance is responsible for that property. There’s a way to override it, but let’s explore this a bit more to make sure we know that’s actually causing the problem.

So let me try to reproduce this on my local instance. Can you send me the messages.properties file you used?

Here is my messages.properties file … oops can’t upload .properties here, so i renamed extension to .docx .
messages_vi.docx (157.5 KB)