[MacPorts] #39714: mythtv-core.25 builds on ppc but scheduling fails

[MacPorts]

#39714: mythtv-core.25 builds on ppc but scheduling fails
-----------------------------+--------------------------
  Reporter:  swbhenderson@…  |      Owner:  ctreleaven@…
      Type:  defect          |     Status:  new
  Priority:  Normal          |  Milestone:
 Component:  ports           |    Version:  2.1.3
Resolution:                  |   Keywords:  ppc ppc64
      Port:  mythtv-core.25  |
-----------------------------+--------------------------

Comment (by swbhenderson@…):

 Replying to [comment:16 ctreleaven@…]:
 > OK, that should not happen.  I checked with the other G5 user and she
 confirmed that she originally had the byte-swapped characters (and
 manually entered corrections) and all channels invisible.  She mentioned
 that she had two instances of mysqld running when she converted to using
 Macports for Myth.  They _should_ be separate but...check with 'ps aux
 |grep mysqld'.
 >
 > Two more possibilities.  First, perhaps your database has become
 corrupted.  Make a backup and then optimize the database; docs at:
 >
 > http://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance
 >
 > Via MacPorts, the backup and optimize utilities are at:

 Very interesting.

 The database is brand new. About a week old. works fine for XBMC and I
 regular check it out using SEQEL PRO from on or other of the Mac boxes.

 BUT

 Your other G5 users comments ... never would have looked at that:

 {{{
 _mysql     294   0.0  2.5  2484004 206812   ??  S    10:54AM   7:02.57
 /opt/local/libexec/mysqld --basedir=/opt/local
 --datadir=/opt/local/var/db/mysql5 --user=_mysql --log-
 error=/opt/local/var/db/mysql5/ariel.local.err --open-files-limit=8192
 --pid-file=/opt/local/var/db/mysql5/ariel.local.pid
 --socket=/opt/local/var/run/mysql5/mysqld.sock --port=3306
 root        73   0.0  0.0    75944    796   ??  S    10:54AM   0:00.12
 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe
 --datadir=/opt/local/var/db/mysql5 --pid-
 file=/opt/local/var/db/mysql5/ariel.local.pid

 }}}
 Which one is the real one and where are they coming form?


 > /opt/local/share/mythtv/mythconverg_backup.pl
 > /opt/local/share/mythtv/contrib/optimize_mythdb.pl
 >
 > The "optimize" step uses MySQL functions to fix any basic problems with
 the database tables.  It is best if Myth is idle while the optimize script
 runs.
 >
 > Second, perhaps there is something wonky with the setup of your
 HDHomerun tuners.  Proper steps are:
 >
 >
 http://www.mythtv.org/wiki/Silicondust_HDHomeRun#North_America_Digital_Antenna
 >
 > I don't know if it is still necessary, but I've used my router to give
 my HDHomeruns reserved (unchanging) IP addresses.  I know that was
 required in the early days but it may no longer be necessary.
 >
 > Third (yeah, I know I said two but I thought of something else ;), are
 you certain that the other instances of myth are shut down?  Don't want
 something else grabbing the tuner before us!

-- 
Ticket URL: <https://trac.macports.org/ticket/39714#comment:17>
MacPorts <http://www.macports.org/>
Ports system for OS X