MySQL Connection String

FiveM Server Development Server Discussion
1

I am receiving this error in the console as I boot my server up:

Empty mysql_connection_string detected.
Error: (node:30705) UnhandledPromiseRejectionWarning: Error: Empty mysql_connect                         ion_string detected.
    at global.on (mysql-async.js:5143:13)
    at citizen:/scripting/v8/main.js:204:28
Error: (node:30705) UnhandledPromiseRejectionWarning: Unhandled promise rejectio                         n. This error originated either by throwing inside of an async function without                          a catch block, or by rejecting a promise which was not handled with .catch(). (r                         ejection id: 1)
Error: (node:30705) [DEP0018] DeprecationWarning: Unhandled promise rejections a                         re deprecated. In the future, promise rejections that are not handled will termi                         nate the Node.js process with a non-zero exit code.

I am running my database externally which seems to run fine on another resource. I am not sure why this error is occurring so it would be great to have some assistance with this.

1 Like
2

Hello, this is a friendly reminder because this is your first time creating a topic (or it has been a while since your last topic) in this category.

Please note that most of the support is provided by the FiveM community on a voluntary basis. We ask you to be patient; there is no guarantee we have a solution to your problem(s). To avoid unnecessary/duplicate topics, please browse the forums before creating a topic.

To improve your chances of your issue(s) being solved, please provide as much information as possible about the issue(s) you are having. Also —whenever possible— please use the template given to you when creating a topic.

Thanks for keeping these forums tidy!
:mascot:

3

Looks like you didn’t set your mysql credentials in server.cfg

4

It’s there

I’ve fixed the error message now and here is my log


root@rebornrp:/home/fx-server-data# bash /home/fx-server/run.sh +exec server.cfg
Resolved live-internal.fivem.net:30110 to 178.32.9.100:30110
Creating script environments for _cfx_internal
Found new resource fivem-map-skater in /home/fx-server-data/resources//fivem-map                          -skater
Found new resource fivem in /home/fx-server-data/resources//fivem
Found new resource esplugin_mysql in /home/fx-server-data/resources//esplugin_my                          sql
Found new resource runcode in /home/fx-server-data/resources//runcode
Found new resource fivem-map-hipster in /home/fx-server-data/resources//fivem-ma                          p-hipster
Found new resource fivem-awesome1501 in /home/fx-server-data/resources//fivem-aw                          esome1501
Found new resource mysql-async in /home/fx-server-data/resources//mysql-async
Found new resource essentialmode in /home/fx-server-data/resources//essentialmod                          e
Found new resource async in /home/fx-server-data/resources//async
Found new resource race in /home/fx-server-data/resources//[gamemodes]/race
Found new resource race-test in /home/fx-server-data/resources//[gamemodes]/race                          -test
Found new resource betaguns in /home/fx-server-data/resources//[test]/betaguns
Found new resource keks in /home/fx-server-data/resources//[test]/keks
Found new resource gameInit in /home/fx-server-data/resources//[test]/gameInit
Found new resource mapmanager in /home/fx-server-data/resources//[managers]/mapm                          anager
Found new resource es_extended in /home/fx-server-data/resources//[essential]/es                          _extended
Found new resource playernames in /home/fx-server-data/resources//[gameplay]/pla                          yernames
Found new resource obituary-deaths in /home/fx-server-data/resources//[gameplay]                          /obituary-deaths
Found new resource irc in /home/fx-server-data/resources//[gameplay]/irc
Found new resource obituary in /home/fx-server-data/resources//[gameplay]/obitua                          ry
Found new resource channelfeed in /home/fx-server-data/resources//[gameplay]/cha                          nnelfeed
Found new resource â– â– â– â– â– â– â–  in /home/fx-server-data/resources//[system]/â– â– â– â– â– â– â– 
Found new resource baseevents in /home/fx-server-data/resources//[system]/baseev                          ents
Found new resource chat in /home/fx-server-data/resources//[system]/chat
Found new resource sessionmanager in /home/fx-server-data/resources//[system]/se                          ssionmanager
Found new resource chat-theme-gtao in /home/fx-server-data/resources//[system]/c                          hat-theme-gtao
Found new resource scoreboard in /home/fx-server-data/resources//[system]/scoreb                          oard
Found new resource hardcap in /home/fx-server-data/resources//[system]/hardcap
Found new resource spawnmanager in /home/fx-server-data/resources//[system]/spaw                          nmanager
Found new resource webpack in /home/fx-server-data/resources//[system]/[builders                          ]/webpack
Found new resource yarn in /home/fx-server-data/resources//[system]/[builders]/y                          arn
Found new resource esx_menu_default in /home/fx-server-data/resources//[esx]/[ui                          ]/esx_menu_default
Found new resource esx_menu_list in /home/fx-server-data/resources//[esx]/[ui]/e                          sx_menu_list
Found new resource esx_menu_dialog in /home/fx-server-data/resources//[esx]/[ui]                          /esx_menu_dialog
Creating script environments for sessionmanager
Started resource sessionmanager
Could not bind on ip:30120 - is this address valid and not already in use?
No such command `set.
No such command `set.
No such command `set.
No such command `set.
Creating script environments for mapmanager
Started resource mapmanager
Creating script environments for chat
Started resource chat
Started resource spawnmanager
Started gametype Freeroam
Started resource fivem
Creating script environments for hardcap
Started resource hardcap
Creating script environments for â– â– â– â– â– â– â– 
Started resource â– â– â– â– â– â– â– 
Creating script environments for mysql-async
Started resource mysql-async
Creating script environments for essentialmode
Loaded SQLite.net, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null into Sc                          riptDomain_1358718216
Instantiated instance of script SQLite.Main.
Started resource essentialmode
Creating script environments for esplugin_mysql
Started resource esplugin_mysql
Creating script environments for async
Started resource async
Creating script environments for es_extended
Started resource es_extended
Started resource esx_menu_default
Started resource esx_menu_list
Started resource esx_menu_dialog
Authenticating server license key...
Server license key authentication succeeded. Welcome!
cfx> Sending heartbeat to live-internal.fivem.net:30110
Performing version check against: https://api.kanersps.pw/em/version?version=6.2                          .1&uuid=918cea2e-0b81-4506-7f22-7ebf351a8dc5

