Featured Post

HOW TO: Install VPN server on Ubuntu when server is behind firewall

The whole point in this post is to run your own VPN service, and allow you to connect remote devices to your home network. To start off yo...

Dec 4, 2015

HOWTO: MySQL install guide for NAS4Free 10.2.x

In some of my previous posts I have written about using NAS4Free and installing various extensions on the system, well it was time to upgrade my NAS4Free but I didn't have the space on the Operating System drive - so a complete re-install was looming.

As daunting as it was, it was inevitable that I had to redo everything, but thanks to the new package manager in FreeBSD 10.x this turned out to be an enjoyable exercise.

The first step I decided to tackle was implementing the MySQL DB on NAS4Free, so I could provide a shared DB for Kodi installs.

First let's determine an appropriate location to install the temporary files for installation:

setenv PKG_TMPDIR /mnt/Data

Next let's create the appropriate user and group for the MySQL install in NAS4Free:

Group
Name: mysql
ID: 88

User
Name: mysql
Fullname: mysql
UserID: 88
Primary Group: mysql
NO PASSWORD

After defining the user to access the MySQL DB, the next step was installing MySQL server, using the following commands:

pkg install mysql56-server
rehash
cd /usr/local
mysql_install_db

At this point it is good practice to confirm that MySQL will indeed starts:

/usr/local/etc/rc.d/mysql-server onestart

Hopefully everything is good at this point and, the next step is to make sure that MySQL is enabled in NAS4Free:

nano /etc/rc.conf

Add the following line to the rc.conf file:

mysql_enable="YES"

Now you should be good to go.

If you want to configure this for Kodi to use, check out the following guide:
http://www.geekfreely.com/2015/12/howto-configuring-kodi-to-use-nas4free.html
Post a Comment