[SOLVED] Setting up MySQL - Printable Version +- Forum (http://forum.xbian.org) +-- Forum: Software (/forum-6.html) +--- Forum: Configuration (/forum-17.html) +--- Thread: [SOLVED] Setting up MySQL (/thread-2764.html) |
Setting up MySQL - Djawid Hnian - 20th Feb, 2015 08:01 AM Hi folks, So I recently bought the Pi 2 and I love it so far. After months of using OpenELEC on my previous old Pi B, I decided to give Xbian a shot now my Linux knowledge is a bit improved. I also want to setup a MySQL databse on the Pi 2 so all my devices with Kodi are in sync with their watch status and resuming a paused video from one location to another. I used the following command to install MySQL: Code: sudo apt-get install mysql-server After that I did the following steps to set it up: Code: sudo nano /etc/mysql/my.cnf Restarted the server with Code: sudo /etc/init.d/mysql restart The following commands after restart: Code: mysql -u root -p Code: CREATE USER 'kodi' IDENTIFIED BY 'kodi'; Code: GRANT ALL ON *.* TO 'kodi'; Code: \q Then I made the advancedsettings.xml. Here it is: http://pastebin.com/JSsM4pm7 I imported some movies and tvshows using NFS and the standard scrapers (The TVDB and The Movie Databse) I put the advancedsettings file in the right folder on my laptop running Windows 8.1. This is the log file I get: http://pastebin.com/3G27bFv6 Despite I don't see any errors in the log file, Kodi doesn't show my library which is on Xbian. I'm really lost. When I did the following on my Desktop running Linux Mint 17, it worked. So there must be a problem with Xbian. What's also is strange is that when I add the advancedsettings.xml on the right .kodi folder in Xbian and I scrape my Videos, then nothing happens. Kodi doesn't scrape anything. When I remove advancedsettings.xml from Xbian, I get my library back. I hope someone can help me to fix this. I would really appreciate it! RE: Setting up MySQL - Skywatch - 20th Feb, 2015 07:28 PM I can't help with your exact problem, but try comparing the files in .kodi to those in .xbmc for a start. It would be nice to remove *ALL* references to xbmc in the kodi releases to avoid any confusion, but I guess that this might take a little time, if it's being implemented at all. Skywatch. RE: Setting up MySQL - Djawid Hnian - 21st Feb, 2015 07:44 AM (20th Feb, 2015 07:28 PM)Skywatch Wrote: I can't help with your exact problem, but try comparing the files in .kodi to those in .xbmc for a start.Thanks for your reply mate, but I gave it up. I managed now to run the MySQL server on the Pi with OpenELEC and the LAMP addon. Didn't changed my advancedsettings.xml and everything works flawlessly. RE: Setting up MySQL - Djawid Hnian - 8th Mar, 2015 11:03 AM Solved it thanks to dev mk01. https://github.com/xbianonpi/xbian/issues/695#issuecomment-77661493 |