[mythtv-users] Debian update fails mythtv-database (re)configure

[Nick Morrott]

On 22 July 2015 at 01:37, Robin Gilks <g8ecj at gilks.org> wrote:
>
> I did at one stage find out how to determine just what root password the
> config script was using - I seem to have lost that information now :(

Put the following in a file, mark it as executable and run it:

---------------------------8<---------------------------
#!/bin/sh -e

. /usr/share/debconf/confmodule

db_get mythtv/mysql_admin_user
admin_username="$RET"

db_get mythtv/mysql_admin_password
admin_password="$RET"

db_get mythtv/mysql_host
hostname="$RET"

if test -z "$hostname"; then
    hostname=localhost
fi

db_get mythtv/mysql_mythtv_dbname
database="$RET"

echo "MythTV database upgrade variables (Debian):"
echo "  Username: $admin_username"
echo "  Password: $admin_password"
echo "  Hostname: $hostname"
echo "  Database: $database"
---------------------------8<---------------------------

This will print the variables the mythtv-database upgrade script is using.

You might also want to remove the two 'woden' host entries from your
mysql.user table unless you specifically need them. You have a
wildcard hostname entry for root, so this will help to reduce noise.

Cheers,
Nick