Solving some 8.0 to 8.1 problems

[MarcosBL]

Sorry for the bad english, just a quick note that could help someone:

After upgrading from 8.0 to 8.1 almost everything stopped working:

- Email
- DNS
- Plesk
- MySQL

While httpd seems to work fine... but my vhost are completly lost... every host points to Plesk default page.

When i try to login in Plesk i get a:

ERROR: PleskFatalException
Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to connect to Plesk Database: Client does not support authentication protocol requested by server; consider upgrading MySQL client
packagemng: Unable to connect to the mysql database

0: /usr/local/psa/admin/auto_prepend/auth.php3:484

If i try to start Plesk via command line i get:

[root@llwb320 root]# service psa start
Unable to connect to Plesk Database: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Unable to connect to mysql database

System error 25: Inappropriate ioctl for device
Starting psa-spamassassin service: [FAILED]
/usr/local/psa/admin/bin/httpsdctl start: httpd (pid 3377) already running
....

I get similar errors regarding database connectivity each time i ry to upgrade using the command line autoinstaller... so in the end my solution was:

# mysql -uadmin -pYOUR_DB_PASSWORD
mysql> use psa;
Database changed
mysql> UPDATE mysql.user SET Password=OLD_PASSWORD('YOUR_DB_PASSWORD') WHERE User='admin';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> UPDATE mysql.user SET Password=OLD_PASSWORD('YOUR_DB_PASSWORD') WHERE User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
Bye



# /usr/local/psa/admin/bin/websrvmng -a -v

The first MySQL steps fixes the MySQL passwords (Notice the OLD_PASSWORD function) so the psa software can connect to the database. You need to flush privileges too in order to get the changes working.

The second step, websvrmng rebuilds the vhosts part, so everything works fine in my server now, a pretty old Fedora Core 1.

It was not so " just a quick note " in the end... but i hope it helps someone.