P99 Open source

[starkind]

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

I already did that but a scared Enchanter claimed it's because the client code somehow has an issue with modified server side channeling code which is somewhat plausible. In the absence of any staff feedback I figure I'll go verify if that is true or not.

It will also make for a better timeline of how broken bug reports and contributions are...

1. Create bug report to research issue.
2. Gather evidence and prove something isn't classic.
3. Propose code change per contribution guidelines and get ignored by developers.
4. Argue with other people on forums who are scared about getting nerfed.
5. Stand up server to validate potentially misleading claims from scared players due to still being ignored by developers.
<-- You are here.
6. Prove you were misled by randos on forum and have now wasted hours, day, weeks, eons of your time and are still being ignored by developers.
7. Create new bug report about the bug report process.
8. Get channeling nerfed.
9. Laugh as people can't level past 20 anymore because the game gets too difficult and the entire "raid scene" collapses simply due to a lack of high level players until people catch up in Velious.

very valid point, its a lot of work to test things, so i applauded you for that.

genuinely!

[Pringles]

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

snip

You should hit up New Age Soldier and snag a copy of the EQClassic source that the TAKP team updated to not use ancient eqemu code. Probably a fun project if you are thirsty for classic content and have the chops.

edit: or hit up the lantern eq guy and see if he needs assistance

[starkind]

Yep takp has a pretty solid database available to public?

[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.

[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