Problema Putty: Connection Refused

StrikeZone · 08 Noi 2015, 00:19

Salut ! Am o problema la mysql .
Intru in putty , ma loghez.

root@metin2:~ # cd /usr/home/game
/usr/home/game: No such file or directory.
root@metin2:~ # cd /usr/game
root@metin2:/usr/game # sh start.sh

- Cate channele vrei sa pornesti ? -

1 - (1) 1 CHANNEL - Porneste doar ch1.

2 - (2) 2 CHANNEL - Porneste doar ch2.

1

Imi da eroarea :

Cod: Selectaţi tot

SERVER: Ai deschis cu succes (CH1)

 Visit www.desertdust2.eu !
root@metin2:/usr/game # connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused

Si o tine tot asa.
De asemenea , nu ma pot conecta la Navicat , dar nici pe site !

Eroare Navicat: 1045 - Acces denied for user 'root'@'86.123.39.207' (using password: YES)

Eroare site:
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at [email protected] to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

Va rog un pic de ajutor ????

AndreiYildirim · 08 Noi 2015, 00:22

Cod: Selectaţi tot

mysql -u root -p
ENTER
CREATE USER utlizator@% IDENTIFIED BY 'parola';
GRANT ALL PRIVILEGES ON *.* TO utilizator@% IDENTIFIED BY 'parola';
flush privileges;
exit

Asa vei putea sa creezi un user nou pentru baza de date, si il folosesti pe cel nou.

StrikeZone · 08 Noi 2015, 00:23

Sa inteleg ca le scriu in Putty ?
Edit: inlocuiesc doar "utilizator" si "parola" cu ce imi trebuie.
Atat , restul copy+paste , nu?

StrikeZone · 08 Noi 2015, 00:27

Scuze pentru double - post.

Cand scriu

Cod: Selectaţi tot

mysql -u root -p

in putty , imi apare eroarea:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y ES)

Edit , ce am in sysser la ch1 :

Cod: Selectaţi tot

SYSERR: Nov  7 23:41:39 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Nov  7 23:41:42 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Nov  7 23:41:45 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Nov  7 23:41:48 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Nov  7 23:41:51 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Nov  7 23:41:54 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Nov  7 23:41:59 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Nov  7 23:41:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Nov  7 23:42:00 :: pid_deinit:

*Tin sa spun ca am verificat si directoarele , sunt ok. Am folosit si optiunea Maintain Tables din Navicat , cu repair extended. Degeaba.
Am rezolvat MySQL , insa ce fac cu jocul?
(Cand intru in client spune ca CH1 este functional)
Acum imi merge si Navicat.
Site-ul merge si el !
Ce pot face?

Imi ramane la "Vei fi conectat la server"....

Referitor la ce ai spus tu ..

AndreiYildirim scrie:
Cod: Selectaţi tot
mysql -u root -p
ENTER
CREATE USER utlizator@% IDENTIFIED BY 'parola';
GRANT ALL PRIVILEGES ON *.* TO utilizator@% IDENTIFIED BY 'parola';
flush privileges;
exit
Asa vei putea sa creezi un user nou pentru baza de date, si il folosesti pe cel nou.

Uite ce eroare imi da cand introduc ce zici tu :

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

AndreiYildirim · 08 Noi 2015, 02:59

Bun, in primul rand ar trebui sa cauti pe google inainte de a posta aici, au mai fost 1000 de oameni cu aceeasi problema inaintea ta...

In al doilea rand, daca nu te poti accesa consola de la mysql prin putty inseamna ca serverul de mysql nu este pornit, deci va trebui sa faci asta:

Intrii in Putty si dai paste la comanda asta:

Cod: Selectaţi tot

echo 'mysql_enable="YES"' >> /etc/rc.conf

Prin comanda asta se va adauga instructiunea de pornire automata a serverului de mysql in freebsd.

Apoi dai un restart la server prin comanda asta:

Cod: Selectaţi tot

reboot

Incearca inca odata ce am scris in prima postare si spune-mi daca functioneaza.

StrikeZone · 08 Noi 2015, 10:04

Nu merge frate

In channel1 CONFIGS am scris astea:
PLAYER_SQL: localhost mt2 PAROLA_SERVER player
COMMON_SQL: localhost mt2 PAROLA_SERVER common

In loc de parola_server , sa inteleg ca pun parola de la navicat , mai schimb si altceva?

StrikeZone · 08 Noi 2015, 21:56

Up ...

09 Noi 2015, 16:48

Te rog sa nu blochezi porturile P2P in firewall, lasa-le sa fie vizibile doar pentru dedicat.
In cazul de fata avem o problema cu tabelele mysql .
te rog frumos sa dai un repair extended la fiecare tabel si optimize tables.
Daca nu merge asa , te rog frumos din nou sa verifici portul MYSQL cu cel din pf.conf sa nu fie blocat . ( ATENTIE , NU ESTE 3306 , acesta este pentru conexiunile externe ! )

Problema Putty: Connection Refused

Connection refused->putty

Connection refused putty

Connection refused putty

Problema connect: Connection refused connect: Connection refused connect: Connection refused

Cine este conectat