[Urgent] Issue with server database and esx_policejob

mysql
issue
database
serverissue

#1

Hello everyone,

I have been working on a server for the past few days and with a ton of issues. Firstly when a new player joins everyone in the server disconnects including me and it says “timed out” and the server itself stops. Furthermore, in the database when I add esx_policejob in the server.cfg things like items and user_licenses randomly disappear from the database. Also, ID Card and Search randomly stopped working for me just a few minutes ago. Any help will be appreciated and I will provide anything needed to fix this issue. Server is running on nfoservers.com and I am using Linux with phpMyAdmin.

Here’s my server.cfg

# you probably don't want to change these!
# only change them 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 es_enableCustomData 1
set mysql_connection_string "server=127.0.0.1;database=xxxxx;userid=xxxxx;password=xxxxx;"
set sv_licenseKey xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

### ESSENTIAL ####
start scoreboard #
start customchat
start mapmanager #
start sessionmanager #
start spawnmanager #
start fivem #
start hardcap #
start es_admin2 #
start es_camera #
start esplugin_mysql #
start essentialmode #
start es_extended #
start mysql-async #
start rconlog #

#### Basics ####
start baseevents #
start bob74_ipl #
start commands
#start coloredhud
start cron #
start deleteveh
start fivem-map-skater #
start idoverhead
start instance #
#start xnLoad-master
#start NoDriveBy 
start outlawalert
start PvP
start skinchanger #
start streetLabel #
start VK_main
#start wk_vehdamage
start RealisticVehicleFailure #
start deathmessages
#start NoReticle

#### ESX ####
start new_banking #
start esx_addonaccount #
start esx_phone # phone3
start esx_addoninventory #
start esx_AdvancedFuel #
start esx_aiomenu #
start esx_ambulancejob #
start esx_animations #
start esx_barbershop
start esx_basicneeds #
start esx_billing #
start esx_carwash #
start esx_clotheshop
start esx_datastore
start esx_deliveryjob
start esx_dmvschool #
start esx_drugs #
start esx_eden_garage #
start esx_firejob #
start esx_holdup #
start esx_identity ##
start esx_joblisting ##
start esx_jobs #
start esx_license #
start esx_lscustom #
start esx_mask
start esx_mecanojob #
start esx_menu_default #
start esx_menu_dialog #
start esx_menu_list #
start esx_property #
start esx_realestateagentjob #
start esx_service #
start esx_shops #
start esx_sit
start esx_skin #
start esx_society #
start esx_policejob #
start esx_jailer #
start esx_status #
start esx_taxijob #
start esx_truckerjob
start esx_vehicleshop #
start esx_voice #
start esx_weashops #
start esx_brinksjob #
start esx_gopostal
start esx_holdupbank
start esx_airlines #
start esx_optionalneeds #
start esx_mafia # mafiajob
#start esx_rebel
start esx_coffee
start esx_securityjob
start esx_pizza #
start esx_bennys
start esx_garbagejob #
start esx_tattoosShops #
#start esx_ranger
start esx_traffic
start esx_clip
#start esx_unicornjob
#start esx_bus
start esx_dockshop #
start esx_coastguard
start esx_lsd-master
#start esx_turtle
start esx_rodriguez
start esx_rpchat
#start esx_pearl
#start esx_bishops
start esx_bountyhunter
start esx_litter
start esx_dismay
start esx_grove
start ESX_binoculars
start esx_plasticsurgery
start esx_vehiclelock
start esx_vehicle_inventory #

#### Cars ####
start 2016-chp-megapack
start cars
start pdmegapack
start EMSPack
start sfjrp_bcsopack
start doomsday_vehicles
start viktoraddoncars
start Captain14_LSPD
start unmarked
start sfjrp_bcso
start pol718
start polaventa
start pack1
start hurkf350
start 69charger
start rmodamgc63
start addonr35

#### Other Addons ####
start carhud
start guns
start handsup 
start hospital #
#start Jailer # esx_jailer
start knockout
start LEOAnimations
start lux_vehcontrol #
start peds #
start pointing
start pv-tow
start vengine
start wk_wrs
start vehcontrol
start PTTPoliceRadio
#start disclaimer
start disclaimer_new
start marker
#start eden_jail
#start timesync
start starPursuit
#start speedo
start clothes #
start hat
start drop
start eden_accesories
start nos
start chopshop
start VehicleExtraMenu #
start els-fivem #
start eden_animal-master ##
start welcome_new 
start keks_n
start vSync
start celldoors

sv_scriptHookAllowed 0

# change this
rcon_password savage

sv_hostname "xxxxxxxxxxxxxx | Snow | Serious RP | Jobs | xxxxxx | CUSTOM CARS |"

# nested configs!
#exec server_internal.cfg

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

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

# disable announcing? clear out the master by uncommenting this
#sv_master1 ""

# want to only allow players authenticated with a third-party provider like Steam?
#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_ace resource.essentialmode command.add_principal allow
add_principal identifier.steam:110000112345678 group.admin # add the admin to the group

# hide player endpoints in external log output
sv_endpointprivacy true

# server slots limit (default to 30)
sv_maxclients 32

Regards,
Ralf


#2

Not a FiveM issue, moved to #development:scripts


#3

Thats WAY too many resources. Using that many you should be on a dedicated server. Second, i found this in just a few seconds.


The search function is a great feature, ya know.


#4

Thanks! I will try this. Do you have any ideas why the server crashes when a new player joins? It would say in the console ELS Data 1 and sometimes Available:true? or access denied to the command add principal. Also licenses disappear from peoples inventories.


#5

Too many resources? That’s maybe 1/4 of what I’m running and it doesn’t utilize more than 3GB RAM and 20% CPU when server is running. This is on a windows 10 VM on a 2012 Server R2 on an older computer in my office. The important part is actually the network bandwidth. When you get 20+ people connecting it’s the network connection you should be concerned with. If you run Linux, you use a fraction of the resources compared to windows, but I’m not familiar with linux.


#6

I run Linux and I use Essentialmode 5


#7

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