Im so close tomaking my first server I can taste it..im done but its not loggin..

[Crono32]

heres the tut ive followed..

http://forum.ragezone.com/f518/mango...server-332335/

im done but I feel as though im not configuring it right for realm.conf

and mangos.conf

Heres my realm.conf(Ive takin out the passes and logins)




# MaNGOS realmd configuration file
ConfVersion=2006060401

# Database connection settings for the realm server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;"your mysql name";"your mysql pass";"
WorldDatabaseInfo = "127.0.0.1;3306;"your mysql name";"your mysql pass";"
CharacterDatabaseInfo = "127.0.0.1;3306;"your mysql name";"your mysql pass";"

# Settings for maximum database-ping interval (minutes between pings)
MaxPingTime = 30

# Default RealmServerPort
RealmServerPort = 3724

# Server console level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogLevel = 0

# Logfile name
# empty name disable creating log file: LogFile =
# Default: "Server.log" - not recommended.
LogFile = "Realmd.log"

# Server file level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogFileLevel = 0

# Color for messages (format "normal_color details_color debug_color error_color)
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN, 3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 - CYAN, 7 - GREY,
# 8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
# "13 7 11 9" - for example :)
LogColors = "13 7 11 9"

# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
# number (bitmask value of selected processors)
UseProcessors = 0

# Process proirity setting (Used only at Windows)
# 0 (Normal)
# Default: 1 (HIGH)
ProcessPriority = 1





------------------------------




And my mangos.conf

# MaNGOS Configuration file
ConfVersion=2006082301

# RealmID must match the realmlist
RealmID = 1

# 0 NORMAL 1 PVP 4 NORMAL 6 RP 8 RPPVP
GameType = 0

# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = "./"

# Database connection settings for the world server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;"your mysql name";"your mysql pass";realmd"
WorldDatabaseInfo = "127.0.0.1;3306;"your mysql name";"your mysql pass";mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;"your mysql name";"your mysql pass";characters"
# Logfile name
# Default: "Server.log"
LogFile = "Server.log"

# BC support.
# Default: 0 (No support)
# 1 (BC needed to logon)
BCSupport = 1

# Server console level of logging
# 0 = Minimum; 1 = Basic&Error; 2 = Detail; 3 = Full/Debug
# Default: 0
# recommend: 1
LogLevel = 1

# Packet logging for the worldserver
# Default: 0 (false)
# 1 (true)
LogWorld = 0

# Log filters
# 0 (default) - include in log if log level permit, 1 - not include with any log level
LogFilter_TransportMoves = 1
LogFilter_CreatureMoves = 1

# Color for messages (format "normal_color details_color debug_color error_color)
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN, 3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 - CYAN, 7 - GREY,
# 8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
# "13 7 11 9" - for example :)
LogColors = "13 7 11 9"

# Log file of gm commands
# Default: "" (Disable)
GmLogFile = "GMCommangs.log"

# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
# number (bitmask value of selected processors)
UseProcessors = 0

# Process proirity setting (Used only at Windows)
# 0 (Normal)
# Default: 1 (HIGH)
ProcessPriority = 1

# Compression level for update packages sended to client (1..9)
# Default: 1 (speed)
# 9 (best compression)
Compression = 1


# Maximum number of players in the world. Excluding GM's
# Default: 100
PlayerLimit = 100

# Default value for enabling addons, Allow then Deny or Deny then Allow
# Default: 1 (true)
# 0 (false)
AddonDefault = 1

# Max level that can reached by player for expirience.
# Change not recommended
# Default: 60
MaxPlayerLevel = 70

# Max count that player can learn the primary trade skill.
# Default: 2
# Max : 9
MaxPrimaryTradeSkill = 2

# Max distance to creature for group memeber to get XP at creature death.
# Default: 74
MaxGroupXPDistance = 74

# Max level different with creature for group member to get XP at creature death.
# Default: 10
MaxGroupXPLevelDiff = 10

# Allow or not accounts to create characters in the 2 teams in any game type.
# Defaullt: 0 (Not allowed)
# 1 (Allowed)
AllowTwoSide.Accounts = 1

# Allow or not common :chat(say,yell);channel(chat)group(join);trade for players from different teams.
# Defaullt: 0 (Not allowed)
# 1 (Allowed)
AllowTwoSide.Interaction = 1

# Allow or not show player from both team in who list.
# Defaullt: 0 (Not allowed)
# 1 (Allowed)
AllowTwoSide.WhoList = 1

# Is GM accept whispers from player by default.
# Default: 0 (false)
# 1 (true)
WhisperingToGM = 1

# Message of the Day. Displayed at worldlogin for every user.
Motd = "Welcome to |cff660000World of Warcraft TBC|r...\nRepacked by DJRavine [|cff0066CChttp:\\wowps.org|r]...\n Supports v2.0.7 v2.0.8 v2.0.10..."

