Installed mysql-async version 3.3.2 and followed the instructions on the web link here: mysql-async Documentation - mysql-async Documentation
Then specified the settings for my database in the usual way as below:
set mysql_connection_string “user=cust33146;database=cust33146;host=10.168.11.2;password=password123”
This generated the following prompt each time you start the server:
[mysql-async] [ERROR] connect ECONNREFUSED 127.0.0.1:3306
I then did a search on all files for 127.0.0.1 and found this was manually set in:
server-data\resources\mysql-async\src\entry\server.ts
server-data\resources\mysql-async\mysql-async.js
So I changed the settings there to the correct ones for my remote database cluster. I then restarted the server and again noticed the same error:
[mysql-async] [ERROR] connect ECONNREFUSED 127.0.0.1:3306
So something is causing the server to only look for the database on the local machine. However I am at a loss as to what I’m doing wrong. So have opened this as a bug.
FiveM server is hosted on:
Server 2019 Standard
i7-7700K
128GB RAM
Database Server:
Ubuntu Server 20.04.1
MySQL 8.0.22
Xeon 1230v6
4GB RAM