• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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