ISPConfig no longer creating databases since update to 3.2.5

Hi there, I recently ran a few updates to Ubuntu and ISPConfig and I'm now using Ubuntu 20.04.2 and ISPConfig 3.2.5. (I was on one of the earlier 3.2 revisions before, I can't remember exactly which one).

Since making the update, ISPConfig is no longer creating databases or database users. It goes through the motions and shows the databases and users in the list, they're just not created in MySQL. I can create them manually with phpmyadmin and the existing databases and sites are all working fine, I just can't create new ones.

I've followed the debug steps, but I'm not seeing any errors relating to the creation of databases, only a couple of PHP Warnings here and there.

My apologies, but my web server knowledge is very limited. In the past ISPConfig has just worked exactly as it should.

Can anyone offer any suggestions of things I might try?

Thanks in advance,
Bruce

 

Thanks for your reply, and sorry for the delay. Here is the server.sh debug output.

03.08.2021-15:01 - WARNING - There is already a lockfile set, but no process running with this pid (2684615). Continuing.
PHP Warning: Undefined array key "php_fpm_incron_reload" in /usr/local/ispconfig/server/plugins-available/z_php_fpm_incron_reload_plugin.inc.php on line 109
03.08.2021-15:01 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
03.08.2021-15:01 - DEBUG - Found 58 changes, starting update process.
03.08.2021-15:01 - DEBUG - Calling function 'ssl' from plugin 'apache2_plugin' raised by event 'web_domain_insert'.
PHP Warning: Undefined array key "CA_path" in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 269
03.08.2021-15:01 - DEBUG - Calling function 'insert' from plugin 'apache2_plugin' raised by event 'web_domain_insert'.
03.08.2021-15:01 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client1/web8' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client1/web8' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: cp '/usr/local/ispconfig/server/conf/error/en/'* '/var/www/clients/client1/web8/web/error/' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: chmod -R a+r '/var/www/clients/client1/web8/web/error/' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: chmod -R a+r '/var/www/clients/client1/web8/web/' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: df -T '/var/www/clients/client1/web8'|awk 'END{print $2,$NF}' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: which 'setquota' 2> /dev/null - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: setquota -u 'web8' '0' '0' 0 0 -a &> /dev/null - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: setquota -T -u 'web8' 604800 604800 -a &> /dev/null - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: chown -R 'web8':'client1' '/var/www/clients/client1/web8/web' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: chown 'web8':'client1' '/var/www/clients/client1/web8/web' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client1/web8' - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: usermod --groups sshusers 'web8' 2>/dev/null - return code: 0
03.08.2021-15:01 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client1/web8' - return code: 0
PHP Warning: Undefined array key "template" in /usr/local/ispconfig/server/lib/classes/tpl_ini.inc.php on line 92
PHP Warning: Trying to access array offset on value of type null in /usr/local/ispconfig/server/lib/classes/tpl_ini.inc.php on line 92
PHP Warning: Undefined array key "template" in /usr/local/ispconfig/server/lib/classes/tpl_ini.inc.php on line 92
PHP Warning: Trying to access array offset on value of type null in /usr/local/ispconfig/server/lib/classes/tpl_ini.inc.php on line 92
03.08.2021-15:01 - DEBUG - safe_exec cmd: which 'apache2ctl' 2> /dev/null - return code: 0
PHP Warning: Undefined array key "website_autoalias" in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 1415
PHP Warning: Undefined array key "custom_php_fpm_socket_dir" in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 1661
PHP Warning: Undefined array key "vhost_proxy_protocol_enabled" in /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php on line 1806
03.08.2021-15:01 - DEBUG - Writing the vhost file: /etc/apache2/sites-available/recapamac.com.au.vhost
03.08.2021-15:01 - DEBUG - Removing symlink: /etc/apache2/sites-enabled/100-recapamac.com.au.vhost->/etc/apache2/sites-available/recapamac.com.au.vhost
03.08.2021-15:01 - DEBUG - Creating symlink: /etc/apache2/sites-enabled/100-recapamac.com.au.vhost->/etc/apache2/sites-available/recapamac.com.au.vhost
PHP Warning: Undefined array key "template" in /usr/local/ispconfig/server/lib/classes/tpl_ini.inc.php on line 92
PHP Warning: Trying to access array offset on value of type null in /usr/local/ispconfig/server/lib/classes/tpl_ini.inc.php on line 92
PHP Warning: Undefined array key "template" in /usr/local/ispconfig/server/lib/classes/tpl_ini.inc.php on line 92
PHP Warning: Trying to access array offset on value of type null in /usr/local/ispconfig/server/lib/classes/tpl_ini.inc.php on line 92
03.08.2021-15:01 - DEBUG - safe_exec cmd: which 'apache2ctl' 2> /dev/null - return code: 0
PHP Fatal error: Uncaught TypeError: count(): Argument #1 ($var) must be of type Countable|array, bool given in /usr/local/ispconfig/server/lib/classes/tpl.inc.php(1344) : eval()'d code:77

Stack trace:
#0 /usr/local/ispconfig/server/lib/classes/tpl.inc.php(1344): eval()
#1 /usr/local/ispconfig/server/lib/classes/tpl.inc.php(788): tpl->_parse()
#2 /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php(3456): tpl->grab()
#3 /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php(1998): apache2_plugin->php_fpm_pool_update()
#4 /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php(499): apache2_plugin->update()
#5 /usr/local/ispconfig/server/lib/classes/plugins.inc.php(120): apache2_plugin->insert()
#6 /usr/local/ispconfig/server/mods-available/web_module.inc.php(136): plugins->raiseEvent()
#7 /usr/local/ispconfig/server/lib/classes/modules.inc.php(302): web_module->process()
#8 /usr/local/ispconfig/server/lib/classes/modules.inc.php(235): modules->raiseTableHook()
#9 /usr/local/ispconfig/server/server.php(180): modules->processDatalog()
#10 {main}

thrown in /usr/local/ispconfig/server/lib/classes/tpl.inc.php(1344) : eval()'d code on line 77

[web8]

listen = /var/lib/php7.4-fpm/web8.sock
listen.owner = web8
listen.group = www-data
listen.mode = 0660
user = web8
group = client1
pm = ondemand
pm.max_children = 10
pm.process_idle_timeout = 10s;
pm.max_requests = 0

chdir = /

env[HOSTNAME] = $HOSTNAME
env[TMP] = /var/www/clients/client1/web8/tmp
env[TMPDIR] = /var/www/clients/client1/web8/tmp
env[TEMP] = /var/www/clients/client1/web8/tmp
env[PATH] = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

php_admin_value[open_basedir] = /var/www/clients/client1/web8/web:/var/www/clients/client1/web8/private:/var/www/clients/client1/web8/tmp:/var/www/recapamac.com.au/web:/srv/www/recapamac.com.au/web:/usr/share/php5:/usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin:/dev/random:/dev/urandom

php_admin_value[session.save_path] = /var/www/clients/client1/web8/tmp
php_admin_value[upload_tmp_dir] = /var/www/clients/client1/web8/tmp
php_admin_value[sendmail_path] = "/usr/sbin/sendmail -t -i -f [email protected]"

 

Thanks so much for your help, that did the trick.
It must have changed to PHP 8 with my latest Ubuntu update. Now that I've set it to "manual mode" hopefully it will stay on 7.4 in the future.
Once again, thank you very much.

 

I did fine mine changed too when I did Ubuntu upgrade long time ago so I use monit to monitor that with my script shared in here.