EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)
-   -   Debian Wiki Updates/Tweaks (https://www.eqemulator.org/forums/showthread.php?t=38561)

Shin Noir 08-01-2014 07:31 AM

Debian Wiki Updates/Tweaks
 
Howdy.
http://wiki.eqemulator.org/p?EQEmu_o..._6_VM&frm=Main
This topic above, here's my notes about it.

I used debian-7.6.0-amd64-netinst.iso

----compile EQEMU section---
cmake is now used instead of just make, so these steps are added:
apt-get install cmake
cmake .
make

---Grabbing the sources--
remove these (deprecated):
svn co http://projecteqdb.googlecode.com/svn/trunk/peqdatabase peq
svn co http://projecteqquests.googlecode.com/svn/trunk/quests quests

they're now https://drive.google.com/folderview?...p=sharing#list


copying and linking files:

on the change to server dir, copy and create links steps:
cp ../source/utils/patches/patch_* ./
cp ../source/utils/patches/opcodes.conf ./

This is a personal preference, so if you recompile it backs up old and copies new. cleanipc and a lot of commands aren't properly noted here, but can be. (You need to copy the files from ~/eq/source/Bin/* over to your ~/eq/server/ dir.
~/eq/server/$
nano sync.sh
Code:

#!/bin/bash
#sync latest compiled source files to server dir. Place in server dir.
mkdir -p backup/
cp zone backup/$(date +%Y-%m-%d)-zone
cp ../source/Bin/zone .
cp eqlaunch backup/$(date +%Y-%m-%d)-eqlaunch
cp ../source/Bin/eqlaunch .
cp world backup/$(date +%Y-%m-%d)-world
cp ../source/Bin/world .
cp /usr/lib/libEMuShareMem.so backup/$(date +%Y-%m-%d)-libEMuShareMem.so
cp ../source/Bin/libEMuShareMem.so /usr/lib/
echo Syncronized.

Database Setup no longer has a peqdb_rev.sql_gz, the source noted has a readme DO NOT USE THIS DB
instead, copied from the readme.txt
-----------
create database whatever_db_name_you_want;
use whatever_db_name_you_made;
source peqbeta_blahblah.sql;
source player_tables_blahblah.sql;

(OPTIONAL) source load_login.sql;
(OPTIONAL) source load_bots.sql;

copy eqtime.cfg over to the directory where your server binaries live.

If you plan on using the public EQEmu login server, then sourcing load_login.sql is not necessary.
If you wish to use a local login, you can login using Admin and the password "password". You can also look in load_login.sql to see how to add your own users manually.

-----------------

Then run:
mysql -u root -p peq < peqbeta*.sql
mysql -u root -p peq < player_tables_*.sql

cp ~/eq/peq/eqtime.cfg ~/eq/server/

EQEMU setup--
the mv eqemu_config.xml.bak command doesn't do anything. No source/destination. I think it wants:
mv eqemu_config.xml eqemu_config.xml.bak


Create your server start and stop files---

instead of the mess of shell scripts, I normally install gnu screen or tmux or whatever. I adjust tmux personally with this https://gist.github.com/andreyvit/2921703 so it feels like screen. and do a series of C+a c C+a , and call them eqlaunch, world, whatever you launch.

eqconfig needs login.eqemulator.net 5998 as well

I think that's about it.

Akkadius 08-01-2014 11:40 AM

Shin,

Would you like a Wiki user to update the page yourself?

Thanks,
-Akka

hayward6 08-01-2014 01:22 PM

Quote:

Originally Posted by Shin Noir (Post 232390)
words...

This will be extremely helpful! I have recently been trying to revive my old linux server, and so much is different. Thank you,

Shin Noir 08-01-2014 04:54 PM

I suppose I could do that Akkadius. I tried originally and noticed it was locked except for wiki members, figured I'd write self notes/tell you guys to do it than go through process of applying.

Thanks.

hayward6 08-01-2014 07:15 PM

Quote:

Originally Posted by Shin Noir (Post 232415)
I suppose I could do that Akkadius. I tried originally and noticed it was locked except for wiki members, figured I'd write self notes/tell you guys to do it than go through process of applying.

Thanks.

I look forward to seeing it all together, because I don't know what this means... I can navigate to that site in windows and download the files, but I don't know how to grab them directly from the command line in Linux. The link you posted doesn't seem to be enough.

"---Grabbing the sources--
remove these (deprecated):
svn co http://projecteqdb.googlecode.com/svn/trunk/peqdatabase peq
svn co http://projecteqquests.googlecode.com/svn/trunk/quests quests

they're now https://drive.google.com/folderview?...p=sharing#list"

Akkadius 08-01-2014 07:31 PM

Sent in a PM Shin.

Thank you so much for getting the Debian install up to date.

This was needed badly.

Also, bonus points for anyone who gets a Debian VM setup and then lets me download it from them so I can host it on our Wiki for an instant sandbox.

hayward6 08-01-2014 07:40 PM

Quote:

Originally Posted by Akkadius (Post 232421)
Sent in a PM Shin.

Thank you so much for getting the Debian install up to date.

This was needed badly.

Also, bonus points for anyone who gets a Debian VM setup and then lets me download it from them so I can host it on our Wiki for an instant sandbox.

That would be awesome! My only hesitation is that the knowledge that it takes to set up a server is also required to update it. If I could just come here and download the VMDK file, I would probably have no idea how to edit and update it.

Shin Noir 08-02-2014 12:09 AM

Replied to your PM with a virtualbox install package, akkadius. I'm working on a new page for the tutorial instead of editing the old one. (With videos).
http://wiki.eqemulator.org/p?EQEmu_o...n_7_Virtualbox

Shin Noir 08-02-2014 12:28 AM

Quote:

Originally Posted by hayward6 (Post 232420)
I look forward to seeing it all together, because I don't know what this means... I can navigate to that site in windows and download the files, but I don't know how to grab them directly from the command line in Linux. The link you posted doesn't seem to be enough.

"---Grabbing the sources--
remove these (deprecated):
svn co http://projecteqdb.googlecode.com/svn/trunk/peqdatabase peq
svn co http://projecteqquests.googlecode.com/svn/trunk/quests quests

they're now https://drive.google.com/folderview?...p=sharing#list"

My new tutorial shows how I do this, since wget isn't friendly in cli with google's downloading. (I just use filezilla for easy scp)

hayward6 08-02-2014 07:03 AM

Quote:

Originally Posted by Shin Noir (Post 232440)
My new tutorial shows how I do this, since wget isn't friendly in cli with google's downloading. (I just use filezilla for easy scp)

I setup webmin and moved the files that way simply because it's what I know.

hayward6 08-03-2014 09:03 AM

The videos are great! Thank you for the update. I will try to run through this setup tomorrow to see how it goes. My only differences will be that I am using Vmware Workstation 10, and I am more accustom to using vi for editing.

Shin Noir 08-03-2014 04:12 PM

I finished my wiki article, now I'll go and edit the original one as soon as I find time. :)

hayward6 08-03-2014 08:20 PM

Quote:

Originally Posted by Shin Noir (Post 232486)
I finished my wiki article, now I'll go and edit the original one as soon as I find time. :)

I am very impressed and thankful to you for doing this. I am about half way through and everything is working great. I gave the idea of hosting a complete image some more thought, and I just don't know... It would be difficult to keep that image updated and very hard for someone with no linux experience to just start owning it.

Shin Noir 08-03-2014 08:25 PM

Meh, I can give guidance to a linux noob on how to maintain stuff. I'm just too lazy to do all the upkeep myself. :P

hayward6 08-04-2014 10:20 AM

I've just about got it, but still have a couple things not going well. The LibEMuShare file is in the server directory...

Code:

[Debug] [WORLD__HTTP] Requesting that HTTP Service stop.
[Debug] [COMMON__THREADS] Ending EQStreamFactoryWriterLoop with thread ID 1268692736
[Debug] [COMMON__THREADS] Ending TCPServerLoop with thread ID 1296017152
eqemu@debian:~/server$ nano eqemu_config.xml
eqemu@debian:~/server$ ls -lt
total 87252
-rw-r--r-- 1 eqemu eqemu      30 Aug  4 10:14 eqtime.cfg
drwxr-xr-x 2 eqemu eqemu    4096 Aug  4 10:13 logs
-rw-r--r-- 1 eqemu eqemu 18028095 Aug  4 08:21 spells_us.txt
-rw-r--r-- 1 eqemu eqemu  2149759 Aug  4 08:20 spells_en.txt
-rw-r--r-- 1 eqemu eqemu    2508 Aug  4 08:14 eqemu_config.xml
lrwxrwxrwx 1 eqemu eqemu        9 Aug  4 07:35 quests -> ../quests
lrwxrwxrwx 1 eqemu eqemu      17 Aug  4 07:35 plugins -> ../quests/plugins
lrwxrwxrwx 1 eqemu eqemu        8 Aug  4 07:35 Maps -> ../maps/
-rw-r--r-- 1 eqemu eqemu    16719 Aug  4 07:35 opcodes.conf
-rw-r--r-- 1 eqemu eqemu    22607 Aug  4 07:35 patch_SoF.conf
-rw-r--r-- 1 eqemu eqemu    18844 Aug  4 07:35 patch_Titanium.conf
-rw-r--r-- 1 eqemu eqemu    19006 Aug  4 07:35 patch_Underfoot.conf
-rw-r--r-- 1 eqemu eqemu    17718 Aug  4 07:35 patch_6.2.conf
-rw-r--r-- 1 eqemu eqemu    16027 Aug  4 07:35 patch_RoF.conf
-rw-r--r-- 1 eqemu eqemu    18916 Aug  4 07:35 patch_SoD.conf
-rwxr-xr-x 1 eqemu eqemu 45408815 Aug  4 07:34 zone
-rwxr-xr-x 1 eqemu eqemu 13984142 Aug  4 07:34 world
-rwxr-xr-x 1 eqemu eqemu  4485617 Aug  4 07:34 ucs
-rwxr-xr-x 1 eqemu eqemu  2433598 Aug  4 07:34 queryserv
-rwxr-xr-x 1 eqemu eqemu  266920 Aug  4 07:34 libEMuShareMem.so
-rwxr-xr-x 1 eqemu eqemu  2371644 Aug  4 07:34 eqlaunch
-rwxr-xr-x 1 eqemu eqemu    32988 Aug  4 07:34 cleanipc
eqemu@debian:~/server$ nano eqemu_config.xml
eqemu@debian:~/server$ [Debug] [WORLD__INIT] Starting HTTP world service...
-su: [Debug]: command not found
eqemu@debian:~/server$ [Debug] [COMMON__THREADS] Starting DBAsyncLoop with thread ID 1287624448
-su: [Debug]: command not found
eqemu@debian:~/server$ [Debug] [WORLD__HTTP_ERR] Failed to load mime types from 'mime.types'
-su: [Debug]: command not found
eqemu@debian:~/server$ [Debug] [WORLD__INIT] Loading variables..
-su: [Debug]: command not found
eqemu@debian:~/server$ [Debug] [WORLD__INIT] Loading zones..
-su: [Debug]: command not found
eqemu@debian:~/server$ [Debug] [WORLD__INIT] Clearing groups..
-su: [Debug]: command not found
[Debug] [WORLD__INIT] Clearing raids..
[Debug] [WORLD__INIT] Loading items..
eqemu@debian:~/server$ [Debug] [WORLD__INIT] Clearing raids..
-su: [Debug]: command not found
eqemu@debian:~/server$ [Debug] [WORLD__INIT] Loading items..
-su: [Debug]: command not found
eqemu@debian:~/server$ [Error] Load Shared Library 'libEMuShareMem.so' failed.  Error=libEMuShareMem.so: cannot open shared object file: No such file or directory
-su: [Error]: command not found
eqemu@debian:~/server$ [Debug] [WORLD__INIT_ERR] Error: Could not load item data.  But ignoring
-su: [Debug]: command not found
eqemu@debian:~/server$ [Debug] [WORLD__INIT] Loading guilds..
-su: [Debug]: command not found
eqemu@debian:~/server$ [Debug] [WORLD__INIT] Loaded default rule set 'default'
-su: [Debug]: command not found
eqemu@debian:~/server$ ^C
You have new mail in /var/mail/eqemu
eqemu@debian:~/server$


hayward6 08-04-2014 10:37 AM

I was able to get through the SharedMem issue by doing a forum search. I needed to copy that file to the /usr/lib directory. It seems fine now. The only think that is happening now is the mime.types file is not in the server directory. I am going back to figure out where that file is built and see if I can locate it.

hayward6 08-04-2014 10:49 AM

ok I was able to find mime.types in the source/utils/defaults directory, so I either skipped a couple steps where this and the other file are either copied, moved, or linked, or its missing from the wiki. Thanks again, this was very easy to follow and I believe I am all setup. I will probably run through a clean build again tonight just to make sure I understand it.

hayward6 08-04-2014 11:04 AM

I went here and used this script to start and stop the server and it seems to be working great. https://gist.github.com/mackal/7994207

Shin Noir 08-04-2014 02:39 PM

sudo mv libEMuShareMem.so /usr/lib
Added this to the instructions.

Yeah, there's tons of ways to write start/stop scripts.

demonstar55 08-04-2014 04:27 PM

Quote:

Originally Posted by hayward6 (Post 232513)
I went here and used this script to start and stop the server and it seems to be working great. https://gist.github.com/mackal/7994207

I would highly recommend using that script (I think I missed a ucs or something, but I'll blame whoever posted it originally :P)

The LD_LIBRARY_PATH line will also remove the need to copy that library to the system ... which I wouldn't recommend :P

hayward6 08-04-2014 06:09 PM

Yeah that script has been great! The only thing I seem to be dealing with now is my buffs dropping when I zone. I also have a couple user accounts that have signed on but not created a character, so I suspect some small linger issue there. Right now I am just tweaking things like mysql backups and making management easier.

hayward6 08-04-2014 07:10 PM

I was able to compress the entire server image down to 1.7GB, so staging a download where someone can go retrieve there own fresh server might not be that difficult... Again, I am not sure if it's really needed though.

vsab 08-05-2014 04:03 AM

1.7gb? Surely a stripped down linux vm should take up no more than 200MB HD and 64mb RAM? /troll ;)

Shin Noir 08-05-2014 04:05 AM

Quote:

Originally Posted by vsab (Post 232534)
1.7gb? Surely a stripped down linux vm should take up no more than 200MB HD and 64mb RAM? /troll ;)

