Re: [gentoo-user] OT - mysql (WAS: [Re: OT - Need help with mythfronted GUI])

[Mark Knecht <markknecht@gmail.com>]

>
> OK.  I went to my terminal on catherine and put in the line you
> suggested.  Here's the output:
>
> catherine ~ # mysql -u mythtv -h 192.168.1.3 -p mythconverg
> Enter password:
> ERROR 1130 (00000): Host 'catherine.espersunited.com' is not allowed to
> connect to this MySQL server

This suggests that the mythconverge database hasn't been properly
modified with the GRANT ALL  command we talked about earlier.

One other possibility I found from rereading somuch of the painful
thread I created 9 months ago was that I did have to restart mysql
after doing the GRANT commands. DId you do that on the backend
machine?

/etc/init.d/mysql restart

>
> However, when I try it on camille it doesn't work either, unless I
> remove the host entry:
>
> michael@camille ~ $ mysql -u mythtv -h 192.168.1.3 -p mythconverg

Would it allow

mysql -u mythtv -h localhost -p mythconverg


> Enter password:
> ERROR 1130 (00000): Host 'camille.espersunited.com' is not allowed to
> connect to this MySQL server

Ah....one other possibility I remember running into was that
camille.espersunited.com is NOT the same as camille. mysql was VERY
picky about names in my hosts file, etc.


> michael@camille ~ $ mysql -u mythtv -p mythconverg

Yes, this command does not attempt to bind over the network. (I
think....don't trust me!!)


> The correct address IS in my.cnf:
>
> michael@camille ~ $ cat /etc/mysql/my.cnf | grep 'bind-address'
> bind-address                            = 192.168.1.3
> michael@camille ~ $ cat /etc/mysql/my.cnf | grep 'port'
> port                                            = 3306
> [mysqlimport]
> port                                            = 3306
>
> So why can't I connect with the IP address?  Mythsetup already has
> 192.168.1.3 as the address of the backend server...
>

This is so similar to what I stuggled with for weeks. I think you're
very close if we can just find the trick. Definately try restarting at
least mysql and also mythbackend:

/etc/init.d/mythbackend stop
/etc/init.d/mythbackend status
/etc/init'd/mysql restart
/etc/init.d/mythbackend start
/etc/init.d/mythbackend status

Don't totally trust the Gentoo scripts to do this right. They may work
or they may not. I remember last year having some troubles with the
scripts and getting better results being very specific about what I
wanted to happen.

- Mark

-- 
gentoo-user@gentoo.org mailing list