• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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