Bug 19127

Found that /etc/sysconfig/mythbackend is not setting MYTHTV_HOME
Easy fix is to add it to /etc/systemd/system/mythbackend.service.d/local.conf
cat > /etc/systemd/system/mythbackend.service.d/local.conf
[Service]
Environment=MYTHTV_HOME=/var/lib/mythtv
Environment=MYTHCONFDIR=/var/lib/mythtv
^d

https://bugs.mageia.org/show_bug.cgi?id=19223#c8 suggests a number is required in the password.

List of MythTv files needing new password:
System:
   /usr/share/mythtv/initialdb/mc.sql
   /var/lib/mythtv/config.xml

Users:
 $HOME/.mythtv/config.xml

After importing my mga5 mythtv dump on mga6, I could no longer log into mysql as root. Solution, 
o change root and mythtv passwords to pass mga6 mysql restrictions on mga5
o set new password in files in comment 3 on mga5
o export the mythconverg database to dump.sql
o set same root password on mga6 as mga5
o /usr/bin/mysqladmin --user=root password 'new_pw'
o mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql --user=root --password=new_pw mysql
o set new password in files in comment 3 on mga6
o mysql --user=root --password=new_pw mysql < dump.sql

(In reply to Bit Twister from comment #4)
> After importing my mga5 mythtv dump on mga6, I could no longer log into
> mysql as root.

root login problem was my fault.
My dump contained the mysql schema. Removed mysql schema from the dump.

FYI: 0.28 on 11-April-2016

Source RPM: drakxtools-17.71-1.mga6.src.rpm => mythtv-0.27.4-20141022.11.mga6.tainted.src.rpm

I'm going to start tinkering with this.

The hardware I am using is a Hauppauge WinTV-HVR-955Q USB TV Tuner
with a Mohu Leaf 50 TV Antenna.

Kaffeine works just fine on my test systems.

FYI:  29.0 released 01-February-2017

CC'ing some more committers, because the registered maintainer is unavailable

CC: (none) => cjw, eatdirt, guillomovitch

See bug 24104 to get mythtv-setup to access to database.

Might not hurt to get errata updated to have
    echo "MYTHTV_HOME=/var/lib/mythtv" >> /etc/sysconfig/mythbackend
    echo "MYTHCONFDIR=/var/lib/mythtv" >> /etc/sysconfig/mythbackend

mga6 users need to read https://bugs.mageia.org/show_bug.cgi?id=24104
mga7 users need just the above comment #11 workaround for mythtv-setup and mythbackend.

Fix in next mythtv-29.1-20181230.1.1.mga6 update and for cauldron too in
mythtv-29.1-20181230.2.mga7

It looks as if this & bug 24243 could be fixed by either adapting 
 /usr/share/doc/mythtv-doc/README
 /usr/share/doc/mythtv-doc/UPGRADING
with the necessary instructions, if this is permitted;
or create as suggested a
 /usr/share/doc/mythtv/README.mageia file about this
reference https://bugs.mageia.org/show_bug.cgi?id=24243#c4
and https://bugs.mageia.org/show_bug.cgi?id=24243#c8

The registered maintainer for mythtv is no longer active, so assigning this globally. DavidG is already involved.
Doubtful that we enhance ERRATA post release, but just in case this is possible, CC'ing Atelier.

Assignee: mageia => pkg-bugs
CC: marja11 => atelier-bugs, lewyssmith
Source RPM: mythtv-backend-29.1-20180521.2.mga7.tainted => mythtv-30.0-20190202.5.mga7.[tainted].src.rpm
See Also: (none) => https://bugs.mageia.org/show_bug.cgi?id=24243

Awaiting clarification of what points from comment 0 should be in ERRATA 7.

(In reply to Lewis Smith from comment #15)
> Awaiting clarification of what points from comment 0 should be in ERRATA 7.

mysql's requirement to have stronger passwords prevents mythtv install using
a short password.

Solution would be to change all
      IDENTIFIED BY "mythtv"
to    IDENTIFIED BY "mythtv_Password"
in /usr/share/mythtv/initialdb/mc.sql and use mythtv_Password at all password
prompts and ignore all documentation that indicates "mythtv" is to be used 
as password.

User is responsible for picking a consent node/ip value.

Thanks for the note. Done.

Keywords: (none) => IN_ERRATA7
Status: NEW => RESOLVED
Resolution: (none) => WORKSFORME