Resolved : The Nightmare of installing MythTV 0.26 and Centos 6.4
Bob Lightfoot <[email protected]> Fri, 31 May 2013 09:29:02 -0400
| Newsgroups | gmane.linux.redhat.rpm.atrpms.general |
|---|---|
| Message-ID | <[email protected]> |
On 05/31/2013 09:07 AM, Bob Lightfoot wrote:
> Dear Mailing list:
> My recent migration to Myth-0.26 is an ongoing nightmare, for which
> I hope there are some solutions out there. This email will be lengthy
> and contain a lot of hoepfully pertinent information. I've tried to
> make it readable placing problems and questions near the top and data at
> the end. Thanks for those using the atrpms mythtv implementation who
> have time to read and help.
>
> For reasons I won't into in this email, I managed to blow away my
> wonderful working Myth-0.25 system, but not before running mysqldump
> command and the mythconverg_backup.pl script and storing my backups
> safely off the system. Since Myth-0.26 was available, many thanks for
> Axel for that, I opted to install it.
>
> After a lot of work detailed below I at the point where I have what
> I believe is a system that should start when I issue "service
> mythbackend start" as root, but instead it fails as shown below:
>> [root@mythbox .mythtv]# service mythbackend start
>> Starting mythbackend: [ OK ]
>> [root@mythbox .mythtv]# QSqlDatabase: QMYSQL driver not loaded
>> QSqlDatabase: available drivers: QSQLITE
>>
>> Cannot login to database
>>
>> Would you like to configure the database connection now? [no]
>> [console is not interactive, using default 'no']
>>
>> [root@mythbox .mythtv]#
>
> I am out of ideas and things to try. I'll reply with whatever
> additional information might be needed.
>
> Below follows the nightmare of my installing myth-0.26.
>
> I'll post the content of my atrpms.repo in case there is a problem
> there, now:
>> [atrpms]
>> name=Red Hat Enterprise Linux $releasever - $basearch - ATrpms
>> failovermethod=priority
>> baseurl=http://dl.atrpms.net/el$releasever-$basearch/atrpms/stable
>> enabled=1
>> gpgcheck=1
>> gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-atrpms
>> priority=5
> Yes there are rpmfusion repos on this system as well, but there
> priority is 10 so I am relatively sure they ahve not inerfered. The
> first problem I encountered was that a simple "yum install mythtv"
> failed. I tried varying versions with "yum install
> http://dl.atrpms.net/el6-x86_64/atrpms/stable/mythtv-0.26.0-292.1.el6.x86_64.rpm"
> being what I finally had to run. This resulted in a numerous missing
> dependancy errors. For some reason yum would not pull in things like
> libmyth, libswscale2 and so forth. After a couple hours of working thru
> this I finally had all major and I think minor myth components
> installed. I'll post the output of yum list installed | grep atrpms for
> reference now:
>> PIL.x86_64 1.1.7-10.1.el6 @atrpms
>> a52dec.x86_64 0.7.4-7.0.1.el6 @atrpms
>> atrpms.noarch 77-1 @atrpms
>> atrpms-repo.x86_64 6-6.el6 @atrpms
>> atrpms-rpm-config.noarch 202-1 @atrpms
>> bitstream-vera-fonts-common.noarch 1.10-18.el6 @atrpms
>> bitstream-vera-sans-fonts.noarch 1.10-18.el6 @atrpms
>> 1.10-18.el6 @atrpms
>> bitstream-vera-serif-fonts.noarch 1.10-18.el6 @atrpms
>> crystalhd-firmware.noarch 3.10.0-3.99.el6 @atrpms
>> cuetools.x86_64 1.4.0-0.6.svn305.el6 @atrpms
>> faac.x86_64 1.28-6.el6 @atrpms
>> ffmpeg.x86_64 1.2.1-59.el6 @atrpms
>> fluidsynth-libs.x86_64 1.1.3-1.el6 @atrpms
>> glib.x86_64 1:1.2.10-33.el6 @atrpms
>> gtk+.x86_64 1:1.2.10-70.el6 @atrpms
>> lash.x86_64 0.5.4-9.el6 @atrpms
>> liba52_0.x86_64 0.7.4-7.0.1.el6 @atrpms
>> libavcodec54.x86_64 1.2.1-59.el6 @atrpms
>> libavdevice54.x86_64 1.2.1-59.el6 @atrpms
>> libavfilter3.x86_64 1.2.1-59.el6 @atrpms
>> libavformat54.x86_64 1.2.1-59.el6 @atrpms
>> libavutil52.x86_64 1.2.1-59.el6 @atrpms
>> libbluray.x86_64 0.3.0-5.el6 @atrpms
>> libbluray1.x86_64 0.3.0-5.el6 @atrpms
>> libcddb.x86_64 1.3.2-4.el6 @atrpms
>> libcrystalhd.x86_64 3.10.0-3.99.el6 @atrpms
>> libdca0.x86_64 0.0.5-4.el6 @atrpms
>> libdvbpsi7.x86_64 0.2.2-1.el6 @atrpms
>> libebml.x86_64 1.0.0-1.el6 @atrpms
>> libfaac0.x86_64 1.28-6.el6 @atrpms
>> libfaad2.x86_64 1:2.7-18.el6 @atrpms
>> libgoom2.x86_64 0-3.el6 @atrpms
>> libirman0.x86_64 0.4.5-7.el6 @atrpms
>> liblirc_client0.x86_64 0.9.0-89.el6 @atrpms-testing
>> libmad0.x86_64 0.15.1b-4.el6 @atrpms
>> libmatroska.x86_64 1.0.0-1.el6 @atrpms
>> libmikmod.x86_64 3.2.0-11.beta2.el6 @atrpms
>> libmodplug.x86_64 1:0.8.7-2.el6 @atrpms
>> libmyth-0.26_0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythavcodec54.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythavdevice54.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythavfilter2.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythavformat54.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythavutil51.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythbase-0.26_0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythfreemheg-0.26_0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythhdhomerun-0.26_0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythlivemedia-0.26_0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythnzmqt0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythpostproc52.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythprotoserver-0.26_0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythqjson0.x86_64 0.26.0-292.1.el6 @atrpms
>> 0.26.0-292.1.el6 @atrpms
>> libmythswresample0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythswscale2.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythui-0.26_0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythupnp-0.26_0.x86_64 0.26.0-292.1.el6 @atrpms
>> libmythzmq1.x86_64 0.26.0-292.1.el6 @atrpms
>> libnemesi.x86_64 0.6.9-0.1.20090422git.el6 @atrpms
>> libogg.x86_64 2:1.2.0-10.el6 @atrpms-testing
>> libogg0.x86_64 2:1.2.0-10.el6 @atrpms-testing
>> libopencore-amrnb0.x86_64 0.1.3-1.el6 @atrpms
>> libopencore-amrwb0.x86_64 0.1.3-1.el6 @atrpms
>> libpostproc52.x86_64 1.2.1-59.el6 @atrpms
>> libprojectM.x86_64 2.0.1-5.el6 @atrpms
>> libquicktime0.x86_64 1.2.3-30.el6 @atrpms
>> libreplaygain.x86_64 0.9.1-0.1.svn453.el6 @atrpms
>> libswresample0.x86_64 1.2.1-59.el6 @atrpms
>> libswscale2.x86_64 1.2.1-59.el6 @atrpms
>> libtheora.x86_64 1:1.1.1-13.el6 @atrpms-testing
>> libtheora0.x86_64 1:1.1.1-13.el6 @atrpms-testing
>> libtheoradec1.x86_64 1:1.1.1-13.el6 @atrpms-testing
>> libtheoraenc1.x86_64 1:1.1.1-13.el6 @atrpms-testing
>> libupnp.x86_64 1.6.6-3.el6 @atrpms
>> libva.x86_64 1.0.15-7.el6 @atrpms
>> libva-glx1.x86_64 1.0.15-7.el6 @atrpms
>> libva-x11_1.x86_64 1.0.15-7.el6 @atrpms
>> libva1.x86_64 1.0.15-7.el6 @atrpms
>> libvcdinfo0.x86_64 0.7.24-10.el6 @atrpms
>> libvorbis.x86_64 1:1.2.3-6.el6 @atrpms-testing
>> libvorbis0.x86_64 1:1.2.3-6.el6 @atrpms-testing
>> libvorbisenc2.x86_64 1:1.2.3-6.el6 @atrpms-testing
>> libvorbisfile3.x86_64 1:1.2.3-6.el6 @atrpms-testing
>> libvpx.x86_64 1.0.0-1.el6 @atrpms
>> libvpx0.x86_64 0.9.7.1-1_1.el6 @atrpms
>> libx264_130.x86_64 0.130-18_20130509.2245.el6 @atrpms
>> libxavs1.x86_64 0.1.51-2.el6 @atrpms
>> libxosd2.x86_64 2.2.14-4.el6 @atrpms
>> libxvidcore4.x86_64 1.2.2-14.el6 @atrpms
>> lirc.x86_64 0.9.0-89.el6 @atrpms-testing
>> live.x86_64 2012.02.04-1.el6 @atrpms
>> mjpegtools.x86_64 1:2.0.0-22.el6 @atrpms
>> mplayer.x86_64 4:1.2-91_snap20130509.el6 @atrpms
>> mplayer-fonts.noarch 4:1.0-7.at @atrpms
>> musepack-tools.x86_64 sv8-3.svn435.el6 @atrpms
>> mytharchive.x86_64 0.26.0-292.1.el6 @atrpms
>> mythbrowser.x86_64 0.26.0-292.1.el6 @atrpms
>> mythgallery.x86_64 0.26.0-292.1.el6 @atrpms
>> mythgame.x86_64 0.26.0-292.1.el6 @atrpms
>> mythmusic.x86_64 0.26.0-292.1.el6 @atrpms
>> mythnetvision.x86_64 0.26.0-292.1.el6 @atrpms
>> libva.x86_64 1.0.15-7.el6 @atrpms
>> libva-glx1.x86_64 1.0.15-7.el6 @atrpms
>> libva-x11_1.x86_64 1.0.15-7.el6 @atrpms
>> libva1.x86_64 1.0.15-7.el6 @atrpms
>> libvcdinfo0.x86_64 0.7.24-10.el6 @atrpms
>> libvorbis.x86_64 1:1.2.3-6.el6 @atrpms-testing
>> libvorbis0.x86_64 1:1.2.3-6.el6 @atrpms-testing
>> libvorbisenc2.x86_64 1:1.2.3-6.el6 @atrpms-testing
>> libvorbisfile3.x86_64 1:1.2.3-6.el6 @atrpms-testing
>> libvpx.x86_64 1.0.0-1.el6 @atrpms
>> libvpx0.x86_64 0.9.7.1-1_1.el6 @atrpms
>> libx264_130.x86_64 0.130-18_20130509.2245.el6 @atrpms
>> libxavs1.x86_64 0.1.51-2.el6 @atrpms
>> libxosd2.x86_64 2.2.14-4.el6 @atrpms
>> libxvidcore4.x86_64 1.2.2-14.el6 @atrpms
>> lirc.x86_64 0.9.0-89.el6 @atrpms-testing
>> live.x86_64 2012.02.04-1.el6 @atrpms
>> mjpegtools.x86_64 1:2.0.0-22.el6 @atrpms
>> mplayer.x86_64 4:1.2-91_snap20130509.el6 @atrpms
>> mplayer-fonts.noarch 4:1.0-7.at @atrpms
>> musepack-tools.x86_64 sv8-3.svn435.el6 @atrpms
>> mytharchive.x86_64 0.26.0-292.1.el6 @atrpms
>> mythbrowser.x86_64 0.26.0-292.1.el6 @atrpms
>> mythgallery.x86_64 0.26.0-292.1.el6 @atrpms
>> mythgame.x86_64 0.26.0-292.1.el6 @atrpms
>> mythmusic.x86_64 0.26.0-292.1.el6 @atrpms
>> mythnetvision.x86_64 0.26.0-292.1.el6 @atrpms
>> mythnews.x86_64 0.26.0-292.1.el6 @atrpms
>> mythplugins.x86_64 0.26.0-292.1.el6 @atrpms
>> mythweather.x86_64 0.26.0-292.1.el6 @atrpms
>> mythweb.noarch 0.26.0-277 @atrpms
>> mythzoneminder.x86_64 0.26.0-292.1.el6 @atrpms
>> nas-libs.x86_64 1.9.2-1.el6 @atrpms
>> netembryo.x86_64 0.0.9-1.el6 @atrpms
>> perl-Class-Factory-Util.noarch 1.7-7.el6 @atrpms
>> perl-DateTime-Format-Builder.noarch 0.8000-2_1.el6 @atrpms
>> 1.2000-2.el6 @atrpms
>> perl-Tk-TableMatrix.x86_64 1.23-7.el6 @atrpms
>> perl-XMLTV.noarch 0.5.61-85.el6 @atrpms
>> portaudio.x86_64 19-6_4_20071207.el6 @atrpms
>> qt47.x86_64 1:4.7.2-1_18.el6 @atrpms-testing
>> qt47-webkit.x86_64 1:4.7.2-1_18.el6 @atrpms-testing
>> qt47-x11.x86_64 1:4.7.2-1_18.el6 @atrpms-testing
>> schroedinger.x86_64 1.0.10-1.el6 @atrpms
>> transcode.x86_64 1.1.7-48.el6 @atrpms
>> twolame.x86_64 0.3.12-2.el6 @atrpms
>> vlc.x86_64 2.0.6-6.el6 @atrpms
>> xmltv.noarch 0.5.61-85.el6 @atrpms
>> xmltv-grabbers.noarch 0.5.61-85.el6 @atrpms
>> xmltv-gui.noarch 0.5.61-85.el6 @atrpms
>> xmms-libs.x86_64 1:1.2.11-40.el6 @atrpms
>
> At this point I launched mythTV setup from the, but was caught in a
> viscous loop that only ESCAPE Key would exit. A little checking with
> the mysql command revealed that no mythconverg database existed. so
> with a bit more checking I found that I could create database
> mythconverg in mysql ; then "mysql -u root -p[root-password-sanitized]
> mythconverg < myth-0.25-mythconverg-backup.sql" and create the database.
> Following that I could "mythconverg_restore --drop_database
> --create_database --filename myth-0.25-mythconverg-backup.sql.gz. This
> as far as I can tell gives me a working schema 1299 database.
>
> Still service mythbackend start fails and I am at a loss for why or
> what I might have missed.
>
> The /etc/my.cnf file is as follows:
>> [mysqld]
>> datadir=/var/lib/mysql
>> socket=/var/lib/mysql/mysql.sock
>> user=mysql
>> # Disabling symbolic-links is recommended to prevent assorted security risks
>> symbolic-links=0
>> bind-address=192.168.2.201
>>
>> [mysqld_safe]
>> log-error=/var/log/mysqld.log
>> pid-file=/var/run/mysqld/mysqld.pid
>
>
> The config.xml of both root and my-non-root-user are as follows:
>> <Configuration>
>> <UPnP>
>> <UDN>
>> <MediaRenderer>17900799-d363-4539-bca3-c286bc37543e</MediaRenderer>
>> </UDN>
>> </UPnP>
>> <LocalHostName>mythbox.ladodomain</LocalHostName>
>> <Database>
>> <PingHost>1</PingHost>
>> <Host>192.168.2.201</Host>
>> <UserName>mythtv</UserName>
>> <Password>mythtv</Password>
>> <DatabaseName>mythconverg</DatabaseName>
>> <Port>3306</Port>
>> </Database>
>> <WakeOnLAN>
>> <Enabled>0</Enabled>
>> <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
>> <SQLConnectRetry>5</SQLConnectRetry>
>> <Command>echo 'WOLsqlServerCommand not set'</Command>
>> </WakeOnLAN>
>> </Configuration>
>
> The mysql.txt file also is as follows:
>> DBHostName=192.168.2.201
>>
>> # By default, Myth tries to ping the DB host to see if it exists.
>> # If your DB host or network doesn't accept pings, set this to no:
>> #
>> #DBHostPing=no
>>
>> DBPort=3306
>> DBUserName=mythtv
>> DBPassword=mythtv
>> DBName=mythconverg
>> DBType=QMYSQL
>>
>> # Set the following if you want to use something other than this
>> # machine's real hostname for identifying settings in the database.
>> # This is useful if your hostname changes often, as otherwise you
>> # will need to reconfigure mythtv every time.
>> # NO TWO HOSTS MAY USE THE SAME VALUE
>> #
>> #LocalHostName=my-unique-identifier-goes-here
>>
>> # If you want your frontend to be able to wake your MySQL server
>> # using WakeOnLan, have a look at the following settings:
>> #
>> #
>> # The time the frontend waits (in seconds) between reconnect tries.
>> # This should be the rough time your MySQL server needs for startup
>> #
>> #WOLsqlReconnectWaitTime=0
>> #
>> #
>> # This is the number of retries to wake the MySQL server
>> # until the frontend gives up
>> #
>> #WOLsqlConnectRetry=5
>> #
>> #
>> # This is the command executed to wake your MySQL server.
>> #
>> #WOLsqlCommand=echo 'WOLsqlServerCommand not set'
>
>
> If I have omitted something please ask. Any help is appreciated.
>
> Sicnerely,
> Bob Lightfoot
>
Dear ATRpms users:
Turns out that qt47-mysql package was not installed. This resolved
the database connection issues. I then also had to resolve the time
zone issue detailed here --> >
http://www.mythtv.org/wiki/Troubleshooting:Mythbackend_will_not_start_after_upgrade_0.26_Time_Zone_error
WIth that out of the way the myth-setup would run and update the
databases. And MythTV-Frontend worked.
Axel - It looks good. Thanks for the hard work.
Sicnerely,
Bob Lightfoot