Fedora Linux Support Community & Resources Center
  #16  
Old 3rd August 2009, 09:16 PM
bbobbo Offline
Registered User
 
Join Date: Dec 2004
Location: Cambridge, MA
Posts: 89
linuxfedorafirefox
are you trying to reinstall mysql-libs? i don't think you need to touch that. as far as i can tell, you can install mysql and mysql-server without touching mysql-libs.

it would really be a lot easier if you posted the results of the commands you ran--otherwise, i'm left trying to guess exactly what you did.
Reply With Quote
  #17  
Old 3rd August 2009, 09:18 PM
tamar Offline
Registered User
 
Join Date: Jun 2009
Posts: 63
windows_xp_2003firefox
No, I removed mysql, mysql-devel, and mysql-server. Now I am trying to reinstall the fc10 versions.

Code:
# rpm -ivh --nodeps http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-5.0.83-2.fc10.i386.rpm http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-devel-5.0.83-2.fc10.i386.rpm http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-server-5.0.83-2.fc10.i386.rpm http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-libs-5.0.83-2.fc10.i386.rpm
Retrieving http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-5.0.83-2.fc10.i386.rpm
Retrieving http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-devel-5.0.83-2.fc10.i386.rpm
Retrieving http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-server-5.0.83-2.fc10.i386.rpm
Retrieving http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-libs-5.0.83-2.fc10.i386.rpm
Preparing...                ########################################### [100%]
        package mysql-libs-5.1.36-1.fc11.i586 (which is newer than mysql-libs-5.0.83-2.fc10.i386) is already installed
        file /etc/ld.so.conf.d/mysql-i386.conf from install of mysql-libs-5.0.83-2.fc10.i386 conflicts with file from package mysql-libs-5.1.36-1.fc11.i586
        file /etc/my.cnf from install of mysql-libs-5.0.83-2.fc10.i386 conflicts with file from package mysql-libs-5.1.36-1.fc11.i586
        file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.0.83-2.fc10.i386 conflicts with file from package mysql-libs-5.1.36-1.fc11.i586
...snip
It's a mess now
Reply With Quote
  #18  
Old 3rd August 2009, 09:28 PM
P38Lightning Offline
Registered User
 
Join Date: Aug 2009
Location: Oklahoma
Age: 23
Posts: 20
windows_xp_2003opera
Quote:
Originally Posted by monkeypet View Post
Hi, After upgrading from fc10->fc11, mysql fails to startup with the following in /var/log/mysql*

Code:
090626 02:37:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090626  2:37:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090626  2:37:20  InnoDB: Started; log sequence number 0 29288572
090626  2:37:20 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'host'; try to repair it

I can get it to startup if I add '--skip-grant' to the mysqld_safe line in the /etc/init.d/mysqld file.

Running mysqlcheck --databases mysql reveals the following, repairing it does nothing:

[root@mythtv mysql]# mysqlcheck --databases mysql
mysql.columns_priv
Error    : Incorrect key file for table 'columns_priv'; try to repair it
error    : Corrupt
mysql.db
Error    : Incorrect key file for table 'db'; try to repair it
error    : Corrupt
mysql.event                                        OK
mysql.func
Error    : Incorrect key file for table 'func'; try to repair it
error    : Corrupt
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host
Error    : Incorrect key file for table 'host'; try to repair it
error    : Corrupt
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv
Error    : Incorrect key file for table 'tables_priv'; try to repair it
error    : Corrupt
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user
Error    : Incorrect key file for table 'user'; try to repair it
error    : Corrupt
I am guessing that if I can't figure it out, I'll nuke the db and reinitialize it restoring from the backups.
I have had problems with upgrading fedora. I found that the best was to go ahead and back up my data, and format my drive and just start with the new version fresh.
Reply With Quote
  #19  
Old 3rd August 2009, 09:43 PM
tamar Offline
Registered User
 
Join Date: Jun 2009
Posts: 63
windows_xp_2003firefox
Thanks fedora 6 but I can't do that and I'm not the OP.
Reply With Quote
  #20  
Old 3rd August 2009, 09:44 PM
bbobbo Offline
Registered User
 
Join Date: Dec 2004
Location: Cambridge, MA
Posts: 89
linuxfedorafirefox
Quote:
Originally Posted by tamar View Post
No, I removed mysql, mysql-devel, and mysql-server. Now I am trying to reinstall the fc10 versions.

# rpm -ivh --nodeps http://download.fedora.redhat.com/pu....fc10.i386.rpm http://download.fedora.redhat.com/pu....fc10.i386.rpm http://download.fedora.redhat.com/pu....fc10.i386.rpm http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-libs-5.0.83-2.fc10.i386.rpm
yes, you are trying to reinstall mysql-libs (the last item in your rpm command). as i stated before, only install mysql and mysql-server. don't install mysql-devel or mysql-libs.
Reply With Quote
  #21  
Old 3rd August 2009, 09:46 PM
tamar Offline
Registered User
 
