Problems w/ creating server (world.exe)
 

Having problems w/ world.exe, I followed the readmes, RTFM, and did searches on my problem. The main problem is that when I run world.exe, it gives me text very quickly, then closes, and it says something about incorrect version, any help would be greatly appreciated.

OS: WinME
CPU: Celeron proccessor (733 mhz)
RAM: 512 SDR
EQ Client: No
Last EQ patch date: late march
Running EQEmu: World(trying to)
#of zones: 5

DB.INI

[Database]
host=localhost
user=*****
password=*****
database=eq
compression=off

LOGINSERVER.INI

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=Casserole Surprise
worldaddress=172.142.100.248
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

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

BOOT5ZONES.bat

start zone . 172.142.100.248 7995 172.142.100.248
start zone . 172.142.100.248 7996 172.142.100.248
start zone . 172.142.100.248 7997 172.142.100.248
start zone . 172.142.100.248 7998 172.142.100.248
start zone . 172.142.100.248 7999 172.142.100.248
exit
cls

WORLD.exe

It closes real fast, but it says: could not connect to database 'eq', cant to connect to mysql server, then says:[STATUS] incorrect_version: EqEmu 4.3, then [ERROR] incorrect_version: EqEmu 4.3

There is the problem, it just closes real fast, I have mysqladmin running in the backround and have an eq database already set up by using the readme's directions, so any help would be greatly appreciated, thanx.

same..
 

I have the exact same problem and have done everything i can think of to fix it, any help would be greatly appreciated..also i have attempted to make a server on two different computers and both have the same result.

Simply run it from a command prompt instead of from explorer and it won't close or you need to setup it's pif so it doesn't close automaticly

..
 

k i read more and saw a fix for this and did the command for it but i still get the same error when i load world.exe

this is the fix i tried...GRANT ALL PRIVILEGES ON eq.* TO image@133.133.13.13 IDENTIFIED BY 'bleh' WITH GRANT OPTION;

changed the info obviously but still got the same error


Failed to connect to database: Error: #1045: Access denied for user: 'bluedestin
y @localhost' (Using password: YES)
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.3
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.3
Loading Variables, zone names & items...
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
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
EMuShareMem.dll 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
server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
Error: Could not load item data

any help you can give is much appreciated been going at this for several hours now and gonna keep searching forums for other possible fixes

old....and a fix =P
 

Hehe, I posted this like a couple weeks ago lol, someone searching around must've found it, anyhow, I have since fixed this error mind you and then ran into a new one; but that's not important, here's what worked for me:

Make sure you have winmysqladim running first.

Then go to start, run, then type in "command" without quotes.

Then type in, without quotes: "c:\mysql\bin\mysql.exe --user=root eq" then press enter.

This should change the promt to mysql, then type as follows without quotes: "GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;"

That should do it, worked for me and others, search around and you'll find exactly what I just privided you with kk thx. Hope this helps, later....

Bonus points if you can spot whats wrong here..

Who@Where ?

You need to use @localhost in your grant command when connecting directly to the sql socket, You generaly only use TCP for connections to a remote database, in fact it's considered unsafe to even listen for TCP connections.