Install Akabot Center 3x and MySQL on Microsoft Windows

This guide provides instructions to installing a single instance of akaBot Center version: 3.x, 2.x, 1.x with MySQL as the database engine. The target Operating System (OS) in this guideline is Microsoft Windows.

Guide video

Install Akabot Center 3x and MySQL on Microsoft Windows (2026) - YouTube

1. Prerequisites

1.1. Hardware and OS Requirements

Configuration	Requirements
Hardware	RAM: 32GB or higher Core: 8 CPU or higher SSD: 512 GB
Operating System	Windows 10, 11, Server 2012 R2/2016/2019

1.2. Software Packages

The installation must be performed using an account with Administrator (root) privileges on the target machine.
You need to prepare the installation package according to the following list.

Note:

• If the computer where you're installing Center does not have an internet connection, please download the installation package externally and copy it to the machine.
• To avoid errors during installation with command line execution, please use a dedicated folder for akaBot Center installation and name the installation package directory without any spaces. For example: C:\akaBot

#	Name	File Name	Version	Description	Download Link
1	akaBot Center	akaBot-center-3.x.x.x.war	Newest version	akaBot Center installation package	akaBot provides through email after the customer makes a purchase.
2	Java Developer Kit	openlogic-openjdk-11.0.20	11.0.20	Open logic JDK 11.0.20	Download
3	Apache tomcat	apache-tomcat- 8.5.89.exe	8.5.59	Web server Apache Tomcat	Download
4	ActiveMQ	apache-activemq- 5.15.1-bin.zip	5.15.1	ActiveMQ for Queue functionality in akaBot Center	Download
5	MySQL	Windows (x86, 32-bit), MSI Installer	8.0.45	The database engine of akaBot Center	Read Section 3.1for more details

2. Java JDK 11 Installation

Run the installer -openlogic-openjdk-11.0.20 you have downloaded. After that, click "Next" to proceed.

• After Installation is complete, you will see the Complete Notification below. Simply click Finish. You have successfully installed JDK.

Note: Make sure that JAVA_HOME presents in your environment variables by typing command echo %JAVA_HOME%, the output should be a path that point to jdk 11 ex: C:\Program Files\OpenLogic\jdk-11.0.20.8

3. MySQL installation

3.1. Install MySQL

Step 1- Kindly download MySQL 8.0

Step 2- Run the installer

• Select "Custom" option and click "Next"

• To run akaBot Center, you will need MySQL Server and MySQL Workbench.
• Under:
  • MySQL Servers > MySQL Server, choose the newest for MySQL Server.
  • Application > MySQL Workbench, choose the newest version for MySQL Workbench

• Click button "Next"

• After that, kindly click "Execute" and hit "Next"

• After products are successfully installed, click "Next " to continue process

• When you at the Accounts and Roles page, it is recommended you set it to the default password sis@12345 to avoid having to update the config file later. Click "Next"

• Click "Execute" and wait till everything is finished. Click Finish.

• If you see this screen, we have successfully finished the installation. Click Finish.

3.2.Setup MYSQL account to enable remote connection

Follow these steps to know how to setup remote connection with MySQL. This will help to install MySQL and akaBot Center in separated systems.

Test your MySQL from remote client using MySQL Workbench

• Open MySQL Workbench in other computer, click to the add connection button (see picture bellowed) to open Setup New Connection window.

• Input IP address of MySQL that you want to test, explorer in "HostName"
• Input your SQLUsername: root
• Click to Test Connection button
• After dialog Connect to MySQL Server appears, you enter password (you created in 3.1 >Step 2) for this account then hit ok totest this connection

• You will see this dialog if everything is configured successfully.

• After connect successful, you can browse remote database in details using MySQL Workbench

3.3. Create MySQL Database for Center

• For the new/first-time installation, you must create a new database for your Center.
• Follow these steps to create a database with the name aka_orchestrator in a machine that is designed to install MySQL Database for Center.

Step 1: Open MySQL Workbench in the machine you want to create a MySQL Database

• Open MySQL Workbench, access local instance

Step 2: Click to (1) to open Create new database dialog

(2) input schema name=aka_orchestrator

(3) input the database name of Center

