Trying to login to my new server, but its telling me I need to merge with battle.net?

[tbdcarakias]

Created a MaNGOS server from scratch. When I try to login, it tells me the account needs to be merged.

Did I forget to edit a file or something?

[Ground Zero]

You forgot to make a new realmlist.wtf I assume, make a new txt file save it as realmlist.wft with the following information inside "Set realmlist 127.0.0.1" < localhost.

[tbdcarakias]

I just delete the old one? In the enUS folder?

[Sounddead]

Or you can edit it with notepad.

[tbdcarakias]

I dont mess with the config file in the WTF folder at all, correct? It should say in that the realmlist and patchserver are still the default WoW ones?

[tbdcarakias]

Tried changing the file in the enUS folder... set the realmlist to 127.0.0.1 and it just says unable to connect, also tried localhost, same result =/

Weird thing is I can connect to the database just fine with SQLYog.

edit: Sorry for the double post.

[Laniax]

Close any WoW window you have open

Open your realmlist.wtf with notepad

make sure it says exactly this.

set realmlist 127.0.0.1

Save the file and start WoW with the wow.exe

???

Profit!

[tbdcarakias]

I did exactly as you said, still unable to connect.

I guess I botched the entire server setup process somewhere.

Normally I use a repack but I was tired of my city guards not giving directions, monsters having no LoS (running through walls, dying in the ground, etc) and wanted to make one from scratch.

Been trying for 2 days, about to call it quits, or try ArcEmu instead of Mangos.

Ugh =(

[Laniax]

make sure the loginserver is running without error. it should get you connected, if not then theres a config issue i guess.

I suggest you look around at some compiling guides around the forums.

[tbdcarakias]

make sure the loginserver is running without error. it should get you connected, if not then theres a config issue i guess.

I suggest you look around at some compiling guides around the forums.

What do you mean by this? I am able to connect to the database in SQLYog and Navicat. Does that mean its running without error but I messed something up somewhere?

[Le Froid]

Post realmd.conf and mangosd.conf

[tbdcarakias]

LoginDatabaseInfo = "127.0.0.1;3306;root;root;realmd"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 0
LogTime = 0
LogFile = "Realmd.log"
LogTimestamp = 0
LogFileLevel = 0
LogColors = ""
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0

RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo     = "127.0.0.1;3306;root;root;realmd"
WorldDatabaseInfo     = "127.0.0.1;3306;root;root;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;root;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"

[Le Froid]

make sure after it says root in your conf to put your mysql pass and if you used an old db add all the sql updates to your database.

If that doesnt work then look here to see if you skipped a step in installation - MangosWiki Setting up MaNGOS - MangosWiki

[tbdcarakias]

Think I know what went wrong but no idea how to fix it. When I was supposed to do the SQL dumps, some of them wouldnt work. The guide I followed said to do them in numerical order, which I did, but half of them wouldn't work without catching an error.

I figured this was because my database was up to date or something, but now I'm starting to wonder if I just messed the whole thing up somehow.

If I wanted to start from scratch, do I just need to delete the MaNGOS folder with everything in it, or is there more, behind-the-background kinda deleting I need to do?

[Le Froid]

Heres a dump of my realmd database for the latest mangos rev:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `account`
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
  `username` varchar(32) NOT NULL DEFAULT '',
  `sha_pass_hash` varchar(40) NOT NULL DEFAULT '',
  `gmlevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `sessionkey` longtext,
  `v` longtext,
  `s` longtext,
  `email` text,
  `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_ip` varchar(30) NOT NULL DEFAULT '0.0.0.0',
  `failed_logins` int(11) unsigned NOT NULL DEFAULT '0',
  `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active_realm_id` int(11) unsigned NOT NULL DEFAULT '0',
  `expansion` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mutetime` bigint(40) unsigned NOT NULL DEFAULT '0',
  `locale` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';

-- ----------------------------
-- Table structure for `account_banned`
-- ----------------------------
DROP TABLE IF EXISTS `account_banned`;
CREATE TABLE `account_banned` (
  `id` int(11) NOT NULL DEFAULT '0' COMMENT 'Account id',
  `bandate` bigint(40) NOT NULL DEFAULT '0',
  `unbandate` bigint(40) NOT NULL DEFAULT '0',
  `bannedby` varchar(50) NOT NULL,
  `banreason` varchar(255) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`,`bandate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Ban List';

-- ----------------------------
-- Records of account_banned
-- ----------------------------

-- ----------------------------
-- Table structure for `ip_banned`
-- ----------------------------
DROP TABLE IF EXISTS `ip_banned`;
CREATE TABLE `ip_banned` (
  `ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  `bandate` bigint(40) NOT NULL,
  `unbandate` bigint(40) NOT NULL,
  `bannedby` varchar(50) NOT NULL DEFAULT '[Console]',
  `banreason` varchar(255) NOT NULL DEFAULT 'no reason',
  PRIMARY KEY (`ip`,`bandate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Banned IPs';

-- ----------------------------
-- Records of ip_banned
-- ----------------------------
-- ----------------------------
-- Table structure for `realmcharacters`
-- ----------------------------
DROP TABLE IF EXISTS `realmcharacters`;
CREATE TABLE `realmcharacters` (
  `realmid` int(11) unsigned NOT NULL DEFAULT '0',
  `acctid` bigint(20) unsigned NOT NULL,
  `numchars` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`realmid`,`acctid`),
  KEY `acctid` (`acctid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm Character Tracker';


-- ----------------------------
-- Table structure for `realmd_db_version`
-- ----------------------------
DROP TABLE IF EXISTS `realmd_db_version`;
CREATE TABLE `realmd_db_version` (
  `required_9010_01_realmd_realmlist` bit(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';

-- ----------------------------
-- Records of realmd_db_version
-- ----------------------------
INSERT INTO `realmd_db_version` VALUES (null);

-- ----------------------------
-- Table structure for `realmlist`
-- ----------------------------
DROP TABLE IF EXISTS `realmlist`;
CREATE TABLE `realmlist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  `address` varchar(32) NOT NULL DEFAULT '127.0.0.1',
  `port` int(11) NOT NULL DEFAULT '8085',
  `icon` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `color` tinyint(3) unsigned NOT NULL DEFAULT '2',
  `timezone` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `population` float unsigned NOT NULL DEFAULT '0',
  `realmbuilds` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System';

-- ----------------------------
-- Records of realmlist
-- ----------------------------
INSERT INTO `realmlist` VALUES ('1', 'YOUR REALM', '127.0.0.0', '8085', '1', '0', '2', '0', '0.02', '10505 ');

-- ----------------------------
-- Table structure for `uptime`
-- ----------------------------
DROP TABLE IF EXISTS `uptime`;
CREATE TABLE `uptime` (
  `realmid` int(11) unsigned NOT NULL,
  `starttime` bigint(20) unsigned NOT NULL DEFAULT '0',
  `startstring` varchar(64) NOT NULL DEFAULT '',
  `uptime` bigint(20) unsigned NOT NULL DEFAULT '0',
  `maxplayers` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`realmid`,`starttime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';

delete your old one and put that one in.then create a new account and start realmd.exe to see if you can connect.

n for your other databases copy the sql files off of UDB or w/e database you use and run mangosd.exe

if that dont work i have no clue whats wrong

edit: To start over delete everything in your databases and recompile and configure mangos again w/ a new database