1 |
On Sun, 2006-01-08 at 12:46 -0800, Mark Knecht wrote: |
2 |
> On 1/8/06, Michael Sullivan <michael@××××××××××××.com> wrote: |
3 |
> > On Sun, 2006-01-08 at 13:41 -0600, Michael Sullivan wrote: |
4 |
> > > On Sun, 2006-01-08 at 13:36 -0600, Michael Sullivan wrote: |
5 |
> > > > On Sun, 2006-01-08 at 11:22 -0800, Mark Knecht wrote: |
6 |
> > > > > On 1/8/06, Michael Sullivan <michael@××××××××××××.com> wrote: |
7 |
> > > > > |
8 |
> > > > > > I'm not going to mark my mythtv problem SOLVED until I'm sure that |
9 |
> > > > > > mythbackend is running stably. |
10 |
> > > > > |
11 |
> > > > > Nor should you... |
12 |
> > > > > |
13 |
> > > > > > It seems to be working for now. The |
14 |
> > > > > > problem is that I can't change channels in mythfrontend. I'm watching |
15 |
> > > > > > live TV and I'm hitting the Up arrow key (as specified on mythtv's web |
16 |
> > > > > > site, but the channel is not changing. What's worse is that it seems |
17 |
> > > > > > all that's on the one channel I get is infomercials! How can I fix |
18 |
> > > > > > this??? I ran mythsetup and and went to the Channel Editor. There were |
19 |
> > > > > > no channels defined. I wanted the click the Scan For Channels button, |
20 |
> > > > > > but I couldn't figure out how to get to it. Also, (I think it was in |
21 |
> > > > > > mythfrontend) I set the GUI to appear in a window instead of full |
22 |
> > > > > > screen. It turned out to be not what I wanted and now I can't find the |
23 |
> > > > > > option to get the full screen mode back. Help! |
24 |
> > > > > |
25 |
> > > > > After running mythsetup you then run mythfilldatabase. You should see |
26 |
> > > > > it logging into Zap2It and getting the channel data for the next 2 |
27 |
> > > > > weeks. Is this working for you? |
28 |
> > > > > |
29 |
> > > > > When I hit the up arrow I do get a new channel. I can also just type |
30 |
> > > > > in a channel number and jump that way. I see no mention in the |
31 |
> > > > > mythbackend.log file that much happened. THere are a coupl eof lines |
32 |
> > > > > but they aren't very interesting and I doubt thay had anything to do |
33 |
> > > > > with this at all. More likely when I started the frontend on my PC. |
34 |
> > > > > |
35 |
> > > > > 2006-01-08 11:16:59.814 adding: lightning as a client (events: 0) |
36 |
> > > > > 2006-01-08 11:16:59.911 adding: lightning as a client (events: 1) |
37 |
> > > > > 2006-01-08 11:16:59.934 adding: lightning as a client (events: 0) |
38 |
> > > > > 2006-01-08 11:16:59.994 adding: lightning as a client (events: 0) |
39 |
> > > > > 2006-01-08 11:17:00.018 adding: lightning as a remote ringbuffer |
40 |
> > > > > |
41 |
> > > > > - Mark |
42 |
> > > > > |
43 |
> > > > |
44 |
> > > > After I ran mythfilldatabase for the umpteenth time I got a channel |
45 |
> > > > listing in the Channel Editor. Next, I want to get mythfrontend working |
46 |
> > > > on my wife's computer. It will need to use the database and mythbackend |
47 |
> > > > on my computer remotely. Is there anything special I need to know to |
48 |
> > > > make this work? I've already set up the IP address in mythsetup on my |
49 |
> > > > machine to my PC's network address... |
50 |
> > > |
51 |
> > > I ssh'd over to my wife's machine and tried running mythfrontend. |
52 |
> > > Apparently it can't connect to my mysql server. I added two lines to |
53 |
> > > the end of my /etc/mysql/my.cnf file last night that was supposed to fix |
54 |
> > > this: |
55 |
> > > |
56 |
> > > skip-innodb |
57 |
> > > set-variable=thread_stack=256k |
58 |
> > > |
59 |
> > > but I guess it didn't... |
60 |
> > |
61 |
> > I changed the bind-address option in my PC's /etc/mysql/my.cnf file from |
62 |
> > "127.0.0.1" to "0.0.0.0" and restarted mysql. |
63 |
> |
64 |
> 0.0.0.0 is unroutable. You need to put in the actual IP address of |
65 |
> your backend server. As I said in a previous email that is |
66 |
> 192.168.1.55 for our setup here. |
67 |
> |
68 |
> |
69 |
> I then tried to run |
70 |
> > mythfrontend from my wife's PC in an ssh environment. I got a lot of |
71 |
> > errors that were copies of this: |
72 |
> > |
73 |
> > 2006-01-08 14:19:51.309 Unable to connect to database! |
74 |
> > 2006-01-08 14:19:51.309 Driver error was [1/1130]: |
75 |
> > QMYSQL3: Unable to connect |
76 |
> > Database error was: |
77 |
> > Host 'catherine.espersunited.com' is not allowed to connect to this |
78 |
> > MySQL server |
79 |
> |
80 |
> this is because you have not run the commands that I showed you where |
81 |
> you allow network clients have access to MySQL. This is pointed out in |
82 |
> the link I sent you earlier. |
83 |
> |
84 |
> Note: I do not run the frontend client through an ssh tunnel. I have |
85 |
> the frontend only on all our machines. My fronteld client points at |
86 |
> the server's IP address. (192.168.1.55) The mysql database on the |
87 |
> server is set up to allow network access. The frontend client talks to |
88 |
> it and only the video runs across the network. |
89 |
> |
90 |
> > |
91 |
> > catherine is my wife's computer, located at 192.168.1.4 My computer is |
92 |
> > camille, at 192.168.1.3 When I tried to telnet into my mysql server, I |
93 |
> > got the same message: |
94 |
> > |
95 |
> > catherine ~ # telnet camille 3306 |
96 |
> > Trying 192.168.1.3... |
97 |
> > Connected to camille. |
98 |
> > Escape character is '^]'. |
99 |
> > SHost 'catherine.espersunited.com' is not allowed to connect to this |
100 |
> > MySQL serverConnection closed by foreign host. |
101 |
> > |
102 |
> > How do I fix this? I had a similar problem a long time ago and as far |
103 |
> > as I can tell it was fixed by changing the mysql server's bind-address |
104 |
> > to 0.0.0.0. That didn't work this time. BTW, I'm using mysql version |
105 |
> > 4.1.14... |
106 |
> |
107 |
> As I said earlier, follow the instructions on the link I gave you to |
108 |
> give network access to the mysql database. |
109 |
> |
110 |
> - Mark |
111 |
> |
112 |
|
113 |
What instructions? Are you referring to the GRANT line? I did that |
114 |
yesterday. As for the mythbackend server IP, I set that two or three |
115 |
days ago. It's in the database correctly: |
116 |
|
117 |
mysql> select * from settings WHERE value = 'BackendServerIP'; |
118 |
+-----------------+-------------+----------+ |
119 |
| value | data | hostname | |
120 |
+-----------------+-------------+----------+ |
121 |
| BackendServerIP | 192.168.1.3 | camille | |
122 |
+-----------------+-------------+----------+ |
123 |
1 row in set (0.00 sec) |
124 |
|
125 |
What else do I need to do? |
126 |
|
127 |
-- |
128 |
gentoo-user@g.o mailing list |