Update DB

Results 1 to 7 of 7
  1. #1
    Member SniperX32 is offline
    MemberRank
    Jan 2007 Join Date
    93Posts

    Update DB

    Hi all can someone explain me how to updatemy DB now I have the 3010 Full
    I fI use the DB update it says it can't connect to the root@localhost (using pasword: YES)
    Last edited by SniperX32; 27-01-07 at 02:24 PM. Reason: Typed something wrong


  2. #2
    Member SniperX32 is offline
    MemberRank
    Jan 2007 Join Date
    93Posts
    Omg why does no'one help me

    oops capslock :p

  3. #3
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,515Posts
    Maybe nobody is "helping" you because you're so impatient! You PMed me twice in about 15 minutes. Maybe if you try setting up your MySQL properly, it will work. There's a reason it's saying:
    can't connect to the root@localhost (using pasword: YES)
    ... Double check and make sure you set the right username and password, or, just copy the contents of your conf files and post them here, and I'll tell you what you did wrong.
    P.S. In future, try to be a bit more patient. If you PM someone and they don't answer, it means they are either busy, they're not there, or they just don't wanna help (it just so happens I was very busy).

  4. #4
    Member SniperX32 is offline
    MemberRank
    Jan 2007 Join Date
    93Posts
    Lol i Pmed you 2 times in a hour :P

    Code:
    # MaNGOS Configuration file
    ConfVersion=2006082301
    
    # RealmID must match the realmlist
    RealmID = 1
    
    # 0 NORMAL 1 PVP 4 NORMAL 6 RP 8 RPPVP
    GameType = 1
    
    # Data directory setting.
    # Important: DataDir needs to be quoted, as it is a string which may
    # contain space characters.
    DataDir = "./Data"
    
    # Database connection settings for the world server.
    # Default: hostname;port;username;password;database
    LoginDatabaseInfo = "127.0.0.1;3306;root;pass;realmd"
    WorldDatabaseInfo = "127.0.0.1;3306;root;pass;mangos"
    
    # Settings for maximum database-ping interval (minutes between pings)
    MaxPingTime = 30
    
    # Server console level of logging
    # 0 = Minimum; 1 = Basic&Error; 2 = Detail; 3 = Full/Debug
    # Default: 0
    # recommend: 1
    LogLevel = 3
    
    # Logfile name
    #    empty name disable creating log file: LogFile = 
    # Default: ""
    LogFile = "Server.log"
    
    # Server file level of logging
    # 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
    # Default: 0
    LogFileLevel = 0
    
    # Packet logging for the worldserver
    # Default: 0 (false)
    #          1 (true)
    LogWorld = 1
    
    # Log filters
    # 0 (default) - include in log if log level permit, 1 - not include with any log level
    LogFilter_TransportMoves = 0
    LogFilter_CreatureMoves = 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 = ""
    
    # Log file of DB errors detected at server run.
    # Default: ""
    DBErrorLogFile = "DBErrors.log"
    
    # Log file of gm commands
    # Default: "" (Disable)
    GmLogFile = ""
    
    # 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
    
    # Max level that can reached by player for expirience (in range from 1 to 255).
    # Change not recommended
    # Default: 60
    MaxPlayerLevel = 60
    
    # Ignore level requirement to enter instance
    # 	   1 (true)
    # Default: 0 (false)
    IgnoreATLevelRequirement = 0
    
    # Max count that player can learn the primary trade skill.
    # Default: 2
    # Max : 9 
    MaxPrimaryTradeSkill = 2 
    
    # Min signatures count to creating guild (0..9).
    # Default: 9
    MinPetitionSigns = 9 
    
    # 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 = 0
    
    # Allow or not common :chat(say,yell);channel(chat)group(join)guild(join);trade for players from different teams.
    # Defaullt: 0 (Not allowed)
    #           1 (Allowed)
    AllowTwoSide.Interaction = 0
    
    # Allow or not show player from both team in who list.
    # Defaullt: 0 (Not allowed)
    #           1 (Allowed)
    AllowTwoSide.WhoList = 0
    
    # Is GM accept whispers from player by default.
    # Default: 0 (false)
    #          1 (true) 
    GM.WhisperingTo = 0
    
    
    # Is GM showed in GM list (if visible) in non-GM state (.gmoff)
    # Default: 0 (false)
    #          1 (true) 
    GM.InGMList = 0
    
    # Is GM showed in who list (if visible).
    # Default: 0 (false)
    #          1 (true) 
    GM.InWhoList = 0
    
    # GM mode at login
    #          0 (disable)
    #          1 (enable) 
    # Default: 2 (last save state)
    GM.LoginState = 2
    
    # Include GM trade and trade slot enchanting operations in GM log if it enable
    #          0 (not include)
    # Default: 1 (include)
    GM.LogTrade = 1
    
    # Group visibility modes
    # Default: 0 (standard setting: only members from same group can 100% auto detect invisible player)
    #          1 (raid members 100% auto detect invisible player from same raid)
    #          2 (players from same team can 100% auto detect invisible player)
    GroupVisibility = 0
    
    # Message of the Day. Displayed at worldlogin for every user.
    Motd = "Welcome to the Massive Network Game Object Server."
    
    # Health and power regeneration.
    Rate.Health = 1;
    Rate.Power1 = 1;
    Rate.Power2 = 1;
    Rate.Power3 = 1;
    
    # Drop rates
    # Default: 1
    Rate.Drop.Items = 1000000
    Rate.Drop.Money = 1000000
    
    # XP rates
    # Default: 1
    Rate.XP.Kill    = 1000000
    Rate.XP.Quest   = 1000000
    Rate.XP.Explore = 1000000
    
    # Creature Damage Rate.
    # Examples: 2 - creatures will damage 2x, 1.7 - 1.7x.
    Rate.Creature.Normal.Damage = 1
    Rate.Creature.Elite.Elite.Damage = 1
    Rate.Creature.Elite.RAREELITE.Damage = 1
    Rate.Creature.Elite.WORLDBOSS.Damage = 1
    Rate.Creature.Elite.RARE.Damage = 1
    
    # 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
    Rate.Creature.Elite.RAREELITE.HP = 1
    Rate.Creature.Elite.WORLDBOSS.HP = 1
    Rate.Creature.Elite.RARE.HP = 1
    
    
    # Resting points grow rates (1 - normal, 2 - double rate, 0.5 - half rate, etc) from standart values
    Rate.Rest.InGame = 1
    Rate.Rest.Offline.InTavernOrCity = 1
    Rate.Rest.Offline.InWilderness = 1
    
    # Skill chance values (0..100) 
    # default: 100-75-25-0
    SkillChance.Orange = 100
    SkillChance.Yellow = 75
    SkillChance.Green  = 25
    SkillChance.Grey   = 0
    
    #Aggro radius percent or off.
    #          0   - off (0%)
    # Default: 1   - 100% 
    #          1.5 - 150%
    Rate.Creature.Aggro = 1
    
    # 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
    
    # Maximum overspeed ping count before player kick (minimum is 2, 0 used for disable check)
    # Default: 10
    MaxOverspeedPings = 10
    
    
    # Unload grids (if you have lot memory you can disbale 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 = 100
    
    # Default weather update interval
    ChangeWeatherInterval = 600000
    
    # Default PlayerSaveInterval
    PlayerSaveInterval = 900000
    
    # Default WorldServerPort
    WorldServerPort = 8085
    
    
    # Beep at mangosd start finished (mostly work only at Unix/Linux systems)
    # Default: 1 
    BeepAtStart = 1
    Realmd
    Code:
    # 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;root;pass;realmd"
    
    # 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 = ""
    
    # 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

  5. #5
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,515Posts
    What username and pass did you set when you installed MySQL? Well, whatever username you set, replace these red words with it:
    LoginDatabaseInfo = "127.0.0.1;3306;root;pass;realmd"
    WorldDatabaseInfo = "127.0.0.1;3306;root;pass;mangos"
    and replace the blue words with the password you specified when installing MySQL

  6. #6
    Member SniperX32 is offline
    MemberRank
    Jan 2007 Join Date
    93Posts
    thats what I did I can run my server play on it and everything the only reason is I want to know how to update my DB :P

  7. #7
    Sorcerer Supreme elldiablo is offline
    Member +Rank
    Oct 2005 Join Date
    Outland --> Shattrath cityLocation
    478Posts
    heheh always the same problems that you guys can find in the tutorials ,,

    "Tip"
    next time save a tutorials adres in your fafo's folder



Advertisement