P99 Open source

[Dolalin]

Originally Posted by azxten [You must be logged in to view images. Log in or Register.]

https://github.com/dbsanfte/eqemu-server-docker



True EverQuest hero.

Lol you found it. My Splitpaw test server uses that.

[azxten]

Where is the peq database these days? http://peqtgc.com/ is down

[Dolalin]

Those seem to have moved here:

http://db.projecteq.net/

I updated the steps on my git archive with the new file paths, let me know if it still works properly.

[azxten]

Thanks, worked well

From Ubuntu 20 VM:

# Install necessary packages

sudo apt update
sudo apt install openssh-server docker docker.io docker-compose wget git
sudo systemctl start sshd
sudo systemctl start docker
sudo systemctl start containerd
sudo systemctl enable ssh
sudo systemctl enable docker
sudo systemctl enable containerd

# Setup directories and clone git repo

mkdir eqemu
sudo mkdir -p /home/eqemu/shared; sudo chown -R doc. /home/eqemu
git clone https://github.com/dbsanfte/eqemu-server-docker.git
mv eqemu-server-docker/conf/* /home/eqemu/

# Download PEQ database, EQEmu .sql files, and extract/move into place

wget http://db.projecteq.net/latest -O /home/doc/eqemu/peq_dump.zip
wget https://raw.githubusercontent.com/EQ...gin_schema.sql -O /home/doc/eqemu/login_schema.sql
unzip eqemu/peq_dump.zip -d eqemu; mv eqemu/login_schema.sql eqemu/peq-dump/

# Start mariadb docker instance mapping port 3306 on VM to 3306 on Docker instance, volume mount /home/doc/eqemu to /var/lib/mysql to retain database through instance restarts, set database login credentials

docker run --detach --name eqemu-mariadb --restart always -p 3306:3306 -v /home/doc/eqemu:/var/lib/mysql --env MARIADB_USER=eqemu-user --env MARIADB_PASSWORD=P99Channeling --env MARIADB_ROOT_PASSWORD=P99Channeling mariadb:latest

# Initalize mariadb database with .sql files

mysql -h 127.0.0.1 -uroot -pP99Channeling -e "create database peq;"; mysql -h 127.0.0.1 -uroot -pP99Channeling peq < /home/doc/eqemu/peq-dump/create_tables_content.sql; mysql -h 127.0.0.1 -uroot -pP99Channeling peq < /home/doc/eqemu/peq-dump/create_tables_player.sql; mysql -h 127.0.0.1 -uroot -pP99Channeling peq < /home/doc/eqemu/peq-dump/login_schema.sql

# Customize /home/eqemu/.conf files

cd /home/eqemu/; ls

# Edit these files as needed, set zone=X to number of zone servers, set MySQL password in eqemu_config.json, edit "CHANGEME" lines, set loginserver to 127.0.0.1 for localhost login server

docker-compose up -d --scale zone=1

# After docker-compose up finishes, monitor logs for finish of database update script
# while true; do docker logs eqemu_world_1 | tail -n 20; sleep 10; clear; done
# Ctrl+C to stop

docker logs eqemu_world_1

# Once database update script finishes

docker-compose down; docker-compose up -d --scale zone=10

# Your EQEmu / PEQ server is ready to login
# Login accounts are stored in login_accounts table, created upon login attempt to local loginserver
# Login server sends client to world server sends client to zone server, check your client can reach the IP specified in eqemu_config.json, containers can reach 127.0.01 but client can not, use VM external IP instead

Probably missing something but figured this might be helpful to someone. How to stand up a Ubuntu 20 VM as a stand alone EQEmu server with PEQ database using Dolalin's eqemu-server-docker images.

[You must be logged in to view images. Log in or Register.]

Next episode I'll rebuild with altered channeling code and test.

[starkind]

In 2021 you have p99 wiki
And three live servers.

P99 didn't have that.

[starkind]

Yep takp has a pretty solid database available to public?

[Jimjam]

Inspirational!

[starkind]

1337

[cd288]

Yes they'll totally do this because you posted about it after they have countless times said they wouldn't. A+ post

[azxten]

Originally Posted by cd288 [You must be logged in to view images. Log in or Register.]

Yes they'll totally do this because you posted about it after they have countless times said they wouldn't. A+ post

I have received word from on high. Sir Nilbog has blessed my work. Your Enchanter will be nerfed soon. I'm already graphing channeling equations to maximize your tears.