#wont let me in server anyone know what this mean

1 messages · Page 1 of 1 (latest)

cobalt galleon
#

also when trying to load in saying qb-core.deffering connection

cobalt galleon
wooden wigeon
cobalt galleon
#

Yeah mate I’ve tried everything can think off

wooden wigeon
#

Sql turned on in xampp?

cobalt galleon
#

Yeah pal that’s what confusing life out of me

wooden wigeon
#

In the live console, towards the end does it say - database connection established?

cobalt galleon
#

Just restarted my pc to reload everything up again so I’ll double check that too

wooden wigeon
cobalt galleon
#

clicked your name and didn’t mean click onto friend request mate

cobalt galleon
wooden wigeon
#

Did you check what I said

cobalt galleon
#

yh its connection established

#

script:connectqueue] QUEUE: [connectqueue] Disabling hardcap

#

what does this mean when i launch the server this is only wierd thing im finding

stone lava
#

i need help pls i cant open the stash of the shop . if u have some solution

cobalt galleon
subtle sand
#

the error indicates that your game server is unable to connect to your database.

Have you checked to ensure that your database credentials are formatted correctly inside your server.cfg file?

cobalt galleon
#

yeah which ones should i check im pretty sure dont all matey

#

@subtle sand been trying this since 1 aha i remeber you your the legend who helped me before

subtle sand
#

always happy to help 😄

#

so inside your server.cfg file you should see a line starting with set mysql_connection_string

#

you'll want to double check these settings an ensure that they match your database host, name, user and password.

cobalt galleon
#

so ive update my SQL ealier incase that was the problem will i have a new connection string to add on to it now ?

subtle sand
#

if you re-created your sql database then you may have changed the name or the user associated with the database

#

did you only update your mysql server or did you delete it and create another one?

cobalt galleon
#

update it

#

it didnt change anything for the codes are all the same

subtle sand
#

and after you updated it did you start the server back up?

#

make sure it's running 🙂

#

the sql server, I mean

cobalt galleon
#

no havent done anything

#

it was fine then went out came back and said the following what i sent other

subtle sand
#

how is your server hosted? on your pc or on a vps server?

cobalt galleon
#

on my pc bro

subtle sand
#

using xampp?

cobalt galleon
#

yeah

subtle sand
#

open your xampp control panel and ensure that MySQL is running - it should look something like this if it's running correctly:

cobalt galleon
#

thats how it is mate

subtle sand
#

you'll either see your databases or a red mysql error

cobalt galleon
#

like this ?

subtle sand
#

yep, so your sql server is running, that's good.

#

go into your server.cfg file and paste that set mysql_connection_string line here so I can double check the formatting for you.

cobalt galleon
#

set mysql_connection_string "mysql://root@localhost/QBCoreFramework_B92F41?charset=utf8mb4"

subtle sand
#

hmm yeah that is correct

cobalt galleon
#

im lost i dont have a clue

subtle sand
#

restart your fivem server and see if you get any errors in your server console while it's starting up

cobalt galleon
#

does this help?

subtle sand
#

kind of, but scroll up to see if there's any errors closer to the top

#

your sql database is running, and the connection string is correct. as long as you didn't modify the database structure you should be able to connect, unless i'm missing something.. even if you modified the structure of the db it would still connect

cobalt galleon
#

thats the top and there nothing in the middle either

subtle sand
#

hmm

cobalt galleon
#

then when i try to connect that what i sent before comes up but says this on logs like im in city which is strange

#

says i joined que and loaded in but didnt

subtle sand
#

yeah, that's because you're technically loading into the server but the framework is kicking you out for not being able to connect to the database

cobalt galleon
#

How do i get to db settings ill send them to you to see if any look out of place

subtle sand
#

you're connecting using localhost with a root user, no password, so as long as the connection string is correct you should be fine there.

in your xampp control panel, what does it say under Port on the MySQL line?

subtle sand
cobalt galleon
#

3306 same

#

search on your fivem BOYS TILL DEATH RP and try to connect for me my mates are out

#

appartlney on live console i timed out ?

subtle sand
#

same error, which is what i expected

cobalt galleon
#

yeah its hard work aha

subtle sand
#

and when you go to phpmyadmin you don't have to enter a password to log into the root account right?

cobalt galleon
#

nah did'nt have to do anything just brought me up to what i sent other

subtle sand
#

got me stumped on this one mang

#

just to be sure... open your xampp control panel again and click the Logs button on the MySQL row. you should only have one option in the list. this is the actual error log file for the mysql server itself. open that file and see if there's any errors in there.

#

you can also click the Browse option under Logs and drop the entire mysql_error.log file in here and I'll review it

cobalt galleon
#

Yeah think we found the issue

subtle sand
#

ooh let me know

cobalt galleon
#

the file is too long to send maybe two screenshots

subtle sand
#

can you drag and drop the whole file in here?

#

if you click Browse it will take you to the file itself

cobalt galleon
subtle sand
#

thanks one second let me take a look

cobalt galleon
#

thanks matey

subtle sand
#

i'm honestly stumped on this one, but i'm going to see if someone else can have a look - maybe i'm missing somethingj

cobalt galleon
#

alright matey thankyou i appricate it

#

shall i try deleting the error log

subtle sand
#

no that won't change anything

#

have you tried restarting your PC?

cobalt galleon
#

yeah ive fully restarted it couple times

#

shall i fully turn it off

subtle sand
#

no as long as you've tried restarting it

#

i'm honestly stumped here man! let's go back to what you were doing before this started

#

what exactly did you do before you stopped being able to connect?

cobalt galleon
#

i added a drug script and it crashed but i fully deleted

#

so maybe i added something somewhere and i need to delete it

#

do u know where i could of added something i was having to change true false things but think i change them all back

subtle sand
cobalt galleon
#

still not working mate

#

could you call me and have a look with me i can share screen

#

has this got anything to do with it

#

are all they files suppose to have something in

#

under connect queue

cobalt galleon
#

anyone able helpplease been trying all dayyyy

#

really wanna carry on devolmping my city but not letting me on and no clue why