Join Date: Jun 2009
Posts: 63
windows_xp_2003firefox
oops, good call... I thought I removed that. Let's see what this does.
Reply With Quote
  #22  
Old 3rd August 2009, 10:45 PM
tamar Offline
Registered User
 
Join Date: Jun 2009
Posts: 63
windows_xp_2003firefox
This is evil

Code:
# mysql_upgrade
mysql_upgrade: /usr/lib/mysql/libmysqlclient.so.15: no version information available (required by mysql_upgrade)
mysql_upgrade: relocation error: mysql_upgrade: symbol handle_options, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference
and....

Code:
# ldd /usr/bin/mysql_upgrade
/usr/bin/mysql_upgrade: /usr/lib/mysql/libmysqlclient.so.15: no version information available (required by /usr/bin/mysql_upgrade)
        linux-gate.so.1 =>  (0x00c8f000)
        libmysqlclient.so.15 => /usr/lib/mysql/libmysqlclient.so.15 (0x0038c000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x0035b000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x071a6000)
        libm.so.6 => /lib/libm.so.6 (0x003c7000)
        libssl.so.7 => /usr/lib/libssl.so.7 (0x00cee000)
        libcrypto.so.7 => /usr/lib/libcrypto.so.7 (0x00ad8000)
        libz.so.1 => /lib/libz.so.1 (0x00415000)
        libc.so.6 => /lib/libc.so.6 (0x00428000)
        libfreebl3.so => /lib/libfreebl3.so (0x008eb000)
        /lib/ld-linux.so.2 (0x0022f000)
        libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x00c46000)
        libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00a03000)
        libcom_err.so.2 => /lib/libcom_err.so.2 (0x009f9000)
        libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00aad000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x009d8000)
        libdl.so.2 => /lib/libdl.so.2 (0x003f1000)
        libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x00aa1000)
        libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x009fe000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x003f8000)
        libselinux.so.1 => /lib/libselinux.so.1 (0x00110000)
Reply With Quote
  #23  
Old 3rd August 2009, 11:17 PM
bbobbo Offline
Registered User
 
Join Date: Dec 2004
Location: Cambridge, MA
Posts: 89
linuxfedorafirefox
okay, it looks like mysql_upgrade relies on libssl.so.7 and libcrypto.so.7, and probably on the old version of mysql-libs.

i'm out of "easy" answers...the last thing i can think of would be to copy the mysql files over to a fedora 10 machine and do the updates there, but of course i'm guessing you don't have another fedora 10 machine or you would have done this already.

my recommendation:

1) install virtualbox
2) install fedora 10 as a virtual os within virtualbox
3) copy the mysql files over
4) run mysql_upgrade
5) copy the files back over to your fedora 11 installation
6) run mysql_upgrade again

sounds convoluted, i know. but that's the best i can come up with at the moment.
Reply With Quote
  #24  
Old 3rd August 2009, 11:30 PM
tamar Offline
Registered User
 
Join Date: Jun 2009
Posts: 63
windows_xp_2003firefox
hmm, yeah, that's a pain.

I assume the only corrupted table here is "mysql." Is there any way I can just uh, create it from scratch and associate it with the usernames/other databases later?
Reply With Quote
  #25  
Old 4th August 2009, 05:39 AM
bbobbo Offline
Registered User
 
Join Date: Dec 2004
Location: Cambridge, MA
Posts: 89
linuxfedorafirefox
i'm not sure you can assume that the only corrupted database is `mysql`. but if that's the case i think what you're saying will work. update back to mysql-5.1.36-1, start and stop mysqld, then copy all the other database directories into /var/lib/mysql. then try mysql_upgrade again.

then fill in the 'db' and 'user' tables in the `mysql` database with the appropriate data. or maybe you have to fill in that data before doing mysql_upgrade.
Reply With Quote
  #26  
Old 4th August 2009, 10:41 PM
tamar Offline
Registered User
 
Join Date: Jun 2009
Posts: 63
windows_xp_2003firefox
I actually think that did it Thanks for your help!
Reply With Quote
Reply

Tags
fails, fc10>fc11, mysql, startup, upgrading

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mic fails in FC11, worked in FC10 leonpollak Hardware & Laptops 9 22nd November 2009 02:00 AM
After Upd FC10 to FC11 Yum not working Turbo13 Using Fedora 1 12th October 2009 07:57 AM
FC9->FC10->FC11 problem vogelap Installation, Upgrades and Live Media 20 23rd July 2009 05:25 PM
firefox fc10 on fc11 LinuxHippy Using Fedora 7 15th July 2009 10:15 PM
Upgrade to FC11 from FC10 jpm_power Using Fedora 2 14th May 2009 08:35 PM


Current GMT-time: 16:00 (Saturday, 25-10-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat
Kanbe Photos on Instagram - Nueva Italia de Ruiz Photos - Saint Helier Instagram Photos