---
[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
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.
Recommended Comments