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

Je n'arrive pas à me connecter


Rexal

Question

Bonjour, petit soucis de connexion

 

Version des files :2012

Domaine (Base de données, Core, etc.) :BDD

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

 

Description du problème : Donc quand je cree le perso dans la bdd de navicat,je fais tout ce qu'il faut et quand j'essaie de me co avec le compte cree sur mon serv ca bloque sur connexion au serveur en cours

Comment reproduire le problème

Recherches et tests effectué : Deja quand je mets de faux pass ca me met que c incorrect donc c un soucis avec les vrais comptes

Résultat des recherches et tests :

 

Message d'erreur, capture d'écran :

 

 

Merci  :top: [Message d'introduction]

 

PS: j'ai déjà reussi à me co,j'avais reboot pour me mettre GM et c'est à ce moment là que j'arrive pas à me co (encore maintenant)

Link to comment
  • Answers 39
  • Created
  • Last Reply

Top Posters For This Question

Top Posters For This Question

Recommended Posts

  • 0
  • Administrateur

Dans ton FTP, Avec Filezilla ou WinSCP tu as des dossiers "auth", "db" channel1" (sous dossier core 1) dans /usr/metin2.

Je souhaite que tu nous donnes le contenues des SYSERR de chacun, ils contiennent les erreurs de ton serveur qui nous permettra de mieux répondre à ton soucis.

Link to comment
  • 0

Bonsoir,

As-tu bien hashé ton mot de passe en Mysql5 ? Si oui vérifie bien que tout tes ports sont correctement ouvert.

Si ce n'est pas le cas ouvre les correctement ( Pense à couper Skype ) parfois ils peux jouer sur certains ports.

 

Cordialement, History.

 

J'ai reussi à me co,donc pas de soucis de mdp

 

Je viens de quitter skype,pas de changement.

Link to comment
  • 0

Vérifie donc correctement tes ports.

Ensuite je pense que tu devrais nous envoyer ce que ASIKOO t'as demandé en retour plus haut.

 

Avec le peu d'informations on ne sais pas ou cibler le problème ça peux venir de tout et rien en faite ^^

 

Cordialement, History.

 

J'aimerais bien savoir d'ou ca vient x)

Link to comment
  • 0
  • Administrateur

Les mots de passes, seuls toi peut les connaitre, nous ne connaissons pas tes files.

Sinon IP de ton serveur + root + le mot de passe que tu tapes au début quand tu dois te connecter à ton serveur (là ou tu écris start etc...) sur un logiciel FTP (Winscp, Filezilla)

Link to comment
  • 0

Les mots de passes, seuls toi peut les connaitre, nous ne connaissons pas tes files.

Sinon IP de ton serveur + root + le mot de passe que tu tapes au début quand tu dois te connecter à ton serveur (là ou tu écris start etc...)

 

Oue 

donc l'ip hamachi + root + toto

Link to comment
  • 0

Connexion refusé ou mot de passe incorrect  ? Faut savoir ce sont 2 choses différentes et opposée.

 

Cependant je me répète vérifiez bien vos ports si ils sont bien tous ouvert.

Si ce n'est pas le cas il ce peux qu'il faut redémarrer le serveur mais pensez à démarrer portmap avant et fermez SKYPE également lors du lancement.

 

Cordialement, History.

Link to comment
  • 0

Syserr de Auth:  http://image.noelshack.com/fichiers/2017/13/1491085246-sans-titre.png

De DB:  SYSERR:

erreur db

 Mar 10 19:52:52 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Mar 10 19:52:52 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

SYSERR: Mar 10 19:52:57 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

SYSERR: Mar 10 19:52:58 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

SYSERR: Mar 10 19:57:33 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Mar 10 19:57:37 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Mar 10 19:57:38 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

SYSERR: Mar 10 19:57:42 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

SYSERR: Mar 10 19:57:44 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

SYSERR: Mar 10 20:34:22 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  1 22:59:57 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Apr  1 23:00:32 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

SYSERR: Apr  1 23:00:37 :: heart_idle: losing 39 seconds. (lag occured)

SYSERR: Apr  1 23:00:37 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

SYSERR: Apr  1 23:00:38 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)

