dbs..

[Freshmaster17uk]

hi im using eqemu 5.0 having some probs with dbs ect can anybody post what dbs will work with 5.0 and what order i have to source them into mysql.. thanks

[Kgaul]

source this and watch for udates.

http://www.everquestserver.com/forums/viewtopic.php?t=10890&start=0


Kgaul

[arkaria]

Once you download and source the DB that Kgaul pointed you tovards.

Source this as well http://www.everquestserver.com/forums/viewtopic.php?t=11161

This is an update for that DB

[Freshmaster17uk]

before all that do i have to source db.sql too and all them other files , sometimes i keep getting item errors and no spawns

[Freshmaster17uk]

ok i sourced them files created a charactor when i try login its saying zone not avaiable i get following errors :

world.exe says

Logged in: Local: eqemu
Received unknown opcode: 0x02d2 size:0 bytes
Name approval request for:Master race:1 class:4
Choice:1
[Error] Database: could not find start_zones entry in database. Using Defaults..

Char create:Master
Attempting autobootup of qeynos2 (2) for Master
Zoneserver SetZone: localhost:7995 (0)
Zoneserver SetZone: localhost:7995 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Attempting autobootup of qeynos2 (2) for Master
Zoneserver SetZone: localhost:7998 (0)
Zoneserver SetZone: localhost:7998 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Received unknown opcode: 0x00e7 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:3199

one of the boot5zones.exe says

Logged in: Local: eqemu
Received unknown opcode: 0x02d2 size:0 bytes
Name approval request for:Master race:1 class:4
Choice:1
[Error] Database: could not find start_zones entry in database. Using Defaults..

Char create:Master
Attempting autobootup of qeynos2 (2) for Master
Zoneserver SetZone: localhost:7995 (0)
Zoneserver SetZone: localhost:7995 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Attempting autobootup of qeynos2 (2) for Master
Zoneserver SetZone: localhost:7998 (0)
Zoneserver SetZone: localhost:7998 (0)
Received unknown opcode: 0x02d2 size:0 bytes
Received unknown opcode: 0x00e7 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:3199

[Freshmaster17uk]

and another says

[Status] Weather should change in 12058 seconds
Init: Loading zone listsError1 in PopulateZoneLists query 'SELECT x,y,z,target_x
,target_y,target_z,target_zone,heading,target_head ing,number FROM zone_points WH
ERE zone='qeynos2' order by number' #1054: Unknown column 'heading' in 'field li
st'
ERROR: Couldn't load zone lists.
Zone->Init failed

rest are all fine seems like a db problem ?

[Chrysm]

No, you don't source the db.sql at all. You start out with a blank databse named eq and source those two files into it. I learned that hard way till hours of searching lead me to a post where the maker of the db asys do not source db.sql... just those two.

[Freshmaster17uk]

now i just gotta figure out them errors im getting

[CoDown]

now i just gotta figure out them errors im getting


Am having the same prob and know not what to do to get past it.

[Freshmaster17uk]

surely somebody knows! come on post post post we need ya helpz

[CoDown]

After Reading a few posts in other topics, it looks as tho we will have to wait for the next for the next DB Update from TCS

[arkaria]

TCS' alph3_3 DB + the update works fine for me. The 2 links up at the begining of this thread.

[Freshmaster17uk]

mayby just the one i downloaded before could be corrupt ? ill re download see wat happens ..... wish me luck

[CoDown]

I tried the db's from the links on this page and they worked perfectly.
Thanks for the help

[Kgaul]

You might be having a NAT error. there is a post somewhere about NAT config...

Made all the difference in my server.

Kgaul

[Tinv]

Having the exact same problem.

if I :
create database eq;
use eq;
source db.sql
then
everything works fine. No mobs, loot, spawns.... obviously. But i can get in and walk around.

if i:
create database eqtcm;
use eqtcm;
source MWnpcmovDB_050_alpha0_3_3.sql
source 050_item_object_update.sql
"optional next line, i've tried it with and without"
source dumpeditems.sql
then
I can get up to the char select screen create a character but when i try to get that character in i immediatly get "That zone is not Available"

The output in World.exe and the Zone.exe handling the character are pretty much identical to what the other poster recieved.


Am i going about this wrong? I've trolled here for a few hours and tried everything i came acrossed.


Any ideas?

[Kgaul]

please post your .ini's, might be in the IP config or in the Batzone... If your set up right you might also be having a NAT error. There is a wonderful No-name.org trick that shortcuts the NAT error...

http://www.everquestserver.com/forums/viewtopic.php?t=4177


Kgaul

