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

[Michael Sullivan <michael@espersunited.com>]

On Sun, 2006-01-08 at 13:54 -0800, Mark Knecht wrote:
> On 1/8/06, Michael Sullivan <michael@espersunited.com> wrote:
> > On Sun, 2006-01-08 at 12:46 -0800, Mark Knecht wrote:
> > > 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
> > >
> >
> > 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