>>> HOWTO Setup Your Wrath of the Lich King Beta SeRvEr! <<<

[billy1arm]

pls help me ;(

2008-09-12 13:28:13 World Database: 127.0.0.1;3306;root;mangos;database
2008-09-12 13:28:13 MySQL client library: 5.0.56
2008-09-12 13:28:13 MySQL server ver: 5.0.45-community-nt-log
2008-09-12 13:28:13 Character Database: 127.0.0.1;3306;root;mangos;database
2008-09-12 13:28:13 MySQL client library: 5.0.56
2008-09-12 13:28:13 MySQL server ver: 5.0.45-community-nt-log
2008-09-12 13:28:13 Login Database: 127.0.0.1;3306;root;mangos;database
2008-09-12 13:28:13 MySQL client library: 5.0.56
2008-09-12 13:28:13 MySQL server ver: 5.0.45-community-nt-log
2008-09-12 13:28:13 Realm running as realm ID 1
2008-09-12 13:28:13 Using UDB 0.10.3 (35 for MaNGOS rev. 6346 with SD2 SQL for rev. 502 Database modified for WotLK Beta by Mogrein
2008-09-12 13:28:13 Using DataDir ./
2008-09-12 13:28:13 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-09-12 13:28:13 WORLD: VMap data directory is: ./vmaps
2008-09-12 13:28:13 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-09-12 13:28:15
2008-09-12 13:28:15 Loading MaNGOS strings...
2008-09-12 13:28:15
2008-09-12 13:28:15 >> Loaded 515 MaNGOS strings
2008-09-12 13:28:15 Initialize data stores...
2008-09-12 13:28:17 ERROR:
Some required *.dbc files (2 from 55) not found or not compatible:
./dbc/CreatureDisplayInfo.dbc (exist, but have 15 fields instead 16) Wrong client version DBC file?
./dbc/Spell.dbc (exist, but have 221 fields instead 222) Wrong client version DBC file?

The version of the Game that your extracted the DBC files from does not match the version of the Game that Mangos is expecting.

If mangos is expecting 2.4.3.8606 (for example), then your client needs to be patched to the same version before you extract the files.

[billy1arm]

i have a big problem with the mangos.sql, and it is, i only can get 5 mb, out of the 120 mb or how much it is... It´s just stop when i have 5 mb and the computer freeze...

can i get some help about that?

I had this problem when the server i was trying to import it into was running low and memory/ disk space.

One disk cleanup and reboot later....

[billy1arm]

I was going through the Account Tables for your WOTLK server. And there seems not to be a password table, is the password the name of the account aswell?

The Password is held in the I field as an encoded password:

All is not lost.....

Look in your account table for the ID of the user password you need to change, then replace x in the examples below..


Change password:

UPDATE `account` SET `I` = SHA1(CONCAT(UPPER(`username`),':',('passwordxyz'))) WHERE `id` = x;


Change username:

UPDATE `account` SET `username` = 'new_uname', `I` = SHA1(CONCAT(UPPER('new_uname'),':',('passwordxyz'))) WHERE `id` = x;


Create new account:

INSERT INTO `account` (`username`,`I`) VALUES ('username', SHA1(CONCAT(UPPER('username'),':',('password'))));

[SuperSirius]

I can't make a deathknight for some odd reason.

[wrior]

I keep getting an error but i have no idea what it means, "2008-09-20 11:36:33 Loading Creature templates...
2008-09-20 11:36:34 ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql)."

[riepdiep]

I have a probleme whit: 4.Execute each database with the matching one , "Realmd" with Realmd.sql , "mangos" with mangos.sql "Characters" with Characters.sql and "scriptdev2" with scriptdev2.sql
It gives me errors

[riepdiep]

This is the error i get : [Err] 1074 - Column length too big for column 'TabText' (max = 255); use BLOB or TEXT instead
[Err] CREATE TABLE `guild_bank_tab` (
`guildid` int(11) unsigned NOT NULL default '0',
`TabId` tinyint(1) unsigned NOT NULL default '0',
`TabName` varchar(100) NOT NULL default '',
`TabIcon` varchar(100) NOT NULL default '',
`TabText` varchar(500) NOT NULL default '',
PRIMARY KEY (`guildid`,`TabId`),
KEY `guildid_key` (`guildid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Could anyone please help me ??

[Guysus]

how do i get to the new land ?

[PoeTheGhost]

Did you bother looking in your SQL Databases?

Penny for your thoughts. twocents

[PoeTheGhost]

I have a probleme whit: 4.Execute each database with the matching one , "Realmd" with Realmd.sql , "mangos" with mangos.sql "Characters" with Characters.sql and "scriptdev2" with scriptdev2.sql
It gives me errors

Try posting the errors in your "halp" post, and btw, it says "No Questions Here" right ^ up there^.

[wintersp0ken]

FIXED- I opened it in heidi instead, and it's working just fine, now.


Hello, I have a problem; Whenever I try to execute the realmd file in navicat the account table is not created.I'm rather inexperienced in this sort of thing, or I suppose I could create the table myself.

I've read back over the guide very carefully, and followed everything word for word, but is there something I'm missing?

Any help would be greatly appreciated, thanks.

Also, the 'message log' from when I try to execute realmd.

[Err] 1074 - Column length too big for column 'email' (max = 255); use BLOB or TEXT instead
[Err] CREATE TABLE `account` (
`id` bigint(20) 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` varchar(320) NOT NULL default '',
`joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`last_ip` varchar(30) NOT NULL default '127.0.0.1',
`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',
`online` tinyint(4) NOT NULL default '0',
`tbc` 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=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';
[Err] 1146 - Table 'realmd.account' doesn't exist
[Err] -- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `account` VALUES ('1', 'administrator', 'a34b29541b87b7e4823683ce6c7bf6ae68beaaac', '3', '', '0', '0', '', '2006-04-25 18:18:56', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0', '0', '0', '0');
[Err] 1146 - Table 'realmd.account' doesn't exist
[Err] INSERT INTO `account` VALUES ('2', 'gamemaster', '7841e21831d7c6bc0b57fbe7151eb82bd65ea1f9', '2', '', '0', '0', '', '2006-04-25 18:18:56', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0', '0', '0', '0');
[Err] 1146 - Table 'realmd.account' doesn't exist
[Err] INSERT INTO `account` VALUES ('3', 'moderator', 'a7f5fbff0b4eec2d6b6e78e38e8312e64d700008', '1', '', '0', '0', '', '2006-04-25 18:19:35', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0', '0', '0', '0');
[Err] 1146 - Table 'realmd.account' doesn't exist
[Err] INSERT INTO `account` VALUES ('4', 'player', '3ce8a96d17c5ae88a30681024e86279f1a38c041', '0', '', '0', '0', '', '2006-04-25 18:19:35', '127.0.0.1', '0', '0', '0000-00-00 00:00:00', '0', '0', '0', '0');
[Msg] Finished - Unsuccessfully

[jamster345]

hi!
i'm french and i want know if it could be work with the french wotlk beta ?

[Simpzzz]

i cant get it to work it says Could not connect to MySQL database at 127.0.0.1: Unknown database 'mangosd'

Cannot connect to world database 127.0.0.1:3306:root:root:mangosd
it says this every time i turn on mangosd.exe

[RoflmaoWoW]

if i install this will i still be able to play retail before WOTLK comes out?

[Gazebo]

Ok, how the freak do i fly in northrend? I cant cast summon netherdrake or anything like that and their isnt a fly command (tried .fly and .flymode) so wtf? how do i get to nexus and shit like that without flying?