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

[James Abernathy]

On Tue, Mar 24, 2020 at 3:49 PM Bill Meek <keemllib at gmail.com> wrote:

> On 3/24/20 1:45 PM, James Abernathy wrote:
> > On Tue, Mar 24, 2020 at 2:37 PM Bill Meek <keemllib at gmail.com> wrote:
>
> ...
>
> >> Hmmm, this looks like something that was fixed got reverted. It's still
> OK
> >> in our packaging tree.
> >>
> >> Jim,
> >>
> >> Please look in: /var/lib/dpkg/info/mythtv-database.postinst
> >>
> >> There should be a lines like these:
> >>
> >> update_database() {
> >>       #Set up privs for mythtv at network
> >>       if ! echo "CREATE USER IF NOT EXISTS '$mythtv_username'@'%'
> >> IDENTIFIED WITH mysql_native_password; \
> >>                  ALTER USER '$mythtv_username'@'%' IDENTIFIED BY
> >> '$mythtv_password'; \
> >>                  GRANT ALL ON $database.* TO '$mythtv_username'@'%';"
> | \
> >>           mysql $SECURITY_INFO "$database" >/dev/null 2>&1; then
> >>           fail_database
> >>       fi
> >>
> >> But it appears that you'll see:
> >>
> >> update_database() {
> >>       #Set up privs for mythtv at network
> >>       if ! echo "GRANT ALL PRIVILEGES ON $database.* TO
> $mythtv_username@'%'
> >> IDENTIFIED BY '$mythtv_password';" | \
> >>           mysql $SECURITY_INFO "$database" >/dev/null 2>&1; then
> >>           fail_database
> >>       fi
> >>
> >> --
> >> Bill
> >>
> > I see
> >
> > update_database() {
> >      #Set up privs for mythtv at network
> >      if ! echo "CREATE USER IF NOT EXISTS '$mythtv_username'@'%'
> IDENTIFIED
> > WITH mysql_native_password; \
> >                 ALTER USER '$mythtv_username'@'%' IDENTIFIED BY
> > '$mythtv_password'; \
> >                 GRANT ALL ON $database.* TO '$mythtv_username'@'%';" | \
> >          mysql $SECURITY_INFO "$database" >/dev/null 2>&1; then
> >          fail_database
> >      fi
>
> That's good.
>
> Can you login as the root user using the credentials in:
> /etc/mysql/debian.cnf ?
> This works for me: sudo mysql --defaults-extra-file=/etc/mysql/debian.cnf
> on
> MariaDB and MySQL v5.7 and 8.
>
> If that fails, your earlier comment about ' admin username and password'
> may
> explain things. Otherwise, please read on...
>
> The attached has some debugging info in it. I'd rename the existing file
> and put this one in. Make sure to chmod 755 on it.
>
> Then re-run: sudo dpkg-reconfigure mythtv-database
>
> Additional information will print in the failure message. At least it
> would get
> it down to the area that's failing.
>
> Remove the file and re-rename the original
> /var/lib/dpkg/info/mythtv-database.postinst
> file.
>
>
> --
> Bill
>
> I can login with the --default-extra-file
The sudo dpkg-reconfigure mythtv-database didn't add much new text.

jim at mythbuntu:~$ sudo dpkg-reconfigure mythtv-database
Failed to create/alter user or grant permissions to database (incorrect
admin username/password?)
Try:
sudo dpkg-reconfigure mythtv-database
jim at mythbuntu:~$

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