Learn Setup Windows Server Aliconnect - aliconnect/aliconnect.sdk GitHub Wiki

Setup Strato Server

  1. STRATO ServerCloud Panel
  2. Netwerk 1. Firewall-beleid
    1. Toelaten, Alle, TCP: 20,21,22,81,82,444,445,1433,1434
    2. Toelaten, Alle, UDP: 22,1434
    3. Wacht op Staus, Wordt geconfigureerd > Actief

Setup Server

  1. Windows+R Open: servermanager
  2. Dashboard > Add roles and features
  3. Before You Begin 1. [ Next > ]
  4. Installation Type 1. [x] Role based or feature-based installation 1. [ Next > ]
  5. Server Selection 1. [x] Select a server from the server pool 1. [ Next > ]
  6. Server Roles 1. [x] Web Server (IIS)
    1. [ Add Features ] 1. [ Next > ]
  7. Features 1. [ Next > ]
  8. Web Server Role (IIS) 1. Role Services
    1. Web Server
    2. Application Development 1. [x] CGI
    3. FTP Server
    4. [ Next > ]
  9. Confirmation 1. [ Install ]

OpenSSH Server

  1. Setup SSH server on server
  2. See Get started with Opne SSL on windows
  3. Start Manage optional features
  4. Add feature OpenSSH Server
  5. Waint until service is installed, this can take saveral minutes.

Microsoft Web Platform Installer 5.1

  1. PHP 7.4.13 (x64) [ Add ]
  2. Microsoft Drivers 5.8 (x64) fro PHP v7.4 for SQL Server in IIS [ Add ]
  3. URL Rewrite 2.1 [ Add ]
  4. [ Install ]
  5. [ I Accept ]
  6. [ Finsh ]
  7. [ I Accept ]
  8. [ Exit ]

Add Windows user aim

  1. Windows+R Open: compmgmt.msc
  2. Computer Management (Local) > System Tools > Local Users and Groups > Users
  3. Actions > Users > More actions > New User...
  4. User name: Aim
  5. Full name: Aim FTP User
  6. Description: Aim FTP User
  7. Password: ***
  8. Confirm password: ***
  9. User must change password at next logon
  10. User cannot change password
  11. Password never expires
  12. Account is disabled
  13. [ Create ]
  14. [ Close ]

Setup Windows Firewall

  1. Windows+R Run: wf.msc
  2. Windows Defender Firewall > Inboud Rules
  3. Add Rule TCP AIM Server
  4. Actions > New Rule...
  5. Rule Type
    1. Port
    2. [ Next > ]
  6. Protocol and Ports
    1. TCP
    2. Specific local ports: 20,21,81,82,444,445,1433,1434
    3. [ Next > ]
  7. Action
    1. Allow the connection
    2. [ Next > ]
  8. Profile
    1. Domain
    2. Private
    3. Public
    4. [ Next > ]
  9. Name
    1. Name: TCP AIM Server
    2. [ Finish ]
  10. Add Rule UDP AIM Server
  11. Actions > New Rule...
  12. Rule Type
    1. Port
    2. [ Next > ]
  13. Protocol and Ports
    1. UDP
    2. Specific local ports: 1433,1434
    3. [ Next > ]
  14. Action
    1. Allow the connection
    2. [ Next > ]
  15. Profile
    1. Domain
    2. Private
    3. Public
    4. [ Next > ]
  16. Name
    1. Name: UDP AIM Server
    2. [ Finish ]

Setup Atom

  1. https://atom.io/
  2. [ Download ]
  3. AtomSetup-x64.exe > Open file
  4. Add folders: d:\aliconnect

Setup config.json

  1. Run Atom
  2. 📁 aliconnect > 📁 Config
  3. New File [A]
  4. Enter the path for the new file. config\.config.yaml
  5. add content

