Problema AUTH

Maria1 · 25 Apr 2018, 11:03

*Problemă: imi pica serverul ..

imi da multe "connection refuse "
Tipologie server: PVM
*Resursă folosită:
*ServerFiles utilizat: htt p://just4me tin.ro/serverfiles/serverfiles-clean-src-t67971.html (am pus space in link ca nu ma lasa sa-l pun intreg)
*Syserr:
Sysser AUTH/CH

Poză: muuulte de astea
*Detalii suplimentare:
Buna, m-am gandit sa incerc sa fac si eu un server, am urmarit multe tutoriale pe net. Am dat de eroarea asta..a mers serverul la inceput..pana cand.. am nevoie de putin ajutor daca se poate..

Vincent Griffith · 25 Apr 2018, 11:09

Repara tabelele iar daca nu merge nici asa lasa-mi start.sh aici prin

Cod: Selectaţi tot

 sa ti-l verific.

Maria1 · 25 Apr 2018, 11:20

Sebastian♕ scrie:Repara tabelele iar daca nu merge nici asa lasa-mi start.sh aici prin [cod.e] sa ti-l verific.

Am reparat tabelele ..imi spune ca toate-s OK ..

Cod: Selectaţi tot

#!/bin/sh
echo -e "\033[31m Baza de date\033[0m"
cd /usr/game/server/db/
./db &
sleep 2
clear
echo -e "\033[31m Autentificarea\033[0m"
cd /usr/game/server/auth/ 
./auth &
sleep 2
clear
echo -e "\033[31m Canal 1\033[0m"
cd /usr/game/server/canal1/canal1_1/
./canal1_1 &
sleep 2
cd /usr/game/server/canal1/canal1_2/
./canal1_2 &
sleep 2
clear
echo -e "\033[31m Canal 99\033[0m"	
cd /usr/game/server/canal99/
./canal99 &
sleep 2
clear

25 Apr 2018, 11:23

#!/bin/sh
echo -e "\033[31m Baza de date\033[0m"
cd /usr/game/server/db/
./db &
sleep 10
clear
echo -e "\033[31m Autentificarea\033[0m"
cd /usr/game/server/auth/ 
./auth &
sleep 10
clear
echo -e "\033[31m Canal 1\033[0m"
cd /usr/game/server/canal1/canal1_1/
./canal1_1 &
sleep 10
cd /usr/game/server/canal1/canal1_2/
./canal1_2 &
sleep 10
clear
echo -e "\033[31m Canal 99\033[0m"   
cd /usr/game/server/canal99/
./canal99 &
sleep 10
clear

Bughy · 25 Apr 2018, 11:24

fa asa, ruleaza in putty urmatoarele comenzi pe rand:

Cod: Selectaţi tot

cd /usr/home/game

Cod: Selectaţi tot

sh close.sh

Cod: Selectaţi tot

chown -R mysql /var/db/mysql/;
chgrp -R mysql /var/db/mysql/;
chmod -R 777 /var/db/mysql;

in navicat dai repair la:

Cod: Selectaţi tot

account
common
player

dupa ce ai facut asta dai reboot.

Daca a mers lasa reply

Maria1 · 25 Apr 2018, 11:58

Bughy scrie:fa asa, ruleaza in putty urmatoarele comenzi pe rand:
Cod: Selectaţi tot
cd /usr/home/game
Cod: Selectaţi tot
sh close.sh
Cod: Selectaţi tot
chown -R mysql /var/db/mysql/;
chgrp -R mysql /var/db/mysql/;
chmod -R 777 /var/db/mysql;
in navicat dai repair la:
Cod: Selectaţi tot
account
common
player
dupa ce ai facut asta dai reboot.

Daca a mers lasa reply

Deocamdata nu imi da connection refuse, astept sa vad in continuare, ca de obicei imi da dupa vreo 2-3 min

Bughy · 25 Apr 2018, 12:01

