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

[Michael Sullivan]

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@××××××××××××.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.  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@g.o mailing list