EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Tutorials::Needs work (https://www.eqemulator.org/forums/forumdisplay.php?f=631)
-   -   OUTDATED:: HOWTO: Setup a server with EQEmu 5.X (https://www.eqemulator.org/forums/showthread.php?t=10514)

hypershadow66 12-03-2003 03:47 PM

Help!
 
umm, when i get to the part where i open db.sql it says Error: failed to open db.sql;

Bearik 12-03-2003 05:16 PM

Could you be a little more specific hypershadow? Did you try to literally open db.sql, or did you just type "Open DB.sql;" ?

should just be "source db.sql;"

Also copying the error from cmd prompt would help :)

a_Guest03 12-04-2003 03:13 AM

It would also help if you posted a request for support in a support forum and just quoted this thread.

the2ndone 12-04-2003 03:06 PM

I get the same error; (failed to open file 'db.sql;' , error 2)_

the2ndone 12-04-2003 03:11 PM

Some time I feel so stupid I put the db.sql file im my eq folder and not im my bin folder lol.

Ynyyk 12-21-2003 09:28 PM

Semms to work but my server is "CLOSED"
 
I managed to use this guide and i can see my server listed on Eqemu servers. But unfortunately i can't even log in cause it is written CLOSED.

So how to avoid this and now how to do something in the server as a GM or as a player ?

animekenji 12-27-2003 02:34 AM

ran command mysql -u root mysql and got the following error message:

ERROR 2003: Can't connect to MySQL server on 'localhost' <10061>

Ynyyk 12-27-2003 05:30 AM

I have since yesterday night the same problem than animekenj.

When i am in the dos (by cmd) in this repertoire (c:\mysql\bin) i type mysql -u root mysql (cause i want to have all right to create a new DB) and it is writtten this :
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

And when i try to do world.exe (to see what happens) it is written :

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR2
[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
Warning: You need to get laid...
TCP listening on: 81.66.121.26:9000
World server listening on: 81.66.121.26:9000
===============================
Runtime errors:

MySQL Error #2003 means you were unable to connect to the mysql server.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=2

Hit any key to exit


so can someone help me (during this time i will try to resolve my problem myself)
:lol:

mattmeck 12-27-2003 05:48 AM

all you need to know can be found by using search

Ynyyk 12-27-2003 06:29 AM

Mattmeck you are a Helper ? So instead of saying always use search (guess what i use search about error 2003 and i found several post but none resolved my problems) why not really helping me (or others).

I am sure it take egual time to flame than to help. And believe or not i REALLY try to find answers by myself (search, own tries...etc).

I hope i won't be banned for only say what i think.

mattmeck 12-27-2003 06:37 AM

to quote the words of the Devs http://www.everquestserver.com/forum...ic.php?t=10773

and http://www.everquestserver.com/forum...ic.php?t=11111 (since you are asking in the wrong forum)

and http://www.everquestserver.com/forum...pic.php?t=8849 (right in this forum)

Bearik 12-27-2003 08:11 AM

Ynyyk, mattmeck is the best kind of helper because not only does he help with problems but he helps people understand that theres a god damn search button that solves 80% of all EQEmu problems. :)

And he does help people alot, just look through his posts.

This is not a support forum. If you have a problem please post in the support forum and say that you got it after reading my guide so I can improve this in whatever way.


Thanks. Bearik out -_-

Squiffy 01-07-2004 09:20 PM

Mkay, I've tried everything here and I'm stumped. I'm modifying this howto to make a local server. Replacing everything with "localhost" (without the quotes) wherever an IP is.

So I run MiniLogin, World goes fine, except for some database issues (it's empty right now) then B5Z works fine, too.

I load up EQ, get to server select, mine shows up there, but locked. Odd, since the login.ini is set to false, but hey. I hit play, and after a minute get 1017ed.

Code:

db.ini
[Database]
host=localhost
user=myusername
password=mypassword
database=eq
compression=off

Code:

LoginServer.ini
[LoginServer]
loginserver=localhost
loginport=5999
worldname=Squiffy Emulator
worldaddress=localhost
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

Any ideas what I may be doing wrong? Minilogin gives me an error about a missing Miniloginaccounts.ini, or similar. Is that the culprit, or a red herring?

The eqemu/eqemu account is added in the sql table, and I added it through world.exe.

Any ideas? :(

Muuss 01-07-2004 09:44 PM

Minilogin requires its ini file, read that post :
http://www.eqemulator.net/forums/vie...ight=minilogin

Squiffy 01-07-2004 09:53 PM

Bleh I got all excited. I added the MLA.ini file and originally had

Code:

localhost eqemu eqemu
Which wasn't working. Changed it to 192.168.1.100, and the server was unlocked this time /gasp.

Still 1017, though.

/sigh.

Here's the output I get, by the way...

MiniLogin:
Code:

LoginServer.ini read.
MiniLoginAccounts.ini read.
Server mode: Standalone
Login server listening on port:5999

World.exe:
Code:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemclass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslots,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5type,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,unknown070,unknown076,unknown077
,augtype,ldonpointtheme,ldonpointcost,unknown099,astr,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,damage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,factionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,hp,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidance,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shielding,spellshield,strikethrough,
stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2
' in 'field list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data.  But ignoring
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking bards...done
TCP listening on: localhost :9000
World server listening on: localhost :9000
Connected to LoginServer: localhost:5999

Zone.exe:
Code:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded

At this point, 99% of the time, it stops. After a loooong pause it spits out the rest:

Code:

Error: EMuShareMem: DLLLoadItems: !ItemsMMF.IsLoaded() (timeout)
[Error] Loading items FAILED!
Failed.  But ignoring error and going on...
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 148 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000



All times are GMT -4. The time now is 08:35 AM.

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