I just upgraded initially and everthing worked OK, however I have installed on a fresh NAS using 9.3 and the proceedure was completed as I origonally described.Are there any updates to the guide as a result of the new version (9.3 +) of FreeNAS?
mysql> SELECT @@global.time_zone, @@session.time_zone;
+--------------------------+---------------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------------+---------------------------+
| SYSTEM | SYSTEM |
+--------------------------+---------------------------+
1 row in set (0.00 sec)
This shows that mysql is using the system for it's timezone …
Now check the mythtv database entry
root@mythtest:/ # mysql -u root -p'<password>' -e 'show databases;'
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | mythconverg | | performance_schema | | test | +--------------------+ 5 rows in set (0.00 sec) mysql>
Setup Remote X11 access from your PC/Laptop
Download Xming from here: http://sourceforge.net/projects/xming/
Download PuTTY from here: http://www.putty.org/
ssh -Y root@<mythtv jail ip> /usr/local/bin/mythtv-setup
root@mythtest:/ # service sshd restart
root@mythtv:/ # service sshd restart Performing sanity check on sshd configuration. Could not load host key: /etc/ssh/ssh_host_rsa_key Could not load host key: /etc/ssh/ssh_host_dsa_key Could not load host key: /etc/ssh/ssh_host_ecdsa_key Could not load host key: /etc/ssh/ssh_host_ed25519_key Disabling protocol version 2. Could not load host key sshd: no hostkeys available -- exiting.
root@mythtv:/ # /usr/bin/ssh-keygen -A ssh-keygen: generating new host keys: RSA1 RSA DSA ECDSA ED25519 root@mythtv:/ # service sshd restart Performing sanity check on sshd configuration. sshd not running? (check /var/run/sshd.pid). Performing sanity check on sshd configuration. Starting sshd. root@mythtv:/ #
root@mythtv:/ # service ssh status ssh does not exist in /etc/rc.d or the local startup directories (/usr/local/etc/rc.d) root@mythtv:/ #
Firstly create a mythtv jail in FreeNAS (standard plugin jail)
login to the jail and a) set the root password "passwd" and b) create a user with full privileges"adduser" just follow the prompts, where it asks for the following....
Login group is test. Invite test into other groups? []: <enter wheel group here>
===> Creating users and/or groups. Creating group 'mythtv' with gid '119'. Creating user 'mythtv' with uid '119'. [mythtv] [139/139] Extracting mythtv-0.27.0.20140121_6: 100%
root@mythtest:/ # echo 'ListenAddress <youripaddress>' >> /etc/ssh/sshd_config
root@mythtest:/ # ssh -Y root@<mythtv jail ip> /usr/local/bin/mythtv-setup
I recommend you use Zufallsheld's very comprehensive installation guidehttp://zufallsheld.de/2013/11/22/freenas-transmission-couchpotato-sickbeard-dlna-server/
Yes, but it does NOT show that the timezones were loaded correctly.
This page describes how to test whether your timezones have been loaded correctly:
http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables
I don't understand why you are creating a user in this step because:
- I don't see where it is used in your tutorial, and
- MythTV creates it's own user and group during its installation
Code:===> Creating users and/or groups. Creating group 'mythtv' with gid '119'. Creating user 'mythtv' with uid '119'. [mythtv] [139/139] Extracting mythtv-0.27.0.20140121_6: 100%
I misunderstood the instructions for setting up X11 forwarding so I'm posting what worked for me.
<youripaddress> is the address of the MythTV Jail. It is the same as <mythtv jail ip> used a little later in the tutorial.
The prefix root@mythtest:/ mislead me into thinking that this command is run within the MythTV Jail. It is run from your X11 client on your PC/Mac/Whatever.
This didn't work for me
Code:root@mythtv:/ # service sshd restart Performing sanity check on sshd configuration. Could not load host key: /etc/ssh/ssh_host_rsa_key Could not load host key: /etc/ssh/ssh_host_dsa_key Could not load host key: /etc/ssh/ssh_host_ecdsa_key Could not load host key: /etc/ssh/ssh_host_ed25519_key Disabling protocol version 2. Could not load host key sshd: no hostkeys available -- exiting.
Until I explicitly built the keys:
Code:root@mythtv:/ # /usr/bin/ssh-keygen -A ssh-keygen: generating new host keys: RSA1 RSA DSA ECDSA ED25519 root@mythtv:/ # service sshd restart Performing sanity check on sshd configuration. sshd not running? (check /var/run/sshd.pid). Performing sanity check on sshd configuration. Starting sshd. root@mythtv:/ #
But I'm wondering …
Does ssh need to be added to /etc/rd.d ?
Code:root@mythtv:/ # service ssh status ssh does not exist in /etc/rc.d or the local startup directories (/usr/local/etc/rc.d) root@mythtv:/ #
The thread on the FreeNAS Forum may be better.
if the timezone was not loaded correctly then it would not show that the System time zone is being used, there would be a null error.
It's actually the same article by the same guy!
I don't know why this failed for you, no other reports for missing keys on this topic....