I’m stuck and would appreciate any help you can give. I have installed MariaDB on a remote Rpi3B+. I don’t get a connection error (I did, but fixed that) but now I get an error on Recorder. I have gone through the instructions on Recorder and have ensured I have the extra files and the correct syntax. Here is the error from my log:
ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: invalid literal for int() with base 10: '' (retrying in 3 seconds)
I replaced the database to make sure it was fresh, I granted complete permissions to the user and have checked the credentials - they work fine. I have searched high and low for what may be the problem, but only one other topic was similar and their solution was to delete and replace the database.
Has anyone else added a MaraDB through a remote server and successfully connected with Recorder? How did you do it?
Note: This is not docker. My HA Core is current, running on a RPi4B and the MariaDB is running on a RPi3B+. They are on the same SSID too.