# Fixing database connections in a redudant gateway

**URL:** <https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523>\
**Category:** Ignition\
**Tags:** ignition81, database\
**Created:** [November 15, 2022, 1:05pm UTC](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523 "2022-11-15T13:05:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![L\_F](https://avatars.discourse-cdn.com/v4/letter/l/5f8ce5/32.png) [@L\_F](https://forum.inductiveautomation.com/u/L_F)\
**Post date:** [November 15, 2022, 1:05pm UTC](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523/1 "2022-11-15T13:05:16Z")

</div>

Ignition version: 8.1.22  
Database: MySQL

I need my redudant gateway on one server, `opc1`, to communicate a database on the server with my master gateway, `opc0`. I created a new user within MySQL specifically for Ignition and set the host of my connection string to the IP address of `opc0`. My redudant gateway is unable to reach the database on `opc0` because it's using `localhost` as the host and `root` as the user.

My redudant gateway isn't allowing me to make changes to the database connection URL. I tried restoring the redudant gateway with a backup of the master, but it isn't updating the connection URL. How can I update these parameters?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 15, 2022, 1:06pm UTC](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523/2 "2022-11-15T13:06:32Z")

</div>

You cannot. Backup servers get all of their configuration from the master, except for redundancy settings themselves.

Use a DNS name that resolves correctly in both hosts.

---

<div class="post-metadata">

**Author:** ![L\_F](https://avatars.discourse-cdn.com/v4/letter/l/5f8ce5/32.png) [@L\_F](https://forum.inductiveautomation.com/u/L_F)\
**Post date:** [November 15, 2022, 1:11pm UTC](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523/3 "2022-11-15T13:11:52Z")

</div>

Why does the DNS work in place of the IP? And if the configuration comes from the master, why have the changes I've already made not been reflected in my backup?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 15, 2022, 1:12pm UTC](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523/4 "2022-11-15T13:12:39Z")

</div>

Don't know. Tell your backup server to do a full resync.

---

<div class="post-metadata">

**Author:** ![L\_F](https://avatars.discourse-cdn.com/v4/letter/l/5f8ce5/32.png) [@L\_F](https://forum.inductiveautomation.com/u/L_F)\
**Post date:** [November 15, 2022, 1:18pm UTC](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523/5 "2022-11-15T13:18:44Z")

</div>

Forced resync has updated the settings in my database connection, thanks. Is there a way to schedule resyncs?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 15, 2022, 1:19pm UTC](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523/6 "2022-11-15T13:19:41Z")

</div>

They **should** be automatic. But I've seen them get bogged down. I'm not aware of any way to script them, short of peeking under IA's hood.