• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Updated to 7.5.3 no MySQL backed sites work

D

dofni

Guest
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.

:)
 
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
 
Back
Top