Am probleme cu mysql

[R4zvyy]

Ajutatima Va rog 

message.txt

Edited December 5, 2020 by R4zvyy

[danuts]

[ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 's145_bgg'@'jocuri.five-host.com' (using password: YES)

îți spune clar care este problema, ai greșit datele de conectare pentru baza de date.

[R4zvyy]

Chiar acum, matei_ a spus:

[ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 's145_bgg'@'jocuri.five-host.com' (using password: YES)

îți spune clar care este problema, ai greșit datele de conectare pentru baza de date.

ii conectat corect ,

 

[10:40:04]  Loading plugin: mysql.so
[10:40:04]   Failed (plugins/mysql.so: invalid ELF header)

[R4zvyy]

[10:40:04]  Loading plugin: mysql.so
[10:40:04]   Failed (plugins/mysql.so: invalid ELF header)

[Fanta Adv]

incearca sa schimbi pluginu mysql

[Fanta Adv]

http://www.mediafire.com/file/6a8pc16j9rbpyd8/mysql.dll/file
http://www.mediafire.com/file/1b4ejqf7vl9gfbm/mysql.pdb/file
http://www.mediafire.com/file/kmg7wxcbmdmlhxt/mysql.so/file

[R4zvyy]

Chiar acum, Fanta Adv a spus:

http://www.mediafire.com/file/6a8pc16j9rbpyd8/mysql.dll/file
http://www.mediafire.com/file/1b4ejqf7vl9gfbm/mysql.pdb/file
http://www.mediafire.com/file/kmg7wxcbmdmlhxt/mysql.so/file

trebuie neaparat si dll?

 

[Fanta Adv]

daca il ai pe host foloseste doar .so, .dll l-am trimis in caz de nu merge nici el

[R4zvyy]

Chiar acum, Fanta Adv a spus:

daca il ai pe host foloseste doar .so, .dll l-am trimis in caz de nu merge nici el

nu merge

[Fanta Adv]

ce scrie in server_log?

[R4zvyy]

Chiar acum, Fanta Adv a spus:

ce scrie in server_log?

[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: TotalUsers
[11:03:35] gQuery: SELECT * FROM users
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadSVehicle
[11:03:35] gQuery: SELECT * FROM `svehicles` ORDER BY `svehicles`.`vID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: InsertSafeZone
[11:03:35] gQuery: SELECT * FROM `safezones` ORDER BY `safezones`.`ID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadProperty
[11:03:35] gQuery: SELECT * FROM `houses` ORDER BY `houses`.`ID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadBizz
[11:03:35] gQuery: SELECT * FROM `bizz` ORDER BY `bizz`.`ID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: InsertGarages
[11:03:35] gQuery: SELECT * FROM `garages` ORDER BY `garages`.`ID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: InsertClans
[11:03:35] gQuery: SELECT * FROM `clans` ORDER BY `clans`.`ID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: loadClanVehicles
[11:03:35] gQuery: SELECT * FROM `clanvehicles`
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: SQL_loadTurfs
[11:03:35] gQuery: SELECT * FROM `turfs`
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadFaction
[11:03:35] gQuery: SELECT * FROM `factions` ORDER BY `factions`.`ID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadFactions
[11:03:35] gQuery: SELECT * FROM `factions` ORDER BY `factions`.`ID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadJobs
[11:03:35] gQuery: SELECT * FROM `jobs` ORDER BY `jobs`.`ID` ASC
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadStuffs
[11:03:35] gQuery: SELECT * FROM `stuff`
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadDSVeh
[11:03:35] gQuery: SELECT * FROM `dsveh`
[11:03:35] ====================================================================
[11:03:35] ====================================================================
[11:03:35] Error ID: 2006, Eroare: MySQL server has gone away
[11:03:35] Callback: LoadSafes
[11:03:35] gQuery: SELECT * FROM `seif`
[11:03:35] ====================================================================
[11:03:46] password = ""  (string)
[11:04:07] [connection] 79.113.5.29:50136 requests connection cookie.
[11:04:08] [connection] incoming connection: 79.113.5.29:50136 id: 0
[11:04:09] [join] R4zvyy has joined the server (0:79.113.5.29)
[11:04:09] ====================================================================
[11:04:09] Error ID: 2006, Eroare: MySQL server has gone away
[11:04:09] Callback: checkPlayerBan
[11:04:09] gQuery: SELECT * FROM `bans` WHERE `PlayerName`='R4zvyy'
[11:04:09] ====================================================================
[11:04:09] ====================================================================
[11:04:09] Error ID: 2006, Eroare: MySQL server has gone away
[11:04:09] Callback: 
[11:04:09] gQuery: UPDATE `stuff` SET `MaxPlayers`='1', `MaxPlayersDate`='05/12/2020 - 11:04:09'
[11:04:09] ====================================================================
[11:04:36] [part] R4zvyy has left the server (0:1)
[11:04:36] ====================================================================
[11:04:36] Error ID: 2006, Eroare: MySQL server has gone away
[11:04:36] Callback: 
[11:04:36] gQuery: UPDATE `users` SET `BattlePassPremium`='0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0' WHERE `ID`='0' LIMIT 1
[11:04:36] ====================================================================
[11:04:36] ====================================================================
[11:04:36] Error ID: 2006, Eroare: MySQL server has gone away
[11:04:36] Callback: 
[11:04:36] gQuery: UPDATE `users` SET `BattlePassNormal`='0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0' WHERE `ID`='0' LIMIT 1
[11:04:36] ====================================================================
[11:04:36] ====================================================================
[11:04:36] Error ID: 2006, Eroare: MySQL server has gone away
[11:04:36] Callback: 
[11:04:36] gQuery: UPDATE `users` SET `Status`='0' WHERE `id`='0'
[11:04:36] ====================================================================
[11:04:36] ====================================================================
[11:04:36] Error ID: 2006, Eroare: MySQL server has gone away
[11:04:36] Callback: 
[11:04:36] gQuery: UPDATE users SET `lastOn`='05.12.2020 11:04' WHERE `ID`='0'
[11:04:36] ====================================================================
 

[Fanta Adv]

n-am idee, nu mi s-a mai intamplat...

[qSorin_]

Daca pluginu iti merge. si inca ai problema asta:
 

[ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 's145_bgg'@'jocuri.five-host.com' (using password: YES)

Din cate stiu trebuie sa ceri acces la ip-ul extern al server-ului.

Daca ai de ex host de la `gazduire jocuri` trebuie sa ceri acces la ip-ul extern de la firma five-host.com catre ip-ul server-ului
Si daca ai baza de date de la aceasi firma cu care ai si serverul. Inseamna ca e de la pluginuri.