ya
 

umm after it connects to worldserver nothing happens wat do i do????

Error #1017 , i tried everything i read on this thread and im still stumped

OK , i seemd to fix it, here is what i did for further reference.....

When i turned off my Firewall, my external isp was changed. Doing so i had to go back and get my new changed isp with no firewalls and redid the db.ini,loginserver.ini,and boot5zones.bat

Guys....dont ask for support at the end of a guide your not gonna get much help. Make your own topic.

what eq.sql?

ehhhh, db.sql i meant, fixed that.

How long about will the errors keep going? cause i get 1136 like forever...

ERROR 1136: Column count doesn't match value count at row 1 X1000 and still going =P

hm, things are a lot more different than I thought...this could take a while :(

Server Locked (
 

Ok i scrolled through the posts and i don't think anyone has asked anything about this yet. Just to let you know i am somewhat new to eqemu. Anyway, i did all that was said here and started my server up. Server shows up in the list of servers but it is LOCKED. How do i get it unlocked pls anyone?

I am sure this is something small i have overlooked.

btw my loginserver.ini:

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport2=5997
loginport3=5997
worldname=[test] ramuhs_server
worldaddress=68.1.210.103
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[ChatChannelServer]
ChatChannelServer=192.168.1.50

I'm not sure this is needed at all.. no-one has access to the (working) 'chat channel' servers. If you get an error saying something about this, ignore it.

ok I been getting this duplicate error since 6 hours ago!, is this how it suppose to take to source the alpha 1 file!?

Getting same problem as above, with either of the two files. :/

i just exited, i cant wait for 12 hours to source a file =\

When 0.5.5 DR1 first came out, this error was causing world.exe to not connect to Login Server. Not sure if we still have this problem but thats why its in there.

Server LOCKED
 

So does anyone know what i am doing wrong here? why my server is locked? any help would be greatly apreciated. =)

For loosenut, i am not sure if this is why it is taking so long but try running that the doing the "source db.sql" and all the other ones without mysql running. It seemed to help when i did it, but i am not positive on that, just worth a shot.

I see the two world databases you need to source have been removed from the guide, I assume they're incompatible with 5.5 or something?

No, they are just not necessary to get a server running and people are complaining to much about having to wait for them to source.

Well several hours of the same error and the PC speaker beeping constantly kinda gives people the idea that it's not working :) And since no-one has given a straight answer as to how long it usually takes, and if that's normal, you'll continue to get these silly questions.

when i slept last night.. i wasnt sourcing any files.. but i still heard the beeping terror lol

This is annoying, I've set up EQEmu in the past many times, having taken a break from it, I come back and I'm getting all the problems I've read about.

Re-following your guide and making the necessary adjustments for Minilogin, World.exe crashes as soon as I create a character, on subsequent re-login World.exe finds my 'bogus' character and deletes it. Also, I'm getting the "Error: Could not load item data. But ignoring." stuff which, having searched the forums, is apparently because the db.sql is incompatible.

I can paste in a full World.exe output if necessary. Any ideas?

BTW I'm posting here and not making a new thread because it seems pertinent to the topic.

Answering my own question: Sourcing db.sql is the problem, if you skip that step and source MW055_alpha_02.sql directly after use eq; it works fine, takes a couple of minutes but everything works perfectly. Something must be wrong with the db.sql included with 5.5

Actually if you only source in Alpha_02 then you will be missing the Doors table update, thats the only reason I said to source the db.sql, but I see your point, i will try to find the Doors update and post it in the Tutorial. Btw, if you source the files in MySQL-Front it only takes 2.5 hours and there is no beeping :) I have done it uncountable times.

This link seems to be broken..can we get a new one please?

I wasn't there when it stopped (I was at work), but on my system which has a fast processor (AMD XP 3000), lotsa RAM (1GB), and fast a Hard Drive (a pair of 10,000RPM ATA100 8MB cache drives in RAID 0), and it took me more than 14 hours. My guess is somewhere around 16 hours or so. And yes, it continues beeping ALL THROUGH THE NIGHT!!! All for only about 5k new records. . .

Also, Since I have access to web space, I'm gonna go ahead and upload my MySQL DB dump and post a link to it when it's done.

I'm updating my DB with the "npc_types_update.sql" file right now. I'll have the dump out as soon as it's done! :)

Here it is! Careful though, it's a little over 5 MB.

You'll need to right-click on the link and choose "save as. . ." since this web server knows how to read GZipped files!

http://www.raskii.net/eqemu/eqemu055.sql.gz