[Tinv]

db.ini :

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



loginserver.ini :

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=menzoberranzan
locked=false
worldaddress=68.36.223.6

[WorldServer]
Defaultstatus=0
Unavailzone=

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



boot5zone.bat :

@echo off

if NOT exist spells_en.txt goto NOSPELL

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

The only thing i change is the database name from eq to eqtcm depending on what one i want to try.

[Chrysm]

did you world adduser eqemu eqemu 200?
I had the same problems and I think that fixed it

[Tinv]

Will give that a shot right away......
That zone is not available
:twisted:

[Chrysm]

If that doesn't work, I forgot how to fix it.
Be sure that when you add that account, it's to the new one that you make "DWMnpc_blah.sql" one

[Chrysm]

Try downloading the database directly from his website and sourcing the update then add the account and try. I am almost positive that's the problem.

[Tinv]

Am doin that sa i type am currently sourcing =)

[Tinv]

No Go =/

Heres the World.exe window :


[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=25924, max id=68199
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: 68.36.223.6:9000
World server listening on: 68.36.223.6:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997
7981 New TCP connection: 68.36.223.6:2513
7981 New TCP connection: 68.36.223.6:2514
7981 New TCP connection: 68.36.223.6:2515
7981 New TCP connection: 68.36.223.6:2516
New zoneserver: #1 68.36.223.6:2516
New zoneserver: #2 68.36.223.6:2515
New zoneserver: #3 68.36.223.6:2514
New zoneserver: #4 68.36.223.6:2513
Zoneserver SetConnectInfo: 68.36.223.6:2513: 68.36.223.6:7995
Zoneserver SetConnectInfo: 68.36.223.6:2514: 68.36.223.6:7998
Zoneserver SetConnectInfo: 68.36.223.6:2515: 68.36.223.6:7997
Zoneserver SetConnectInfo: 68.36.223.6:2516: 68.36.223.6:7999
8031 New TCP connection: 68.36.223.6:2517
New zoneserver: #5 68.36.223.6:2517
Zoneserver SetConnectInfo: 68.36.223.6:2517: 68.36.223.6:7996
66085 New client from ip: 68.36.223.6 port: 2520
Account Attempting to be created:Tinv 0
Logged in: FirstLogin LS#38090: Tinv
Received unknown opcode: 0x02d2 size:0 bytes
Name approval request for:Tinvarien race:7 class:4
Choice:1
[Error] Database: could not find start_zones table in database. Using Defaults..

Char create:Tinvarien
Attempting autobootup of qeynos2 (2) for Tinvarien
Zoneserver SetZone: 68.36.223.6:7995 (0)
Zoneserver SetZone: 68.36.223.6:7995 (0)
Received unknown opcode: 0x02d2 size:0 bytes


Heres the zone window that took the call :

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from spells_us.txt
[Status] FileLoadSPDat() spells loaded: 4352
[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: 68.36.223.6:9000
[Status] Weather should change in 5432 seconds
Init: Loading zone listsError1 in PopulateZoneLists query 'SELECT x,y,z,target_x
,target_y,target_z,target_zone,heading,target_head ing,number FROM zone_points WH
ERE zone='qeynos2' order by number' #1054: Unknown column 'heading' in 'field li
st'
ERROR: Couldn't load zone lists.
Zone->Init failed


So to recap.

create database eqtest;
use eqtest;
source DWMnpc_blah.sql
source DWMnpc_update_050..blah.sql
exit

edit db.ini
changed the database line to
database=eqtest
go to command prompt to eqemu directory

world adduser eqemu eqemu 200

close command prompt.

click on world
click on boot5zone.bat

open eq and....

after creating newbie 1 ranger
and clicking on enter
That zone is not available =/


Did i miss anything?

Again. if i follow these exact steps but only source the db.sql from eqemu i enter the world fine.

/boggle

[arkaria]

Did you grant the proper mysql permisions to the database eqtest for the user tinv@localhost?

[Tinv]

ruh roh i think ya got me.. that one went soaring over my skullcap.. let me go search around for exactly what you are talking about

[mattmeck]

[Error] Database: could not find start_zones table in database. Using Defaults..

Thats what cought my attention, Ma be a bad DB. In the past when i had DB issues i re-downloaded the DB and reinstalled. It is a common error for the SQL file to become currupted when unzipping, i know of many cases of this.

EDIT

Init: Loading zone listsError1 in PopulateZoneLists query 'SELECT x,y,z,target_x
,target_y,target_z,target_zone,heading,target_head ing,number FROM zone_points WH
ERE zone='qeynos2' order by number' #1054: Unknown column 'heading' in 'field li
st'
ERROR: Couldn't load zone lists.
Zone->Init failed


that would be the result of the first error i pointed out.

[arkaria]

Not sure what guide you've been following. The following guide is out dated but the commands you need to configure mysql are still valid.

http://www.eqemu.net/Guide.htm

[Tinv]

ok redownloaded both archives by following post # 2 and 3 from this thread.

and am following http://www.eqemu.net/Guide.htm
to the "T".

[arkaria]

Just make sure not to use the eqhost.txt specified in that guide as it is for v4.4 servers. Everything else pretty much should still aplly.

[Kgaul]

ok found some potential probs

If you have not please recopy your ini's by hand, there were probs i ran into just using the cvs version.. ALSO please dont cut and paste from this site...

my loginserver.ini

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Raevenloft [LEGIT] (Beta)
worldaddress=(NAT correction with No-ip.org)
locked=false
[worldserver]
defaultstatus=
unavailzone=
[loginconfig]
servermode=standalone
serverport=5997
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=


also make sure you read the NAT post on the tutorials. I was finally able to log in when i corrected how world, zone, login, and my ports were talking to each other...

http://www.everquestserver.com/forums/viewtopic.php?t=4177

Kgaul

[Tinv]

:D :D :D :D :D

Outstanding Troubleshooting to all 3 of you!!!

There was a descrepency in file sizes from the MWblahblah050.sql i downloaded last night and the one i just downloaded tonight.
That was problem # 1 /cheer mattmeck

Problem #2 Arkaria was dead on. All the tutorials use one form of the GRANT PRIVILEGES line to open up mysqladmin to eqemu.
I forgot ,in my rush to start messing with filled worlds after seeing this thing actually worked, that i had used eq.* in the grant privileges line and not *.* . Which had i stopped and thought about it for a minute makes sense that when i ran the database with just db.sql sourced in itwould work because that database is called eq.sql . But when i created eqtest eqemu wasnt allowed in because i didnt re run my Grant permision line to include eq*.* or eqtest.* . I am edumacated now and look forward to my next bout of noobism

Thanks a ton for listening =)

[arkaria]

Glad to help.

Have fun running your server :)

