The solution to your problems

[Lurker_005]

Perl Quests for 0.5.3+ (http://www.eqemulator.net/forums/viewtopic.php?t=12020)

Outdatad!! the rest hasn't been updated in quite a while, but may still be useful.

Yes that title is meant to get the attention of everyone having trouble :P

General notes for people only wanting to play on an EQEmu server:
Read the Everyone should read section below
Try patching to EQ Live, then using EQEmu patcher. If you have problems, or are unsure what to do, get on IRC and check the eqemu channel topic, then politely ask for help if it isn't covered in the topic.

Everyone should read the current readme.html (http://eqemu.sourceforge.net/shawn319/documents/readme.html) and/or the Guide.htm (http://www.eqemu.net/Guide.htm) and the FAQ (http://eqemu.sourceforge.net/shawn319/documents/faq.html) and the new FAQ Forum (http://forums.eqemu.net/viewforum.php?f=26) If you are overwelmed by the readme, you can try this minilogin server setup walkthru (http://forums.eqemu.net/viewtopic.php?t=2937). These and several other helpful things can be found in the Tutorials and Howtos (http://forums.eqemu.net/viewforum.php?f=21) Forum.


EQEmu 0.4.3 is the current release. Get it here. (http://sourceforge.net/project/showfiles.php?group_id=41381) There are also 0.4.4 Developer Release1 copies posted on the forums For Items, Mobs, ect, see Databases below. Don't try using an older version of the Emu. There seems to be a problem with some servers where you get booted at the character name aproval. It is believed to be related to the upload speed (http://forums.eqemu.net/viewtopic.php?t=5156) of the servers internet connection. I believe some still have this problem, and FYI it has been tied to the packet that sends the list of guilds being large. Just try a different server with more bandwidth.

The EQEmu Patcher:
First if you want to also play on Sony's server, make a copy of your EQ directory, 1 for EQ live, and 1 for the EQEmu. Download EQEmuPatcher.exe (http://prdownloads.sourceforge.net/eqemu/EQEmuPatcher.exe?download) and run it. Install the files to the SAME directory as your EQEmu copy of EQ. Not a sub directory, make sure this is right. Next run everquest.exe to patch to the current EQ Live files. Then run Patche.exe to patch to the older EQ files that work with the EQEmu. This only needs to be done ONCE each time the EQEmu is updated to use newer files. In other words only patch when EQEmu stops working, or your told to. After you have patched, use EQW.exe to start EQ for EQEmu (or use "eqgame.exe patchme" as described in the readme) Make sure EQW points to your EQEmu copy of EQ.

If your not running XP chances are you need to install mdac_typ.exe (http://www.eqemu.net/patcher/mdac_typ.exe) for the patcher to work (XP has the latest version) Some other things reported to have caused the errors when running the patcher are Norton antivirus, XP's built in firewall, 3rd party firewalls. Chances are you will need to disable these to run the patcher.

Release specific notes for running a server:
Get a database to add items or spawns, the release only has the DB structure. The 4.3 release is not compatable with older DB's but there are some scripts in the worldbuilder forum (http://forums.eqemu.net/viewtopic.php?t=6349) that will mostly convert an existing 4.2 DB to work with 4.3

General notes for running a server:
If your running minilogin, you probably need to run world.exe adduser eqemu eqemu 200 from the command line to create the eqemu user account. Firewalls Cause problems for the EQEmu if they aren't setup right. This includes XP's built in firewall, broadband routers, and possibly zonealarm too. Ports that need to be open to allow other users to login are 7995 thru 7999 and 9000. Those ports should point to your EQEmu servers LAN IP address. Read the documentation on your product to figure out how to set this up.




After reading the readme and FAQ, people wishing to only play on other people's server only need 3 things. Download the EQEmu Patcher (http://prdownloads.sourceforge.net/eqemu/EQEmuPatcher.exe?download) also read The EQ Patcher section above, EQW (http://forums.eqemu.net/download.php?id=445), and your login and password for this bulitin board (http://forums.eqemu.net/profile.php?mode=register). Here (http://forums.eqemu.net/viewtopic.php?t=8) is a step by step client setup guide of the above.

Note: The emu is a command line server, and still VERY early in development. That means it requires a little skill and knowledge to setup and run, and the WILL be bugs! If the readme isn't enough to get you started, see the next paragraph.

Please take some time to learn about the programs you are using if you have ANY trouble. This includes windows, mysql, the dos command line, and networking. There are MANY web pages with info. The mysql help files are probably on your hard drive if you installed mysql, and there is a lot of help on the dos command line built into windows. I would guess over half of the questions asked aren't about EQEmu, read the other programs docs too!

Search (http://forums.eqemu.net/search.php?s=) for other posts dealing with similar problems.

Read the Sticky posts at the beginning of the forum, like this one (http://forums.eqemu.net/viewtopic.php?t=1736) <- makes it a LOT easier to solve the problem. Also useing this template (http://forums.eqemu.net/viewtopic.php?t=3853) when asking for help will improve responses to your request. If you don't bother to post you configs and emu screens, then I have an error, helpppppp!!! tells us absolutly nothing. Post ALL your config files, AND the text from your world and zone windows. **** out your passwords, and you might as well leave the IP's, they are public anyhow.

Databases for the emu can be found in the World Builder Forum (http://forums.eqemu.net/viewforum.php?f=19), be sure to get a DB for the version of the emu your running. A Popular one is the DBAddon I generate, It can be found with the EQEmu release files on Sourceforge (http://sourceforge.net/project/showfiles.php?group_id=41381)

Various other tools and support programs are in 3rd Party Tools (http://forums.eqemu.net/viewforum.php?f=10) Help setting up the publiclogin (nolonger functional and unsupported) server is here (http://forums.eqemu.net/viewtopic.php?t=1471) Note, there is not a current publiclogin released.

Regarding fix/release dates: If your gonna ask about any ETA on this board, just pretend you did, and someone replied "when it is done". :P

The Dev's know many people are awating the release/fix of [insert name here] and are working on it. So far the longest time some part of the emu project wasn't working has been about 2 weeks due to a verant patch (ok the zone thing took 2 months :( ). Of course this can be avoided if you follow the suggestion to make a backup of your EQ files (as well as your emu files)

This does not really have any new information, it just puts lots of it in one place.

[Symarra]

Now thats a Cluster Uck of information!

Nice work Lurk!

[bennu]

can't sign up for a login for some reason. it keeps timing out. is it working correctly?

[Lurker_005]

Let me know if you think I should update, change, add anything to this post. I am trying to keep it as a single point of referance for the most asked stuff. It isn't intended to contain the information itself, just point you to the right file, post, readme or web page.

[Baron Sprite]

Mind if I stick all this at the bottom on my post in a quote thing? ;)

[stormgod]

doing the same baron ;)

[Baron Sprite]

I ment on the before you ask for help post.

[Lurker_005]

Baron and Stormgod, by all means. Anything to get people up to speed. :D

[Baron Sprite]

Edited it a bit, gonna add a link to your post in my sig tho :D

[Shawn319]

I dont know how in the world this was left un-stuck. its stuck now :)

also added some things to the end of my sig :)

[Baron Sprite]

I should make mine much more menacing... Need Help? is kind of a question rather then an order ;)

[Jcomer]

Wow,

That helped me a lot, fixed almost every problem.

[Lurker_005]

Well if it didn't cover something, I'm open to suggestions.

[ellis]

Using database 'eq' at localhost
Loading zone names, items & NPCs...Done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...done.
Loading faction data...done.
Unable to get host name. Error: 11001InitWorldServer failed
Entering sleep mode

I have a normal modem, nothing special.
I want to run a standalone, me only server. Please advise.

I have made all patches even June 5th patch. - logged in to eqemu servers once with no items and no commands available. also nothing had items on the spawns.

_Please help.

[Shawn319]

did you have world.exe running first?

and.. if you have all the patches you cannot play because EQemu does not work with the june 5th, 6th or 12th patch.

[ellis]

Got all of it working now. Except for everquest... lol

Guess I need to wait for new version of EQEmu...

Thank You

[LordDrumheller]

I am having the exact same problem Ellis is (Was?)... You say in your post that the emulator will not work with the newest patch, however, a mere 9 days ago, you said, and I quote, "*corrects*.. 0.3.4 does work with latest patch but is it buggy. ".... Any pointer? lol... Kinda hard for me to get an earlier version of EQ, seeing as how I had to reinstall from a crash... So I was glad to see that the new patch will work... But for me - it doesnt =(

[Lurker_005]

<deleted, see end of thread for status>

[Lurker_005]

Dang, over 8000 views, guess someone is actually reading this thread :D

[nogard]

well I found the readme and step by step guide awesome as they are very explicit, but I,ve got stucked at step four of the part two in the readme...

Problem isthat I've downloaded the stable version of mysql and cant seem to have it working right, fact is that create a database doesn't appear at all on my menu, all I get is -flush options.

would anyone have the answer to this? I've browsed the board and haven't come up on something aobut it...

[Lurker_005]

The best thing to do is run mysql.exe and enter the commands to create a DB manually. Learning some basic mysql commands is good anyhow.

so start mysql.exe then:

mysql> create database eq;
mysql> exit;

and your done. See the mysql readme for what that means and more info if you want to do something different.

[Elkezix]

Is anyone else having this problem:

When I open MySQL, under the Environment tab in the MyODBC box it says

Not Found

Driver Version 03.51
Driver C:\WINDOWS\System32\myodbc3.dll
API Level 2
Setup C:\WINDOWS\System32\myodbc3.dll
SQL Level 1

Also, the Enviroment (Yeah, it's spelled different than in the tab for some reason) box I can't click any of the stuff to change it. And then under the Database tab in the Databases box when I right click I get the Flush options but not create database or anything... I need help, lots of it

[Trumpcard]

AHHHHH

AHHHHHHHH


ARRRRRRGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHHHHHHHH HH

[lunatic987]

I am having the exact same problem, Elkezix

No matter what I do I keep getting the 10017 error. I am trying the minilogin and can't get it to work.

I've tried everything including searching the forum. and nothing.

I even manually updated the database for eqemu.


But I can log into the public servers. But I want to do it on my own. lol.

[Lurker_005]

To create the database, see my above post.

The envoroment in winmysqladmin is display only, see the my.ini edit tab for what you can change. myODBC is not required to run a server, the emu links directly to mySQL myODBC is used by other utilities though, and can be downloaded seperatly from the www.mysql.org

Hey check it, would it be possible... to come out with an emulator version... that worked just off a fresh install? Is that at all possible?

Also i am still testing out my beta update server, i seem to be able to FORCE the logged in computer to download MY version of EQ files. Here is why i am doing this. Lets say that 100 users told 10 friends each about eqemu. Thats 1000 CURRENT & UP TO DATE SoE EQ players that wish to play eq but SoE keeps updating their software. Now what do they need to play on my EQ server??? Well my beta sends them the SAME EXACT signature that the Sony servers send users to tell them wether or not they need to update. Now i have it set so that they will receive the string, and their computer automatically downloads from me. Only 2 problems.. if your a dev and know anything about what im not doing correctly please reply in post....

Symptom:
1. I cannot figure out where in the string sony tells the computer that they are CURRENT, i have only found where they say you are NOT CURRENT.

Q. is there a way that i can set up my update server to automatically determine what setup they have, VIA having my server execute a command on the user end that will send my Server end a file that has the current listings???

2. Whenever a fresh install is made using PoP disc ONLY, i get a weird 2nd packet that is requested from the users end that my server does not have when they try to update off my update server.

Q. What is this packet and why does it not show up in Everquest (original or trillogy)?

My Setup :
Network = hp 64-port fibre channel director switch
Server = Dell PowerEdge 2600
Update Server = Dell Optiplex GX240
Workstations = Dell Precision Workstation 450's (42)
OS = Win XP Professional

[Lurker_005]

The original post has been updated for the EQEmu 4.1 release.

[lunatic987]

I got the eqemu account to actually login.

I had to go into the console mysql.exe and type the following, since the world adduser no longer works at this time.
use eq

then

INSERT INTO account SET name='eqemu', password='eqemu', status 200,lsaccount_id=0;


Now I can get in, but no items, npc's, or anything.... But the doors work!!! lol.

[Elkezix]

Huh? What console? X_X My mysql still says "Not Found" and I can't do anything...

[lunatic987]

ignore the winmysqladmin's message.

if you haven't created the database yet, do the following. If you have, skip to the next part.

make sure you have db.sql in the bin folder first.

open a command prompt (command for win9x, cmd for winnt,2k,xp)

go to the bin folder if it's not already open. (I'm assuming it's in c:\mysql since that is the default)

cd\mysql\bin
mysqladmin create eq


then open mysql.exe and do the following


use eq
source db.sql
INSERT INTO account SET name='eqemu', password='eqemu', status 200,lsaccount_id=0;


then you can login with eqemu/eqemu through everquest with the emu open.ignore the winmysqladmin's message.

[Elkezix]

I did what you said, and my server still just says "Locked", the MySQLAdmin still says "Not Found", and when I try to load up EQEmu Admin Tool it freezes for a while then finally loads with the error message:

Exception: Can't connect to MySQL server on '*my IP adress here*' (10060)
The admin tool wasn't able to connect to
database "eq" at host *my IP address here*.
Please go to the Preferences dialog and set the
username, password, database, and host values.

There's an OK button, and when I click that the tool closes down.

I'm confused...

Oh yeah, I opened the FQADMIN.INI to see if I set everything, and it all looks right but I dunno what this one thing is for:
EQPATH (I set it to the EQ folder)
MAPSPATH (I didn't change it, dunno where it is supose to go)

[singalots]

Well.... I need Help... Is there a Chat thing besides Mirc thing? like Live chat so i can talk to someone? maybe on Yahoo?

[Lurker_005]

Mirc is just a popular program to access the IRC network. and it is by far your best bet to chat live with someone aobut problems.

Log on, ask and be patient. If you don't get a response try agin in 10 minutes.

[loki4687]

I got past login, then i got a "COULD'NT' message: as follows:

"COULD'NT LOAD DLL (null), error = 0" or some along those lines...

Did I miss a piece of something? because when i was patching for the first time, it says "missing file: blah blah blah"

[Lurker_005]

It sure sounds like you messed up patching somewhere.

The EQEmu patcher should be installed in your EQ dir, not in a subdirectory like might be suggested by the default path when setting it up.

[garbash]

I'm getting an SQL Error message. Here it is. Anyone else got this before? Using Windows2000 sp2 with the newest mysql release.
----------------------------------------------------------------------------------
Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.3
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.3
Loading Variables, zone names & items...
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1146: Table 'eq.variables' doesn't exist
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1146: Table '
eq.zone' doesn't exist
EMuShareMem.dll loaded.
Error in GetItemsCount query 'SELECT MAX(id), count(*) FROM items' #1146: Table
'eq.items' doesn't exist
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
Error: Could not load item data

---------------------------------------------------------------------------
Seems it doesn't like the syntax. Guess i'll go in the sql code and see what's what.

[Lurker_005]

more like your DB isn't right, it is missing tables.

[wulfeous]

whenever i try to type in:
INSERT INTO account SET name='eqemu', password='eqemu', status 200,lsaccount_id=0;

i just get this:
ERROR 1064: you have an error in your SQL syntax near '200,lsaccount_id=0' at line 1

i also has this when i was trying it without the lsaccount_id=0 at the end. what is wrong?..

[Lurker_005]

try it with

"status=200"

[CrushTheTroll]

Howdy,

I have been working on a LAN setup, with no internet connection (in the military and dont have personnal net access). I have everything working great on the server, can log on and play normally from server computer. My problem is when I try to connect from a second computer. I reach the server select menue on mini login just fine, mini login sees the client when I do this but when i select my server and try to connect it bumps me out every time. Both machines are running xp pro and I am using a hub for the LAN. I have spent alot of time reading the forums but I am overlooking something (probably very obvious). Any suggestions as to why this is not working for me would be appriciated. :D

[Lurker_005]

Make sure you have the propper entries in miniloginaccounts.ini and that your not using 127.0.0.1 or localhost anywhere. Use the actual lan IP addresses.

Also check the minilogin, world and zone windows for any clues to what is actually happening.

[Barnebarn]

Hi,

just wanted to say that I've been away from EQEmu for a few months and nothing worked when I returned - but following this did, so thanks Lurker - nice job on this file!

[Lurker_005]

Well with over 20000 views I'm glad I have been able to keep it pretty much up to date and useful :)