Problem with APSC SQL upgrade 11.0 to 11.5 with autoinstaller

[Sergea]

Hello,
My environment - CentOS 6.4 and Plesk 11.0.9 Update #55.

The following problem arise when using upgrade from Plesk Panel 11.0 to 11.5 via shell command
/usr/local/psa/admin/bin/autoinstaller

...during process:
The following product versions are available:

1. [*] Parallels Plesk Panel
2. (*) Parallels Plesk Panel 11.5.30
3. ( ) Parallels Plesk Panel 11.0.9 (stable) (currently installed)

...upgrade started and come to

===> Performing safe prep-install database actions
===> Upgrading database

Trying to start service mysqld... mysqld (pid 4323) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011009
Trying to backup MySQL database... Warning: Not dumping MySQL database 'atmail' as it doesn't exist
done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.11.0.9-11.5.30.20130629-184036.dump.gz
Trying to upgrade APS controller database...
===> Cumulative APS controller database (apsc) upgrade has been started.
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.apsc.11.0.9-11.5.30.20130629-184038.dump.gz
ERROR 1548 (HY000) at line 67: Cannot load from mysql.proc. The table is probably corrupted
InnoDB

...and sad finish
ERROR while trying to upgrade APSC SQL database from 11.1.0
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
===> Restoring APS controller database from backup '/var/lib/psa/dumps/mysql.preupgrade.apsc.11.0.9-11.5.30.20130629-184038.dump.gz'
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try installing the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.

Does anybody knows the problem solution ?
Is this a bug of Plesk 11.5 autoinstaller package ?

Thanks in advance,
Regards
Serge

 

[Nikolay.]

Try mysql_upgrade. http://forum.parallels.com/showthread.php?287854-Problem-Upgrading-from-11-0-9-to-11-5-29

 

[Sergea]

Yes, Nikolay, thank you !
So now we know how to solve it.
FIRST run
mysql_upgrade -uadmin -p` cat /etc/psa/.psa.shadow`
AFTER that
/usr/local/psa/admin/bin/autoinstaller

There is another question for 11.5
Although installation is successful and NGINX installed, enabled and running - there are no visible options to choose PHP-FPM application
as stated on http://download1.parallels.com/Plesk/PP11/11.5/Doc/en-US/online/plesk-administrator-guide/index.htm?fileName=70742.htm

Service Plans - edit UNLIMITED - Hosting Parameters
PHP support - Run PHP as Apache module OR CGI application OR FastCGI application - that's all.
No any PHP-FPM application in the list

What could be a reason and solution for that ?

 

[Faris Raouf]

Although installation is successful and NGINX installed, enabled and running - there are no visible options to choose PHP-FPM application

You need to enable certain repos, like remi, and install the necessary packages first.

There are some instructions somewhere, but for some reason I can't find them. If I find it I'll get back to you. In the meantime, try searching for "plesk 11.5 nginx php-fpm" on google to see if you can find what I'm talking about. I know it is there somewhere. I've read it! I just can't seem to see it :-(

 

[Nikolay.]

Yes, you need to enable a third-party repository that provides php-fpm and then install it via Autoinstaller. The component you need is in the same group as nginx reverse proxy server support.

If you use console Autoinstaller mode and did not enable appropriate repository, the component will be marked with [!] which means "unavailable".

 

[Sergea]

Regarding PHP-FPM application NOT in the list of PHP options:
My report is
1) I've enabled ATOMIC repo before run /autoinstaller
2) After upgrade from 11.0.9 to 11.5.30 via shell /autoinstaller - I used Plesk interface as
Tools & Settings - Updates and Upgrades - Add Component - NGINX as reverse mode and PHP-FPM marked and successfully installed.
3) After that I run shell command
/usr/local/psa/admin/bin/nginxmng --enable
and restart server

AFTER server restart I check via shell
service nginx status
it reports
nginx (pid 2061) is running...

So we know we have nginx installed and even running.

But I still have the same problem as above
Plesk Panel interface - Service Plans - edit UNLIMITED - Hosting Parameters
PHP support - Run PHP as Apache module OR CGI application OR FastCGI application - that's all. ONLY 3 options and no any PHP-FPM application in the list.

So the problem is still here.
Would be obliged for any opinions/hints !

 

