[SOLVED] world & auth closing instantly

[Black Ace]

Hello , I haven't touched the host yesterday since I've been busy but today I added a simple sql and went to test it but auth.exe and world.exe keep closing , they stay open for like 3-4 sec .
kinda fits with a hip hop song when restarter keeps poping them on and off :lol:

I check on their log files and this shows up :

-DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database


any ideas? ( mysql is running as far as I can see )​

 

[Jameyboor]

Please provide us with your Server.txt and Auth.txt logs, located in the folder where your auth & world servers are located.

 

[Black Ace]

Auth log :

TrinityCore rev. 20d070172bae 2013-09-23 22:55:35 +0200 (master branch) (Win32, Release) (authserver)
<Ctrl-C> to stop.

Using configuration file authserver.conf.
OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e 11 Feb 2013)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.9
MySQL server ver: 5.5.34
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 75, sql: "INSERT INTO rbac_account_groups (accountId, groupId, realmId) VALUES (?, ?, ?)"
Table 'auth.rbac_account_groups' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "DELETE FROM rbac_account_groups WHERE accountId = ? AND groupId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_groups' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "INSERT INTO rbac_account_roles (accountId, roleId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_roles' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "DELETE FROM rbac_account_roles WHERE accountId = ? AND roleId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_roles' doesn't exist
MySQL client library: 5.5.9
MySQL server ver: 5.5.34
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 74, sql: "SELECT groupId FROM rbac_account_groups WHERE accountId = ? AND (realmId = ? OR realmId = -1) GROUP BY groupId"
Table 'auth.rbac_account_groups' doesn't exist
In mysql_stmt_prepare() id: 77, sql: "SELECT roleId, granted FROM rbac_account_roles WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY roleId, realmId"
Table 'auth.rbac_account_roles' doesn't exist
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database

server log

In mysql_stmt_prepare() id: 75, sql: "INSERT INTO rbac_account_groups (accountId, groupId, realmId) VALUES (?, ?, ?)"
Table 'auth.rbac_account_groups' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "DELETE FROM rbac_account_groups WHERE accountId = ? AND groupId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_groups' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "INSERT INTO rbac_account_roles (accountId, roleId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_roles' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "DELETE FROM rbac_account_roles WHERE accountId = ? AND roleId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_roles' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "SELECT groupId FROM rbac_account_groups WHERE accountId = ? AND (realmId = ? OR realmId = -1) GROUP BY groupId"
Table 'auth.rbac_account_groups' doesn't exist
In mysql_stmt_prepare() id: 77, sql: "SELECT roleId, granted FROM rbac_account_roles WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY roleId, realmId"
Table 'auth.rbac_account_roles' doesn't exist
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to login database 127.0.0.1;3306;root;password;auth

 

[Tommy]

Don't add updates if it isn't consistent with your server's database structure. It plainly says you're missing tables.

Table 'auth.rbac_account_groups' doesn't exist
Table 'auth.rbac_account_roles' doesn't exist