Problema connectare server pus pe host

VirTual · 22 Feb 2020, 23:47

*Problemă/Întrebare:Cand pun un cont random imi spune ca parola sau numele este gresit cand bagun cont bun imi ramane la connectarea la server pe host,in pc tin sa mentionez ca merge fara probleme
Tipologie server:PVM easy
*Resursă folosită:Cleverl
*ServerFiles utilizat:Clever
*Syserr:

22 Feb 2020, 23:58

Hm .. "Can't connect to local MySQL server..."

Incearca asta :

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

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

3. chmod -R 777 /var/db/mysql

4. Reboot

Nu stiu, asta e o rezolvare pe care am primit-o eu de la cineva acum mult timp cand primeam eroare la start dupa ce aplicam backup-ul la MySQL din WinSCP

VirTual · 23 Feb 2020, 00:20

Am facut cum mi-ai spus ,mai dau eu dupa "restart-mysql" , da se conecteze la server, iar cand da sa intre sa-mi aleg caracterul,ma duc iar la pagina de logare...

23 Feb 2020, 00:27

Vezi ce-ti da in syserr server, printre ultimele linii

VirTual · 23 Feb 2020, 00:30

YSERR: Feb 22 23:27:53 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb 22 23:27:56 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb 22 23:27:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb 22 23:28:28 :: pid_init:
Start of pid: 1068

SYSERR: Feb 22 23:28:28 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb 22 23:28:31 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb 22 23:28:59 :: pid_init:

SYSERR: Feb 22 23:40:21 :: pid_init:
Start of pid: 1230

SYSERR: Feb 22 23:40:45 :: pid_init:
Start of pid: 1241

SYSERR: Feb 22 23:41:11 :: pid_init:
Start of pid: 1252

SYSERR: Feb 22 23:41:37 :: pid_init:
Start of pid: 1263

SYSERR: Feb 22 23:42:02 :: pid_init:
Start of pid: 1271

23 Feb 2020, 00:45

Config ch1 și conf.txt db și dai și comanda asta după ce dai drumul in vds și da print cu ce scoate.
sockstat -4l

[ Postat de pe Android ] Imagine

VirTual · 23 Feb 2020, 01:04

Config ch

db:

VirTual · 23 Feb 2020, 07:58

E configurat

Doar am spus mai sus ca pe pc imi merge fara probleme, iar pe host imi face ca mai sus.

23 Feb 2020, 14:03

VirTual scrie: ↑23 Feb 2020, 01:04 Config ch
HOSTNAME: channel1
CHANNEL: 1
PORT: 13001
P2P_PORT: 14001
DB_PORT: 15000
DB_ADDR: localhost
MAP_ALLOW: 1 3 21 110 111 4 23 24 25 41 43 44 46 61 62 63 64 65 240 235 212 352 66 67 68 69 70 71 72 73 74 104 207 216 217 222 246 301 302 303 304 306 307 353 354 355 356 357 358 241
TABLE_POSTFIX:
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
PLAYER_SQL: localhost mt2 mt2!@#! player
COMMON_SQL: localhost mt2 mt2!@#! common
LOG_SQL: localhost mt2 mt2!@#! log
TEST_SERVER: 0
PK_SERVER: 0
adminpage_ip: 185.249.197.104
adminpage_ip0: 185.249.197.104
adminpage_ip1: 185.249.197.104
adminpage_ip2: 185.249.197.104
adminpage_ip3: 185.249.197.104
adminpage_password: 1rr1324*223322r3rfv-233-_'2!!1$$$###2320123*2
MALL_URL: arkadia2.online/site
VIEW_RANGE: 8000
MAX_LEVEL: 120
PK_PROTECT_LEVEL: 15
BIND_IP: 194.36.142.202
PUBLIC_IP: 194.36.142.202
INTERNAL_IP: 194.36.142.202
SHOP_SERVER_ID: 0
db:
WELCOME_MSG = "DB Server Aciliyor.."

SQL_ACCOUNT = "localhost account mt2 mt2!@#! 0"
SQL_PLAYER = "localhost player mt2 mt2!@#! 0"
SQL_COMMON = "localhost common mt2 mt2!@#! 0"
SQL_HOTBACKUP = "localhost hotbackup mt2 mt2!@#! 0"

TABLE_POSTFIX = " "

BIND_PORT = 15000
DB_SLEEP_MSEC = 10
CLIENT_HEART_FPS = 10
HASH_PLAYER_LIFE_SEC = 600
BACKUP_LIMIT_SEC = 3600
PLAYER_ID_START = 100
PLAYER_DELETE_LEVEL_LIMIT = 70
PLAYER_DELETE_CHECK_SIMPLE = 1

ITEM_ID_RANGE = 1000000000 2000000000

MIN_LENGTH_OF_SOCIAL_ID = 6

SIMPLE_SOCIALID = 1
Block "Y/QSB7omi36awq4ctpUxuiwRARM="

bun in primul rand mysql nu are ip intern
te duci in conf.txt si adaugi sub:
BIND_PORT = 1500
BIND_IP = 127.0.0.1
2. te duci in toate configurile din ch1,2,3,.... si auth si scoti:
PUBLIC_IP: 194.36.142.202
INTERNAL_IP: 194.36.142.202
BIND_IP: 194.36.142.202
3. schimba in conf.txt din mysql
BIND_PORT = 15000 cu 12000
4. te duci in toate configurile din ch1,2,3,... si auth si schimbi:
DB_PORT: 15000 cu 12000
5. reboot
6. verifica si in start.sh ca db-ul sa porneasca primul in fiecare case si dupa ce porneste dai un: sleep 2 sa aibe timp sa porneasca corect

Edit:
ce am mai vazut acum ca prin syserr
te duci in navicat account apesi ctrl+q si rulezi:

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for block_exception
-- ----------------------------
DROP TABLE IF EXISTS `block_exception`;
CREATE TABLE `block_exception` (
  `login` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5;

-- ----------------------------
-- Records of block_exception
-- ----------------------------
INSERT INTO `block_exception` VALUES ('1000');

apoi tot in account rulezi si:

SET  @num := 0;

UPDATE account SET id = @num := (@num+1);

ALTER TABLE account AUTO_INCREMENT =1;

VirTual · 23 Feb 2020, 19:50

Am facut ce mi-ai spus tu si nu s-a schimbat nimic

Ce imi apare in folderul var/db/mysql in fisierul de errori de la host

Problema connectare server pus pe host

Problema la connectare server

Erroare de connectare la server :| !

Problema connectare sv ....

Problema connectare

Cine este conectat