Server stopped connecting to SQL

FiveM Server Development Server Discussion
, , ,
1

Out of the blue my server stopped communicating with the sql server.
They are 2 different servers.
I get connect ETIMEOUT from mysqsl-async
the sql log it says (Got an error reading communication packets)
I’ve made no changes to the FiveM server or the SQL server.

All connections are working to the SQL server and to the FiveM server, they just stopped communicating with each other.

Has anyone run into this before?

2

Hi @Species8472,

Can you take a screenshot or add a snippet that contains the exact error you’re receiving?

Without that information, my best guess would be it has something to do with either:

  • Recent firewall/network change
  • High rate of connections
  • Queries could be timing out (PHP max_execution_time)
3

first is the fivem server error, second is the sql log.

fivemserver-error

sqlserver-error
sqlserver-error1547×199 146 KB

4

I found the solution. Don’t know why it happened now but I had to add

;connectTimeout=60000;acquireTimeout=60000;timeout=60000

to my server config for the database connection. It now connects. Makes no sense, nothing in the configuration of either server has changed.

5

Im having this same issue and im not sure where to input your solution… please help

6

it was added in the sql connection string
set mysql_connection_string “user=SQLUser123;password=xxxxxx;host=942.549.200.632;database=gta5;charset=utf8mb4;connectTimeout=90000;acquireTimeout=90000;timeout=90000”