Help a newbie? (plugin jail, mysql & xbmc)

[seymour71]

Hi guys, I'm looking for an idiot proof guide here!

I'm currently running FreeNAS-8.3.1-RELEASE-p2-x64 (r12686+b770da6_dirty

I have somehow managed to set this up fine, and I am using it to stream videos to two xbmc Openelec devices.

I would like to sync my library now, so that if I start watching something on one device, I can finish on the other. I understand I need to install a plugin jail, Mysql, and then edit the advanced settings for xbmc, but I really need some help!

I don't really know where to start! any truly idiot-proof guides I could try?

Any guidance is much appreciated.

 

[Whattteva]

I would suggest you upgrade to 9.1.1 first before you proceed any further.
It has lots of bug fixes and numerous improvements to the jail system including improved GUI with automatic downloads, which would definitely help a newbie set up additional plugins.

 

[seymour71]

Good call actually, I hadn't even realised I wasn't running the most recent version. Upgrade done - it was painless!

Now, just to do the rest...still need an idiot-proof guide, the more I Google, the less I understand!

 

[par]

1. create a jail -> advanced options -> uncheck "vanilla"
2. reboot freenas
3. http://doc.freenas.org/index.php/Adding_Jails#Accessing_the_Command_Line_of_a_Jail
4. now you can "pkg install" stuff

There I just saved you hours of frustration not knowing why pkg isn't working

 

[seymour71]

Thanks for that, I have created a Jail!

I'm a bit lost now though - do I need to configure the ssh, as mentioned in your link? Or do I now install MySql?

 

[Whattteva]

SSH is not needed for what you are trying to do and you can go straight to installing MySQL. However, it is a nice to have since it makes administrating the jail a lot less cumbersome IMO.

 

[seymour71]

Cheers man, I'll have a bash at that tonight then. How would I go about installing Mysql once i've done the ssh stuff?

 

[Whattteva]

There is currently no plugin for that yet, so you will have to install that manually into the jail with this command:

Code:

pkg install mysql56-server

or for the client:

Code:

pkg install mysql56-client

Note I'm assuming you are using the pkgng database already if you followed par's suggestion several posts above.

 

[seymour71]

..er... I'll be honest, I don't know. I've just tried to find the post you mentioned, but I can't see it?

I did say I was a newbie. ;-)

 

[Whattteva]

Log in to the jail you wish to install MySQL on and execute this command:

Code:

pkg

If you get a message that says something like:

Code:

The package management tool is not yet installed on your system.
Do you want to fetch and install it now? [y/N]: n

If you get that message, then install MySQL using these commands instead:

Code:

pkg_add -r mysql56-server

Or for the client:

Code:

pkg_add -r mysql56-client

If the "pkg" command works, then use the commands that I listed earlier instead.

 

[seymour71]

Brilliant, thanks for that dude, I'll give it a bash tonight.

 

[seymour71]

Thanks for your continued help guys, I have tried the above, this is what I get:

Code:

                                                                           
[root@freenas ~]#                                                             
[root@freenas ~]# pkg install mysql156-server                                 
The package management tool is not yet installed on your system.               
Do you want to fetch and install it now? [y/N]: y                             
Bootstrapping pkg please wait                                                 
_http._tcp.pkg.FreeBSD.org                                                     
pkg: fail to extract pkg-static                                               
[root@freenas ~]# pkg_add -r mysql156-server                                   
Error: Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-9-st
able/Latest/mysql156-server.tbz: File unavailable (e.g., file not found, no acce
ss)                                                                           
pkg_add: unable to fetch 'ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages
-9-stable/Latest/mysql156-server.tbz' by URL                                   
[root@freenas ~]#                                                             
                      

 

[Whattteva]

Looks like the machine may have trouble accessing the internet.
Try this command for me and post the output:

Code:

nslookup freebsd.org

 

[seymour71]

Hi mate, from the root I get this:

Code:

[root@freenas ~]# nslookup freebsd.org                                         
Server:        192.168.1.1                                                   
Address:        192.168.1.1#53                                                 
                                                                               
Non-authoritative answer:                                                     
Name:  freebsd.org                                                           
Address: 8.8.178.110                                                           
                                                                               
[root@freenas ~]#    

From within the jail, I get this:

Code:

;; Got recursion not available from 192.168.1.1, trying next server           
;; connection timed out; no servers could be reached                           
                                                                               
root@testjail:/ #                                      

 

[Whattteva]

I just realized you're trying to install it on the freenas.
Run the pkg_add -r command inside the jail, not on the root box.

 

[seymour71]

Hi mate, I think I'm in the jail here, this is the output I get:

Code:

[root@freenas ~]# jexec 1  /bin/tcsh                                         
root@testjail:/ # pkg_add -r mysql156-server                                   
Error: Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-9-st
able/Latest/mysql156-server.tbz: File unavailable (e.g., file not found, no acce
ss)                                                                           
pkg_add: unable to fetch 'ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages
-9-stable/Latest/mysql156-server.tbz' by URL                                   
root@testjail:/ #                                                             
                    

 

[Whattteva]

Lol, of course it didn't work. You made a typo.
What you seem to have typed is:

Code:

pkg_add -r mysql156-server

What you're supposed to type is:

Code:

pkg_add -r mysql56-server

See the difference?

 

[seymour71]

Whoops! That seems to work now mate - thanks.

Should I somehow test this is working?

 

[Whattteva]

Not sure what you mean by that.

 

[seymour71]

Sorry mate, I meant will mysql just start on boot, or do I need to enable it?

Also, I understand I need to change an .xml on xbmc to look at the jails ip address to find the database, how would i find out that ip address?