Difference between revisions of "Install wiki on win server"

From MPSWiki
Jump to: navigation, search
(→‎Prepare)
 
(One intermediate revision by the same user not shown)
Line 11: Line 11:
 
==MYSQL==
 
==MYSQL==
 
#[https://drive.google.com/u/0/uc?id=1ByVELx1RIdFGKO3DYPwP_DoK2bNZBdlH&export=download Install MYSQL]
 
#[https://drive.google.com/u/0/uc?id=1ByVELx1RIdFGKO3DYPwP_DoK2bNZBdlH&export=download Install MYSQL]
 +
##Select Custom
 +
##Install Server
 +
##Install WorkBench
 +
##Install MYSQL shell
 +
 
==Media WIKI==
 
==Media WIKI==
 
# mediawiki from archive
 
# mediawiki from archive
Line 42: Line 47:
 
# add default document: index.php
 
# add default document: index.php
 
# FastCGI Settings: add application: C:\php\php=cgi.exe
 
# FastCGI Settings: add application: C:\php\php=cgi.exe
−
 
−
 
−
'''Backup script:'''
 
−
<pre>
 
−
@echo off
 
−
SETLOCAL ENABLEEXTENSIONS
 
−
SETLOCAL ENABLEDELAYEDEXPANSION
 
−
 
−
set WIKI_FOLDER=E:\WWW\efieldpro\FieldproWiki
 
−
set BAKEUP_FOLDER=C:\Backups\wiki
 
−
 
−
set WIKI_DATABASE=fieldprowiki
 
−
set WIKI_DATABASE_USER=root
 
−
set WIKI_DATABASE_PASS=prosuite
 
−
 
−
for /f "tokens=2 delims==" %%I in ('wmic os get localdatetime /format:list') do (
 
−
set DATETIME=%%I
 
−
set WIKI_BACKUP_DATETIME=!DATETIME:~0,8!_!DATETIME:~8,6!
 
−
)
 
−
 
−
@echo Backup wiki folder from !WIKI_FOLDER!, new backup file wiki_!WIKI_BACKUP_DATETIME!.7z will be in !BAKEUP_FOLDER!
 
−
"C:\Backups\wiki\7za.exe" a "!BAKEUP_FOLDER!\wiki_!WIKI_BACKUP_DATETIME!.7z" "!WIKI_FOLDER!"
 
−
 
−
@echo Backup wiki database !WIKI_DATABASE!, new backup file !WIKI_DATABASE!_!WIKI_BACKUP_DATETIME!.sql will be in !BAKEUP_FOLDER!
 
−
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" -u!WIKI_DATABASE_USER! -p!WIKI_DATABASE_PASS! !WIKI_DATABASE! > "!BAKEUP_FOLDER!\!WIKI_DATABASE!_!WIKI_BACKUP_DATETIME!.sql"
 
−
</pre>
 

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"