Apache php mysql python mod_wsgi install - manually on Windows
2015-07-05 , rev 2015-07-10 Ver 45
1. this document shows several attempts....
This document shows several attempts at finding a combination of packages that works together.
See
#40. That is where I actually started getting somewhere.
10. see also
stack,web,amp,xampp.gsht - manualinstall tab. sheet1 tab compares software versions. 2015-06-28
Sun12.12-PM
https://docs.google.com/spreadsheets/d/1AFIbGWJuyt01jwmQ9WVD76I1DomrxoDrtdw1MAupcqg/edit?usp=sharing
15. Graham posts what to use for mod_wsgi.
https://github.com/GrahamDumpleton/mod_wsgi/blob/develop/win32/README.rst
28. I didn't use this section.... php 5.4.42 vc9 download
"VC9 x86 Thread Safe (2015-Jun-11 01:49:48) Zip [16.47MB] sha1: 7f106152261a04dc3547f0f31b4563cefbe402f4"
http://windows.php.net/download/
29. I didn't use this section.... Struggling to find packages that should work together...
2015-06-28
Sun12.56-PM
vc10 w64: py 3.4 ap24 modwsgi
php is vc 9 11 or 14
http://www.easyphp.org/easyphp-devserver.php
for Windows 7 and 8 Windows 2012
- EasyPHP DevServer 14.1 VC11
- This version supports : PHP 5.6.x / 5.5.x / 5.4.x / 5.3.x
- VC9, VC10 and VC11 VC11 builds don't run on XP and 2003 but load VC9 and VC10 builds.
- All PHP versions can be used (VC9, VC10 and VC11). ref.
http://www.easyphp.org/easyphp-devserver.php
PHP 5.5 (5.5.26) - VC11 x64 Non Thread Safe (2015-Jun-11 02:03:05)
Note: x64 builds are currently experimental
conclusion:
- x64 php is experimental
- may be able to use php vc11 with apache vc10. - 2015-06-28
40. Use w32 vc10 - for apache python and mod_wsgi
vc10 w32:
- py 3.4, ap24, mod_wsgi
vc11:
- php 5.6 w32 (w64 is experimental) [Cannot find vc10 binary for php 5.6]
mysql:
- w64
45. Download..
follow: https://github.com/GrahamDumpleton/mod_wsgi/blob/develop/win32/README.rst
Apache 2.4 win32 VC10 binary
http://www.apachelounge.com/download/win32/
http://www.apachelounge.com/download/win32/binaries/httpd-2.4.12-win32.zip
http://www.microsoft.com/en-us/download/details.aspx?id=30679
download: vcredist 2012 update 4 - w32
php 5.6
http://windows.php.net/download/
http://windows.php.net/downloads/releases/php-5.5.26-Win32-VC11-x86.zip thread safe
Somehow i didn't use this one, not sure why.
http://windows.php.net/downloads/releases/php-5.6.10-Win32-VC11-x86.zip
PHP 5.6 (5.6.10) VC11 x86 Thread Safe (2015-Jun-11 02:33:47)
Python 3.4.3 - 2015-02-25
https://www.python.org/downloads/windows/
https://www.python.org/ftp/python/3.4.3/python-3.4.3.msi
w32 vc10
mod
wsgi
https://github.com/GrahamDumpleton/modwsgi/blob/develop/win32/README.rst
https://github.com/GrahamDumpleton/mod_wsgi/releases
https://github.com/GrahamDumpleton/mod
wsgi/releases/download/4.4.12/modwsgi-windows-4.4.12.tar.gz
https://dev.mysql.com/downloads/windows/installer/
5.6.25
phpmyadmin
http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.4.10/
http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.4.10/phpMyAdmin-4.4.10-english.zip/download
50. unpack and install
- create .gitignore and create git repo to track edits I make to the settings.
I am following this:
http://superuser.com/questions/748117/how-to-manually-install-apache-php-and-mysql-on-windows
- I unpack apache into
c:\p2\damp\apache
- run httpd.exe from command prompt
- need msvcr100.dll -- install 2012 vcredist x86
- set paths in httpd.conf
- win10: no error but httpd just sits there. localhost will not work.
- win10: didn't get firewall request to add httpd to the allowed list.
-
win7: asked to add to firewall. it works.
-
copy php.ini-'dev' to
php.ini
- enable php in
httpd.conf
- test it. it works.
- apache and php are working.
- This will print a text file of the last 1 changes. >>>
git format-patch -1 head --stdout > patch5630a.txt
Install apache as a service.
C:\p2\damp\apache\bin\httpd.exe -k install
C:\Windows\system32>C:\p2\damp\apache\bin\httpd.exe -k install
Installing the 'Apache2.4' service
The 'Apache2.4' service is successfully installed.
Testing httpd.conf....
Mysql
From: C:\p2\damp\,this,\mysql-installer-community-5.6.25.0.msi
- install mysql. it would only go in
program files
. No other choice was offered.
- I installed win64, 64bit.
- (next time do this later) made user dg417 passwd
- root
- done. ok.
55. Phpmyadmin:
https://wiki.phpmyadmin.net/pma/Quick_Install
cd phpMyAdmin
mkdir config # create directory for saving
http://localhost/phpMyAdmin/setup/ ## run setup
had to edit php.ini for mbstring ext. lots of edits.
see git commit
Testing my 'prodrpt' app
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe" --user=root -p -e "create database prodrptdb";
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe" --user=root -p prodrptdb < C:\p2\damp\htdocs\2test\prodrpt\documents\bkups\prodrptexp.sql
Set default collation in mysql.
This didn't do it: SET NAMES 'utf8';
The following worked. It's in
my.ini
David Gleba set default collation...
collationserver=utf8unicode_ci
charactersetserver=utf8
Try this next time:
CREATE USER 'dg417'@'localhost' IDENTIFIED BY '**';
CREATE USER 'dg417'@'%';
GRANT USAGE ON . TO 'dg417'@'localhost' ;
GRANT ALL PRIVILEGES ON prodrptdb
. TO 'dg417'@'%';
60. Install python mod_wsgi module
C:\p2\Python34\
install wsgi module, w32 vc10 ap24 py34.
edit httpd.conf
install python 3.4 w32
cd C:\p2\Python34\Scripts
pip install Django
django get-pip.py
pip install Django
Successfully installed django-1.8.2
pip install django-admin-bootstrapped
Successfully installed django-admin-bootstrapped-2.5.2
I got error on trakberry app but the other two apps work.
Request Method: GET
Request URL: http://localhost:8986/trakberry/admin/
Django Version: 1.8.2
Exception Type: ImportError
Exception Value:
No module named 'views'
90. Summary
Working - per my basic testing by starting them up in a web page:
Apache, mysql, php, python, django, xataface, codeigniter, yii,
2015-07-01
Wed18.49-PM
I think the damp folder is portable. Install mysql and python using the installers.
Everything except for mysql and python are in the
c:\p2\damp
folder.
files used:
httpd-2.4.12-win32-vc10(apache).zip
modwsgi-4.4.12-ap24-py34-VC10-w32.so
Graham Dumpleton's modwsgi-windows-4.4.12.tar.gz
mysql-installer-community-5.6.25.0,win32-and-win64.msi
php-5.5.26-Win32-VC11-x86.zip
phpMyAdmin-4.4.10-english.zip
python-3.4.3.msi (w32, all python windows is vc10 )
vcredist_x86-2012update4.exe
100. Question
I manually installed apache, python, mod
wsgi, mysql and php.
I matched the compiler version -VC10, for python, apache, and modwsgi.
I couldn't find a VC10 binary for PHP 5.5 so I used vc11. Mysql is the 64bit community binary.
Everything seems to be working OK.
Will the combination of vc10/11 compiler and 32/64 bit versions I used work ok, or will it lead to problems? Is there a way to test it other than just using it?
Windows | version | bits | vc |
Apache | 2.4.12 | w32 | vc10 |
Python | 3.4.3 | w32 | vc10 |
MySQL | 5.6.24 | w64 | ? |
PHP | 5.5.26 | w32 | vc11 |
More detailed notes of my installation are at: http://davidgleba.blogspot.ca/2015/07/apache-install-2015-06-28-2md.html
Note: made the installation on st-dgleba machine. 2015-07-01.
105.
I added filezilla server. 2015-07-07
May be best to install over top using installer when installing this on another machine. It will install the service.
110. Compatibility
"although some docuentation suggests that VC10 and VC11 are compatible with each other, I make no guarantee of this."
http://forum.wampserver.com/read.php?2,128113,128268
115. Mysql users.
Removed 'any' user see screenshots in dropbox.
ver7 2015-07-10
Fri12.22-PM
C:\n\Dropbox\csd\computer\damp-2015-07-01\mysqlinstallnotes
120. enable mod_rewrite
uncomment this line in httpd.conf:
LoadModule rewrite_module modules/mod_rewrite.so
This won't display correctly. don't copy and paste this...
AllowOverride none
Require all denied
DocumentRoot "c:/p2/damp/htdocs"
<Directory "c:/p2/damp/htdocs">
Options Indexes FollowSymLinks Includes ExecCGI
AllowOverride All
Require all granted
Find any additional occurrences of the line “AllowOverride None” and change it to “AllowOverride All”.
Used some info of this link below and other info copied from xampp httd.conf.
http://www.webdevdoor.com/php/mod_rewrite-windows-apache-url-rewriting/
ver 8 of damp, 2015-07-10
Fri19.13-PM no zip/7z file made.
.end.
-
-
-