[Help] Trinity Realm loop getting server live

[griim]

Hi there came back to mangos /trinity even tho i still run a arcemu based server

Anyway tried runing Trinitycore 1 version 2.4.3

##########################################
# Trinity Core realmd configuration file #
##########################################
ConfVersion=2007062001

###################################################################################################################
# REALMD SETTINGS
#
#    LoginDatabaseInfo
#        Database connection settings for the realm server.
#        Default: hostname;port;username;password;database
#                 .;somenumber;username;password;database - use named pipes at Windows
#                       Named pipes: mySQL required adding "enable-named-pipe" to [mysqld] section my.ini
#                 .;/path/to/unix_socket;username;password;database - use Unix sockets at Unix/Linux
#                       Unix sockets: experimental, not tested
#
#    LogsDir
#         Logs directory setting.
#         Important: Logs dir must exists, or all logs be disable
#         Default: "" - no log directory prefix, if used log names isn't absolute path then logs will be 
#                       stored in current directory for run program.
#
#    MaxPingTime
#         Settings for maximum database-ping interval (minutes between pings)
#
#    RealmServerPort
#         Default RealmServerPort
#
#    BindIP
#         Bind Realm Server to IP/hostname
#
#    PidFile
#        Realmd daemon PID file
#        Default: ""             - do not create PID file
#                 "./realmd.pid" - create PID file (recommended name)
#
#    LogLevel
#        Server console level of logging
#        0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
#        Default: 0
#
#    LogTime
#        Include time in server console output [hh:mm:ss]
#        Default: 0 (no time)
#                 1 (print time)
#
#    LogFile
#        Logfile name
#        Default: "realmd.log"
#                 "" - empty name disable creating log file
#
#    LogTimestamp
#        Logfile with timestamp of server start in name
#        Default: 0 - no timestamp in name
#                 1 - add timestamp in name in form Logname_YYYY-MM-DD_HH-MM-SS.Ext for Logname.Ext
#
#    LogFileLevel
#        Server file level of logging
#        0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
#        Default: 0
#
#    LogColors
#        Color for messages (format "normal_color details_color debug_color error_color)
#        Colors: 0 - BLACK, 1 - RED, 2 - GREEN,  3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 -  CYAN, 7 - GREY,
#                8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
#        Default: "" - none colors
#                 "13 7 11 9" - for example :)
#
#    UseProcessors
#        Used processors mask for multi-processors system (Used only at Windows)
#        Default: 0 (selected by OS)
#                 number (bitmask value of selected processors)
#
#    ProcessPriority
#        Process proirity setting (Used only at Windows)
#        Default: 1 (HIGH)
#                 0 (Normal)
#
#    RealmsStateUpdateDelay
#        Realm list Update up delay (updated at realm list request if delay expired).
#        Default: 20 
#                 0  (Disabled)
#
#    WrongPass.MaxCount
#        Number of login attemps with wrong password before the account or IP is banned
#        Default: 0  (Never ban)
#
#    WrongPass.BanTime
#        Duration of the ban in seconds (0 means permanent ban)
#        Default: 600
#
#    WrongPass.BanType
#        Ban the IP or account on which login is attempted
#        Default: 0 (Ban IP)
#                 1 (Ban Account)
#
###################################################################################################################

LoginDatabaseInfo = "xxxxxxxxx;3306;root;xxxxx;login"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0.0"
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

The info before login database was 127.0.0.1 people could connect to server then but would get stuck on realm list , a friend of mine told me to edit the login address to my external ip which i did but this is the issue i got screenshot is above.

[Kirry]

It seems you missunderstood your friend

You have to be goin' into the realm-databse (at MySQL) and setup the realmlist-table.
The is an entry with the connectiondatas (IP, PORT, s.o.) for your realm.
Now you have to replace the 127.0.0.1 with your external IP.

The MySQLconnection should be at 127.0.0.1.

Greetz GiR-Zippo

[griim]

Lol i havn't mis understood i had all the info already changed as stated above "People could connect" but would get stuck on the realmlist.

This was after messing around the login info was kept as 127.0.0.1 realmlist was my external ip could login fine players would login realm would pop up but thats as far as they could get , yet i could login fine.


A friend of mine calibur from Pretbc.com (admin) of it told me to change the info in the configs to my external ip so i did, thats the error that came up.

[Kiev]

Typically you only need to set the realm to your external IP, and config the database to recognize this.

[griim]

the configs in database are set to my external ip for logon realm d and world connect the realmlist in table is also the external ip .If i change the ips in configs to external tho i get the error as posted in my 1st post the realmd would give that error.If i leave the configs set as 127.0.0.1 people can connect but the realm would just loop , yet i can login fine.

[lunarpac]

the configs in database are set to my external ip for logon realm d and world connect the realmlist in table is also the external ip .If i change the ips in configs to external tho i get the error as posted in my 1st post the realmd would give that error.If i leave the configs set as 127.0.0.1 people can connect but the realm would just loop , yet i can login fine.

The thing is, if you set your IP in the realmd/realmlist to 127.0.0.1, that means only a user connecting from the same machine as the core will be able to successfully connect. So I find it surprising that, when you set your IP that way, others can connect?

All IPs pointing towards the database, i.e in the TrinityRealm.conf and TrinityCore.conf should be 127.0.0.1 if you keep your MySQL server on the same machine as the core. The realmd/realmlist generally should be set to your external ip/dns to allow external connections (for LAN you set it up using the LAN IP).

EDIT: To clarify:
MySQL database connections (TrinityCore.conf/TrinityRealm.conf): 127.0.0.1
Realm/server connections (realmdb/realmlist): LAN or external IP


// Lunar

[griim]

Okay Lunar

Listen ive tried that configs before were set as 127.0.0.1 realmd database was set as external ip as you said.

Players would login and get stuck on realm loop ,thats why i thought it could be the configs but obviously not so i have no real idea what the issue is.

[Kiev]

I think your ports persoanlly aren't fully forwarded, either that or something in your configs are wrong.

[griim]

Technically if my ports were not fully forwarded i wouldn't be able to run a arcemu server? i run one tho Tbc wow Fatal vengeance and that works fine >.<.Just not mangos based emus.

[Kiev]

Im not sure but they might use different ports, they should state in the configs which ones are used.