[evilscytheman]

Hello all

i want for several Kodi clients a central DB on my Raspberry Pi via MariaDB. But I'm getting these errors:

​

html:
2021-10-13 14:45:27.530 T:25420 ERROR <general>: Unable to open database: MyMusic82 [2002](Can't connect to MySQL server on '192.168.178.200' (10061))

2021-10-13 14:45:29.353 T:18996 INFO <general>: CIRServerSuite:rocess: failed to connect to irss, will keep retrying every 5 seconds

2021-10-13 14:31:13.989 T:14968 ERROR <general>: Unable to open database: MyMusic81 [2002](Can't connect to MySQL server on '192.168.178.200' (10061))

.

.

.

2021-10-13 14:47:11.015 T:25420 ERROR <general>: Unable to create new database

2021-10-13 14:47:13.049 T:25420 ERROR <general>: Unable to open database: MyVideos119 [2002](Can't connect to MySQL server on '192.168.178.200' (10061))

.

.

.

2021-10-13 14:48:44.367 T:25420 ERROR <general>: Unable to create new database

What I've done:
Installed MariaDB on Raspi. Created user via:
​

sql:
CREATE USER 'kodi'@'%' IDENTIFIED BY 'kodi';

GRANT ALL PRIVILEGES ON *.* TO 'kodi'@'%':

FLUSH PRIVILEGES;

​
User should have all rights and not only local, right?

I changed the my.cnf file in /etc/mysql/:

xml:
​

[client-server]

port=3306

​
So the port should work as well.


My advancedsettings.xml:

xml:
<advancedsettings>

    <musicdatabase> 

        <type>mysql</type> 

        <host>192.168.178.200</host> 

        <port>3306</port> 

        <user>kodi</user> 

        <pass>songoku</pass> 

    </musicdatabase> 

    <videodatabase>

        <type>mysql</type>

        <host>192.168.178.200</host>

        <port>3306</port>

        <user>kodi</user>

        <pass>songoku</pass>

    </videodatabase> 

    <videolibrary>

        <importwatchedstate>true</importwatchedstate>

        <importresumepoint>true</importresumepoint>

    </videolibrary>

</advancedsettings>

What did I do wrong? Any hints?

Thanks in advance. BR!

[ponkotsu]

Stab in the dark..
In my.cnf, did you comment out

Code:

bind-address = 127.0.0.1

or set it to 192.168.178.200 or 0.0.0.0?

[evilscytheman]

Stab in the dark..
In my.cnf, did you comment out

Code:

bind-address = 127.0.0.1

or set it to 192.168.178.200 or 0.0.0.0?

At the moment the complete my.cnf looks like this:

[evilscytheman]

Stab in the dark..
In my.cnf, did you comment out

Code:

bind-address = 127.0.0.1

or set it to 192.168.178.200 or 0.0.0.0?

At the moment the complete my.cnf looks like this:

This german tutorial did the trick.

There still was a binding to localhost in the " /etc/mysql/mariadb.conf.d/50-server.cnf"
the my.cnf seems not a complete overview.

Thanks all for the hints

[Klojum]

Thread marked solved.