Started map fivem-map-skater
Started resource fivem-map-skater

[EssentialMode] Current version: 6.2.1
[EssentialMode] Updater version: 6.2.1

Access denied for command sets.
Access denied for command sets.
[EssentialMode] Everything is nice and updated!

I don’t know what “access denied for command sets” mean or why it says “Could not bind on ip:30120 - is this address valid and not already in use?”
All I have installed currently is ESX and it’s prerequisites.

5

Means you are trying to host a server on a port which is already taken

6

How would I go about changing the port for future reference?

I’ve fixed the issues but I am now noticing the argument count mismatch in which I have no clue on the steps to resolve this.


Argument count mismatch (passed 8, wanted 2)
Argument count mismatch (passed 32, wanted 2)
Argument count mismatch (passed 26, wanted 2)

and this error after being in-game


Error: (node:4263) UnhandledPromiseRejectionWarning: AssertionError [ERR_ASSERTI                 ON]: unexpected PromiseRejectEvent
    at process.<anonymous> (internal/process/promises.js:27:25)
    at <anonymous>
    at Query.db.query (mysql-async.js:5223:9)
    at Query.<anonymous> (mysql-async.js:1117:10)
    at Query._callback (mysql-async.js:1083:16)
    at Query.Sequence.end (mysql-async.js:275:24)
    at Query.ErrorPacket (mysql-async.js:2237:8)
    at Protocol._parsePacket (mysql-async.js:6296:23)
    at Parser._parsePacket (mysql-async.js:6907:10)
    at Parser.write (mysql-async.js:6517:10)
Error: (node:4263) UnhandledPromiseRejectionWarning: Unhandled promise rejection                 . This error originated either by throwing inside of an async function without a                  catch block, or by rejecting a promise which was not handled with .catch(). (re                 jection id: 1)
Error: (node:4263) [DEP0018] DeprecationWarning: Unhandled promise rejections ar                 e deprecated. In the future, promise rejections that are not handled will termin                 ate the Node.js process with a non-zero exit code.
Error: (node:4263) UnhandledPromiseRejectionWarning: Error: ER_DATA_TOO_LONG: Da                 ta too long for column 'position' at row 1
    at Query.Sequence._packetToError (mysql-async.js:239:14)
    at Query.ErrorPacket (mysql-async.js:2224:18)
    at Protocol._parsePacket (mysql-async.js:6296:23)
    at Parser._parsePacket (mysql-async.js:6907:10)
    at Parser.write (mysql-async.js:6517:10)
    at Protocol.write (mysql-async.js:6043:16)
    at Socket.<anonymous> (mysql-async.js:683:28)
    at Socket.<anonymous> (mysql-async.js:1117:10)
    at emitOne (events.js:116:13)
    at Socket.emit (events.js:211:7)
    --------------------
    at Pool.query (mysql-async.js:4910:23)
    at Promise (mysql-async.js:5220:10)
    at new Promise (<anonymous>)
    at MySQL.execute (mysql-async.js:5216:26)
    at Object.global.exports [as callback] (mysql-async.js:5101:9)
    at citizen:/scripting/v8/main.js:96:41
Error: (node:4263) UnhandledPromiseRejectionWarning: Unhandled promise rejection                 . This error originated either by throwing inside of an async function without a                  catch block, or by rejecting a promise which was not handled with .catch(). (re                 jection id: 2)
7

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.