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

je ne peux pas me co a mon dedier


tiran58
 Share

Question

[Message d'introduction]

 

Version des files :2012

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

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

 

Description du problème : impossibilité de se connecter au serveur alors que on peux se connecter au site ( site de test )

Comment reproduire le problème : je ne c'est pas du tous.....

Recherches et tests effectué : inscription par le site de test et navica total 2 compte créer

Résultat des recherches et tests :les 2 compte se connecte sur le site mais pas sur le client

 

Message d'erreur, capture d'écran : identifient ou mdp incorecte

 

Screen

1: un compte et crée

un compte est créé

1580890020.png

 

2: la connections au serveur et ok

connection ok

1480039566.png

 

3: impossible de se connecter par le client

Impossible de me connecter

1887225430.png

 

4: connections par le site de test

Test effectué

1551689514.png

 

 

 

 

putty:

 

Message de Putty

Real Server

Log OffAsyncSQL: connected to localhost (reconnect 1)

Success PLAYER

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

Success ACCOUNT

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

Success COMMON

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

Success HOTBACKUP

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

PUBLIC_IP:IP_de_mon_serveur interface em0

HOSTNAME: auth

AsyncSQL: connected to localhost (reconnect 1)

CommonSQL connected

Setting Locale "france" (Path: locale/france)

Setting DB to locale latin1

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

PlayerSQL connected

LogSQL connected

SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

AsyncSQL: connected to localhost (reconnect 1)

SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

AUTH_SERVER: I am the master

MasterAuth 8PUBLIC_IP: IP_de_mon_serveur interface em0

HOSTNAME: channel1

AsyncSQL: connected to localhost (reconnect 1)

CommonSQL connected

Setting Locale "france" (Path: locale/france)

Setting DB to locale latin1

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

PlayerSQL connected

LogSQL connected

SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

AsyncSQL: connected to localhost (reconnect 1)

SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

MAP ALLOW 1

MAP ALLOW 3

MAP ALLOW 4

MAP ALLOW 5

MAP ALLOW 21

MAP ALLOW 23

MAP ALLOW 24

MAP ALLOW 25

MAP ALLOW 41

MAP ALLOW 43

MAP ALLOW 44

MAP ALLOW 45

MAP ALLOW 61

MAP ALLOW 62

MAP ALLOW 63

MAP ALLOW 64

MAP ALLOW 65

MAP ALLOW 66

MAP ALLOW 67

MAP ALLOW 68

MAP ALLOW 69

MAP ALLOW 70

MAP ALLOW 71

MAP ALLOW 72

MAP ALLOW 73

MAP ALLOW 74

MAP ALLOW 75

MAP ALLOW 84

MAP ALLOW 85

MAP ALLOW 86

PLAYER_MAX_LEVEL:250 LocaleService locale/france/locale_string.txt

PUBLIC_IP: IP_de_mon_serveur interface em0

HOSTNAME: channel2

AsyncSQL: connected to localhost (reconnect 1)

CommonSQL connected

Setting Locale "france" (Path: locale/france)

Setting DB to locale latin1

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

PlayerSQL connected

LogSQL connected

SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

AsyncSQL: connected to localhost (reconnect 1)

SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

MAP ALLOW 1

MAP ALLOW 3

MAP ALLOW 4

MAP ALLOW 5

MAP ALLOW 21

MAP ALLOW 23

MAP ALLOW 24

MAP ALLOW 25

MAP ALLOW 41

MAP ALLOW 43

MAP ALLOW 44

MAP ALLOW 45

MAP ALLOW 61

MAP ALLOW 62

MAP ALLOW 63

MAP ALLOW 64

MAP ALLOW 65

MAP ALLOW 66

MAP ALLOW 67

MAP ALLOW 68

MAP ALLOW 69

MAP ALLOW 70

MAP ALLOW 71

MAP ALLOW 72

MAP ALLOW 73

MAP ALLOW 74

MAP ALLOW 75

MAP ALLOW 84

MAP ALLOW 85

MAP ALLOW 86

PLAYER_MAX_LEVEL:250 LocaleService locale/france/locale_string.txt

PUBLIC_IP: IP_de_mon_serveur interface em0

HOSTNAME: channel99

AsyncSQL: connected to localhost (reconnect 1)

CommonSQL connected

Setting Locale "france" (Path: locale/france)

Setting DB to locale latin1

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

AsyncSQL: connected to localhost (reconnect 1)

PlayerSQL connected

LogSQL connected

SKILL_POWER_BY_LEVEL 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 0 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 1 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

AsyncSQL: connected to localhost (reconnect 1)

SKILL_POWER_BY_JOB 2 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 3 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 4 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 5 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 6 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

SKILL_POWER_BY_JOB 7 0 5 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 50 52 54 56 58 60 63 66 69 72 82 85 88 91 94 98 102 106 110 115 125 125 125 125 125

MAP ALLOW 60

MAP ALLOW 81

MAP ALLOW 90

MAP ALLOW 91

MAP ALLOW 92

MAP ALLOW 103

MAP ALLOW 105

MAP ALLOW 110

MAP ALLOW 111

MAP ALLOW 112

MAP ALLOW 113

MAP ALLOW 140

MAP ALLOW 181

MAP ALLOW 182

MAP ALLOW 183

PLAYER_MAX_LEVEL:250 LocaleService locale/france/locale_string.txt

 

 

 

 

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

 

Edit by herostar 34 : Mettre des spoilers, permet d'éviter une page full image, merci de les mettre la prochaine fois.

Link to comment
Share on other sites

  • Answers 9
  • Created
  • Last Reply

Top Posters For This Question

Popular Days

Top Posters For This Question

9 answers to this question

Recommended Posts

  • 0

Alors la solution est simple c'est comme moi

 

Tu va dans /usr/metin2/g1/auth puis tu ouvre le fichier CONFIG

 

Tu supprimer tes ancienne ligne et tu remplace par sa !

 

 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
ACCOUNT_SQL: localhost mt2 [email protected]# account
PLAYER_SQL: localhost mt2 [email protected]# account
COMMON_SQL: localhost mt2 [email protected]# common
LOG_SQL: localhost mt2 [email protected]# log
LOCALE_SERVICE: france 

 

En gros la nouvelle ligne ajouter est celle ci :

 

PLAYER_SQL: localhost mt2 [email protected]# account

 

Apres tu va sur putty et tu reboot ton serveur et dit moi la réponse

 

PS : Si c'est résolu oublie pas de changer ta balise après ;)

  • J'adore 1
Link to comment
Share on other sites

  • 0

dayedu91 : sa marche mais mtn le jeux crache et me mais une fenaitre avec des : ????????????

 

 

 

*-dj28-* : j'ai tenter avec 1 , 2 , 3 , 4 ,5 chanelle sa ne change rien

 

 

Takron :

SYSERR: Dec 10 23:41:03 :: ChildLoop: AsyncSQL: query failed: Table 'player.account' doesn't exist (query: SELECT PASSWORD('Mon-mdp'),password,securitycode,social_id,id,status,availDt - NOW() > 0,UNIX_TIMESTAMP(silver_expire),UNIX_TIMESTAMP(gold_expire),UNIX_TIMESTAMP(safebox_expire),UNIX_TIMESTAMP(autoloot_expire),UNIX_TIMESTAMP(fish_mind_expire),UNIX_TIMESTAMP(marriage_fast_expire),UNIX_TIMESTAMP(money_drop_rate_expire),UNIX_TIMESTAMP(create_time) FROM account WHERE login='Mon-mdp' errno: 1146)

SYSERR: Dec 10 23:45:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Dec 11 00:00:05 :: ChildLoop: AsyncSQL: query failed: Table 'player.account' doesn't exist (query: SELECT PASSWORD('MOn-mdp'),password,securitycode,social_id,id,status,availDt - NOW() > 0,UNIX_TIMESTAMP(silver_expire),UNIX_TIMESTAMP(gold_expire),UNIX_TIMESTAMP(safebox_expire),UNIX_TIMESTAMP(autoloot_expire),UNIX_TIMESTAMP(fish_mind_expire),UNIX_TIMESTAMP(marriage_fast_expire),UNIX_TIMESTAMP(money_drop_rate_expire),UNIX_TIMESTAMP(create_time) FROM account WHERE login='Mon-mdp' errno: 1146)

SYSERR: Dec 11 00:00:13 :: ChildLoop: AsyncSQL: query failed: Table 'player.account' doesn't exist (query: SELECT PASSWORD('MOn-mdp'),password,securitycode,social_id,id,status,availDt - NOW() > 0,UNIX_TIMESTAMP(silver_expire),UNIX_TIMESTAMP(gold_expire),UNIX_TIMESTAMP(safebox_expire),UNIX_TIMESTAMP(autoloot_expire),UNIX_TIMESTAMP(fish_mind_expire),UNIX_TIMESTAMP(marriage_fast_expire),UNIX_TIMESTAMP(money_drop_rate_expire),UNIX_TIMESTAMP(create_time) FROM account WHERE login='tiran58' errno: 1146)

SYSERR: Dec 11 00:00:30 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.

SYSERR: Dec 11 11:49:22 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'last_play' in 'field list'

query: UPDATE account SET last_play=NOW() WHERE id=7607

SYSERR: Dec 11 11:49:37 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'last_play' in 'field list'

query: UPDATE account SET last_play=NOW() WHERE id=7607

SYSERR: Dec 11 11:50:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'last_play' in 'field list'

query: UPDATE account SET last_play=NOW() WHERE id=7607

SYSERR: Dec 11 11:50:47 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Unknown column 'last_play' in 'field list'

query: UPDATE account SET last_play=NOW() WHERE id=7607

Link to comment
Share on other sites

  • 0

Ah bah oui mais le problème de ce syserr a été réparé ce matin vu que l'erreur date d'hier 23h don si ton jeu crash quand tu te connecte c'est le syserr du ch où tu te connecte et le syserr du client.

 

Donc ça peut provenir de beaucoup de choses... En général le client mais c'est pas sûr à 100% faut voir ce que disent les syserr ch et client.

Link to comment
Share on other sites

  • 0
1211 12:50:10594 :: LZObject: not a valid data

1211 12:50:10594 :: Failed to decompress : d:/ymir work/effect/monster/yeongi.dds

 

 

j'ai que sa


je vais tester avec un client vierge pour voir


avec un client vierge sa marche =)

 

mais fau que je reface mon client --"

Link to comment
Share on other sites

  • 0
  • Retraité

Bonsoir,

 

Le sujet contient la balise [glow=red][Résolu][/glow] ou reste sans réponse, de ce fait il a été déplacé dans la section "Résolu ou sans réponse".

 

Bonne soirée.

You can't be immortal,
But you can make people remember
you for thousands of years...

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



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.