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

Mysql upgrade problems:Plesk 7.5 fedora3

Discussion in 'Plesk for Linux - 8.x and Older' started by AISPL, Dec 2, 2005.

  1. AISPL

    AISPL Guest

    0
     
    I tried upgrade from 3.23.58 to 4.0.26 , doing rmp -Uvh for all four packages rpm(server,client,shared,devel).
    Subsequently doing
    -------------------------------------------------------------------------------------------------------------
    # mysql --version
    # mysql Ver 12.22 Distrib 4.0.26, for pc-linux-gnu (i686)

    # rpm -qa | grep -i mysql
    MySQL-server-4.0.26-0
    MySQL-devel-4.0.26-0
    php-mysql-4.3.11-2.8
    perl-DBD-MySQL-2.9003-5
    MySQL-shared-compat-4.0.26-0
    MySQL-client-4.0.26-0
    -------------------------------------------------------------------------------------------------------------

    I could not connect to mysql, mysqldlog was
    -----------------------------------------------------------------------------------------------------
    051202 08:14:32 mysqld started
    051202 8:14:32 Can't start server: Bind on TCP/IP port: Address already in use
    051202 8:14:32 Do you already have another mysqld server running on port: 3306 ?
    051202 8:14:32 Aborting
    051202 8:14:32 /usr/sbin/mysqld: Shutdown Complete
    051202 08:14:32 mysqld ended
    -----------------------------------------------------------------------------------------------------------------


    I serached and Followed http://www.whoopis.com/howtos/php5-mysql4-FC3-rpm.html
    Error changed
    ---------------------------------------------------------------------------------------------------------------------
    051202 08:36:24 mysqld started
    Fatal error: Can't change to run as user 'mysql'. Please check that the user exists!
    051202 8:36:26 Aborting

    051202 8:36:26 /usr/sbin/mysqld: Shutdown Complete

    051202 08:36:26 mysqld ended
    ------------------------------------------------------------------------------------------------------------
    Then upon /sbin/reboot, error changed to
    -----------------------------------------------------------------------------------------------------------
    051202 22:47:54 mysqld started
    051202 22:47:54 Warning: Can't create test file /var/lib/mysql/air838.lower-test
    /usr/sbin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
    051202 22:47:54 Aborting
    051202 22:47:54 /usr/sbin/mysqld: Shutdown Complete
    051202 22:47:54 mysqld ended

    PS (air8383 is my server name)


    Any help will be appreciated
     
  2. AISPL

    AISPL Guest

    0
     
    Well overcomed that with enforcing --force with rpm -Uvh

    Now as in the process i have not backed up databases.(Since I have not created any) and deleted va/lib/mysql, i am getting this error now, when accessing my plesk interface.

    ERROR: Unable to query: Table 'psa.misc' doesn't exist 0: /usr/local/psa/admin/plib/common_func.php3:203 psaerror(string "Unable to query: Table 'psa.misc' doesn't exist") 1: /usr/local/psa/admin/plib/common_func.php3:390 db_query(string "select param, val from misc") 2: /usr/local/psa/admin/plib/class.Session.php:113 get_param(string "login_timeout") 3: /usr/local/psa/admin/auto_prepend/auth.php3:139 Session->Session()

    I am very new to plesk. (two days back i got one server on plesk)It was hard to note that plesk uses mysql table for login. Ensim and others does not. What will happen if some user doesnot want mysql and stop it to have memory. Plesk will not work.

    Please help.
     
Loading...