[ArcEmu] Host not alloud to connect to MySQL? menu

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Else's Avatar Private
    Reputation
    1
    Join Date
    Apr 2010
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [ArcEmu] Host not alloud to connect to MySQL?

    Hey. I have used Dynamic DNS to make a Host. Port forwarded all the ports needed. (Computer firewall is off also) I have a problem while trying to open the Logonserver.exe. I have filled the configs the best i could, im thinking it's probably because some of it is filled out incorrectly. When i launch logonserver.exe ( yes mySQL is running ) it states, "Connection failed due to ; ......(host) is not alloud to connect to this MySQL server". Before this error started occuring ( i could log on myself before i edited some configs) the world.exe and everything worked fine.. BUT, i think i still have the Authenticating problem with world.exe, but i don't know cause i can't get that far anymore. Here are my configs. Oh and yes i do have a space at the end of ALL my config files in the configs folder. I am trying to make the private server public... btw.. Any help would be greatly appreciated and will get +rep.

    Logon.conf

    /***********************************************************************
    * ArcEmu Logonserver Configuration File
    * Last edited: 7/18/09
    ***********************************************************************
    * Configure the logonserver to connect to the accounts database below *
    ***********************************************************************
    * LogonDatabase.Host - The hostname that the database is located on
    * LogonDatabase.Username - The username used for the mysql connection
    * LogonDatabase.Password - The password used for the mysql connection
    * LogonDatabase.Name - The database name
    * LogonDatabase.Port - Port that MySQL listens on. Usually 3306.
    * LogonDatabase.Type - Client to use. 1 = MySQL
    * Not supported: - 2 = PostgreSQL (Partly implemented)
    * Not Supported: - 3 = SQLite (unimplemented)
    ***********************************************************************/

    <LogonDatabase Hostname = "forsakenlegends.gotdns.com"
    Username = "root"
    Password = "ascent"
    Name = "logon"
    Port = "3306"
    Type = "1">


    /* Host Directive
    *
    * This is the address that the realmlist will listen on.
    * To listen on all addresses, set it to 0.0.0.0
    * Default: 127.0.0.1 (localhost)
    *
    * Note: ISHost is the interserver communication listener.
    */

    <Listen Host = "0.0.0.0"
    ISHost = "0.0.0.0"
    RealmListPort = "3724"
    ServerPort = "8093">

    /* Server console logging level
    *
    * This directive controls how much output the server will
    * display in it's console. Set to 0 for none.
    * 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
    * Default: 3
    */

    <LogLevel Screen = "0"
    File = "-1">

    /* Account Refresh Time
    *
    * This controls on which time interval accounts gets
    * refreshed. (In seconds)
    * Default = 600
    * 600 seconds = 10 minutes - 1 second = 0.0166666667 minutes 300 seconds = 5 minutes, 150 seconds = 2.5minutes
    *
    */

    <Rates AccountRefresh = "600">

    /* Accepted Build Range Setup
    *
    * These two directives set up which clients will be
    * allowed to authenticate with the realm list.
    *
    * Set these to the same builds that the server was
    * compiled for.
    *
    * As of the last update, version 3.3.3 was build 11685, patch 3.3.3a is 11723.
    */

    <Client MinBuild = "11685"
    MaxBuild = "11723">

    /* WorldServer Setup
    *
    * RemotePassword
    * This directive controls the password used to authenticate with the worldserver.
    * It must be the same between the two configs. If it is not, your server will
    * not register.
    *
    * Default: "change_me_logon"
    *
    * AllowedIPs
    * This section MUST be completed, otherwise all attempts to link your servers will fail.
    * These "Allowed" fields are a space-seperated list of CIDR-form IP addresses that are allowed
    * to make server connections to your logonserver, and register realms.
    * For example, everything in the 127.0.0.* range would be:
    * 127.0.0.0/24, as 24 of the bits must match the 127.0.0.0
    *
    * To allow a single IP,
    * 1.3.3.7/32, would allow only 1.3.3.7 to connect as 32 of the bits must match.
    *
    * AllowedModIPs
    * In the same form as AllowedIPs, these are the IPs that are allowed to modify the database
    * (adding bans, GMs, account permissions, etc)
    */

    <LogonServer RemotePassword = "ascent"
    AllowedIPs = "127.0.0.1/24"
    AllowedModIPs = "127.0.0.1/24">


    Realms.conf

    /***********************************************************************
    * ArcEmu Realms Configuration File
    * Last edited: 7/18/09
    *
    * Configure ArcEmu's Realms below
    ***********************************************************************/

    /******************************************************
    * LogonServer Section
    *
    * Address:
    * The address (no port) of the server.
    *
    * Port:
    * The port on which the logon server listens. (*** NOT 3724 ***)
    *
    * Name:
    * Not really relavant, but name the logon.
    *
    * RealmCount:
    * The number of realms in the next section.
    *
    ******************************************************/

    <LogonServer Address = "forsakenlegends.gotdns.com"
    Port = "8093"
    Name = "Default Logon"
    RealmCount = "2">

    /******************************************************
    * Realm Section
    *
    * Name:
    * The name of the realm.
    *
    * Address:
    * The address (and port) of that realm.
    *
    * Icon:
    * The type of realm (PVP, Normal, RPPVP, RP)
    *
    * TimeZone:
    * The location of the server (1=Development, 2=United States, 3=Oceanic, 4=Latin America,
    * 5=Tournament, 6=Korean, 8=English, 9=German, 10=French)
    *
    * Population:
    * (0 = low, 1 = medium, 2 = high)
    *
    * Important information below
    *
    * change 127.0.0.1 to your EXTERNAL ip if you wish to have a PUBLIC server.
    * This issues come up a lot!
    *
    * Timezone values :
    * 0=Korean 16=China
    * 1=Development 17=CN1
    * 2=United States 18=CN2
    * 3=Oceanic 19=CN3
    * 4=Latin America 20=CN4
    * 5=Tournament 21=CN5
    * 6=Korean 22=CN6
    * 8=English 23=CN7
    * 9=German 24=CN8
    * 10=French 25=Tournament
    * 11=Spanish 26=Test Server
    * 12=Russian 27=Tournament
    * 13=Tournament 28=QA Server
    * 14=Taiwan 29=CN9
    * 15=Tournament 30=TestServer2
    ******************************************************/

    <Realm1 Name = "F.L. 3.3.3 FUN"
    Address = "forsakenlegends.gotdns.com:8129"
    Icon = "Normal"
    Population = "1.0"
    TimeZone = "8">



    World.conf

    /***********************************************************************
    * ArcEmu Configuration File
    * Last edited: 7/18/09
    *
    * Configure ArcEmu's world server below.
    ***********************************************************************
    ***********************************************************************
    * Database Section
    *
    * Database.Host - The hostname that the database is located on
    * Database.Username - The username used for the mysql connection
    * Database.Password - The password used for the mysql connection
    * Database.Name - The database name
    * Database.Port - Port that MySQL listens on. Usually 3306.
    * Database.Type - Client to use. 1 = MySQL
    * Not supported: - 2 = PostgreSQL (Partly implemented)
    * Not Supported: - 3 = SQLite (unimplemented)
    *******************************************************/

    <WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "world" Port = "3306" Type = "1">
    <CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "character" Port = "3306" Type = "1">


    /******************************************************
    * Listen Config
    *
    * Host
    * This is the address that the server will listen on.
    * To listen on all addresses, set it to 0.0.0.0
    * Default: 127.0.0.1 (localhost)
    *
    * WorldServerPort
    * This is the port that the world server listens on.
    * It has to be the same as what is specified in the
    * realms table in the LogonDatabase.
    * Default: 8129
    *
    ******************************************************/

    <Listen Host = "0.0.0.0"
    WorldServerPort = "8129">


    /******************************************************
    * Log Level Setup
    *
    * Console Logging Level
    * This directive controls how much output the server will
    * display in it's console. Set to 0 for none, or -1 to disable.
    * -1 = Disabled; 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
    * Default: 3
    *
    * World server packet logging feature
    * If this directive is turned on, a file called `world.log`
    * will be created in the server's directory and all packets
    * sent and received by clients will be dumped here in bfg
    * format.
    * Default: 0
    *
    * DisableCrashdumpReport
    * Disables crashdump reports, else if the build has debugging enabled,
    * arcemu-world will call ./arcemu-crashreport every time it starts, so
    * if there is a core, a crashdump will automatically be reported
    * to the tracker at sf.net
    * Needs gdb and curl
    * Linux only
    * Default: 0
    *
    ******************************************************/

    <LogLevel Screen="0" File="-1" World="0" DisableCrashdumpReport="0">


    /******************************************************
    * Server Settings
    *
    * PlayerLimit
    * This directive controls the amount of sessions that will be
    * accepted by the server before it starts to add people to
    * the server queue.
    * Default: 100
    *
    * Motd
    * This message will be displayed by the server in the chat
    * box every time any user logs on. Colors can be used in the
    * standard WoW format.
    * Default: "No MOTD specified
    *
    * Send Stats On Join
    * This directive controls whether the server will send the online player
    * count to a cilent when it enters the world.
    *
    * Breathing Setup
    * If the breathing code is causing problems or you want to run a fun server, you can disable
    * water checks by enabling this directive.
    * Default: 1
    *
    * Seperate Channels Control
    * This directive controls whether horde and alliance chats will be seperated across channels.
    * Set to 1 for blizzlike seperated channels, or 0 to allow horde/alliance to speak to each other
    * across channels.
    * Default: 0
    *
    * Compression Threshold
    * This directive controls the limit when update packets will be compressed using deflate.
    * For lower-bandwidth servers use a lower value at the cost of cpu time.
    * Default: 1000
    *
    * Queue Update Rate
    * This directive controls how many milliseconds (ms) between the updates
    * that the queued players receieve telling them their position in the queue.
    * Default: 5000 (5 seconds).
    *
    * Kick AFK Players
    * Time in milliseconds (ms) that a player will be kicked after they go afk.
    * Default: 0 (disabled)
    *
    * Connection Timeout
    * This directive specifies the amount of seconds that the client will be disconnected
    * after if no ping packet is sent. It is advised to leave it at the default.
    * Default: 180
    *
    * Realm Type
    * This is the realm type that will be used by the server to handle world pvp.
    * Default: 0 (pve)(RPPVE)
    * Other values: 1(pvp)(RPPVP)
    *
    * AdjustPriority
    * Set the server to high process priority?
    * Default: 0
    *
    * RequireAllSignatures
    * This directive controls whether the full 10 signatures will be required in order
    * to turn in a petition. Smaller servers would be better off having it turned off.
    * Default: off
    *
    * ShowGMInWhoList
    * This directive controls whether GM's will be shown in player's who lists or not.
    * Default: on
    *
    * MapUnloadTime
    * This directive controls whether to unload map cells after an idle period of <x> seconds.
    * Use on smaller servers or servers that are memory-limited. The server without cell unloading
    * can use over 1.2GB memory with all creatures loaded.
    * Default: 0
    *
    * LimitedNames
    * This directive forces all character names to be a-z and A-Z compliant.
    * Default: 1
    *
    * UseAccountData
    * This directive determines whether the account_data table is used to save custom client data.
    * May cause buggy behaviour.
    * Default: 0
    *
    * AllowPlayerCommands
    * This directive, if enabled can allow players to use commands with a '0' command group.
    * Default: 0
    *
    * EnableLFGJoin
    * If this is enabled, you can join the LFG channel without using the LFG tool.
    * Default: 0
    *
    * TimeZone
    * Set your local timezone relative to GMT here.
    * Default: 0
    *
    * Collision
    * Enable collision system (LoS checks).
    * Default: 0
    * Make sure you have collision.dll in the same folder as arcemu-world!
    *
    * DisableFearMovement (In Battlegrounds and Arenas only!)
    * Disable fear movement in arenas & battlegrounds.
    * Recommended if you do not have collision enabled!
    * Default: 0 (off) Not blizzlike
    *
    * SaveExtendedCharData
    * Enable saving extended data to characters table.
    * Recommended for armory type services.
    * Default: 0 (off)
    *
    ******************************************************/

    <Server PlayerLimit = "1000"
    Motd = "Welcome to Forsaken Legends Fun Server."
    SendStatsOnJoin = "1"
    EnableBreathing = "0"
    SeperateChatChannels = "0"
    CompressionThreshold = "1000"
    QueueUpdateInterval = "5000"
    KickAFKPlayers = "0"
    ConnectionTimeout = "180"
    RealmType = "0"
    AdjustPriority = "0"
    RequireAllSignatures = "0"
    ShowGMInWhoList = "1"
    MapUnloadTime="0"
    LimitedNames="1"
    UseAccountData="0"
    AllowPlayerCommands="0"
    EnableLFGJoin="0"
    TimeZone="0"
    Collision="0"
    DisableFearMovement="0"
    SaveExtendedCharData="0">

    /********************************************************
    * Announce Configuration
    *
    * Tag
    * Configure what is shown in front of your announces in the [] brackets.
    * Default: Staff (would give [Staff])
    *
    * GMAdminTag
    * Configure whether the <GM> or <Admin> tag is shown in announces.
    * Default: 0 (disabled)
    *
    * NameinAnnounce
    * If this is enabled the name of the person who makes an announcement will be shown in front of the msg.
    * Default: 1 (enabled)
    *
    * NameinWAnnounce
    * If this is enabled the name of the person who makes an wide-screen announcement will be shown in front
    * of the message.
    * Default: 1 (enabled)
    *
    * ShowInConsole
    * This controls whether announces are shown in the arcemu-world console or not.
    * This does not apply for the team-internal GM announce.
    * Default: 1 (enabled)
    *
    ********************************************************/
    <Announce Tag = "Staff"
    GMAdminTag = "0"
    NameinAnnounce = "1"
    NameinWAnnounce = "1"
    ShowInConsole = "1">

    /******************************************************
    * Power regeneration multiplier setup
    *
    * These directives set up the multiplier in which regen values will be
    * multiplied by every 2 seconds.
    * Powers:
    * Power1 = Mana, Power2 = Rage, Power3 = Focus (pets), Power4 = Energy
    *
    * Reputation:
    * Kill = Rep gained on kill, Quest = rep gained from quests
    *
    * Honor:
    * Honor = multiplier used to calculate honor per-kill.
    *
    * PvP:
    * PvPTimer = in ms, the timeout for pvp after turning it off. default: 5mins (300000)
    * ArenaQueueDiff = maximum difference in average rating of 2 arena teams to be matched in queue
    *
    * XP:
    * The xp that a player receives from killing a creature will be multiplied
    * by this value in order to get his xp gain.
    *
    * RestXP:
    * Amount of hours needed to get one Bubble rested XP ( one bubble is 5% of the complete XP bar)
    * Default is 8 hrs rest for one bubble. Raising this rate causes RestedXP to be earned faster,
    * F.e, setting a rate of 2 makes you require only 4 hrs reesting for 1 bubble (instead of .
    * Note that resting in a resting area (Zzz) goes 4 times faster.
    * Default: 1 (bubble every 8 hrs)
    *
    * Drop(Color):
    * These values will be multiplied by the drop percentages of the items for creatures
    * to determine which items to drop. All default to 1.
    * To allow you better control of drops, separate multipliers have been created for items
    * of each quality group.
    *
    * DropMoney:
    * This value will be multiplied by any gold looted and pickpocketed
    *
    * Save:
    * Value in milliseconds (ms) that will be between player autosaves.
    * Default: 300000 (5 minutes)
    *
    * SkillChance:
    * The chance that you have to level up a skill in melee or a profession is multiplied
    * by this value.
    * Default: 1
    *
    * SkillRate:
    * The amount of "levels" your skill goes up each time you gain a level is multiplied
    * by this value.
    *
    * ArenaMultiplier
    * Every week/day the arena points gained by a player will be multiplied by this value.
    *
    ******************************************************/

    <Rates Health="1"
    Power1="1"
    Power2="1"
    Power3="1"
    Power4="1"
    QuestReputation="1"
    KillReputation="1"
    Honor="1"
    PvPTimer="300000"
    ArenaQueueDiff="150"
    Compression="1"
    XP="1"
    QuestXP="1"
    RestXP="1"
    ExploreXP="1"
    DropGrey="1"
    DropWhite="1"
    DropGreen="1"
    DropBlue="1"
    DropPurple="1"
    DropOrange="1"
    DropArtifact="1"
    DropMoney="1"
    Save="300000"
    SkillChance="1"
    SkillRate="1"
    ArenaMultiplier2x="1"
    ArenaMultiplier3x="1"
    ArenaMultiplier5x="1">


    /******************************************************
    * GM Client Channel
    *
    * This should be set to 'gm_sync_channel' for the My_Master addon to work.
    * Default: gm_sync_channel
    *
    ******************************************************/

    <GMClient GmClientChannel = "gm_sync_channel">


    /******************************************************
    * Terrain & Collision Settings
    *
    * Set the path to the map_xx.bin files and whether unloading should be enabled
    * for the main world maps here. Unloading the main world maps when they go idle
    * can save a great amount of memory if the cells aren't being activated/idled
    * often. Instance/Non-main maps will not be unloaded ever.
    *
    * Default:
    * MapPath = "maps"
    * vMapPath = "vmaps"
    * UnloadMaps = 1
    *
    ******************************************************/

    <Terrain MapPath = "maps"
    vMapPath = "vmaps"
    UnloadMaps = "1">


    /******************************************************
    * Log Settings
    *
    * Cheaters:
    * This directive sets up the cheater logging file, if turned on any
    * cheat / packet exploit / speedhack attempts will be logged here.
    *
    * GMCommands:
    * These two directives set up the GM command logging fie. If turned on,
    * most gm commands will be logged for this file for abuse investigation, etc.
    *
    * TimeStamp:
    * Enables timestamps in logs.
    *
    ******************************************************/

    <Log Cheaters="0" GMCommands="0" TimeStamp="0">


    /******************************************************
    * Mail System Setup
    *
    * These directives control the limits and behaviour of the ingame mail system.
    * All options must have Mail prefixed before them.
    *
    * ReloadDelay
    * Controls the delay at which the database is "refreshed". Use it if you're
    * inserting mail from an external source, such as a web-based interface.
    * 0 turns it off.
    * Default: 0
    *
    * DisablePostageCostsForGM
    * Enables/disables the postage costs for GM's. DisablePostageCosts overrides this.
    * Default: 1
    *
    * DisablePostageCosts
    * Disables postage costs for all players.
    * Default: 0
    *
    * DisablePostageDelayItems
    * Disables the one hour wait time when sending mail with items attached.
    * Default: 1
    *
    * DisableMessageExpiry
    * Turns off the 30 day / 3 day after read message expiry time.
    * WARNING: A mailbox still cannot show more than 50 items at once
    * (stupid limitation in client).
    * Default: 0
    *
    * EnableInterfactionMail
    * Removes the faction limitation for sending mail messages. Applies to all players.
    * Default: 1
    *
    * EnableInterfactionMailForGM
    * Removes the faction limitation for sending mail messages, but only applies
    * to GM's. EnableInterfactionMail overrides this.
    * Default: 1
    *
    ******************************************************/

    <Mail ReloadDelay="0"
    DisablePostageCostsForGM="1"
    DisablePostageCosts="0"
    DisablePostageDelayItems="1"
    DisableMessageExpiry="0"
    EnableInterfactionMail="1"
    EnableInterfactionMailForGM="1">


    /******************************************************
    * Status Dumper Config
    *
    * These directives set up the status dumper plugin. Filename is an
    * absolute or relative path to the server binary. Interval is the
    * time that the stats will be dumped to xml.
    * Default: stats.xml / 120000 (2 minutes)
    *
    ******************************************************/

    <StatDumper FileName = "stats.xml" Interval = "120000">


    /******************************************************
    * Startup Options
    *
    * Preloading
    * This directive controls whether the entire world will be spawned at server
    * startup or on demand. It is advised to leave it disabled unless you are a
    * developer doing testing.
    * Default: off
    *
    * Background Loot Loading
    * This directive controls whether loot will be loaded progressively during
    * startup or in the background in a seperate thread. Turning it on will
    * result in much faster startup times.
    * Default: on
    *
    * Multithreaded Startup
    * This controls whether the server will spawn multiple worker threads to
    * use for loading the database and starting the server. Turning it on
    * increases the speed at which it starts up for each additional cpu in your
    * computer.
    * Default: on
    *
    * Additional Table Binding
    * You can load static item/creature/etc data into the server using this directive.
    * This way throughout database updates your custom data can be preserved.
    * Format: "sourcetable destination table,sourcetable destinationtable"
    * Example: "myitems items,mynpcs creature_names"
    * Default: ""
    *
    ******************************************************/

    <Startup Preloading = "0"
    BackgroundLootLoading = "1"
    EnableMultithreadedLoading = "1"
    LoadAdditionalTables="">

    /******************************************************
    * Flood Protection Setup
    *
    * Lines
    * This is the number of "messages" or lines that it will allow before stopping messages from
    * being sent. This counter is reset every "Seconds" seconds.
    * Default: 0 (disabled)
    *
    * Seconds
    * This is the number of seconds inbetween the Line counter being reset.
    * Default: 0 (disabled)
    *
    * SendMessage
    * If this is enabled, a "Your message has triggered serverside flood protection. You can speak again in %u seconds."
    * message will be sent upon flood triggering.
    * Default: 0
    *
    ******************************************************/

    <FloodProtection Lines = "0" Seconds = "0" SendMessage = "0">


    /******************************************************
    * LogonServer Setup
    *
    * DisablePings
    * This directive controls whether pings will be sent to the logonserver to check
    * if the connection is still "alive". Expect problems if it is disabled.
    * Default: 0
    *
    * RemotePassword
    * This directive controls the password used to authenticate with the logonserver.
    * It must be the same between the two configs. If it is not, your server will
    * not register.
    *
    ******************************************************/

    <LogonServer DisablePings = "0"
    RemotePassword = "ascent">


    /******************************************************
    * AntiHack Setup
    * Note: Most of this doesn't work as it should.
    *
    * Teleport
    * This directive controls anti-teleport hack checks will be enabled or not.
    * Default: 1
    *
    * Speed
    * This directive controls anti-speed hack checks will be performed on player movement or not.
    * Default: 1
    *
    * SpeedThreshold
    * This directive controls the threshold at which the speedhack detection will trip.
    * It's (characters' move time of distance - real move time of distance)
    * Default: -600.0
    *
    * FallDamage
    * This directive controls anti-fall damage hack checks will be performed on player movement or not.
    * Default: 1
    *
    * Flying
    * This directive controls whether flight hacks will be performed on players or not.
    * Default: 1
    *
    * FlightThreshold
    * This directive controls the height at which you must be above the vmaps height before you are flagged as "flying" and are subject to kicks.
    * Default: 10
    *
    * DisableOnGM
    * This directive controls hack checks will be disabled for GM's or not.
    * Default: 0
    *
    ******************************************************/

    <AntiHack Teleport="1"
    Speed="1"
    FallDamage="1"
    Flight="1"
    FlightThreshold="10"
    DisableOnGM="1">


    /******************************************************
    * Period Setup
    *
    * These are the periods that the server will wait before doing periodic duties. At the moment only
    * arena point calculation and honor point calculation are used here.
    *
    * Default:
    * Arena: weekly
    * Honor: daily
    * (blizzlike values)
    *
    ******************************************************/

    <Periods HonorUpdate="daily"
    ArenaUpdate="weekly"
    DailyUpdate="daily">


    /******************************************************
    * Channels Setup
    *
    * These directives control some of the aspects in the channel system.
    *
    * BannedChannels
    * If you would like to ban users from creating or joining a channel specify them here in a ';'
    * seperated list.
    * Default: ""
    *
    * MinimumLevel
    * Channel names that require a minimum level of 10 to talk, seperate names by ;
    * Default: ""
    *
    *
    ******************************************************/

    <Channels BannedChannels=""
    MinimumLevel="">


    /******************************************************
    * VoiceChat Setup
    *
    * These directives control some of the aspects in the voice chat system.
    *
    * Enabled
    * If you want to enable the voice chat system, this must be set to 1.
    * Default: "0"
    *
    * ServerIP
    * This is the IP of the voice chat server.
    * Default: "127.0.0.1"
    *
    * ServerPort
    * This is the TCP port of the voice chat server.
    * Default: "3727"
    *
    ******************************************************/

    <VoiceChat Enabled="0"
    ServerIP="127.0.0.1"
    ServerPort="3727">


    /******************************************************
    * Remote Console Setup
    *
    * These directives control the remote administration console.
    *
    * Enabled
    * If you want to enable the remote administration console, set this.
    * Default: 0
    *
    * Host
    * This is the interface the RA server listens on.
    * Default: "0.0.0.0"
    *
    * Port
    * This is the TCP port the RA server listens on. Connect to it with a regular telnet client.
    * Default: 8092
    *
    ******************************************************/

    <RemoteConsole Enabled="0"
    Host="0.0.0.0"
    Port="8092">


    /******************************************************
    * Scripting Engine Setup
    *
    * ArcEmu can support multiple script backends via the means of loading .dll files for them.
    * This section in the config can enable/disable those backends.
    *
    * LUA
    * If you would like to enable the LUA scripting backend, enable this.
    * Default: 0
    *
    ******************************************************/

    <ScriptBackends LUA="1">


    /******************************************************
    * Movement Setup
    *
    * NOTE: For any of these directives to function, movement compression has to be compiled into
    * the server.
    *
    * FlushInterval
    * This is the interval at which movement packets will be flushed to the client, i.e. compressed/sent.
    * If you have a high threshold, keeping this at 1-2 seconds will work better.
    * Default: 1000 (one second)
    *
    * CompressionRate
    * This is the deflate compression rate. Higher will use more cpu, but smaller packets.
    * Range: 1-9 (or 0 is disable)
    * Default: 1
    *
    * CompressionThreshold
    * This is the distance that will be used to determine if an object needs to be sent compressed or
    * normal. It is advised to keep it at least 30 units. This value is used for players.
    * Default: 30.0
    *
    * CompressionThresholdCreatures
    * This is the distance that will be used to determine if an object needs to be sent compressed or
    * normal. This value is used for creatures, so it can be a lot lower.
    * Default: 10.0
    *
    ******************************************************/

    <Movement FlushInterval="1000"
    CompressRate="1"
    CompressThreshold="30.0"
    CompressThresholdCreatures="10.0">


    /******************************************************
    * Localization Setup
    *
    * LocaleBindings
    * This is a list of locale names and the other locale you want to associate with them.
    * For example, to make the European client always use the french language, "enGB=frFR"
    *
    * Must be terminated by a space.
    *
    * Default: ""
    *
    ******************************************************/

    <Localization LocaleBindings="">


    /******************************************************
    * Dungeon / Instance Setup
    *
    * TakeGroupLeaderID
    * If a player doesn't have an instance id, the group isn't already assigned
    * to an instance and the group or raid leader already have one, the player will
    * be bound to the instance id of the group/raid leader.
    * Default: 1 (enabled)
    *
    * SlidingExpiration
    * If enabled, persistent instances will expire relative to the creation time.
    * Otherwise persistent instances will expire at fixed points of time. (blizz like)
    * Default: 0 (disabled)
    *
    * DailyHeroicInstanceResetHour
    * Sets the hour of day when heroic instances will be resetted on disabled SlidingExpiration.
    * Default: 5
    *
    * CheckTriggerPrerequsites
    * Entering & checks
    * Default: 1
    ******************************************************/

    <InstanceHandling TakeGroupLeaderID="1"
    SlidingExpiration="0"
    DailyHeroicInstanceResetHour="5"
    CheckTriggerPrerequsites="1" >


    /******************************************************
    * BattleGround settings
    * Set Rules for Min / Max players ---- PS.Min for each side | Max for Total
    *
    * AlteracValley
    * AV_MIN
    * AV_MAX
    *
    * ArathiBasin
    * AB_MIN
    * AB_MAX
    *
    * WarSong
    * WS_MIN
    * WS_MAX
    *
    * Eyes Of The Storm.
    * EOS_MIN
    * EOS_MAX
    *
    ******************************************************/
    <Battleground AV_MIN="0"
    AV_MAX="40"
    AB_MIN="4"
    AB_MAX="15"
    EOS_MIN="4"
    EOS_MAX="15"
    WS_MIN="2"
    WS_MAX="10"
    SOTA_MIN="10"
    SOTA_MAX="15">

    /*****************************************************
    * Arena Settings
    *
    * Allows you to control current season and its progress.
    *
    * Season - has to be higher than 0 for arenas to work.
    * Progress - sets the progress, 0 = finished, 1 = in progress
    *
    *****************************************************/
    <Arena Season = "5"
    Progress = "1">

    /*****************************************************
    * StartOnGMIsland
    *
    * Makes GM Characters start on GM Island
    *
    * Also sets their bind location to GM Island
    * Default:1 (Yes)
    *
    *****************************************************/
    <GameMaster StartOnGMIsland = "1">

    /*****************************************************
    * Limits settings
    *
    * Enable
    * Enable damage/hp/mana caps
    * Default value: 1 (enabled)
    * AutoAttackDmg
    * Maximum damage allowed for auto-attack (swing)
    * Default value: 10000
    * SpellDmg
    * Maximum damage allowed for a spell
    * Default value: 30000
    * Health
    * Maximum health allowed for a player
    * Default value: 100000
    * Mana
    * Maximum mana allowed for a player
    * Default value: 80000
    * Disconnect
    * Disconnect player that exceeds limits above
    * Default value: 0 (disabled)
    * BroadcastGMs
    * Broadcast a message to online GMs when max damage/hp/mana has been exceeded (possible cheating)
    * Default value: 1 (on)
    *
    * Set any of the values above to 0 to disable that setting (for example, set SpellDmg="0" to disable only spell damage limit)
    *
    *****************************************************/

    <Limits Enable="1" AutoAttackDmg="10000" SpellDmg="30000" Health="100000" Mana="80000" Disconnect="0" BroadcastGMs="1">
    Last edited by Else; 04-27-2010 at 06:11 PM.

    [ArcEmu] Host not alloud to connect to MySQL?
  2. #2
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Change the parts i changed; to what i changed it too.

    Code:
    <LogonDatabase Hostname = "localhost"
    Username = "root"
    Password = "ascent"
    Name = "logon"
    Port = "3306"
    Type = "1">
    
    <LogonServer Address = "127.0.0.1"
    Port = "8093"
    Name = "Default Logon"
    RealmCount = "1">
    Also, use [code] tags next time.




  3. #3
    Else's Avatar Private
    Reputation
    1
    Join Date
    Apr 2010
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, i can log in now. But it just sits at logging into game server, after i try to enter my Realm.

  4. #4
    nazgul111's Avatar Site Donator The Faithless
    Reputation
    256
    Join Date
    Apr 2010
    Posts
    303
    Thanks G/R
    20/14
    Trade Feedback
    2 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just try few time turning off wow and then turning on, i got this like every time i start the server, i have to turn on and off wow twice to get it work good luck

  5. #5
    Else's Avatar Private
    Reputation
    1
    Join Date
    Apr 2010
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok Naz, i tryed over 5 times, first two it logged me on, i clicked on realm, sat on logging into game server, then returned me back to realm. 3rd time i went to log on it stuck at handshaking for 5 minutes, so i hit cancel and it brought me to realmlist. then i hit enter, then back to logging on to game server. I tried with different accounts and got the same error, i also tried on a different computer (seperate ips) and got unable to connect. i got no errors on mysql or logonserver.exe or world.exe... maybe its my system32/drivers/etc/hosts? i am on windows xp btw if i have not stated.

    Here is my hosts file, just in case.

    127.0.0.1 forsakenlegends.gotdns.com
    192.168.1.64 forsakenlegends.gotdns.com
    75.157.174.62 forsakenlegends.gotdns.com
    (oh and for the 127.0.0.1, i have tried that and put localhost after it, same result with both)

  6. #6
    anitab's Avatar Private
    Reputation
    -2
    Join Date
    Apr 2010
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    try this.....

    i can always get on to wow by unplugging and plugging back in.

    hope it helps.











    anitab

  7. #7
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try and remove the changes you did to the hosts file and see what happens then.




  8. #8
    Link_S's Avatar Member
    Reputation
    125
    Join Date
    Dec 2008
    Posts
    293
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wall of text hits me right in the face, better scroll down to the bottom.

    PLEASE USE CODE TAGS!

    Did you apply necessary database updates?
    Why do I need a signature?

  9. #9
    Else's Avatar Private
    Reputation
    1
    Join Date
    Apr 2010
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1 im new dont get mad about Code Tags. Btw code tags in the name?
    Kiev. Same result.

    Link_S, If you mean the update the files in the DBC, then no.

  10. #10
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wrap the configs in [code] tags, I.E:

    [code]
    Config files here
    [ /code]

    Are you still receiving the error in logonserver? If so, make sure your password and database names in logon.conf match up to what they are meant to be.




  11. #11
    Link_S's Avatar Member
    Reputation
    125
    Join Date
    Dec 2008
    Posts
    293
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    @Else
    It wasn't my point to be bitchy about the code tags, it's just cause it's a pain to read without them "/

    I meant the database updates, both for World and Logon.
    They're in this directory
    <root arcemu directory>/sql

    Why do I need a signature?

  12. #12
    Else's Avatar Private
    Reputation
    1
    Join Date
    Apr 2010
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Kiev, i am not getting any more errors, but, the Database names in both logon.conf and world.conf are different, if this is what you meant :P,
    and Link_s, I dont see the <root arcemu directory>/sql, what folder would it be in

    [World.conf]
    <WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "world"
    <CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "character"
    [/World.conf]

    [Logon.conf]
    LogonDatabase Hostname = "localhost"
    Username = "root"
    Password = "ascent"
    Name = "logon"
    [/Logon.conf]

    'Sorry if i used code tags wrong again :P lol, i tried.'
    Last edited by Else; 04-30-2010 at 09:22 AM.

  13. #13
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Heh, you dont need to put the name of the conf in them, just [code] .

    When you look inside your Database, what are your databases called? Im going to preusme one of them isn't "character" but yet, "logon"




  14. #14
    Else's Avatar Private
    Reputation
    1
    Join Date
    Apr 2010
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you mean by database Server/mysql/data.
    then yes there is a Character folder there, and a logon one, world and mysql (the folders)

  15. #15
    Else's Avatar Private
    Reputation
    1
    Join Date
    Apr 2010
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, i found something online, changed it, and i can now log on. Thanks Kiev for all the help
    i would +rep again, but it doesn't let me xD

Page 1 of 2 12 LastLast

Similar Threads

  1. [SQL] Host 'PC name' is not allowed to connect to this mysql server
    By dewboat in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 07-17-2014, 06:57 PM
  2. host cant connect to mysql help plz
    By david12 in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 07-11-2009, 12:41 AM
  3. Host is not allowed to connect mysql HELP +rep
    By david12 in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 07-10-2009, 02:15 PM
  4. Host 'PC name' is not allowed to connect to this mysql server
    By gurpreet in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 08-25-2008, 05:01 AM
  5. host "my IP" is not allowed to connect to this MySQL server
    By ledz14 in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 06-18-2008, 02:51 AM
All times are GMT -5. The time now is 03:54 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search