Problema ! Erroare la conectare

Imuka · 13 Aug 2018, 21:19

*Problemă: In client imi da eroare la conectare
Tipologie server: PVM
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat: serverfile-pvm-hard-2089m
*Syserr:

DIN DB
SYSERR: Aug 13 20:17:12 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:19:48 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:24:56 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:31:29 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:34:46 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 21:18:44 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 21:44:57 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 22:05:36 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

Poză: - poza nu am la ce -
*Detalii suplimentare:
- Serveru e facut pe IP meu + No-IP ( Configurat in rooter Porturile + Logat la No-IP )
- Merge sa ma conecteaz la FTP/Navicat...
- Cand ii sau sh start.sh imi scrie CH 1 este pornit asteptati 10 secunde ( astept degeaba )
- Ajutor !?

Imuka · 13 Aug 2018, 21:51

Cel din Db apare acum

SYSERR: Aug 13 20:17:12 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:19:48 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:24:56 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:31:29 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:34:46 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 21:18:44 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 21:44:57 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 22:05:36 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 22:48:02 :: 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 errno: 1317)
SYSERR: Aug 13 22:48:07 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:07 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:12 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:12 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:12 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:12 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:17 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:17 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:17 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:17 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:17 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:17 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:22 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:22 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:22 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:22 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:22 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:22 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:22 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:22 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:27 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:32 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL errno: 2002)
SYSERR: Aug 13 22:48:37 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 13 22:48:42 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 13 22:48:48 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 22:49:29 :: socket_bind: bind: Address already in use

Cel din channel 1

SYSERR: Aug 13 22:05:36 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 22:07:50 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(2291) MAP(62)
SYSERR: Aug 13 22:08:07 :: heart_idle: losing 34 seconds. (lag occured)
SYSERR: Aug 13 22:48:51 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 22:49:33 :: socket_bind: bind: Address already in use

Cel din Auth

SYSERR: Aug 13 20:17:14 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:17:14 :: ChildLoop: AsyncSQL: query failed: Unknown column 'text' in 'field list' (query: SELECT name, text FROM string errno: 1054)
SYSERR: Aug 13 20:19:50 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:24:58 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:24:58 :: ChildLoop: AsyncSQL: query failed: Unknown column 'text' in 'field list' (query: SELECT name, text FROM string errno: 1054)
SYSERR: Aug 13 20:31:31 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:31:31 :: ChildLoop: AsyncSQL: query failed: Unknown column 'text' in 'field list' (query: SELECT name, text FROM string errno: 1054)
SYSERR: Aug 13 20:34:47 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 20:34:47 :: ChildLoop: AsyncSQL: query failed: Unknown column 'text' in 'field list' (query: SELECT name, text FROM string errno: 1054)
SYSERR: Aug 13 21:18:44 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 21:44:57 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 22:05:36 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Aug 13 22:48:49 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 22:48:49 :: ChildLoop: AsyncSQL: query failed: Unknown column 'text' in 'field list' (query: SELECT name, text FROM string errno: 1054)
SYSERR: Aug 13 22:49:30 :: socket_bind: bind: Address already in use
SYSERR: Aug 13 22:49:30 :: ChildLoop: AsyncSQL: query failed: Unknown column 'text' in 'field list' (query: SELECT name, text FROM string errno: 1054)

Thrasher · 15 Sep 2018, 03:15

Avusem o problemă similară. Am schimbat parola de la Navicat, apoi surprinzător, mi-a funcționat.

15 Sep 2018, 23:11

Incearca sa rulezi asta in player :

/*
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-09-16 00:11:15
*/

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
-- ----------------------------
INSERT INTO `item_award` VALUES ('1', '0', '', '0', '0', '0000-00-00 00:00:00', null, null, null, '0', '0', '0', '0');

Titan · 23 Sep 2018, 19:22

Răspuns primit, topic mutat în probleme rezolvate.

Problema ! Erroare la conectare

erroare la conectare

Erroare la conectare..

erroare conectare la server!

erroare conectare la server

Cine este conectat