# Health and power regeneration.
Rate.Health = 1;
Rate.Power1 = 1;
Rate.Power2 = 1;
Rate.Power3 = 1;

# Drop rates
# Default: 1
Rate.Drop.Items = 1
Rate.Drop.Money = 1

# XP rates
# Default: 1
Rate.XP.Kill = 75
Rate.XP.Quest = 100
Rate.XP.Explore = 50

# Creature Damage Rate.
# Examples: 2 - creatures will damage 2x, 1.7 - 1.7x.
Rate.Creature.Normal.Damage = 1
Rate.Creature.Elite.Elite.Damage = 1.3
Rate.Creature.Elite.RAREELITE.Damage = 1.6
Rate.Creature.Elite.WORLDBOSS.Damage = 1.9
Rate.Creature.Elite.RARE.Damage = 2

# Creature Health Ammount Modifier.
# Examples: 2 - creatures have 2x health, 1.7 - 1.7x.
Rate.Creature.Normal.HP = 1
Rate.Creature.Elite.Elite.HP = 1.3
Rate.Creature.Elite.RAREELITE.HP = 1.6
Rate.Creature.Elite.WORLDBOSS.HP = 1.9
Rate.Creature.Elite.RARE.HP = 2

#Aggro radius percent or off.
# 0 - off (0%)
# Default: 1 - 100%
# 1.5 - 150%
Rate.Creature.Aggro = 0.40

# Default remote console port
Ra.Port = 3443

# Log remote console connections
Ra.Log = 1

# Minimum level that's required to login,3 by default
Ra.MinLevel = 3

# Kick client on wrong pass
Ra.Secure = 1


# Unload grids (if you have lot memory you can disable it to speed up player move to new grids second time)
# 0 (not unload grids)
# Default: 1 (unload grids)
GridUnload = 1;


# All times are in milliseconds.

# Default socket select time
SocketSelectTime = 10000

# Default grid clean up delay
GridCleanUpDelay = 300000

# Default map update interval
MapUpdateInterval = 500

# Default weather update interval
ChangeWeatherInterval = 600000

# Default PlayerSaveInterval
PlayerSaveInterval = 900000

# Default WorldServerPort
WorldServerPort = 8085


Does it look right?? It wont let me login with my selected login and passy

Im sooo close. I followed the tut word for word....
Thanks for any help....

[MentaL]

[Crono32]

I feel like im missing something to... theres nothing running in the query in SQLyog and the timer at the bottom left(exec) isent running... What am I missing??

[Crono32]

it keeps crashing on me...


## Crash! 2/24/2009 3:04:50 AM. mangosd.exe has crashed! Lines logged from Server.log



MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM


2009-02-24 03:04:06 World Database: 127.0.0.1;3306;root;root;mangos
2009-02-24 03:04:06 Login Database: 127.0.0.1;3306;root;root;realmd
2009-02-24 03:04:06 Realm running as realm ID 1
2009-02-24 03:04:06 ERROR:SQL: UPDATE `character` SET `online` = 0
2009-02-24 03:04:06 ERROR:SQL ERROR: Table 'mangos.character' doesn't exist
2009-02-24 03:04:06 Using DataDir ./
2009-02-24 03:04:07 ERROR:SQL: DELETE FROM `corpse` WHERE `bones_flag` = '1'
2009-02-24 03:04:07 ERROR:SQL ERROR: Table 'mangos.corpse' doesn't exist
2009-02-24 03:04:07 Initialize data stores...
2009-02-24 03:04:08
2009-02-24 03:04:08 >> Loaded 28 data stores
2009-02-24 03:04:08
2009-02-24 03:04:08 Loading Game Object Templates...
2009-02-24 03:04:08 ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 18 fields in sql).

What could be the problem??

[Crono32]

it looks as though I need to update something but what?? slq??

[Crono32]

you know.. why do I bother.. Nobody cares......

[blackhawk]

did u change reamlist in sql to your server name & ip

[spoocke]

2009-02-24 03:04:08 ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 18 fields in sql).

thats the problem you usea wrong db on this server or are running older or newer dbc files wich you downloaded from the net.
its beter to extract them.
if its your first wow server.
stick with repacks.
there are 3.0.9 repacks out already.

[Ainkut]

redo the SQL file. reupload it by deleting the original upload, and then upload it again. sounds like something didnt get uploaded right.

[dreadth81]

I got my server working fine .... but i just need a repack that includes a nice mall but cant get it... soo right now im stuck with a plane blizzlike server... and the reason i want a repack with the mall is because i cant figure out all those npc's names sooo

[sixdd]

The command that is your best friend for that is .npc, just try it and you'll figure out how it works pretty quickly.

Also you can go to WoW Vendetta and create custom items and a vendor for them, there is a learning curve but it is pretty easy to figure out once you get going.

Happy mall making, I'll try and remember to check back here if you have any other questions.