Friday, July 15, 2016

First attempt on new RD server - WAMP upgrade

Steps for upgrading wamp 22 to 25 on Windows server 2008 OS.

These are fine tuned along the way....still tuning.  the objective of this list is to follow verbatim when i update the live servers.  

This step is only for my RD server.
Make sure the host file has your RD server pointing to its self.

take WAMP 22 off line, using the systray

exit the service using systray, so you can perform next step

rename the wamp folder to wamp22 (keep it around)

Run the vcredit_x64.exe file from this stackoverflow post - proactive step to eliminate .dll error during WAMP 25 install. I had to run both distribution packages referenced in SO post. vcredist_64.exe and vcredist_x86.exe.

Execute the wamp25 installer - accepting defaults.  Hopefully you have proactively removed the annoying install error mentioned in SO post.

stop the new SQL service that was created by the installer - Services: wampmysqld64
 (if you miss this step, you wont be able to perform next - app. still be in memory)

rename the mysql data folder located path wamp\bin\mysql5.6.17 - appending orig. (keeping it around)

copy the data folder from old install to new, copy wamp22\bin\mysql5.4.26\data into wamp\bin\mysql5.5.26 - this is about 4GB - which are the DBs... take a few minutes

Apache update

activate vhost directive in new config file.  wamp\bin\apache\apche2.4.9\conf\httpd.conf - remove comment from line 513.  Browse to the file and edit with Notepad ++.

rename the vhost file from old wamp to new, but first rename the new one by appending _orig to file name.  wamp\bin\apache\apache2.4.9\conf\extra\http-vhost.conf

copy the old httpd-vhost.conf file from wamp22 into wamp.  There are a couple changes I could make to the apache conf. file, to be more 2.4.9 compliant, but I an skipping them for now.  To me that keeps things simpler.

Update PHP settings in new .ini file. wamp\bin\apache\apache2.4.9\bin\php.ini - note apache path. Edit with notepad ++
  1. update post_max_size to 1024M
  2. update upload_max_filesize = 1024 M
  3. ensure max_execution_time = -1 'unlimited
  4. update max_input_vars = 5000 - for those big moodle courses
  5. update max_input_time = -1 ' unlimited
  6. ensure error log is reporting error_log = wamp/logs/php_error.php
Copy moodle code from old wamp to new.  wamp22\www content into wamp\www (690 MB - takes a few minutes)

Update the services

Restart the server - reloading WAMP (If you do not do this, you wont be able to interface with WAMP in systray)

Using the systray, put wamp25 back into on-line mode.  This will allow you to use menu options to remove and create new services for both sql and apache.

Restart all the services,  using WAMP in systray.

For student moodle instance - edit the sync bat file, located in web root www\sync_enrollments_genius.bat. Change the php path in both statements

c:\wamp\bin\php\php5.5.12\php.exe -f c:\wamp\www\student\auth\db\cli\sync_users.php
c:\wamp\bin\php\php5.5.12\php.exe -f c:\wamp\www\student\enrol\database\cli\sync.php

Update the phpMyAdmin config. file, config.inc.php -  so you can use it!  Open the file located at wamp\bin\apps\phpmyadmin.  I added the password for the root user, so I could access my favorite admin app, phpMyAdmin.





No comments:

Post a Comment