Updated OS X Installer - 0.27.4

[pvr4me]

BTW, I noticed that you should be using another option with mythfilldatabase to grab all 14 days of program data in one swoop: --dd-grab-all. I've updated the wiki about this:

Make this option the default for all mythfilldatabase runs initiated by mythbackend. In mythtv-setup, go to "General", find the screen "Program Schedule Download Options" and ensure that "Guide data arguments" contains "--dd-grab-all".

http://www.mythtv.org/wiki/Silicondust_ ... lldatabase

Craig

[pvr4me]

Sorry about that. I didn't pay attention to the name. I just assumed all where mythbackend.

In this log, the database server was not running. Did you have to do something to start it before Myth would successfully start?

If it is a timing problem on boot up (MariaDB not finished starting by the time mythbackend tries to access it), I think the worst thing that will happen is that launchd will try again in 5 minutes to start the backend. But I haven't tested that.

Let me know if this is a continuing problem or not.

Craig

[rbmisc]

Craig,

I didn't do anything to start the database before the backend started. I have been able to watch live tv with no issues.

I've found that the system isn't recording anything I have scheduled. When I go into watch recorded programs, there is a big red X stating that the file could not be found in the database. The last two I scheduled didn't even appear in this area. I looked in the post about Live TV and recordings not starting. I have live tv. Just not getting anything recorded.

So I would appreciate any help in pointing me to possible solutions for this problem.

Rick

[pvr4me]

I didn't do anything to start the database before the backend started. I have been able to watch live tv with no issues.

I've found that the system isn't recording anything I have scheduled. When I go into watch recorded programs, there is a big red X stating that the file could not be found in the database. The last two I scheduled didn't even appear in this area. I looked in the post about Live TV and recordings not starting. I have live tv. Just not getting anything recorded.

Backend logs?

What locations have you defined for storing your media? Ala:

http://www.mythtv.org/wiki/MacPorts#Med ... _Locations

Craig

[rbmisc]

That information helped. I am interested in getting a complete document that explains exactly what each setup values could be that appear in each setup screen. Is there such a document? The documents that I have been referred to don't appear to match the Mythtv-setup program with MythTV Macport.

Any help here would be appreciated.

Rick

[rbmisc]

One thing I forgot to ask. I added an invalid directory to default storage setup. How do I delete this directory entry?

[pvr4me]

That information helped. I am interested in getting a complete document that explains exactly what each setup values could be that appear in each setup screen. Is there such a document?

My goodness, you don't want much!

This is an open source project and, as is typical, the documentation isn't always in perfectly in sync with the software. Normally, your best reference is the help text displayed along with each value of each control. The official docs don't always reflect the most recent version of the software but are also a pretty good reference. Find the section on configuration here:

http://www.mythtv.org/wiki/MythTV-HOWTO ... ing_MythTV

The documents that I have been referred to don't appear to match the Mythtv-setup program with MythTV Macport.

The user interface of the MacPorts build of MythTV is essentially identical to the Linux versions. Most of the differences between the wiki pages I've directed you to and the screens you see are due to upgrades to Myth since the wiki page was authored. (And trivial differences such as the captured screens showing a different UI theme in use.) Be a little flexible. Ask questions if you have trouble with specific settings.

Feel free to update the wiki. Someone who has just worked through the process for the first time is in the BEST position to help other users have a smooth first-time experience!

Craig

[pvr4me]

One thing I forgot to ask. I added an invalid directory to default storage setup. How do I delete this directory entry?

Offhand, I don't know. Check the following:

http://www.mythtv.org/wiki/MythTV-HOWTO ... d_commands

Pressing 'd' or the Delete key look like possibilities.

One thing to keep in mind is that Myth is designed so that it can be operated by a remote control with a fairly limited selection of buttons. (Even the 6-button Apple Mac remote control.) Often, pressing Menu on the remote, or "m" on the keyboard, brings up a context-sensitive menu of available commands.

Craig

[rbmisc]

Craig,

Here is my next question. I powered up my system and saw in the mythtvbackend log the mysql server didn't start. I had to manually start it. I looked in the instructions to see if there was any setting to automatically start it. Are there any documentation for setting up mariadb to start at power up?

Rick

[pvr4me]

