Use externally hosted MariaDB (on Home Assistant)

[lits101]

Is it possible to configure the docker-compose.yaml to use an externally hosted database. I have MariaDB running as an add-on in Home Assistant, and I host a lot of things on there because it's backed up regularly and then backed up to Google Drive automatically.

I've specified environment variables:
- MYSQL_USER=teslalogger
- MYSQL_PASSWORD=xxxxxx
- MYSQL_DATABASE=teslalogger
- MYSQL_HOST=192.168.20.x

This doesn't seem to have any effect, the main teslalogger container is still trying to access the 'database' container, which I've commented out.

[bassmaster187]

copy App.config in Teslalogger.exe folder and rename it to Teslalogger.exe.config
https://github.com/bassmaster187/TeslaLogger/blob/master/TeslaLogger/App.config

There is a tag called DBConnectionstring you can use to connect to a different database.

Something like that should work:

...
<setting name="DBConnectionstring" serializeAs="String">
        <value>Server=192.168.20.x;Database=teslalogger;Uid=root;Password=teslalogger;CharSet=utf8mb4;</value>
      </setting>
....

[lits101]

Ah yes, I see the setting in the file. I've specified my variables and restarted the container but it's still attempting to connect to the default database.

[bassmaster187]

it must work, because I'm using different databases for testing and developing. Make sure the name is:
TeslaLogger.exe.config
It is case sensitive! Make sure you didn't forget to close tags or have any other syntax errors in your settings. There are also some limitations for special characters for name / password. Make sure you're using just letters and numbers and no special characters...

[lits101]

I've copied the TeslaLogger/App.config file to TeslaLogger/TeslaLogger.exe.config.

-rw-r--r--  1 pi   pi   5.0K May  1 07:27 App.config
...
-rw-r--r--  1 pi   pi   5.0K May  1 08:33 TeslaLogger.exe.config

Here's the codeblock from my new file TeslaLogger/TeslaLogger.exe.config:

      <setting name="DBConnectionstring" serializeAs="String">
        <value>Server=192.168.20.246;Database=teslalogger;Uid=teslalogger;Password=xxsuitablepasswordxx;CharSet=utf8mb4;</value>
      </setting>

I've restarted the container stack. No effect.

The log still shows:
DBConnectionstring: Server=database;Database=teslalogger;Uid=root;Password=teslalogger;CharSet=utf8mb4;