Problems w/ creating server (world.exe)

[a_pond_sturgeon]

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.

[bluedestiny723]

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.

[Bigpull]

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

[bluedestiny723]

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

[a_pond_sturgeon]

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....

[Bigpull]

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: 'bluedestiny@localhost' (Using password: YES)


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.