EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Tutorials/Howto's (https://www.eqemulator.org/forums/forumdisplay.php?f=619)
-   -   HOWTO: Setup an EQEmu server as of 06/01/2004 (https://www.eqemulator.org/forums/showthread.php?t=12337)

bluejam 04-20-2004 12:05 AM

first of all dowload this, right-click > save target as > copy to your eqemu folder

eqtime.cfg

at least that should fix those errors at the beginning.

tearnevery1doown 04-20-2004 07:31 AM

k added that time config file also on my zones it says shit like this
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.6
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 160 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 192.168.1.100:9000


when i boot it up i dunno if that matters just posting that too

Cripp 04-20-2004 07:44 AM

you need to add those commands to the addon.ini file.

mikenune 04-20-2004 08:21 AM

All those errors mean is that those commands (help, version, serversidename, loc, flag, and si) don't have a required level to be used and it's defaulting the level to "everyone who's logged in". This is only a problem if you are running a Legit, Custom-Legit, or Semi-Legit server and don't want people to use commands like si or flag. Normally I just ignore them but if you want, you can add the following lines to the bottom of your 'addon.ini' file to get rid of those errors (note this won't actually change who can/cannot use them, it will just remove the error message).

addon.ini
Code:

!help=0
!version=0
!serversidename=0
!loc=0
!flag=0
!si=0


tearnevery1doown 04-20-2004 09:06 AM

any idea why people get disconnected after creating a character.. and i cant even get to character creation eq just starts responding

Valex 04-21-2004 06:48 AM

MY SQL LINK DOESNT WORK
 
The mysql 4.0 link DOES NOT WORK:)

erb2k 04-23-2004 07:08 PM

Hey, Got an error /grump
 
Hello Running world.exe right now. Everything goes fine up till I get to eq.variables and then I get the following error.

Quote:

Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables' doesn't exist'
Know why I'm getting this? I am supposed to have everything I need. /sigh :( talk about suckage :-) Hope you can help me out :-)

Erb2k

Force 04-25-2004 01:30 AM

all my servers are runnign perfectly but... how do i play? lol

NarutoLegacy 04-25-2004 02:19 AM

All of your servers? Are you trying to play or trying to run a server?

oxiroxt 04-25-2004 10:08 PM

Re: HOWTO: Setup an EQEmu server as of 04/23/04
 
Quote:

Originally Posted by Jezebell
(***NOTE*** sourcing MW055_alpha1.sql is OPTIONAL, if you source Alpha1 then Alpha_02 it will take hours to source in because of duplicate entries, but you will have a more complete database....if you do not want to wait hours for it to source only source in Alpha_02!!!)

So I went for the complete db... but...
You should have warned that everytime it finds a duplicate entry it makes the computer speaker BEEP!!!! :evil:
It's been beeping all the time now for 30mins. and I can feel my head is about to explode!!! :shock: :x :roll: :cry: :oops: (there are just not enough emoticons to represent how i feel right now)
Im going to the most apart room from this one now...
I was about to pull the speaker cord few time ago, but reconsidered after noticing the reset wire next to it.
And, NO, my comp. speaker control doesnt work.

Apart from that... Thank you for the tutorial. I've spent the whole night trying to get the server working, but seems that the guide on the main page is a lil outdated. Hope this one works. Thanks. :)

valaerosilantix 04-26-2004 12:50 AM

lol I found that out too.. took me 12 hours to finish... I had to disconect speaker :/

oxiroxt 04-26-2004 04:47 AM

Quote:

Originally Posted by valaerosilantix
lol I found that out too.. took me 12 hours to finish... I had to disconect speaker :/

Thanks for the telling the time it took you. Ive decided to finally pull out the cord. Its been like 6 hours now and still beeeping.
Done. Wow, what a silence. Its like relaxing. phew :D

govtcheeze 04-26-2004 05:36 AM

from the DOS prompt browse to mysql\bin and type:

mysql -f [database name] < [file name to source]

FOr instance, mine looked like the following:

Code:

C:\mysql\bin> mysql -f eq<tcsmw_055_alpha2.sql
No beeping and only errors are output. Thanks to someone else in another thread for pointing this out.

mikenune 04-26-2004 08:23 AM

erb2k, it looks like you don't have a complete database. As long as you don't have any custom items/spawns/loot tables/etc. then I'd suggest deleting your old eq DB and resourcing using this one. I've heard mixed reviews as to whether or not it works on a 5.7 server, but it should work fine on both versions 5.5 and 5.6. Just follow the directions in the packaged REATME.TXT file and you should be fine.

CK-Jhev 04-30-2004 04:53 AM

Quote:

Download TCMyWorld's Alpha 1 database and TCMyWorld's Alpha 2 database
I tried downloading these, and I couldn't get either one. Does anyone know if the links still work, or where I can get them? Are they even necessary? Thanks!

Aniron 05-01-2004 03:14 PM

i wonder why it takes everyone so long to source both of those. It only took me about 30 minutes total for the two. Any idea's as to the varying difference in time (running a p4, 2.0 ghz)

jamescr 05-05-2004 06:49 AM

Help
 
When I run the boot5zones I get

C;\mysql\eqemu>REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

C:\mysql\eqemu>
C:\mysql\eqemu>REM: If you still get errors try using localhost instead of 127.0.0.1

C:\mysql\eqemu>
C:\mysql\eqemu>REM:-----------Start------------
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.
Cannot find file 'zone' <or one of its components>. Check to ensure the path and filename are correct and that all required libraries are available.

mikenune 05-05-2004 07:35 AM

Looks like you need to rename ZoneDebug.exe to Zone.exe. Might have to do the same for World.exe.

