I installed a fresh FiveM server on my dedicated server. Then I created a mySQL db. Then I placed mysql-async in \server-data\resources. I also placed the file police in \server-data\resources. I edited the server.cfg and when I launch the server I get this error.
[ERROR] [MySQL] An critical error happens on MySQL for query "CREATE TABLE IF NOT EXISTSpolice(identifiervarchar(255) COLLATE utf8_unicode_ci NOT NULL,deptint(11) NOT NULL DEFAULT '0',rankint(11) NOT NULL DEFAULT '0') {=}": Method 'System.Security.Cryptography.X509Certificates.X509Certificate2..ctor' not found. at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine] (TStateMachine& stateMachine) [0x0002c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
This is my server.cfg file.
only change these if you're using a server with multiple network interfaces
endpoint_add_tcp "0.0.0.0:30120"
endpoint_add_udp "0.0.0.0:30120"
set mysql_connection_string "server=127.0.0.1;database=fivem;userid=mylogin;password=mypw"
for example: sets tags "drifting, cars, racing" or sets tags "roleplay, military, tanks"
sets tags "default"
sv_hostname "Sown Test 2"
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!"
Uncomment to DISABLE your server coming up in the server list
sv_master1 ""
want to only allow players authenticated with a third-party provider like Steam (don't forget, Social Club is a third party provider 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
I installed a fresh FiveM server on my dedicated server. Then I created a mySQL db. Then I placed mysql-async in \server-data\resources. I also placed the file police in \server-data\resources. I edited the server.cfg and when I launch the server I get this error.
[ERROR] [MySQL] An critical error happens on MySQL for query "CREATE TABLE IF NOT EXISTSpolice(identifiervarchar(255) COLLATE utf8_unicode_ci NOT NULL,deptint(11) NOT NULL DEFAULT '0',rankint(11) NOT NULL DEFAULT '0') {=}": Method 'System.Security.Cryptography.X509Certificates.X509Certificate2..ctor' not found. at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine] (TStateMachine& stateMachine) [0x0002c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0This is my server.cfg file.
only change these if you're using a server with multiple network interfaces
endpoint_add_tcp "0.0.0.0:30120" endpoint_add_udp "0.0.0.0:30120" set mysql_connection_string "server=127.0.0.1;database=fivem;userid=mylogin;password=mypw"
start mapmanager start chat start spawnmanager start sessionmanager start fivem start hardcap start rconlog start scoreboard start playernames
start mysql-async start police
allow client mods such as Lamda Menu?
sv_scriptHookAllowed 1
change this
rcon_password yay
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"
sv_hostname "Sown Test 2"
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!"
Uncomment to DISABLE your server coming up in the server list
sv_master1 ""
want to only allow players authenticated with a third-party provider like Steam (don't forget, Social Club is a third party provider 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 32)
sv_maxclients 32
license key for server (https://keymaster.fivem.net)
sv_licenseKey
I've verified all downloads are up to date.