# Windows 11 Installation - Error in DB connectivity

**URL:** https://community.openboxes.com/t/windows-11-installation-error-in-db-connectivity/866
**Category:** troubleshooting
**Created:** [December 11, 2023, 10:11am UTC](https://community.openboxes.com/t/windows-11-installation-error-in-db-connectivity/866 "2023-12-11T10:11:34Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![jmiranda](https://community.openboxes.com/user_avatar/community.openboxes.com/jmiranda/32/199_2.png) [@jmiranda](https://community.openboxes.com/u/jmiranda)
#### Post date: [December 13, 2023, 5:57am UTC](https://community.openboxes.com/t/windows-11-installation-error-in-db-connectivity/866/3 "2023-12-13T05:57:57Z")

</div>

Hey @Mahesh_Thamilarasu

Thanks for the message, and apologies for the delay in responding.

```auto
Caused by: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)

```

I suspect this is caused by a common error running Tomcat on a Windows machine. I’m not sure if it’s a bug with Windows, Grails or Tomcat, but the file locations always end up getting mangled when the

Instead of a proper file location

```
c:\Users\username\.grails\openboxes-config.properties

```

the application looks for the file here

```
c:\.grails\openboxes-config.properties

```

essentially chopping off the USER\_HOME or TOMCAT\_HOME part of the file location path.

**First of all, we need to confirm that this is the problem**

Restart Tomcat and paste the first 100-200 lines of your stdout log file (sorry, I’ve forgotten what it’s called on Windows).

I’m looking for a snippet starting with “Using configuration locations …”. If you find it, paste it here to confirm.

**Then we need to fix the issue**

I think there are three options

1. Copy your openboxes-config.properties into one of the locations reported in the log file.
2. Figure out why USER\_HOME or TOMCAT\_HOME resolves to empty string
3. Set up your own file location (there’s a configuration property for this, but

I would recommend using option (1) for now since the other two will require some troubleshooting and I’m guessing you just want to see this working.

There are some other posts here that might be helpful. You can also just search in the Search box for “Using configuration locations” to see posts with the same issue.

- [OpenBoxes WAR file cannot start in tomcat 7 - #2 by jmiranda](https://community.openboxes.com/t/openboxes-war-file-cannot-start-in-tomcat-7/371/2)
- [Windows installation errors - #4 by jmiranda](https://community.openboxes.com/t/windows-installation-errors/392/4)
- [Errors while installing OpenBox on my GoDaddy Windows Server](https://community.openboxes.com/t/errors-while-installing-openbox-on-my-godaddy-windows-server/552)
- [NoClassDefFoundError during connection pool creation - #9 by jmiranda](https://community.openboxes.com/t/noclassdeffounderror-during-connection-pool-creation/622/9)

For option (3) you need to set one of the two command line arguments when starting Tomcat.

```auto
-Dopenboxes.config.location=<pathtofile>
-DOPENBOXES_CONFIG_LOCATION=<pathtofile>

```

In Ubuntu, I would create/edit the setenv.sh and pass this argument in via JAVA\_OPTS or CATALINA\_OPTS, but I have no idea where or how this would be set in Windows.

For reference, here’s the code in Config.groovy that adds these to our config file location candidates.

```auto
// Allow admin to override the config location using command line argument
configLocation = System.properties["${appName}.config.location"]
if (configLocation) {
    grails.config.locations << "file:" + configLocation
}

// Allow admin to override the config location using environment variable
configLocation = System.env["${appName.toString().toUpperCase()}_CONFIG_LOCATION"]
if (configLocation) {
    grails.config.locations << "file:" + configLocation
}

```

---

_[View the full topic](https://community.openboxes.com/t/windows-11-installation-error-in-db-connectivity/866)._