vec1phyr

Whoops lol, I'm new to using command-line MySQL. I figured from what the table was actually showing me was what I needed to change which was the defaults. Seems to be working now after a smack in the head and some value-changes! Thanks!

Alright, I fixed the database and conf. The error still persists where the authserver shows as the following: TrinityCore rev. 17e661fd2d70 2016-04-29 02:44:55 +0200 (3.3.5 branch) (Unix, Release) (authserver) <Ctrl-C> to stop. Using configuration file /usr/local/etc/authserver.conf. Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014) Using Boost version: 1.55.0 Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1. MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.04.1 Connected to MySQL database at 127.0.0.1 MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.04.1 Connected to MySQL database at 127.0.0.1 DatabasePool 'auth' opened successfully. 2 total connections running. Updating Auth database... >> Auth database is up-to-date! Containing 1 new and 10 archived updates. Started auth database connection pool. Added realm "Trinity" at 127.0.0.1:8085. Whenever I also change any of the data (ex: Changing the name of the realm) the data doesn't change according to authserver. It will always show as "Trinity" at 127.0.0.1:8085

Hello TrinityCore Community! I recently set up a TrinityCore server to run on a dedicated server in order to learn and play with friends. However, I am having this issue where I have my IP binded to 199.XXX.103.XX (hidden by request of server host) and the realm returns as "127.0.0.1". The issue I'm having is that my config is as shown below which (according to the internet) is correct. Server accepts connection up till realm selection, at which I select the "Trinity" server as needed and will be returned with "Connecting" and then brought back to the realm selection. I also must note that the server also doesn't see any name changes in the database and always returns as "Trinity". Running authserver returns the following: TrinityCore rev. 17e661fd2d70 2016-04-29 02:44:55 +0200 (3.3.5 branch) (Unix, Release) (authserver) <Ctrl-C> to stop. Using configuration file /usr/local/etc/authserver.conf. Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014) Using Boost version: 1.55.0 Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1. MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.04.1 Connected to MySQL database at 199.XXX.103.XX MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.04.1 Connected to MySQL database at 199.XXX.103.XX DatabasePool 'auth' opened successfully. 2 total connections running. Updating Auth database... >> Auth database is up-to-date! Containing 1 new and 10 archived updates. Started auth database connection pool. Added realm "Trinity" at 127.0.0.1:8085. -------------------------------------------------------- MySQL Database: auth.realmlist mysql> show columns from `realmlist`; +----------------------+----------------------+------+-----+----------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+----------------------+------+-----+----------------+-------+ | id | int(10) unsigned | NO | PRI | 1 | | | name | varchar(32) | NO | UNI | Trinity | | | address | varchar(255) | NO | | 199.168.103.10 | | | localAddress | varchar(255) | NO | | localhost | | | localSubnetMask | varchar(255) | NO | | 255.255.255.0 | | | port | smallint(5) unsigned | NO | | 8085 | | | icon | tinyint(3) unsigned | NO | | 1 | | | flag | tinyint(3) unsigned | NO | | 0 | | | timezone | tinyint(3) unsigned | NO | | 1 | | | allowedSecurityLevel | tinyint(3) unsigned | NO | | 0 | | | population | float unsigned | NO | | 0 | | | gamebuild | int(10) unsigned | NO | | 12340 | | +----------------------+----------------------+------+-----+----------------+-------+ 12 rows in set (0.00 sec) All help is appreciated! Thanks!