Difference between revisions of "Install wiki on win server"

From MPSWiki
Jump to: navigation, search
 
(29 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
install:
+
=Prepare=
−
# pyton need 2.7.xx 32bit version (python-2.7.12.msi)
+
==Python==
−
# php from archive // latest php (64bit threads safe) (php-7.3.2-Win32-VC15-x64.zip)
+
#Install [https://drive.google.com/u/0/uc?id=1tHvZMHZxkApbz0WQP1ALtZS_IxHXn_u0&export=download Python]
−
# latest mysql (mysql-installer-community-8.0.11.0.msi)
+
==PHP==
 +
#[https://drive.google.com/u/0/uc?export=download&confirm=Zt0E&id=12bQS-caoryip0wIn78IMoAV4AiNo4O-6 Download PHP archive]
 +
##Extract all files from archive to C:\PHP\
 +
##[[File:Php-mapping.png]]
 +
##Click '''Add Module Mapping'''
 +
##[[File:Php-edit-mapping.png]]
 +
##Add default document: [[File:Php-default.png]]
 +
==MYSQL==
 +
#[https://drive.google.com/u/0/uc?id=1ByVELx1RIdFGKO3DYPwP_DoK2bNZBdlH&export=download Install MYSQL]
 +
##Select Custom
 +
##Install Server
 +
##Install WorkBench
 +
##Install MYSQL shell
  
−
create:
+
==Media WIKI==
−
mysql -uroot -pprosuite
+
# mediawiki from archive
 +
 
 +
=Setup MySQL=
 +
 
 +
# install with legacy password
 +
# remove .NET connector
 +
 
 +
 
 +
''create:''
 +
mysql -uroot -ppassword
 
CREATE DATABASE fieldprowiki;
 
CREATE DATABASE fieldprowiki;
  
−
backup:
+
''backup:''
−
mysqldump.exe -uroot -pprosuite fieldprowiki > e:\fieldprowiki.sql
+
mysqldump.exe -uroot -ppassword fieldprowiki > e:\fieldprowiki.sql
 +
 
 +
''restore:''
 +
mysql -uroot -ppassword fieldprowiki < e:\fieldprowiki.sql
  
−
restore:
 
−
mysql -uroot -pprosuite 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 update mysql:''
 +
# login in mysql: mysql -uroot -ppassword
 +
# ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
  
−
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 -pprosuite
 
  
−
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

Latest revision as of 10:19, 10 January 2021

Prepare

Python

  1. Install Python

PHP

  1. Download PHP archive
    1. Extract all files from archive to C:\PHP\
    2. Php-mapping.png
    3. Click Add Module Mapping
    4. Php-edit-mapping.png
    5. Add default document: Php-default.png

MYSQL

  1. Install MYSQL
    1. Select Custom
    2. Install Server
    3. Install WorkBench
    4. Install MYSQL shell

Media WIKI

  1. mediawiki from archive

Setup MySQL

  1. install with legacy password
  2. remove .NET connector


create: mysql -uroot -ppassword 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:

  1. C:\ProgramData\MySQL\MySQL Server 8.0\my.ini - update 'caching_sha2_password' to 'mysql_native_password'

and then update mysql:

  1. login in mysql: mysql -uroot -ppassword
  2. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';


Setup IIS:

  1. add application pool (with 32bit)
  2. add default document: index.php
  3. FastCGI Settings: add application: C:\php\php=cgi.exe
Retrieved from "https://mps.resnet.com/MPSWiki/index.php?title=Install_wiki_on_win_server&oldid=594"