1 |
On Sun, 2006-01-08 at 13:54 -0800, Mark Knecht wrote: |
2 |
> On 1/8/06, Michael Sullivan <michael@××××××××××××.com> wrote: |
3 |
> > On Sun, 2006-01-08 at 12:46 -0800, Mark Knecht wrote: |
4 |
> > > On 1/8/06, Michael Sullivan <michael@××××××××××××.com> wrote: |
5 |
> > > > On Sun, 2006-01-08 at 13:41 -0600, Michael Sullivan wrote: |
6 |
> > > > > On Sun, 2006-01-08 at 13:36 -0600, Michael Sullivan wrote: |
7 |
> > > > > > On Sun, 2006-01-08 at 11:22 -0800, Mark Knecht wrote: |
8 |
> > > > > > > On 1/8/06, Michael Sullivan <michael@××××××××××××.com> wrote: |
9 |
> > > > > > > |
10 |
> > > > > > > > I'm not going to mark my mythtv problem SOLVED until I'm sure that |
11 |
> > > > > > > > mythbackend is running stably. |
12 |
> > > > > > > |
13 |
> > > > > > > Nor should you... |
14 |
> > > > > > > |
15 |
> > > > > > > > It seems to be working for now. The |
16 |
> > > > > > > > problem is that I can't change channels in mythfrontend. I'm watching |
17 |
> > > > > > > > live TV and I'm hitting the Up arrow key (as specified on mythtv's web |
18 |
> > > > > > > > site, but the channel is not changing. What's worse is that it seems |
19 |
> > > > > > > > all that's on the one channel I get is infomercials! How can I fix |
20 |
> > > > > > > > this??? I ran mythsetup and and went to the Channel Editor. There were |
21 |
> > > > > > > > no channels defined. I wanted the click the Scan For Channels button, |
22 |
> > > > > > > > but I couldn't figure out how to get to it. Also, (I think it was in |
23 |
> > > > > > > > mythfrontend) I set the GUI to appear in a window instead of full |
24 |
> > > > > > > > screen. It turned out to be not what I wanted and now I can't find the |
25 |
> > > > > > > > option to get the full screen mode back. Help! |
26 |
> > > > > > > |
27 |
> > > > > > > After running mythsetup you then run mythfilldatabase. You should see |
28 |
> > > > > > > it logging into Zap2It and getting the channel data for the next 2 |
29 |
> > > > > > > weeks. Is this working for you? |
30 |
> > > > > > > |
31 |
> > > > > > > When I hit the up arrow I do get a new channel. I can also just type |
32 |
> > > > > > > in a channel number and jump that way. I see no mention in the |
33 |
> > > > > > > mythbackend.log file that much happened. THere are a coupl eof lines |
34 |
> > > > > > > but they aren't very interesting and I doubt thay had anything to do |
35 |
> > > > > > > with this at all. More likely when I started the frontend on my PC. |
36 |
> > > > > > > |
37 |
> > > > > > > 2006-01-08 11:16:59.814 adding: lightning as a client (events: 0) |
38 |
> > > > > > > 2006-01-08 11:16:59.911 adding: lightning as a client (events: 1) |
39 |
> > > > > > > 2006-01-08 11:16:59.934 adding: lightning as a client (events: 0) |
40 |
> > > > > > > 2006-01-08 11:16:59.994 adding: lightning as a client (events: 0) |
41 |
> > > > > > > 2006-01-08 11:17:00.018 adding: lightning as a remote ringbuffer |
42 |
> > > > > > > |
43 |
> > > > > > > - Mark |
44 |
> > > > > > > |
45 |
> > > > > > |
46 |
> > > > > > After I ran mythfilldatabase for the umpteenth time I got a channel |
47 |
> > > > > > listing in the Channel Editor. Next, I want to get mythfrontend working |
48 |
> > > > > > on my wife's computer. It will need to use the database and mythbackend |
49 |
> > > > > > on my computer remotely. Is there anything special I need to know to |
50 |
> > > > > > make this work? I've already set up the IP address in mythsetup on my |
51 |
> > > > > > machine to my PC's network address... |
52 |
> > > > > |
53 |
> > > > > I ssh'd over to my wife's machine and tried running mythfrontend. |
54 |
> > > > > Apparently it can't connect to my mysql server. I added two lines to |
55 |
> > > > > the end of my /etc/mysql/my.cnf file last night that was supposed to fix |
56 |
> > > > > this: |
57 |
> > > > > |
58 |
> > > > > skip-innodb |
59 |
> > > > > set-variable=thread_stack=256k |
60 |
> > > > > |
61 |
> > > > > but I guess it didn't... |
62 |
> > > > |
63 |
> > > > I changed the bind-address option in my PC's /etc/mysql/my.cnf file from |
64 |
> > > > "127.0.0.1" to "0.0.0.0" and restarted mysql. |
65 |
> > > |
66 |
> > > 0.0.0.0 is unroutable. You need to put in the actual IP address of |
67 |
> > > your backend server. As I said in a previous email that is |
68 |
> > > 192.168.1.55 for our setup here. |
69 |
> > > |
70 |
> > > |
71 |
> > > I then tried to run |
72 |
> > > > mythfrontend from my wife's PC in an ssh environment. I got a lot of |
73 |
> > > > errors that were copies of this: |
74 |
> > > > |
75 |
> > > > 2006-01-08 14:19:51.309 Unable to connect to database! |
76 |
> > > > 2006-01-08 14:19:51.309 Driver error was [1/1130]: |
77 |
> > > > QMYSQL3: Unable to connect |
78 |
> > > > Database error was: |
79 |
> > > > Host 'catherine.espersunited.com' is not allowed to connect to this |
80 |
> > > > MySQL server |
81 |
> > > |
82 |
> > > this is because you have not run the commands that I showed you where |
83 |
> > > you allow network clients have access to MySQL. This is pointed out in |
84 |
> > > the link I sent you earlier. |
85 |
> > > |
86 |
> > > Note: I do not run the frontend client through an ssh tunnel. I have |
87 |
> > > the frontend only on all our machines. My fronteld client points at |
88 |
> > > the server's IP address. (192.168.1.55) The mysql database on the |
89 |
> > > server is set up to allow network access. The frontend client talks to |
90 |
> > > it and only the video runs across the network. |
91 |
> > > |
92 |
> > > > |
93 |
> > > > catherine is my wife's computer, located at 192.168.1.4 My computer is |
94 |
> > > > camille, at 192.168.1.3 When I tried to telnet into my mysql server, I |
95 |
> > > > got the same message: |
96 |
> > > > |
97 |
> > > > catherine ~ # telnet camille 3306 |
98 |
> > > > Trying 192.168.1.3... |
99 |
> > > > Connected to camille. |
100 |
> > > > Escape character is '^]'. |
101 |
> > > > SHost 'catherine.espersunited.com' is not allowed to connect to this |
102 |
> > > > MySQL serverConnection closed by foreign host. |
103 |
> > > > |
104 |
> > > > How do I fix this? I had a similar problem a long time ago and as far |
105 |
> > > > as I can tell it was fixed by changing the mysql server's bind-address |
106 |
> > > > to 0.0.0.0. That didn't work this time. BTW, I'm using mysql version |
107 |
> > > > 4.1.14... |
108 |
> > > |
109 |
> > > As I said earlier, follow the instructions on the link I gave you to |
110 |
> > > give network access to the mysql database. |
111 |
> > > |
112 |
> > > - Mark |
113 |
> > > |
114 |
> > |
115 |
> > What instructions? Are you referring to the GRANT line? I did that |
116 |
> > yesterday. As for the mythbackend server IP, I set that two or three |
117 |
> > days ago. It's in the database correctly: |
118 |
> > |
119 |
> > mysql> select * from settings WHERE value = 'BackendServerIP'; |
120 |
> > +-----------------+-------------+----------+ |
121 |
> > | value | data | hostname | |
122 |
> > +-----------------+-------------+----------+ |
123 |
> > | BackendServerIP | 192.168.1.3 | camille | |
124 |
> > +-----------------+-------------+----------+ |
125 |
> > 1 row in set (0.00 sec) |
126 |
> > |
127 |
> > What else do I need to do? |
128 |
> |
129 |
> Again, I'm not that good on this stuff but it's this basic command: |
130 |
> |
131 |
> The specific grant command is this one, or something like it: |
132 |
> |
133 |
> % mysql -u root -p |
134 |
> mysql> GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'remotehost' |
135 |
> IDENTIFIED BY 'password' |
136 |
> |
137 |
> Before you do that make sure you have camille's address in /etc/mysql/my.cnf: |
138 |
> |
139 |
> # keep secure by default! |
140 |
> bind-address = 192.168.1.3 |
141 |
> port = 3306 |
142 |
> # this can make it even more secure: |
143 |
> |
144 |
> Make sure you have 192.168.1.3 in the mythsetup stuff for the server. |
145 |
> |
146 |
> At this point you should try logging into the mysql server from a |
147 |
> terminal on both the server and your wife's machine. If you cannot log |
148 |
> in then neither can Myth. From my terminal on a frontend only PC: |
149 |
> (default password was mythtv on my system) |
150 |
> |
151 |
> dragonfly ~ # mysql -u mythtv -h 192.168.1.55 -p mythconverg |
152 |
> Enter password: |
153 |
> Reading table information for completion of table and column names |
154 |
> You can turn off this feature to get a quicker startup with -A |
155 |
> |
156 |
> Welcome to the MySQL monitor. Commands end with ; or \g. |
157 |
> Your MySQL connection id is 123 to server version: 4.0.25 |
158 |
> |
159 |
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. |
160 |
> |
161 |
> mysql> exit |
162 |
> Bye |
163 |
> dragonfly ~ # |
164 |
> |
165 |
> Hope this helps, |
166 |
> Mark |
167 |
> |
168 |
|
169 |
OK. I went to my terminal on catherine and put in the line you |
170 |
suggested. Here's the output: |
171 |
|
172 |
catherine ~ # mysql -u mythtv -h 192.168.1.3 -p mythconverg |
173 |
Enter password: |
174 |
ERROR 1130 (00000): Host 'catherine.espersunited.com' is not allowed to |
175 |
connect to this MySQL server |
176 |
|
177 |
However, when I try it on camille it doesn't work either, unless I |
178 |
remove the host entry: |
179 |
|
180 |
michael@camille ~ $ mysql -u mythtv -h 192.168.1.3 -p mythconverg |
181 |
Enter password: |
182 |
ERROR 1130 (00000): Host 'camille.espersunited.com' is not allowed to |
183 |
connect to this MySQL server |
184 |
michael@camille ~ $ mysql -u mythtv -p mythconverg |
185 |
Enter password: |
186 |
Reading table information for completion of table and column names |
187 |
You can turn off this feature to get a quicker startup with -A |
188 |
|
189 |
Welcome to the MySQL monitor. Commands end with ; or \g. |
190 |
Your MySQL connection id is 4 to server version: 4.1.14-log |
191 |
|
192 |
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. |
193 |
|
194 |
mysql> quit |
195 |
Bye |
196 |
|
197 |
The correct address IS in my.cnf: |
198 |
|
199 |
michael@camille ~ $ cat /etc/mysql/my.cnf | grep 'bind-address' |
200 |
bind-address = 192.168.1.3 |
201 |
michael@camille ~ $ cat /etc/mysql/my.cnf | grep 'port' |
202 |
port = 3306 |
203 |
[mysqlimport] |
204 |
port = 3306 |
205 |
|
206 |
So why can't I connect with the IP address? Mythsetup already has |
207 |
192.168.1.3 as the address of the backend server... |
208 |
|
209 |
|
210 |
|
211 |
-- |
212 |
gentoo-user@g.o mailing list |