[mythtv-users] Cannot get the backend to run

[Jarom McDonald]

If you're doing it from the command line, try these steps.

1) Log in to the mysql shell as root with this command:

mysql -u root -p

2) Enter the mysql root password when prompted

3) Select the mysql table with this command:

use mysql

4) Query the user table with this command (don't forget the semicolon on the
end of the query):

SELECT user,host FROM user;

5) If you don't have a row that has "mythtv" in the user column and either
"macMini" or "%" (the mysql wildcard) in the host column, you can create
that user with this command:

CREATE USER mythtv at macMini IDENTIFIED BY [whatever password your mysql.txt
or config.xml file uses]

6) Grant that user permissions to use the mythconverg DB with this command:

GRANT ALL on mythconverg.* TO mythtv at macMini

7) Flush privileges

Of course, all of this raises a very important question that smarter people
than I will have to address ... why, when the backend or mythtv-setup is
trying to start, is it trying to connect to the hostname macMini rather than
localhost? That's really the root of the problems (it's not something I've
seen before...my backend just connects with mythtv at localhost), and may have
to eventually be addressed if you're ever planning on adding additional
backends or frontends. I take it this is actually installed on a macMini? If
so, is it on OS X or did you install linux onto your Mini? I guess it's
possible that, if you're actually running it on OS X, there's something with
how that OS handles hostnames that is messing with Myth...

I hope this helps in any way.

Best,
Jarom

On Fri, May 22, 2009 at 4:33 PM, Mark Knecht <markknecht at gmail.com> wrote:

> On Fri, May 22, 2009 at 3:26 PM, Jarom McDonald <jarom_mcdonald at byu.edu>
> wrote:
> > The one piece of information you haven't provided yet are the details of
> > your mysql user tables on the non-working and the working servers.
> Remember
> > that a mysql user is a combination of a username and a hostname, so
> > mythtv at localhost and mythtv at macMini and mythtv at 192.168.1.61 are 3
> separate
> > users (even if, on the OS level, they all resolve to each other). The
> error
> > message you're getting on MacMini is not a Myth error, but a MySQL error
> > telling you that the mythtv at macMini user has been denied access. There
> are
> > only three reasons for this: 1) mysql isn't configured to accept any
> users
> > not from the 'localhost' host, 2) the password in mysql.txt isn't
> > corresponding with the password in the mysql tables, or 3) the
> mysql at macMini
> > user doesn't even exist.
> >
> > You've ruled out 1 and 2, but haven't ruled out 3. In your mysql user
> table,
> > ("SELECT user,host FROM user") you have a mythtv at localhost (evident from
> > your very first message that let you connect), and you have a
> > mythtv at 192.168.1.61 (that was created when you did the GRANT statement),
> but
> > you should check to see if you have a mythtv at macMini, and that ITS
> password
> > is properly set, since that's the user that mythbackend is trying to
> connect
> > with. You could just do:
> >
> > GRANT ALL on mythconverg.* to mythtv at macMini IDENTIFIED BY "[password]"
> >
> > just as you did with the user that has the ip address as the hostname, to
> > insure that the user exists with the right password.
> >
> > If THAT fails, then I don't know what to say ... there could be some
> > corruption in the mysql user tables. You could delete all users and
> > re-create them, I suppose, or drop the DBs and reinstall mysql (you did
> say
> > this was a new server, correct?)
> >
> > Jarom
> >
>
> Jarom,
>   It is a completely new server with no recordings. I'm free to do
> anything. I'll be using my HD Homerun with this server and taking the
> older PVR-150 server out of service as Comcast ramps down analog
> transmission.
>
>   I'm completely happy to remove every database and start over if it
> makes a difference. That way at least there shouldn't be so many
> questions about what's been done to the database.
>
>   What is the actual command I use in mysql to check this? I'd like
> to check before I issue a new GRANT ALL. I think I'd learn something
> important.
>
>   I suspect that mythtv at macmini has not been accounted for.
>
> - Mark
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090522/11c7471c/attachment-0001.htm>