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

Updated to 7.5.3 no MySQL backed sites work

Discussion in 'Plesk for Linux - 8.x and Older' started by dofni, Jun 8, 2005.

  1. dofni

    dofni Guest

    0
     
    I used the Updater to install updates on my server. All items that need MySQL are not working and Apache didn't restart on it's own this morning. I had to log in and restart it manually. I can access a database from phpMyAdmin, which now looks totally different, I read about changing some configuration files in the PSA database, but that was for Reloaded 7.1. Those table entries do not exist in 7.5.3. Any solutions out there.

    :)
     
  2. iggypop

    iggypop Guest

    0
     
    Did You take a look on my.cnf? this should show the dbs for mysql. You can find it in /etc/ (hope you are using unix;)).
    Originally looks like:
    ----------
    [mysqld]
    safe-show-database
    innodb_data_file_path=ibdata1:10M:autoextend
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    ----------

    I made the following mods for performance reasons:

    ----------
    [mysqld]
    safe-show-database
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock

    #innodb_data_file_path=ibdata1:10M:autoextend
    innodb_data_file_path=ibdata1:100M:autoextend
    innodb_flush_log_at_trx_commit=1
    set-variable = innodb_file_io_threads=4
    set-variable = innodb_lock_wait_timeout=50


    set-variable = max_allowed_packet=4M
    set-variable = thread_stack=256K
    set-variable = back_log=256
    set-variable = key_buffer=16M
    set-variable = table_cache=256
    set-variable = sort_buffer=16M
    set-variable = record_buffer=5M
    set-variable = max_connections=4096
    set-variable = join_buffer=5M

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    -----------

    finnaly, if this might not help you, take a look @

    7.5.3-rhel3.build75050512.15 apache,webmail,sitebuilder probs
     
Loading...