API tools faq
paste
Advertisement
Hiukuss

Auth

Hiukuss
Aug 26th, 2013
159
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.75 KB | None | 0 0
raw download clone embed print report
  1. Auth.txt:
  2. TrinityCore rev. 5164caa9ffb4 2013-08-03 13:23:24 +0200 (master branch) (Win32, Release) (authserver)
  3. <Ctrl-C> to stop.
  4.  
  5. Using configuration file authserver.conf.
  6. OpenSSL 1.0.1c 10 May 2012 (Library: OpenSSL 1.0.1c 10 May 2012)
  7. Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
  8. MySQL client library: 5.5.9
  9. MySQL server ver: 5.6.12-log
  10. Connected to MySQL database at 127.0.0.1
  11. In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
  12. Table 'auth.ip_banned' doesn't exist
  13. In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
  14. Table 'auth.account_banned' doesn't exist
  15. In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity realmd', 'Failed login autoban')"
  16. Table 'auth.ip_banned' doesn't exist
  17. In mysql_stmt_prepare() id: 8, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity realmd', 'Failed login autoban', 1)"
  18. Table 'auth.account_banned' doesn't exist
  19. In mysql_stmt_prepare() id: 9, sql: "DELETE FROM account_banned WHERE id = ?"
  20. Table 'auth.account_banned' doesn't exist
  21. In mysql_stmt_prepare() id: 11, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
  22. Table 'auth.account' doesn't exist
  23. In mysql_stmt_prepare() id: 12, sql: "UPDATE account SET sessionkey = ?, last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE username = ?"
  24. Table 'auth.account' doesn't exist
  25. In mysql_stmt_prepare() id: 15, sql: "UPDATE account SET failed_logins = failed_logins + 1 WHERE username = ?"
  26. Table 'auth.account' doesn't exist
  27. In mysql_stmt_prepare() id: 23, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
  28. Table 'auth.ip_banned' doesn't exist
  29. In mysql_stmt_prepare() id: 24, sql: "DELETE FROM ip_banned WHERE ip = ?"
  30. Table 'auth.ip_banned' doesn't exist
  31. In mysql_stmt_prepare() id: 28, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
  32. Table 'auth.account_banned' doesn't exist
  33. In mysql_stmt_prepare() id: 29, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
  34. Table 'auth.account_banned' doesn't exist
  35. In mysql_stmt_prepare() id: 30, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
  36. Table 'auth.realmcharacters' doesn't exist
  37. In mysql_stmt_prepare() id: 31, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
  38. Table 'auth.realmcharacters' doesn't exist
  39. In mysql_stmt_prepare() id: 32, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
  40. Table 'auth.realmcharacters' doesn't exist
  41. In mysql_stmt_prepare() id: 33, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
  42. Table 'auth.realmcharacters' doesn't exist
  43. 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"
  44. Table 'auth.realmcharacters' doesn't exist
  45. In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET expansion = ? WHERE id = ?"
  46. Table 'auth.account' doesn't exist
  47. In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET locked = ? WHERE id = ?"
  48. Table 'auth.account' doesn't exist
  49. In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
  50. Table 'auth.account' doesn't exist
  51. In mysql_stmt_prepare() id: 39, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
  52. Table 'auth.logs' doesn't exist
  53. In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
  54. Table 'auth.account' doesn't exist
  55. In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
  56. Table 'auth.account' doesn't exist
  57. In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
  58. Table 'auth.account' doesn't exist
  59. In mysql_stmt_prepare() id: 43, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
  60. Table 'auth.account' doesn't exist
  61. In mysql_stmt_prepare() id: 44, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
  62. Table 'auth.account' doesn't exist
  63. In mysql_stmt_prepare() id: 45, sql: "UPDATE account SET online = 1 WHERE id = ?"
  64. Table 'auth.account' doesn't exist
  65. In mysql_stmt_prepare() id: 46, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
  66. Table 'auth.uptime' doesn't exist
  67. In mysql_stmt_prepare() id: 47, sql: "DELETE FROM logs WHERE (time + ?) < ?"
  68. Table 'auth.logs' doesn't exist
  69. In mysql_stmt_prepare() id: 48, sql: "DELETE FROM account_access WHERE id = ?"
  70. Table 'auth.account_access' doesn't exist
  71. In mysql_stmt_prepare() id: 49, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
  72. Table 'auth.account_access' doesn't exist
  73. In mysql_stmt_prepare() id: 50, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
  74. Table 'auth.account_access' doesn't exist
  75. In mysql_stmt_prepare() id: 67, sql: "DELETE FROM account WHERE id = ?"
  76. Table 'auth.account' doesn't exist
  77. In mysql_stmt_prepare() id: 72, sql: "INSERT INTO rbac_account_groups (accountId, groupId, realmId) VALUES (?, ?, ?)"
  78. Table 'auth.rbac_account_groups' doesn't exist
  79. In mysql_stmt_prepare() id: 73, sql: "DELETE FROM rbac_account_groups WHERE accountId = ? AND groupId = ? AND (realmId = ? OR realmId = -1)"
  80. Table 'auth.rbac_account_groups' doesn't exist
  81. In mysql_stmt_prepare() id: 75, sql: "INSERT INTO rbac_account_roles (accountId, roleId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
  82. Table 'auth.rbac_account_roles' doesn't exist
  83. In mysql_stmt_prepare() id: 76, sql: "DELETE FROM rbac_account_roles WHERE accountId = ? AND roleId = ? AND (realmId = ? OR realmId = -1)"
  84. Table 'auth.rbac_account_roles' doesn't exist
  85. In mysql_stmt_prepare() id: 78, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
  86. Table 'auth.rbac_account_permissions' doesn't exist
  87. In mysql_stmt_prepare() id: 79, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
  88. Table 'auth.rbac_account_permissions' doesn't exist
  89. MySQL client library: 5.5.9
  90. MySQL server ver: 5.6.12-log
  91. Connected to MySQL database at 127.0.0.1
  92. In mysql_stmt_prepare() id: 0, sql: "SELECT id, name, address, localAddress, localSubnetMask, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name"
  93. Table 'auth.realmlist' doesn't exist
  94. In mysql_stmt_prepare() id: 3, sql: "SELECT * FROM ip_banned WHERE ip = ?"
  95. Table 'auth.ip_banned' doesn't exist
  96. In mysql_stmt_prepare() id: 25, sql: "SELECT ip, bandate, unbandate, bannedby, banreason FROM ip_banned WHERE (bandate = unbandate OR unbandate > UNIX_TIMESTAMP()) ORDER BY unbandate"
  97. Table 'auth.ip_banned' doesn't exist
  98. In mysql_stmt_prepare() id: 26, sql: "SELECT ip, bandate, unbandate, bannedby, banreason FROM ip_banned WHERE (bandate = unbandate OR unbandate > UNIX_TIMESTAMP()) AND ip LIKE CONCAT('%%', ?, '%%') ORDER BY unbandate"
  99. Table 'auth.ip_banned' doesn't exist
  100. In mysql_stmt_prepare() id: 5, sql: "SELECT bandate, unbandate FROM account_banned WHERE id = ? AND active = 1"
  101. Table 'auth.account_banned' doesn't exist
  102. In mysql_stmt_prepare() id: 6, sql: "SELECT account.id, username FROM account, account_banned WHERE account.id = account_banned.id AND active = 1 GROUP BY account.id"
  103. Table 'auth.account' doesn't exist
  104. In mysql_stmt_prepare() id: 7, sql: "SELECT account.id, username FROM account, account_banned WHERE account.id = account_banned.id AND active = 1 AND username LIKE CONCAT('%%', ?, '%%') GROUP BY account.id"
  105. Table 'auth.account' doesn't exist
  106. In mysql_stmt_prepare() id: 10, sql: "SELECT a.sessionkey, a.id, aa.gmlevel FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE username = ?"
  107. Table 'auth.account' doesn't exist
  108. In mysql_stmt_prepare() id: 13, sql: "SELECT a.sha_pass_hash, a.id, a.locked, a.lock_country, a.last_ip, aa.gmlevel, a.v, a.s FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = ?"
  109. Table 'auth.account' doesn't exist
  110. In mysql_stmt_prepare() id: 14, sql: "SELECT country FROM ip2nation WHERE ip < ? ORDER BY ip DESC LIMIT 0,1"
  111. Table 'auth.ip2nation' doesn't exist
  112. In mysql_stmt_prepare() id: 16, sql: "SELECT id, failed_logins FROM account WHERE username = ?"
  113. Table 'auth.account' doesn't exist
  114. In mysql_stmt_prepare() id: 17, sql: "SELECT id FROM account WHERE username = ?"
  115. Table 'auth.account' doesn't exist
  116. In mysql_stmt_prepare() id: 18, sql: "SELECT id, username FROM account WHERE username = ?"
  117. Table 'auth.account' doesn't exist
  118. In mysql_stmt_prepare() id: 19, sql: "SELECT id, sessionkey, last_ip, locked, expansion, mutetime, locale, recruiter, os FROM account WHERE username = ?"
  119. Table 'auth.account' doesn't exist
  120. In mysql_stmt_prepare() id: 20, sql: "SELECT id, username FROM account WHERE email = ?"
  121. Table 'auth.account' doesn't exist
  122. In mysql_stmt_prepare() id: 21, sql: "SELECT numchars FROM realmcharacters WHERE realmid = ? AND acctid= ?"
  123. Table 'auth.realmcharacters' doesn't exist
  124. In mysql_stmt_prepare() id: 22, sql: "SELECT id, username FROM account WHERE last_ip = ?"
  125. Table 'auth.account' doesn't exist
  126. In mysql_stmt_prepare() id: 27, sql: "SELECT 1 FROM account WHERE id = ?"
  127. Table 'auth.account' doesn't exist
  128. In mysql_stmt_prepare() id: 34, sql: "INSERT INTO account(username, sha_pass_hash, joindate) VALUES(?, ?, NOW())"
  129. Table 'auth.account' doesn't exist
  130. In mysql_stmt_prepare() id: 51, sql: "SELECT id FROM account WHERE username = ?"
  131. Table 'auth.account' doesn't exist
  132. In mysql_stmt_prepare() id: 52, sql: "SELECT gmlevel FROM account_access WHERE id = ?"
  133. Table 'auth.account_access' doesn't exist
  134. In mysql_stmt_prepare() id: 53, sql: "SELECT gmlevel FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
  135. Table 'auth.account_access' doesn't exist
  136. In mysql_stmt_prepare() id: 54, sql: "SELECT username FROM account WHERE id = ?"
  137. Table 'auth.account' doesn't exist
  138. In mysql_stmt_prepare() id: 55, sql: "SELECT 1 FROM account WHERE id = ? AND sha_pass_hash = ?"
  139. Table 'auth.account' doesn't exist
  140. In mysql_stmt_prepare() id: 56, sql: "SELECT 1 FROM account WHERE username = ? AND sha_pass_hash = ?"
  141. Table 'auth.account' doesn't exist
  142. In mysql_stmt_prepare() id: 57, sql: "SELECT a.username, aa.gmlevel, a.email, a.last_ip, DATE_FORMAT(a.last_login, '%Y-%m-%d %T'), a.mutetime, a.mutereason, a.muteby, a.failed_logins, a.locked, a.OS FROM account a LEFT JOIN account_access aa ON (a.id = aa.id AND (aa.RealmID = ? OR aa.RealmID = -1)) WHERE a.id = ?"
  143. Table 'auth.account' doesn't exist
  144. In mysql_stmt_prepare() id: 58, sql: "SELECT unbandate, bandate = unbandate, bannedby, banreason FROM account_banned WHERE id = ? AND active ORDER BY bandate ASC LIMIT 1"
  145. Table 'auth.account_banned' doesn't exist
  146. In mysql_stmt_prepare() id: 59, sql: "SELECT a.username, aa.gmlevel FROM account a, account_access aa WHERE a.id=aa.id AND aa.gmlevel >= ? AND (aa.realmid = -1 OR aa.realmid = ?)"
  147. Table 'auth.account' doesn't exist
  148. In mysql_stmt_prepare() id: 60, sql: "SELECT a.username, a.last_ip, aa.gmlevel, a.expansion FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.id = ?"
  149. Table 'auth.account' doesn't exist
  150. In mysql_stmt_prepare() id: 61, sql: "SELECT 1 FROM account_access WHERE id = ? AND gmlevel > ?"
  151. Table 'auth.account_access' doesn't exist
  152. In mysql_stmt_prepare() id: 62, sql: "SELECT a.id, aa.gmlevel, aa.RealmID FROM account a LEFT JOIN account_access aa ON (a.id = aa.id) WHERE a.username = ?"
  153. Table 'auth.account' doesn't exist
  154. In mysql_stmt_prepare() id: 63, sql: "SELECT 1 FROM account WHERE recruiter = ?"
  155. Table 'auth.account' doesn't exist
  156. In mysql_stmt_prepare() id: 64, sql: "SELECT 1 FROM account_banned WHERE id = ? AND active = 1 UNION SELECT 1 FROM ip_banned WHERE ip = ?"
  157. Table 'auth.account_banned' doesn't exist
  158. In mysql_stmt_prepare() id: 65, sql: "SELECT username, email, last_ip FROM account WHERE id = ?"
  159. Table 'auth.account' doesn't exist
  160. In mysql_stmt_prepare() id: 66, sql: "SELECT allowedSecurityLevel from realmlist WHERE id = ?"
  161. Table 'auth.realmlist' doesn't exist
  162. In mysql_stmt_prepare() id: 68, sql: "SELECT c.country FROM ip2nationCountries c, ip2nation i WHERE i.ip < ? AND c.code = i.country ORDER BY i.ip DESC LIMIT 0,1"
  163. Table 'auth.ip2nationcountries' doesn't exist
  164. In mysql_stmt_prepare() id: 69, sql: "SELECT id, weight, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
  165. Table 'auth.autobroadcast' doesn't exist
  166. In mysql_stmt_prepare() id: 70, sql: "SELECT gmlevel, RealmID FROM account_access WHERE id = ? and (RealmID = ? OR RealmID = -1) ORDER BY gmlevel desc"
  167. Table 'auth.account_access' doesn't exist
  168. In mysql_stmt_prepare() id: 71, sql: "SELECT groupId FROM rbac_account_groups WHERE accountId = ? AND (realmId = ? OR realmId = -1) GROUP BY groupId"
  169. Table 'auth.rbac_account_groups' doesn't exist
  170. In mysql_stmt_prepare() id: 74, sql: "SELECT roleId, granted FROM rbac_account_roles WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY roleId, realmId"
  171. Table 'auth.rbac_account_roles' doesn't exist
  172. In mysql_stmt_prepare() id: 77, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
  173. Table 'auth.rbac_account_permissions' doesn't exist
  174. DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
  175. Cannot connect to database
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!