1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Help needed to upgrade mysql

Discussion in 'Plesk for Linux - 8.x and Older' started by kaiserkai, Feb 8, 2006.

  1. kaiserkai

    kaiserkai Guest

    0
     
    All,

    i am using a 1and1 dedicated server with FC2 and Plesk 7.5.4 installed.
    I am in need of upgrading mysql to 4.0.xx
    After several searches of this site i decided to rather not try this on my own, not being a Linux SA but rather a guy who bought a server for some webhosting.
    I have seen several offers of people to help out.

    So my question is, who is willing to do it, what would it cost me (only 1 server) and do you have any references?
    Please give me an idea of what I am looking at timewise as well (guessing someone who knows what he is doing can do that in about 1h)

    Contact me in this threat or via PM on the boards.

    Thanks in advance.
     
  2. Highland

    Highland Guest

    0
     
    You do know yum will do the upgrade for you with little or no pain, right? The main thing is making sure you have the ART archive set properly and you make one small edit to your /etc/my.cnf file. Beyond that you could be running 4.1.15 (latest ART release) inside 10 mins.
     
  3. kaiserkai

    kaiserkai Guest

    0
     
    You are correct.
    I did it myself after all, and it could not have been easier.
    Get Yum configured, install latest mysql through Yum, change my.conf and done.

    I little shock when I couldnt connect to my databases initially but that was fixed soon.

    Thanks.
     
  4. Telegon80

    Telegon80 Guest

    0
     
    I enabled all of the responding repositories in /etc/yum.conf

    also, I added the DAG repository. My problem is there doesn't appear to be an available mysql-server to upgrade to. any ideas?

    # yum search mysql-server
    Gathering header information file(s) from server(s)
    Server: Fedora Core 2 - i386 - Base
    Server: Dag RPM Repository for Fedora Core
    Server: Fedora Core 2 updates (from fedoralegacy.org)
    Server: Fedora Core 2 - i386 - Released Updates
    Server: Fedora Core 2 - i386 - Unreleased Updates
    Finding updated packages
    Downloading needed headers
    Looking in available packages for a providing package
    No packages found
    Looking in installed packages for a providing package
    Installed package: mysql-server.i386 0:3.23.58-16.FC2.4.legacy matches with
    mysql-server
    1 results returned


    here's my /etc/yum.conf
    # cat /etc/yum.conf
    [main]
    cachedir=/var/cache/yum
    debuglevel=2
    logfile=/var/log/yum.log
    pkgpolicy=newest
    distroverpkg=redhat-release
    tolerant=1
    exactarch=1
    retries=20

    [base]
    name=Fedora Core $releasever - $basearch - Base
    baseurl=http://download.fedora.redhat.com/pub/fedora/linux/core/$releasever/$basearch/os/

    [updates-released]
    name=Fedora Core $releasever - $basearch - Released Updates
    baseurl=http://download.fedora.redhat.com/pub/fedora/linux/core/updates/$releasever/$basearch/

    [updates-testing]
    name=Fedora Core $releasever - $basearch - Unreleased Updates
    baseurl=http://download.fedora.redhat.com/pub/fedora/linux/core/updates/testing/$releasever/$basearch/

    #[development]
    #name=Fedora Core $releasever - Development Tree
    #baseurl=http://download.fedora.redhat.com/pub/fedora/linux/core/development/$basearch/

    [base]
    name=Fedora Core $releasever - $basearch - Base
    baseurl=http://download.fedoralegacy.org/fedora/$releasever/os/$basearch

    [fedoralegacy-updates]
    name=Fedora Core $releasever updates (from fedoralegacy.org)
    baseurl=http://download.fedoralegacy.org/fedora/$releasever/updates/$basearch

    [dag]
    name=Dag RPM Repository for Fedora Core
    baseurl=http://apt.sw.be/fedora/$releasever/en/$basearch/dag



    My ISP has Fedora Core2 installed. as well.
     
  5. Mirco@

    Mirco@ Basic Pleskian

    24
    53%
    Joined:
    Aug 1, 2001
    Messages:
    43
    Likes Received:
    0
    1.

    # rpm -Uvh http://3es.atomicrocketturtle.com/atomic/art/2/RPMS/mysql-server-4.1.15-1.rhfc2.art.i386.rpm http://3es.atomicrocketturtle.com/atomic/art/2/RPMS/mysql-4.1.15-1.rhfc2.art.i386.rpm http://3es.atomicrocketturtle.com/atomic/art/2/RPMS/mysql-compat-4.1.15-1.rhfc2.art.i386.rpm

    2.

    # /usr/bin/mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`
     
  6. orpheum

    orpheum Guest

    0
     
    What did you change in my.conf? Could you please be more specific? I've already done this upgrade, but Plesk is having trouble recognizing the fact that MySQL 4.1.18 is installed. I'm starting to have a feeling that it's unsupported either by Fedora Core 2 or by Plesk, because everyone else seems to be upgrading to 4.1.15.
     
  7. orpheum

    orpheum Guest

    0
     
    Nevermind, I figured out what the "problem" was. Wasn't a problem at all, really. Damn Plesk, lol.
     
  8. michaellunsford

    michaellunsford Regular Pleskian

    25
    90%
    Joined:
    Jul 25, 2005
    Messages:
    131
    Likes Received:
    0
    I need to update to 4.x, but you guys are making me nervous. All this talk about problems that aren't problems.

    What should I watch out for? Is there a tutorial on doing the update? When I panic, what do I do next?
     
  9. Highland

    Highland Guest

    0
     
    The big thing to do is after you go to 4.1.x is edit /etc/my.cnf and add the following under [mysqld]

    Code:
    old_passwords=1
    This prevents MySQL from trying to upgrade the passwords and breaking your system. Beyond that (I had to repair several passwords before I learned of this) I've had no problems with 4.1.15 (latest ART release)

    Remember to use Yum and not a rpm!
     
  10. michaellunsford

    michaellunsford Regular Pleskian

    25
    90%
    Joined:
    Jul 25, 2005
    Messages:
    131
    Likes Received:
    0
    I've never done anything like this. I went to the mysql website to download the upgrade, but there are like 50 different options, and the ones I think are for me all say RPM.

    My server is running redhat linux on an intel celeron processor.

    proc/version reports:
    Linux version 2.6.5-1.358 (bhcompile@bugs.build.redhat.com) (gcc version 3.3.3 20040412 (Red Hat Linux 3.3.3-7)) #1 Sat May 8 09:04:50 EDT 2004

    The downloads on mysql.com all say "enterprise" (which isn't reported by proc/version), and I don't even seen an option on mysql for version 2.6.5
     
  11. Highland

    Highland Guest

    0
     
    Step by step then... Please omit the # as they're just there to replace whatever your SSH prompt is.

    1. Make sure Yum is installed
    Code:
    #which yum
    If you don't go get it
    http://linux.duke.edu/projects/yum/download.ptml

    2. In your /etc/yum.conf file make sure you have the following
    Code:
    [atomic]
    name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
    baseurl=http://3es.atomicrocketturtle.com/atomic/art/$releasever/
    
    This is where the ART files are stored

    3. Now we need to check for updates (and you'll have them for certain) so we run
    Code:
    # yum check-update
    Gathering header information file(s) from server(s)
    Server: Atomic Rocket Turtle - 2 - Atomic PSA-Compatible RPMS
    Server: Fedora Core 2 - i386 - Base
    Server: Fedora Core 2 - i386 - Released Updates
    Finding updated packages
    Downloading needed headers
    Name                                Arch   Version                  Repo
    --------------------------------------------------------------------------------
    php-pear                            i386   4.4.2-3.rhfc2.art        atomic
    php-xslt                            i386   4.4.2-3.rhfc2.art        atomic
    
    Now the formatting is off (and your list will be 10x longer) but you get the idea. To upgrade, for instance, pear we'd use
    Code:
    #yum upgrade pear
    Not the best example, tho, as pear is quite capable of updating itself. One of the few cases you shouldn't use an ART upgrade as this one will likely break pear.

    In your case you'll want the main packages updated. I'd upgrade mysql, php and spamassassin in addition to any base packages you might need.
     
  12. michaellunsford

    michaellunsford Regular Pleskian

    25
    90%
    Joined:
    Jul 25, 2005
    Messages:
    131
    Likes Received:
    0
    under yum check-update I get two mysql lines:

    mysql i386 4.1.15-1.rhfc2.art atomic
    mysql-server i386 4.1.15-1.rhfc2.art atomic

    am I updating both of them?

    Also, there is no my.conf in the /etc/ directory before upgrade, does the upgrade add it, or do I need to create the file manually?
     
  13. Highland

    Highland Guest

    0
     
    Just run
    Code:
    #yum upgrade mysql
    And that will be all you need

    As for my.cnf... first make sure you're not searching for my.conf. It's my.cnf If it's still not there you may need to do a find
    Code:
    #find / -name 'my.cnf'
    but I would wait until after your upgrade just in case it does move it.
     
  14. Verbal

    Verbal Guest

    0
     
    Hello,
    I need to update to MySql 4.xx too for Plesk 7.5.4 on Fedora Core 3.
    I tried with Yum but my yum.conf seems to not be valid.
    Do you have a yum.conf complete example for FC3 with plesk and mysql4 ?

    thanks a lot, it's my first linux experience ....

    edit : ok yum check-update worked, i tried yum upgrade mysql, here is the result :

    Should i download the libmysqlclient.so.10 for mysql 4.1.15 rpm and install it before ? I thought only YUM was necessary to make update.

    Thanks.
     
  15. Verbal

    Verbal Guest

    0
     
    I downloaded the shared rpm package but when installing it, it says it was alreay installed ...
    I retried yum upgrade mysql and here is the new result :

    What should i do to fix those public key issues please ?

    thanks.
     
  16. Highland

    Highland Guest

    0
     
    Run
    Code:
    wget [url]http://www.atomicrocketturtle.com/RPM-GPG-KEY.art.txt[/url]
    And then run
    Code:
    rpm --import RPM-GPG-KEY.art.txt
     
  17. Verbal

    Verbal Guest

    0
     
    Ok the upgrade is done :
    I ve edited the my.cnf file to add old_passwords=1.
    I tried to log into plesk and here is the result accessing the plesk admin site :

    edit : I ve rebooted the server and it is OK. Works fine.
    Im going to make some tests.

    Thanks a lot for your help.
     
  18. michaellunsford

    michaellunsford Regular Pleskian

    25
    90%
    Joined:
    Jul 25, 2005
    Messages:
    131
    Likes Received:
    0
    awesome, I finally got up enough courage to yum update mysql -- everything here was perfect.

    one question, though, phpinfo() still thinks I'm running mysql 3. It's not a big deal because command line reports the right version, and phpmyadmin is cooperating with mysql 4 commands -- but it is odd, no?
     
  19. Verbal

    Verbal Guest

    0
     
    Hello,
    Same here but i think it shows mysql client and not server.
    This command will show you version of RPMs installed :
    #rpm -qa|grep -i mysql
     
  20. propmaster

    propmaster Guest

    0
     
    I am getting the following errors when I run this code in ssh: # yum upgrade mysql:
    error: db4 error(-30978) from db->get: DB_RUNRECOVERY: Fatal error, run database recovery
    error: error(-30978) getting "errmsg.sys" records from Basenames index
    rpmdb: PANIC: fatal region error detected; run recovery
    error: db4 error(-30978) from db->get: DB_RUNRECOVERY: Fatal error, run database recovery
    error: error(-30978) getting "errmsg.txt" records from Basenames index
    rpmdb: PANIC: fatal region error detected; run recovery
    error: db4 error(-30978) from db->get: DB_RUNRECOVERY:
    etc etc on every file..
    Dep Installed: mysql-devel 4.1.18-1.rhfc2.art.i386 mysql-server 4.1.18-1.rhfc2.art.i386 mysql-compat 4.1.18-1.rhfc2.art.i386
    Transaction(s) Complete


    I thought I did everything listed in this thread in cluding adding the old_passwords to yum.conf but I am still getting this when I go to my Plesk control panel:

    ERROR: Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0: /usr/local/psa/admin/auto_prepend/auth.php3:81 psaerror(string "Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")

    Can anyone tell me what to do to correct this?
    Thanks!!
     
Loading...