EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)
-   -   Modified Akk-Stack help (https://www.eqemulator.org/forums/showthread.php?t=44302)

nosfentora 02-12-2025 05:00 PM

Modified Akk-Stack help
 
Good afternoon y'all -

I've gotten my Akk-stack up and running for a while on my local machine and everything works great.

I've been trying to convert it to a container that can run on my Unraid server so I don't need to have my machine up all the time.

For the moment, all I care about are the database and server containers.

I've gotten the db container up and running and successfully switched over from the mariadb docker to my mysql container on unraid.
Akk-stack works fine w/ the mariadb stopped and connected to unraid MySQL.

yay.

next, i created the template for unraid following the docker-compose.yml in the root of akk-stack.

I cloned the akk-stack repo to my unraid server and mapped accordingly.
I fired up the container, hit the console and ran make install, and everything seems to work fine.

Spire is up and running and I'm able to get the server up. No crashes in the logs. Spire Launcher, World, Zone, UCS, LoginServer, QueryServ are all running.

i updated my eqhost.txt file to my server's lan ip and I can see my unraid server in the list - but get the "Error 1017: cannot login to the EverQuest server".

boo.

It has to be a port somewhere, but I'm not sure which.

If I change the eqhost (from 192.168.1.20:5999) back to my local machine (192.168.1.200:5999), I can log into the local docker stack no problem.

This is the docker command output from unraid and it all looks right

Code:

docker run
  -d
  --name='PEQ_Server'
  --net='bridge'
  --pids-limit 2048
  -e TZ="America/Chicago"
  -e HOST_OS="Unraid"
  -e HOST_HOSTNAME="Guardian"
  -e HOST_CONTAINERNAME="PEQ_Server"
  -e 'SPIRE_PORT'='3000'
  -e 'SPIRE_ADMIN_PASSWORD'='XXXXXXXXX'
  -e 'SERVER_PASSWORD'='XXXXXXXXX'
  -e 'EQEMU_DB_PASSWORD'='eqemu'
  -e 'PEQ_EDITOR_PASSWORD'='XXXXXXXXX'
  -e 'IP_ADDRESS'='192.168.1.20'
  -e 'PORT_RANGE_HIGH'='7030'
  -e 'TZ'='US/Central'
  -l net.unraid.docker.managed=dockerman
  -p '2222:22/tcp'
  -p '2222:22/udp'
  -p '8085:8080/tcp'
  -p '9001:9001/tcp'
  -p '9001:9001/udp'
  -p '9000:9000/tcp'
  -p '9000:9000/udp'
  -p '5999:5999/tcp'
  -p '5999:5999/udp'
  -p '5998:5998/tcp'
  -p '5998:5998/udp'
  -p '6000:6000/tcp'
  -p '7778:7778/tcp'
  -p '7778:7778/udp'
  -p '7000-7030:7000-7030/udp'
  -p '3000-3001:3000-3001/tcp'
  -v '/mnt/user/appdata/eqemu/server/server/':'/home/eqemu/server':'rw'
  -v '/mnt/user/appdata/eqemu/server/code/':'/home/eqemu/code':'rw'
  -v '/mnt/user/appdata/eqemu/server/assets/':'/home/eqemu/assets':'rw'
  -v '/mnt/user/appdata/eqemu/server/build-cache/':'/home/eqemu/.ccache':'rw'
  -v '/mnt/user/appdata/eqemu/server/spire-assets/':'/home/eqemu/.cache':'rw'
  -v '/mnt/user/appdata/eqemu/server/var-log/':'/var/log':'rw'
  --cap-add=SYS_PTRACE
  --add-host=mariadb:192.168.1.20 'akkadius/eqemu-server:v15'

Code:

{
 "server": {
  "zones": {
  "defaultstatus": "0",
  "ports": {
    "low": "7000",
    "high": "7030"
  }
  },
  "qsdatabase": {
  "db": "peq",
  "host": "192.168.1.20",
  "port": "3306",
  "username": "eqemu",
  "password": "eqemu"
  },
  "ucs": {
  "host": "0.0.0.0",
  "port": "7778"
  },
  "world": {
  "api": {
    "enabled": false
  },
  "address": "0.0.0.0",
  "localaddress": "127.0.0.1",
  "loginserver1": {
    "port": "5998",
    "account": "",
    "password": "",
    "host": "login.eqemulator.net",
    "legacy": "1"
  },
  "loginserver2": {
    "account": "",
    "password": "",
    "host": "127.0.0.1",
    "port": "5998"
  },
  "loginserver3": {
    "account": "",
    "password": "",
    "host": "login.projecteq.net",
    "port": "5998"
  },
  "tcp": {
    "ip": "0.0.0.0",
    "port": "9001"
  },
  "telnet": {
    "ip": "0.0.0.0",
    "port": "9000",
    "enabled": "true"
  },
  "key": "blah blah",
  "shortname": "Nosfentoras Unraid Server",
  "longname": "Nosfentoras Unraid Server"
  },
  "database": {
  "db": "peq",
  "host": "192.168.1.20",
  "port": "3306",
  "username": "eqemu",
  "password": "eqemu"
  },
  "files": {
  "opcodes": "assets/opcodes/opcodes.conf",
  "mail_opcodes": "assets/opcodes/mail_opcodes.conf"
  },
  "directories": {
  "patches": "assets/patches/",
  "opcodes": "assets/opcodes/"
  }
 },
 "web-admin": {
  "version": "1.0.0",
  "application": {
  "key": "blah blah",
  "admin": {
    "password": "XXXXXXXX"
  }
  },
  "launcher": {
  "runSharedMemory": true,
  "runLoginserver": true,
  "runQueryServ": true,
  "runUcs": true,
  "isRunning": false,
  "minZoneProcesses": 5,
  "staticZones": "butcher,erudnext,freporte,qeynos,freeporte,oot,iceclad,nro,oasis,nedaria,abysmal,natimbi,timorous,firiona,overthere",
  "updateOpcodesOnStart": true,
  "deleteLogFilesOlderThanDays": 1
  },
  "quests": {
  "hotReload": true
  },
  "serverCodePath": "/home/eqemu/code/"
 },
 "spire": {
  "encryption_key": "blah blah",
  "launcher_start": true
 }
}

Any suggestions?

nosfentora 02-12-2025 05:17 PM

Welp... I think I got it figured out (or at least I got it to work)

Server Public Address 0.0.0.0 and Local Address to 192.168.1.20

(I SWEAR I tried this combo before)

At first I also set the unraid network type to HOST, and it worked.
I switched back to BRIDGE and it still works.


Anyhow - hope this thread helps someone....

nosfentora 02-27-2025 03:58 PM

I've been using this docker for a couple of weeks now and it seemed to work great, until i went to start the server today and noticed the pre-flight showed some errors.

I went to the console and ran the update, but world asks if i want to run the update, but gives me no opportunity to give input.

Quote:

World | Info | UpdateManifest [9297] [missing] | [2024_01_22_sharedbank_guid_primary_key.sql]
World | Info | UpdateManifest [9298] [missing] | [2024_10_24_inventory_changes.sql]
World | Info | UpdateManifest [9299] [ok] | [2024_10_24_merchantlist_temp_uncap.sql]
World | Info | UpdateManifest [9300] [missing] | [2024_10_15_npc_types_multiquest_enabled.sql]
World | Info | UpdateManifest [9301] [missing] | [2024_10_08_add_detail_player_event_logging.sql]
World | Info | UpdateManifest [9302] [missing] | [2025_02_09_illusion_block.sql]
World | Info | UpdateManifest [9303] [ok] | [2025_02_13_corpse_slot_fix.sql]
World | Info | UpdateManifest [9304] [missing] | [2024_12_01_2024_update_guild_bank]
World | Info | UpdateManifest [9305] [missing] | [2024_12_01_expedition_dz_merge.sql]
World | Info | UpdateManifest [9306] [missing] | [2025_02_16_data_buckets_zone_id_instance_id.sql]
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest Automatically backing up database before applying updates
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | DatabaseDump MySQL installed [mysql Ver 15.1 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper]
World | Info | DatabaseDump Database [peq] Host [192.168.1.20] Username [eqemu]
World | Info | DatabaseDump Backing up database [mysqldump --defaults-extra-file=login.my.cnf peq --allow-keywords --extended-insert --max-allowed-packet=1G --net-buffer-length=32704 --skip-lock-tables > backups/peq-2025-02-27.sql]
World | Info | DatabaseDump This can take a few minutes depending on the size of your database
World | Info | DatabaseDump LOADING... PLEASE WAIT...
eqemu@8a123c368d54:~$ World | Info | DatabaseDump Database dump created at [backups/peq-2025-02-27.sql]
World | Info | DatabaseDump Compression requested. Compressing dump [backups/peq-2025-02-27.sql]
World | Info | DatabaseDump Compressed dump created at [backups/peq-2025-02-27.tar.gz]
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest Running database migrations. Please wait...
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest Some migrations require user input. Running interactively
World | Info | UpdateManifest This is usually due to a major change that could cause data loss
World | Info | UpdateManifest Your server is automatically backed up before these updates are applied
World | Info | UpdateManifest but you should also make sure you take a backup prior to running this update
World | Info | UpdateManifest Would you like to run this update? [y/n] (Timeout 60s)
World | Info | UpdateManifest ----------------------------------------------------------------------
y
bash: y: command not found

[2]+ Stopped cd ~/server && ./bin/world
How do i get it to run the input? And what did i miss updating that a bunch of sql are missing?

nosfentora 02-27-2025 04:27 PM

I re-ran make install and saw that world takes parameters

Running
cd ~/server && ./bin/world database:updates

seems to have gotten me what I needed


All times are GMT -4. The time now is 10:12 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.