[mythtv-users] mythtv-users Digest, Vol 91, Issue 94
Damian
myth at surr.co.uk
Tue Oct 26 03:26:45 UTC 2010
On 26/10/2010 00:34, mythtv-users-request at mythtv.org wrote:
> Date: Mon, 25 Oct 2010 21:20:35 +0100
> From: Jason Chambers<lists at purplish-monkey.com>
> Subject: Re: [mythtv-users] Problem with Ubuntu upgrade
> To:mythtv-users at mythtv.org
> Message-ID:<4CC5E693.7080300 at purplish-monkey.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On 25/10/2010 19:51, Damian wrote:
>> > On 23/10/2010 02:12, Bill Meek wrote:
>>> >>
>>> >> mysql -umythtv -p mythconverg
>> >
>> > This results in:
>> > ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
>> > password: YES)
> Hmm, you've previously ran this command before and it was successful
> (http://www.gossamer-threads.com/lists/mythtv/users/457092#457092).
>
> Have you been making other changes that you haven't posted about? Or
> changed something, then you reversed the change out again afterwards but
> maybe didn't get it right? Or maybe re-keyed the above command and made
> a typo?
>
> (Sorry don't mean to sound accusing here - just don't want to go chasing
> something that may not be relevant).
>
>> >
>>> >> 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.
> The user name your using here is mythtv. So the password is the mythtv
> user's password, not the root password. Also unless you've changed the
> password again since you posted the user table contents in your previous
> emails the password is "mythtv".
I'm very confused now!
I've just got into into:
mysql -umythtv -p mythconverg
By using, not my root password, not my mythtv users password, but by
using 'mythtv' it's self as a password. I've never set 'mythtv' as a
password. What's going 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.
>>> >>
> <snip>
>
>> > Here's the output:
>> >
>> > http://www.gingermagic.com/misc/mythhelp.txt
>> >
> <quoting from url>
>
>> > 192.168.0.2 MythBox # Added by NetworkManager
>> > 127.0.0.1 localhost.localdomain localhost
>> > ::1 MythBox localhost6.localdomain6 localhost6
>> > 127.0.1.1 MythBox
>> > ::1 ip6-localhost ip6-loopback
I swapped an email with Bill how pointed out that I'd run his script
without editing the password in the script!! Here's the real output:
http://www.gingermagic.com/misc/myth2.txt
> That shows your /etc/hosts file has MythBox resolving to both 127.0.0.1
> and its external IP address of 192.168.0.2.
>
> This can cause all sorts of confusion as its not guaranteed which one
> MythBox will be resolved to.
>
> Please remove the "127.0.1.1 MythBox" line, restart mysql (as it may
> cache the lookups) and try connecting again:
How do I do that?
> $ mysql -u mythtv -p mythconverg
I can log in using 'mythtv' as the password!?!?!
> $ mysql -u mythtv -h mythbox -p mythconverg
I can log in using 'mythtv' as the password!?!?!
> If those don't work post the output of:
>
> $ mysql -u root -p mysql
> mysql>SELECT host, user, password, select_priv FROM user;
mysql> SELECT host, user, password, select_priv FROM user;
+-----------+------------------+-------------------------------------------+-------------+
| host | user | password | select_priv |
+-----------+------------------+-------------------------------------------+-------------+
| localhost | root |
*62342D54FD9B128B41AF87CC8133ECDC8D8D3EA3 | Y |
| MythBox | root | | Y |
| 127.0.0.1 | root | | Y |
| localhost | | | N |
| localhost | debian-sys-maint |
*E70FD7D9D21BEC5D5D6800B84C6C8DBE602A1195 | Y |
| localhost | mythtv |
*CC8F35F587CA5A556B4132C2407E556D92172FFC | Y |
| % | mythtv |
*CC8F35F587CA5A556B4132C2407E556D92172FFC | Y |
| localhost | torrentflux |
*58AD98AB94E879529879F11472FC0B07B311264D | N |
+-----------+------------------+-------------------------------------------+-------------+
8 rows in set (0.00 sec)
> and
>
> mysql>SELECT host, db, user, select_priv FROM db;
mysql> SELECT host, db, user, select_priv FROM db;
+-----------+-------------+-------------+-------------+
| host | db | user | select_priv |
+-----------+-------------+-------------+-------------+
| % | test | | Y |
| % | test\_% | | Y |
| localhost | mythconverg | mythtv | Y |
| % | mythconverg | mythtv | Y |
| localhost | torrentflux | torrentflux | Y |
+-----------+-------------+-------------+-------------+
5 rows in set (0.00 sec)
> --
> Regards, Jason
I don't know what's going on, but my brain is hurting.
I could well have changed files I shouldn't have changed or not changed
something back properly. I don't know any more. The one thing I do know
is that I have never set a password for anything ever that was 'mythtv'.
I use KeePass to generate secure passwords for everything I use. Has the
Ubuntu upgrade done something stupid like that?
It's 4.20am here now. Need some sleep.
Thanks for everyone's help.
I may look at backing up the database, getting rid of everything and
hoping that I can restore the recordings of family footage and my tv
work. This system is starting to feel too messed up.
Damian
More information about the mythtv-users
mailing list