[mythtv-users] Problem with Ubuntu upgrade

[Damian]

On 23/10/2010 02:12, Bill Meek wrote:
> 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

This results in:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using 
password: YES)

>    mysql -hlocalhost -umythtv -p mythconverg

This too results in
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using 
password: YES)

I tried both my root password and my mythtv password (which worked fine 
in MythtV until the Ubuntu upgrade) for both.

>
> 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.

Hotsname responce:
MythBox

>
> 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"

My mum told me not to run code i don't understand from strangers! But 
I'm getting desperate, so did it anyway.

Here's the output:

http://www.gingermagic.com/misc/mythhelp.txt

> All of the above should be done on the Master Backend.
>
> Bill Meek
>

Thanks for helping Bill. I have no idea if we're getting anywhere. I've 
taken to using 'MeTv' in the mean time.

Thanks
Damian