1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Mysql 4.x upgrade failed

Discussion in 'Plesk for Linux - 8.x and Older' started by durodata, Mar 17, 2005.

  1. durodata

    durodata Guest

    0
     
    I tried to upgrade my mysql server from the instructions on ART, but unfortunately it didn't complete successfully


    instructions


    Any way how to fix it?


    [root@www admin]# rpm -e MySQL-Max MySQL-server MySQL-client MySQL-shared-compat --nodeps
    error: package MySQL-Max is not installed
    error: package MySQL-server is not installed
    error: package MySQL-client is not installed
    error: package MySQL-shared-compat is not installed
    [root@www admin]# yum install mysql-server mysql mysql-compat
    Gathering header information file(s) from server(s)
    Server: Atomic Rocket Turtle - 3ES - Atomic PSA-Compatible RPMS
    Server: Atomic Rocket Turtle - 3ES - Atomic Desktop
    Server: Atomic Rocket Turtle - 3ES - Base OS RPMS mirror
    Server: Atomic Rocket Turtle - 3ES - Project Gamera
    Server: Atomic Rocket Turtle - 3ES - SW-Soft PSA 7.0 RPMS
    Server: Atomic Rocket Turtle - 3ES - SW-Soft PSA 7.1 RPMS
    Server: Atomic Rocket Turtle - 3ES - SW-Soft PSA 7.5 RPMS
    Server: Atomic Rocket Turtle - 3ES - OS Update RPMS mirror
    Finding updated packages
    Downloading needed headers
    mysql-devel-0-4.0.24-1.rh 100% |=========================| 6.6 kB 00:00
    mysql-0-4.0.24-1.rhel3.ar 100% |=========================| 12 kB 00:00
    mysql-server-0-4.0.24-1.r 100% |=========================| 6.6 kB 00:00
    mysql-compat-0-4.0.24-1.r 100% |=========================| 5.6 kB 00:00
    Resolving dependencies
    .Dependencies resolved
    I will do the following:
    [install: mysql-compat 4.0.24-1.rhel3.art.i386]
    [update: mysql-server 4.0.24-1.rhel3.art.i386]
    [update: mysql 4.0.24-1.rhel3.art.i386]
    I will install/upgrade these to satisfy the dependencies:
    [deps: mysql-devel 4.0.24-1.rhel3.art.i386]
    Is this ok [y/N]: y
    Downloading Packages
    Getting mysql-devel-4.0.24-1.rhel3.art.i386.rpm
    mysql-devel-4.0.24-1.rhel 100% |=========================| 652 kB 00:06
    Getting mysql-server-4.0.24-1.rhel3.art.i386.rpm
    mysql-server-4.0.24-1.rhe 100% |=========================| 1.4 MB 00:13
    Getting mysql-4.0.24-1.rhel3.art.i386.rpm
    mysql-4.0.24-1.rhel3.art. 100% |=========================| 7.5 MB 02:16
    Getting mysql-compat-4.0.24-1.rhel3.art.i386.rpm
    mysql-compat-4.0.24-1.rhe 100% |=========================| 243 kB 00:04
    Running test transaction:
    Test transaction complete, Success!
    mysql 100 % done 1/7
    mysql-compat 100 % done 2/7
    mysql-devel 100 % done 3/7
    mysql-server 100 % done 4/7
    Completing update for mysql-devel - 5/7
    Completing update for mysql-server - 6/7
    packagemng: db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    packagemng: db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    packagemng: Unable to connect to the mysql database

    System error 2: No such file or directory
    packagemng: Unable to connect to the mysql database

    System error 2: No such file or directory
    error: %trigger(psa-7.5.2-rhel3.build75050130.17) scriptlet failed, exit status 1
    Installed: mysql-compat 4.0.24-1.rhel3.art.i386
    Updated: mysql-server 4.0.24-1.rhel3.art.i386 mysql 4.0.24-1.rhel3.art.i386
    Dep Installed: mysql-devel 4.0.24-1.rhel3.art.i386
    Transaction(s) Complete
    [root@www admin]#
    [root@www admin]# mysql --version
    mysql Ver 12.22 Distrib 4.0.24, for redhat-linux-gnu (i686)
     
  2. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    psa 7.5 added in some triggers that I havent had a chance to fully investigate yet. I suspect they're trying to populate the PSA database indicating what is installed/updated, and mysql is in the midst of restarting at the moment it does that. The installation as you noted however was successful
     
  3. wintech2003@

    wintech2003@ Guest

    0
     
    Do the above instuctions work with CentOS 3.4?
    I have MySQL 4.0.23 installed with Plesk 7.5.2 and want to upgrade to 4.0.24...

    What should my /etc/yum.conf file look like?

    Currently this is my yum.conf:
    Code:
    [main]
    cachedir=/var/cache/yum
    debuglevel=2
    logfile=/var/log/yum.log
    pkgpolicy=newest
    distroverpkg=redhat-release
    installonlypkgs=kernel kernel-smp kernel-hugemem kernel-enterprise kernel-debug kernel-unsupported kernel-smp-unsupported kernel-hugemem-unsupported
    tolerant=1
    exactarch=1
    
    [base]
    name=CentOS-3.4 - Base
    baseurl=http://mirror.trouble-free.net/cAos/centos-3/3.4/os/$basearch/
    gpgcheck=1
    [update]
    name=CentOS-3.4 - Updates
    baseurl=http://mirror.trouble-free.net/cAos/centos-3/3.4/updates/$basearch/
    gpgcheck=1
    [addons]
    name=CentOS-3.4 - Addons
    baseurl=http://mirror.trouble-free.net/cAos/centos-3/3.4/addons/$basearch/
    gpgcheck=1
    [extras]
    name=CentOS-3.4 - Extras
    baseurl=http://mirror.trouble-free.net/cAos/centos-3/3.4/extras/$basearch/
    gpgcheck=1
    [psa-7.5]
    name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.5 RPMS
    baseurl=http://3es.atomicrocketturtle.com/atomic/psa-7.5/3ES/
    baseurl=http://archive.atomicrocketturtle.com/atomic/psa-7.5/3ES/
    baseurl=http://www.atomicrocketturtle.com/atomic/psa-7.5/3ES/
    
    [atomic]
    name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
    baseurl=http://3es.atomicrocketturtle.com/atomic/art/3ES/
    baseurl=http://archive.atomicrocketturtle.com/atomic/art/3ES/
    baseurl=http://www.atomicrocketturtle.com/atomic/art/3ES/
    [app-vault]
    name=Atomic Rocket Turtle - $releaserver - App - Vault
    baseurl=http://3es.atomicrocketturtle.com/atomic/app-vault/
    baseurl=http://archive.atomicrocketturtle.com/atomic/app-vault/
    baseurl=http://www.atomicrocketturtle.com/atomic/app-vault/
    
    Thanks
     
  4. MrBafner

    MrBafner Guest

    0
     
    We had a very serious problem with upgrading MySQL on Redhat 9.0

    The auto-updater stopped on updating the MySQL and corrupted the enitre email system. SQL scripts worked fine but all emails responded with errors in outgoing and incoming emails. MySQL did not respond using putty, and playing around with qmail had no use either.

    I am sure there is a problem with plesk and the latest version of MySQL.

    The final solution resulted in us formatting the linux box, and re-installing the plesk system. It was a major problem, loss of data, and HUGE amounts of complaints from customers.

    I will never use auto-update again..... and wish you all the best.
     
Loading...