It's actually possible, but not worth the effort. XD

vsab 08-05-2014 05:28 AM

Heh yeah I used to be a Slackware then Gentoo freak, trying to get it to run on my toaster like netBSD could.

I actually fancy having a stab at running a server on Ubuntu LTS 14.04, because it's half the price of a windows VM on Azure.

Shin Noir 08-05-2014 06:36 AM

I love slack. ./configure, make, make install or bust!
emerging the world, ehh, not so much.
My debian 7 tutorial is like 99% applicable to ubuntu LTS 14.04 server.

the vm instance on tutorial ends up being about 744mb ram to run the core, LAMP stack, SSHd, and world/eqlaunch 5 zones. each zone is about 25mb, world is ~6mb if I read it correctly. A loaded zone goes up to about 45mb. I should see how much memory goes up having a single character loaded in.

Shin Noir 08-05-2014 06:51 AM

Quote:

Originally Posted by demonstar55 (Post 232521)
I would highly recommend using that script (I think I missed a ucs or something, but I'll blame whoever posted it originally :P)

The LD_LIBRARY_PATH line will also remove the need to copy that library to the system ... which I wouldn't recommend :P

Adjusted tutorial to use the script and not the /usr/lib/ hack. :P

hayward6 08-05-2014 08:42 AM

Quote:

Originally Posted by vsab (Post 232534)
1.7gb? Surely a stripped down linux vm should take up no more than 200MB HD and 64mb RAM? /troll ;)

