[dfborn]

Hi. I recently moved to a centralized library using MySQL. We run Kodi on 2 macs and 1 windows 10 pc. Everything was working fine and then the macs quit starting kodi. Both freeze upon open on the kodi splash screen and have to be Force Quit. The windows pc with Kodi works fine.

If I rename the Kodi folder in application support, Kodi creates a new folder and starts fine. If I paste my old advanced settings folder in the new folder, Kodi hangs on startup again.

Not sure what's happening.

Here's a link to the logfile:
http://pastebin.com/tY9Ev7wC

Appreciate any help you can give.

[Rechi]

It seems you have installed Banned add-ons (wiki) installed, so you won't get any support here.

[dfborn]

It seems you have installed Banned add-ons (wiki) installed, so you won't get any support here.

My apologies. Honestly, I didn't know there was such a thing. I have removed them and can only assume they were banned for good reason. (Our kodi install initially came from a tech saavy friend and we have used it mostly for our own library).

I have updated the original post with a new log file after removing the old kodi folder.

[Rechi]

We need a Debug log (wiki). As you are saying Kodi doesn't start you must enable it the way it is described at Log_file/Advanced#Turn_on_debugging_using_a_file_.28advancedsettings.xml.29 (wiki).

[dfborn]

Here's the debug log: http://pastebin.com/A8qh9Yu3

This is using a completely new Kodi folder. The only thing I added was my advancedsettings.xml. Doing some troubleshooting, I found out that if I remove the section that points to the mySQL database, Kodi starts fine.

But, our machine running Windows 10 runs fine with the same file...

Thanks for the help.

[Waltman]

Here's the debug log: http://pastebin.com/A8qh9Yu3

This is using a completely new Kodi folder. The only thing I added was my advancedsettings.xml. Doing some troubleshooting, I found out that if I remove the section that points to the mySQL database, Kodi starts fine.

But, our machine running Windows 10 runs fine with the same file...

Thanks for the help.

1. Are you sure your paths and ports are pointing the right way? and is your user for mysql right ? i see a lot of xxx where i should expect an ip adres, port number or username. Or did you xxx.xxx.xxx it out yourself for the log ? see below
2. sources.xml and advanced setting.xml must be correct otherwise its pointing nowhere. see also http://kodi.wiki/view/MySQL
3. What device is running the mysql service ?

<videodatabase>
<type>mysql</type>
<host>xxx.xxx.xxx.xxx</host>
<port>xxxx</port>
<user>xxxx</user>
<pass>*****</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>xxx.xxx.xxx.xxx</host>
<port>xxxx</port>
<user>xxxx</user>
<pass>*****</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>

[dfborn]

Yes, I x-ed those out in the logfile before I posted it on pastebin. Didn't want that info out on the interwebs...

2 Kodi instances on different OSX computers were working fine with mySQL and this advancedsettings file. Then, they just stopped working.

The only change I can think of that I made that could have caused this is that I had been added all our sources (and updating them) through my Macbook. Then I added a source (that wasn't added on the Macbook) on our Windows machine. After that, neither of the macs would start kodi.

[Waltman]

Mabey something went wrong with the sources.xml file ? File rights or format.

And if you creatie a whole new sources.xml as plain text on the MAC and use that file in the Windows and mac machines ?

[dfborn]

Mabey something went wrong with the sources.xml file ? File rights or format.

And if you creatie a whole new sources.xml as plain text on the MAC and use that file in the Windows and mac machines ?

That didn't work. But removing the additions we made to my.ini regarding the query_cache lines as suggested here did the trick: http://forum.kodi.tv/showthread.php?tid=212806

That seems to cause this error: WARNING: DARWINOSX: underflow (0 vs 4096 bytes)

Not sure what's going on...

[Waltman]

Okay, so you fixed it !

I have the same error, as have many with a mysql database. Use millhouses texturecacache.db tool to smooth the database intead. See http://forum.kodi.tv/showthread.php?tid=158373