X-Forums

Computer, Games, and Technology

Error connecting to database

12 posts

  1. beatson

    Member
    Joined: Sep '08
    Posts: 8

    Hi, i keep gettin this error message when i run the mangosd and realmd

    Mangosd:

    2008-09-02 16:56:11 Using configuration file mangosd.conf.
    2008-09-02 16:56:11 Reaper-X UR1 Arcane-Fire
    2008-09-02 16:56:11 Goto http://www.reaper-x.com for more info!
    2008-09-02 16:56:11 Press <Ctrl-C> to stop.

    ARCANE-FIRE
    www.Reaper-X.com
    ------------------------------------------
    Thanks to the Reaper-X Team:
    -Reaper
    -Oatman
    -Colt45
    ------------------------------------------
    Uses Revs:
    -MaNGOS 6399
    -SD2 525
    -UDB 358
    -ACID 18
    -AH Bot 79

    2008-09-02 16:56:11 Arcane-Fire Continue...
    2008-09-02 16:56:11 World Database: 127.0.0.1;3306;root;mangos;mangos
    2008-09-02 16:56:11 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

    2008-09-02 16:56:11 ERROR:Cannot connect to world database 127.0.0.1;3306;root;mangos;mangos

    Realmd:

    2008-09-02 16:52:25 Using configuration file realmd.conf.
    2008-09-02 16:52:25 MaNGOS/0.12.0-SVN (Revision 6407) (Win32,little-endian) (realm-daemon)
    2008-09-02 16:52:25 <Ctrl-C> to stop.

    2008-09-02 16:52:25 Database: 127.0.0.1;3306;root;mangos;realmd
    2008-09-02 16:52:25 ERROR:Could not connect to MySQL database at 127.0.0.1: Access denied for user 'root'@'localhost' (using password: YES)

    2008-09-02 16:52:25 ERROR:Cannot connect to database

    any idea on how to fix this?

    Posted 1 year ago » Permalink

  2. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    open your .conf files and look for the following lines:

    LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
    WorldDatabaseInfo = "127.0.0.1;3306;root;mangos;mangos"
    CharacterDatabaseInfo = "127.0.0.1;3306;root;mangos;characters"

    LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"

    ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;mangos;scriptdev2"

    replace them with:

    LoginDatabaseInfo = "127.0.0.1;3306;root;[yourmysqlpassword];realmd"
    WorldDatabaseInfo = "127.0.0.1;3306;root;[yourmysqlpassword];mangos"
    CharacterDatabaseInfo = "127.0.0.1;3306;root;[yourmysqlpassword];characters"

    LoginDatabaseInfo = "127.0.0.1;3306;root;[yourmysqlpassword];realmd"

    ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;[yourmysqlpassword];scriptdev2"

    Posted 1 year ago » Permalink

  3. beatson

    Member
    Joined: Sep '08
    Posts: 8

    ok, thanks, but now it says that the dir is wrong for the map files

    Posted 1 year ago » Permalink

  4. beatson

    Member
    Joined: Sep '08
    Posts: 8

    ok sorted now, but now i get loads of SQL errors

    Posted 1 year ago » Permalink

  5. beatson

    Member
    Joined: Sep '08
    Posts: 8

    this is what i get:

    2008-09-02 22:28:52 Using configuration file mangosd.conf.
    2008-09-02 22:28:52 Reaper-X UR1 Arcane-Fire
    2008-09-02 22:28:52 Goto http://www.reaper-x.com for more info!
    2008-09-02 22:28:52 Press <Ctrl-C> to stop.

    ARCANE-FIRE
    www.Reaper-X.com
    ------------------------------------------
    Thanks to the Reaper-X Team:
    -Reaper
    -Oatman
    -Colt45
    ------------------------------------------
    Uses Revs:
    -MaNGOS 6399
    -SD2 525
    -UDB 358
    -ACID 18
    -AH Bot 79

    2008-09-02 22:28:52 Arcane-Fire Continue...
    2008-09-02 22:28:52 World Database: 127.0.0.1;3306;root;sandune;mangos
    2008-09-02 22:28:53 MySQL client library: 5.0.56
    2008-09-02 22:28:53 MySQL server ver: 5.0.67-community-nt
    2008-09-02 22:28:53 Character Database: 127.0.0.1;3306;root;sandune;characters
    2008-09-02 22:28:53 MySQL client library: 5.0.56
    2008-09-02 22:28:53 MySQL server ver: 5.0.67-community-nt
    2008-09-02 22:28:53 Login Database: 127.0.0.1;3306;root;sandune;realmd
    2008-09-02 22:28:53 MySQL client library: 5.0.56
    2008-09-02 22:28:53 MySQL server ver: 5.0.67-community-nt
    2008-09-02 22:28:53 Realm running as realm ID 1
    2008-09-02 22:28:53 Using UDB 0.10.3 (35 8) for MaNGOS rev. 6346 with SD2 SQL for rev. 502
    2008-09-02 22:28:53 Using DataDir C:/WoW/data/
    2008-09-02 22:28:53 WORLD: VMap support included. LineOfSight:0, getHeight:0
    2008-09-02 22:28:53 WORLD: VMap data directory is: C:/WoW/data/vmaps
    2008-09-02 22:28:53 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
    2008-09-02 22:28:54
    2008-09-02 22:28:54 Loading MaNGOS strings...
    2008-09-02 22:28:54
    2008-09-02 22:28:54 >> Loaded 509 MaNGOS strings
    2008-09-02 22:28:54 Initialize data stores...
    2008-09-02 22:29:01
    2008-09-02 22:29:01 >> Loaded 55 data stores
    2008-09-02 22:29:01
    2008-09-02 22:29:01 Using Autodetected DBC Locale (0).

    2008-09-02 22:29:01 Loading InstanceTemplate
    2008-09-02 22:29:01 >> Loaded 51 Instance Template definitions
    2008-09-02 22:29:01
    2008-09-02 22:29:01 Loading SkillLineAbilityMultiMap Data...
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Loaded 7025 SkillLineAbility MultiMap
    2008-09-02 22:29:02 Cleaning up instances...
    2008-09-02 22:29:02 ERROR:SQL: SELECT mapid, resettime FROM instance_reset
    2008-09-02 22:29:02 ERROR:query ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime < '1220390942' AND instance.resettime > '0') OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < '1220390942')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('249','4185389632')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('269','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('309','2140371520')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('409','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('469','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Initialized 0 instances
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('509','2140371520')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 Packing instances...
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('531','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('532','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('533','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('534','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('540','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Instance numbers remapped, next instance id is 600
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('542','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 Loading Localization strings...
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('543','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('544','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('545','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Loaded 0 MaNGOS locale strings. DB table mangos_string contains no localization.
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('546','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('547','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('548','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('550','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('552','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('553','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('554','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('555','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Loaded 0 creature locale strings. DB table locales_creature is empty.
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('556','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('557','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('558','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('560','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Loaded 0 gameobject locale strings. DB table locales_gameobject is empty.
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('564','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('565','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('568','2140371520')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('580','1935440448')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02 ERROR:SQL: INSERT INTO instance_reset VALUES ('585','1842408000')
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.instance_reset' doesn't exist
    2008-09-02 22:29:02
    2008-09-02 22:29:02 ERROR:SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
    2008-09-02 22:29:02 >> Loaded 0 Item locale strings. DB table locales_item is empty.
    2008-09-02 22:29:02 ERROR:SQL ERROR: Table 'characters.group_instance' doesn't exist
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Loaded 0 Quest locale strings. DB table locales_quest is empty.
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Loaded 0 Quest locale strings. DB table locales_npc_text is empty.
    2008-09-02 22:29:02
    2008-09-02 22:29:02 >> Loaded 0 PageText locale strings. DB table locales_page_text is empty.
    2008-09-02 22:29:02 Loading Page Texts...
    2008-09-02 22:29:02 >> Loaded 1389 page texts
    2008-09-02 22:29:02
    2008-09-02 22:29:02 Loading Game Object Templates...
    2008-09-02 22:29:03 >> Loaded 13616 game object templates
    2008-09-02 22:29:03
    2008-09-02 22:29:03 Loading Spell Chain Data...
    2008-09-02 22:29:04
    2008-09-02 22:29:04 >> Loaded 1919 spell chain records
    2008-09-02 22:29:04 Loading Spell Elixir types...
    2008-09-02 22:29:04
    2008-09-02 22:29:04 >> Loaded 98 spell elixir definitions
    2008-09-02 22:29:04 Loading Spell Learn Skills...
    2008-09-02 22:29:04
    2008-09-02 22:29:04 >> Loaded 78 Spell Learn Skills from DBC
    2008-09-02 22:29:04 Loading Spell Learn Spells...
    2008-09-02 22:29:04
    2008-09-02 22:29:04 >> Loaded 14 spell learn spells + 500 found in DBC
    2008-09-02 22:29:04 Loading Spell Proc Event conditions...
    2008-09-02 22:29:04 ERROR:Spell 33280 listed in spell_proc_event does not exist
    2008-09-02 22:29:04 ERROR:Spell 35092 listed in spell_proc_event does not exist
    2008-09-02 22:29:04 ERROR:Spell 35093 listed in spell_proc_event does not exist
    2008-09-02 22:29:04 ERROR:Spell 35094 listed in spell_proc_event does not exist
    2008-09-02 22:29:04
    2008-09-02 22:29:04 >> Loaded 959 spell proc event conditions
    2008-09-02 22:29:04 Loading Aggro Spells Definitions...
    2008-09-02 22:29:05 >> Loaded 89 aggro generating spells
    2008-09-02 22:29:05
    2008-09-02 22:29:05 Loading NPC Texts...
    2008-09-02 22:29:06
    2008-09-02 22:29:06 >> Loaded 4357 npc texts
    2008-09-02 22:29:06 Loading Item Random Enchantments Table...
    2008-09-02 22:29:06
    2008-09-02 22:29:06 >> Loaded 28408 Item Enchantment definitions
    2008-09-02 22:29:06 Loading Items...
    2008-09-02 22:29:11 >> Loaded 23788 item prototypes
    2008-09-02 22:29:11
    2008-09-02 22:29:11 ERROR:Item (Entry: 849 8) not correct 20655 display id, must be 44666 (using it).
    2008-09-02 22:29:11 ERROR:Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
    2008-09-02 22:29:11 ERROR:Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
    2008-09-02 22:29:11 ERROR:Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
    2008-09-02 22:29:11 ERROR:Item (Entry: 3380 8) not correct 47014 display id, must be 51920 (using it).
    2008-09-02 22:29:11 ERROR:Item (Entry: 3386 8) not correct 47131 display id, must be 51758 (using it).
    2008-09-02 22:29:11 ERROR:Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
    2008-09-02 22:29:11 Loading Item Texts...
    2008-09-02 22:29:11
    2008-09-02 22:29:11 >> Loaded 0 item pages
    2008-09-02 22:29:11 Loading Creature Model Based Info Data...
    2008-09-02 22:29:12 >> Loaded 16891 creature model based info
    2008-09-02 22:29:12
    2008-09-02 22:29:12 Loading Equipment templates...
    2008-09-02 22:29:12 >> Loaded 1874 equipment template
    2008-09-02 22:29:12
    2008-09-02 22:29:12 Loading Creature templates...
    2008-09-02 22:29:13 ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql).

    Posted 1 year ago » Permalink

  6. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    It appears your characters database is not installed properly, either create the characters database manually, or redo the fresh install. After taht, dont forget to apply the Arcane Fire fix, also found where you downloaded AF

    Posted 1 year ago » Permalink

  7. beatson

    Member
    Joined: Sep '08
    Posts: 8

    ok, il try that, thanks alot

    Posted 1 year ago » Permalink

  8. beatson

    Member
    Joined: Sep '08
    Posts: 8

    umm, it seemed to work, but it wont keeps saying unable to connect when i try to log in

    Posted 1 year ago » Permalink

  9. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    did you change your realmlist.wtf in your wow folder to 127.0.0.1? If yes, run the install bat and select configure for lan, then enter 127.0.0.1 as IP, then try again.

    Posted 1 year ago » Permalink

  10. beatson

    Member
    Joined: Sep '08
    Posts: 8

    still not working, i found this error though,

    2008-09-03 20:46:35 Item (Entry: 849 8) not correct 20655 display id, must be 44666 (using it).
    2008-09-03 20:46:35 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
    2008-09-03 20:46:35 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
    2008-09-03 20:46:35 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
    2008-09-03 20:46:35 Item (Entry: 3380 8) not correct 47014 display id, must be 51920 (using it).
    2008-09-03 20:46:35 Item (Entry: 3386 8) not correct 47131 display id, must be 51758 (using it).
    2008-09-03 20:46:35 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
    2008-09-03 20:46:56 Spell (id: 5179 8) have SPELL_EFFECT_QUEST_COMPLETE for quest 11122 , but quest not have flag QUEST_MANGOS_FLAGS_EXPLORATION_OR_EVENT. Quest flags must be fixed, quest modified to enable objective.
    2008-09-03 20:47:10 SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, difficulty, leaderGuid FROM groups
    2008-09-03 20:47:10 query ERROR: Unknown column 'difficulty' in 'field list'

    Posted 1 year ago » Permalink

  11. Pitje

    Regular
    Joined: Aug '08
    Posts: 178

    Very odd lol :p
    only the last 4 lines of errors are interesting, but anyway, im pretty clueless how to fix this... i think i would simply retry a fresh install, or remove the difficulty column from database characters table groups.

    Posted 1 year ago » Permalink

  12. beatson

    Member
    Joined: Sep '08
    Posts: 8

    iv tried the fresh install more than once, il try removing the difficulty column from the char table. thanks for the help

    Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.

Topic Info

General

Discuss about anything else

1,272 Topics – 6,705 Posts