Problema mysql

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
FALLEN1
Nivel 4

Nivel 4
Mesaje: 585
Membru din: 14 Noi 2015, 20:12
Server: Dark-Fusion2
Regat: Chunjo
Aprecieri: 366  
Mulţumiri: 758  
  Rezolvări prob.: 2
Discord: Copiază ID
Medalii

*Problemă/Întrebare: Eroare mysql
Tipologie server(PvM / PvP):pvp
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat: serenity
*Syserr:
HOSTNAME: channel1
PUBLIC_IP: 188.222.58.100 interface em0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: arkadia2 db: common
cannot start server while no common sql connected
Poză:
*Detalii suplimentare:Nu reusesc sa ii dau de cap, am sters mysql, l-am reinstalat nu inteleg de ce nu se poate conecta la common,
Avatar utilizator
SkyLine
Membru Club

Membru Club
Mesaje: 2655
Membru din: 12 Dec 2013, 23:37
Server: Miraj2-Online
Regat: Jinno
Aprecieri: 520  
Mulţumiri: 987  
Discord: Copiază ID
 Contact:
Medalii

ai resetat parola?
Avatar utilizator
FALLEN1
Nivel 4

Nivel 4
Mesaje: 585
Membru din: 14 Noi 2015, 20:12
Server: Dark-Fusion2
Regat: Chunjo
Aprecieri: 366  
Mulţumiri: 758  
  Rezolvări prob.: 2
Discord: Copiază ID
Medalii

Da, am resetat parola, am încercat sa golesc tabele alea dar imi da eroare rdsclient cu un ip ciudat,

[ Postat de pe Android ] Imagine

Ideea e ca nu pot porni nici sv din cauza la prostia asta
Avatar utilizator
AleAme
Utilizator interzis !

Utilizator interzis !
Mesaje: 10
Membru din: 23 Dec 2019, 14:44
Server: Creez
Regat: Jinno
Aprecieri: 7  
Mulţumiri: 1  
Discord: Copiază ID
Medalii

Martinel scrie: ↑11 Mar 2020, 21:42 *Problemă/Întrebare: Eroare mysql
Tipologie server(PvM / PvP):pvp
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat: serenity
*Syserr:
HOSTNAME: channel1
PUBLIC_IP: 188.222.58.100 interface em0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: arkadia2 db: common
cannot start server while no common sql connected
Poză:
*Detalii suplimentare:Nu reusesc sa ii dau de cap, am sters mysql, l-am reinstalat nu inteleg de ce nu se poate conecta la common,

Oferă permisiunile 777 mysql[88] & mysql[88] manual. reboot și o să meargă
Avatar utilizator
FALLEN1
Nivel 4

Nivel 4
Mesaje: 585
Membru din: 14 Noi 2015, 20:12
Server: Dark-Fusion2
Regat: Chunjo
Aprecieri: 366  
Mulţumiri: 758  
  Rezolvări prob.: 2
Discord: Copiază ID
Medalii

AleAme scrie: ↑11 Mar 2020, 22:00
Martinel scrie: ↑11 Mar 2020, 21:42 *Problemă/Întrebare: Eroare mysql
Tipologie server(PvM / PvP):pvp
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat: serenity
*Syserr:
HOSTNAME: channel1
PUBLIC_IP: 188.222.58.100 interface em0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: arkadia2 db: common
cannot start server while no common sql connected
Poză:
*Detalii suplimentare:Nu reusesc sa ii dau de cap, am sters mysql, l-am reinstalat nu inteleg de ce nu se poate conecta la common,

Oferă permisiunile 777 mysql[88] & mysql[88] manual. reboot și o să meargă
Sa le ofer la toată baza de date?

[ Postat de pe Android ] Imagine
Avatar utilizator
AleAme
Utilizator interzis !

Utilizator interzis !
Mesaje: 10
Membru din: 23 Dec 2019, 14:44
Server: Creez
Regat: Jinno
Aprecieri: 7  
Mulţumiri: 1  
Discord: Copiază ID
Medalii

Martinel scrie: ↑11 Mar 2020, 22:04
AleAme scrie: ↑11 Mar 2020, 22:00
Martinel scrie: ↑11 Mar 2020, 21:42 *Problemă/Întrebare: Eroare mysql
Tipologie server(PvM / PvP):pvp
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat: serenity
*Syserr:
HOSTNAME: channel1
PUBLIC_IP: 188.222.58.100 interface em0
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
cannot open direct sql connection to host: localhost user: arkadia2 db: common
cannot start server while no common sql connected
Poză:
*Detalii suplimentare:Nu reusesc sa ii dau de cap, am sters mysql, l-am reinstalat nu inteleg de ce nu se poate conecta la common,

Oferă permisiunile 777 mysql[88] & mysql[88] manual. reboot și o să meargă
Sa le ofer la toată baza de date?

[ Postat de pe Android ] Imagine
intri in fiecare folder din var/db/mysql selectezi tot și oferi
Avatar utilizator
FALLEN1
Nivel 4

Nivel 4
Mesaje: 585
Membru din: 14 Noi 2015, 20:12
Server: Dark-Fusion2
Regat: Chunjo
Aprecieri: 366  
Mulţumiri: 758  
  Rezolvări prob.: 2
Discord: Copiază ID
Medalii

AleAme scrie: ↑11 Mar 2020, 22:06
Martinel scrie: ↑11 Mar 2020, 22:04
AleAme scrie: ↑11 Mar 2020, 22:00


Oferă permisiunile 777 mysql[88] & mysql[88] manual. reboot și o să meargă
Sa le ofer la toată baza de date?