Here is my next question. I powered up my system and saw in the mythtvbackend log the mysql server didn't start. I had to manually start it. I looked in the instructions to see if there was any setting to automatically start it. Are there any documentation for setting up mariadb to start at power up?

Way back, in the initial database setup, we instructed launchd to run the MariaDB mysqld server:

Code: Select all

sudo launchctl load -w /Library/LaunchDaemons/org.macports.mariadb-server.plist

Launchd will do its damndest to keep the server running until an authorized user gives it the 'unload' command.

Please provide a copy of the backend log you saw. BTW, did you wait 5 minutes for launchd's next attempt to start the backend?

Exactly, what command did you use to "manually start it"?

Rick, unless YOU provide specific details, we're just shooting in the dark. Frankly, I'm finding it frustrating that you don't seem to get that.

Craig

[rbmisc]

I had to go to terminal and enter mysql.server start. The mysqlbackend log indicated that it couldn't connect to the server. When I ran mysql.server start I got the message success and was able to start the backend.

Here's the log.
2014-11-18 17:06:56.313518 C [19/2579] thread_unknown mythcommandlineparser.cpp:2595 (ConfigureLogging) - mythbackend version: fixes/0.27 [v0.27.4-b305eb5b-MacPorts] www.mythtv.org
2014-11-18 17:06:56.313549 C [19/2579] thread_unknown mythcommandlineparser.cpp:2597 (ConfigureLogging) - Qt version: compile: 4.8.6, runtime: 4.8.6
2014-11-18 17:06:56.313555 N [19/2579] thread_unknown mythcommandlineparser.cpp:2599 (ConfigureLogging) - Enabled verbose msgs: general
2014-11-18 17:06:56.313757 N [19/2579] thread_unknown logging.cpp:907 (logStart) - Setting Log Level to LOG_INFO
2014-11-18 17:06:56.336914 I [19/7939] Logger logging.cpp:308 (run) - Added logging to the console
2014-11-18 17:06:56.337450 I [19/2579] thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) - Setup Interrupt: 2 handler
2014-11-18 17:06:56.337455 I [19/2579] thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) - Setup Terminated: 15 handler
2014-11-18 17:06:56.337459 I [19/2579] thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) - Setup Segmentation fault: 11 handler
2014-11-18 17:06:56.337462 I [19/2579] thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) - Setup Abort trap: 6 handler
2014-11-18 17:06:56.337466 I [19/2579] thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) - Setup Bus error: 10 handler
2014-11-18 17:06:56.337470 I [19/2579] thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) - Setup Floating point exception: 8 handler
2014-11-18 17:06:56.337473 I [19/2579] thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) - Setup Illegal instruction: 4 handler
2014-11-18 17:06:56.337696 N [19/2579] thread_unknown mythdirs.cpp:55 (InitializeMythDirs) - Using runtime prefix = /opt/dvr
2014-11-18 17:06:56.337704 N [19/2579] thread_unknown mythdirs.cpp:68 (InitializeMythDirs) - Using configuration directory = /opt/dvr/var/mythtvuser/.mythtv
2014-11-18 17:06:56.337769 I [19/2579] CoreContext mythcorecontext.cpp:257 (Init) - Assumed character encoding:
2014-11-18 17:06:56.337773 W [19/2579] CoreContext mythcorecontext.cpp:264 (Init) - This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE, and LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
2014-11-18 17:06:56.339469 N [19/2579] CoreContext mythcontext.cpp:504 (LoadDatabaseSettings) - Empty LocalHostName.
2014-11-18 17:06:56.339478 I [19/2579] CoreContext mythcontext.cpp:512 (LoadDatabaseSettings) - Using localhost value of iMac
2014-11-18 17:06:56.354329 E [19/2579] CoreContext mythdbcon.cpp:216 (OpenDatabase) - Unable to connect to database!
2014-11-18 17:06:56.354358 E [19/2579] CoreContext mythdbcon.cpp:217 (OpenDatabase) - Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/opt/dvr/var/run/mariadb/mysqld.sock' (2)

