[Release] EssentialMode base

I am getting a lot of errors when setting up Essentialmode.
I get this error:

— Error detected in authentication, please take a look at your convars for essentialmode. —

And a ton(probably 50+ errors) of these:
[ERROR] [MySQL] An critical error happens on MySQL for query “SELECT * FROM items {=}”: Authentication method ‘caching_sha2_password’ is not supported. at MySql.Data.Serialization.MySqlSession+d__49.MoveNext () [0x00311] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at MySql.Data.MySqlClient.ConnectionPool+d__0.MoveNext () [0x00467] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at MySql.Data.MySqlClient.MySqlConnection+d__68.MoveNext () [0x00102] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0

Help?

From my server.cfg:
es_couchdb_password “test:test”
es_couchdb_port 5984
es_couchdb_url 127.0.0.1

When I am using the command “wladd” on essentialX’s whitelist script, I get this error:
rror running call reference function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:351: servecfx> r/main.lua:234: attempt to index a nil value (field ‘?’)

What are these errors?

Been having huge issues getting this working. last error was access this database when the server started and i fixed this by changing the resource.lua file to server_script ‘@mysql-async/lib/MySQL.lua’ instead of mysql-async.js

Now when any user logins i get this error:
Error running system event handling function for resource esplugin_mysql: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: citizen:/scripting/lua/scheduler.lua:657: No such export mysql_fetch_all in resource mysql-async
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:657: in metamethod ‘__index’
@mysql-async/lib/MySQL.lua:143: in field ‘fetchAll’
server.lua:15: in upvalue ‘handler’
citizen:/scripting/lua/scheduler.lua:175: in function citizen:/scripting/lua/scheduler.lua:174
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:41: in field ‘CreateThreadNow’
citizen:/scripting/lua/scheduler.lua:174: in function citizen:/scripting/lua/scheduler.lua:138
any ideas on how to fix

anyone know how to add more roles into es_admin2? I know of a server that had roles such as:

  • moderator
  • admin in training
  • admin
  • senior admin
  • elite admin
  • community manager
  • head admin
  • co owner
  • owner

I would be happy if I could even get it so they had the same perms as the defaults. E.g.

  • admin in training has moderator perms ect

Hello, someone can help me with Error? I seen many topics and no one helps me.

[ERROR] [MySQL] Check the error above, an error happens when executing the callback from the query : “SELECT * FROM users WHERE job = @job ORDER BY job_grade DESC {@job=police}”

In Action-Boss only Employee List not working in Employee Managment, Recruit works :X can’t see a employee ppl in job (Mecano, EMS and Police, idk how other jobs but probably too)

Yo could anyone help me get some error fixed? tried to figure it out but havent solved the problem

So well this is what i have installed
mysql-async
essentialmode
esplugin_mysql
es_admin2

Everything runs great server starts but i get alot of errors in the console and i cant figure out why

This is how my config looks like

set es_enableCustomData 1
set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root;password=SECRET"
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"

start mapmanager
start chat
start spawnmanager
start sessionmanager
start fivem
start hardcap
start ■■■■■■■
start scoreboard
start playernames

# Starting Essentialmode
start mysql-async
start essentialmode
start esplugin_mysql
start es_admin2

sv_scriptHookAllowed 1

# change this
#rcon_password SECRET

# a comma-separated list of tags for your server
# for example: sets tags "drifting, cars, racing" or sets tags "roleplay, military, tanks"
sets tags "default"

# set an optional server info and connecting banner image url.
# size doesn't matter, any banner sized image will be fine.
#sets banner_detail "http://url.to/image.png"
#sets banner_connecting "http://url.to/image.png"

sv_hostname "beta server"

# nested configs!
#exec server_internal.cfg

# loading a server icon (96x96 PNG file)
#load_server_icon myLogo.png

# convars for use from script
set temp_convar "hey world!"

# disable announcing? clear out the master by uncommenting this (your server will not be listed in the serverlist if you uncomment this!)
#sv_master1 ""

# want to only allow players authenticated with a third-party provider like Steam (don't forget, Social Club is a third party probvider too!)?
#sv_authMaxVariance 1
#sv_authMinTrust 5

# 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.steam:110000112345678 group.admin # add the admin to the group

# remove the # to hide player endpoints in external log output
sv_endpointprivacy true

# server slots limit (must be between 1 and 31)
sv_maxclients 30

# license key for server (https://keymaster.fivem.net)
sv_licenseKey "n7peep5yc6j344u8se6mfghw1i3s675i"

i have placed essentialmode, Esplugin_mysql and Es_admin2 in resources folder

