rm-r
Contributor
- Joined
- Jan 7, 2013
- Messages
- 166
Hi Guys,
Just thought is post here for how to set-up 9.1.1 with mysql for a centralised XBMC watched and progress library
http://wiki.xbmc.org/index.php?titl...ySQL/Setting_up_MySQL#tab=FreeNAS_and_freeBSD
I collated information from around the place and put in one guide - works wonderfully!
I have put a copy below for safe keeping / link death
Cheers
RM-r
----------------------------------------------------------------------------------------------------------------------
=== Make a jail ===
create a "STANDARD" Jail via the FreeNAS webui - if unsure see here http://doc.freenas.org/index.php/Adding_Jails
make a note of the jail IP address shown - you will need this to put in the advancedsettings.xml file on the XBMC machine later
=== Prepare the jail ===
ssh into FreeNAS
If you have a windows PC use putty (http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html)
(easiest) click the "shell" button in the left of the FreeNAS webui
type the following commands
Take note of the JID of the jail you created, use it in the command below and replace n with the number of the jail you just created
=== Install mysql ===
You are now inside your jail
(nano is a text editor you will need shortly)
We now need to enable mysql in rc.conf
insert the line below into the rc.conf file
save the file and exit (see bottom of nano edit page for keystrokes info)
Optional step below - this is an automated script that will secure you mysql instance - it will prompt you for answers to questions. Its up to you if you do this.
=== Configure mysql ready for xbmc to use ===
type in
You are now in mysql administration
that's it - proceed to the next step below and configure XBMC to use your FreeNAS hosted XBMC MYSQL database - I love mine!
Just thought is post here for how to set-up 9.1.1 with mysql for a centralised XBMC watched and progress library
http://wiki.xbmc.org/index.php?titl...ySQL/Setting_up_MySQL#tab=FreeNAS_and_freeBSD
I collated information from around the place and put in one guide - works wonderfully!
I have put a copy below for safe keeping / link death
Cheers
RM-r
----------------------------------------------------------------------------------------------------------------------
=== Make a jail ===
create a "STANDARD" Jail via the FreeNAS webui - if unsure see here http://doc.freenas.org/index.php/Adding_Jails
make a note of the jail IP address shown - you will need this to put in the advancedsettings.xml file on the XBMC machine later
=== Prepare the jail ===
ssh into FreeNAS
If you have a windows PC use putty (http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html)
(easiest) click the "shell" button in the left of the FreeNAS webui
type the following commands
Code:
jls
Take note of the JID of the jail you created, use it in the command below and replace n with the number of the jail you just created
Code:
jexec n csh
=== Install mysql ===
You are now inside your jail
Code:
pkg install mysql55-server
Code:
pkg install nano
(nano is a text editor you will need shortly)
We now need to enable mysql in rc.conf
Code:
nano /etc/rc.conf
insert the line below into the rc.conf file
Code:
mysql_enable="YES"
save the file and exit (see bottom of nano edit page for keystrokes info)
Code:
service mysql-server start
Optional step below - this is an automated script that will secure you mysql instance - it will prompt you for answers to questions. Its up to you if you do this.
Code:
mysql_secure_installation
=== Configure mysql ready for xbmc to use ===
type in
Code:
mysql -u root -p
You are now in mysql administration
Code:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
Code:
GRANT ALL ON *.* TO 'xbmc';
Code:
quit;
that's it - proceed to the next step below and configure XBMC to use your FreeNAS hosted XBMC MYSQL database - I love mine!