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 1Evj0y-0004GR-At for garchives@archives.gentoo.org; Sun, 08 Jan 2006 22:27:53 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id k08MOkpM031785; Sun, 8 Jan 2006 22:24:46 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 k08MKIdA023204 for ; Sun, 8 Jan 2006 22:20:19 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 k08MKIot002256 for ; Sun, 8 Jan 2006 16:20:18 -0600 Subject: Re: [gentoo-user] OT - mysql (WAS: [Re: OT - Need help with mythfronted GUI]) From: Michael Sullivan To: gentoo-user@lists.gentoo.org In-Reply-To: <5bdc1c8b0601081354r431b8cc2p9bab4463e0e4cd0e@mail.gmail.com> References: <1135878795.9187.17.camel@camille.espersunited.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> <5bdc1c8b0601081246p6735ba5er2a351c1c9ab283c4@mail.gmail.com> <1136754802.9839.40.camel@camille.espersunited.com> <5bdc1c8b0601081354r431b8cc2p9bab4463e0e4cd0e@mail.gmail.com> Content-Type: text/plain Date: Sun, 08 Jan 2006 16:20:17 -0600 Message-Id: <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 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-Archives-Salt: d43feca2-8e2e-4ac8-850d-36d6ed16e141 X-Archives-Hash: fb9df037082c2cb87ead4608891150c6 On Sun, 2006-01-08 at 13:54 -0800, Mark Knecht wrote: > On 1/8/06, Michael Sullivan wrote: > > On Sun, 2006-01-08 at 12:46 -0800, Mark Knecht wrote: > > > 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 > > > > > > > What instructions? Are you referring to the GRANT line? I did that > > yesterday. As for the mythbackend server IP, I set that two or three > > days ago. It's in the database correctly: > > > > mysql> select * from settings WHERE value = 'BackendServerIP'; > > +-----------------+-------------+----------+ > > | value | data | hostname | > > +-----------------+-------------+----------+ > > | BackendServerIP | 192.168.1.3 | camille | > > +-----------------+-------------+----------+ > > 1 row in set (0.00 sec) > > > > What else do I need to do? > > Again, I'm not that good on this stuff but it's this basic command: > > The specific grant command is this one, or something like it: > > % mysql -u root -p > mysql> GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'remotehost' > IDENTIFIED BY 'password' > > Before you do that make sure you have camille's address in /etc/mysql/my.cnf: > > # keep secure by default! > bind-address = 192.168.1.3 > port = 3306 > # this can make it even more secure: > > Make sure you have 192.168.1.3 in the mythsetup stuff for the server. > > At this point you should try logging into the mysql server from a > terminal on both the server and your wife's machine. If you cannot log > in then neither can Myth. From my terminal on a frontend only PC: > (default password was mythtv on my system) > > dragonfly ~ # mysql -u mythtv -h 192.168.1.55 -p mythconverg > Enter password: > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 123 to server version: 4.0.25 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> exit > Bye > dragonfly ~ # > > Hope this helps, > Mark > 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 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 Enter password: ERROR 1130 (00000): Host 'camille.espersunited.com' is not allowed to connect to this MySQL server michael@camille ~ $ mysql -u mythtv -p mythconverg Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.1.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye 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... -- gentoo-user@gentoo.org mailing list