Configurations - What's the latest?

[Arcane]

I'm trying to use MySQL 4.0.21-nt, with EQEmu 0.5.8; the database I am not completely sure of at the moment as I have yet to get running. I know I have two errors one regards the compatability of the data base (which one and where?), and also a possible firewall issue, which the firewall is completely disabled in the server box and also it's LAN IP is DMZed to be open to the public as it were.

I'll figure out the firewall/blockage later, right now due to my total lack of experience with EQEmu and my extremely limited vocabulary with which to type in search criteria, I'm lost. I've been typing away trying to get EQE running by myself, by using a shred of common sense and scouring the boards.

Please don't beat me :)

[Malignus Wingnut]

Uh...so what exactly are your 2 problems? Need more info.

[Arcane]

I have the compatability/possibly corrupt data base, and the firewall problem.

Right now I'm only interested in ensuring I have the proper database, I'll work on the connectivity once I get that portion nailed down.

[sotonin]

You still have yet to explain your problem. What is wrong with your db to make you think it's corrupt. Post error messages etc.

[Malignus Wingnut]

What sotonin said.

[Arcane]

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.8
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[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 -1 stale player corpses from database
[Status] Deleted -1 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: FaustRealms.servegame.com:9000
World server listening on: FaustRealms.servegame.com:9000
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables' doesn't exist'
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error: 10061'

[Malignus Wingnut]

1)What database have you sourced?
2)Post contents of loginserver.ini.

[Arcane]

That's the problem; I myself have not "sourced" any databases, unless you mean by "sourced" downloaded and imported. I have tried several.

dumpeditems.sql - 12/7/2003
update-feb-20.sql - 2/29/2004
db.sql - 9/30-2004

I will have to admit that the SQL portion of EQEmu's configuration hasn't been easy for me.


[LoginServer]
#loginserver=FaustRealms.servegame.com
loginserver=newlogin1.eqemulator.net
#loginserver2=eqemulator.net
loginport=5996
#loginport2=5996
worldname=The Realms of Faust
worldaddress=FaustRealms.servegame.com
locked=true
account=
password=


[WorldServer]
Defaultstatus=20
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[Arcane]

I'm going to use this guide for now; and see what happens next

http://www.eqemulator.net/forums/viewtopic.php?t=17531&highlight=database+download

[Arcane]

The database "classic" worked, thank you for the guide, will work on the port issues next.

For those of you reading this post, looking for the same thing I was looking for be sure to follow the link in my prior post.

[Malignus Wingnut]

[LoginServer]
#loginserver=FaustRealms.servegame.com
loginserver=newlogin1.eqemulator.net
#loginserver2=eqemulator.net
loginport=5996

Error here, 5996 server is gone, should be:

[LoginServer]
#loginserver=FaustRealms.servegame.com
loginserver=newlogin1.eqemulator.net
#loginserver2=eqemulator.net
loginport=5994

Thats why world.exe wont connect to the login server.[/quote]

[sotonin]

That's the problem; I myself have not "sourced" any databases, unless you mean by "sourced" downloaded and imported. I have tried several.

The proper way to source a database is through command prompt Mysql. "Importing" through mysql-front can cause problems a lot of the time. It isn't very good for importing huge databases like this. It has trouble on raw fields many times. I'd recommend following the guides that explain how to do it via dos prompt.

[Arcane]

THe database and login server issues are resolved; now I gotta find the right guide for logging in.