And this is the errors i get

C:\Users\proffset\Desktop\FXServer>cd C:\Users\proffset\Desktop\FXServer

C:\Users\proffset\Desktop\FXServer>C:\Users\proffset\Desktop\FXServer\run.cmd +exec server.cfg
INFO: No channel links found in configuration file.
Resolved live-internal.fivem.net:30110 to 178.32.9.100:30110
Found new resource esplugin_mysql in C:/Users\proffset\Desktop\FXServer/resources//esplugin_mysql
Found new resource essentialmode in C:/Users\proffset\Desktop\FXServer/resources//essentialmode
Found new resource es_admin2 in C:/Users\proffset\Desktop\FXServer/resources//es_admin2
Found new resource fivem in C:/Users\proffset\Desktop\FXServer/resources//fivem
Found new resource fivem-awesome1501 in C:/Users\proffset\Desktop\FXServer/resources//fivem-awesome1501
Found new resource fivem-map-hipster in C:/Users\proffset\Desktop\FXServer/resources//fivem-map-hipster
Found new resource fivem-map-skater in C:/Users\proffset\Desktop\FXServer/resources//fivem-map-skater
Found new resource mysql-async in C:/Users\proffset\Desktop\FXServer/resources//mysql-async
Found new resource runcode in C:/Users\proffset\Desktop\FXServer/resources//runcode
Found new resource race in C:/Users\proffset\Desktop\FXServer/resources//[gamemodes]/race
Found new resource race-test in C:/Users\proffset\Desktop\FXServer/resources//[gamemodes]/race-test
Found new resource channelfeed in C:/Users\proffset\Desktop\FXServer/resources//[gameplay]/channelfeed
Found new resource irc in C:/Users\proffset\Desktop\FXServer/resources//[gameplay]/irc
Found new resource obituary in C:/Users\proffset\Desktop\FXServer/resources//[gameplay]/obituary
Found new resource obituary-deaths in C:/Users\proffset\Desktop\FXServer/resources//[gameplay]/obituary-deaths
Found new resource playernames in C:/Users\proffset\Desktop\FXServer/resources//[gameplay]/playernames
Found new resource mapmanager in C:/Users\proffset\Desktop\FXServer/resources//[managers]/mapmanager
Found new resource baseevents in C:/Users\proffset\Desktop\FXServer/resources//[system]/baseevents
Found new resource chat in C:/Users\proffset\Desktop\FXServer/resources//[system]/chat
Found new resource hardcap in C:/Users\proffset\Desktop\FXServer/resources//[system]/hardcap
Found new resource ■■■■■■■ in C:/Users\proffset\Desktop\FXServer/resources//[system]/■■■■■■■
Found new resource scoreboard in C:/Users\proffset\Desktop\FXServer/resources//[system]/scoreboard
Found new resource sessionmanager in C:/Users\proffset\Desktop\FXServer/resources//[system]/sessionmanager
Found new resource spawnmanager in C:/Users\proffset\Desktop\FXServer/resources//[system]/spawnmanager
Found new resource betaguns in C:/Users\proffset\Desktop\FXServer/resources//[test]/betaguns
Found new resource gameInit in C:/Users\proffset\Desktop\FXServer/resources//[test]/gameInit
Found new resource keks in C:/Users\proffset\Desktop\FXServer/resources//[test]/keks
Found new resource yarn in C:/Users\proffset\Desktop\FXServer/resources//[system]/[builders]/yarn
Started resource sessionmanager
Started resource mapmanager
Started resource chat
Started resource spawnmanager
Started gametype Freeroam
Started resource fivem
Started resource hardcap
Started resource ■■■■■■■
Started resource scoreboard
Started resource playernames
Loaded MySQLAsync.net, Version=2.0.2.0, Culture=neutral, PublicKeyToken=null into ScriptDomain_1060395707
Instantiated instance of script MySQLAsync.MySQLAsync.
Started resource mysql-async
Started resource essentialmode
Started resource esplugin_mysql
Started resource es_admin2
Authenticating server license key...
Server license key authentication succecfx> eded. Welcome!
Sending heartbeat to live-internal.fivem.net:30110

Current version: 5.0.3
Updater version: 5.0.3

Everything is fine!

Started map fivem-map-skater
Started resource fivem-map-skater
InvokeNative: execution failed: Argument at index 1 was null.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Value does not fall within the expected range.


