Jump to content
  • [SOLVED] Malfunction, possible bug..


    niemal
    • Status: Completed
      Main Category: Core / Mangos Daemon
      Sub-Category: gamebreaker
      Version: 21.0 Milestone: 21 Priority: Normal
      Implemented Version: 21.0

    ---

    [b][u]ISSUE RESOLVED (scroll down for the solution)[/b][/u]

    Mangos: 2
    Branch: Rel20_Newbuild (latest update)
    Platform: Linux hermit 2.6.32-042stab093.5 #1 SMP Wed Sep 10 17:39:49 MSK 2014 x86_64 GNU/Linux
    Problem: ./realmd is working just fine, but ./mangosd isn't (I can't connect to the server) and everything seems to be properly configured.
    Booting up mangosd: [url]http://i.imgur.com/LqHd7oq.png[/url]
    What happens when I try to connect to the server: [url]http://puu.sh/g1s2Q/c2425db47e.jpg[/url] + Logging in to game server message and then prompt back to the screenshot.

    MySQL database seems to be full and is identical to a Rel20_Newbuild working mirror I got on my windows..

    NOTE: The working mirror I got on my windows is [b]not[/b] the same with the latest one.

    [code]
    mysql> SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'mangos';
    +----------+
    | COUNT(*) |
    +----------+
    | 155 |
    +----------+
    1 row in set (0.02 sec)

    mysql> SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = 'mangos';
    +----------+
    | COUNT(*) |
    +----------+
    | 1768 |
    +----------+
    1 row in set (0.05 sec)

    mysql> SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = 'characters';
    +----------+
    | COUNT(*) |
    +----------+
    | 554 |
    +----------+
    1 row in set (0.11 sec)

    mysql> SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = 'realmd';
    +----------+
    | COUNT(*) |
    +----------+
    | 75 |
    +----------+
    1 row in set (0.01 sec)
    [/code]



    Additionally, here are the logs (using tail command):

    [code]
    ==> ElunaErrors.log
    ==> realm-list.log 2015-02-16 17:03:35 20000 [realm-daemon]
    2015-02-16 17:03:35 to stop.

    2015-02-16 17:03:35 Using configuration file realmd.conf.
    2015-02-16 17:03:35 Login Database total connections: 2
    2015-02-16 17:03:35 MySQL client library: 5.5.40
    2015-02-16 17:03:35 MySQL server ver: 5.5.40-0ubuntu0.14.04.1-log
    2015-02-16 17:03:35 MySQL client library: 5.5.40
    2015-02-16 17:03:35 MySQL server ver: 5.5.40-0ubuntu0.14.04.1-log
    2015-02-16 17:03:35 Added realm id 1, name 'Burny's Beta'

    ==> scriptdev2-errors.log
    ==> world-characters.log
    ==> world-database.log
    ==> world-eventai.log
    ==> world-gamemaster.log
    ==> world-packets.log
    ==> world-remote-access.log
    ==> world-server.log 2015-02-17 17:36:00 Player::DeleteOldChars: Deleting all characters which have been deleted 30 days before...
    2015-02-17 17:36:00 Initialize AuctionHouseBot...
    2015-02-17 17:36:00 AHBOT is Disabled. Unable to open configuration file(ahbot.conf).
    2015-02-17 17:36:00 [Eluna]: Executed 3 Lua scripts in 1 ms
    2015-02-17 17:36:00 WORLD: World initialized
    2015-02-17 17:36:00 SERVER STARTUP TIME: 0 minutes 3 seconds
    2015-02-17 17:36:00
    2015-02-17 17:38:01 GameEvent 61 "Stormwind City - Stockades Jail Break" removed.
    2015-02-17 17:40:01 GameEvent 41 "Leader of Jin'Alai, Kutube'sa" started.
    2015-02-17 17:40:01 GameEvent 43 "Leader of Jin'Alai, Chulo" removed.
    [/code]


    So far the facts lead me to believe the source and/or database is/are broken. Could you guys look it up? Thanks.


    User Feedback

    Recommended Comments

    Logging in issue:
    This will be due to an incorrect [B]address [/B]in the [B]realmlist[/B] table of the realmd database, well, in my experience that has been the case :)

    You need to give it the address of the server's machine. It is probably set to 127.0.0.1, at the moment.

    Link to comment
    Share on other sites

    [quote=antz]We spotted an error in the SQL which affects Linux builds, please try again[/quote]

    That fixed a "Connected" message that was freezing up getting the character list!

    [quote=Chucksta]
    Logging in issue:
    This will be due to an incorrect address in the realmlist table of the realmd database, well, in my experience that has been the case

    You need to give it the address of the server's machine. It is probably set to 127.0.0.1, at the moment.
    [/quote]

    That's correct. Nicely spotted!


    Everything seems to work as it should now. Issue resolved.

    Link to comment
    Share on other sites


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use