(4) input Charset =utf8 ,utf8_general_ci.

(5) Hit Apply after you finish all (1) (2) (3) (4).

Step 3: Hit Apply to create our LMS Database

Hit Finish

4. Apache Tomcat installation

4.1. Install Apache Tomcat

Apache Tomcat installation:
-Uncheck "Run Apache Tomcat"
-Uncheck "Show Readme"
-Click the "Finish" button to complete the installation.

The installation path for Apache Tomcat:%TOMCAT_PATH% = C:\Program Files\Apache Software Foundation\Tomcat 8.5

4.2. Apache Tomcat Configuration

4.2.1. Configure log settings

Step 1: Open the file %TOMCAT_PATH%\conf\logging.properties

Step 2: Add attributemaxDays to specify the maximum number of days that rotated access logs will be retained for before being deleted for the catalina, localhost, host-manager, manager logs. If not specified, the default value of-1will be used which means never delete old files.

• Example: keep 10 daysworth of history. Enter:
  • 1catalina.org.apache.juli.AsyncFileHandler.maxDays = 10
  • 2localhost.org.apache.juli.AsyncFileHandler.maxDays = 10
  • 3manager.org.apache.juli.AsyncFileHandler.maxDays = 10
  • 4host-manager.org.apache.juli.AsyncFileHandler.maxDays = 10

Step 3: Save changes and close the file.

Step 4: Open the file %TOMCAT_PATH%\conf\server.xml

Step 5: Un-Comment the line of log setting to turn on the log and add attribute maxDays as below:

Note: Only by opening in Notepad, can you edit the .xml file

These following steps illustrate how you can open in Notepad:

• Click Run as administrator

• Navigate to File\Open

• Locate to your file in the list, remember select "All files" option

Step 6: Save changes and close the file

4.2.2. Other settings

Step 1: Navigate to the path %TOMCAT_PATH%\bin and double-click the file Tomcat8w.exe to open the Apache Tomcat Service configuration.

Step 2: On the General tab

• Select Startup type: Automatic
• Choose Apply to apply the configuration changes.

Step 3: On the Logging tab

(1) Log prefix: Remove "commons-daemon"

(2) Redirect Stdout: Remove "auto"

(3) Redirect Stderror: Remove "auto"

(4) Choose Apply to apply the configuration changes.

Step 4: On the Java tab

a. Adjust the Java Heap configuration:

• Initial memory pool: Enter a value <= 1/4of the server's RAM.

Example: Server RAM = 32 GB -> Initial memory pool should be <= 1/4 * 16 * 1024 MB

• Maximum memory pool: Enter a value <= of the server's RAM.

Example: Server RAM = 32 GB -> Maximum memory pool should be <= * 16 * 1024 MB

Note: If you enter a value that is too large, it may prevent Apache Tomcat service from starting and result in errors.

b.Choose Apply to apply the configuration changes.

Step 5: Start the Tomcat Service

On the General tab, select Start to initiate the Apache Tomcat service.

4.3. Check Apache Tomcat Installation

Step 1: After installation and configuration, go to the Services screen and check the status of the Apache Tomcat service.

• If the Status is not Running, start the Apache Tomcat service.
• If the Status is Running, proceed to step 2.

Step 2: Access the URL http://localhost:8080 in Chrome to verify the successful installation of Apache Tomcat:

5. ActiveMQ installation

5.1. Install ActiveMQ

Step 1: Extract the file "apache-activemq-5.15.1-bin.zip" to the desired installation path.

For example: ACTIVEMQ_PATH = C:\akaBot\apache-activemq-5.15.1

Note: The installation path should not contain any spaces.

Step 2: Open Command Prompt with Administrator privileges.

Step 3: Run the file %ACTIVEMQ_PATH%\bin\win64\InstallService.bat to install the ActiveMQ service.

Run command: C:\Windows\System32>C:\akaBot\apache-activemq-5.15.1\bin\win64\InstallService.bat

Step 4: Start the ActiveMQ service.

5.2. Java Heap Configuration

Step 1: Stop service ActiveMQ

Step 2: Open the file %ACTIVEMQ_PATH%\bin\win64\wrapper.conf and configure the parameters:

