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 1EvhWU-0001U2-E0 for garchives@archives.gentoo.org; Sun, 08 Jan 2006 20:52:18 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id k08KoDUO013337; Sun, 8 Jan 2006 20:50:13 GMT Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.196]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id k08KkH2P005497 for ; Sun, 8 Jan 2006 20:46:18 GMT Received: by zproxy.gmail.com with SMTP id x7so3656786nzc for ; Sun, 08 Jan 2006 12:46:17 -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=eycNO557Hf2Ac4eW6IWgqf0wuFqE2uSkoPC7GgccCI4spCkM6Zxpenn/GIKgWuUFpzvpdjdZrV/otJrC+sziT848Q91niLA92t1ZTjiuBgYl6A9CHs9P5+uD4cFjI7GCOnHTUpl1+PuQLYqapX5rbc9iq/QSYCd0JYPPfOUGJZQ= Received: by 10.65.153.12 with SMTP id f12mr6906497qbo; Sun, 08 Jan 2006 12:46:17 -0800 (PST) Received: by 10.65.163.16 with HTTP; Sun, 8 Jan 2006 12:46:17 -0800 (PST) Message-ID: <5bdc1c8b0601081246p6735ba5er2a351c1c9ab283c4@mail.gmail.com> Date: Sun, 8 Jan 2006 12:46:17 -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: <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 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <1135878795.9187.17.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> <1136752137.9838.36.camel@camille.espersunited.com> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by robin.gentoo.org id k08KkH2P005497 X-Archives-Salt: 99ba0712-058c-4de8-87c6-d3909f645801 X-Archives-Hash: 3134497432f742673d44c89e3602ff9a On 1/8/06, Michael Sullivan wrote: > 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. 0.0.0.0 is unroutable. You need to put in the actual IP address of your backend server. As I said in a previous email that is 192.168.1.55 for our setup here. 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 this is because you have not run the commands that I showed you where you allow network clients have access to MySQL. This is pointed out in the link I sent you earlier. Note: I do not run the frontend client through an ssh tunnel. I have the frontend only on all our machines. My fronteld client points at the server's IP address. (192.168.1.55) The mysql database on the server is set up to allow network access. The frontend client talks to it and only the video runs across the network. > > 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... As I said earlier, follow the instructions on the link I gave you to give network access to the mysql database. - Mark -- gentoo-user@gentoo.org mailing list