[How-to] Setup FXServer with MySQL and Essentialmode4

andsim · February 3, 2019, 7:13am

my have no data at all in the database but getting this

i tried get developer of this addon no response from them

Fabien_Jost · February 4, 2019, 9:26am

hello, can you tell me if i do a good job ? Sorry i’m beginner on FIVEM

I have 2 errors

Access Ddenied for command sets.

I can connect on my serv and play.

HalCroves · February 4, 2019, 12:18pm

@Fabien_Jost Check this => https://wiki.kanersps.pw/display/FIV/Installation

MRS · February 7, 2019, 2:42pm

have you opened your ports?

Dankyz · February 7, 2019, 7:06pm

Hello,

What is the command to stop the server?
My server location in my linux is /home/FiveM/server-data

HalCroves · February 8, 2019, 12:47pm

Manage server FiveM (restart/start/stop/screen/status) on linux ?

Aethbrine · February 23, 2019, 11:14pm

if you have a password

ED919 · February 27, 2019, 1:27am

can someone help me with this error

MattyBDidItAgain · February 27, 2019, 2:07am

127.0.0.01 is NOT the same as 127.0.0.1 (as it should be)

ED919 · February 27, 2019, 2:28am

can you tell me how to fix it

MattyBDidItAgain · February 27, 2019, 3:04am

change 127.0.0.01 to 127.0.0.1

mrfuge · February 27, 2019, 9:35pm

Hello, I keep getting this error —> https://pastebin.com/YRqpRJV8

I am able to connect and play on my server, and i have verified the credentials in my server.cfg "set mysql_connection_string “server=localhost;database=essentialmode;userid=root;password=password”

I get it for 4 different esx plugins. I am able to access my db and see all the tables, etc. Any ideas on how to fix this? I’ve searched the web to no avail. Thanks in advance

ED919 · February 27, 2019, 10:06pm

is working thanks

MattyBDidItAgain · February 28, 2019, 4:57am

@mrfuge
Try this
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPasswordGoesInsideHere';
then run
FLUSH PRIVILEGES;

Zad · April 8, 2019, 12:19am

Hi.
Its my first time trying to make a fiveM server…
I have installed it all and cant se anny errors at the server.
But when i try to joini get ‘Error cant load resource’ anyone know why?

AlinGP4 · April 11, 2019, 9:20pm

Loaded SQLite.net, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null into ScriptDomain_1551468581
Failed to instantiate instance of script SQLite.Main: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.DllNotFoundException: SQLite.Interop.dll
at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(System.Data.SQLite.SQLiteConfigOpsEnum)
at System.Data.SQLite.SQLite3.StaticIsInitialized () [0x0001d] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.SQLite.SQLiteLog.Initialize (System.String className) [0x00026] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.SQLite.SQLiteConnection…ctor (System.String connectionString, System.Boolean parseViaFramework) [0x00046] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at System.Data.SQLite.SQLiteConnection…ctor (System.String connectionString) [0x00000] in <2dbd34e157eb4fefbab8047bc0d9632d>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection…ctor(string)
at SQLite.Main…ctor () [0x0004f] in :0
at (wrapper managed-to-native) System.Reflection.MonoCMethod.InternalInvoke(System.Reflection.MonoCMethod,object,object[],System.Exception&)
at System.Reflection.MonoCMethod.InternalInvoke (System.Object obj, System.Object[] parameters, System.Boolean wrapExceptions) [0x00005] in :0
— End of inner exception stack trace —
at System.Reflection.MonoCMethod.InternalInvoke (System.Object obj, System.Object[] parameters, System.Boolean wrapExceptions) [0x00017] in :0
at System.RuntimeType.CreateInstanceMono (System.Boolean nonPublic, System.Boolean wrapExceptions) [0x000a8] in :0
at System.RuntimeType.CreateInstanceSlow (System.Boolean publicOnly, System.Boolean wrapExceptions, System.Boolean skipCheckThis, System.Boolean fillCache, System.Threading.StackCrawlMark& stackMark) [0x00009] in :0
at System.RuntimeType.CreateInstanceDefaultCtor (System.Boolean publicOnly, System.Boolean skipCheckThis, System.Boolean fillCache, System.Boolean wrapExceptions, System.Threading.StackCrawlMark& stackMark) [0x00027] in :0
at System.Activator.CreateInstance (System.Type type, System.Boolean nonPublic, System.Boolean wrapExceptions) [0x00020] in :0
at System.Activator.CreateInstance (System.Type type, System.Boolean nonPublic) [0x00000] in :0
at System.Activator.CreateInstance (System.Type type) [0x00000] in :0
at CitizenFX.Core.InternalManager.CreateAssemblyInternal (System.String assemblyFile, System.Byte[] assemblyData, System.Byte[] symbolData) [0x000af] in /src/code/client/clrcore/InternalManager.cs:102

some help ther i can’t start ¿?

MrFredFazbear · May 12, 2019, 8:25pm

Thank you soooooo much this worked for me perfectly

wanfir019 · May 20, 2019, 1:16am

Thank you so much for making this topic. I been looking about 3-5 guide and almost all of it missing few key infos… Cheers !

7035bf35321506b06889 · May 22, 2019, 12:43pm

can someone help me with this error

BoboBijo · May 23, 2019, 6:11pm

Im getting this when my server is up

[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM coffees {=}”: Unable to connect to any of the specified MySQL hosts. [ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM weashops {=}”: Unable to connect to any of the specified MySQL hosts. [ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM shops {=}”: Unable to connect to any of the specified MySQL hosts. [ERROR] [MySQL] An error happens on MySQL for query “SELECT 1 FROM users WHERE identifier =@identifier; {identifier=steam:11000010ba*****}”: Unable to connect to any of the specified MySQL hosts. [ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM jail WHERE identifier=@id {@id=steam:11000010ba*****}”: Unable to connect to any of the specified MySQL hosts.