Problema Pornire server

Khronos4Metin · 13 Iul 2018, 19:54

*Problemă:Pornesc serverul dar in client tot eroare conectare primesc
Tipologie server:PVM
*Resursă folosită:-
*ServerFiles utilizat:Luxurya
*Syserr:-
Poză:

AUTH:

[/b]
Ch1 Core1_1:

Ch1 core 1_2:

Game 99:

*Detalii suplimentare:Am modificat peste tot cu IP + am verificat si porturile

13 Iul 2018, 20:46

Cred ca nu ai locatiile corecte in fisierul start.sh ?

ai verificat ?
pune si sysser la tot

Khronos4Metin · 13 Iul 2018, 20:54

syss:

Cod: Selectaţi tot

SYSERR: Jul 13 17:37:32 :: pid_init: 
Start of pid: 1130

SYSERR: Jul 13 17:37:32 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 17:37:32 :: InitializeLocalization: InitializeLocalization() ==> DirectQuery failed(SELECT mValue, mKey FROM locale)
SYSERR: Jul 13 17:37:32 :: pid_deinit: 
End of pid

SYSERR: Jul 13 17:39:35 :: pid_init: 
Start of pid: 1241

SYSERR: Jul 13 17:39:35 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 17:40:17 :: pid_init: 
Start of pid: 1268

SYSERR: Jul 13 17:40:17 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 17:40:47 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1317)
SYSERR: Jul 13 17:40:57 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Jul 13 17:47:16 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 13 17:47:16 :: pid_deinit: 
End of pid

SYSERR: Jul 13 17:47:34 :: pid_init: 
Start of pid: 1445

SYSERR: Jul 13 17:47:34 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 18:04:00 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 13 18:04:00 :: pid_deinit: 
End of pid

SYSERR: Jul 13 18:04:05 :: pid_init: 
Start of pid: 1515

SYSERR: Jul 13 18:04:05 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 18:33:08 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 13 18:33:08 :: pid_deinit: 
End of pid

SYSERR: Jul 13 18:33:28 :: pid_init: 
Start of pid: 1769

SYSERR: Jul 13 18:33:28 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 18:55:10 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 13 18:55:10 :: pid_deinit: 
End of pid

SYSERR: Jul 13 18:55:23 :: pid_init: 
Start of pid: 2148

SYSERR: Jul 13 18:55:23 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 19:04:56 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 13 19:04:56 :: pid_deinit: 
End of pid

SYSERR: Jul 13 19:05:09 :: pid_init: 
Start of pid: 2350

SYSERR: Jul 13 19:05:09 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 20:38:06 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 13 20:38:06 :: pid_deinit: 
End of pid

SYSERR: Jul 13 20:41:35 :: pid_init: 
Start of pid: 2709

SYSERR: Jul 13 20:41:35 :: Start: TABLE_POSTFIX not configured use default

start.sh:

Am verificat si sunt bune locatiile

13 Iul 2018, 21:20

SYSERR: Jul 13 17:40:47 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1317)

intra in navigat--> player--> in player ctr+q,copiaza asta si ruleaz-o :

/*
Navicat MySQL Data Transfer

Source Server         : test sv
Source Server Version : 50552
Source Host           : 188.212.100.75:3306
Source Database       : player

Target Server Type    : MYSQL
Target Server Version : 50552
File Encoding         : 65001

Date: 2018-07-13 22:20:35
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for item_award
-- ----------------------------
DROP TABLE IF EXISTS `item_award`;
CREATE TABLE `item_award` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `login` varchar(30) NOT NULL DEFAULT '',
  `vnum` int(6) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `given_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `taken_time` datetime DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `why` varchar(128) DEFAULT NULL,
  `socket0` int(11) NOT NULL DEFAULT '0',
  `socket1` int(11) NOT NULL DEFAULT '0',
  `socket2` int(11) NOT NULL DEFAULT '0',
  `mall` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pid_idx` (`pid`),
  KEY `given_time_idx` (`given_time`),
  KEY `taken_time_idx` (`taken_time`)
) ENGINE=MyISAM AUTO_INCREMENT=71697 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of item_award
-- ----------------------------

reboot si incearca sa il pornesti iar

Khronos4Metin · 13 Iul 2018, 21:22

Sunt pe null toate in item_award

13 Iul 2018, 21:24

Tu ruleaza aia de mai sus care ti-am dat-o eu,reboot si porneste iar.

Khronos4Metin · 13 Iul 2018, 21:27

Cod: Selectaţi tot

SYSERR: Jul 13 22:13:53 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 13 22:30:20 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jul 13 22:30:20 :: pid_deinit: 
End of pid

SYSERR: Jul 13 22:32:26 :: pid_init: 
Start of pid: 816

SYSERR: Jul 13 22:32:26 :: Start: TABLE_POSTFIX not configured use default

13 Iul 2018, 21:29

inchide svr si dai sh start.sh iar,trebuie sa o ia

Khronos4Metin · 13 Iul 2018, 21:35

Cod: Selectaţi tot

SYSERR: Jul 13 22:39:30 :: pid_init: 
Start of pid: 929

SYSERR: Jul 13 22:39:30 :: Start: TABLE_POSTFIX not configured use default

Khronos4Metin · 14 Iul 2018, 19:46

Problema Pornire server

Problema pornire server

Problema pornire server

PROBLEMA PORNIRE SERVER.

Problema pornire server

Cine este conectat