Trying to set up server

[Jster22]

Hello,
I am trying to set up a server. I have been following the guide Installing EQEmu on Debian Linux but it is very out of date. I followed the guide up until the section "Extract Source" where is instructs me to execute "tar xzf EQEmu-0.7.0-1043-source.tgz".

I have created the user eqemu, added directories home/source and home/server. I have got the files from the svn repository. I'm not sure how to compile to code now? My source directory contains the folders eqemumaps-ready-only, projecteqemu-read-only, projecteqdb-current-only, projecteqqests-read-only.

What do I do next? Is there an updated guide somewhere?
Thank you for your help!

[trevius]

Well, for one thing, you are going to have to move the maps and quests folders into your server directory and rename them to "maps" and "quests" respectively. Make sure that the maps are directly inside that maps folder and not inside another folder within it. Also, quests should be in folders named after the shortname of each zone directly inside the quests folder.

You will also need to move your quests/plugins folder to your server folder.

Really, most of the debian install guide should still be useful information for getting setup. I think the only thing that has really changed is how you get the source code and database, as they both come from google svn now. Unfortunately, I don't have instructions on how to do that on Linux yet, but there may be some directions around the forums/wiki somewhere for it.

Once you get the EQEmuServer source code downloaded, you can just go into that folder and type "make" and if you have followed all of the other steps, it should compile properly.

[Mirakus]

If you're still having problems, I would recommend reading this thread: http://eqemulator.org/forums/showthread.php?t=30773 and using the script described there.

I started out with trying to use the Debian guide, and had a lot of problems along the way. Snag the later version of the script from that other thread, and then add into the section where it adds links a link for commands.pl and login.ini. I'm not sure of the exact directory locations at this time. You might be able to get that setup script working with your existing installation, but you may need to rename some directories or move things around. I know that the script creates a lot of soft links into the server directory that you do not create (and need) when using the Debian guide.

If you're planning on running your own login server and running locally only in your LAN, I would recommend setting the address and local address values in eqemu_config.xml. A couple of guides out there say it is unnecessary, but I had to do that in order to get up and running.

[Jster22]

Hello trevius and Mirakus,

Thanks for the replies. I will look into both of your suggestions. Hopefully I can get this working. I'm sure I'll be replying back with more questions.

trevius, I have logged into your server before. You have done a very good job with it.

[Jster22]

Mirakus,

I don't know the exact commands for adding the links for commands.pl and login.ini. I did find those files in eqemulator/projecteqemu/utils/defaults/commands.pl and eqemulator/projecteqemu/EQEmuLoginServer/login_util/login.ini. Would this mean the link commands would look like this

user@server:/home/eqemulator/server$ ln -s ../projecteqemu/utils/defaults/commands.pl \
done
user@server:/home/eqemulator/server$ ln -s ../projecteqemu/EQEmuLoginServer/login_util/login.ini \
done

That doesn't seem right to me. Any ideas on this?

My end goal is to set up a private server for a few of my friends and myself. They live in different cities so I will need to setup a login server.

Thank you for taking time to help me.

[Kobaz]

Assuming you're in your server directory, the command you want will look like:

 ln -s ../projecteqemu/utils/defaults/commands.pl .

The keywork "done" terminates a loop block, such as a for or while loop.

[Jster22]

Thanks for the clarification Kobaz.

After running the script that Mirakus suggested, it said to cd into projecteqemu and make it. It errored out, so I tried it again and it errored out again. I'm not sure how to resolve this. Below is the error message from my second attempt.