[Nikolay.]

PHP-FPM management is elsewhere in the panel, near other nginx settings. Please address Plesk documentation for exact steps.

 

[Sergea]

I agree - please, read documentation on http://download1.parallels.com/Plesk/Doc/en-US/online/plesk-administrator-guide/index.htm?fileName=71997.htm - there is 1 comment there from another man who has the same problem.
Everything is installed, enabled and running - but on Plesk Panel there are only 3 Apache PHP options without PHP-FPM.
So there is no a possibility to use documentation as nothing to enable via Plesk Panel...

By the way - do you know what file contains list of cronjobs created via Tools & Settings - Scheduled Tasks ?
I would like to backup this file before full server reinstallation (data will be lost)
Thank you !

 

[Nikolay.]

It is written in several places, including the page you mentioned. Maybe here you'll find it to be less subtle: PHP Handlers. See "PHP-FPM application (Linux only)" row.

If you don't have the "Process PHP by nginx" checkbox - please explicitly state so.

 

[Sergea]

I explicitly state I have no "Process PHP by nginx" checkbox (or drop-down option for Process PHP as) via Plesk Panel GUI - this is why I can't enable it.
Drop-down option contains only "Run PHP as"
- Apache module
- CGI application
- FastCGI application

At the same time nginx and php-fpm were properly installed via GUI Tools & Settings - Update/Upgrade (using of atomic repository as required third-party)

To make sure that nginx and php-fpm are running I used shell
/etc/init.d/php-fpm status
php-fpm (pid 2047) is running...
service nginx status
nginx (pid 2061) is running...

So that it could be a bug of Plesk Panel GUI 11.5.30 on CentOS 6.4 ?

 

[EugeneKazakov]

In Panel UI checkbox "Process PHP by nginx" is situated on "Web Server Settings" form for the domain.
You should have "Hosting settings management" permission

 

[Sergea]

Dear Eugene,
THANK YOU VERY MUCH for the clear direct hint !
I'd advise to include your hint/screenshots to Plesk documentation for 11.5 - because references there create a certain mess where exactly to find this "Process PHP by nginx"...as to me - I was sure it must be done somewhere on a "global" level.
But PLESK solution is much clever to set Process PHP by nginx on an exact Website level.
So now the matter is solved and thank you again !

 

[MisterU]

Did you check corresponding settings in 'Websites & Domains' -> 'Web server settings', 'nginx settings' part?

 

[ParveenK]

Unable to find Web server settings , it's a mess

Did you check corresponding settings in 'Websites & Domains' -> 'Web server settings', 'nginx settings' part?

I also done with all the above settings that SERGEA do and unable to find the option you are talking about>>:"Web Server Settings"

Here is my config:
OS CentOS 6.4 (Final)
Panel version 11.0.9 Update #59

Here is the screenshot, what i found under "Website & Domains">>http://i.imgur.com/b9CZVHy.png

Here is the screenshot to show, everything is running fine>>http://i.imgur.com/xixqj3g.png

Thanks.

 

[EugeneKazakov]

I also done with all the above settings that SERGEA do and unable to find the option you are talking about>>:"Web Server Settings"

Here is my config:
OS CentOS 6.4 (Final)
Panel version 11.0.9 Update #59

Here is the screenshot, what i found under "Website & Domains">>http://i.imgur.com/b9CZVHy.png

Here is the screenshot to show, everything is running fine>>http://i.imgur.com/xixqj3g.png

Thanks.

PHP FPM is available since Plesk 11.5, you have 11.0.9 version.

 

[ParveenK]

So i am using the latest version or old version??

 

[EugeneKazakov]

So i am using the latest version or old version??

You have the old version. There is the newer one, but it has not been marked as stable yet.

 

[ParveenK]

Am i able to use that and how should i upgrade to that?

 

[EugeneKazakov]

Am i able to use that and how should i upgrade to that?

Yes, you're able.
Check "Update and Upgrade Settings". Looks like you have "Late adopter release" checked, try "General release" option and you will have 11.5 in autoinstaller.
See more information about release tiers: http://download1.parallels.com/Ples...-migration-guide/index.htm?fileName=68908.htm

 

[Mar]

Its a pretty nice feature, but is it possible to definie this as a global setting and not only for one domain?