#PORT ALREADY IN USE ERROR??? WHO KNOWS HOW TO FIX

1 messages · Page 1 of 1 (latest)

plush stone
#

I RESTARTED MY SQL THRU XAMPP AND REPLACED MY DATA FOLDER WITH THE BACKUP BECAUSE MY SQL WOULDNT START, NOW IT STARTS BUT TX ADMIN GIVING ME THIS ERROR WHEN TRYING TO START

cyan onyxBOT
brisk plover
#

yeah bc you have 2 or more servers running atm

#

!shutdown

cyan onyxBOT
#

:point_right: How to completely shutdown txAdmin:

windows For Windows:

Close the FXServer terminal or go to Task Manager > Details and kill all fxserver.exe processes.
If that doesn't work, restart the host.
linux For Linux:
If your server is running via screen, search on how to kill a screen session (screen -ls and then screen -X -S <number> quit).
Alternatively you can also just restart the host, and unless fxserver has auto-start, that will make sure the process is terminated.
zap ZAP-Hosting:
Login to the ZAP panel, select your server, then at the top click on the red pause/stop button at the top right of the screen.
pterodactyl Pterodactyl (most providers):
On your host panel press the Stop button and then press Kill.

plush stone
#

now im getting black screen flying into city

brisk plover
#

flying into the city>

plush stone
brisk plover
#

do you mean joing your server

plush stone
#

this after loading screen, just a loading icon in the corner and no load

#

yes joining server sorry

brisk plover
#

errors at all?

#

either in f8 or tx

plush stone
brisk plover
#

do you have an esx databse?

plush stone
#

yes

brisk plover
#

whats the name of it

plush stone
#

this name?

brisk plover
#

no.

#

of your database

#

was it you that mentioned you used xampp?

plush stone
#

yes

brisk plover
#

ok so open your phpmyadmin or if you use hedi open that

#

and show me what pops up

plush stone
#

my sql was not loading, so i followed a video to replace my data folder in xampp with my backup sql folder, after i did this im getting this error

brisk plover
#

ok so if your database wont work this is a perfect time to change from xampp

#

!db

cyan onyxBOT
#

:point_right: If you are having ECONNREFUSED 127.0.0.1:3306 when connecting to the database, this probably means you do not have a database installed or running.
windows Windows Home Hosted or VPS:
:one: Download and install MariaDB: https://docs.yorick.gg/FiveM/Server/Windows/Database#download-mariadb
:two: To make sure you can edit/view your database, download and install HeidiSQL: https://docs.yorick.gg/FiveM/Server/Windows/Database#download-heidisql
:three: On txAdmin, click on the Cancel button and try again.
linux Linux VPS or Self Hosted:
It depends on your distro (like CentOS, Ubuntu, etc), you will need to google how to install MariaDB in it.
pterodactyl Pterodactyl setups (most hosting providers):
Open a support ticket at your hosting provider to ask their help in setting up the database.
If your pterodactyl is self hosted (you own the instance), this video MAY be the solution.

brisk plover
#

follow this

plush stone
#

run the phpmyadmin?

brisk plover
#

dont use xampp

#

change to mariadb

plush stone
#

will i have to remake my database and all the stuff i ran thru my sql?

brisk plover
#

yes, which wont matter atm as it seems it doesnt find your database anywya

plush stone
#

i have over 250 scripts it will take so long to re install all of the files

brisk plover
# plush stone

well looking at this you dont even have a database for your server

#

so either way your stuck at having to do it

plush stone
#

how can you tell?

brisk plover
#

bc normally databses have a name just for example in your case your database was esxlegacy_028db4

plush stone
#

this has to be an error from what i did with xampp theres no way to reverse?

brisk plover
#

which you dont have any of those. tbh the EASIEST way would to restart your server and move your scripts over, otherwise you can figure out how to restore it

plush stone
#

theres no way to restore or you dont know how

brisk plover
#

You can always Google and see. Typically no there isnt

#

Unless u had a backup

plush stone
#

i used the backup folder in xampp tho

brisk plover
#

DONT USE XAMPP

#

But. If u had a backup u can restore

plush stone
#

i used the backup im saying for my original data folder

#

now its doing this

brisk plover
#

Ok..so do u have said backup

plush stone
#

so there has to be a way

brisk plover
#

?

plush stone
#

this is the backup i used for my original data folder, this is in the xampp file location inside the "mysql" folder

#

this is what youtube told me to do to fix the "mysql" not starting error in xampp

brisk plover
#

Ill tell you what, if your ginna keep using xampp be my guest but I cant help then

plush stone
#

once i did this, the sql was starting again, but the tx did the error you made me fix originally. before all of this, my VPS screen went black so i did CTRL+ALT+END to sign out and reboot my vps. once i did this , is when the sql wasnt starting in xampp

#

so basically long story short you cant help me with this?

brisk plover
#

Its not that i cant its more so I wont since you are using software that isnt meant for this stuff

plush stone
#

i didnt know this originally, so once i already installed 250+ scripts im just learning now not to use xampp. that is what i was taught to use, so its evident id rather just continue with what i was using because I didnt know of mariaDB.

indigo venture
#

have you considered switching

plush stone
#

therefore when i make v2 of my city i will switch but for now ive been working installing and develeping my own server for months on end. i now know this causes issue but this is my first issue

#

live and you learn is a term lol but if yall can help me figure it out would be greatly appreciated, if not just lmk

brisk plover
plush stone
#

the backup folder is the one i screenshotted

#

is this not the correct backup?

brisk plover
#

No.

plush stone
#

what am i missing what should i be looking for