make -C EMuShareMem
make[1]: Entering directory `/home/eqemulator/projecteqemu/EMuShareMem'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/home/eqemulator/projecteqemu/EMuShareMem'
make -C world
make[1]: Entering directory `/home/eqemulator/projecteqemu/world'
gcc -c -Wall -Wuninitialized -Wwrite-strings -Wcast-qual -Wcomment -Wcast-align -Wno-deprecated -g -march=i686 -O -pthread -pipe -I../common/SocketLib -DFX -D_GNU_SOURCE -DINVERSEXY -DWORLD -DDEBUG=5 -DEQDEBUG=5 -DSHAREMEM -DCATCH_CRASH -DNO_PIDLOG -DFIELD_ITEMS -DIRC -Di386 -DAPP_OPCODE_SIZE=2 -DEMBPERL -DEMBPERL_PLUGIN -DHAS_UNION_SEMUN -I/usr/include/mysql -DBIG_JOINS=1 -fPIC -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/lib/perl/5.10/CORE Adventure.cpp -o Adventure.o
Adventure.cpp: In member function ‘void Adventure::MoveCorpsesToGraveyard()’:
Adventure.cpp:381: error: ‘atoi’ was not declared in this scope
make[1]: *** [Adventure.o] Error 1
make[1]: Leaving directory `/home/eqemulator/projecteqemu/world'
make: *** [all] Error 2

[orkim]

You pretty much got it there Mirakus.

One note I will add, is "adding your ip to the top of the config file" portion from above.

Typically when the world server connects to the login server it will save the IP address from which the world server connected. Say, world server at 1.2.3.4 connects to login server at 4.3.2.1, therefor the login server knows the public IP address of the world server.

However, when you run both on the same machine (or within a LAN and desire outside connections) this can be a bit tricky. Local LAN + outside connections typically runs into some routing problems (i.e. route the internal LAN packets properly using internal addresses and still listen/respond to external addresses). If you're not concerned about external connections (i.e. from the internet) then you have a easier job. But I digress...

Here in lies the rub, the login server will not know the public/private IP address to which it should use to connect to the world server. This is why when you are running the login server and world server on a single machine you MUST set these fields. Otherwise the 'IP' gets recorded as 127.0.0.1 and all clients are then routed back to themselves (127.0.0.1) to look for the worldserver, which of course isn't there.

As clear as mud?

Hope that helps.

-ork

[Jster22]

Thanks for the replies Mirakus and orkim.

In my login_util>linux there are the folders fedora-12-64, gentoo32, and ubuntu-9-10-32. I chose ubuntu. I moved the files into EQEmuLoginServer and ran make. I believe it built ok this time.

gcc -o EQEmuLoginServer Client.o ClientManager.o Config.o DatabaseMySQL.o ErrorLog.o Main.o ServerManager.o WorldServer.o .obj/BasePacket.o .obj/Condition.o .obj/CRC16.o .obj/crc32.o .obj/debug.o .obj/emu_opcodes.o .obj/EmuTCPConnection.o .obj/EmuTCPServer.o .obj/EQPacket.o .obj/EQStream.o .obj/EQStreamFactory.o .obj/logsys.o .obj/logsys_eqemu.o .obj/misc.o .obj/MiscFunctions.o .obj/Mutex.o .obj/opcodemgr.o .obj/packet_dump.o .obj/packet_functions.o .obj/rdtsc.o .obj/TCPConnection.o .obj/TCPServer.o .obj/timeoutmgr.o .obj/timer.o .obj/unix.o -Wall -Wuninitialized -Wwrite-strings -Wcast-qual -Wno-deprecated -Wcomment -Wcast-align -O -g -march=i686 -pthread -pipe -DEQLAUNCH -DEQDEBUG=5 -I/usr/include/mysql -DBIG_JOINS=1 -fPIC -rdynamic -L. -lstdc++ -ldl -L/usr/lib/mysql -lmysqlclient -lEQEmuAuthCrypto -lcryptopp

Reading the eqemu_config.xml configuration guide, it says the file should be located in world/eqlaunch/zone. However, I found my file in projecteqemu/utils/defaults. Is this ok?

My goal is to open this server up for my friends to log on to. They live in different cities so I wont be connecting using LAN. Is there an easy way to find your WAN ip? I just went to whatismyip.com and put that value in for both <address> and <localaddress>. Or does localaddress need to be 127.0.0.1? Following the guide, this is my eqemu_config.xml file currently

<?xml version="1.0">
<server>
        <world>
                <shortname>setme</shortname>
                <longname>I Forgot To Edit My Config</longname>
                <address>(whatismyip.com)</address>
                <localaddress>(whatismyip.com)</localaddress>
                <key>some long random string</key>
        </world>
        <database>
                <host>localhost</host>
                <port>3306</port>
                <username>eq</username>
                <password>eq</password>
                <db>eq</db>
        </database>
</server>

I don't have a database set up yet. I am having problems installing mysql. I install it using the command "apt-get install mysql-server" but when I type "mysql -u root" to set up the root account, I get this error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)". How do I completely remove mysql-server and start again? Or is there another way to fix this?

I will work on login.ini after I have eqemu_config.xml configured and mysql working.

Thanks again for your help. I am looking forward to getting this running!

[pfyon]

sudo apt-get remove mysql-server

I remember getting that error with mysql when I set up my server too, will have to try to remember how I fixed it.

[Jster22]

Hi pfyon, I removed mysql and reinstalled but still get the same error. Please let me know if you remember how you got around this error.

Thanks.

[Jster22]

I wanted to post an update in case anyone else runs into this problem because I think I have found a solution.

I ran "sudo ln -s /etc/mysql/my.cnf /etc/my.cnf" because I think it was looking for /etc/my.cnf instead of /etc/mysql/my.cnf. This seems to have fixed that problem. When I ran mysql -u root again I got a new error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)". I fixed that by running "mysql --user=root -p" and entering a new password.

I think I have mysql set up correctly. I am going to work on sourcing my database. However, the guide says that the databasefile.sql should be in server/database but I don't have the database directory. I'm going to try and find it. Does my eqemu_config.xml look correct from a couple posts back?

Thank you.

[pfyon]

Ah yeah that was the problem.

You'll have to get a database for that. The most popular one is over at project eq (http://www.projecteq.net). You can download a recent release in the downloads section of the google code page (http://code.google.com/p/projecteqdb/) or check it out from the svn to get the most recent version (svn co http://projecteqdb.googlecode.com/svn/trunk/ ).

[Jster22]

Thanks for the info about the database pfyon. I checked out the code and believe I got it all sources correctly. I am just waiting on word if I have create my eqemu_config.xml file correctly from post 12?

On a side note, I sourced load_bots.sql and got some errors. Note sure if they need to be fixed since this source was optional.

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `botpetinventory`' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `botbuffs`' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$
DROP FUNCTION IF EXISTS `GetMobType` $$
CREATE FUNCTION `GetMobT' at line 1
ERROR 1193 (HY000): Unknown system variable 'Result'
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF (select count(*) from character_ where name = mobname) > 0 THEN
SET Res' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ELSEIF (select count(*) from bots where Name = mobname) > 0 THEN
SET Resul' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END IF' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RETURN Result' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END $$
DELIMITER' at line 1
ERROR 1305 (42000): FUNCTION eqdb.GetMobType does not exist

