[mythtv-users] error during upgrade from V30 to V31

[Jim Abernathy]

On 3/31/20 11:12 AM, Bill Meek wrote:
> On 3/31/20 8:59 AM, James Abernathy wrote:
>> I assume that at some time soon your fix will make it into the normal
>> update process.
>
> Yes. Just making the search for SQL version better, as just looking 
> for 10.0 or 10.1
> wasn't good enough ('cause MySQL could reach that version.)
>
> Note that if you're trying the fix, it *must* be made executable (sudo 
> chmod a+x...)
> I didn't mention that in the last post.
>
Just updated to 2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1 this 
morning and got a new error similar to the mythtv-database problem 
previously. I'll hold off on using the patched mythtv-database.postinst 
we used before because of the new error.

Log below:

Unpacking mythtv (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) over 
(2:31.0+fixes.202003301427.aa63cae~ubuntu18.04.1) ...
Setting up libmyth (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up php-mythtv (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythtv-common 
(2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythweb (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up libgd3:amd64 (2.2.5-4ubuntu0.4) ...
Setting up mythtv-transcode-utils 
(2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up libmyth-python 
(2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up libmythtv-perl 
(2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythtv-database 
(2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Installing new version of config file /etc/cron.weekly/mythtv-database ...
mysql 'hidden SECURITY_INFO' --execute=CREATE USER IF NOT EXISTS 
'mythtv'@'%' IDENTIFIED WITH mysql_native_password; ALTER USER 
'mythtv'@'%' IDENTIFIED BY 'JebbVE2c'; GRANT ALL ON mythconverg.* TO 
'mythtv'@'%'; mythconverg failed, (incorrect admin username/password or 
syntax?)
Try:
sudo dpkg-reconfigure mythtv-database
Setting up mythtv-backend 
(2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythtv-frontend 
(2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythmusic (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythtv (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythtv-dbg (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythnews (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythgame (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythweather (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mytharchive (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythbrowser (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Setting up mythplugins (2:31.0+fixes.202004031046.809ea60~ubuntu18.04.1) ...
Processing triggers for ureadahead (0.100.0-21) ...
Processing triggers for libc-bin (2.27-3ubuntu1) ...
Processing triggers for systemd (237-3ubuntu10.39) ...
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for rsyslog (8.32.0-1ubuntu4) ...
Processing triggers for mime-support (3.60ubuntu1) ...