Agora

Categories

Back to the site

Game database unreachable or refused

ETIMEDOUT, ECONNREFUSED, Access denied, table not found, framework not detected, missing CREATE right: the connection test errors and their fix.

Updated on Sep 30, 2026, 9:00 a.m.

On this page
  1. Test messages
  2. Grant the right privileges
  3. When the game server is off
  4. Other symptoms

In short. The Test button in Server → Database says exactly what is wrong. Nine times out of ten, it is the host: inside a container, localhost means the container itself.

Test messages #

MessageCauseFix
"Game database not configured (…)"The host, user or database is not filled inFill these three fields in Server → Database (the framework can stay on Automatic)
connect ETIMEDOUT or ECONNREFUSEDAgora cannot reach the MySQL hostUse the machine's IP, the Docker service name or the public IP; check that MySQL does not only listen on 127.0.0.1 (bind-address) and that port 3306 is open to Agora's IP
Access denied for user 'agora'@'…'The user may not connect from this IPAllow the IP shown in the message (CREATE USER then GRANT)
"Table players not found (wrong framework?)"The fixed framework does not matchESX reads users, QBCore and Qbox read players: set the dropdown back to Automatic (or pick the right one), save, then Test
"Game server framework not detected: …"Automatic mode, and detection could not decide safelyFollow the reason given: right database, framework SQL imported, game server started with the resource. Or fix the framework. See Supported frameworks
"… Framework: QBox (automatic, from the database tables)."This is not an error: successful test on AutomaticNothing to fix: it is the framework in use and where it comes from
"The MySQL user must be able to create tables (CREATE)"The CREATE right is missingGrant CREATE, INDEX and ALTER on the database
"Vehicle table not found in the game database."Neither player_vehicles nor owned_vehiclesPlates and dealership unavailable: check the framework and your garage script
"Discord: no column…, for information"This is not an errorNothing to fix: characters are found through the linked license
"Database found (…) but on 127.0.0.1"Detection found an address local to the game serverEnter the address reachable from Agora

The connection timeout is 5 seconds: beyond that, Agora gives up rather than keep a page waiting.

Grant the right privileges #

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER
  ON `your_database`.* TO 'agora'@'203.0.113.10';
FLUSH PRIVILEGES;

When the game server is off #

  • Drop-down lists fed by the database (garages, jobs, columns) turn back into free text: nothing is blocked.
  • The browser MDT follows the Server unreachable policy in MDT → Settings: kept open (default) or suspended.
  • With the framework on Automatic, Agora keeps the last detected framework, or failing that the one the resource reported. If it has neither yet, the screen shows "Not detected: the game server database is not responding…": bring the database back, detection runs again by itself.

Other symptoms #

SymptomCause
"No character found for your account"The player has not linked their game: see Link your game
Not all jobs show upCatalogue "deduced from characters": connect the panel or SFTP
"Illegal mix of collations"Two tables with different collations: align on utf8mb4_unicode_ci
agora_* tables missingThe MDT was never opened, or the CREATE right is missing
"Could not find where player money is stored in this database." (dealership)Agora recognises neither players.money, nor users.accounts, nor users.money / users.bank: check the framework; with a home-made economy, the dealership cannot work

Was this article helpful?

Related articles