DurisMUD

DurisMUD forked from Xanadinn's repo.

Table of Contents

• Prerequisites
• Database Setup
• Compilation
• Configuration
• Running the MUD
• Connecting
• Troubleshooting
• Development vs Production
• Database Migrations
• Project Structure
• Logs

---

Prerequisites

Required Software

• C Compiler: GCC 4.x or later (tested with GCC 14.2.0)
• Build Tools: GNU Make
• MySQL/MariaDB: 8.0 or later (tested with MySQL 8.0.44)
• MySQL Client Library: libmysqlclient-dev

Installing Dependencies

Ubuntu/Debian:

sudo apt-get update
sudo apt-get install build-essential mysql-server libmysqlclient-dev
sudo apt-get install libxml2 libxml2-dev
sudo apt-get install zlib1g zlib1g-dev
sudo apt-get install gnutls-dev
sudo apt-get install libcjson-dev libssl-dev

CentOS/RHEL:

sudo yum install gcc make mysql-server mysql-devel

---

Database Setup

1. Install and Start MySQL

# Start MySQL service
sudo systemctl start mysql
sudo systemctl enable mysql

2. Create Database and User

Development Database:

mysql -u root -p

-- Create development database
CREATE DATABASE duris_dev;

-- Create user with privileges
GRANT ALL PRIVILEGES ON duris_dev.* TO 'duris'@'localhost' IDENTIFIED BY 'duris';
GRANT ALL PRIVILEGES ON duris_dev.* TO 'duris'@'127.0.0.1' IDENTIFIED BY 'duris';
FLUSH PRIVILEGES;

-- newer versions of MYSQL
CREATE USER 'duris'@'localhost' IDENTIFIED BY 'duris';
CREATE USER 'duris'@'127.0.0.1' IDENTIFIED BY 'duris';
GRANT ALL PRIVILEGES ON duris_dev.* TO 'duris'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON duris_dev.* TO 'duris'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Production Database (when ready):

-- Create production database
CREATE DATABASE duris;

-- Grant privileges (use a strong password in production!)
GRANT ALL PRIVILEGES ON duris.* TO 'duris'@'localhost' IDENTIFIED BY 'your_secure_password';
GRANT ALL PRIVILEGES ON duris.* TO 'duris'@'127.0.0.1' IDENTIFIED BY 'your_secure_password';
FLUSH PRIVILEGES;

-- newer versions of MYSQL
CREATE USER 'duris'@'localhost' IDENTIFIED BY 'duris';
CREATE USER 'duris'@'127.0.0.1' IDENTIFIED BY 'duris';
GRANT ALL PRIVILEGES ON duris.* TO 'duris'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON duris.* TO 'duris'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;

3. Import Database Schema

# For development:
mysql -u duris -p duris_dev < src/duris.sql

# For production:
mysql -u duris -p duris < src/duris.sql

4. Apply Migrations

# Apply frag leaderboard tables (if using web statistics):
mysql -u duris -p duris_dev < sql/migrations/add_frag_leaderboard_tables.sql

Note: The frag leaderboard tables will be automatically populated as players log in and save. No manual population is needed.

5. Import Help Files (Optional)

Help files, news, credits, etc, you can import them to the database:

# Edit the script to configure your database settings:
nano import_help_to_prod.sh
# Update: REMOTE_HOST, REMOTE_USER, MYSQL_USER, MYSQL_PASS, MYSQL_DB

# Dry run to see what would be imported:
./import_help_to_prod.sh --dry-run

# Import to database:
./import_help_to_prod.sh

This imports:

• Individual help files (motd, news, help, faq, etc.) → mud_info and pages tables
• Help index entries (~535 entries) → pages table
• Parsed help file entries → pages table

Note: This is only needed if you're running the web interface. The MUD itself reads help files directly from disk.

6. Link an SSL Certificate

Unless configured otherwise, the game expects the SSL cert and its private key as duris.crt and duris.key. It's probably most convenient to use symlinks for managing them.

