Jump to content
  • 0
Sign in to follow this  
Kermit79

en cours connect : connexion refused

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.

Share this post


Link to post

Recommended Posts

  • 0

J'ai pas encore le client, sinon pour les tables SQL, oui c'est bon.

J'ai suivi ton tuto à la lettre.

Share this post


Link to post
  • 0

Non j'ai fait un raccourci, dans \root, j'ai mis un truc dans start :

#!/bin/sh

cd /usr/metin2

sh start.sh

 

après je met 1 channel.

 

PS : Pour le lancer, du coup je fais ./start

Share this post


Link to post
  • 0

Je teste en normal


ça met pareil...

:sniff:


PS : Dans sysinstall, quand je met en host : "mcncc.com" et en domain : "com" comme dans le tuto.

Cela revient automatiquement en host : "new-host-2" et domain : "home"...

Share this post


Link to post
  • 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

Share this post


Link to post
  • 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 ?

Share this post


Link to post
  • 0

Ba oui, c'est réglable.

 

Il faut que tu créé les tables, que tu exécute le fichier SQL sur la table correspondante ..

Share this post


Link to post
  • 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

Share this post


Link to post
  • 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"

 

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"

Share this post


Link to post
  • 0

Effectivement, je reboot, je test, et je vous dit. :)

Alors, maintenant il n'y a plus qu'un connect : connexion refused, et avant j'ai un message qui dit que j'ai réussi à me connecter aux 3 tables

C'est bon signe ?

Share this post


Link to post
  • 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

Share this post


Link to post
  • 0

Oui c'est ce que j'ai fait.

Je le refait et je te dit.


J'ait refait et c'est pareil, on dirait que ça marche :

Screen après une minute d'attente. (Plus d'erreurs) :

060847Sans-titre2.png

Share this post


Link to post
Guest
This topic is now closed to further replies.
Sign in to follow this  
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

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.