Server stack trace:
  at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR (System.Int32 errorCode) [0x0000a] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
  at (wrapper cominterop) CitizenFX.Core.IScriptHost:InvokeNative (CitizenFX.Core.fxScriptContext&)
  at (wrapper cominterop-invoke) CitizenFX.Core.IScriptHost:InvokeNative (CitizenFX.Core.fxScriptContext&)
  at CitizenFX.Core.MonoScriptRuntime+WrapScriptHost.InvokeNative (CitizenFX.Core.fxScriptContext& context) [0x00000] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\MonoScriptRuntime.cs:254
  at (wrapper remoting-invoke-with-check) CitizenFX.Core.MonoScriptRuntime+WrapScriptHost:InvokeNative (CitizenFX.Core.fxScriptContext&)
  at (wrapper xdomain-dispatch) CitizenFX.Core.MonoScriptRuntime+WrapScriptHost:InvokeNative (object,byte[]&,byte[]&)

Exception rethrown at [0]:
  at (wrapper xdomain-invoke) CitizenFX.Core.MonoScriptRuntime+WrapScriptHost:InvokeNative (CitizenFX.Core.fxScriptContext&)
  at CitizenFX.Core.ScriptContext.InvokeInternal (System.UInt64 nativeIdentifier, CitizenFX.Core.IScriptHost scriptHost) [0x0000c] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\ScriptContext.cs:184
  at CitizenFX.Core.ScriptContext.Invoke (System.UInt64 nativeIdentifier, CitizenFX.Core.IScriptHost scriptHost) [0x00000] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\ScriptContext.cs:177
  at CitizenFX.Core.Native.Function.InvokeInternal (CitizenFX.Core.Native.Hash nativeHash, System.Type returnType, CitizenFX.Core.Native.InputArgument[] args) [0x00026] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\Native.cs:28
  at CitizenFX.Core.Native.Function.Call[T] (CitizenFX.Core.Native.Hash hash, CitizenFX.Core.Native.InputArgument[] arguments) [0x00000] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\Native.cs:11
  at MySQLAsync.MySQLAsync.<.ctor>b__2_0 () [0x00037] in <6b79789832b34a31961dbb39358e1b3f>:0
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00032] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
   --- End of inner exception stack trace ---


