1. Please take a little time for this simple survey! Thank you for participating!
    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...