Jump to content
×
×
  • Create New...
  • 0

connect : connexion refused


Kermit79

Question

[Message d'introduction]

 

Version des files : Passage en 2012

Domaine (Base de données, Core, etc.) : connect : connexion timed out

Votre niveau (débutant, intermédiaire, avancé) : intermédiaire

 

Description du problème : Messages à répétition

Comment reproduire le problème : Sans le faire exprès :)

Recherches et tests effectué : J'ai suivi :

https://funky-emu.net/showthread.php?tid=2072&highlight=refused

et

https://funky-emu.net/showthread.php?tid=36812

Résultat des recherches et tests : Négatif :(

 

Message d'erreur, capture d'écran :

http://img822.imageshack.us/img822/9003/capturesib.png

 

En postant ma demande d'aide, j'affirme avoir lu et accepté le règlement des demandes d'aides.

Link to comment
  • Answers 49
  • Created
  • Last Reply

Top Posters For This Question

Top Posters For This Question

Recommended Posts

  • 0

OK je fais ça et je reviens.

PS : Voici quelques erreurs syserr/syslog :

Auth :

SYSERR: Mar 6 22:07:23 :: socket_connect: HOST localhost:15000, could not connect.

 

DB :(syslog) :

Mar 6 22:07:29 :: AsyncSQL: locale euckr

Mar 6 22:07:29 :: --mysql_set_character_set(euckr)

Mar 6 22:07:29 :: CREATING MAIN_SQL

Mar 6 22:07:29 :: AsyncSQL: locale euckr

Mar 6 22:07:29 :: CREATING ASYNC_SQL

Mar 6 22:07:29 :: AsyncSQL: locale euckr

Mar 6 22:07:29 :: OK

Mar 6 22:07:29 :: Start: SQL_COMMON not configured

Mar 6 22:07:29 :: --mysql_set_character_set(euckr)

Mar 6 22:07:29 :: --mysql_set_character_set(euckr)

Mar 6 22:07:29 :: AsyncSQL: closing mysql connection.

 

DB : (Syserr) :

SYSERR: Mar 6 22:06:57 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Mar 6 22:07:29 :: Start: SQL_COMMON not configured

 

CH1,GAME99 :

SYSERR: Mar 6 22:08:17 :: socket_connect: HOST localhost:15000, could not connect.

SYSERR: Mar 6 22:08:19 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Mar 6 22:08:19 :: socket_block: fcntl: nonblock: Bad file descriptor







"Supprime toutes les tables de ta BDD puis tu les remets mais celle des Files 2012.."

J'ai fait mais quand je remets ça : "Tables_SQL_2012", elles ne reviennent pas...

Je fais comment :(

Elles ont disparues

Link to comment
  • 0

Tu m'as dit : "Supprime toutes les tables de ta BDD puis tu les remets mais celle des Files 2012.."

Alors j'ai ouvert Navicat, J'ai ouvert la BDD de mon serveur, puis j'ai supprimé toutes les tables.

Après j'ai pris les fichiers SQL de ton tuto pour les remettres mais les tables n'ont pas réapparues.

En gros elles on disparues...

J'ai plus de tables, je fais comment ?


C'est rassurant que ça vienne de ma BDD ?

Link to comment
  • 0

Configuration de : \usr\metin2

Chanel 1:

 

HOSTNAME: channel1

CHANNEL: 1

PORT: 13000

P2P_PORT: 14000

DB_PORT: 15000

DB_ADDR: localhost

MAP_ALLOW: 1 3 4 5 21 23 24 25 41 43 44 45 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 84 85 86

TABLE_POSTFIX:

PASSES_PER_SEC: 25

SAVE_EVENT_SECOND_CYCLE: 180

PING_EVENT_SECOND_CYCLE: 180

PLAYER_SQL: 192.168.1.5 root 16427crl player

COMMON_SQL: 192.168.1.5 root 16427crl common

LOG_SQL: 192.168.1.5 root 16427crl log

LOCALE_SERVICE: france

#TEST_SERVER: 1

#NO_PK: 1

MAX_LEVEL: 250

MALL_URL: google.fr

adminpage_ip0: 127.0.0.1

adminpage_ip1: 127.0.0.1

adminpage_ip2: 127.0.0.1

adminpage_ip3: 127.0.0.1

admin_page_password: dmpe/DKH*éàlJD

VIEW_RANGE: 20000

CHECK_MULTIHACK: 1

 

Chanel 2:

 

HOSTNAME: channel2

CHANNEL: 2

PORT: 13001

P2P_PORT: 14001

DB_PORT: 15000

DB_ADDR: localhost

MAP_ALLOW: 1 3 4 5 21 23 24 25 41 43 44 45 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 84 85 86

TABLE_POSTFIX:

PASSES_PER_SEC: 25

SAVE_EVENT_SECOND_CYCLE: 180

PING_EVENT_SECOND_CYCLE: 180

PLAYER_SQL: 192.168.1.5 root 16427crl player

COMMON_SQL: 192.168.1.5 root 16427crl common

LOG_SQL: 192.168.1.5 root 16427crl log

LOCALE_SERVICE: france

#TEST_SERVER: 1

#NO_PK: 1

MAX_LEVEL: 250

MALL_URL: google.fr

adminpage_ip0: 127.0.0.1

adminpage_ip1: 127.0.0.1

adminpage_ip2: 127.0.0.1

adminpage_ip3: 127.0.0.1

admin_page_password: dmpe/DKH*éàlJD

VIEW_RANGE: 20000

CHECK_MULTIHACK: 1

 

Chanel 3:

 

HOSTNAME: channel3

CHANNEL: 3

PORT: 13002

P2P_PORT: 14002

DB_PORT: 15000

DB_ADDR: localhost

MAP_ALLOW: 1 3 4 5 21 23 24 25 41 43 44 45 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 84 85 86

TABLE_POSTFIX:

PASSES_PER_SEC: 25

SAVE_EVENT_SECOND_CYCLE: 180

PING_EVENT_SECOND_CYCLE: 180

PLAYER_SQL: 192.168.1.5 root 16427crl player

COMMON_SQL: 192.168.1.5 root 16427crl common

LOG_SQL: 192.168.1.5 root 16427crl log

LOCALE_SERVICE: france

#TEST_SERVER: 1

#NO_PK: 1

MAX_LEVEL: 250

MALL_URL: google.fr

adminpage_ip0: 127.0.0.1

adminpage_ip1: 127.0.0.1

adminpage_ip2: 127.0.0.1

adminpage_ip3: 127.0.0.1

admin_page_password: dmpe/DKH*éàlJD

VIEW_RANGE: 20000

CHECK_MULTIHACK: 1

 

Chanel 4 :

 

HOSTNAME: channel4

CHANNEL: 4

PORT: 13003

P2P_PORT: 14003

DB_PORT: 15000

DB_ADDR: localhost

MAP_ALLOW: 1 3 4 5 21 23 24 25 41 43 44 45 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 84 85 86

TABLE_POSTFIX:

PASSES_PER_SEC: 25

SAVE_EVENT_SECOND_CYCLE: 180

PING_EVENT_SECOND_CYCLE: 180

PLAYER_SQL: 192.168.1.5 root 16427crl player

COMMON_SQL: 192.168.1.5 root 16427crl common

LOG_SQL: 192.168.1.5 root 16427crl log

LOCALE_SERVICE: france

#TEST_SERVER: 1

#NO_PK: 1

MAX_LEVEL: 250

MALL_URL: google.fr

adminpage_ip0: 127.0.0.1

adminpage_ip1: 127.0.0.1

adminpage_ip2: 127.0.0.1

adminpage_ip3: 127.0.0.1

admin_page_password: dmpe/DKH*éàlJD

VIEW_RANGE: 20000

CHECK_MULTIHACK: 1

 

Chanel 5 :

 

HOSTNAME: channel5

CHANNEL: 5

PORT: 13004

P2P_PORT: 14004

DB_PORT: 15000

DB_ADDR: localhost

MAP_ALLOW: 1 3 4 5 21 23 24 25 41 43 44 45 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 84 85 86

TABLE_POSTFIX:

PASSES_PER_SEC: 25

SAVE_EVENT_SECOND_CYCLE: 180

PING_EVENT_SECOND_CYCLE: 180

PLAYER_SQL: 192.168.1.5 root 16427crl player

COMMON_SQL: 192.168.1.5 root 16427crl common

LOG_SQL: 192.168.1.5 root 16427crl log

LOCALE_SERVICE: france

#TEST_SERVER: 1

#NO_PK: 1

MAX_LEVEL: 250

MALL_URL: google.fr

adminpage_ip0: 127.0.0.1

adminpage_ip1: 127.0.0.1

adminpage_ip2: 127.0.0.1

adminpage_ip3: 127.0.0.1

admin_page_password: dmpe/DKH*éàlJD

VIEW_RANGE: 20000

CHECK_MULTIHACK: 1

 

Game99

 

HOSTNAME: channel99

CHANNEL: 99

PORT: 13099

P2P_PORT: 14099

DB_PORT: 15000

DB_ADDR: localhost

MAP_ALLOW: 60 81 90 91 92 103 105 110 111 112 113 140 181 182 183

TABLE_POSTFIX:

PASSES_PER_SEC: 25

SAVE_EVENT_SECOND_CYCLE: 180

PING_EVENT_SECOND_CYCLE: 180

PLAYER_SQL: 192.168.1.5 root 16427crl player

COMMON_SQL: 192.168.1.5 root 16427crl common

LOG_SQL: 192.168.1.5 root 16427crl log

LOCALE_SERVICE: france

#TEST_SERVER: 1

#NO_PK: 1

MAX_LEVEL: 250

MALL_URL: google.fr

adminpage_ip0: 127.0.0.1

adminpage_ip1: 127.0.0.1

adminpage_ip2: 127.0.0.1

adminpage_ip3: 127.0.0.1

admin_page_password: dmpe/DKH*éàlJD

VIEW_RANGE: 20000

CHECK_MULTIHACK: 1

 

DB:

 

WELCOME_MSG = "DB Server has been started"

 

SQL_ACCOUNT = "192.168.1.5 account root 16427crl 0"

SQL_PLAYER = 192.168.1.5 player root 16427crl 0"

SQL_COMMON = 192.168.1.5 common root 16427crl 0"

SQL_HOTBACKUP = 192.168.1.5 hotbackup root 16427crl 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 = 90

PLAYER_DELETE_CHECK_SIMPLE = 1

 

ITEM_ID_RANGE = 2000000000 2100000000

 

MIN_LENGTH_OF_SOCIAL_ID = 6

 

#NAME_COLUMN = "locale_name"

#LOCALE = "france"

SIMPLE_SOCIALID = 1

 

AUTH :

 

HOSTNAME: auth

CHANNEL: 1

PORT: 11002

P2P_PORT: 12000

DB_PORT: 15000

DB_ADDR: localhost

TABLE_POSTFIX:

ITEM_ID_RANGE: 000000001 000000002

PASSES_PER_SEC: 25

SAVE_EVENT_SECOND_CYCLE: 180

PING_EVENT_SECOND_CYCLE: 180

AUTH_SERVER: master

PLAYER_SQL: 192.168.1.5 root 16427crl account

LOG_SQL: 192.168.1.5 root 16427crl log

COMMON_SQL: 192.168.1.5 root 16427crl common

LOCALE_SERVICE: france

Link to comment
  • 0
  • Administrateur

SQL_PLAYER = 192.168.1.5 player root 16427crl 0"

SQL_COMMON = 192.168.1.5 common root 16427crl 0"

SQL_HOTBACKUP = 192.168.1.5 hotbackup root 16427crl 0"

 

Tu as oublié des ", remplace par, das le fichier Config de DB :)

 

SQL_ACCOUNT = "192.168.1.5 account root 16427crl 0"

SQL_PLAYER = "192.168.1.5 player root 16427crl 0"

SQL_COMMON = "192.168.1.5 common root 16427crl 0"

SQL_HOTBACKUP = "192.168.1.5 hotbackup root 16427crl 0"

Link to comment
  • 0

Le voici :

WELCOME_MSG = "DB Server has been started"

 

SQL_ACCOUNT = "192.168.1.5 account root 16427crl 0"

SQL_PLAYER = "192.168.1.5 player root 16427crl 0"

SQL_COMMON = "192.168.1.5 common root 16427crl 0"

SQL_HOTBACKUP = "192.168.1.5 hotbackup root 16427crl 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 = 90

PLAYER_DELETE_CHECK_SIMPLE = 1

 

ITEM_ID_RANGE = 2000000000 2100000000

 

MIN_LENGTH_OF_SOCIAL_ID = 6

 

#NAME_COLUMN = "locale_name"

#LOCALE = "france"

SIMPLE_SOCIALID = 1

Link to comment
Guest
This topic is now closed to further replies.


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.