EQEmulator Forums - Configurations

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - Configurations - What's the latest? (https://www.eqemulator.org/forums/showthread.php?t=16136)

Arcane

10-01-2004 03:20 PM

Configurations - What's the latest?

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

10-01-2004 04:22 PM

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

Arcane

10-02-2004 01:12 AM

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

10-02-2004 02:58 AM

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

10-02-2004 09:40 AM

What sotonin said.

Arcane

10-03-2004 06:00 AM

Quote:

[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

10-03-2004 06:05 AM

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

Arcane

10-03-2004 06:20 AM

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.

Quote:

[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

10-03-2004 06:38 AM

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

http://www.eqemulator.net/forums/vie...abase+download

Arcane

10-03-2004 06:47 AM

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

10-03-2004 06:56 AM

Quote:

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

Error here, 5996 server is gone, should be:

Code:

[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

10-03-2004 08:30 AM

Quote:

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

10-03-2004 09:15 AM

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

All times are GMT -4. The time now is 08:38 PM.