MagicServer

MagicServer is a lightweight and portable server package that includes Apache, PHP, MariaDB, and Redis, pre-configured to run MagicAppBuilder smoothly on Windows systems.

---

✨ Features

• ✅ Portable – no installation required

• ✅ Zero configuration

• ✅ Auto-installs MagicAppBuilder

• ✅ Rebuilds server configuration on each startup

• ✅ Includes:

  • Apache HTTP Server
  • PHP
  • MariaDB (MySQL-compatible)
  • Redis Server (Windows build)

---

📁 Folder Structure

MagicServer/
├── apache/                      # Apache HTTP Server binaries and configuration files
├── config/                      # Generated config files (e.g., for Apache, PHP, Redis)
├── data/                        # MariaDB data directory (stores databases)
├── logs/                        # Central log directory (for Apache, MariaDB, Redis, etc.)
├── mysql/                       # MariaDB binaries and supporting files
├── php/                         # PHP runtime and configuration (php.ini, extensions)
├── redis/                       # Redis Server binaries and configuration
├── sessions/                    # PHP session file storage directory
├── tmp/                         # Temporary files (e.g., uploads, caches)
├── www/                         # Web root directory (place your web apps here)
│   ├── MagicAppBuilder/         # Auto-installed MagicAppBuilder (a low-code web platform)
│   └── phpmyadmin/              # Pre-installed phpMyAdmin for managing MariaDB databases
├── fn.php                       # Common/shared PHP utility functions
├── index.php                    # Default web entry point (can be replaced with your own app)
├── install-magicappbuilder.php  # Installer script for MagicAppBuilder platform
├── install-mariadb.php          # Script to initialize MariaDB system tables (data directory)
├── set-mariadb-password.php     # Script to set or change the MariaDB root password
├── start.php                    # Script to generate config and start Apache, MariaDB, and Redis
└── stop.php                     # Script to gracefully stop Apache, MariaDB, and Redis

---

🚀 Getting Started

1. Download and Extract

Extract MagicServer to any location, e.g.:

D:\MagicServer

2. Open Command Prompt as Administrator

Required to allow Apache, MariaDB, and Redis to run properly.

D:
cd MagicServer

3. Install MariaDB

Run the following to install MariaDB:

php\php.exe install-mariadb.php

4. Install MagicAppBuilder

Run the following to download and install the latest version:

php\php.exe install-magicappbuilder.php

5. Start the Server

Starts Apache, MariaDB, Redis, and rebuilds configs:

php\php.exe start.php

6. Access Your Application and Tools

Open your browser and go to:

• MagicAppBuilder:

  http://localhost/MagicAppBuilder/
  

• phpMyAdmin (MariaDB web interface):

  http://localhost/phpmyadmin/
  

If you see the error "Login without a password is forbidden by configuration", set a MariaDB root password by running:

php\php.exe set-mariadb-password.php

7. Stop the Server

To stop all services:

php\php.exe stop.php

---

🔧 Configuration

Template-based configurations are rebuilt automatically.

Component	Template File	Generated File
Apache	config/httpd-template.conf	config/httpd.conf
PHP	config/php-template.ini	php/php.ini
MariaDB	config/my-template.ini	config/my.ini
Redis	config/redis-template.conf	redis/redis.conf

📝 Do not edit generated files. Modify the templates instead.

---

🛡️ Default Credentials

Service	Username	Password
MariaDB	root	password
MagicAppBuilder	administrator	administrator
Your App	superuser	superuser

🔐 Secure your environment by setting strong passwords.

---

🔐 Changing the MariaDB Root Password via phpMyAdmin

To change the root password securely using phpMyAdmin:

1. Open http://localhost/phpmyadmin/ in your browser.

2. Log in with the default credentials:

   • Username: root
   • Password: password

3. Click the "User accounts" tab on the top menu.

4. Find the user root@localhost and click "Edit privileges".

5. Scroll to the "Change password" section.

6. Enter your new secure password twice, and click Go.

7. Repeat the same steps for any other root user entries with a different Host name.

8. After changing the password, you can log out and log in again using the new credentials.

⚠️ If you update the root password, make sure any application (including MagicAppBuilder) that connects to MariaDB is updated accordingly.

---

⚙️ Compatibility

• ✅ Windows 10 and 11
• ✅ PHP 7.x and 8.x supported
• ✅ MagicAppBuilder v1.12.0+
• ✅ Redis for Windows (Memurai / Microsoft port)

---

🛠 Included Tools

Tool	Description	Path
PHP CLI	Run PHP scripts from the command line	php\php.exe
MariaDB CLI	MySQL-compatible database client	mysql\bin\mysql.exe
Redis CLI	Command-line interface for Redis	redis\redis-cli.exe
phpMyAdmin	Web-based interface for MariaDB administration	Accessible at /phpmyadmin/ in your browser

---

📜 License

Licensed under the MIT License, except for bundled components that use their respective open-source licenses.

---

🙏 Acknowledgements

MagicServer includes:

• Apache HTTP Server
• PHP
• MariaDB
• Redis (Windows Build)
• MagicAppBuilder

---

💡 Happy building with MagicAppBuilder + Redis on MagicServer! 🚀