Mailing List Archive

The Nightmare of installing MythTV 0.26 and Centos 6.4
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

_______________________________________________
atrpms-users mailing list
atrpms-users@atrpms.net
http://lists.atrpms.net/mailman/listinfo/atrpms-users