Windows Batch Script with Menu Choices

 

@ECHO OFF

:Menu

CLS

ECHO ----------------------------------------

ECHO   Application Development Environment

ECHO ----------------------------------------

ECHO 1. JDK 8.0.392 and Tomcat 9.0.37

ECHO 2. JRE 21.0.8 and Tomcat 9.0.108

ECHO 3. Exit

ECHO ----------------------------------------

SET /P CHOICE="Enter your choice (1-3): "

IF "%CHOICE%"=="1" GOTO Option1

IF "%CHOICE%"=="2" GOTO Option2

IF "%CHOICE%"=="3" GOTO :EOF

GOTO Menu

:Option1

SET DEV_HOME=C:/Users/DevApps

SET JAVA_HOME=%DEV_HOME%/zulu8.74.0.17-ca-jdk8.0.392-win_x64

SET CATALINA_HOME=%DEV_HOME%/ApacheTomcat9_CitizenPortal

@ECHO Open JDK 8.0.392 and Tomcat 9.0.37

GOTO Common

:Option2

SET DEV_HOME=C:/Users/DevApps

SET JAVA_HOME=%DEV_HOME%/zulu21.44.17-ca-jre21.0.8-win_x64

SET CATALINA_HOME=%DEV_HOME%/apache-tomcat-9.0.108

@ECHO Open JDK 21.0.8 and Tomcat 9.0.108

GOTO Common

:Common

REM SET JAVA_HOME=C:\Program Files (x86)\Java\jre1.8.0_191

SET CATALINA_BASE=%CATALINA_HOME%

SET PATH=%JAVA_HOME%/bin;%PATH%;%CATALINA_HOME%/bin;C:\Program Files\7-Zip

Mediawiki Installation and Setup

 

Downloads:

• Web Server: Apache VS17 binaries and modules download

• PHP: PHP Downloads

• Database: MySQL Download MySQL Community Server or MariaDB - Community Server

• MediaWiki: Download - MediaWiki

Installation:

• Unzip the files to the local folders

Configuration:

• Httpd: modify %HTTPD_HOME%/conf/httpd.conf

Set server Root:

Define SRVROOT "c:/DevApps/Apache24"

Set listen port:

Listen 8080

Enable(uncomment) SSL

LoadModule ssl_module modules/mod_ssl.so

Enable PHP

LoadModule php_module "C:/DevApps/php-8.4.11/php8apache2_4.dll"

AddHandler application/x-httpd-php .php

PHPIniDir "C:/DevApps/php-8.4.11"

• Enable extension in php.ini by removing ";" from the following lines

;extension_dir = "ext"

;extension=mysqli

;extension=curl

;extension=fileinfo

;extension=intl

;extension=mbstring

;extension=openssl

;extension=pdo_mysql

Database:

• Log in as root(admin account)

• Run the following statement to create initial DB:

CREATE DATABASE my_wiki;

CREATE USER 'wikiuser'@'localhost' IDENTIFIED BY 'database_password';

GRANT ALL PRIVILEGES ON my_wiki.* TO 'wikiuser'@'localhost' WITH GRANT OPTION;

Set up Wiki:

• localhost:8080/mediawiki-1.44.0/index.php

• Set up MySQL, account etc

• Admin account creation

• Options: eg Authorized editors only

• Email, Skin etc

Download LocalSettings.php after the successful Wiki installation and copy it to %WIKI_HOME%

MySQL Installation

  • Download MySQL from www.mysql.com and configure thru the installation

• If you download .zip file, run %MYSQL_HOME%\bin\mysql_configurator.exe and configure the data folder, accounts, service etc.

○ Data Directory: C:\ProgramData\MySQL\data

○ Type and Networking: defaults - Development Computer, TCP/IP, Port 3306 etc

○ Root password and any user accounts

○ Windows Services (optional if running as standalone)

○ Server File Permission: defaults only to Administrators Group, you may need to manually add the users' access

○ Sample Database: skip

○ Apply Configuration - execute

• Start MySQL by running mysqld --defaults-file="C:/ProgramData/MySQL/data/my.ini" --console

• Stop MySQL by running mysqladmin -u root -p shutdown

• Connect to MySQL using mysql -u <userid> -p

• List existing databases: Show databases;

• Create a new database: CREATE DATABASE demodb;

• Switch to a database: USE <database name>;