Maria1 scrie:
Bughy scrie:fa asa, ruleaza in putty urmatoarele comenzi pe rand:
Cod: Selectaţi tot
cd /usr/home/game
Cod: Selectaţi tot
sh close.sh
Cod: Selectaţi tot
chown -R mysql /var/db/mysql/;
chgrp -R mysql /var/db/mysql/;
chmod -R 777 /var/db/mysql;
in navicat dai repair la:
Cod: Selectaţi tot
account
common
player
dupa ce ai facut asta dai reboot.

Daca a mers lasa reply
Deocamdata nu imi da connection refuse, astept sa vad in continuare, ca de obicei imi da dupa vreo 2-3 min

Revino cu un edit peste 10-15 minute sa stim daca a mers.

Maria1 · 25 Apr 2018, 12:34

Bughy scrie:
Maria1 scrie:
Bughy scrie:fa asa, ruleaza in putty urmatoarele comenzi pe rand:
Cod: Selectaţi tot
cd /usr/home/game
Cod: Selectaţi tot
sh close.sh
Cod: Selectaţi tot
chown -R mysql /var/db/mysql/;
chgrp -R mysql /var/db/mysql/;
chmod -R 777 /var/db/mysql;
in navicat dai repair la:
Cod: Selectaţi tot
account
common
player
dupa ce ai facut asta dai reboot.

Daca a mers lasa reply
Deocamdata nu imi da connection refuse, astept sa vad in continuare, ca de obicei imi da dupa vreo 2-3 min
Revino cu un edit peste 10-15 minute sa stim daca a mers.

Tot imi da connection refuse dupa un timp in consola..
In SYSSER CH1 mai apare si asta

SYSERR: Apr 25 13:04:40 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2825, 959322, 269628, 5, 'GM_LOGIN', '', '25.75.200.17') errno: 1146)
SYSERR: Apr 25 13:04:40 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2825, 959322, 269628, 0, 'LOGIN', '25.75.200.17 763697484 1 41 1', '25.75.200.17') errno: 1146)
SYSERR: Apr 25 13:04:40 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 2406, 2825, inet_aton('25.75.200.17'), '') errno: 1146)
SYSERR: Apr 25 13:05:26 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2825, 959322, 269628, 0, 'LOGOUT', '25.75.200.17 763697484 1 41 1', '25.75.200.17') errno: 1146)
SYSERR: Apr 25 13:07:03 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2825, 959322, 269628, 5, 'GM_LOGIN', '', '25.75.200.17') errno: 1146)
SYSERR: Apr 25 13:07:03 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2825, 959322, 269628, 0, 'LOGIN', '25.75.200.17 763697484 1 41 1', '25.75.200.17') errno: 1146)
SYSERR: Apr 25 13:07:03 :: ChildLoop: AsyncSQL: query failed: Table 'log.loginlog2' doesn't exist (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 2406, 2825, inet_aton('25.75.200.17'), '') errno: 1146)
SYSERR: Apr 25 13:08:05 :: ChildLoop: AsyncSQL: query failed: Table 'log.command_log' doesn't exist (query: INSERT DELAYED INTO command_log (userid, server, ip, port, username, command, date ) VALUES(2825, 999, '25.75.200.17', 1, '[SA]Spyke', 'i 500', NOW()) errno: 1146)
SYSERR: Apr 25 13:08:13 :: ChildLoop: AsyncSQL: query failed: Table 'log.log' doesn't exist (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 2825, 959599, 270423, 0, 'LOGOUT', '25.75.200.17 763697484 1 41 1', '25.75.200.17') errno: 1146)

Fisieru log din navicat si server(din mysql) este gol..

Bughy · 25 Apr 2018, 12:37

da-i repair la tabelul log

Maria1 · 25 Apr 2018, 12:41

Bughy scrie:da-i repair la tabelul log

Cum sa dau repair daca in baza de date numita "LOG" nu este nimic, nimic ?

Problema AUTH

Problema Auth

Problema db si auth

Problema auth

problema auth

Cine este conectat