For testing, you can use a self-signed certificate. You can link it via:

ln -s localhost.crt duris.crt
ln -s localhost.key duris.key

For a server reachable from the network, though, you should use a real certificate. You can obtain one eg. via Let's Encrypt. Once you do, you need to set up a cronjob to renew it, allow the Duris process to read the files, and point the links appropriately, for example:

ln -s /var/lib/dehydrated/certs/testduris.net/fullchain.pem duris.crt
ln -s /var/lib/dehydrated/certs/testduris.net/privkey.pem duris.key

---

Compilation

Standard Build

cd src
make -f Makefile.linux
cp dms_new ../dms

Note: The Makefile compiles to src/dms_new, which you then copy to dms in the root directory.

Clean Build

cd src
make -f Makefile.linux clean
make -f Makefile.linux
cp dms_new ../dms

Build Configuration

The build is configured in src/Makefile.linux:

• MySQL Enabled: MySQL support is enabled by default
• Test Mode: TEST_MUD flag is enabled for development builds

To disable MySQL (not recommended):

# Edit src/Makefile.linux and uncomment:
# CFLAGS += -D__NO_MYSQL__

---

Configuration

Database Credentials

Database connection settings are hardcoded in src/sql.h (lines 6-16):

#ifdef TEST_MUD
  #define DB_HOST "127.0.0.1"
  #define DB_USER "duris"
  #define DB_PASSWD "duris"
  #define DB_NAME "duris_dev"
#else
  #define DB_HOST "127.0.0.1"
  #define DB_USER "duris"
  #define DB_PASSWD "duris"
  #define DB_NAME "duris"
#endif

Important Notes:

• These credentials are compiled into the binary
• Changes require recompilation: cd src && make -f Makefile.linux clean && make -f Makefile.linux
• For production: Change DB_PASSWD to a secure password before compiling
• Default credentials: user: duris, password: duris

Port Configuration

The MUD automatically selects the database based on the port:

• Port 7777 (default): Uses production database (duris)
• Other ports: Uses development database (duris_dev)

This is configured in src/sql.c initialize_mysql() function.

---

Running the MUD

Starting the Server

Development (port 4000):

./dms 4000

Production (port 7777):

./dms 7777
# or just:
./dms

Running in Background

# Using nohup:
nohup ./dms 7777 > logs/mud.out 2>&1 &

# Using screen:
screen -S duris
./dms 7777
# Press Ctrl+A, D to detach

Stopping the Server

Graceful shutdown:

• Connect as immortal and use shutdown command

Force stop:

# Find process:
ps aux | grep duris

# Kill process:
kill <PID>

---

Connecting

Using telnet

telnet localhost 7777

Using MUD Client

Recommended clients:

• TinTin++ (Linux/Mac/Windows)
• MUSHclient (Windows)
• Mudlet (Cross-platform)

Connect to:

• Host: localhost (or your server IP)
• Port: 7777 (or configured port)

---

Troubleshooting

MySQL Initialization Failed

Error message:

MySQL initialization failed! Dying!

Common causes and solutions:

1. MySQL not running:

   sudo systemctl status mysql
   sudo systemctl start mysql

2. Database doesn't exist:

   mysql -u root -p -e "CREATE DATABASE duris_dev;"

3. Wrong credentials:

   # Test connection:
   mysql -h127.0.0.1 -u duris -p duris_dev
   # Password: duris

4. User lacks privileges:

   GRANT ALL PRIVILEGES ON duris_dev.* TO 'duris'@'127.0.0.1' IDENTIFIED BY 'duris';
   FLUSH PRIVILEGES;

5. Database schema not loaded:

   mysql -u duris -p duris_dev < src/duris.sql

Check Logs

# Status log (MySQL connection, etc.):
tail -f logs/log/status

# System log (game events):
tail -f logs/log/syslog

# Command log (player commands):
tail -f logs/log/cmdlog