• wrapper.java.initmemory: Enter the initial value for the Java Heap memory.

For example, if the server has 32 GB of RAM, you can enter 1024.

• wrapper.java.maxmemory: Enter the maximum value for the Java Heap memory.

For example, with a server having 32 GB of RAM, you can enter 4096.

Step 3: Start ActiveMQ Service

5.3.Check ActiveMQ Installation

Step 1: Check the Running status of the ActiveMQ service. If it is not running, start the service.

Step 2: Access the URL http://localhost:8161 to verify the successful installation of ActiveMQ.

6. akaBot Center Installation

Download akaBot-center- 3.x.x.x.war.

6.1. Copy and extract war file

Step 1: Stop Apache Tomcat service

Step 2: Delete all folders in %TOMCAT_PATH%/webapps.

Step 3: Copy the file akaBot-center-x.x.x.x.war to the**%TOMCAT_PATH%/webapps/** directory and rename it to ROOT.war.

Step 4: Restart the Apache Tomcat service and wait for the ROOT.war to be extracted into the ROOT directory.

Step 5: Stop the Apache Tomcat service.

6.2. akaBot Center configuration

6.2.1. Configquartz.properties

Step 1: Stop the Apache Tomcat service (if the Apache Tomcat service is currently running).

Step 2: Modify the configuration in the file %TOMCAT_PATH%/webapps/ROOT/WEB-INF/classes/quartz.properties as follows:

1. Comment out the jobstore configuration for MySSQL.

2. Remove the "#" character at the beginning of the line for the jobstore configuration for MySQL to uncomment it.

6.2.2.Configure the MySQL Database Connection

Step 1: Navigate to the path %TOMCAT_PATH%/webapps/ROOT/WEB-INF/classes/config/

Step 2: Modify the configuration in both files: application-dev.yml and application-prod.yml

Remove the # characters at the beginning of the lines to uncomment the configuration and enable MySQL usage. Add the "#" characters at the beginning of the lines to comment out the configuration and disable MSSQL.

• application-dev.yml

• application-prod.yml

6.2.3. Log setting

1. Open the file %TOMCAT_PATH%/webapps/ROOT/WEB-INF/classes/logback-spring.xml

2. Change the log level to ERROR

3. Change the setting in rolling log file as below:

• maxFileSize: Limit the size of each file. Ex: 200MB.
• maxHistory: The optional maxHistory property controls the maximum number of archive files to keep. Ex: 20
• totalSizeCap: The optional totalSizeCap property controls the total size of all archive files. Ex: 20GB

4. Save changes and close file

5. Start the Apache Tomcat service and access http://localhost:8080/ to verify the installation of akaBot Center.

6. Log in using the following credentials:

• username: admin
• password: admin
• You will be redirected to the dashboard as shown below.

7. Troubleshooting

7.1. ActiveMQ

7.1.1. Unable to execute Java command

• Open the file %ACTIVEMQ_PATH%\bin\win64\wrapper.conf and configure the parameter:

wrapper.java.command=%JAVA_HOME%/bin/java.exe

7.1.2. Other Errors

Please check the error details in the log file of ActiveMQ: %ACTIVEMQ_PATH%\logs\data\wrapper.log

8. Backup for disaster recovery

Information to be backed up for disaster recovery scenarios:

No	Name	Path	Description
1	akaBot Center	Database	Database (MSSQL) of akaBot Center
		%TOMCAT_PATH%/filestorage	Folder containing .nupkg files from akaBot Studio published to akaBot Center
		%TOMCAT_PATH%\webapps\webapps\ROOT\WEB- INF\classes\config\application.yml
		%TOMCAT_PATH%\webapps\webapps\ROOT\WEB- INF\classes\config\application-dev.yml
		%TOMCAT_PATH%\webapps\webapps\ROOT\WEB- INF\classes\config\application-prod.yml
		%TOMCAT_PATH%\webapps\webapps\ROOT\WEB- INF\classes\config\quartz.properties	Configuration files for akaBot Center
2	activeMQ	%ACTIVEMQ_PATH%\data	activeMQ data directory

9. Activate Licenses

Please follow the instruction via Activation