Kodi Community Forum

Full Version: Can't get library working via MySQL
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I recently had to replace the hdd in my xbmc device. I decided to upgrade to Frodo. Previously (with Eden), I had the libraries sync'd with two xbmc devices. Now, I'm trying to re-setup everything and I cannot get it to work for the life of me.

I have Frodo installed -- no issues.
New library scraped locally. I plan on using this new library for the MySQL database, replacing the old one.
Sources are working -- I can watch TV Shows.
Library is not working.

I followed the wiki article and I exported the library as intructed. I then added the videodatabase information to the advancedsettings.xml file. I then went to scan for new content but nothing happens. I went to Videos > Files > TV Shows (One of my sources). I then right-clicked and selected Set Content. I set it to TV Shows and clicked OK. Went to scan for new content and NOTHING happens. I then right clicked on TV Shows again and went to Set Content. The information that I previously entered is no longer saved. I repeated this multiple times.

I thought that the previous database might have been the problem so I dropped the previous tables from mysql (regarding xbmc).
Still the same... No scanning, and set content not saving.

From there I searched for some answers on the forums. I looked in my log file and noticed "Cannot connect to MySQL". Searched for this on the forums. Came across a post suggesting to change the bind-address in /etc/mysql/my.cnf to 0.0.0.0 instead of 192.168.1.166 (my IP for my server). Did this and still no change.

I am puzzled. Here is the link to my debug log file: http://pastebin.com/CFiUYFHz

Could someone please help me get this working??

Here is my advancedsettings.xml file: http://pastebin.com/2qLFMXHk

Here is my sources.xml file: http://pastebin.com/48PNmvaM

NOTE: the xbmc user is in mysql and has privileges. See here:
mysql> show grants for xbmc;
+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD 'hash_for_xbmc_password' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
It seems the problem is only experienced on systems using an SSD drive. You need to edit the following file:

/etc/init/xbmcbuntu-wait.conf
Code:
change:
script
    status xbmcbuntu | grep -q "start/running" && exit 0
    start xbmcbuntu || true

to:
script
    status xbmcbuntu | grep -q "start/running" && exit 0
    sleep 10
    start xbmcbuntu || true