brouznouf / fivem-mysql-async

MySql Async Library for FiveM
MIT License
111 stars 106 forks source link

[ghmattimysql] [error] connect ETIMEDOUT #188

Open ArchAngelAzrael opened 2 years ago

ArchAngelAzrael commented 2 years ago

i put the [databasename] to protect said server from hacking, but it is actually connected to a database that is setup correctly :)

Describe the bug Getting odd ghmattimysql error "connect ETIMEDOUT" although xampp and my-SQL database has been established, using FiveM Qbus integration.

To Reproduce Please provide a brief script that causes the error.

To reproduce simply restarting server, tried multiple fixes like the following:

set mysql_connection_string "mysql://root@localhost/[databasename]?connectTimeout=30000&acquireTimeout=30000&waitForConnections=true&keepAlive=30&charset=utf8mb4"

set mysql_connection_string "mysql://@localhost/[databasename]?connectTimeout=30000&acquireTimeout=30000&waitForConnections=true&keepAlive=30&charset=utf8mb4"

set mysql_connection_string "server=localhost;database=[databasename];userid=root"

set mysql_connection_string "mysql://root@localhost/[databasename]?charset=utf8mb4"

unsure why it will not connect to mysql database. ghmattimysql for FiveM and QBus integrations.

Expected behavior A clear and concise description of what you expected to happen.

to establish database connection without any issue.

Screenshots / Logs If applicable, add screenshots and Logs to help explain your problem.

image

Software:

Thanks for all the help that you can provide

Nevadastate commented 2 years ago

@ArchAngelAzrael were you able to fix this because I'm having this issue as well

lawson403 commented 1 year ago

@Nevadastate i have this issue and cant seem to figuer out how to fix it iv looked over everything i can possiably think of image

Blade1474 commented 1 year ago

how i fix the problom was to Set start to STREAM type resources ( cars, skins, mappings ) before start ghmattimysql hope this works for you

C4-KTTK commented 1 year ago

how i fix the problom was to Set start to STREAM type resources ( cars, skins, mappings ) before start ghmattimysql hope this works for you

THAAAAAAAANKS!