[zirophyz]

Hi guys,

Getting a little stuck with this one. Had to do some work on my server which meant that the MySQL server went down and was deleted. I have a backup of all the databases using mysqldump, and successfully restored it.

Turning my Rpi, OSMC, Kodi device back on, it seems that there's something up with the database. I have confirmed that I can connect to it, with the same details as is in advancedsettings.xml, using another PC on my network. However, in kodi when I go into the TV Shows or Movies library, the only item listed is simply "1".

Checking out kodi.log in ~/.kodi/temp looks like there is a connection error with the database, but some other lines look like everythings good...

http://pastebin.com/32zW5JW2

To me, looks like Kodi can't connect, or perhaps there is a permissions problem. Little bit of a mysql novice although I am very comfortable in working it out - but yeah, getting a little stuck, and a little frustrated ... any help would be really appreciated! As said before, from another PC I can connect, and can confirm I can browse tables in the Main_Video99 database.

Here's is my advancedsettings.xml as well...

http://pastebin.com/gwQeMiTk

Thanks!!

[zirophyz]

As a test, I installed mysql-client on the RPi and tested the connection. Seems to work okay for reads/queries but I haven't tried writing into any table ...

Here is the pastebin of the successful connection...

http://pastebin.com/5gFDwVhS

[Sam.Nazarko]

Maybe Kodi starts before the network is fully up.

Try enabling Wait for Network in My OSMC

[zirophyz]

Was a database issue that I've resolved. Something up with the new db for v16 - deleted that, and let Kodi upgrade from the old db version and now all is good.