Nu porneste sv cand dau sh start.sh

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

Nivel 2
Mesaje: 166
Membru din: 10 Noi 2018, 16:59
Regat: Jinno
Aprecieri: 302  
Mulţumiri: 126  
  Rezolvări prob.: 1
Discord: Copiază ID
Medalii

*Problemă:nu pornese sv cand dau sh start.sh
Tipologie server(PvM / PvP):
*Resursă folosită: *http://just4metin.ro/svf-pentru-resurse ... 67971.html*
*ServerFiles utilizat:Spyke clean 40k
*Syserr:gol
Poză:imgur.com/w3EAXm8
*Detalii suplimentare:cum rezolv asta
Avatar utilizator
salexandru9928
Nivel 2

Nivel 2
Mesaje: 166
Membru din: 10 Noi 2018, 16:59
Regat: Jinno
Aprecieri: 302  
Mulţumiri: 126  
  Rezolvări prob.: 1
Discord: Copiază ID
Medalii

Baza de date
Real Server
Log Offmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 seconds
Autentificarea
PUBLIC_IP: 25.86.121.100 interface em0
HOSTNAME: auth
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
Canal 1
PUBLIC_IP: 25.86.121.100 interface em0
HOSTNAME: canal1_1
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsPUBLIC_IP: 25.86.121.100 interface em0
HOSTNAME: canal1_2
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
Canal 99
PUBLIC_IP: 25.86.121.100 interface em0
HOSTNAME: canal99
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
cannot open direct sql connection to host: localhost user: root db: common
cannot start server while no common sql connected
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 seconds
root@:/usr/game # mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 seconds
root@:/usr/game # mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsSuccess ACCOUNT
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsSuccess COMMON
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
failed, retrying in 5 secondsSuccess HOTBACKUP
Avatar utilizator
șumahăr
Mister Just4Metin

Mister Just4Metin
Mesaje: 701
Membru din: 29 Iun 2018, 13:50
Aprecieri: 187  
Mulţumiri: 2319  
Discord: Copiază ID
Medalii

Nu e parola buna din conf cu cea din users din baza de date..
Pentru acest mesaj, șumahăr for the post:
salexandru9928
Avatar utilizator
[RaffaeL]
Software Developer

Software Developer
Mesaje: 3223
Membru din: 19 Mar 2016, 12:58
Server: ...
Aprecieri: 15  
Mulţumiri: 2502  
  Rezolvări prob.: 2
Discord: Copiază ID
 Contact:
Medalii

In primul rand acorda permisiuni rwx userului root pe mysql cu comenzile

Cod: Selectaţi tot

/usr/local/etc/rc.d/mysql-server stop

Cod: Selectaţi tot

chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql

Cod: Selectaţi tot

/usr/local/etc/rc.d/mysql-server start
Acest lucru te asigura de asemeni de faptul ca nu ai nici o tabela in modul "read-only".

Modifica apoi in CONFIG din fiecare channel/core, si conf.txt din db, userul si parola existente, cu cele stabilite de tine pentru mysql(de obicei userul este root).

Daca nu ai schimbat deja parola mysql, fa acest lucru folosind comenzile

Cod: Selectaţi tot

/usr/local/etc/rc.d/mysql-server stop

Cod: Selectaţi tot

mysqld_safe --skip-grant-tables &

Cod: Selectaţi tot

mysql -u root

Cod: Selectaţi tot

use mysql;

Cod: Selectaţi tot

update user set password=PASSWORD('parola ta') where User='root';

Cod: Selectaţi tot

flush privileges;
Userul poate sa nu fie neaparat root, ci unul creat de tine, daca nu folosesti userul default.
Imagine
Imagine
https://www.youtube.com/watch?v=GhYkCIETEto
Do everything, if you know what you're doing, else... Imagine
Ma gasesti si aici: Discord https://discord.gg/5J5GnyZVSR
Afișează semnătura
Închis

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

  • Informaţie
  • Cine este conectat

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