Gentoo Archives: gentoo-user

From: Michael Sullivan <msulli1355@×××××.com>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] Mythtv problems
Date: Wed, 26 Oct 2011 23:01:53
Message-Id: 4EA890E6.40104@gmail.com
In Reply to: Re: [gentoo-user] Mythtv problems by Michael Schreckenbauer
1 On 10/26/11 17:53, Michael Schreckenbauer wrote:
2 > Am Mittwoch, 26. Oktober 2011, 17:42:14 schrieb Michael Sullivan:
3 >> On 10/26/11 17:32, Michael Schreckenbauer wrote:
4 >>> So you did run mysql_upgrade and same as before? Some words about what
5 >>> you did and some relevant output of the command (if any) wouldn't hurt
6 >>> ;) Have you tried mysql_fix_privilege_tables? After that, you would
7 >>> need to run the steps mentioned in the wiki again (I think), giving the
8 >>> password you entered in myth-setup to the UPDATE command.
9 >>>
10 >>> Best,
11 >>> Michael
12 >>
13 >> camille ~ # mysql_upgrade -p
14 >> Enter password:
15 >> Looking for 'mysql' as: mysql
16 >> Looking for 'mysqlcheck' as: mysqlcheck
17 >> Running 'mysqlcheck' with connection arguments: '--port=3306'
18 >> '--socket=/var/run/mysqld/mysqld.sock'
19 >> Failed to ALTER DATABASE `#mysql50#mythconverg.bak` UPGRADE DATA
20 >> DIRECTORY NAME
21 >> Error: Incorrect database name '#mysql50#mythconverg.bak'
22 >> Running 'mysqlcheck' with connection arguments: '--port=3306'
23 >> '--socket=/var/run/mysqld/mysqld.sock'
24 >> forum.phpbb_auth_access
25 >> error : Table upgrade required. Please do "REPAIR TABLE
26 >> `phpbb_auth_access`" or dump/reload to fix it!
27 >> forum.phpbb_banlist
28 >> error : Table upgrade required. Please do "REPAIR TABLE
29 >> `phpbb_banlist`" or dump/reload to fix it!
30 >> forum.phpbb_categories
31 >> error : Table upgrade required. Please do "REPAIR TABLE
32 >> `phpbb_categories`" or dump/reload to fix it!
33 >> forum.phpbb_config
34 >> error : Table upgrade required. Please do "REPAIR TABLE
35 >> `phpbb_config`" or dump/reload to fix it!
36 >> forum.phpbb_confirm
37 >> error : Table upgrade required. Please do "REPAIR TABLE
38 >> `phpbb_confirm`" or dump/reload to fix it!
39 >> forum.phpbb_disallow
40 >> error : Table upgrade required. Please do "REPAIR TABLE
41 >> `phpbb_disallow`" or dump/reload to fix it!
42 >> forum.phpbb_forum_prune
43 >> error : Table upgrade required. Please do "REPAIR TABLE
44 >> `phpbb_forum_prune`" or dump/reload to fix it!
45 >> forum.phpbb_forums
46 >> error : Table upgrade required. Please do "REPAIR TABLE
47 >> `phpbb_forums`" or dump/reload to fix it!
48 >> forum.phpbb_groups
49 >> error : Table upgrade required. Please do "REPAIR TABLE
50 >> `phpbb_groups`" or dump/reload to fix it!
51 >> forum.phpbb_posts
52 >> error : Table upgrade required. Please do "REPAIR TABLE
53 >> `phpbb_posts`" or dump/reload to fix it!
54 >> forum.phpbb_posts_text
55 >> error : Table upgrade required. Please do "REPAIR TABLE
56 >> `phpbb_posts_text`" or dump/reload to fix it!
57 >> forum.phpbb_privmsgs
58 >> error : Table upgrade required. Please do "REPAIR TABLE
59 >> `phpbb_privmsgs`" or dump/reload to fix it!
60 >> forum.phpbb_privmsgs_text
61 >> error : Table upgrade required. Please do "REPAIR TABLE
62 >> `phpbb_privmsgs_text`" or dump/reload to fix it!
63 >> forum.phpbb_ranks
64 >> error : Table upgrade required. Please do "REPAIR TABLE
65 >> `phpbb_ranks`" or dump/reload to fix it!
66 >> forum.phpbb_search_results
67 >> error : Table upgrade required. Please do "REPAIR TABLE
68 >> `phpbb_search_results`" or dump/reload to fix it!
69 >> forum.phpbb_search_wordlist
70 >> error : Table upgrade required. Please do "REPAIR TABLE
71 >> `phpbb_search_wordlist`" or dump/reload to fix it!
72 >> forum.phpbb_search_wordmatch
73 >> error : Table upgrade required. Please do "REPAIR TABLE
74 >> `phpbb_search_wordmatch`" or dump/reload to fix it!
75 >> forum.phpbb_sessions
76 >> error : Table upgrade required. Please do "REPAIR TABLE
77 >> `phpbb_sessions`" or dump/reload to fix it!
78 >> forum.phpbb_sessions_keys
79 >> error : Table upgrade required. Please do "REPAIR TABLE
80 >> `phpbb_sessions_keys`" or dump/reload to fix it!
81 >> forum.phpbb_smilies
82 >> error : Table upgrade required. Please do "REPAIR TABLE
83 >> `phpbb_smilies`" or dump/reload to fix it!
84 >> forum.phpbb_themes
85 >> error : Table upgrade required. Please do "REPAIR TABLE
86 >> `phpbb_themes`" or dump/reload to fix it!
87 >> forum.phpbb_themes_name
88 >> error : Table upgrade required. Please do "REPAIR TABLE
89 >> `phpbb_themes_name`" or dump/reload to fix it!
90 >> forum.phpbb_topics
91 >> error : Table upgrade required. Please do "REPAIR TABLE
92 >> `phpbb_topics`" or dump/reload to fix it!
93 >> forum.phpbb_topics_watch
94 >> error : Table upgrade required. Please do "REPAIR TABLE
95 >> `phpbb_topics_watch`" or dump/reload to fix it!
96 >> forum.phpbb_user_group
97 >> error : Table upgrade required. Please do "REPAIR TABLE
98 >> `phpbb_user_group`" or dump/reload to fix it!
99 >> forum.phpbb_users
100 >> error : Table upgrade required. Please do "REPAIR TABLE
101 >> `phpbb_users`" or dump/reload to fix it!
102 >> forum.phpbb_vote_desc
103 >> error : Table upgrade required. Please do "REPAIR TABLE
104 >> `phpbb_vote_desc`" or dump/reload to fix it!
105 >> forum.phpbb_vote_results
106 >> error : Table upgrade required. Please do "REPAIR TABLE
107 >> `phpbb_vote_results`" or dump/reload to fix it!
108 >> forum.phpbb_vote_voters
109 >> error : Table upgrade required. Please do "REPAIR TABLE
110 >> `phpbb_vote_voters`" or dump/reload to fix it!
111 >> forum.phpbb_words
112 >> error : Table upgrade required. Please do "REPAIR TABLE
113 >> `phpbb_words`" or dump/reload to fix it!
114 >> movies.also_available
115 >> error : Table upgrade required. Please do "REPAIR TABLE
116 >> `also_available`" or dump/reload to fix it!
117 >> movies.do_not_watch
118 >> error : Table upgrade required. Please do "REPAIR TABLE
119 >> `do_not_watch`" or dump/reload to fix it!
120 >> movies.movies_to_review
121 >> error : Table upgrade required. Please do "REPAIR TABLE
122 >> `movies_to_review`" or dump/reload to fix it!
123 >> movies.reviews
124 >> error : Table upgrade required. Please do "REPAIR TABLE `reviews`" or
125 >> dump/reload to fix it!
126 >> movies.to_do_list
127 >> error : Table upgrade required. Please do "REPAIR TABLE `to_do_list`"
128 >> or dump/reload to fix it!
129 >> myFantasy.actions
130 >> error : Table upgrade required. Please do "REPAIR TABLE `actions`" or
131 >> dump/reload to fix it!
132 >> myFantasy.allyAbilities
133 >> error : Table upgrade required. Please do "REPAIR TABLE
134 >> `allyAbilities`" or dump/reload to fix it!
135 >> myFantasy.characters
136 >> error : Table upgrade required. Please do "REPAIR TABLE `characters`"
137 >> or dump/reload to fix it!
138 >> myFantasy.class
139 >> error : Table upgrade required. Please do "REPAIR TABLE `class`" or
140 >> dump/reload to fix it!
141 >> myFantasy.enemy
142 >> error : Table upgrade required. Please do "REPAIR TABLE `enemy`" or
143 >> dump/reload to fix it!
144 >> myFantasy.enemyAbility
145 >> error : Table upgrade required. Please do "REPAIR TABLE
146 >> `enemyAbility`" or dump/reload to fix it!
147 >> myFantasy.magic
148 >> error : Table upgrade required. Please do "REPAIR TABLE `magic`" or
149 >> dump/reload to fix it!
150 >> myFantasy.party
151 >> error : Table upgrade required. Please do "REPAIR TABLE `party`" or
152 >> dump/reload to fix it!
153 >> mysql.columns_priv OK
154 >> mysql.db OK
155 >> mysql.event OK
156 >> mysql.func OK
157 >> mysql.general_log
158 >> Error : You can't use locks with log tables.
159 >> status : OK
160 >> mysql.help_category
161 >> error : Table upgrade required. Please do "REPAIR TABLE
162 >> `help_category`" or dump/reload to fix it!
163 >> mysql.help_keyword
164 >> error : Table upgrade required. Please do "REPAIR TABLE
165 >> `help_keyword`" or dump/reload to fix it!
166 >> mysql.help_relation
167 >> error : Table upgrade required. Please do "REPAIR TABLE
168 >> `help_relation`" or dump/reload to fix it!
169 >> mysql.help_topic
170 >> error : Table upgrade required. Please do "REPAIR TABLE `help_topic`"
171 >> or dump/reload to fix it!
172 >> mysql.host OK
173 >> mysql.ndb_binlog_index OK
174 >> mysql.plugin OK
175 >> mysql.proc OK
176 >> mysql.procs_priv OK
177 >> mysql.servers OK
178 >> mysql.slow_log
179 >> Error : You can't use locks with log tables.
180 >> status : OK
181 >> mysql.tables_priv OK
182 >> mysql.time_zone
183 >> error : Table upgrade required. Please do "REPAIR TABLE `time_zone`"
184 >> or dump/reload to fix it!
185 >> mysql.time_zone_leap_second
186 >> error : Table upgrade required. Please do "REPAIR TABLE
187 >> `time_zone_leap_second`" or dump/reload to fix it!
188 >> mysql.time_zone_name
189 >> error : Table upgrade required. Please do "REPAIR TABLE
190 >> `time_zone_name`" or dump/reload to fix it!
191 >> mysql.time_zone_transition
192 >> error : Table upgrade required. Please do "REPAIR TABLE
193 >> `time_zone_transition`" or dump/reload to fix it!
194 >> mysql.time_zone_transition_type
195 >> error : Table upgrade required. Please do "REPAIR TABLE
196 >> `time_zone_transition_type`" or dump/reload to fix it!
197 >> mysql.user OK
198 >> mysql_cpp_data.images OK
199 >> mysql_cpp_data.stock
200 >> Error : Table 'mysql_cpp_data.stock' doesn't exist
201 >> status : Operation failed
202 >> mythconverg.archiveitems OK
203 >> mythconverg.callsignnetworkmap OK
204 >> mythconverg.capturecard OK
205 >> mythconverg.cardinput OK
206 >> mythconverg.channel OK
207 >> mythconverg.channelgroup OK
208 >> mythconverg.channelgroupnames OK
209 >> mythconverg.channelscan OK
210 >> mythconverg.channelscan_channel OK
211 >> mythconverg.channelscan_dtv_multiplex OK
212 >> mythconverg.codecparams OK
213 >> mythconverg.credits OK
214 >> mythconverg.customexample OK
215 >> mythconverg.diseqc_config OK
216 >> mysqlcheck: Got error: 1102: Incorrect database name
217 >> '#mysql50#mythconverg.bak' when selecting the database
218 >> mythconverg.diseqc_tree OK
219 >> mythconverg.displayprofilegroups OK
220 >> mythconverg.displayprofiles OK
221 >> mythconverg.dtv_multiplex OK
222 >> mythconverg.dtv_privatetypes OK
223 >> mythconverg.dvdbookmark OK
224 >> mythconverg.dvdinput OK
225 >> mythconverg.dvdtranscode OK
226 >> mythconverg.eit_cache OK
227 >> mythconverg.filemarkup OK
228 >> mythconverg.gamemetadata OK
229 >> mythconverg.gameplayers OK
230 >> mythconverg.housekeeping OK
231 >> mythconverg.inputgroup OK
232 >> mythconverg.inuseprograms OK
233 >> mythconverg.jobqueue OK
234 >> mythconverg.jumppoints OK
235 >> mythconverg.keybindings OK
236 >> mythconverg.keyword OK
237 >> mythconverg.music_albumart OK
238 >> mythconverg.music_albums OK
239 >> mythconverg.music_artists OK
240 >> mythconverg.music_directories OK
241 >> mythconverg.music_genres OK
242 >> mythconverg.music_playlists OK
243 >> mythconverg.music_smartplaylist_categories OK
244 >> mythconverg.music_smartplaylist_items OK
245 >> mythconverg.music_smartplaylists OK
246 >> mythconverg.music_songs OK
247 >> mythconverg.music_stats OK
248 >> mythconverg.mythlog OK
249 >> mythconverg.mythweb_sessions OK
250 >> mythconverg.netflix OK
251 >> mythconverg.networkiconmap OK
252 >> mythconverg.oldfind OK
253 >> mythconverg.oldprogram OK
254 >> mythconverg.oldrecorded OK
255 >> mythconverg.people OK
256 >> mythconverg.pidcache OK
257 >> mythconverg.playgroup OK
258 >> mythconverg.powerpriority OK
259 >> mythconverg.profilegroups OK
260 >> mythconverg.program OK
261 >> mythconverg.programgenres OK
262 >> mythconverg.programrating OK
263 >> mythconverg.recgrouppassword OK
264 >> mythconverg.record OK
265 >> mythconverg.record_tmp OK
266 >> mythconverg.recorded OK
267 >> mythconverg.recordedcredits OK
268 >> mythconverg.recordedfile OK
269 >> mythconverg.recordedmarkup OK
270 >> mythconverg.recordedprogram OK
271 >> mythconverg.recordedrating OK
272 >> mythconverg.recordedseek OK
273 >> mythconverg.recordingprofiles OK
274 >> mythconverg.recordmatch OK
275 >> mythconverg.romdb OK
276 >> mythconverg.schemalock OK
277 >> mythconverg.settings OK
278 >> mythconverg.storagegroup OK
279 >> mythconverg.tvchain OK
280 >> mythconverg.tvosdmenu OK
281 >> mythconverg.upnpmedia OK
282 >> mythconverg.videocast OK
283 >> mythconverg.videocategory OK
284 >> mythconverg.videocountry OK
285 >> mythconverg.videogenre OK
286 >> mythconverg.videometadata OK
287 >> mythconverg.videometadatacast OK
288 >> mythconverg.videometadatacountry OK
289 >> mythconverg.videometadatagenre OK
290 >> mythconverg.videosource OK
291 >> mythconverg.videotypes OKcamille ~ #
292 >> mysql_fix_privilege_tables
293 >> This script updates all the mysql privilege tables to be usable by
294 >> the current version of MySQL
295 >>
296 >> done
297 >
298 > So your mythtv-tables are ok afaics. you need to repair your php-bb tables at
299 > some time, but that's a different topic.
300 > From your other post I conclude, that connecting to the backend now works, but
301 > you don't get a program listing. I'll answer there, to keep things related
302 > together.
303 >
304 > Best,
305 > Michael
306 >
307 >
308
309 I spent some time repairing tables. Does this look better?
310
311 camille ~ # mysql_upgrade -p
312 Enter password:
313 Looking for 'mysql' as: mysql
314 Looking for 'mysqlcheck' as: mysqlcheck
315 Running 'mysqlcheck' with connection arguments: '--port=3306'
316 '--socket=/var/run/mysqld/mysqld.sock'
317 Failed to ALTER DATABASE `#mysql50#mythconverg.bak` UPGRADE DATA
318 DIRECTORY NAME
319 Error: Incorrect database name '#mysql50#mythconverg.bak'
320 Running 'mysqlcheck' with connection arguments: '--port=3306'
321 '--socket=/var/run/mysqld/mysqld.sock'
322 myFantasy.actions OK
323 myFantasy.allyAbilities OK
324 myFantasy.characters OK
325 myFantasy.class OK
326 myFantasy.enemy OK
327 myFantasy.enemyAbility OK
328 myFantasy.magic OK
329 myFantasy.party OK
330 mysql.columns_priv OK
331 mysql.db OK
332 mysql.event OK
333 mysql.func OK
334 mysql.general_log
335 Error : You can't use locks with log tables.
336 status : OK
337 mysql.help_category OK
338 mysql.help_keyword OK
339 mysql.help_relation OK
340 mysql.help_topic OK
341 mysql.host OK
342 mysql.ndb_binlog_index OK
343 mysql.plugin OK
344 mysql.proc OK
345 mysql.procs_priv OK
346 mysql.servers OK
347 mysql.slow_log
348 Error : You can't use locks with log tables.
349 status : OK
350 mysql.tables_priv OK
351 mysql.time_zone OK
352 mysql.time_zone_leap_second OK
353 mysql.time_zone_name OK
354 mysql.time_zone_transition OK
355 mysql.time_zone_transition_type OK
356 mysql.user OK
357 mysql_cpp_data.images OK
358 mysql_cpp_data.stock
359 Error : Table 'mysql_cpp_data.stock' doesn't exist
360 status : Operation failed
361 mythconverg.archiveitems OK
362 mythconverg.callsignnetworkmap OK
363 mythconverg.capturecard OK
364 mythconverg.cardinput OK
365 mythconverg.channel OK
366 mythconverg.channelgroup OK
367 mythconverg.channelgroupnames OK
368 mythconverg.channelscan OK
369 mythconverg.channelscan_channel OK
370 mythconverg.channelscan_dtv_multiplex OK
371 mythconverg.codecparams OK
372 mythconverg.credits OK
373 mythconverg.customexample OK
374 mythconverg.diseqc_config OK
375 mythconverg.diseqc_tree OK
376 mythconverg.displayprofilegroups OK
377 mythconverg.displayprofiles OK
378 mythconverg.dtv_multiplex OK
379 mythconverg.dtv_privatetypes OK
380 mythconverg.dvdbookmark OK
381 mythconverg.dvdinput OK
382 mythconverg.dvdtranscode OK
383 mythconverg.eit_cache OK
384 mythconverg.filemarkup OK
385 mythconverg.gamemetadata OK
386 mythconverg.gameplayers OK
387 mythconverg.housekeeping OK
388 mythconverg.inputgroup OK
389 mythconverg.inuseprograms OK
390 mythconverg.jobqueue OK
391 mythconverg.jumppoints OK
392 mythconverg.keybindings OK
393 mythconverg.keyword OK
394 mythconverg.music_albumart OK
395 mythconverg.music_albums OK
396 mythconverg.music_artists OK
397 mythconverg.music_directories OK
398 mythconverg.music_genres OK
399 mythconverg.music_playlists OK
400 mythconverg.music_smartplaylist_categories OK
401 mythconverg.music_smartplaylist_items OK
402 mysqlcheck: Got error: 1102: Incorrect database name
403 '#mysql50#mythconverg.bak' when selecting the database
404 mythconverg.music_smartplaylists OK
405 mythconverg.music_songs OK
406 mythconverg.music_stats OK
407 mythconverg.mythlog OK
408 mythconverg.mythweb_sessions OK
409 mythconverg.netflix OK
410 mythconverg.networkiconmap OK
411 mythconverg.oldfind OK
412 mythconverg.oldprogram OK
413 mythconverg.oldrecorded OK
414 mythconverg.people OK
415 mythconverg.pidcache OK
416 mythconverg.playgroup OK
417 mythconverg.powerpriority OK
418 mythconverg.profilegroups OK
419 mythconverg.program OK
420 mythconverg.programgenres OK
421 mythconverg.programrating OK
422 mythconverg.recgrouppassword OK
423 mythconverg.record OK
424 mythconverg.record_tmp OK
425 mythconverg.recorded OK
426 mythconverg.recordedcredits OK
427 mythconverg.recordedfile OK
428 mythconverg.recordedmarkup OK
429 mythconverg.recordedprogram OK
430 mythconverg.recordedrating OK
431 mythconverg.recordedseek OK
432 mythconverg.recordingprofiles OK
433 mythconverg.recordmatch OK
434 mythconverg.romdb OK
435 mythconverg.schemalock OK
436 mythconverg.settings OK
437 mythconverg.storagegroup OK
438 mythconverg.tvchain OK
439 mythconverg.tvosdmenu OK
440 mythconverg.upnpmedia OK
441 mythconverg.videocast OK
442 mythconverg.videocategory OK
443 mythconverg.videocountry OK
444 mythconverg.videogenre OK
445 mythconverg.videometadata OK
446 mythconverg.videometadatacast OK
447 mythconverg.videometadatacountry OK
448 mythconverg.videometadatagenre OK
449 mythconverg.videosource OK
450 mythconverg.videotypes OK
451 FATAL ERROR: Upgrade failed

Replies

Subject Author
Re: [gentoo-user] Mythtv problems Michael Schreckenbauer <grimlog@×××.de>