|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Tutorials::Needs work This is where tutorials get moved to that are incomplete or outdated |
12-03-2003, 03:47 PM
|
|
Banned
|
|
Join Date: Nov 2003
Posts: 335
|
|
Help!
umm, when i get to the part where i open db.sql it says Error: failed to open db.sql;
|
12-03-2003, 05:16 PM
|
 |
Hill Giant
|
|
Join Date: Nov 2003
Location: Washington
Posts: 104
|
|
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 
|
12-04-2003, 03:13 AM
|
|
Demi-God
|
|
Join Date: Jun 2002
Posts: 1,693
|
|
It would also help if you posted a request for support in a support forum and just quoted this thread.
__________________
It's never too late to be something great.
|
12-04-2003, 03:06 PM
|
|
Sarnak
|
|
Join Date: Oct 2003
Posts: 30
|
|
I get the same error; (failed to open file 'db.sql;' , error 2)_
|
12-04-2003, 03:11 PM
|
|
Sarnak
|
|
Join Date: Oct 2003
Posts: 30
|
|
Some time I feel so stupid I put the db.sql file im my eq folder and not im my bin folder lol.
|
12-21-2003, 09:28 PM
|
|
Fire Beetle
|
|
Join Date: Dec 2003
Posts: 10
|
|
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 ?
|
12-27-2003, 02:34 AM
|
|
Fire Beetle
|
|
Join Date: Dec 2003
Posts: 16
|
|
ran command mysql -u root mysql and got the following error message:
ERROR 2003: Can't connect to MySQL server on 'localhost' <10061>
|
 |
|
 |
12-27-2003, 05:30 AM
|
|
Fire Beetle
|
|
Join Date: Dec 2003
Posts: 10
|
|
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:
|
 |
|
 |
12-27-2003, 05:48 AM
|
|
|
all you need to know can be found by using search
|
12-27-2003, 06:29 AM
|
|
Fire Beetle
|
|
Join Date: Dec 2003
Posts: 10
|
|
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.
|
12-27-2003, 06:37 AM
|
|
|
|
12-27-2003, 08:11 AM
|
|
Hill Giant
|
|
Join Date: Nov 2003
Location: Washington
Posts: 104
|
|
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 -_-
|
|
|
|
01-07-2004, 09:20 PM
|
|
Sarnak
|
|
Join Date: Oct 2002
Posts: 78
|
|
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? :(
|
|
|
|
01-07-2004, 09:44 PM
|
|
Dragon
|
|
Join Date: May 2003
Posts: 539
|
|
|
|
|
|
01-07-2004, 09:53 PM
|
|
Sarnak
|
|
Join Date: Oct 2002
Posts: 78
|
|
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
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 01:20 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
