{"id":360,"date":"2014-09-16T22:01:42","date_gmt":"2014-09-17T03:01:42","guid":{"rendered":"http:\/\/bourbonnaisservices.com\/blog\/?p=360"},"modified":"2014-09-17T20:29:21","modified_gmt":"2014-09-18T01:29:21","slug":"adding-mysql-server-in-freenas-for-xbmckodi","status":"publish","type":"post","link":"https:\/\/bourbonnaisservices.com\/blog\/2014\/09\/adding-mysql-server-in-freenas-for-xbmckodi\/","title":{"rendered":"Adding MySQL Server in FreeNAS for XBMC\/KODI"},"content":{"rendered":"

This is the setup I have used on FreeNAS 9.2.1.7 to setup a MySQL server to function for XBMC soon to be KODI.<\/p>\n

Here we go!<\/p>\n

Step 1. We want to create a Jail within the FreeNAS webGUI.<\/p>\n

– Jails –> Add Jails<\/p>\n

\"Freenas\"<\/a><\/p>\n

The 3 highlighted areas are the only things that need to be addressed.
\n1. Naming the jail, in this case MySQL.
\n2. Make sure you pick standard from the drop down list.
\n3. Pick an IP address that will correspond to the service.<\/p>\n

 <\/p>\n

Step 2. Logging via SSH to FreeNAS, I currently use Putty (http:\/\/www.chiark.greenend.org.uk\/~sgtatham\/putty\/download.html<\/a>)<\/p>\n

Here we are going to install mysql and nano (a text editor), and get the service started.<\/p>\n

jls\u00a0<\/code><\/p>\n

This will give you the ID of the newly created jail<\/p>\n

jexec ID csh<\/code><\/p>\n

Where ID is the number of your jail<\/p>\n

pkg install mysql55-server<\/code>
\n pkg install nano<\/code><\/p>\n

Installing both MySQL and Nano<\/p>\n

Now let’s enable MySQL in rc.conf<\/p>\n

nano \/etc\/rc.conf<\/code>
\n mysql_enable=\"YES\"<\/code><\/p>\n

Save and exit the file<\/p>\n

service mysql-server start<\/code>
\n mysql_secure_installation<\/code><\/p>\n

This will start the service and secure the installation of mysql<\/p>\n

Step 3. Creating a user with access for XBMC \/ KODI<\/p>\n

mysql -u root -p<\/code>
\n GRANT USAGE ON *.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';<\/code>
\nflush privileges;<\/code><\/p>\n

Now here is the part where we give the user access to create and modify any database needed by XBMC \/ KODI<\/p>\n

INSERT INTO `mysql`.`db` (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`) VALUES ('%', '%MyVideo%', 'xbmc', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');<\/code><\/p>\n

INSERT INTO `mysql`.`db` (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`) VALUES ('%', '%MyMusic%', 'xbmc', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');<\/code><\/p>\n

flush privileges;<\/code><\/p>\n

Step 4. Setting up XBMC \/ KODI to use the new database.
\nSimply open your advancedsetting.xml located in the userdata folder of xbmc \/ kodi<\/p>\n

And enter the following:<\/p>\n

<advancedsettings>
\n<videodatabase>
\n<type>mysql<\/type>
\n<host>192.168.1.200<\/host><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<port>3306<\/port>
\n<user>xbmc<\/user>
\n<pass>xbmc<\/pass>
\n<\/videodatabase><\/p>\n

<musicdatabase>
\n<type>mysql<\/type>
\n<host>192.168.1.200<\/host>
\n<port>3306<\/port>
\n<user>xbmc<\/user>
\n<pass>xbmc<\/pass>
\n<\/musicdatabase><\/p>\n

<videolibrary>
\n<importwatchedstate>true<\/importwatchedstate>
\n<\/videolibrary>
\n<\/advancedsettings><\/p>\n

Just change the IP and save the changes, now reboot your xbmc \/ kodi device or restart the software.<\/p>\n

Now you should be ready to start adding content with a centralized databse on FreeNAS using MySQL.<\/p>\n

Cheers!<\/p>\n","protected":false},"excerpt":{"rendered":"

This is the setup I have used on FreeNAS 9.2.1.7 to setup a MySQL server to function for XBMC soon to be KODI. Here we go! Step 1. We want to create a Jail within the FreeNAS webGUI. – Jails –> Add Jails The 3 highlighted areas are the only things that need to be […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[24,8,25],"tags":[],"_links":{"self":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts\/360"}],"collection":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/comments?post=360"}],"version-history":[{"count":8,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts\/360\/revisions"}],"predecessor-version":[{"id":369,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts\/360\/revisions\/369"}],"wp:attachment":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/media?parent=360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/categories?post=360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/tags?post=360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}