I'm willing to PAY to get help on this.

[mysticav]

One year trying to upgrade from 8.4 to 8.6 (now 9.0) with no success.

I try to contact plesk support and I don't get any help.

The error is :

ERROR: PleskMainDBException
Up LevelUp Level
MySQL query failed: MySQL server has gone away

0: /usr/local/psa/admin/plib/common_func.php3:214
db_query(string 'SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources')
1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:136
AutoInstallerVendorSource::getVendorSources()
2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
AutoInstallerManager->install(string 'PLESK_8_4_0', array, boolean false, string '[email protected]', boolean true)
3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:101

If somebody knows how to fix it. Please let me know. I will pay for the solution.

 

[atomicturtle]

Heh, no need for that from me...

This line here:
MySQL query failed: MySQL server has gone away

Any chance mysql was restarted when you were doing this? Or does it happen every single time you try to do this?

 

[mysticav]

Thanks for your help.

MySQL is working perfectly. Every time I try the upgrade I get this error.

Se attachment. Those are the upgrade options.

 

[mysticav]

I tried also with autoinstaller, I get a different error. See attachment.

 

[onsightdata]

You could pay for a ticket to plesk i think its about 70 bucks and I am sure they would help you.

However as someone who regrets every single day upgrading to 9.0 ( more like swearing and pissed off ) If you are running a production server with alot of clients and don't want to spend all your time on plesk forums fixing the mass of email issues. Losing all your backups when you upgrade the list goes on.

DON'T DO IT!

 

[atomicturtle]

Well that latter autoinstaller error message just means it couldnt talk to the update server. Have you tried upgrading with yum?

 

[mysticav]

Finally I was able to upgrade it via autosinstaller command line. But Plesk 9.0 has some issues. Now horde webmail is not working. (No webmails are installed anymore). Dr Web is not working. And Still, I get the MySQL error when I try to upgrade via Control Panel. Maybe is because I have Fedora 6, and it comes with MySQL 4, but I upgraded it to the latest version (5.1). So Maybe The Plesk version they offer for FC6 could be targeted to MySQL 4.

 

[atomicturtle]

that will do it all right, mysql 5.1 is not really compatible with plesk

 

[mysticav]

Anyway, There must be a patch to work with MySQL 5.0.

I don't understand why Plesk 9.0 didn't consider the migration to MySQL 5

 

[atomicturtle]

Plesk supports mysql 5.0 just fine, so you shouldnt have any trouble with that

 

[mysticav]

Do you mean it supports 5.0 but not 5.1 ?

 

[onsightdata]

Not sure about 5.1 . Did you upgrade mysql before you updated? You really need to stick with the default plesk update files or the much better solution is to add the atomic turtle repo's. He does an amazing job providing updated files that are compatible with plesk products and all for free ( Which a million thanks to him for )

 

[mysticav]

I'm using remi repos

 

[atomicturtle]

That is correct, Plesk supports Mysql 5.0. It does not support 5.1

My repo is plesk-focused (because I am one of the founders of Plesk ), and everything in it I run on a plesk system in one way or another.

 

[mysticav]

Is mysql-5.0.27-1.fc6.i386.rpm OK for Plesk 9 ??

 

[atomicturtle]

Absolutely

 

[mysticav]

Finally I got the solution, even with 5.1

You just need to increase the timeout in mysql conf file:/etc/my.cnf

wait_timeout = 120
connect_timeout = 120

 

[atomicturtle]

Hey thanks for the followup, thats great news. I might add mysql 5.1 packages to atomic now. Please let us know if you encounter any other problems with it (no matter how minor!)

 

[mysticav]

Everything is working fine!