The only thing NOT in here (that I'm aware of at least) are usernames and the like. :)

I posted this in another thread, but if you run mysql with the -b switch, it will not beep on errer. ie:

I turned off beeping, and alpha2 ran in under a few minutes - done.

Cant get this to work.. i right click and choose save-as, and it just poofs.. nothing happens. If i click on it as a normal link, i get a completely white webpage..

Dunno what i am doing wrong..

Btw.. i did follow the guide and i guess it took somewhere around 16-18 hours to do :(.. anyway.. is there no spawns in there? tried some "regular" spots like pofire, pov, bot.. all empty.. supposed to be this way? or?

Error UsernamePass for Mysql?
 

Hey im having a problem with this:


When i started mysql server, it skiped my username pass that i was going to create.

And now when i run boot5zones.bat, it brings up the 6 windows with all the same error:....

:?

[Error] Loading npcs FAILED!
===============================
Runtime errors:

MySQL Error #1405 or $2001 means your mysql server rejected the username and password you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id=1

Hit any key to exit



.... Well The website link does not work and i am not sure where i can change the username and pass for this...

Also, Which username pass do i use? A new one? the EQemu server username pass? and which one is causing the error?
:?: :?: :?: :?:

Please check this out and tell me what im doing wrong?
http://www.eqemulator.net/forums/vie...?p=76810#76810
KeepHopeAlive

I can not get doorupdate to source I have folllowed your guide to the T got all running but gett 1017 on world select .In another post I was told to change name to source.sql done that and still wont source any help .Before i go brain dead fighting it :shock:

If you can't find it it's either (a) Not in your mysql\bin folder (same folder as mysql.exe) or (b) You're typing the wrong filename.

Rename it to "a.sql" (can't be more simple than that), copy it to C:\mysql\bin (or whatever you have), than Strat => Run => cmd (Check to see it's pointing to bin directory - if not cd to it) and type in this into the mysql window:

mysql -u root -b eq
source a.sql;
exit;

If you still cant get this to work download Mysql front and right click on your EQ database, choose Import => From file and then source it that way.

Lootdrop Update
 

How come you mention downloading the lootdrop update, but not sourcing the .sql files into the eq database as a step?

Just curious.

its optional

well after reading every post that i could i have finally figured the problem out. when sourcing in the db.sql it moved the directory to the mysql directory when i copied the data and moved it to the db directory everything worked. hope that this helps someone out there.

i cant find winmysqladmin.exe in my c:/mysql/bin file
 

i cant find winmysqladmin.exe

Re: i cant find winmysqladmin.exe in my c:/mysql/bin file
 

It should be in C:\mysql\bin

C:\mysql\bin

sorry put slashes wrong way
 

i ment to put them the other way but i still cant find it

Assuming you downloaded and installed mysql ( http://dev.mysql.com/downloads/mysql/4.0.html )

You could do start/run/cmd

then type

cd \
dir winmysqladmin.exe /s

That will search all directories on your C: drive and show you where it is installed.

hi
 

Hello, I followed your wonderfull walkthrough and found it very easy to get along with and only had a few errors which I think i worked out... I was having a problem with a 1017 error but i think i fixed that somehow.. now when i try to login to my server everquest stops responding.. this is my world.exe thing: [Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Liberating a country that despises us...
TCP listening on: 68.101.150.85:9000
World server listening on: 68.101.150.85:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997
35360 New TCP connection: 192.168.1.100:1862
35391 New TCP connection: 192.168.1.100:1863
New zoneserver: #1 192.168.1.100:1863
New zoneserver: #2 192.168.1.100:1862
35438 New TCP connection: 192.168.1.100:1864
35438 New TCP connection: 192.168.1.100:1865
New zoneserver: #3 192.168.1.100:1865
New zoneserver: #4 192.168.1.100:1864
Zoneserver SetConnectInfo: 192.168.1.100:1862: 68.101.150.85:7995
Zoneserver SetConnectInfo: 192.168.1.100:1863: 68.101.150.85:7997
35469 New TCP connection: 192.168.1.100:1866
New zoneserver: #5 192.168.1.100:1866
Zoneserver SetConnectInfo: 192.168.1.100:1864: 68.101.150.85:7999
Zoneserver SetConnectInfo: 192.168.1.100:1865: 68.101.150.85:7996
Zoneserver SetConnectInfo: 192.168.1.100:1866: 68.101.150.85:7998
83469 New client from ip: 192.168.1.1 port: 1869
Account Attempting to be created:band1t 0
Logged in: FirstLogin LS#52681: band1t
Client disconnected
Removing client from ip:192.168.1.1 port:1869
207.36.180.194:5997: TCPConnection::RecvData(): Error: 10054
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:
10060'
Connected to LoginServer: eqlogin3.eqemulator.net:5997
332422 New client from ip: 192.168.1.1 port: 1876
Logged in: FirstLogin LS#52681: band1t
Client disconnected
Removing client from ip:192.168.1.1 port:1876
207.36.180.194:5997: TCPConnection::RecvData(): Connection timeout
Connected to LoginServer: eqlogin3.eqemulator.net:5997
711125 New client from ip: 192.168.1.1 port: 1150
Logged in: FirstLogin LS#52681: band1t
Client disconnected
Removing client from ip:192.168.1.1 port:1150

..... I have all the ports listed in the router tutorial open and basicaly i opened any port i saw the program listening on as a precaution cos im stupid, uhm if you have any ideas why eq stops responding when i try to login to my server id appreciate it. i tried on 2 computers locally that are on my network. also my server name is bloody poway if anyone else wants to try to like get on it?