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 1EvhHW-0002U8-HR for garchives@archives.gentoo.org; Sun, 08 Jan 2006 20:36:50 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id k08KXIat012907; Sun, 8 Jan 2006 20:33:18 GMT Received: from bullet.espersunited.com (24-117-226-93.cpe.cableone.net [24.117.226.93]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id k08KSwSg025866 for ; Sun, 8 Jan 2006 20:28:58 GMT Received: from camille.espersunited.com (camille.espersunited.com [192.168.1.3]) by bullet.espersunited.com (8.13.4/8.13.3) with ESMTP id k08KSvcm001788 for ; Sun, 8 Jan 2006 14:28:57 -0600 Subject: [gentoo-user] OT - mysql (WAS: [Re: OT - Need help with mythfronted GUI]) From: Michael Sullivan To: gentoo-user@lists.gentoo.org In-Reply-To: <1136749283.9803.28.camel@camille.espersunited.com> References: <1135878795.9187.17.camel@camille.espersunited.com> <20060101192012.7dce0470@chi.speakeasy.net> <1136680929.9948.4.camel@camille.espersunited.com> <20060107195002.7f9200f9@chi.speakeasy.net> <1136697447.10009.2.camel@camille.espersunited.com> <20060108085031.5e850782@chi.speakeasy.net> <5bdc1c8b0601080932u2edb0562xdad5c8e0c5abd238@mail.gmail.com> <1136742815.9839.0.camel@camille.espersunited.com> <5bdc1c8b0601081018x5dd916cw106d03ffd6632f42@mail.gmail.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> Content-Type: text/plain Date: Sun, 08 Jan 2006 14:28:57 -0600 Message-Id: <1136752137.9838.36.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 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-Archives-Salt: de817336-9a4f-41bb-9583-2004643a6868 X-Archives-Hash: c8ac0b4f03fc3533fda20ee08245a179 On Sun, 2006-01-08 at 13:41 -0600, Michael Sullivan wrote: > On Sun, 2006-01-08 at 13:36 -0600, Michael Sullivan wrote: > > On Sun, 2006-01-08 at 11:22 -0800, Mark Knecht wrote: > > > On 1/8/06, Michael Sullivan wrote: > > > > > > > I'm not going to mark my mythtv problem SOLVED until I'm sure that > > > > mythbackend is running stably. > > > > > > Nor should you... > > > > > > > It seems to be working for now. The > > > > problem is that I can't change channels in mythfrontend. I'm watching > > > > live TV and I'm hitting the Up arrow key (as specified on mythtv's web > > > > site, but the channel is not changing. What's worse is that it seems > > > > all that's on the one channel I get is infomercials! How can I fix > > > > this??? I ran mythsetup and and went to the Channel Editor. There were > > > > no channels defined. I wanted the click the Scan For Channels button, > > > > but I couldn't figure out how to get to it. Also, (I think it was in > > > > mythfrontend) I set the GUI to appear in a window instead of full > > > > screen. It turned out to be not what I wanted and now I can't find the > > > > option to get the full screen mode back. Help! > > > > > > After running mythsetup you then run mythfilldatabase. You should see > > > it logging into Zap2It and getting the channel data for the next 2 > > > weeks. Is this working for you? > > > > > > When I hit the up arrow I do get a new channel. I can also just type > > > in a channel number and jump that way. I see no mention in the > > > mythbackend.log file that much happened. THere are a coupl eof lines > > > but they aren't very interesting and I doubt thay had anything to do > > > with this at all. More likely when I started the frontend on my PC. > > > > > > 2006-01-08 11:16:59.814 adding: lightning as a client (events: 0) > > > 2006-01-08 11:16:59.911 adding: lightning as a client (events: 1) > > > 2006-01-08 11:16:59.934 adding: lightning as a client (events: 0) > > > 2006-01-08 11:16:59.994 adding: lightning as a client (events: 0) > > > 2006-01-08 11:17:00.018 adding: lightning as a remote ringbuffer > > > > > > - Mark > > > > > > > After I ran mythfilldatabase for the umpteenth time I got a channel > > listing in the Channel Editor. Next, I want to get mythfrontend working > > on my wife's computer. It will need to use the database and mythbackend > > on my computer remotely. Is there anything special I need to know to > > make this work? I've already set up the IP address in mythsetup on my > > machine to my PC's network address... > > I ssh'd over to my wife's machine and tried running mythfrontend. > Apparently it can't connect to my mysql server. I added two lines to > the end of my /etc/mysql/my.cnf file last night that was supposed to fix > this: > > skip-innodb > set-variable=thread_stack=256k > > but I guess it didn't... I changed the bind-address option in my PC's /etc/mysql/my.cnf file from "127.0.0.1" to "0.0.0.0" and restarted mysql. I then tried to run mythfrontend from my wife's PC in an ssh environment. I got a lot of errors that were copies of this: 2006-01-08 14:19:51.309 Unable to connect to database! 2006-01-08 14:19:51.309 Driver error was [1/1130]: QMYSQL3: Unable to connect Database error was: Host 'catherine.espersunited.com' is not allowed to connect to this MySQL server catherine is my wife's computer, located at 192.168.1.4 My computer is camille, at 192.168.1.3 When I tried to telnet into my mysql server, I got the same message: catherine ~ # telnet camille 3306 Trying 192.168.1.3... Connected to camille. Escape character is '^]'. SHost 'catherine.espersunited.com' is not allowed to connect to this MySQL serverConnection closed by foreign host. How do I fix this? I had a similar problem a long time ago and as far as I can tell it was fixed by changing the mysql server's bind-address to 0.0.0.0. That didn't work this time. BTW, I'm using mysql version 4.1.14... -- gentoo-user@gentoo.org mailing list