[ Postat de pe Android ] Imagine
intri in fiecare folder din var/db/mysql selectezi tot și oferi
Nup, am permisiuni si am aceeasi problema.
Avatar utilizator
FALLEN1
Nivel 4

Nivel 4
Mesaje: 585
Membru din: 14 Noi 2015, 20:12
Server: Dark-Fusion2
Regat: Chunjo
Aprecieri: 366  
Mulţumiri: 758  
  Rezolvări prob.: 2
Discord: Copiază ID
Medalii

Am gasit eroarea asta prin sysser ul de la db

SYSERR: Mar 12 09:02:56 :: pid_init:
Start of pid: 1174

SYSERR: Mar 12 09:02:57 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:02:57 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:02:57 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:03:03 :: pid_init:
Start of pid: 1189

SYSERR: Mar 12 09:03:03 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:03:03 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:03:03 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:03:08 :: pid_init:
Start of pid: 1198

SYSERR: Mar 12 09:03:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Lost connection to MySQL server during query
query: SELECT MAX(id) FROM item WHERE id >= 50000001 and id <= 60000000
SYSERR: Mar 12 09:03:13 :: InitializeTables: InitializeItemTable FAILED
SYSERR: Mar 12 09:03:13 :: Initialize: Table Initialize FAILED
SYSERR: Mar 12 09:03:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 50000001 AND id <= 60000000
SYSERR: Mar 12 09:03:13 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:03:13 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:03:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT MAX(id) FROM item WHERE id >= 30000001 and id <= 40000000
SYSERR: Mar 12 09:03:13 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 30000001 AND id <= 40000000
SYSERR: Mar 12 09:03:13 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Mar 12 09:03:18 :: pid_init:
Start of pid: 1213

SYSERR: Mar 12 09:04:59 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:04:59 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:04:59 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:04 :: pid_init:
Start of pid: 1463

SYSERR: Mar 12 09:05:04 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:04 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:05:09 :: pid_init:
Start of pid: 1471

SYSERR: Mar 12 09:05:10 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:05:10 :: Process: FDWATCH: peer null in event: ident 6
SYSERR: Mar 12 09:05:10 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:11 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:11 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:05:18 :: pid_init:
Start of pid: 1477

SYSERR: Mar 12 09:05:18 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:18 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:05:25 :: pid_init:
Start of pid: 1483

SYSERR: Mar 12 09:05:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT MAX(id) FROM item WHERE id >= 110000001 and id <= 120000000
SYSERR: Mar 12 09:05:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 110000001 AND id <= 120000000
SYSERR: Mar 12 09:05:25 :: Process: FDWATCH: peer null in event: ident 6
SYSERR: Mar 12 09:05:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item WHERE id >= 90000001 and id <= 100000000
SYSERR: Mar 12 09:05:25 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item WHERE id >= 90000001 AND id <= 100000000
SYSERR: Mar 12 09:05:25 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:05:30 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:30 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:05:30 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:05:30 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:30 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:35 :: pid_init:
Start of pid: 1504

SYSERR: Mar 12 09:05:35 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:35 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:05:41 :: pid_init:
Start of pid: 1509

SYSERR: Mar 12 09:05:41 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:05:41 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:05:41 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:41 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:05:41 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:05:46 :: pid_init:
Start of pid: 1517

SYSERR: Mar 12 09:05:47 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:05:47 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:05:55 :: pid_init:
Start of pid: 1523

SYSERR: Mar 12 09:05:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item WHERE id >= 130000001 and id <= 140000000
SYSERR: Mar 12 09:05:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item WHERE id >= 130000001 AND id <= 140000000
SYSERR: Mar 12 09:05:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT MAX(id) FROM item WHERE id >= 170000001 and id <= 180000000
SYSERR: Mar 12 09:05:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
query: SELECT COUNT(*) FROM item WHERE id >= 170000001 AND id <= 180000000
SYSERR: Mar 12 09:05:55 :: Process: FDWATCH: peer null in event: ident 6
SYSERR: Mar 12 09:05:55 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:06:00 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:00 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:06:00 :: DirectQuery: MySQL connection was reconnected. querying locale set
SYSERR: Mar 12 09:06:00 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:00 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:05 :: pid_init:
Start of pid: 1541

SYSERR: Mar 12 09:06:05 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:05 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:06:12 :: pid_init:
Start of pid: 1549

SYSERR: Mar 12 09:06:13 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:13 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:06:23 :: pid_init:
Start of pid: 1553

SYSERR: Mar 12 09:06:29 :: pid_init:
Start of pid: 1568

SYSERR: Mar 12 09:06:29 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:29 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:29 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:06:32 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:35 :: pid_init:
Start of pid: 1575

SYSERR: Mar 12 09:06:35 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Mar 12 09:06:36 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='188.212.100.58')
SYSERR: Mar 12 09:06:36 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:36 :: pid_deinit:
End of pid

SYSERR: Mar 12 09:06:41 :: pid_init:
Start of pid: 1579

SYSERR: Mar 12 09:06:43 :: socket_bind: bind: Address already in use
SYSERR: Mar 12 09:06:43 :: pid_deinit:
End of pid
Avatar utilizator
Kidro
Membru Club

Membru Club
Mesaje: 2487
Membru din: 29 Aug 2019, 16:49
Aprecieri: 331  
Mulţumiri: 5190  
Discord: Copiază ID
Medalii

Topic inactiv, arhivat

[ Postat de pe Android ] Imagine
Închis
Răspunsuri
3
Vizualizări
269
Răspunsuri
1
Vizualizări
340

Înapoi la “Arhivă Probleme şi Întrebări”

  • Informaţie
  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Semrush [Bot] și 20 vizitatori