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

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

    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

    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

    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.