Compilation Errors

Missing MySQL library:

sudo apt-get install libmysqlclient-dev

Undefined references:

# Clean and rebuild:
cd src
make -f Makefile.linux clean
make -f Makefile.linux

---

Development vs Production

Development Mode

Characteristics:

• Uses duris_dev database
• Runs on non-7777 ports (e.g., 4000, 4001)
• TEST_MUD flag enabled in compilation
• Safe for testing without affecting production

Running:

./dms 4000

Production Mode

Characteristics:

• Uses duris database
• Runs on port 7777 (default)
• Production-grade database credentials recommended
• Affects live player data

Running:

./dms 7777

Security recommendations:

• Change database password from default duris
• Update src/sql.h with secure credentials
• Recompile after credential changes
• Use firewall rules to restrict MySQL access
• Regular database backups

---

Database Migrations

Applying Migrations

Migrations are SQL scripts in sql/migrations/ directory.

To apply a migration:

# Development:
mysql -u duris -p duris_dev < sql/migrations/migration_name.sql

# Production:
mysql -u duris -p duris < sql/migrations/migration_name.sql

Available Migrations

1. add_frag_leaderboard_tables.sql
   • Adds account_characters and frag_leaderboard tables
   • Required for web leaderboard integration
   • Safe to run multiple times (uses IF NOT EXISTS)
   • Tables will automatically populate as players log in and save

Creating New Migrations

1. Create SQL file in sql/migrations/
2. Use descriptive filename (e.g., add_feature_name.sql)
3. Include header comment with purpose and date
4. Use IF NOT EXISTS or IF EXISTS for idempotency
5. Test on development database first

---

Project Structure

DurisMUD/
├── src/               # C source code
│   ├── sql.c          # MySQL integration
│   ├── sql.h          # Database configuration
│   ├── files.c        # Player file I/O
│   ├── comm.c         # Network communication
│   ├── nanny.c        # Login handler
│   └── ...
├── lib/               # Game data files
│   ├── information/   # Help files
│   ├── etc/           # Configuration files
│   └── ...
├── areas/             # Zone/area files
├── Players/           # Player save files
│   └── {a-z}/         # Organized by first letter
├── Accounts/          # Account files
│   └── {a-z}/         # Organized by first letter
├── logs/              # Log files
│   └── log/           # System logs
│       ├── status     # MySQL and system status
│       ├── syslog     # Game events
│       └── cmdlog     # Player commands
├── sql/               # SQL scripts
│   └── migrations/    # Database migrations
├── docs/              # Documentation
└── duris              # Compiled binary

Important Files

• duris - Compiled MUD executable
• src/sql.h - Database credentials and configuration
• src/config.h - MUD configuration (port, directories, etc.)
• src/duris.sql - Main database schema
• logs/log/status - MySQL connection logs
• logs/log/syslog - Main game log

---

Logs

Log Locations

All logs are in logs/log/ directory:

Log File	Purpose	When to Check
status	MySQL connections, system status	Database connection issues
syslog	Game events, player actions	General debugging
cmdlog	Player commands	Command debugging
wizlog	Immortal commands	Admin actions

Viewing Logs

# Real-time monitoring:
tail -f logs/log/status
tail -f logs/log/syslog

# Search for errors:
grep -i error logs/log/status
grep -i mysql logs/log/status

# View recent entries:
tail -100 logs/log/status

---

Contributing

Code Style

• Use consistent indentation (2 spaces)
• Comment complex logic
• Follow existing code patterns
• Test thoroughly before committing

Committing Changes

# Create a new feature branch:
git checkout -b feature/your-feature-name

# Stage changes:
git add <files>

# Commit with descriptive message:
git commit -m "Brief description of changes"

# Push branch to remote:
git push origin feature/your-feature-name

# Create pull request using GitHub CLI:
gh pr create --title "Your feature title" --body "Detailed description of changes"

Note: All changes should go through pull requests for code review before merging to master.

---