[mythtv-users] Problem with Ubuntu upgrade

[Bill Meek]

On Sat, 2010-10-23 at 01:15 +0100, Damian wrote:
> +-----------+------------------+-------------------------------------------+
> | host      | user             | password                                  |
> +-----------+------------------+-------------------------------------------+
> | localhost | root             | *62342D54FD9B128B41AF87CC8373ECDC8D8D3EA3 |
> | MythBox   | root             |                                           |
> | 127.0.0.1 | root             |                                           |
> | localhost |                  |                                           |
> | localhost | debian-sys-maint | *E70FD7D9D21BEC5D5D6800B84C638DBE602A1195 |
> | localhost | mythtv           | *CC8F35F587CA5A556B4132C2407E256D92172FFC |
> | %         | mythtv           | *CC8F35F587CA5A556B4132C2407E256D92172FFC |
> | localhost | torrentflux      | *58AD98AB94E879529879F11472FC0B03B311264D |
> +-----------+------------------+-------------------------------------------+

I think there are at least 3 issues here.

1st, you can't execute:

  mysql -umythtv -p mythconverg
  mysql -hlocalhost -umythtv -p mythconverg

Please post the output from the above commands.

2nd, according to mythbackend.log you posted in:

  http://www.gossamer-threads.com/lists/mythtv/users/456665#456665

The backend was trying to login with hostname MythBox:

  Access denied for user 'mythtv'@'MythBox' (using password: YES)

Thats why there was a hostname command in front of the mysql line
I had you do. Please type hostname and supply the response.

3rd, also, from the above:
  
  Would you like to configure the database connection now? [no]
  [console is not interactive, using default 'no'] 

It appears that the backend was being started remotely, and the
the ability to do configuration was skipped automatically.  If
thats correct, I'd restart it from the server it runs on

If you're comfortable doing it, put the following in a file, make it
executable and run it.  Put the output in pastebin.com and put the
url in a response here.

#!/bin/bash
MYSQL_ROOT_PASSWORD="Put_Your_MySQL_Root_Password_Here"

echo -e "\n1. Configuration Files --------------------------\n"
DIRS="/home/$USER/.mythtv /home/mythtv/.mythtv /etc/mythtv"
for D in $DIRS; do
    ls -ld $D/mysql.txt $D/config.xml
    egrep "DBUserName|DBHostName" $D/mysql.txt $D/config.xml
done

echo -e "\n2. Who is that backend starting as --------------\n"
cat /etc/init/mythtv-backend.conf
# The above might be init.d

echo -e "\n3. What is my hostname --------------------------\n"
hostname

echo -e "\n4. What's in /etc/hosts -------------------------\n"
egrep -i "localhost|$(hostname)" /etc/hosts

echo -e "\n5. What is the hostname in MythTV DB ------------\n"
mysql -t -uroot -p${MYSQL_ROOT_PASSWORD} mythconverg -e \
    "SELECT * FROM settings WHERE value='HaltCommand'\n"

echo -e "\n6. What config file did the backend pick --------\n"
grep "Using config. directory" /var/log/mythtv/mythbackend.log | tail -1
grep "Access denied for user" /var/log/mythtv/mythbackend.log | tail -1

echo -e "\n7. And look at the MySQL passwords --------------\n"
mysql -t -uroot -p${MYSQL_ROOT_PASSWORD} mysql -e \
    "SELECT host,user,password FROM user"

All of the above should be done on the Master Backend.

Bill Meek