2014-11-18 17:06:56.354539 C [19/2579] CoreContext main.cpp:129 (main) - Failed to init MythContext.
2014-11-18 17:06:56.515260 I [19/6155] LogForward loggingserver.cpp:1373 (forwardMessage) - New Client: (#1)
2014-11-18 17:06:56.535647 I [-1/6155] loggingserver.cpp:142 (FileLogger) - Added logging to /opt/dvr/var/log/mythtv.27/mythbackend.20141118230656.19.log

[pvr4me]

I had to go to terminal and enter mysql.server start. The mysqlbackend log indicated that it couldn't connect to the server. When I ran mysql.server start I got the message success and was able to start the backend.

Yeah, 'mysql.server start' isn't right; I'm surprised it worked. As I said, launchd--unless told otherwise--will try to start the database server*. If that is not working, we should find out why.

Craig
*Launchd may possibly be trying to start another instance of the server after the copy you started manually.

[sergea29]

Hello Craig,

I did my best to clean up my computer and trying the install once again,taking each step carefully, i hope. Here is my echo path results: /opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/opt/X11/bin
I then proceeded to with the command: sudo -u _mysql mysql_install_db
I then tried to set the root password and got stuck trying to start de server:
cd '/opt/dvr' ; /opt/dvr/lib/mariadb/bin/mysqld_safe --datadir='/opt/dvr/var/db/mariadb'
And got this:
141124 21:02:05 mysqld_safe Logging to '/opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err'.
touch: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err: Permission denied
chmod: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err: Permission denied
141124 21:02:05 mysqld_safe Starting mysqld daemon with databases from /opt/dvr/var/db/mariadb
/opt/dvr/lib/mariadb/bin/mysqld_safe: line 138: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err: Permission denied
rm: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.pid: Permission denied
/opt/dvr/lib/mariadb/bin/mysqld_safe: line 182: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err: Permission denied
touch: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err: Permission denied
chown: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err: Permission denied
chmod: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err: Permission denied
141124 21:02:05 mysqld_safe mysqld from pid file /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.pid ended
/opt/dvr/lib/mariadb/bin/mysqld_safe: line 138: /opt/dvr/var/db/mariadb/Nadia-A-Doirons-iMac-10.local.err: Permission denied

For the sake of it I tried this command anyway :'/opt/dvr/lib/mariadb/bin/mysql_secure_installation'
but only got this:
touch: .my.cnf.6309: Permission denied
touch: .mysql.6309: Permission denied
chmod: .my.cnf.6309: No such file or directory
chmod: .mysql.6309: No such file or directory
/opt/dvr/lib/mariadb/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):

when I pressed enter I got this:
/opt/dvr/lib/mariadb/bin/mysql_secure_installation: line 232: .my.cnf.6309: Permission denied
/opt/dvr/lib/mariadb/bin/mysql_secure_installation: line 233: .my.cnf.6309: Permission denied
/opt/dvr/lib/mariadb/bin/mysql_secure_installation: line 234: .my.cnf.6309: Permission denied
/opt/dvr/lib/mariadb/bin/mysql_secure_installation: line 236: .my.cnf.6309: Permission denied
/opt/dvr/lib/mariadb/bin/mysql_secure_installation: line 205: .mysql.6309: Permission denied
/opt/dvr/lib/mariadb/bin/mysql_secure_installation: line 207: .mysql.6309: No such file or directory

After this I figured that I cannot continue. Any insight would be appreciated.

Thanks,

Serge

[pvr4me]

Where did you get these instructions about securing the database? Why do you want to secure it?

Craig

[sergea29]

Hello Craig,

I was following the instructions found in the terminal after installing MySQL as per the wiki (Add '-p' to the third command if you've followed the (very reasonable) instructions to protect the root account on your MySQL database with a password.) With regard to th -p, it should be added to sudo launchctl load -w /Library/LaunchDaemons/org.macports.mariadb-server.plist , right. Just in case I ever make it to there...

The instructions in the Terminal also said to start the server first. I was not sure how to but assumed that cd '/opt/dvr' ; /opt/dvr/lib/mariadb/bin/mysqld_safe --datadir='/opt/dvr/var/db/mariadb' , descibed as a way to start the mariadb deamon, was it.

In my last post, I also put my echo $PATH results hoping you could confim that it looks alright because I did not do it right when starting but I beleive I was able to fix it before continuing.

I would appriciate it if you could but me back on the right track with regards to installing Mysql.

Thanks ,

Serge