Server stack trace:
  at System.Reflection.MonoMethod.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00048] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
  at System.Reflection.MethodBase.Invoke (System.Object obj, System.Object[] parameters) [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
  at System.Delegate.DynamicInvokeImpl (System.Object[] args) [0x000e7] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
  at System.MulticastDelegate.DynamicInvokeImpl (System.Object[] args) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
  at System.Delegate.DynamicInvoke (System.Object[] args) [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
  at CitizenFX.Core.FunctionReference.Invoke (System.Int32 reference, System.Byte[] arguments) [0x00062] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\FunctionReference.cs:62
  at CitizenFX.Core.InternalManager.CallRef (System.Int32 refIndex, System.Byte[] argsSerialized, System.IntPtr& retvalSerialized, System.Int32& retvalSize) [0x00000] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\InternalManager.cs:249
  at (wrapper remoting-invoke-with-check) CitizenFX.Core.InternalManager:CallRef (int,byte[],intptr&,int&)
  at (wrapper xdomain-dispatch) CitizenFX.Core.InternalManager:CallRef (object,byte[]&,byte[]&,int,byte[],int&)

Exception rethrown at [0]:
  at (wrapper xdomain-invoke) CitizenFX.Core.InternalManager:CallRef (int,byte[],intptr&,int&)
  at (wrapper remoting-invoke-with-check) CitizenFX.Core.InternalManager:CallRef (int,byte[],intptr&,int&)
  at CitizenFX.Core.MonoScriptRuntime.CallRef (System.Int32 refIndex, System.Byte[] argsSerialized, System.Int32 argsSize, System.IntPtr& retvalSerialized, System.Int32& retvalSize) [0x00013] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\MonoScriptRuntime.cs:151
Error running system event handling function for resource mysql-async: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: citizen:/scripting/lua/scheduler.lua:665: An error happened while calling export mysql_configure of resource mysql-async (citizen:/scripting/lua/MessagePack.lua:830: missing bytes), see above for details
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:665: in method 'mysql_configure'
        lib/init.lua:3: in upvalue 'handler'
        citizen:/scripting/lua/scheduler.lua:175: in function <citizen:/scripting/lua/scheduler.lua:174>
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow'
        citizen:/scripting/lua/scheduler.lua:174: in function <citizen:/scripting/lua/scheduler.lua:138>

If anyone knows how to solve this / help me solve it would be awesome! thanks in regards / brohype

I get this error message when i do /kick can someone help me? image

since this morning whenever i run a command in esx (es:addAdminGroup) i get a invalid ref call attempt error

fixed reverting latest windows artifact build server to an older one

I have an error updating from essentialmode 4 to 5

Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: citizen:/scripting/lua/scheduler.lua:547: Cannot index a funcref
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:547: in metamethod '__index'
        server/main.lua:169: in function 'addCommand'
        server/main.lua:183: in upvalue 'handler'
        citizen:/scripting/lua/scheduler.lua:175: in function <citizen:/scripting/lua/scheduler.lua:174>
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow'
        citizen:/scripting/lua/scheduler.lua:174: in function <citizen:/scripting/lua/scheduler.lua:138>
Error running system event handling function for resource essentialmode: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: citizen:/scripting/lua/scheduler.lua:547: Cannot index a funcref
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:547: in metamethod '__index'
        server/main.lua:169: in function 'addCommand'
        server/main.lua:183: in upvalue 'handler'
        citizen:/scripting/lua/scheduler.lua:175: in function <citizen:/scripting/lua/scheduler.lua:174>
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow'
        citizen:/scripting/lua/scheduler.lua:174: in function <citizen:/scripting/lua/scheduler.lua:138>

Can someone help me?

I am downloading EssentialMode 5.0.3 to start a new life … does anyone want to advise me if it is compatible with Mysql or CouchDB ?? in which of the two I can put work script - food - etc…and one last question it is important to also have the FXServer !! sorry for my bad English…

Hey There, i have a error with the commands

endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"

set es_enableCustomData 1 
set mysql_connection_string "server=127.0.0.1;database=essentialmode;userid=root"

start es_extended
start mapmanager
start chat
start spawnmanager
start sessionmanager
start fivem
start hardcap
start ■■■■■■■
start scoreboard
start playernames

start mysql-async
start essentialmode
start esplugin_mysql
start es_admin2
start async


#inserted trough ZAP ressourcesystem
## From ESX Pack ##

start esplugin
start Vehicles
start vSync
start OverheidVehicles
start carhud

start async
start cron

start els
start elsplus
start RealisticVehicleFailure
start handling_mod

start esx_accessories
start esx_addonaccount
start esx_addoninventory
start esx_phone
start esx_ambulancejob
start esx_animations
start esx_atm

start esx_bankerjob
start esx_barbershop
start esx_basicneeds
start esx_billing
start esx_boilerplate
start esx_clotheshop
start esx_cruisecontrol
start esx_datastore
start esx_dmvschool
start esx_drugs

start esx_garage
start esx_holdup
start esx_identity
start esx_joblisting
start esx_jobs
start esx_license
start esx_lscustom
start esx_mecanojob
start esx_menu_default
start esx_menu_dialog
start esx_menu_list
start esx_optionalneeds
start esx_policejob
start esx_property

start esx_realestateagentjob
start esx_rpchat
start esx_service
start esx_shops
start esx_sit
#start esx_skin - Werkt niet
#start esx_society - FOUTTIEF WERKT NIET!
start esx_status
#goed hieronder
start esx_taxijob
start esx_vehicleshop
start esx_voice
start esx_weashops
start es_camera
start instance
start skinchanger
## End of ESX Pack ##

sv_scriptHookAllowed 0

# change this
#rcon_password yay

Who can help me to fix this?

Can someone help me with this?
https://pastebin.com/tKfkbapi
I can send more info if needed.

essential is installed i just when i go to localhost to log in it says couldnt find nearly everything i have started
please help

Hi, I am having this error with the most recent update of mysql-async & esplugin_mysql. This is the error.

rror running system event handling function for resource esplugin_mysql: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: citizen:/scripting/lua/scheduler.lua:655: No such export mysql_fetch_all in resource mysql-async
stack traceback:
    [C]: in function 'error'
    citizen:/scripting/lua/scheduler.lua:655: in metamethod '__index'
    @mysql-async/lib/MySQL.lua:143: in field 'fetchAll'
    server.lua:15: in upvalue 'handler'
    citizen:/scripting/lua/scheduler.lua:175: in function <citizen:/scripting/lua/scheduler.lua:174>
stack traceback:

Basically I can’t do much of anything, no ui elements work as expected, I can’t join jobs or buy houses. Pretty much any addon that uses an sql link doesn’t work properly.

How do I open the es_admin2 menu in-game?

Home key

(fucking20chars)

Home Key take me to my desktop. I’m on Windows 7.

That definitely doesn’t change the fact that es_admin2 is mapped to the home key(not your Windows key).

oh well I just try the home key and it did nothing

Can I get help

How to fix Negative money server

I want players to have negative money