From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.54) id 1EvjHj-0004BS-JY for garchives@archives.gentoo.org; Sun, 08 Jan 2006 22:45:12 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id k08MhFI7013646; Sun, 8 Jan 2006 22:43:15 GMT Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id k08MeuY4022952 for ; Sun, 8 Jan 2006 22:40:57 GMT Received: by zproxy.gmail.com with SMTP id o37so4627842nzf for ; Sun, 08 Jan 2006 14:40:56 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=V5nyeKSegRO/bOhi0wvpa6v6b5uGsysnFvlZY6g0jKjXWaH4z8u2YBQQXs69YLz2xYqvduVJOJlaQYiZ8K+ntdEDl/HUx6CgFvmpJurGO0DfpL13zQj9lFt9U1P8ngJvvvJtLjsOu8lVsCHkEClJpati7Lzg8JJChZrF5L9B4cE= Received: by 10.64.143.7 with SMTP id q7mr2261417qbd; Sun, 08 Jan 2006 14:40:56 -0800 (PST) Received: by 10.65.163.16 with HTTP; Sun, 8 Jan 2006 14:40:56 -0800 (PST) Message-ID: <5bdc1c8b0601081440n4dbaeaaexa5a32d4b14f78f23@mail.gmail.com> Date: Sun, 8 Jan 2006 14:40:56 -0800 From: Mark Knecht To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] OT - mysql (WAS: [Re: OT - Need help with mythfronted GUI]) In-Reply-To: <1136758818.9839.46.camel@camille.espersunited.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <1135878795.9187.17.camel@camille.espersunited.com> <1136747428.9839.20.camel@camille.espersunited.com> <5bdc1c8b0601081122t36ea0bcn99987383a4d59ce3@mail.gmail.com> <1136749004.9839.24.camel@camille.espersunited.com> <1136749283.9803.28.camel@camille.espersunited.com> <1136752137.9838.36.camel@camille.espersunited.com> <5bdc1c8b0601081246p6735ba5er2a351c1c9ab283c4@mail.gmail.com> <1136754802.9839.40.camel@camille.espersunited.com> <5bdc1c8b0601081354r431b8cc2p9bab4463e0e4cd0e@mail.gmail.com> <1136758818.9839.46.camel@camille.espersunited.com> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by robin.gentoo.org id k08MeuY4022952 X-Archives-Salt: f40e7d78-1dfd-4761-841e-bd04465217f2 X-Archives-Hash: 22a3438a9d181924842921e5a14cb943 > > 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