[Freshmaster17uk]

ok i got the files an dat have played it fine but sometimes when i restart the emu and try login to char i get zone unavaible again.... not sure wats wrong but its ok sometimes if i restart eq but it happens alot dunno why any ideas?

[Kgaul]

Fresh, we need more info. Your own server or another server? mini or Login with Eqemu...


Kgaul

[Freshmaster17uk]

eh im using minilogin for my own offline server just to mess around on....

[Kgaul]

ok friend, Please post your Ini's and what tutorial your using...


Kgaul

[Freshmaster17uk]

using no tutorials aint that dumb.... anyways heres my inis


loginserver.ini
[LoginServer]
loginserver=localhost
loginport=5999
worldname=BAD_ASS_BOB
worldaddress=localhost
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

db.ini
[Database]
host=localhost
user=god
password=god
database=eq
compression=off


eh u want minilogin accounts ini too and boot5zones ?

[Kgaul]

ok some probs first off. Use a Tutorial

second when you started Mysql for the first time did you use God as the login and God as the password?

Third Pelase check the tutorials to see if 5999 is the port for minilogin. i'm not sure if its that or 5997


Kgaul

[Freshmaster17uk]

lol iv been around long enough no tutorials and yes the port was 5997 i changed it because i was having errors and it seems to work on 5999..

[Kgaul]

ok friend my Aim is Powe8525 if your still having probs please msg me and we will work throu this...


Kgaul

[Freshmaster17uk]

yeah the user and pw was same could it be virus or sommat ... doubt it could be but 1 min it works fine next time i try login "zone not available"

[Kgaul]

have you set static zones? can you log in at all?


Kgaul

[Freshmaster17uk]

yeah i can get in play the game ect but certain times like a day later i try to login again to play but get zone unavailable

[Kgaul]

ok here is my best advice. if you can get in, set up static zones in batzone... then use the zone boot up commands and the zonestatus commands to make sure that zone is up, also always log out in a static zone... that will make sure you can get in(barring any other probs)


Kgaul

[bud9weiser]

the reasons you are getting the errors for start_zones and zone_points is becouse in TCS's database we havent added them yet, they will be included in the next release, for now just ignore the errors

[bud9weiser]

the reasons you are getting the errors for start_zones and zone_points is becouse in TCS's database we havent added them yet, they will be included in the next release, for now just ignore the errors