1 |
Am Mittwoch, 26. Oktober 2011, 17:14:08 schrieb Michael Sullivan: |
2 |
> >> camille ~ # mysql -u root mysql -p |
3 |
> >> Enter password: |
4 |
> >> Reading table information for completion of table and column names |
5 |
> >> You can turn off this feature to get a quicker startup with -A |
6 |
> >> |
7 |
> >> Welcome to the MySQL monitor. Commands end with ; or \g. |
8 |
> >> Your MySQL connection id is 3 |
9 |
> >> Server version: 5.1.56-log Gentoo Linux mysql-5.1.56 |
10 |
> >> |
11 |
> >> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights |
12 |
> >> reserved. This software comes with ABSOLUTELY NO WARRANTY. This is |
13 |
> >> free software, and you are welcome to modify and redistribute it |
14 |
> >> under the GPL v2 license |
15 |
> >> |
16 |
> >> Type 'help;' or '\h' for help. Type '\c' to clear the current input |
17 |
> >> statement. |
18 |
> >> |
19 |
> >> mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE |
20 |
> >> user='mythtv'; |
21 |
> >> Query OK, 0 rows affected (0.00 sec) |
22 |
> >> Rows matched: 2 Changed: 0 Warnings: 0 |
23 |
> >> |
24 |
> >> mysql> FLUSH PRIVILEGES; |
25 |
> >> ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist |
26 |
> >> mysql> quit |
27 |
> >> Bye |
28 |
> > |
29 |
> > Your mysql is broken somehow. Did you by any chance upgrade mysql? Try |
30 |
> > running mysql_upgrade. |
31 |
> > |
32 |
> > Best, |
33 |
> > Michael |
34 |
> |
35 |
> michael@camille ~ $ mythfrontend |
36 |
> 2011-10-26 16:16:27.121 mythfrontend version: |
37 |
> branches/release-0-23-fixes [27077] www.mythtv.org |
38 |
> 2011-10-26 16:16:27.121 Using runtime prefix = /usr |
39 |
> 2011-10-26 16:16:27.121 Using configuration directory = |
40 |
> /home/michael/.mythtv |
41 |
> 2011-10-26 16:16:27.940 Unable to read configuration file mysql.txt |
42 |
> 2011-10-26 16:16:27.940 Empty LocalHostName. |
43 |
> 2011-10-26 16:16:27.940 Using localhost value of camille |
44 |
> 2011-10-26 16:16:28.039 New DB connection, total: 1 |
45 |
> 2011-10-26 16:16:28.090 Connected to database 'mythconverg' at host: |
46 |
> localhost |
47 |
> 2011-10-26 16:16:28.091 Closing DB connection named 'DBManager0' |
48 |
> 2011-10-26 16:16:28.181 ScreenSaverX11Private: XScreenSaver support enabled |
49 |
> 2011-10-26 16:16:28.183 DPMS is disabled. |
50 |
> 2011-10-26 16:16:28.185 Primary screen: 0. |
51 |
> 2011-10-26 16:16:28.186 Connected to database 'mythconverg' at host: |
52 |
> localhost |
53 |
> 2011-10-26 16:16:28.189 Using screen 0, 1024x768 at 0,0 |
54 |
> 2011-10-26 16:16:28.242 Desktop video mode: 1024x768 75.0807 Hz |
55 |
> 2011-10-26 16:16:28.756 MythUI Image Cache size set to 20971520 bytes |
56 |
> 2011-10-26 16:16:28.861 Enabled verbose msgs: important general |
57 |
> 2011-10-26 16:16:28.876 Primary screen: 0. |
58 |
> 2011-10-26 16:16:28.881 Using screen 0, 1024x768 at 0,0 |
59 |
> 2011-10-26 16:16:28.898 Using theme base resolution of 1280x720 |
60 |
> 2011-10-26 16:16:28.935 LIRC, Error: Failed to connect to Unix socket |
61 |
> '/var/run/lirc/lircd' |
62 |
> eno: No such file or directory (2) |
63 |
> 2011-10-26 16:16:28.935 JoystickMenuThread Error: Joystick disabled - |
64 |
> Failed to read /home/michael/.mythtv/joystickmenurc |
65 |
> 2011-10-26 16:16:29.061 Using Frameless Window |
66 |
> 2011-10-26 16:16:29.061 Using Full Screen Window |
67 |
> 2011-10-26 16:16:29.892 Using the Qt painter |
68 |
> 2011-10-26 16:16:30.306 XMLParseBase: Loaded base theme from |
69 |
> '/usr/share/mythtv/themes/metallurgy/base.xml' |
70 |
> 2011-10-26 16:16:30.525 XMLParseBase: Loaded base theme from |
71 |
> '/usr/share/mythtv/themes/default-wide/base.xml' |
72 |
> 2011-10-26 16:16:30.800 XMLParseBase: Loaded base theme from |
73 |
> '/usr/share/mythtv/themes/default/base.xml' |
74 |
> 2011-10-26 16:16:30.807 New DB connection, total: 2 |
75 |
> 2011-10-26 16:16:30.820 Current MythTV Schema Version (DBSchemaVer): 1254 |
76 |
> 2011-10-26 16:16:30.822 Connected to database 'mythconverg' at host: |
77 |
> localhost |
78 |
> 2011-10-26 16:16:32.928 Registering Internal as a media playback plugin. |
79 |
> 2011-10-26 16:16:33.145 Current MythMusic Schema Version |
80 |
> (MusicDBSchemaVer): 1017 |
81 |
> 2011-10-26 16:16:33.338 MMUnix::AddDevice() Error: failed to stat /dev/bdi, |
82 |
> eno: No such file or directory (2) |
83 |
> 2011-10-26 16:16:33.352 MMUnix::AddDevice() Error: failed to stat |
84 |
> /dev/power, |
85 |
> eno: No such file or directory (2) |
86 |
> 2011-10-26 16:16:33.371 MMUnix::AddDevice() Error: failed to stat /dev/bdi, |
87 |
> eno: No such file or directory (2) |
88 |
> 2011-10-26 16:16:33.386 MMUnix::AddDevice() Error: failed to stat |
89 |
> /dev/power, |
90 |
> eno: No such file or directory (2) |
91 |
> 2011-10-26 16:16:33.403 MonitorRegisterExtensions(0x40, |
92 |
> mp3,mp2,ogg,oga,flac,wma,wav,ac3,oma,omg,atp,ra,dts,aac,m4a,aa3,tta,mka,aiff |
93 |
> ,swa,wv) 2011-10-26 16:16:33.421 Cannot load language en_us for module |
94 |
> mythmusic 2011-10-26 16:16:33.425 XMLParseBase: Loading window theme from |
95 |
> /usr/share/mythtv/themes/metallurgy/menu-ui.xml |
96 |
> mount: can't find /dev/sdd1 in /etc/fstab or /etc/mtab |
97 |
> 2011-10-26 16:16:33.538 Failed to mount /dev/sdd1. |
98 |
> 2011-10-26 16:16:33.545 CD/DVD '/mnt/cdrom' contained none of |
99 |
> /VIDEO_TS, /.TOC.plist, /vcd or /svcd |
100 |
> 2011-10-26 16:16:33.545 Searching CD statistically - file by file! |
101 |
> 2011-10-26 16:16:34.035 Loading menu theme from |
102 |
> /usr/share/mythtv/themes/defaultmenu//mainmenu.xml |
103 |
> 2011-10-26 16:16:34.046 Found mainmenu.xml for theme 'metallurgy' |
104 |
> 2011-10-26 16:16:34.225 MythContext: Connecting to backend server: |
105 |
> 192.168.2.3:6543 (try 1 of 1) |
106 |
> 2011-10-26 16:16:34.242 Using protocol version 23056 |
107 |
> 2011-10-26 16:16:36.240 Loading menu theme from |
108 |
> /usr/share/mythtv/themes/defaultmenu//library.xml |
109 |
> 2011-10-26 16:16:37.723 XMLParseBase: Loading window theme from |
110 |
> /usr/share/mythtv/themes/metallurgy/recordings-ui.xml |
111 |
> 2011-10-26 16:16:47.991 MythContext: Connecting to backend server: |
112 |
> 192.168.2.3:6543 (try 1 of 1) |
113 |
> 2011-10-26 16:16:47.998 Using protocol version 23056 |
114 |
> 2011-10-26 16:16:55.044 PlaybackBox: UpdateUIListItem called with a |
115 |
> title unknown to us in m_recordingList |
116 |
> Jessie:Zombie Tea Party 5 |
117 |
> 2011-10-26 16:16:58.624 MythSocket(92ded58:39): Unable to lookup: |
118 |
> 2011-10-26 16:16:58.625 RemoteFile::openSocket(control socket), Error: |
119 |
> Could not connect to server :6543 |
120 |
> 2011-10-26 16:16:58.654 MythSocket(8de8cf8:39): Unable to lookup: |
121 |
> 2011-10-26 16:16:58.654 RemoteFile::openSocket(file data socket), Error: |
122 |
> Could not connect to server :6543 |
123 |
> 2011-10-26 16:16:58.670 MythSocket(8e8bb28:39): Unable to lookup: |
124 |
> 2011-10-26 16:16:58.670 RemoteFile::openSocket(control socket), Error: |
125 |
> Could not connect to server :6543 |
126 |
> 2011-10-26 16:16:58.672 MythSocket(8e6f520:39): Unable to lookup: |
127 |
> 2011-10-26 16:16:58.672 RemoteFile::openSocket(file data socket), Error: |
128 |
> Could not connect to server :6543 |
129 |
> 2011-10-26 16:17:03.038 Deleting UPnP client... |
130 |
> Error in my_thread_global_end(): 1 threads didn't exit |
131 |
|
132 |
So you did run mysql_upgrade and same as before? Some words about what you did |
133 |
and some relevant output of the command (if any) wouldn't hurt ;) |
134 |
Have you tried mysql_fix_privilege_tables? After that, you would need to run |
135 |
the steps mentioned in the wiki again (I think), giving the password you |
136 |
entered in myth-setup to the UPDATE command. |
137 |
|
138 |
Best, |
139 |
Michael |