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

[Mark Knecht <markknecht@gmail.com>]

On 1/8/06, Michael Sullivan <michael@espersunited.com> 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 <michael@espersunited.com> 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 '^]'.
> S\x04Host '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