hehe the database and map files alone make that impossible :) I am running through this setup again because I can't seem to resolve the buffs dropping at zone in. Seems I may have picked up a copy of the source when it was a little unstable...

hayward6 08-05-2014 09:02 AM

I had to add a step here... the config.php file was actually named config.pfp.dist, so I changed it to config.php and got the editor working.

22 - Set up PHPEditor
First, we need to inject the schema file for phpeditor
$ sudo mysql -u eq -p -h 127.0.0.1 eq < /var/www/phpeditor/sql/schema.sql
Go to a web browser, access 10.0.0.110/phpeditor/
It should note database is not configured.
$ sudo nano /var/www/phpeditor/config.php
change the dbhost, 127.0.0.1
dbuser change to eq
password change to password
Refresh web page, should show prompt
Log in as admin/password

hayward6 08-05-2014 09:16 AM

Another interesting issue... I have never used the phpeditor before, so I may just need to familiarize myself...

Could not create logs/sql_log_08-2014.sql! Make sure the logs directory is writeable by your webserver.

Here's another issue I will just add as an edit to save posts. I cannot get the http management portal working. I have used it for years and I know how to turn it on in eqemu_config.xml and forward port 9080... I am just going through the tutorial looking for things like this so we know its 100%

hayward6 08-05-2014 03:48 PM