Thanks.

[Jster22]

I believe I have gone through all the steps to set up the server, but I can't get it to start. I don't know if I have set up eqemu_config.xml file correctly. I tried ./start and this is the output. Is this working correctly?

+ LNAME=zone
+ '[' '\1' = test ']'
+ P=/home/eqemulator/server
+ export LD_LIBRARY_PATH=:/home/eqemulator/server
+ LD_LIBRARY_PATH=:/home/eqemulator/server
+ mkdir -p logs
+ '[' '!' -e .lock-zones -a '!' -e .lock-world ']'
+ for f in 'logs/eqemu_*.log'
+ '[' logs/eqemu_debug_4267.log = logs/eqemu_commands_zone.log ']'
+ rm -f logs/eqemu_debug_4267.log
+ for f in 'logs/eqemu_*.log'
+ '[' logs/eqemu_debug_4316.log = logs/eqemu_commands_zone.log ']'
+ rm -f logs/eqemu_debug_4316.log
+ for f in 'logs/eqemu_*.log'
+ '[' logs/eqemu_debug_chatchannels.log = logs/eqemu_commands_zone.log ']'
+ rm -f logs/eqemu_debug_chatchannels.log
+ for f in 'logs/eqemu_*.log'
+ '[' logs/eqemu_debug_mail.log = logs/eqemu_commands_zone.log ']'
+ rm -f logs/eqemu_debug_mail.log
+ for f in 'logs/eqemu_*.log'
+ '[' logs/eqemu_debug_world.log = logs/eqemu_commands_zone.log ']'
+ rm -f logs/eqemu_debug_world.log
+ '[' '!' -e .lock-world ']'
+ touch .lock-world
+ '[' 1 ']'
+ ./persist_world
+ sleep 15
+ '[' '!' -e .lock-launcher ']'
+ touch .lock-launcher
+ '[' 1 ']'
+ ./eqlaunch zone
+ ./chatserver
+ '[' 1 ']'
+ ./mailserver

Thanks!