Forum
[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
Changed bind-address = 127.0.0.1 to bind-address = 0.0.0.0

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.

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.
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