Solved: Setting up MySQL - Printable Version

[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