TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (authserver)
<Ctrl-C> to stop.

Using configuration file authserver.conf.
Using SSL version: OpenSSL 1.0.2a 19 Mar 2015 (library: OpenSSL 1.0.2a 19 Mar 2015)
Using Boost version: 1.58.0
Opening DatabasePool ''. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.38
MySQL server ver: 5.5.25
Connected to MySQL database at
MySQL client library: 5.5.38
MySQL server ver: 5.5.25
Connected to MySQL database at
DatabasePool '' opened successfully. 2 total connections running.
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
No database selected
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
No database selected
In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban', 1)"
No database selected
In mysql_stmt_prepare() id: 9, sql: "DELETE FROM account_banned WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 11, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
No database selected
In mysql_stmt_prepare() id: 15, sql: "UPDATE account SET failed_logins = failed_logins + 1 WHERE username = ?"
No database selected
In mysql_stmt_prepare() id: 23, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM ip_banned WHERE ip = ?"
No database selected
In mysql_stmt_prepare() id: 28, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
No database selected
In mysql_stmt_prepare() id: 29, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
No database selected
In mysql_stmt_prepare() id: 30, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
No database selected
In mysql_stmt_prepare() id: 31, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
No database selected
In mysql_stmt_prepare() id: 32, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 33, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
No database selected
In mysql_stmt_prepare() id: 35, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
No database selected
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET expansion = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET locked = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 39, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET email = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 43, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 44, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 45, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 46, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
No database selected
In mysql_stmt_prepare() id: 47, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
No database selected
In mysql_stmt_prepare() id: 48, sql: "UPDATE account SET online = 1 WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 49, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
No database selected
In mysql_stmt_prepare() id: 50, sql: "DELETE FROM logs WHERE (time + ?) < ?"
No database selected
In mysql_stmt_prepare() id: 51, sql: "DELETE FROM account_access WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 52, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
No database selected
In mysql_stmt_prepare() id: 53, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
No database selected
In mysql_stmt_prepare() id: 70, sql: "DELETE FROM account WHERE id = ?"
No database selected
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
No database selected
In mysql_stmt_prepare() id: 77, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
No database selected
In mysql_stmt_prepare() id: 78, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
No database selected
In mysql_stmt_prepare() id: 79, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES ((SELECT id FROM account WHERE username = ?), 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
No database selected
In mysql_stmt_prepare() id: 82, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
No database selected
In mysql_stmt_prepare() id: 83, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
No database selected
In mysql_stmt_prepare() id: 84, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
No database selected
Closing down DatabasePool ''.
Asynchronous connections on DatabasePool '' terminated. Proceeding with synchronous connections.
All connections on DatabasePool '' closed.
Could not prepare statements of the Login database, see log for details.

###############################################

# Trinity Core Auth Server configuration file #
###############################################
[authserver]

###################################################################################################
# SECTION INDEX
#
# EXAMPLE CONFIG
# AUTH SERVER SETTINGS
# MYSQL SETTINGS
# UPDATE SETTINGS
# LOGGING SYSTEM SETTINGS
#
###################################################################################################

###################################################################################################
# EXAMPLE CONFIG
#
# Variable
# Description: Brief description what the variable is doing.
# Important: Annotation for important things about this variable.
# Example: "Example, i.e. if the value is a string"
# Default: 10 - (Enabled|Comment|Variable name in case of grouped config options)
# 0 - (Disabled|Comment|Variable name in case of grouped config options)
#
# Note to developers:
# - Copy this example to keep the formatting.
# - Line breaks should be at column 100.
###################################################################################################

###################################################################################################
# AUTH SERVER SETTINGS
#
# LogsDir
# Description: Logs directory setting.
# Important: LogsDir needs to be quoted, as the string might contain space characters.
# Logs directory must exists, or log file creation will be disabled.
# Default: "" - (Log files will be stored in the current path)

LogsDir = "logs"

#
# MaxPingTime
# Description: Time (in minutes) between database pings.
# Default: 30

MaxPingTime = 30

#
# RealmServerPort
# Description: TCP port to reach the auth server.
# Default: 3724

RealmServerPort = 3724

#
#
# BindIP
# Description: Bind auth server to IP/hostname
# Default: "0.0.0.0" - (Bind to all IPs on the system)

BindIP = "0.0.0.0"

#
# PidFile
# Description: Auth server PID file.
# Example: "./authserver.pid" - (Enabled)
# Default: "" - (Disabled)

PidFile = ""

#
# UseProcessors
# Description: Processors mask for Windows and Linux based multi-processor systems.
# Example: A computer with 2 CPUs:
# 1 - 1st CPU only, 2 - 2nd CPU only, 3 - 1st and 2nd CPU, because 1 | 2 is 3
# Default: 0 - (Selected by OS)
# 1+ - (Bit mask value of selected processors)

UseProcessors = 0

#
# ProcessPriority
# Description: Process priority setting for Windows and Linux based systems.
# Details: On Linux, a nice value of -15 is used. (requires superuser). On Windows, process is set to HIGH class.
# Default: 0 - (Normal)
# 1 - (High)

ProcessPriority = 0

#
# RealmsStateUpdateDelay
# Description: Time (in seconds) between realm list updates.
# Default: 20 - (Enabled)
# 0 - (Disabled)

RealmsStateUpdateDelay = 20

#
# WrongPass.MaxCount
# Description: Number of login attemps with wrong password before the account or IP will be
# banned.
# Default: 0 - (Disabled)
# 1+ - (Enabled)

WrongPass.MaxCount = 0

#
# WrongPass.BanTime
# Description: Time (in seconds) for banning account or IP for invalid login attempts.
# Default: 600 - (10 minutes)
# 0 - (Permanent ban)

WrongPass.BanTime = 600

#
# WrongPass.BanType
# Description: Ban type for invalid login attempts.
# Default: 0 - (Ban IP)
# 1 - (Ban Account)

WrongPass.BanType = 0

#
###################################################################################################

###################################################################################################
# MYSQL SETTINGS
#
# LoginDatabaseInfo
# Description: Database connection settings for the realm server.
# Example: "hostname;port;username;password;database"
# ".;somenumber;username;password;database" - (Use named pipes on Windows
# "enable-named-pipe" to [mysqld]
# section my.ini)
# ".;/path/to/unix_socket;username;password;database" - (use Unix sockets on
# Unix/Linux)
# Default: "127.0.0.1;3306;root;auth"

LoginDatabaseInfo = "prostotest.ddns.net;3306;root;auth"

#
# LoginDatabase.WorkerThreads
# Description: The amount of worker threads spawned to handle asynchronous (delayed) MySQL
# statements. Each worker thread is mirrored with its own connection to the
# Default: 1

LoginDatabase.WorkerThreads = 1

#
# Wrong.Password.Login.Logging
# Description: Additionally log attempted wrong password logging
# Default: 0 - (Disabled)
# 1 - (Enabled)

Wrong.Password.Login.Logging = 0
#
###################################################################################################

###################################################################################################
# UPDATE SETTINGS
#
# Updates.EnableDatabases
# Description: A mask that describes which databases shall be updated.
#
# Following flags are available
# DATABASE_LOGIN = 1, // Auth database
#
# Default: 0 - (All Disabled)
# 1 - (All Enabled)

Updates.EnableDatabases = 0

#
# Updates.SourcePath
# Description: The path to your TrinityCore source directory.
# If the path is left empty, built-in CMAKE_SOURCE_DIR is used.
# Example: "../TrinityCore"
# Default: ""

Updates.SourcePath = ""

#
# Updates.SourcePath
# Description: The path to your mysql cli binary.
# If the path is left empty, built-in path from cmake is used.
# Example: "C:/Program Files/MySQL/MySQL Server 5.6/bin/mysql.exe"
# "mysql.exe"
# "/usr/bin/mysql"
# Default: ""

Updates.MySqlCLIPath = ""

#
# Updates.AutoSetup
# Description: Auto populate empty databases.
# Default: 1 - (Enabled)
# 0 - (Disabled)

Updates.AutoSetup = 1

#
# Updates.Redundancy
# Description: Perform data redundancy checks through hashing
# to detect changes on sql updates and reapply it.
# Default: 1 - (Enabled)
# 0 - (Disabled)

Updates.Redundancy = 1

#
# Updates.ArchivedRedundancy
# Description: Check hashes of archived updates (slows down startup).
# Default: 0 - (Disabled)
# 1 - (Enabled)

Updates.ArchivedRedundancy = 0

#
# Updates.AllowRehash
# Description: Inserts the current file hash in the database if it is left empty.
# Useful if you want to mark a file as applied but you don't know its hash.
# Default: 1 - (Enabled)
# 0 - (Disabled)

Updates.AllowRehash = 1

#
# Updates.CleanDeadRefMaxCount
# Description: Cleans dead/ orphaned references that occur if an update was removed or renamed and edited in one step.
# It only starts the clean up if the count of the missing updates is below or equal the Updates.CleanDeadRefMaxCount value.
# This way prevents erasing of the update history due to wrong source directory state (maybe wrong branch or bad revision).
# Disable this if you want to know if the database is in a possible "dirty state".
# Default: 3 - (Enabled)
# 0 - (Disabled)
# -1 - (Enabled - unlimited)

Updates.CleanDeadRefMaxCount = 3

#
###################################################################################################

###################################################################################################
#
# LOGGING SYSTEM SETTINGS
#
# Appender config values: Given a appender "name"
# Appender.name
# Description: Defines 'where to log'
# Format: Type,LogLevel,Flags,optional1,optional2,optional3
#
# Type
# 0 - (None)
# 1 - (Console)
# 2 - (File)
# 3 - (DB)
#
# LogLevel
# 0 - (Disabled)
# 1 - (Trace)
# 2 - (Debug)
# 3 - (Info)
# 4 - (Warn)
# 5 - (Error)
# 6 - (Fatal)
#
# Flags:
# 0 - None
# 1 - Prefix Timestamp to the text
# 2 - Prefix Log Level to the text
# 4 - Prefix Log Filter type to the text
# 8 - Append timestamp to the log file name. Format: YYYY-MM-DD_HH-MM-SS (Only used with Type = 2)
# 16 - Make a backup of existing file before overwrite (Only used with Mode = w)
#
# Colors (read as optional1 if Type = Console)
# Format: "fatal error warn info debug trace"
# 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
# Example: "13 11 9 5 3 1"
#
# File: Name of the file (read as optional1 if Type = File)
# Allows to use one "%s" to create dynamic files
#
# Mode: Mode to open the file (read as optional2 if Type = File)
# a - (Append)
# w - (Overwrite)
#
# MaxFileSize: Maximum file size of the log file before creating a new log file
# (read as optional3 if Type = File)
# Size is measured in bytes expressed in a 64-bit unsigned integer.
# Maximum value is 4294967295 (4 gb). Leave blank for no limit.
# NOTE: Does not work with dynamic filenames.
# Example: 536870912 (512 mb)
#

Appender.Console=1,2,0
Appender.Auth=2,2,0,Auth.log,w

# Logger config values: Given a logger "name"
# Logger.name
# Description: Defines 'What to log'
# Format: LogLevel,AppenderList
#
# LogLevel
# 0 - (Disabled)
# 1 - (Trace)
# 2 - (Debug)
# 3 - (Info)
# 4 - (Warn)
# 5 - (Error)
# 6 - (Fatal)
#
# AppenderList: List of appenders linked to logger
# (Using spaces as separator).
#

Logger.root=3,Console Auth

#
###################################################################################################