Difference between revisions of "Install wiki on win server"
| Line 1: | Line 1: | ||
'''install:''' | '''install:''' | ||
| − | # | + | # python need 2.7.xx 32bit version (python-2.7.12.msi) |
# php from archive // latest php (64bit threads safe) (php-7.3.2-Win32-VC15-x64.zip) | # php from archive // latest php (64bit threads safe) (php-7.3.2-Win32-VC15-x64.zip) | ||
# latest mysql (mysql-installer-community-8.0.11.0.msi) | # latest mysql (mysql-installer-community-8.0.11.0.msi) | ||
| Line 13: | Line 13: | ||
''backup:'' | ''backup:'' | ||
| − | mysqldump.exe -uroot - | + | mysqldump.exe -uroot -ppassword fieldprowiki > e:\fieldprowiki.sql |
''restore:'' | ''restore:'' | ||
| − | mysql -uroot - | + | mysql -uroot -ppassword fieldprowiki < e:\fieldprowiki.sql |
| Line 22: | Line 22: | ||
# C:\ProgramData\MySQL\MySQL Server 8.0\my.ini - update 'caching_sha2_password' to 'mysql_native_password' | # C:\ProgramData\MySQL\MySQL Server 8.0\my.ini - update 'caching_sha2_password' to 'mysql_native_password' | ||
''and then login in mysql:'' | ''and then login in mysql:'' | ||
| − | # mysql -uroot - | + | # mysql -uroot -ppassword |
# ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'prosuite'; | # ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'prosuite'; | ||
Revision as of 10:47, 27 February 2019
install:
- python need 2.7.xx 32bit version (python-2.7.12.msi)
- php from archive // latest php (64bit threads safe) (php-7.3.2-Win32-VC15-x64.zip)
- latest mysql (mysql-installer-community-8.0.11.0.msi)
- mediawiki from archive
Setup MySQL:
create: mysql -uroot -pprosuite CREATE DATABASE fieldprowiki;
backup: mysqldump.exe -uroot -ppassword fieldprowiki > e:\fieldprowiki.sql
restore: mysql -uroot -ppassword fieldprowiki < e:\fieldprowiki.sql
if 'caching_sha2_password' error - then:
- C:\ProgramData\MySQL\MySQL Server 8.0\my.ini - update 'caching_sha2_password' to 'mysql_native_password'
and then login in mysql:
- mysql -uroot -ppassword
- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'prosuite';
Setup IIS:
- add application pool (with 32bit)
- add default document: index.php
- FastCGI Settings: add application: C:\php\php=cgi.exe