Setup Microsoft SQL Server

  1. https://www.microsoft.com/nl-nl/sql-server/sql-server-downloads
  2. Express [ Download nu > ]
  3. SQL2019-SSEI-Expr.exe > Open file
  4. Express Edition 1. [ Custom ]
    1. MEDIA LOCATION *: D:\sqlmedia
    2. [ Install ]
  5. Downloading install packages...
  6. SQL Server Installation Center 1. Installation
    1. New SQL Server stand-alone installation ...
    2. License Terms 1. [x] I accept the license terms ... 1. [ Next > ]
    3. Global Rules
    4. Product Updates
    5. Install Setup Files
    6. Install Rules
    7. Feature Selection 1. [ Next > ]
    8. Feature Rules
    9. Instance Configuration 1. [x] Default instance 1. Instance ID: MSSQLSERVER 1. [ Next > ]
    10. Java Install Location 1. [ Next > ]
    11. Server Configuration 1. [ Next > ]
    12. Database Engine Configuration 1. Server Configuration
      1. Mixed Mode (SQL Server authentication and Windows authentication)
      2. Enter password: ***
      3. Confirm password: *** 1. Data Directories
      4. Data root directory: D:\sql\data
      5. User database directory: D:\sql\data
      6. User database log directory: D:\sql\data
      7. Backup directory: D:\sql\bak 1. TempDB
      8. Data directories: D:\sql\data
      9. Log directoriy: D:\sql\data 1. [ Next > ]
    13. Consent to install Microsoft R Open 1. [ Accept ] 1. [ Next > ]
    14. Consent to install MPython 1. [ Accept ] 1. [ Next > ]
    15. Offline Installation of Microso...
    16. Feature Configuration Rules
    17. Installation Progress 1. [ Next > ]
    18. Complete 1. [ Close ]

Setup Node JS

  1. Start Edge
  2. https://nodejs.org/en/
  3. [ 18.12.1.LTS Recommended For Most Users ]
  4. node-v18.12.1-x64.msi > Open file
  5. Welcome 1. [ Next ]
  6. End-User License Agreement 1. [x] I accept ... 1. [ Next ]
  7. Destination folder 1. C:\Program Files\nodejs\ 1. [ Next ]
  8. Custom Setup 1. [ Next ]
  9. Tools for Native Modules 1. [ Next ]
  10. Ready to install Node.js 1. [ Install ]
  11. Completed 1. [ Finish ]

Setup Composer

  1. Start Edge
  2. https://getcomposer.org/download/
  3. Composer-Setup.exe
  4. Composer-Setup.exe > Open file
  5. Select install mode 1. [ Install for all users ]
  6. Installation options 1. [ Next ]
  7. Settings Check 1. Choose the command-line... C:\Program Files\php\v7.4\php.exe 1. [x] Add this PHP to your path? 1. [ Next ]
  8. Proxy Settings 1. [ Next ]
  9. Ready to install 1. [ Install ]
  10. Information 1. [ Next ]
  11. Completing Composer Setup 1. [ Finish ]
  12. Voeg toe Gebruikers aan beveiliging met rechten lezen enz???

Setup PHP Yaml

  1. Start Edge
  2. https://pecl.php.net/package/yaml/2.0.4/windows
  3. 7.4 Non Thread Safe (NTS) x64
  4. 7.4 Non Thread Safe (NTS) x64 > Open file
  5. Copy php_yaml.dll, php_yaml.pdb
  6. Paste into C:\Program Files\PHP\v7.4\ext
  7. Windows+R Open: notepad
  8. Ctrl+O Open: C:\Program Files\PHP\v7.4\php.ini
  9. Add extension YAML 
    [ExtensionList]
extension=php_yaml.dll
  10. Add Logging 
    [AIM Changes]
error_log=D:\aliconnect\logs\php_errors.log
upload_tmp_dir=D:\aliconnect\temp\php
session.save_path=D:\aliconnect\temp\php\session

Setup folders

  1. Windows+R Run: cmd
  2. Run command's
d:
md \sql
md \sql\data
md \sql\bak
md \aliconnect
md \aliconnect\bu
md \aliconnect\config
md \aliconnect\config\cert
md \aliconnect\logfiles
md \aliconnect\public
cd \aliconnect
npm init
npm install @aliconnect/sdk
composer require phpmailer/phpmailer

Setup Cert folder

  1. Copy Cert folder van local d:\aliconnect\cert naar Server d:\aliconnect\cert

