(C:\\Program Files\\nodejs\\node\_modules\\npm\\node\_modules\\node-gyp\\lib\\find-python.js:221:16)
> gyp ERR! stack at PythonFinder.execFileCallback (C:\\Program Files\\nodejs\\node\_modules\\npm\\node\_modules\\node-gyp\\lib\\find-python.js:267:16)
> gyp ERR! stack at exithandler (child\_process.js:302:5)
> gyp ERR! stack at ChildProcess.errorhandler (child\_process.js:314:5)
> gyp ERR! stack at ChildProcess.emit (events.js:209:13)
> gyp ERR! stack at Process.ChildProcess.\_handle.onexit (internal/child\_process.js:270:12)
> gyp ERR! stack at onErrorNT (internal/child\_process.js:456:16)
> gyp ERR! stack at processTicksAndRejections (internal/process/task\_queues.js:80:21)
> gyp ERR! System Windows\_NT 10.0.18362
> gyp ERR! command "C:\\\\Program Files\\\\nodejs\\\\node.exe" "C:\\\\Program Files\\\\nodejs\\\\node\_modules\\\\npm\\\\node\_modules\\\\node-gyp\\\\bin\\\\node-gyp.js" "rebuild"
> gyp ERR! cwd C:\\Users\\81810\\AppData\\Roaming\\npm\\node\_modules\\ffi\\node\_modules\\ref
> gyp ERR! node -v v12.10.0
> gyp ERR! node-gyp -v v5.0.3
> gyp ERR! not ok
> npm ERR! code ELIFECYCLE
> npm ERR! errno 1
> npm ERR! ref@1.3.5 install: \`node-gyp rebuild\`
> npm ERR! Exit status 1
> npm ERR!
> npm ERR! Failed at the ref@1.3.5 install script.
> npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
>
> npm ERR! A complete log of this run can be found in:
> npm ERR! C:\\Users\\81810\\AppData\\Roaming\\npm-cache\\\_logs\\2019-11-24T23\_02\_43\_511Z-debug.log
> PS C:\\Windows\\system32\>
> \`\`\`
>
> \
---
### Author:  [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [May 19, 2022, 4:42pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/5 "2022-05-19T16:42:06Z")
> May you share if we are able to debug openboxes in Apache Netbeans?
I forgot to respond to this.
I have been using IntelliJ Utimate for the better part of 10 years so I don’t have much experience with Netbeans. The last time I tried to use Netbeans was many many years ago (Netbeans 8.2) and it seemed to work pretty well. I just fired it up and it looks fine to me. Newer versions of Netbeans will probably support newer versions of Grails so I’m not sure how it’ll handle an older Grails project like ours.
As for whether it plays nice with npm and node, I don’t really know. I generally run servers in dev mode (`grails run-app` (for running the main webapp) and `npm run watch` (for editing React resources) in terminal windows outside of the IDE.
---
### Author:  [@chandara](https://community.openboxes.com/u/chandara)
#### Post date: [May 23, 2022, 3:37pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/6 "2022-05-23T15:37:49Z")
Thank you @jmiranda
I tried to install
node v14.17.5
npm v6.14.14
last one to install compatible sass version
npm install node-sass@4.14 --save-dev --unsafe-perm node-sass
There is no more error but I cannot run the app.
This screenshot, it is selected index.html file.
Thanks,
Mick
---
### Author:  [@chandara](https://community.openboxes.com/u/chandara)
#### Post date: [May 23, 2022, 3:39pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/7 "2022-05-23T15:39:18Z")
Here is my run test result:
/////////
PASS src/js/tests/form-elements/ButtonField.test.jsx
ButtonField component is correctly rendering
✓ string label (10ms)
✓ component label (1ms)
PASS src/js/tests/api-client/apiClient.test.js
apiClient
✓ returns 200 (19ms)
✓ returns 400 (3ms)
✓ returns 401 (3ms)
✓ returns 403 (1ms)
✓ returns 404 (2ms)
✓ returns 500 (2ms)
PASS src/js/tests/form-elements/WizardSteps.test.jsx
✓ WizardSteps renders correctly (3ms)
Test Suites: 6 skipped, 3 passed, 3 of 9 total
Tests: 9 skipped, 9 passed, 18 total
Snapshots: 3 passed, 3 total
Time: 4.883s
Ran all test suites.
Done.
///////////
Thanks,
Mick
---
### Author:  [@chandara](https://community.openboxes.com/u/chandara)
#### Post date: [May 23, 2022, 4:39pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/8 "2022-05-23T16:39:39Z")
I tried to SDK and grails but cannot resolve dependencies as error below:
//////
(base) macbookpro@MacBookPro openboxes-0.8.16-hotfix3 % grails compile
Java HotSpot™ 64-Bit Server VM warning: ignoring option MaxPermSize=192m; support was removed in 8.0
Welcome to Grails 1.3.9 - [http://grails.org/](http://grails.org/)
Licensed under Apache Standard License 2.0
Grails home is set to: /Users/macbookpro/.sdkman/candidates/grails/current
Base Directory: /Users/macbookpro/Downloads/openboxes-0.8.16-hotfix3
Resolving dependencies…
:: problems summary ::
:::: WARNINGS
module not found: org.jboss.tattletale#tattletale-ant;1.2.0.Beta2
```
==== grailsPlugins: tried
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
/Users/macbookpro/Downloads/openboxes-0.8.16-hotfix3/lib/tattletale-ant-1.2.0.Beta2.jar
==== grailsHome: tried
/Users/macbookpro/.sdkman/candidates/grails/current/lib/tattletale-ant-1.2.0.Beta2.xml
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
/Users/macbookpro/.sdkman/candidates/grails/current/lib/tattletale-ant-1.2.0.Beta2.jar
==== grailsHome: tried
/Users/macbookpro/.sdkman/candidates/grails/current/dist/tattletale-ant-1.2.0.Beta2.xml
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
/Users/macbookpro/.sdkman/candidates/grails/current/dist/tattletale-ant-1.2.0.Beta2.jar
==== grailsHome: tried
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
/Users/macbookpro/.sdkman/candidates/grails/current/plugins/grails-tattletale-ant-1.2.0.Beta2.jar
==== grailsCentral: tried
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
http://plugins.grails.org/grails-tattletale-ant/tags/RELEASE_1_2_0_Beta2/grails-tattletale-ant-1.2.0.Beta2.jar
==== localMavenResolver: tried
/Users/macbookpro/.m2/repository/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.pom
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
/Users/macbookpro/.m2/repository/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.jar
==== mavenCentral: tried
http://repo1.maven.org/maven2/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.pom
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
http://repo1.maven.org/maven2/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.jar
==== http://repo.grails.org/grails/plugins-releases/: tried
http://repo.grails.org/grails/plugins-releases/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.pom
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
http://repo.grails.org/grails/plugins-releases/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.jar
==== http://repo.grails.org/grails/plugins/: tried
http://repo.grails.org/grails/plugins/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.pom
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
http://repo.grails.org/grails/plugins/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.jar
==== http://repo.grails.org/grails/core/: tried
http://repo.grails.org/grails/core/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.pom
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
http://repo.grails.org/grails/core/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.jar
==== http://oss.sonatype.org/content/repositories/snapshots/: tried
http://oss.sonatype.org/content/repositories/snapshots/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.pom
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
http://oss.sonatype.org/content/repositories/snapshots/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.jar
==== localMavenResolver: tried
/Users/macbookpro/.m2/repository/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.pom
-- artifact org.jboss.tattletale#tattletale-ant;1.2.0.Beta2!tattletale-ant.jar:
/Users/macbookpro/.m2/repository/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.jar
::::::::::::::::::::::::::::::::::::::::::::::
:: UNRESOLVED DEPENDENCIES ::
::::::::::::::::::::::::::::::::::::::::::::::
:: org.jboss.tattletale#tattletale-ant;1.2.0.Beta2: not found
::::::::::::::::::::::::::::::::::::::::::::::
```
:::: ERRORS
SERVER ERROR: HTTPS Required url=http://repo1.maven.org/maven2/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.pom
```
SERVER ERROR: HTTPS Required url=http://repo1.maven.org/maven2/org/jboss/tattletale/tattletale-ant/1.2.0.Beta2/tattletale-ant-1.2.0.Beta2.jar
```
///////
Thanks,
Mick
---
### Author:  [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [May 24, 2022, 4:43pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/9 "2022-05-24T16:43:48Z")
> [@chandara](#):
>
> grails compile
> Java HotSpot™ 64-Bit Server VM warning: ignoring option MaxPermSize=192m; support was removed in 8.0
Make sure you’re using Java 7. We recommend using Zulu.
> **[Azul Downloads](https://www.azul.com/downloads/?version=java-7-lts&os=macos&package=jdk)**
>
> Click here to download the Azul Zulu Builds of OpenJDK for Java 8, 11, 17, 21, 23 for Linux, Windows and macOS. Also download Azul Platform Prime.
As for the dependency error …
```auto
SERVER ERROR: HTTPS Required
```
… we’ve fixed that in the most recent version. 0.8.16-hotfix3 is at least a few months old, so I would recommend using the develop branch.
I believe the fix was to add an insecure Maven Repo to BuildConfig.groovy.
```auto
repositories {
//grailsRepo "http://grails.org/plugins"
grailsPlugins()
grailsHome()
grailsCentral()
mavenLocal()
mavenCentral()
mavenRepo "https://repo.grails.org/grails/plugins-releases/"
mavenRepo "https://repo.grails.org/grails/plugins/"
mavenRepo "https://repo.grails.org/grails/core/"
mavenRepo "https://oss.sonatype.org/content/repositories/snapshots/"
mavenRepo "http://insecure.repo1.maven.org/maven2"
}
```
---
### Author:  [@chandara](https://community.openboxes.com/u/chandara)
#### Post date: [May 26, 2022, 3:26pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/10 "2022-05-26T15:26:59Z")
Thank you @jmiranda.
After got notified new version so I used a new one instead,
and tried to following each configuration step.
> grails upgrade
> I got below errors.
Also I used same version node and npm Github instruction.
//////
(base) macbookpro@MacBookPro openboxes-0.8.17-hotfix4 % grails upgrade
Java HotSpot™ 64-Bit Server VM warning: ignoring option MaxPermSize=192m; support was removed in 8.0
Welcome to Grails 1.3.9 - [http://grails.org/](http://grails.org/)
Licensed under Apache Standard License 2.0
Grails home is set to: /Users/macbookpro/.sdkman/candidates/grails/current
Base Directory: /Users/macbookpro/Downloads/openboxes-0.8.17-hotfix4
Resolving dependencies…
Dependencies resolved in 1002ms.
Running script /Users/macbookpro/.sdkman/candidates/grails/current/scripts/Upgrade.groovy
Environment set to development
```
WARNING: This target will upgrade an older Grails application to 1.3.9.
Are you sure you want to continue?
(y, n)
```
y
[delete] Deleting directory /Users/macbookpro/.grails/1.3.9/projects/openboxes-0.8.17-hotfix4/resources
[copy] Copying 1 file to /Users/macbookpro/Downloads/openboxes-0.8.17-hotfix4/web-app/WEB-INF
[copy] Copying 1 file to /Users/macbookpro/Downloads/openboxes-0.8.17-hotfix4/web-app/WEB-INF
[copy] Copying 4 files to /Users/macbookpro/Downloads/openboxes-0.8.17-hotfix4/web-app/WEB-INF/tld
Installing zip /Users/macbookpro/.sdkman/candidates/grails/current/plugins/grails-hibernate-1.3.9.zip… …
[delete] Deleting directory /Users/macbookpro/.grails/1.3.9/projects/openboxes-0.8.17-hotfix4/plugins/hibernate-1.3.9
[mkdir] Created dir: /Users/macbookpro/.grails/1.3.9/projects/openboxes-0.8.17-hotfix4/plugins/hibernate-1.3.9
[unzip] Expanding: /Users/macbookpro/.sdkman/candidates/grails/current/plugins/grails-hibernate-1.3.9.zip into /Users/macbookpro/.grails/1.3.9/projects/openboxes-0.8.17-hotfix4/plugins/hibernate-1.3.9
Installed plugin hibernate-1.3.9 to location /Users/macbookpro/.grails/1.3.9/projects/openboxes-0.8.17-hotfix4/plugins/hibernate-1.3.9. …
java.lang.NullPointerException: Cannot invoke method getAt() on null object
at \_PluginDependencies\_groovy$\_run\_closure21\_closure45.doCall(\_PluginDependencies\_groovy:477)
at \_PluginDependencies\_groovy$\_run\_closure21\_closure45.doCall(\_PluginDependencies\_groovy)
at \_PluginDependencies\_groovy.withPluginInstall(\_PluginDependencies\_groovy:500)
at \_PluginDependencies\_groovy.this$4$withPluginInstall(\_PluginDependencies\_groovy)
at \_PluginDependencies\_groovy$\_run\_closure21.doCall(\_PluginDependencies\_groovy:475)
at \_PluginDependencies\_groovy$\_run\_closure21.call(\_PluginDependencies\_groovy)
at \_GrailsPlugins\_groovy$\_run\_closure3.doCall(\_GrailsPlugins\_groovy:98)
at Upgrade$\_run\_closure1.doCall(Upgrade.groovy:208)
at Upgrade$\_run\_closure2.doCall(Upgrade.groovy:216)
at gant.Gant$\_dispatch\_closure5.doCall(Gant.groovy:381)
at gant.Gant$\_dispatch\_closure7.doCall(Gant.groovy:415)
at gant.Gant$\_dispatch\_closure7.doCall(Gant.groovy)
at gant.Gant.withBuildListeners(Gant.groovy:427)
at gant.Gant.this$2$withBuildListeners(Gant.groovy)
at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)
at gant.Gant.dispatch(Gant.groovy:415)
at gant.Gant.this$2$dispatch(Gant.groovy)
at gant.Gant.invokeMethod(Gant.groovy)
at gant.Gant.executeTargets(Gant.groovy:590)
at gant.Gant.executeTargets(Gant.groovy:589)
Error installing plugin: Cannot invoke method getAt() on null object: Cannot invoke method getAt() on null object
(base) macbookpro@MacBookPro openboxes-0.8.17-hotfix4 %
//////////
Thanks,
Chandara
---
### Author:  [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [May 26, 2022, 4:14pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/11 "2022-05-26T16:14:44Z")
> [@chandara](#):
>
> Java HotSpot™ 64-Bit Server VM warning: ignoring option MaxPermSize=192m; support was removed in 8.0
This is telling me that you’re running with Java 8. You need to use Java 7.
---
### Author:  [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [May 26, 2022, 4:15pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/12 "2022-05-26T16:15:46Z")
> [@chandara](#):
>
> After got notified new version so I used a new one instead,
> and tried to following each configuration step.
Just checkout the develop branch for the latest changes.
---
### Author:  [@chandara](https://community.openboxes.com/u/chandara)
#### Post date: [May 27, 2022, 2:40pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/13 "2022-05-27T14:40:46Z")
Thank @jmiranda
I still got same error after change to use SDK 7.
Thanks,
Chandara
---
### Author:  [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [May 27, 2022, 5:07pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/14 "2022-05-27T17:07:14Z")
The IDE setting is only applicable if you’re running Grails from within the IDE. Since you’re running `grails run-app` from the command line you need to tell your terminal (bash) to use Java 7.
Just to confirm that your system is trying to use Java 8, execute the following command from your terminal and post the output here.
```auto
java -version
```
On Ubuntu, I usually have to do two things
1. Configure the default JVM
```auto
$ sudo update-alternatives --config java
There are 5 choices for the alternative java (providing /usr/bin/java).
Selection Path Priority Status
------------------------------------------------------------
0 /usr/lib/jvm/java-11-openjdk-amd64/bin/java 1111 auto mode
1 /usr/lib/jvm/java-11-openjdk-amd64/bin/java 1111 manual mode
2 /usr/lib/jvm/java-7-openjdk-amd64/jre/bin/java 1071 manual mode
3 /usr/lib/jvm/java-7-oracle/jre/bin/java 1073 manual mode
* 4 /usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java 1081 manual mode
5 /usr/lib/jvm/java-9-openjdk-amd64/bin/java 1091 manual mode
Press to keep the current choice[*], or type selection number: 2
update-alternatives: using /usr/lib/jvm/java-7-openjdk-amd64/jre/bin/java to provide /usr/bin/java (java) in manual mode
```
1. Set the JAVA\_HOME environment property in my .bashrc
```auto
export JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64
```
I don’t know exactly what you need to do on Mac, but here’s a resource to help you figure it out.
>
You’ll know you did it right when you see something like this
```auto
$ java -version
Picked up JAVA_TOOL_OPTIONS: -Dhttps.protocols=TLSv1.2
java version "1.7.0_95"
OpenJDK Runtime Environment (IcedTea 2.6.4) (7u95-2.6.4-3)
OpenJDK 64-Bit Server VM (build 24.95-b01, mixed mode)
``
```
---
### Author:  [@chandara](https://community.openboxes.com/u/chandara)
#### Post date: [May 27, 2022, 6:16pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/15 "2022-05-27T18:16:53Z")
Thank you @jmiranda
It is seem working now.
> I used these two command
> /usr/libexec/java\_home -V
> export JAVA\_HOME=`/usr/libexec/java\_home -v 1.7
It is running now. only fixing issue cannot connect to mySQL database.
Thanks,
Chandara
---
### Author:  [@chandara](https://community.openboxes.com/u/chandara)
#### Post date: [May 27, 2022, 6:30pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/16 "2022-05-27T18:30:58Z")
@jmiranda Im reaching the last step.
What am I missing for the error below?
Here is my connectionstring:
////////
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at sun.reflect.GeneratedConstructorAccessor87.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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.(ConnectionImpl.java:778)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor84.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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: Unknown system variable ‘storage\_engine’
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.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1552)
at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2607)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1480)
at com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5030)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3202)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2068)
… 18 more
2022-05-28 01:26:58,742 [C3P0PooledConnectionPoolManager[identityToken-\>1hge160ap1veldcsvyjli|3af7ee3e]-HelperThread-#1] WARN resourcepool.BasicResourcePool - Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@5edd8648 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2022-05-28 01:26:58,838 [main] ERROR context.GrailsContextLoader - Error executing bootstraps: 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!
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 org.grails.tomcat.InlineExplodedTomcatServer.doStart(InlineExplodedTomcatServer.groovy:112)
at org.grails.tomcat.InlineExplodedTomcatServer$doStart.callCurrent(Unknown Source)
at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:97)
at grails.web.container.EmbeddableServer$start.call(Unknown Source)
at \_GrailsRun\_groovy$\_run\_closure5\_closure12.doCall(\_GrailsRun\_groovy:158)
at \_GrailsRun\_groovy$\_run\_closure5\_closure12.doCall(\_GrailsRun\_groovy)
at \_GrailsSettings\_groovy$\_run\_closure10.doCall(\_GrailsSettings\_groovy:280)
at \_GrailsSettings\_groovy$\_run\_closure10.call(\_GrailsSettings\_groovy)
at \_GrailsRun\_groovy$\_run\_closure5.doCall(\_GrailsRun\_groovy:149)
at \_GrailsRun\_groovy$\_run\_closure5.call(\_GrailsRun\_groovy)
at \_GrailsRun\_groovy.runInline(\_GrailsRun\_groovy:116)
at \_GrailsRun\_groovy.this$4$runInline(\_GrailsRun\_groovy)
at \_GrailsRun\_groovy$\_run\_closure1.doCall(\_GrailsRun\_groovy:59)
at RunApp$\_run\_closure1.doCall(RunApp.groovy:33)
at gant.Gant$\_dispatch\_closure5.doCall(Gant.groovy:381)
at gant.Gant$\_dispatch\_closure7.doCall(Gant.groovy:415)
at gant.Gant$\_dispatch\_closure7.doCall(Gant.groovy)
at gant.Gant.withBuildListeners(Gant.groovy:427)
at gant.Gant.this$2$withBuildListeners(Gant.groovy)
at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)
at gant.Gant.dispatch(Gant.groovy:415)
at gant.Gant.this$2$dispatch(Gant.groovy)
at gant.Gant.invokeMethod(Gant.groovy)
at gant.Gant.executeTargets(Gant.groovy:590)
at gant.Gant.executeTargets(Gant.groovy:589)
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!
… 25 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!
… 25 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!
… 25 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!
… 25 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!
… 25 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)
… 25 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)
… 26 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.(ConnectionImpl.java:778)
at com.mysql.jdbc.JDBC4Connection.(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: java.sql.SQLException: Unknown system variable ‘storage\_engine’
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.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1552)
at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2607)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1480)
at com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5030)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3202)
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2068)
… 15 more
---
### Author:  [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [May 27, 2022, 6:41pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/17 "2022-05-27T18:41:48Z")
Set the database configuration in openboxes-config.properties.
You will need to create the file if you haven’t already done so.
See the README for instructions
> **[GitHub - openboxes/openboxes: OpenBoxes is a supply chain management system...](https://github.com/openboxes/openboxes#5-create-openboxes-configuration-file)**
>
> OpenBoxes is a supply chain management system designed to manage inventory and track stock movements for healthcare facilities. - GitHub - openboxes/openboxes: OpenBoxes is a supply chain managemen...
---
### Author:  [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [May 27, 2022, 6:45pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/18 "2022-05-27T18:45:30Z")
Once it does connect to the database and you can see that the application is running through database migrations please be patient. This process can take a long time especially if you haven’t followed the instructions carefully (hint: make to increase heap size and permgen).
---
### Author:  [@chandara](https://community.openboxes.com/u/chandara)
#### Post date: [May 28, 2022, 4:32am UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/19 "2022-05-28T04:32:51Z")
Thank you @jmiranda
I created in this location. is it a correct place?
Thanks,
Chandara
---
### Author:  [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [May 28, 2022, 12:18pm UTC](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554/20 "2022-05-28T12:18:50Z")
No it’ should be created under your user home directory. On A Mac that would be something like
```auto
/Users/username/.grails
```
If you encounter any more issues send me the full output from the grails run-app command.
[Next page](https://community.openboxes.com/t/how-to-run-openboxes-in-apache-netbeans/554.md?page=2)