I believe I have come to a conclusion... There might be too many small issues going on for me to run a server these days :( I cannot fix the buffs dropping, I cannot speak in /ooc and it looks like chat is not connecting at all, and I even noticed that the default login server is wrong in the eqemu_config.xml file... There are probably a dozen little issues that seem to be all over the forum and I probably don't have the skill to figure out all of them.

Akkadius 08-05-2014 03:56 PM

Quote:

Originally Posted by hayward6 (Post 232551)
I believe I have come to a conclusion... There might be too many small issues going on for me to run a server these days :( I cannot fix the buffs dropping, I cannot speak in /ooc and it looks like chat is not connecting at all, and I even noticed that the default login server is wrong in the eqemu_config.xml file... There are probably a dozen little issues that seem to be all over the forum and I probably don't have the skill to figure out all of them.

It is probably better that we work through them because everyone else is going to run into them and if you just give up then we can't correct the issues.

The buffs issue is related to you missing proper columns in the database, so when you zone the data wasn't actually able to store properly so its not going to be there when the server tries to reassign them to the character.

Check your utils/sql/git/required/ for any missing updates, yours sounds like this:

https://github.com/EQEmu/Server/blob...uff_update.sql

The default config has login.eqemulator.net which is the right one.

The chatserver not being able to connect could be as simple as eqemu_config.xml settings. Hard to know unless we get some sort of error.

/ooc is a rule setting for minimum level required to chat in /ooc.

Quote:

1 Chat:GlobalChatLevelLimit 1

demonstar55 08-05-2014 04:00 PM

You may also need to repair the table. (if I it got corrupted some how from a crash or something)

hayward6 08-05-2014 04:09 PM

Quote:

Originally Posted by demonstar55 (Post 232553)
You may also need to repair the table. (if I it got corrupted some how from a crash or something)

I don't know... I have now run through this wiki 3 times now from bare metal and I am getting very good at it :) The database has been dropped and re-downloaded 5 times now and when I look at all the updates they fail to apply because they are already part of it...
Error Code: 1054. Unknown column 'death_save_chance' in 'character_buffs'


in the source that I built this morning downloaded just as described in the wiki the login server information is this...

Code:

<loginserver>
                        <host>eqemulator.net</host>
                        <port>5998</port>
                        <account></account>
                        <password></password>
                </loginserver>


hayward6 08-05-2014 04:17 PM

I was able to find the chat in ooc minimum and changed it. Testing that now. Wow there are a lot more rules and variables then I remember :)

hayward6 08-05-2014 04:25 PM

Quote:

Originally Posted by Akkadius (Post 232552)

Check your utils/sql/git/required/ for any missing updates, yours sounds like this:

That might be the problem... I don't have a /source/utils/sql/git folder at all... I have an svn folder...

hayward6 08-05-2014 05:38 PM

Here's one more symptom just so we have a complete list. Every time I create a new character my client crashes and I have to login again to choose the character. I am using SOF

Akkadius 08-05-2014 05:40 PM

Quote:

Originally Posted by hayward6 (Post 232557)
Here's one more symptom just so we have a complete list. Every time I create a new character my client crashes and I have to login again to choose the character. I am using SOF

Use Underfoot client, SoF has aids

hayward6 08-05-2014 06:25 PM

Quote:

Originally Posted by Akkadius (Post 232558)
Use Underfoot client, SoF has aids

haha, I actually have been very good about downloading all of the supported clients as they come along, so I have Titanium - Rain of Fear to test out. I will work on that next :)

hayward6 08-05-2014 06:52 PM

Well, Rain of Fear seems to work ok, but the buffs are still dropping at zone.


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

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