Need help with connecting to database menu

User Tag List

Results 1 to 8 of 8
  1. #1
    Nightsky92's Avatar Member
    Reputation
    1
    Join Date
    Sep 2008
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need help with connecting to database

    Hi!
    I have Moffeman's repack for 3.0.2.8885 and after following a guide here on the forum on how to set the server up, I tried to start it by executing realmd.exe (which would next be followed by mangosd.exe), but when executing the realmd.exe file a commandprompt window appeared (as it should) but with this text in it:

    Code:
    Using configuration file realmd.conf.
    MaNGOS?0.12.0-SVN <Revision 6523> <Win32,little-endian> <realm-daemon>
    <Ctrl-C> to stop.
    
    Database: 127.0.0.1;3306;root;ascent;realmd
    Could not connect to MySQL database at 127.0.0.1: Unknown database ´realmd´
    
    Cannot connecto to database
    My connection is named: Jalle's Wotlk
    My MySQL password is: ascent
    My Database is (default): realmd;characters;mangos
    My MySQL editor is: Navicat

    All instructions from the guides (I've read several identical guides by different members of mmowned) have carefully been followed and done.

    Here's my realmd.conf contents:
    Code:
    LoginDatabaseInfo = "localhost;3306;root;ascent;realmd"
    LogsDir = ""
    MaxPingTime = 30
    RealmServerPort = 3724
    BindIP = "127.0.0.1"
    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
    And here's my mangosd.conf contents:
    Code:
    RealmID = 1
    DataDir = "."
    LogsDir = ""
    LoginDatabaseInfo     = "127.0.0.1;3306;root;ascent;realmd"
    WorldDatabaseInfo     = "127.0.0.1;3306;root;ascent;world"
    CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;character"
    MaxPingTime = 30
    WorldServerPort = 8085
    BindIP = "127.0.0.1"
    Please help me!

    Need help with connecting to database
  2. #2
    Aznex's Avatar Contributor
    Reputation
    128
    Join Date
    Feb 2008
    Posts
    770
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can u make a screenshot of your Navicat GUI?

  3. #3
    Nightsky92's Avatar Member
    Reputation
    1
    Join Date
    Sep 2008
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


    Is this ok or do you need anyone else?
    I'll worship you if you help me find a solution to this problem!

  4. #4
    Aznex's Avatar Contributor
    Reputation
    128
    Join Date
    Feb 2008
    Posts
    770
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've never seen anyone do it like that but try making a different database for all of them
    like
    new database -> name it: Realmd
    another new database -> name it: mangos
    once agian, new database -> name it: characters
    so not only 1 database thats named: realmd;mangos;characters
    gl

  5. #5
    Nightsky92's Avatar Member
    Reputation
    1
    Join Date
    Sep 2008
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for taking time trying to help me!
    Anyway, the problem is that the batch files that I use is actually all 3 (mangos, characters, realmd) in just 1 batch file.
    What I'm trying to do now is to make a new database and execute the batch file into it, and then connect to that new database... Hopefully it will work! (In case I solve this problem I'll post here telling you so that nobody waste their time anymore... however, that is not the case yet =S)

  6. #6
    Aznex's Avatar Contributor
    Reputation
    128
    Join Date
    Feb 2008
    Posts
    770
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well I guess you could just edit your config files and tell it that your database name is realmd;characters;mangos ... maybe that will work too xD

  7. #7
    Nightsky92's Avatar Member
    Reputation
    1
    Join Date
    Sep 2008
    Posts
    11
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I DID edit my config files... however, due to the ";" it only reads the first part which is "realmd" and not the rest. So I created a new database and executed the batchfile into it. Now when I open my realmd.exe I see following:
    Code:
    Using configuration file realmd.conf.
    MaNGOS/0.12.0-SVN (Revision 6523) (Win32,little-endian) (realm-daemon)
    <Ctrl-C> to stop.
    
    Database: localhost;3306;root;ascent;jallewotlk
    MySQL client library: 5.0.56
    MySQL server ver: 5.0.51b-community-nt
    Added realm "Jalle's Wotlk".
    realmd process priority class set to HIGH
    Problem is that when I launch my mangosd.exe it pops up and after like 0.1 second it disappears again, it doesn't stay up. And, naturally, I can't log on to the server.

  8. #8
    Yamajee's Avatar Banned
    Reputation
    10
    Join Date
    Feb 2007
    Posts
    150
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmm, he has put all of the tables into 1 DB, make different DB's as Aznex said.

Similar Threads

  1. [MaNGOS] Need help with database
    By xDvolcom in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 12-20-2009, 05:07 AM
  2. Need help with connection issue
    By Confucius in forum WoW EMU Questions & Requests
    Replies: 14
    Last Post: 12-13-2008, 07:13 PM
  3. Need help with connection problem (Private servers)
    By tobbelainen in forum World of Warcraft General
    Replies: 1
    Last Post: 11-23-2008, 02:14 PM
  4. yea your tired of me but i need help with ASCENT DATABASE EDITOR
    By jmfour20 in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 07-10-2008, 10:44 PM
  5. need help with shammy talents
    By jason in forum World of Warcraft General
    Replies: 5
    Last Post: 07-19-2006, 02:02 AM
All times are GMT -5. The time now is 01:08 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