I added all the necessary esx resources to my server using a tutorial video, I also setup the mysql with HeidiSQL. Although when I enter a command like /dv or /giveitem a error pops up.
I have es_extended v.1.10.0 . Also on my SQL panel no users show up like in some of the videos I’ve watched.
Shaz
May 8, 2021, 12:11pm
3
Its trying to get data from a database named fivem not essentialmode
Shaz
May 8, 2021, 12:18pm
5
change your connection string database name from fivem to essentialmode
1 Like
set mysql_connection string "server=127.0.0.1;database=essentialmode;userid=root;password="
it is isn’t it?
that’s what i had from the beginning
Shaz
May 8, 2021, 12:23pm
9
Well here it sounds like its trying to get a database called “fivem”
thats an error from mysql-async. is there like a config for that alone?
Shaz
May 8, 2021, 12:27pm
11
not sure i dont use mysql-async
# This is NOT supposed to be enough for a fully running server.
# Please read the fivem documentation:
# https://docs.fivem.net/docs/server-manual/server-commands/
# https://docs.fivem.net/docs/server-manual/setting-up-a-server/
## You CAN edit the following:
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"
sv_maxclients 48
set steam_webApiKey "435C52BA44297C755F8518EDC3955BCF"
sets tags "default, deployer"
#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui
#DATABASE
set mysql_connection string "server=127.0.0.1;database=essentialmode;userid=root;password="
set es_enableCustomData 1
## You MAY edit the following:
sv_licenseKey "spyqrrsmbtr48tmnhzpai5ahuis90qqs"
sv_hostname "Chimes built with CFX Default by Tabarra!"
sets sv_projectName "[CFX Default] Chimes"
sets sv_projectDesc "Recipe for the base resources required to run a minimal FiveM server."
sets locale "root-AQ"
## These resources will start by default.
ensure cars
ensure esx_lscustom-master
ensure mapmanager
ensure chat
ensure chat-theme-gtao
ensure spawnmanager
ensure sessionmanager
ensure basic-gamemode
ensure hardcap
ensure CarCommand
ensure FCV
ensure Loading
ensure LegacyFuel-master
ensure fivem-map-hipster
ensure xnOnlineGarage-1.0.4
ensure lscustoms
#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui
## Add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.fivem:2105283 group.admin #InCrafter
ensure EasyAdmin
setr ea_LanguageName "en" # set our language to english
set ea_moderationNotification "false"
add_ace group.admin easyadmin allow```
Ah nevermind i googled someone elses config.cfg and now it works
#DATABASE
set mysql_connection string “server=127.0.0.1;database=fivem;userid=root;password=”
set es_enableCustomData 1
Solution
# This is NOT supposed to be enough for a fully running server.
# Please read the fivem documentation:
# https://docs.fivem.net/docs/server-manual/server-commands/
# https://docs.fivem.net/docs/server-manual/setting-up-a-server/
## You CAN edit the following:
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"
sv_maxclients 48
set steam_webApiKey "435C52BA44297C755F8518EDC3955BCF"
sets tags "default, deployer"
add_ace resource.essentialmode command.sets allow
add_ace resource.essentialmode command.add_principal allow
add_ace resource.essentialmode command.add_ace allow
#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui
#DATABASE
set mysql_connection_string "server=localhost;database=essentialmode;userid=root;"
set es_enableCustomData 1
## You MAY edit the following:
sv_licenseKey "spyqrrsmbtr48tmnhzpai5ahuis90qqs"
sv_hostname "Chimes built with CFX Default by Tabarra!"
sets sv_projectName "[CFX Default] Chimes"
sets sv_projectDesc "Recipe for the base resources required to run a minimal FiveM server."
sets locale "root-AQ"
## These resources will start by default.
ensure cars
ensure esx_lscustom-master
ensure mapmanager
ensure chat
ensure chat-theme-gtao
ensure spawnmanager
ensure sessionmanager
ensure basic-gamemode
ensure hardcap
ensure CarCommand
ensure FCV
ensure Loading
ensure LegacyFuel-master
ensure fivem-map-hipster
ensure xnOnlineGarage-1.0.4
ensure lscustoms
#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui
## Add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.fivem:2105283 group.admin #InCrafter
ensure EasyAdmin
setr ea_LanguageName "en" # set our language to english
set ea_moderationNotification "false"
add_ace group.admin easyadmin allow
1 Like
THAT WAS SO HELPFUL!!! THANK YOU![quote=“InCrafter, post:15, topic:2837076, full:true”]
Solution
# This is NOT supposed to be enough for a fully running server.
# Please read the fivem documentation:
# https://docs.fivem.net/docs/server-manual/server-commands/
# https://docs.fivem.net/docs/server-manual/setting-up-a-server/
## You CAN edit the following:
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"
sv_maxclients 48
set steam_webApiKey "435C52BA44297C755F8518EDC3955BCF"
sets tags "default, deployer"
add_ace resource.essentialmode command.sets allow
add_ace resource.essentialmode command.add_principal allow
add_ace resource.essentialmode command.add_ace allow
#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui
#DATABASE
set mysql_connection_string "server=localhost;database=essentialmode;userid=root;"
set es_enableCustomData 1
## You MAY edit the following:
sv_licenseKey "spyqrrsmbtr48tmnhzpai5ahuis90qqs"
sv_hostname "Chimes built with CFX Default by Tabarra!"
sets sv_projectName "[CFX Default] Chimes"
sets sv_projectDesc "Recipe for the base resources required to run a minimal FiveM server."
sets locale "root-AQ"
## These resources will start by default.
ensure cars
ensure esx_lscustom-master
ensure mapmanager
ensure chat
ensure chat-theme-gtao
ensure spawnmanager
ensure sessionmanager
ensure basic-gamemode
ensure hardcap
ensure CarCommand
ensure FCV
ensure Loading
ensure LegacyFuel-master
ensure fivem-map-hipster
ensure xnOnlineGarage-1.0.4
ensure lscustoms
#ESX
ensure essentialmode
ensure mysql_async
ensure esplugin_mysql
ensure es_extended
ensure async
ensure fxmigrant
ensure rc_mine
ensure rc_minerJob
ensure rc_notify
ensure trew_hud_ui
## Add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.fivem:2105283 group.admin #InCrafter
ensure EasyAdmin
setr ea_LanguageName "en" # set our language to english
set ea_moderationNotification "false"
add_ace group.admin easyadmin allow
[/quote]
system
Closed
June 21, 2021, 7:57am
18
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.