@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:
- The database user was not created properly (unlikely if you followed the instructions)
- 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.