Create Local SSL Server Certificate

  1. The SSL certificate can only be used on the computer where it is created. To recreate the certificate we can export and import it with the help of openssl.
  2. Start d:\aliconnect\config\cert\this-server.pfx.create.bat
  3. Enter Export Password: ***
  4. Verifying - Enter Export Password: ***
  5. Press any key to continue . . .

Setup IIS

  1. Windows+R Run: inetmgr.exe
  2. Import Server SSL Certificate
  3. Connections > XXXXXX (XXXXXX\Administrator)
  4. XXXXXX Home > IIS > Server Certificates > Actions > Open Feature 1. Server Certificates 1. Actions > Import...
    1. Import Certificate
    2. Certificate file (.pfx): d:\aliconnect\config\cert\this-server.pfx
    3. Password: ***
    4. Select Certificate Store: Personal
    5. Allow this certificate to be exported
    6. [ OK ]
  5. Setup Web Server
  6. Connections > XXXXXX (XXXXXX\Administrator) > Sites > Default Web Site
  7. Default Web Site Home > Actions > Edit Site > Basic Settings... 1. Edit Site
    1. Physical path: d:\aliconnect\public
    2. [ Connect as... ]
    3. Connect As 1. [x] Specific user: aim 1. [ Set ]
      1. Set Credentials
      2. User name: aim
      3. Password: ********
      4. Confirm password: ********
      5. [ OK ] 1. [ OK ]
    4. [ Test Settings... ]
    5. [ OK ]
  8. Setup FTP Server
  9. Connections > SERVER (SERVER\Administrator) > Sites
  10. Sites > Actions > Add FTP Site... 1. Site Informatie
    1. FTP site name: FTP
    2. Physical path: d:\aliconnect
    3. [ Next ] 1. Binding and SSL Settings
    4. Binding:
    5. IP Address: All Unassigned
    6. Port: 21
    7. Start FTP site automatically
    8. SSL
    9. Require SSL
    10. SSL Certificate: *.aliconnect.nl
    11. [ Next ] 1. Authentication and Authorization Information
    12. Authentication 1. [ ] Anonymous 1. [x] Basic
    13. Authorization 1. Allow access to > Specific Users: aim 1. Permisions:
      1. Read
      2. Write
    14. [ Finish ]
  11. Connections > SERVER (SERVER\Administrator) > Sites > FTP
  12. FTP Home > FTP > FTP Logging > Actions > Open Feature 1. FTP Logging
    1. Directory: d:\aliconnect\logfiles
    2. Actions > Apply
  13. FTP Home > FTP > FTP Authorization Rules > Actions > Open Feature 1. FTP Authorization Rules
    1. Edit Allow Authorization Rule
    2. Specific users: aim
    3. Permissions: 1. [x] Read 1. [x] Write
  14. FTP Home > FTP > FTP Authorization Rules > Actions > Open Feature 1. FTP SSL Settings
    1. SSL Policy
    2. Allow SSL connections
    3. Actions > Apply
  15. Test FTP m.b.v FileZilla 1. Algemeen
    1. Protocol: FTP - File Transfer Protocol
    2. Host: 000.000.000.000
    3. Versleuteling: Gebruik platte FTP (onveilig)
    4. Inlogtype: Normaal
    5. Gebruiker: aim
    6. Wachtwoord: ***

Schrijf rechten PHP op aliconnect/config/client folder

  1. Open explorere.exe
  2. This PC > Data (D:) > 📁 aliconnect > 📁 config > 📁 client
  3. Actions > Properties > Security
  4. [ Edit... ]
  5. [ Add... ]
  6. Enter the object names to select (examples): IUSR
  7. [ OK ]
  8. Permissions for Aim > Modify > [x] Allow
  9. [ OK ]
  10. [ OK ]

Windows PC

  1. Server setup
  2. Turn Windows features on or off
  3. Windows+R Open: appwiz.cpl
  4. Control Panel Home > Turn Windows features on or off 1. [x] Internet Information Services
    • World Wide Web-services
      • Toepassingsontwikkelingsfuncties
        • CGI 1. [ OK ]