2013-08-30, 18:31
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)
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)