I can not get the hang on using an external db for osmc.
I tried to follow mostly this, but there is no new DBs getting created in Maria
and later from here
I also tried removing the hashtag that the first instruction told me to add, #bind-address = 0.0.0.0
And finally I tried with port 3307 in advancedsettings and with both port 3306 and 3307 in the My OSMC menu.
No luck.
For a long time there didn’t show up anything in Maria.
Finally at some point databases was added, but as far as I can tell there is no info in them.
Ok.
Much confusion about the ports in the guides online. But great that you could help me with that.
So. Database user kodi (which has complete privileges) fails to login?
How do I proceed? Can I check with ssh somehow how to log in?
Is the problem with mariaDB and synology or with osmc configuration?
With you using port 3307, you are getting Access Denied, so you are able to talk to the MariaDB.
With port 3306 you are getting Connection Refused, so that tells us that Maria is indeed using port 3307.
So now you just need to check the MariaDB permissions for the Kodi user. Maria user permissions can be set so that a user can only connected to the database from a specific IP, range of IPs, or all IPs. If you don’t have port 3307 forwarded, then I’d just allow the kodi user to connect from any IP.
If you want to check from ssh, you need to install the maria client:
sudo apt install mariadb-client
You can then try to connect:
mysql -h 192.168.86.205 -P3307 -ukodi -p
(That’s not a typo the command is mysql, not maria)
(the !! are back in the password because synology wont accept passwords without special signs, but I see no reason that should be the problem)
But I still dont get a database when I restart the vero4k+
It is however creating/recreating the MyVideos116 database with the current settings, but empty