Missing privilege after 18.04 > 20.04 upgrade

OK if its simpler to do that then so beit. What is the best startpoint please ? Whereby I dont end up changing all passwords etc when (hopefully) I dont need to

 

Apologies for moving goalposts.

I now got the ispconfig update.sh to run through successfully (my fault had mucked up the auth type for mysql.schemas) put that back as should have been and it ran through. So, a step closer
ftp now runs and connects
now still have a handful of DB connection errors, not everywhere though which is odd
I feel like somehow the update to 20 has left out some php versions and I know I needed 7.4 minimum previously which I cannot see for some reason after the upgrade.
Is there an entry point into the perfect server (or part thereof) that I may need to run or re-run to bring the server up to 7.4 minimum (I saw that isp config doesnt like php 8) )

 

After upgrading ubuntu 18.04 to 20.04, you must run through the ISPCOnfig Perfect Server Guide for Ubuntu 20.04 to get necessary packages installed and configurations done. Then do

Code:

ispconfig_update.sh --force

Verify you have default PHP version set to what is default in Ubuntu 20.04.

 

I had a very similar problem since last week and I hope maybe this will help!
ISPConfig (latest version) and web services running perfectly fine but mail services started failing to connect to MySQL and bouncing mails.
Multiple errors in /var/log/mail.log all similar and related to:
postfix/proxymap[21148]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'127.0.0.1' (using password: YES)

No recent major updates or changes EXCEPT for one...
mysqltuner.pl suggested "Variables to adjust: skip-name-resolve=1"
I followed the advice and that's how I started the problem.
MySQL kept working fine but now connections were not recognized as "localhost" anymore in MySQL log but as "127.0.0.1".
My recent ISPConfig installations did NOT create a second "[email protected]" MySQL user but only one, the "ispconfig@localhost".
Therefore "mysql -uispconfig -hlocalhost -p" kept working fine but "mysql -uispconfig -h127.0.0.1 -p" was now failing with:
ERROR 1045 (28000): Access denied for user 'ispconfig'@'127.0.0.1' (using password: YES)


Solutions:
1.If you recently enabled "skip-name-resolve=1" in your /etc/mysql/my.cnf maybe consider removing it, doing a mysql restart (not just reload) and then trying again.
2. If you really need that parameter then I guess as a temporary solution you can always duplicate the existing MySQL user ispconfig@localhost to a new user [email protected] with the same password and verify that they are both working:
mysql -uispconfig -hlocalhost -p
mysql -uispconfig -h127.0.0.1 -p
In normal situations they should both be working fine.
As stated before you can find the clear-text password in /usr/local/ispconfig/interface/lib/config.inc.php.

I really hope this was helpful, I'm not trying to be a wiseguy here, especially on an old topic that Taleman and even till himself replied to!!!