Solved: Setting up MySQL
|
20th Feb, 2015, 08:01 AM
Post: #1
|
|||
|
|||
Setting up MySQL
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! |
|||
20th Feb, 2015, 07:28 PM
Post: #2
|
|||
|
|||
RE: Setting up MySQL
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. |
|||
21st Feb, 2015, 07:44 AM
Post: #3
|
|||
|
|||
RE: Setting up MySQL
(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. |
|||
8th Mar, 2015, 11:03 AM
Post: #4
|
|||
|
|||
RE: Setting up MySQL | |||
« Next Oldest | Next Newest »
|