XBMC/KODI --> MySQL Plugin configuration issues ?

tcichowicz · 21. Januar 2015

I've got a few KODI clients throughout the house that are connecting to a Windows7 based installation of MySQL for the shared library feature of KODI.

It works PERECTLY! -- I've just discovered OMV and have installed it for many of the features that I have several PCs setup for to provide. I'm hoping to shutdown 3 PCs and run everything on my new OMV setup.

With that said, the MySQL task was the easiest to setup, and I've done it several times over the years, and it was always very simple -- no matter what OS I did it on it was basically the same, I've attached a sample of what I always did. I never had to do the Bind modification ... just the commandline entries... and it ALWAYS just worked. I did the same on my new OMV install but the clients just won't connect?

Has anyone had any luck getting the OMV MySQL server to host the video/music libraries for XMBC/KODI ?

Code

Ubuntu Linux:


$sudo apt-get install mysql-server (see also: https://help.ubuntu.com/10.04/serverguide/C/mysql.html )
Create a password when asked
To configure MySQL to listen for connections from network hosts, edit /etc/mysql/my.cnf and change the bind-address directive to the server's IP address:from: bind-address = 127.0.0.1
to: bind-address = 192.168.0.5
Note: Replace 192.168.0.5 with the appropriate address.
Note: To allow local and remote access try comment out bind-address using a hash(#) or use bind-address = 0.0.0.0


Restart your MySQL server. $sudo restart mysql
Get into the MySQL command line utility: $mysql -u root -p
Enter the following commands:Type in: CREATE USER 'kodi' IDENTIFIED BY 'kodi'; and press return
Type in: GRANT ALL ON *.* TO 'kodi'; and press return


Close out the command line tool with \q

Alles anzeigen

I did try the Bind modifications making the change in the OMV webinterface ... it seems to have FIXED my problem ...

davidh2k · 21. Januar 2015

Just set the bind address to 0.0.0.0.

Greetings
David

tcichowicz · 21. Januar 2015

Thanks ... I set the bind address to 192.168.2.170 which is the IP of my OMV ...

that seemed to make everything start working.

What is the advantage or disadvantage of each/other setting?

davidh2k · 21. Januar 2015

It's just easier to say use 0.0.0.0... And it will work all the time.

Greetings
David

sieben · 6. März 2016

Hey, I don't want to open a new thread as I am having the same issue right now.

I'm trying to set up the kodi DB on my banana pi and run into following error, when trying to connect to the MySQL DB.
The DB itself is working well, but is not able to be connected via the IP.
The Bind address is set to 0.0.0.0 on the OMV WebGUI and this value is also represented in the /etc/mysql/conf.d/openmediavault-mysql.cnf file.
Port is default 3306.

But Kodi returns an error not being able to connect to the mysql database on my local IP 192.168.178.100.
Even trying to connect from the banana pi itself is only working with no host option, or the localhost IP.

Code

# working with localhost or 127.0.0.1 IP


root@bananas:~# mysqladmin -ukodi -pkodi -h127.0.0.1 version
mysqladmin  Ver 8.42 Distrib 5.5.47, for debian-linux-gnu on armv7l
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Server version          5.5.47-0+deb8u1
Protocol version        10
Connection              127.0.0.1 via TCP/IP
TCP port                3306
Uptime:                 3 days 11 hours 50 min 47 sec


Threads: 7  Questions: 493292  Slow queries: 0  Opens: 246  Flush tables: 1  Open tables: 239  Queries per second avg: 1.634


# NOT working with IP


root@bananas:~# mysqladmin -ukodi -pkodi -h192.168.178.100 version
mysqladmin: connect to server at '192.168.178.100' failed
error: 'Can't connect to MySQL server on '192.168.178.100' (111)'
Check that mysqld is running on 192.168.178.100 and that the port is 3306.
You can check this by doing 'telnet 192.168.178.100 3306'
root@bananas:~#

Alles anzeigen

Does someone have a clue what the issue might be?
Thanks a lot.

davidh2k · 6. März 2016

telnet 192.168.178.100 3306

Does it connect?

Greetings
David

sieben · 6. März 2016

Unfortunalety not:

Code

root@bananas:~# telnet 192.168.178.100 3306
Trying 192.168.178.100...
telnet: Unable to connect to remote host: Connection refused

And mysqld is running as expected: (isn't it?)

Code

Proto Recv-Q Send-Q Local Address           Foreign Address         State       User       Inode       PID/Program name
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      114        378911      4917/mysqld

ryecoaaron · 6. März 2016

Did you try resetting the mysql password?

sieben · 6. März 2016

[SOLVED]

I tried resetting the mysql password via the OMV WebGui, but didn't change anything.
Then I found out that stopping the mysql server ends up in an error and mysql going into failed-state.

Furthermore I found a solution regarding this issue:
Resetting the debian-sys-maint user password over the MySQL Web Interface, with the password stored in /etc/mysql/debian.cnf

No idea how this password may got corrupted....

Anyway i can access the MySQL Server with the IP now. Everything fixed.

Thanks to you!

Jetzt mitmachen!