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

[James Abernathy]

On Mon, Mar 30, 2020 at 7:13 AM Jim Abernathy <jfabernathy at gmail.com> wrote:

>
> On 3/29/20 11:12 PM, Bill Meek wrote:
> > On 3/24/20 7:24 PM, Bill Meek wrote:
> >> You're on Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04.
> >>
> >>
> My MariaDB tests are on Server version: 10.3.22-MariaDB-0ubuntu0.19.10.1 Ubuntu 19.10.
>
> >>
> >>
> >> https://mariadb.com/kb/en/create-user/#if-not-exists says IF NOT EXISTS is OK
>
> >>
> >> for 10.3. Sounds like 10.0 doesn't support it.
> >>
> >> What happens if you do: CREATE USER 'blah'@'%'  IDENTIFIED WITH mysql_native_password;
>
> >>
> >> and then do it again?
> >>
> >> DROP USER blah; will get rid of the new user.
> >
> > Give the attached a shot if you can, using sudo dpkg-reconfigure
> > mythtv-database
> >
> > It should live under: /var/lib/dpkg/info, rename the existing one
> > mythtv-database.postinst.SAVED first.
> >
> > Thanks,
>
> Yes this works without any errors.  It pops up the window asking about
> other computers running mythtv. I answer yes and it returns to the
> prompt without further dialogue.
>
> Thanks,
>
> Jim A
>

You may fully expect this but today I got an update to:
 2:31.0+fixes.202003301427.aa63cae~ubuntu18.04.1

I got the same error as before, but I did the same thing as yesterday and
used your new mythtv-database.postinst script and it finished with no
errors when I ran:

sudo dpkg-reconfigure mythtv-database.

I assume that at some time soon your fix will make it into the normal
update process.

Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200331/498b2915/attachment.htm>