Trying to set up server

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

[Jster22]

I am still not able to get my server running. Looking in my server log files I keep seeing "Unable to load 'eqemu_config.xml': Failed to open file". Where does this file need to be located? Right now its in utils/defaults/. I'm not even sure I have it configured correctly. I posted it back in post 12 I think. Does it look right? Anything else I am missing to get this server started?

Thanks.

[Jster22]

Please help, I can't get this to work. I feel like I am talking to a wall now. I have completely wiped everything and started from scratch and still am stuck. Here is where I am at.

My directory structure:
home/eqemulator/projecteqemu
home/eqemulator/server
home/eqemulator/eqemumaps
home/eqemulator/projecteqdb
home/eqemulator/projecteqquests

I have ran make in projecteqemu/EQEmuServer/ and projecteqemu/EQEmuServer/EQEmuLoginServer folders successfully.

I have created and sourced my database successfully.

I modified eqemu_config.xml (as shown back in post 12). I moved it from projecteqemu/EQEmuServer/utils/defaults/ to projecteqemu/EQEmuServer/zone/

What am I missing?

In eqemulator/server i ran ./start I get the following output.

./start: line 11: ./EQEmuLoginServer: No such file or directory
+ LNAME=zone
+ '[' '' = 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 ']'
+ '[' '!' -e .lock-world ']'
+ '[' '!' -e .lock-launcher ']'
+ '[' 1 ']'
+ ./chatserver
./start: line 73: ./chatserver: No such file or directory
+ '[' 1 ']'
+ ./mailserver
./start: line 78: ./mailserver: No such file or directory

I have checked eqemulator/server/logs and all logs are empty.

Please, any help? Thanks!

[Jster22]

I have moved spells_us.txt into home/eqemulator/server. I don't have a copy of spells_en.txt. Could someone send that to me please?

Any suggestions about my last post?

Thanks.

[Jster22]

bump
Still looking for help. Thanks.

[trevius]

You don't really need the spell files anymore. It doesn't hurt to have them there, but spells are loaded from the database now.

You will need to move your config file directly into your server folder, NOT zone or any other folder.

In your config file, you can probably just comment these lines out or just remove them:

                <address>(whatismyip.com)</address>
                <localaddress>(whatismyip.com)</localaddress>

And you are going to need to create symbolic links for all of your files. That is why you are getting errors for the EQEmuLoginServer, and the mail and chat servers. In your case, you want to do something like this:

cd /home/eqemulator/server
ln -s ../projecteqemu/EQEmuServer/utils/defaults/* .
ln -s ../projecteqemu/EQEmuServer/utils/patch_* .
ln -s ../projecteqemu/EQEmuServer/utils/cleanipc
ln -s ../projecteqemu/EQEmuServer/world/world
ln -s ../projecteqemu/EQEmuServer/zone/zone
ln -s ../projecteqemu/EQEmuServer/EMuShareMem/libEMuShareMem.so
ln -s ../projecteqemu/EQEmuServer/eqlaunch/eqlaunch
ln -s ../projecteqemu/EQEmuServer/EQEmuLoginServer/EQEmuLoginServer
ln -s ../projecteqemu/EQEmuServer/ucs/ucs
ln -s ../projecteqemu/EQEmuServer/mailserver/mailserver
ln -s ../projecteqemu/EQEmuServer/chatserver/chatserver

This is basically like creating shortcuts to all of these files, so you can leave them in your source folder and update them or whatever, and always have access to them right from your server folder for scripts and starting the server.

[Jster22]

Hi trevius. Thank you for your reply.

I made the changes you suggested and ran ./start and received the following errors.

user@comp:/home/eqemulator/server$ sudo ./start
./start: line 11: ../projecteqemu/EQEmuServer/EQEmuLoginServer: is a directory
+ LNAME=zone
+ '[' '' = 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 ']'
+ '[' '!' -e .lock-world ']'
+ '[' '!' -e .lock-launcher ']'
+ '[' 1 ']'
+ ../projecteqemu/EQEmuServer/chatserver
./start: line 73: ../projecteqemu/EQEmuServer/chatserver: is a directory
+ '[' 1 ']'
+ ../projecteqemu/EQEmuServer/mailserver
./start: line 78: ../projecteqemu/EQEmuServer/mailserver: is a directory

What is the error "is a directory"? Isn't it supposed to point to the directory?

The original lines looked like "./EQEmuLoginServer" and "./chatserver" etc. But they gave the error "No such file or directory" so I modified my start script to point to the folder locations.

All of my server logs are empty.

Thanks.