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

Shin,

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

Thanks,
-Akka

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

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"

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.

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

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.

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.

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.

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

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

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.

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.

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

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

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

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

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.

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.

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

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.

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.

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

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

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

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%

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.

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

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 :)

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

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

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 :)

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