SYSERR: Apr  1 23:18:13 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Server shutdown in progress (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000001, 3, 2, 0, 1, 11609, 1, 0, 0) errno: 1053)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Lost connection to MySQL server during query (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(30000002, 3, 2, 1, 1, 12489, 28, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2013)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, socket0, socket1, socket2) VALUES(30000003, 3, 2, 4, 1, 19, 1, 0, 0) errno: 2002)

SYSERR: Apr  1 23:18:13 :: ChildLoop: AsyncSQL: retrying

SYSERR: Apr  1 23:20:06 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Apr  1 23:20:40 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

SYSERR: Apr  1 23:20:44 :: heart_idle: losing 37 seconds. (lag occured)

SYSERR: Apr  1 23:46:32 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  1 23:56:26 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Apr  1 23:56:29 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

SYSERR: Apr  2 00:03:35 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  2 00:04:13 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Apr  2 00:04:16 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

SYSERR: Apr  2 00:06:34 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  2 00:07:25 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Apr  2 00:07:29 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

SYSERR: Apr  2 00:10:43 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Apr  2 00:11:07 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)

 

 

 

 

 

 

De Channel1:

erreur Channel1

 SYSERR: Mar 10 19:57:33 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Mar 10 20:08:55 :: GetQuestStateIndex: QUEST wrong quest state file find_squareguard.find

SYSERR: Mar 10 20:10:20 :: Process: SEQUENCE 3c68cc00 mismatch 0xaf != 0x0 header 254

SYSERR: Mar 10 20:10:20 :: Process: SEQUENCE_LOG [uNKNOWN]-------------

[254 : 0xaf]

 

SYSERR: Mar 10 20:19:45 :: Process: SEQUENCE 3bdd9000 mismatch 0xaf != 0x0 header 254

SYSERR: Mar 10 20:19:45 :: Process: SEQUENCE_LOG [uNKNOWN]-------------

[254 : 0xaf]

 

SYSERR: Mar 10 20:29:48 :: Process: SEQUENCE 3c67a400 mismatch 0xaf != 0x0 header 254

SYSERR: Mar 10 20:29:48 :: Process: SEQUENCE_LOG [uNKNOWN]-------------

[254 : 0xaf]

 

SYSERR: Mar 10 20:34:22 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  1 23:00:06 :: socket_connect: HOST localhost:15000, could not connect.

SYSERR: Apr  1 23:11:16 :: heart_idle: losing 638 seconds. (lag occured)

SYSERR: Apr  1 23:11:19 :: socket_accept: accept: Software caused connection abort (fd 12)

SYSERR: Apr  1 23:15:17 :: Click: CQuestManager::Click(pid=3, target_npc_name=Petit Frere IS) - NOT EXIST NPC RACE VNUM[9008]

SYSERR: Apr  1 23:16:45 :: Click: CQuestManager::Click(pid=3, target_npc_name=Soeur IS) - NOT EXIST NPC RACE VNUM[9010]

SYSERR: Apr  1 23:17:25 :: Process: SEQUENCE 297dd400 mismatch 0xaf != 0x0 header 254

SYSERR: Apr  1 23:17:25 :: Process: SEQUENCE_LOG [uNKNOWN]-------------

[254 : 0xaf]

 

SYSERR: Apr  1 23:18:13 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  1 23:20:13 :: socket_connect: HOST localhost:15000, could not connect.

SYSERR: Apr  1 23:30:38 :: heart_idle: losing 593 seconds. (lag occured)

SYSERR: Apr  1 23:30:41 :: socket_accept: accept: Software caused connection abort (fd 12)

SYSERR: Apr  1 23:30:41 :: socket_accept: accept: Software caused connection abort (fd 12)

SYSERR: Apr  1 23:46:32 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  2 00:03:33 :: heart_idle: losing 421 seconds. (lag occured)

SYSERR: Apr  2 00:03:35 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  2 00:06:34 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Apr  2 00:07:29 :: socket_bind: bind: Address already in use

SYSERR: Apr  2 00:10:48 :: socket_connect: HOST localhost:15000, could not connect.

SYSERR: Apr  2 00:22:24 :: heart_idle: losing 671 seconds. (lag occured)

SYSERR: Apr  2 00:22:25 :: socket_accept: accept: Software caused connection abort (fd 12)

 

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.