Am Mittwoch, 26. Oktober 2011, 17:14:08 schrieb Michael Sullivan:
> >> camille ~ # mysql -u root mysql -p
> >> 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 3
> >> Server version: 5.1.56-log Gentoo Linux mysql-5.1.56
> >>
> >> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
> >> reserved. This software comes with ABSOLUTELY NO WARRANTY. This is
> >> free software, and you are welcome to modify and redistribute it
> >> under the GPL v2 license
> >>
> >> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> >> statement.
> >>
> >> mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE
> >> user='mythtv';
> >> Query OK, 0 rows affected (0.00 sec)
> >> Rows matched: 2 Changed: 0 Warnings: 0
> >>
> >> mysql> FLUSH PRIVILEGES;
> >> ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
> >> mysql> quit
> >> Bye
> >
> > Your mysql is broken somehow. Did you by any chance upgrade mysql? Try
> > running mysql_upgrade.
> >
> > Best,
> > Michael
>
> michael@camille ~ $ mythfrontend
> 2011-10-26 16:16:27.121 mythfrontend version:
> branches/release-0-23-fixes [27077] www.mythtv.org
> 2011-10-26 16:16:27.121 Using runtime prefix = /usr
> 2011-10-26 16:16:27.121 Using configuration directory =
> /home/michael/.mythtv
> 2011-10-26 16:16:27.940 Unable to read configuration file mysql.txt
> 2011-10-26 16:16:27.940 Empty LocalHostName.
> 2011-10-26 16:16:27.940 Using localhost value of camille
> 2011-10-26 16:16:28.039 New DB connection, total: 1
> 2011-10-26 16:16:28.090 Connected to database 'mythconverg' at host:
> localhost
> 2011-10-26 16:16:28.091 Closing DB connection named 'DBManager0'
> 2011-10-26 16:16:28.181 ScreenSaverX11Private: XScreenSaver support enabled
> 2011-10-26 16:16:28.183 DPMS is disabled.
> 2011-10-26 16:16:28.185 Primary screen: 0.
> 2011-10-26 16:16:28.186 Connected to database 'mythconverg' at host:
> localhost
> 2011-10-26 16:16:28.189 Using screen 0, 1024x768 at 0,0
> 2011-10-26 16:16:28.242 Desktop video mode: 1024x768 75.0807 Hz
> 2011-10-26 16:16:28.756 MythUI Image Cache size set to 20971520 bytes
> 2011-10-26 16:16:28.861 Enabled verbose msgs: important general
> 2011-10-26 16:16:28.876 Primary screen: 0.
> 2011-10-26 16:16:28.881 Using screen 0, 1024x768 at 0,0
> 2011-10-26 16:16:28.898 Using theme base resolution of 1280x720
> 2011-10-26 16:16:28.935 LIRC, Error: Failed to connect to Unix socket
> '/var/run/lirc/lircd'
> eno: No such file or directory (2)
> 2011-10-26 16:16:28.935 JoystickMenuThread Error: Joystick disabled -
> Failed to read /home/michael/.mythtv/joystickmenurc
> 2011-10-26 16:16:29.061 Using Frameless Window
> 2011-10-26 16:16:29.061 Using Full Screen Window
> 2011-10-26 16:16:29.892 Using the Qt painter
> 2011-10-26 16:16:30.306 XMLParseBase: Loaded base theme from
> '/usr/share/mythtv/themes/metallurgy/base.xml'
> 2011-10-26 16:16:30.525 XMLParseBase: Loaded base theme from
> '/usr/share/mythtv/themes/default-wide/base.xml'
> 2011-10-26 16:16:30.800 XMLParseBase: Loaded base theme from
> '/usr/share/mythtv/themes/default/base.xml'
> 2011-10-26 16:16:30.807 New DB connection, total: 2
> 2011-10-26 16:16:30.820 Current MythTV Schema Version (DBSchemaVer): 1254
> 2011-10-26 16:16:30.822 Connected to database 'mythconverg' at host:
> localhost
> 2011-10-26 16:16:32.928 Registering Internal as a media playback plugin.
> 2011-10-26 16:16:33.145 Current MythMusic Schema Version
> (MusicDBSchemaVer): 1017
> 2011-10-26 16:16:33.338 MMUnix::AddDevice() Error: failed to stat /dev/bdi,
> eno: No such file or directory (2)
> 2011-10-26 16:16:33.352 MMUnix::AddDevice() Error: failed to stat
> /dev/power,
> eno: No such file or directory (2)
> 2011-10-26 16:16:33.371 MMUnix::AddDevice() Error: failed to stat /dev/bdi,
> eno: No such file or directory (2)
> 2011-10-26 16:16:33.386 MMUnix::AddDevice() Error: failed to stat
> /dev/power,
> eno: No such file or directory (2)
> 2011-10-26 16:16:33.403 MonitorRegisterExtensions(0x40,
> mp3,mp2,ogg,oga,flac,wma,wav,ac3,oma,omg,atp,ra,dts,aac,m4a,aa3,tta,mka,aiff
> ,swa,wv) 2011-10-26 16:16:33.421 Cannot load language en_us for module
> mythmusic 2011-10-26 16:16:33.425 XMLParseBase: Loading window theme from
> /usr/share/mythtv/themes/metallurgy/menu-ui.xml
> mount: can't find /dev/sdd1 in /etc/fstab or /etc/mtab
> 2011-10-26 16:16:33.538 Failed to mount /dev/sdd1.
> 2011-10-26 16:16:33.545 CD/DVD '/mnt/cdrom' contained none of
> /VIDEO_TS, /.TOC.plist, /vcd or /svcd
> 2011-10-26 16:16:33.545 Searching CD statistically - file by file!
> 2011-10-26 16:16:34.035 Loading menu theme from
> /usr/share/mythtv/themes/defaultmenu//mainmenu.xml
> 2011-10-26 16:16:34.046 Found mainmenu.xml for theme 'metallurgy'
> 2011-10-26 16:16:34.225 MythContext: Connecting to backend server:
> 192.168.2.3:6543 (try 1 of 1)
> 2011-10-26 16:16:34.242 Using protocol version 23056
> 2011-10-26 16:16:36.240 Loading menu theme from
> /usr/share/mythtv/themes/defaultmenu//library.xml
> 2011-10-26 16:16:37.723 XMLParseBase: Loading window theme from
> /usr/share/mythtv/themes/metallurgy/recordings-ui.xml
> 2011-10-26 16:16:47.991 MythContext: Connecting to backend server:
> 192.168.2.3:6543 (try 1 of 1)
> 2011-10-26 16:16:47.998 Using protocol version 23056
> 2011-10-26 16:16:55.044 PlaybackBox: UpdateUIListItem called with a
> title unknown to us in m_recordingList
> Jessie:Zombie Tea Party 5
> 2011-10-26 16:16:58.624 MythSocket(92ded58:39): Unable to lookup:
> 2011-10-26 16:16:58.625 RemoteFile::openSocket(control socket), Error:
> Could not connect to server :6543
> 2011-10-26 16:16:58.654 MythSocket(8de8cf8:39): Unable to lookup:
> 2011-10-26 16:16:58.654 RemoteFile::openSocket(file data socket), Error:
> Could not connect to server :6543
> 2011-10-26 16:16:58.670 MythSocket(8e8bb28:39): Unable to lookup:
> 2011-10-26 16:16:58.670 RemoteFile::openSocket(control socket), Error:
> Could not connect to server :6543
> 2011-10-26 16:16:58.672 MythSocket(8e6f520:39): Unable to lookup:
> 2011-10-26 16:16:58.672 RemoteFile::openSocket(file data socket), Error:
> Could not connect to server :6543
> 2011-10-26 16:17:03.038 Deleting UPnP client...
> Error in my_thread_global_end(): 1 threads didn't exit
So you did run mysql_upgrade and same as before? Some words about what you did
and some relevant output of the command (if any) wouldn't hurt ;)
Have you tried mysql_fix_privilege_tables? After that, you would need to run
the steps mentioned in the wiki again (I think), giving the password you
entered in myth-setup to the UPDATE command.
Best,
Michael
