[GUIDE] ZPanel 6.1.1 Windows Stack Upgrade

[pjduplooy]

Hi guys

Here is my contribution to ZPanel.

I know this has been covered in various other topics, but here is my guide to upgrade the stack and other third party components of ZPanel 6.1.1 for Windows.

If at all possible perform these steps after an initial install of ZPanel, as I do not know if third party modules are comaptible with PHP 5.3.8, and if they are not, I suppose the Devs will happily upgrade the scripts.

INITIAL REQUIREMENT

EDIT: LINK UPDATED

Download zpanel_upgrade.rar from http://www.mediafire.com/?k3rrjhta9uh6i9p.

This file contains three archives, filezilla.rar, php_suhosin.rar, and roundcubemail-0.7-beta.rar.

filezilla.rar is the upgraded filezilla server executables, and dll's

php_suhosin.rar is the upgraded php_suhosin.dll for PHP 5.3.8
roundcubemail-0.7-beta.rar is the upgraded roundcube webmail interface, without all the unneeded files.


INSTRUCTIONS

1. Extract zpanel_upgrade.rar to a temporary directory.

2. Extract filezilla.rar, php_suhosin.rar and roundcubemail-0.7-beta.rar in that temporary directory.

3. Open the Windows Services applet (either by typing in services.msc in a command prompt, or by opening it from Adminstrative Tools in Control Panel.

4. Open a command shell.

UPGRADE APACHE

5. Stop the Apache service in the Windows Services Applet.

6. Copy your c:\ZPanel\bin\apache folder to a temporary folder.

7. Download apache_2.2.21-x86-openssl-1.0.0e.msi from http://www.anindya.com/.

8. Install apache_2.2.21-x86-openssl-1.0.0e.msi. This will install to C:\Program Files (x86)\Apache Software Foundation\Apache2.2.

9. Copy the 'bin' and 'modules' folders from C:\Program Files (x86)\Apache Software Foundation\Apache2.2 folder to your c:\ZPanel\bin\apache folder. and overwrite everything.

10. In the command shell do the following:

cd \ZPanel\bin\apache\bin
httpd -k uninstall

cd \ZPanel

This will remove the Apache service that was installed in step 8, leaving only one Apache service, the upgraded ZPanel one.

11. Apache is now upgraded to 2.2.21.

UPGRADE PHP

12. Download php-5.3.8-Win32-VC9-x86.zip from http://windows.php.net/download/. This is the thread safe version of PHP 5.3.8 compiled with VC9. This version is to be used with the downloaded Apache 2.2.21, as the Apache installer from the official Apache.org website can not be used with PHP 5.3.8.

13. Copy your c:\ZPanel\bin\php folder to a temporary folder.

14. Extract php-5.3.8-Win32-VC9-x86.zip to a temporary folder.

15. Copy all files from this folder to c:\ZPanel\bin\php, and overwrite everything in there.

UPGRADE SUHOSIN

This is very important, since if you do not do this, Apache WILL not start.

16. Copy the file php_suhosin.dll that you extracted from php_suhosin.rar in steps 1 and 2 to c:\ZPanel\bin\php\ext, and overwrite the existing one.

17. PHP is now upgraded to 5.3.8, and you have also a compatible suhosin.

18. Start the Apache service in the Windows Services applet.

19. Log in to your ZPanel Control Panel, to see if these upgrades have taken effect.

UPGRADE MYSQL

20. Copy your c:\ZPanel\bin\mysql folder to a temporary folder.

21. Backup your Main MySQL database. I personally use the MySQL Workbench from the Official MySQL website to accomplish this, but feel free to use anything else.

22. Stop the MySQL service in the Windows Service applet.

23. Download mysql-5.5.19-win32.zip from http://www.mysql.com/downloads/mysql/.

24. Extract mysql-5.5.19-win32.zip to a temporary folder.

25. Copy the extracted files to your c:\ZPanel\bin\mysql folder, and overwrite.

26. In your Command Shell do the following:

cd \ZPanel\bin\mysql\bin
mysqld --remove
mysqld --install
cd \ZPanel

This wil remove the old MySQL Service, and install a new one.

27. In the Windows Service applet, start the MySQL Service.

28. Using MySQL Workbench or the application that you prefer, login to your MySQL Server. You will be able to login with an "empty" root password.

29. Restore your main MySQL database from where you had it backed-up. This will restore passwords, tables, etc.

30. Log out from the database server.

31. In your Command Shell do the following:

cd \ZPanel\bin\mysql\bin
mysql_upgrade.exe -uroot > mysql_upgrade_output.txt
cd \ZPanel
exit

This will upgrade the databases.

32. You can now log on to your Database Server again with your "old" MySQL root password.

33. MySQL is now upgraded to 5.5.19

34. Log on to you ZPanel Control Panel, to see if the update worked.

UPGRADE FILEZILLA SERVER

35. Copy your c:\ZPanel\bin\filezilla folder to a temporary folder.

36. In the Windows Service applet, stop the Filezilla Server service.

37. Copy the files that you extracted from the filezilla.rar file (refer to steps 1 and 2) to c:\ZPanel\bin\filezilla folder, and overwrite.

38. In the Windows Service applet, start the Filezilla Server service.

39. Filezilla Server has now been upgraded to 0.9.40.

40. You can close the Windows Service applet.

Notes on Filezilla Server upgrade.

The reason why I have made this archive (filezilla.rar), is that there is no zip file (that I know of) available from the Filezilla Official Website, and I couldnt find one on the net. Before I installed ZPanel, I installed the Filezilla Server installer, copied the necessary files, made an archive of them, and uninstalled Filezilla Server, and the installed ZPanel 6.1.1. If you use the Filezilla Server installer after an install of ZPanel, you get a screwed up install, and I was too lazy to see how that can be fixed, so it was just easier to do it this way. LOL


UPGRADE OF PHPSYSINFO, PHPMYADMIN

These steps are optional.

41. Copy the following folders to a temporary folder:

c:\ZPanel\panel\apps\phpmyadmin, and
c:\ZPanel\panel\apps\phpsysinfo.

42. Download phpsysinfo from http://phpsysinfo.sourceforge.net/.

43. Download phpMyAdmin from http://www.phpmyadmin.net/home_page/index.php

44. Extract these two files in a temporary folder.

45. Copy the files in the extracted folders into

c:\ZPanel\panel\apps\phpmyadmin, and
c:\ZPanel\panel\apps\phpsysinfo

respectively, and overwrite the previous files.

46. phpSysInfo is now upgraded to 3.0.15.

47. phpMyAdmin is now upgraded to 3.4.8.

UPGRADE ROUNDCUBE WEBMAIL

Again these steps are optional.

48. Copy your c:\ZPanel\panel\apps\webmail to a temporary folder.

49. Copy the files that you extracted from roundcubemail-0.7-beta.rar (refer to steps 1 and 2) into your c:\ZPanel\panel\apps\webmail, and overwrite.

50. Roundcube Webmail is now upgraded to 0.7 beta.

DONE!!

I hope you find this usefull, and do not hesitate to contact me here or pm if you have any further questions or suggestions.



Regards

Pieter

[rustus]

Awesome work, an thank you for posting this. I am sure that people will find it useful! Off the top of my head I can only think of 1 thing, and that is that there are some special configuration in phpmyadmin to prevent users from bypassing ZPanel limits and settings, so be careful to replace those!

Thanks again!

[pjduplooy]

Rustus

I have used the config.inc.php file that was installed with a fresh install of ZPanel. Do you perhaps know where what you are mentioning is changed in phpmyadmin?

Pieter

[rustus]

Nope, thats the one. I just didnt see anywhere in your document where you had people save this from being overwritten. :P

[pjduplooy]

It isnt in the dosument as the the archives you download does not contain a config.inc.php, but rather a generic config.sample.inc.php that you have to adapt to your installation and eventually rename to config.inc.php

[rustus]

Ahhh... sounds like you got it covered then!

[ballen]

JFYI - The only things that I've disabled from the phpMyAdmin config is the ability to CREATE and DELETE databases as well as suppressing the php_suhosin error but that should all be in the standard config.php and like you say, if your using that then you should be ok anyways

[agungstiawan]

Halo sir, thank you for posting this. but i am can't download zpanel_upgrarde.rar coz link has failed.

Thanks again!

[pjduplooy]

Hi agungstiawan

Unfortunately, I decided to take the files down from mediafire, as these were not an official upgrade to ZPanel 6.1.1.

I should have updated this post to reflect this.

I would suggest that you wait another week for the launch of ZPanelX, an incredible new version of ZPanel, and well worth the wait.

[rpm123]

/me likes ZPX