[Help] Server won't go online.

[Cocoa482]

Can someone help me out? I can' t get this server to go online. I've got a big feeling that i've done loads of **** done.
External IP is 24.250.1.30

so far i've got...
Realms.conf

<LogonServer Address = "24.250.1.30"
Port = "8093"
Name = "Default Logon"
RealmCount = "1">
 
<Realm1 Name = "Demoni WoW Main Server"
Address = "24.250.1.30:8129"
Icon = "Normal"
Colour = "2"
Population = "1"
TimeZone = "1">

logonserver.conf

LogonDatabase Section

 
<LogonDatabase Hostname = "host"
               Username = "user"
               Password = "pass"
               Name     = "db"
               Port     = "3306"
               Type     = "1">
 

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

    Default: 3
 
<LogLevel Screen = "0"
          File = "-1">
Account Refresh Time
    This controls on which time interval accounts gets 
    refreshed. (In seconds)
    Default = 300
 
<Rates AccountRefresh = "60">

    As of the last update, version 2.1.1 was build 6739.
 
<Client MinBuild = "6739"
        MaxBuild = "6898">
WorldServer Setup
    Default: "change_me_logon"
 
[B]<LogonServer RemotePassword = "wookie">[/B]

<WorldDatabase Hostname = "127.0.0.1" Username = "root" Password = "root" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "127.0.0.1" Username = "root" Password = "root" Name = "ascentlogon" Port = "3306" Type = "1">
 

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

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

<Server PlayerLimit = "100"
        Motd = "No MOTD specified."        
        SendBuildOnJoin = "1"
        SendStatsOnJoin = "1"
        EnableBreathing = "1"
        LevelCap = "255"
        GenLevelCap = "70"
        SeperateChatChannels = "0"
        CompressionThreshold = "1000"
        QueueUpdateInterval = "5000"
        KickAFKPlayers = "0"
        ConnectionTimeout = "180"
        RealmType = "1"
        AdjustPriority = "0"
        RequireAllSignatures = "0"
        ShowGMInWhoList = "1"
        MapUnloadTime="0"
        LimitedNames="1"
        UseAccountData="0">
 
<Rates Health="1"
       Power1="1"
       Power2="1"
       Power3="1"
       QuestReputation="1"
       KillReputation="1"
       Honor="1"
       PvPTimer="300000"
       Compression="1"
       XP="1"
       QuestXP="1"
       RestXP="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">
 
 
<GMClient ReqGmClient = "0" GmClientChannel = "gm_sync_channel">
 
 
<Terrain MapPath = "maps" UnloadMaps = "1">
 
 
<Log Cheaters="0" GMCommands="0">
 
 
<Mail ReloadDelay="0"
      DisablePostageCostsForGM="1"
      DisablePostageCosts="0"
      DisablePostageDelayItems="1"
      DisableMessageExpiry="0"
      EnableInterfactionMail="1"
      EnableInterfactionMailForGM="1">
 
 
<StatDumper FileName = "stats.xml" Interval = "120000">
 
 
<Startup Preloading = "0"
         BackgroundLootLoading = "1"
         EnableMultithreadedLoading = "1"
         LoadAdditionalTables="">
 
<FloodProtection Lines = "0" Seconds = "0" SendMessage = "0">
 
 
<LogonServer DisablePings = "0"
             RemotePassword = "youtube">
 
<AntiHack Teleport="0"
          Speed="0"
          FallDamage="0"
          Flying="0"
          DisableOnGM="0">
 
 
<Periods HonorUpdate="daily"
         ArenaUpdate="weekly">
 
 
<AscentStats Enable="1"
             ServerGUID="NONE"
             ServerKey="NONE">
 
 
<Channels BannedChannels=""
          GeneralChannels="General -;Trade -;LookingForGroup;GuildRecruitment;LocalDefense;WorldDefense;">
 
<VoiceChat Enabled="0"
           ServerIP="127.0.0.1"
           ServerPort="3727">
 
 
<RemoteConsole Enabled="0"
               Host="0.0.0.0"
               Port="8092">
 
<Localization LocaleBindings="">

 

[zipper20032]

First problem is change user and password with user-root and password - password of your MySQL
2nd Look at your RemotePassword in both, Logonserver and Ascent conf.. must be the same , in your case wookie, put MaxBuild 9999 to enter with patch 2.1.1 and the Lastest patch (2.3.3)
3rd Look in ascent.conf you see root, and password root, modify only the password with your mysql password!
4th make sure the database=(your database name from navicat or what you use)
5th make sure you have a database install and MySQL

 

[Cocoa482]

I got errors from both clients...



Logon said : Cannot connect user to root @ localhost



Ascent said : Main database initialisation failed.



Could you make it so I can understand it a bit better? I'm somewhat lacking in knowledge of this.

I've got MySQL, Navicat and all that set up.

 

[Cocoa482]

****! sorry for double post!

 

[Cody900]

Coca, in your logonserver.config

You have this:

<LogonDatabase Hostname = "host"
Username = "user"
Password = "pass"
Name = "db"
Port = "3306"
Type = "1">

You need to change it. Change the username to your actual username, change the password to your password, and change the database name to your logon database.

It should be like this (info taken from your world.config, should be right if your world.conf is):

<LogonDatabase Hostname ="localhost"
Username = "root"
Password = "root"
Name = "ascentlogon"
Port = "3306"
Type = "1">

 

[madjock]

looks like you don't have Mysql running and no DB installed pretty much as zipper has said above.

I would recommend following one of the guides in the forums here as a number of them are well laid out and easy enough to follow. If you don't wish to do that can you answer the following to give me a start point.

Have you installed Wamp , Xxamp or Mysql server ?
Have you created character, world and login DB's from a NCDB rev ?
If so have you carried out the changes Zipper advised above ?

A screen shot of errrors would be helpfull.

/MJ

 

[rr2739]

u got a problem here

(hamachi ip got to go lol)

<Listen Host = "5.39.47.105" <.........................change to 0.0.0.0
WorldServerPort = "8129">

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


also go to dyndns.com and make a host account for free

and change


<Realm1 Name = "Demoni WoW Main Server"

Address = "24.250.1.30:8129" <............... to your new dynds host

Icon = "Normal"

Colour = "2"

Population = "1"

TimeZone = "1">