Posts: 50
Joined: Nov 2014
Reputation:
0
I will try this this weekend. I'll let you know how it goes. Thank you!
Posts: 50
Joined: Nov 2014
Reputation:
0
2017-10-22, 08:13
(This post was last modified: 2017-10-22, 08:22 by rebeltaz21.)
I did as you directed. For some reason, I have to specify sudo to run the msyql commands on the new computer, although I do not on the old one. Maybe I set a root password there and I didn't here? Anyway... Kodi doesn't see the database. I was kind of confused about the bind command - do I bind it to the server that is running mysql or to the system that is accessing the database? I tried bind=192.168.1.15 - the server running mysql - first and when thath didn't work I tried 0.0.0.0. Kodi still doesn't see the database. I know that kodi can see that computer because it is serving the media files over the network and kodi is stay able to play playlists for songs located on that server....
What did I do wrong?
Posts: 50
Joined: Nov 2014
Reputation:
0
I have triple checked everything and I cannot figure this out. I even hooked the old server back up just to make sure and sure enough, kodi still sees that database. On the new server, there is a user kodi with kodi as password, the hostname and ip addresses are both the same as the old system, I imported the video and music databases, I can see them when logged into the server as kodi... but kodi will NOT see it!!!!!
/etc/mysql/my.cnf on the old system is identical to /etc/mysql/mysql.conf.d/mysqld.cnf on the new system, including the bind address being commented out in both. Is there another config file I'm missing maybe?
What as I missing!?
Posts: 14,213
Joined: Nov 2009
Reputation:
707
Klojum
Lost connection
Posts: 14,213
Are you using a hostname or an IP address to connect to your new database server?
In case of an IP address, does your new server have the same or a different IP address?
As always, supply the latest debug enabled kodi.log, as errors will appear in case Kodi cannot properly connect to a database.
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
Did you update kodi at some point?
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 50
Joined: Nov 2014
Reputation:
0
Not since I first began using the shared database setup.
Posts: 50
Joined: Nov 2014
Reputation:
0
I am looking at the MySQL server and there are two entries each for Movies and Music - MyMusic56 and MyMusic60 and MyVideos107 and MyVideos99 - if that helps any.
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
And which one has your data?
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 50
Joined: Nov 2014
Reputation:
0
Looks like MyVideos107 and MyMusic60.