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

Update from 8.4 to 8.6 get a error

Discussion in 'Plesk for Linux - 8.x and Older' started by Edmund@, Aug 27, 2008.

  1. Edmund@

    Edmund@ Guest

    0
     
    Hi Folks,

    i have a big Problem i hope you can please Help me,

    i have make a Update on a Linux SuSE 9.3 Server from 8.4 to 8.6 over the Plesk webconfig, but the Updatet get a error "Plesk autoupdate failure"

    and now i can not Start the "psa" Service, so my Plesk is not running :-(

    Please Help me, when you need more logs no problem, tell me

    i hope you can help me

    when i start the psa Service:

    s15224170:/etc/init.d # ./psa start
    Starting xinetd service... done
    Starting named service... done
    Starting mysql service... done
    Starting qmail service... done
    Starting courier-imap service... done
    Starting postgresql service... not installed
    Starting psa-spamassassin service... not installed
    Syntax OK
    Starting Plesk... done
    Starting drwebd service... not installed

    s15224170:/etc/init.d # ./psa status
    psa dead but subsys locked
    s15224170:/etc/init.d #


    i have Try this, but this whos dont work

    cd /root/psa/PSA_8.6.0/dist-rpm-SuSE-10.1-x86_64/base
    rpm -Uvh * --force

    her is the Install Update log:

    http://www.ejro-it.de/error.txt
     
  2. Ma2T

    Ma2T Guest

    0
     
    I'm a big time novice to plesk, so i'm far from an expert.

    But after looking through your install error log, the problems seem to happen after mysql tries (and fails) to restart.

    ===> Installing psa database
    Trying to start MySQL server... Trying to define valid mysql credentials... Trying to establish test connection...

    Check the error reason(see log file: /tmp/psa_8.6.0_suse9.3.build86080722.00_upgrade.080815.15.56.log

    Seems to me that you need to fix the connection to mysql, then it might work okay?
     
  3. Edmund@

    Edmund@ Guest

    0
     
    Hi Ma2T,

    hmm when i look in the log file (/tmp/psa_8.6.0_suse9.3.build86080722.00_upgrade.080815. 15.56.log)

    he can not conect to MySQL, but MySQL works fine

    all outer webseits can working whis my MySQL.

    i can seein the log file he can not open the /root/.my.cnf file,

    the file dont exist on my Server

    do you have i idee ???


    ===> Installing rbash
    Checking that /bin/rbash registered as login shell...
    /bin/rbash
    /bin/rbash is already registered as login shell

    Trying to restart service mysql... Checking for service MySQL: ..running
    done
    ===> Installing psa database
    Trying to start MySQL server... Checking for service MySQL: ..running
    Trying to define valid mysql credentials... Trying to establish test connection... ERROR 2013 (HY000): Lost connection to MySQL server during query
    Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Trying to establish test connection... Could not open required defaults file: /root/.my.cnf
    Fatal error in defaults handling. Program aborted

    ERROR while trying to establish test connection

    Aborting...
     
  4. Ma2T

    Ma2T Guest

    0
     
    Hi Edmund,

    Thats intersting that Mysql still works for other sites, I don't know :/ . Sorry I can't help you more.

    I hope someone who knows more will reply for you.
     
  5. hardweb

    hardweb Guest

    0
     
    This issue can have roots in multiple issue, anyway you should check what's the problem with MySQL. Take a look to the MySQL log file and startup options (although these should not have changed). With access to the server it's not difficult to solve.
     
  6. Edmund@

    Edmund@ Guest

    0
     
    this is the MySQL Log ( /var/lib/mysql/mysqld.log )


    080901 13:28:38 mysqld ended

    080901 13:28:43 mysqld started
    080901 13:28:43 InnoDB: Started; log sequence number 0 32495542
    /usr/sbin/mysqld: ready for connections.
    Version: '4.1.10a' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM
    080901 14:15:57 [Note] /usr/sbin/mysqld: Normal shutdown

    080901 14:15:57 InnoDB: Starting shutdown...
    080901 14:16:01 InnoDB: Shutdown completed; log sequence number 0 32499625
    080901 14:16:01 [Note] /usr/sbin/mysqld: Shutdown complete

    080901 14:16:01 mysqld ended

    080901 14:16:01 mysqld started
    080901 14:16:01 InnoDB: Started; log sequence number 0 32499625
    /usr/sbin/mysqld: ready for connections.
    Version: '4.1.10a' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM

    @hardweb
    "With access to the server it's not difficult to solve."

    do you will access on the Server? and help me?
     
  7. Edmund@

    Edmund@ Guest

    0
     
    Hi

    when i start psa.safe

    psa show this

    s15224170:/etc/init.d # ./psa.save start
    xinetd on
    Starting INET services. (xinetd) done
    named 3
    Starting name server BIND - Warning: named already running! done
    mysql 3
    Starting service MySQL done
    qmail on
    Starting qmail: done
    apache2 on
    Syntax OK
    Cannot read ''
    /usr/local/psa/admin/bin/httpsdctl start: httpd could not be started
    Starting Plesk: failed
    s15224170:/etc/init.d # ./psa.save status
    psa is stopped
    s15224170:/etc/init.d #


    i think the Problem is on httpsd
     
  8. Edmund@

    Edmund@ Guest

    0
     
    my Problem is solvd from Parallels Support :)

    -------------------

    Plesk manual upgrade generated the following errors:

    error: db4 error(22) from db->cursor: Invalid argument
    rpmdb: illegal flag specified to DB->cursor
    error: db4 error(22) from db->cursor: Invalid argument

    It indicates the rpm database corruption.
    I have rebuilt it with:
    rm -f /var/lib/rpm/__db.00*
    rpm -vv --rebuilddb

    After that I have launched the manual upgrade, it was necessary because the Plesk database was not properly upgraded:
    s15224170:~ # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select * from misc where param = 'version';"
    +---------+------+
    | param | val |
    +---------+------+
    | version | 0840 |
    +---------+------+

    I have launched the upgrade with:
    s15224170:~/psa/PSA_8.6.0/dist-rpm-SuSE-9.3-i386 # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select * from misc where param = 'version';"

    After that the database was upgraded, Plesk CP is up and running.
     
Loading...