This is assuming that C:\mysql\eqemu is the directory that you have your EQEMu server installed on. Is this where you have all your EQEMu stuff (including the cfg and other directories) at?

jamescr 05-05-2004 08:11 AM

help
 
they are already changed, still getting same error

jamescr 05-05-2004 09:58 AM

Ok
 
Ok my server is officially up, but it's locked heh, how do I unlock it? =)

masteryoda 05-05-2004 02:14 PM

Edit your loginserver.ini file, if you haven't already to read locked=false

lockecole 05-06-2004 05:51 AM

source
 
not sure why it takes so long. on my new PC, amd64 3200+ 2.0Ghz it took all of about 2 minutes to source both. also on my AMD duron 800mhz machine only took about 20 min to source both. 16 hours? what are you running?

w1ntermute 05-07-2004 07:30 AM

lol im sourcing all the DBs on an old sparcII.. i'll race you!

Kikaro 05-21-2004 11:29 PM

Great guide so far im doing good with it. However,

TCMyWorld's Alpha 2 database

The link you provided has a corrupt file. Is there anywhere else to get this? Im searching for it and I just cant find it.

m0oni9 05-22-2004 06:19 AM

Telling mysql client to be silent, and to turn off beeping, can speed things up a lot.

mysql --silent --no-beep

Bumbee 05-26-2004 08:26 PM

Having trouble.
 
Ok, I used to host my server never quite had this problem...

I'm doing everything the walkthrough is saying, to the T. When I do source MW_057DR2_alpha_1.sql; everything is fine but one Beep at the end...
I then run source loot_update.sql; loaded with beeps, but we'll move on, source npc_types_update.sql; goes into an infinite loop it seems, I have a decent comp. (AMD athlon 3200+ 2.0 ghz). I let it run for hours on end, just keeps going, no beeps, or anything. so after too long I quit it, thought I check to see if world works, fixed db.ini, loginserver.ini boot5zones and all, but my server is still locked anyway... in Login server I have it to false... maybe some of the files in new walkthrough are corrupt? any info would be much appreciated I wanna get my server back up :cry:

Jezebell 05-27-2004 01:42 AM

Its normal for it to take hours and hours sourcing those updates, you just have to let it run, do it before you go to bed or something.

Bumbee 05-27-2004 07:08 PM

Ok, it's done. one last problem.
 
I have no idea why... but all my NPC guild trainers (original ones) arent GM's... they're just there, is there a way I can fix them? I sourced everything and they're messed up, heh, sorry for bothering again. :oops:

cabtiz 05-28-2004 04:33 AM

this will help you out with that.. keep in mind though that this will only work with the NPC's in the database you are using that have guildmast in their name

http://www.eqemulator.net/forums/viewtopic.php?t=15086

antithott 05-29-2004 10:45 PM

Hmm so ok i have a problem, I Have everything setup right, no erros in either World, or boot5zone, they load up fine, i have my external and internal ip put in, and i have put in the eqemu login info.

But the problem comes when my server dont show up on the list? Any idea what could cause this, or info on how i put up a private login setting

SirThomasIV 06-01-2004 04:03 PM

this is making NO sense! I used to be able to set this shit up all the time. I followed the directions step by step from numerous forum posts (mostly this one) numerous times. But when I try to load up world.exe it immediately closes. I noticed it says something so i held down enter to keep opening it and then took a screenshot. "[Database] block not found in DB.INI. Read README.TXT!"
here is what my db.ini says
[Database]
host=127.0.0.1
user=***********
password=********
database=eq
compression=off
^- with the normal username and pass of course for mysql
ok so yea, the db.ini is correct right? ok so I thought maybe it has to deal with the database on mysql, tried reinstalling mysql and doing the sources over again... nope, doesn't work.
Any help much appreciated.

Jezebell 06-01-2004 04:10 PM

make sure you don't have a space after [Database]

SirThomasIV 06-01-2004 04:12 PM

hehe, thanks dude. yea i was just looking around the forum and found out that was my problem for my eqhost file as well and came back here and yea, fixed the db.ini file too

SirThomasIV 06-01-2004 04:47 PM

moved as its own post

Merq 06-08-2004 08:41 PM

I can't get past the damn "Logging in to server. Please wait..." screen. Is it because I patched?

tkd1991a 06-12-2004 03:02 AM

I might be a retard
 
ok i'm trying to just get started with this server set up, when I make the first text file MySQL.bat it just stays as a text file and nothing runs when I hit return etc.... help please

yes i'm retarded

Darkdrizzt 06-12-2004 02:33 PM

my servers up and running but when i click boot5zones they come up and dissapear really fast

bwickes 06-12-2004 07:15 PM

you need a newer compiled set

DaCap 06-12-2004 11:34 PM

do i have to compile dr4 myself?
 
i currently have
CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3

i fallowed everything and im getting this when i try to connect

1515870 New client from ip: 192.168.0.7 port: 1160
[Error] Expecting OP_SendLoginInfo, got 250
Removing client from ip:192.168.0.7 port:1160

any ideas?

and is there any precompiled dr4 binaries available?

pitbull23701 06-20-2004 02:38 AM

hmm ive done everything as said to be. checked double checked and triple checked even went over every forum threads i could find yet i still get this when i run world.exe (and when i check if its up it says locked)
C:\EqEmu>world
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR3
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Breaking linux compiles....
TCP listening on: 207.68.51.151:9000
World server listening on: 207.68.51.151:9000
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#2006: MySQL server has gone
away'
Connected to LoginServer: eqemulator.net:5995
Got signal 2

C:\EqEmu>


All times are GMT -4. The time now is 01:18 PM.

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