• Moyenne : 0 (0 vote(s))
  • 1
  • 2
  • 3
  • 4
  • 5
[Résolu] Problème de connexion
#1
Bonjour à tous,

j'essaye de finaliser l'installation d'un serveur sur un dédié hébergé chez DigitalOcean qui tourne sous FreeBSD 11.1.

Mon problème : lorsque je lance le client avec le serverinfo modifié (qui contient l'ip publique de mon dédié), tous les ch apparaissent fermés.
Comment j'ai procédé : J'ai installé les files 2016 Team FE sur le serveur, j'ai installé les libs manquantes, les tables MYSQL ect...
Résultats :
  • script start.sh : [Only registered and activated users can see links Click here to register]
  • syserr auth :

    SYSERR: Oct 12 10:33:25 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)SYSERR: Oct 12 10:33:25 :: socket_connect: HOST localhost:15000, could not connect.SYSERR: Oct 12 10:33:28 :: socket_connect: HOST localhost:15000, could not connect.
  • syserr db : (rempli de logs comme la ligne ci-dessous)


    SYSERR: Oct 12 10:33:24 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB9\xE9\xB0\xE1\xB4\xDC...' for column 'name' at row 1 (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (301, "
  • syserr core 1 channel 1:



    SYSERR: Oct 12 10:33:27 :: socket_connect: HOST localhost:15000, could not connect.SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: yamachun have not motlist.txt vnum(6091) folder(yamachun)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: yamachun have not motlist.txt vnum(6091) folder(yamachun)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: yamachun have not motlist.txt vnum(6091) folder(yamachun)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_giant_man2 have not motlist.txt vnum(6110) folder(ice_snow_giant_man2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_giant_man2 have not motlist.txt vnum(6110) folder(ice_snow_giant_man2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_giant_man2 have not motlist.txt vnum(6110) folder(ice_snow_giant_man2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_golem2 have not motlist.txt vnum(6111) folder(ice_snow_golem2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_golem2 have not motlist.txt vnum(6111) folder(ice_snow_golem2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_golem2 have not motlist.txt vnum(6111) folder(ice_snow_golem2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_insect2 have not motlist.txt vnum(6112) folder(ice_snow_insect2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_insect2 have not motlist.txt vnum(6112) folder(ice_snow_insect2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_insect2 have not motlist.txt vnum(6112) folder(ice_snow_insect2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_man2 have not motlist.txt vnum(6113) folder(ice_snow_man2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_man2 have not motlist.txt vnum(6113) folder(ice_snow_man2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_man2 have not motlist.txt vnum(6113) folder(ice_snow_man2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_monster2 have not motlist.txt vnum(6114) folder(ice_snow_monster2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_monster2 have not motlist.txt vnum(6114) folder(ice_snow_monster2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: ice_snow_monster2 have not motlist.txt vnum(6114) folder(ice_snow_monster2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_fly have not motlist.txt vnum(6115) folder(reddragon_room_fly)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_fly have not motlist.txt vnum(6115) folder(reddragon_room_fly)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_fly have not motlist.txt vnum(6115) folder(reddragon_room_fly)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_human_boss have not motlist.txt vnum(6116) folder(reddragon_room_human_boss)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_human_boss have not motlist.txt vnum(6116) folder(reddragon_room_human_boss)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_human_boss have not motlist.txt vnum(6116) folder(reddragon_room_human_boss)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_human_boss2 have not motlist.txt vnum(6117) folder(reddragon_room_human_boss2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_human_boss2 have not motlist.txt vnum(6117) folder(reddragon_room_human_boss2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: reddragon_room_human_boss2 have not motlist.txt vnum(6117) folder(reddragon_room_human_boss2)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: metinstone_reddragon_statue have not motlist.txt vnum(611Cool folder(metinstone_reddragon_statue)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: metinstone_reddragon_statue have not motlist.txt vnum(611Cool folder(metinstone_reddragon_statue)SYSERR: Oct 12 10:34:19 :: GetMotionFileName: Motion: metinstone_reddragon_statue have not motlist.txt vnum(611Cool folder(metinstone_reddragon_statue)
  • J'ai recommencé les manips d'installation plusieurs fois sans succès (cette fois-ci j'ai l'erreur socket_connect en plus), si quelqu'un pouvait m'aider ça serait sympa. Merci!
#2
Salut,

Ton premier sysser regarde bien pour une erreur coter mob_proto dans la db player.

Tu est sous quel files?
#3
(12-10-2017, 14:35)Collapse a écrit : Salut,

Ton premier sysser regarde bien pour une erreur coter mob_proto dans la db player.

Tu est sous quel files?

Citation :J'ai installé les files 2016 Team FE sur le serveur
#4
Le serveur est sous files 2016 Team Fe.
Pour le premier syserr, j'ai corrigé l'erreur en ajoutant la table string dans la bd account.
Par contre pour l'erreur socket_connect je vois pas où se trouve le pb.
#5
Ton serveur n'arrive pas a se connecter a la BDD , 15000 etant le port de liaison entre ton game et la BDD

1) coupe ton serveur mt2

Code :
cd /usr/metin2/ && ./close.sh

fais un netstat pour voir il est bien fermé
(port 13000 etc ... ne doivent plus être en état listen)

si il se ferme pas correctement , ferme le de maniere radical

Code :
ps | grep "game"

tu kill un par un les processsus avec leur PID

Code :
kill PID

et si y'en a un qui est asser chiant tu t'embette pas

Code :
kill-9 PID

par contre kill -9 , ATTENTION a ne pas en abuser , sa tue direct le processus et c'est dangereux


tu stope mysql
Code :
/usr/local/etc/rc.d/mysql-server stop

tu attend qu'il ai fini et qu'il te renvoi le shell
tu relance mysql
Code :
/usr/local/etc/rc.d/mysql-server start

tu lance la commande
Code :
mysql
si tu est connecter , c'est que c'est bon sinon c'est que mysql plante et faut savoir pourquoi

ATTENTION tu as peut etre defini un mot de passe meme pour le root local
Ne pas confondre root % et root localhost : c'est deux compte completement different

si tu as mis un mot de passe :
Code :
mysql -u root -p tonmotdepasse

si tu es connecter tu devrai avoir sa :

Code :
mysql >

si c'est le cas , relance ton serveur , sinon affiche nous les logs de mysql qui se trouve dans /var/db/mysql
le fichier a l'extension .err
#6
J'ai lancé ces commandes, je n'ai plus accès à mysql... (access denied for root using password : yes -> mon mdp est bon bien entendu)

log :

Code :
171012 13:11:11 mysqld_safe mysqld from pid file /var/db/mysql/freebsd-512mb-fra1-01.pid ended
2017-10-12 13:11:33 3812 [Note] Plugin 'FEDERATED' is disabled.
2017-10-12 13:11:33 3812 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-10-12 13:11:33 3812 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-12 13:11:33 3812 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-10-12 13:11:33 3812 [Note] InnoDB: Memory barrier is not used
2017-10-12 13:11:33 3812 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-10-12 13:11:33 3812 [Note] InnoDB: Using CPU crc32 instructions
2017-10-12 13:11:33 3812 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-10-12 13:11:34 3812 [Note] InnoDB: Completed initialization of buffer pool
2017-10-12 13:11:37 3812 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-12 13:11:37 3812 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=1597230
2017-10-12 13:11:37 3812 [Warning] InnoDB: Starting to delete and rewrite log files.
2017-10-12 13:11:37 3812 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-10-12 13:11:40 3812 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-10-12 13:11:42 3812 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-10-12 13:11:42 3812 [Warning] InnoDB: New log files created, LSN=1597230
2017-10-12 13:11:43 3812 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-12 13:11:43 3812 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-10-12 13:11:43 3812 [Note] InnoDB: Tablespace and datafile system tables created.
2017-10-12 13:11:43 3812 [Note] InnoDB: Waiting for purge to start
2017-10-12 13:11:43 3812 [Note] InnoDB: 5.6.37 started; log sequence number 1597230
2017-10-12 13:11:43 3812 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2017-10-12 13:11:43 3812 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2017-10-12 13:11:43 3812 [Note] Server hostname (bind-address): '*'; port: 3306
2017-10-12 13:11:43 3812 [Note] IPv6 is available.
2017-10-12 13:11:43 3812 [Note]   - '::' resolves to '::';
2017-10-12 13:11:43 3812 [Note] Server socket created on IP: '::'.
2017-10-12 13:11:44 3812 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50533, now running 50637. Please use mysql_upgrade to fix this error.
2017-10-12 13:11:44 3812 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50533, now running 50637. Please use mysql_upgrade to fix this error.
2017-10-12 13:11:44 3812 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50533, now running 50637. Please use mysql_upgrade to fix this error.
2017-10-12 13:11:44 3812 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2017-10-12 13:11:44 3812 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50533, now running 50637. Please use mysql_upgrade to fix this error.
2017-10-12 13:11:44 3812 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50533, now running 50637. Please use mysql_upgrade to fix this error.
2017-10-12 13:11:44 3812 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2017-10-12 13:11:44 3812 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2017-10-12 13:11:44 3812 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50533, now running 50637. Please use mysql_upgrade to fix this error.
2017-10-12 13:11:44 3812 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50092, now running 50637. Please use mysql_upgrade to fix this error.
2017-10-12 13:11:44 3812 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2017-10-12 13:11:44 3812 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.37'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
#7
De la même manière, tu utilises mysql5.6 tu devrais le désinstaller et utiliser mysql55 qui a été utilisé pour les fichiers des files 2016 FE. Ou alors tu fais un mysql_upgrade.
[Image: lrUNSda.png][Image: VfZQRcm.png]
#8
mysql_upgrade => Error: Failed while fetching Server version! Could be due to unauthorized access.

Quel est le rapport avec mon pb ? J'ai même plus accès à mysql maintenant !
#9
Dans ce cas tu avais surement fait une mauvaise configuraion du mysql

Tu avais suivi quel tutoriel pour faire l'installation du mysql?

Tu est sous dédier?
Quel opérateur et version du freebsd?
Quel version du mysql ?

Si tu n'a plus accès a mysql... ses parce que tout n'a pas bien été enregistrer lors de ta configuration !
#10
Je pense pas car mysql fonctionnait très bien avant.
J'ai suivi le tuto de mon hébergeur, qui proposait d'installer mysql56.
lien : [Only registered and activated users can see links Click here to register]
J'ai effectivement un dédié chez DigitalOcean tournant sous FreeBSD 11.1.

Pourtant je l'avais relancé plusieurs fois avec la commande service mysql-server restart et j'ai jamais eu de pb.




Utilisateur(s) parcourant ce sujet : 1 visiteur(s)
Donation's plugin by Naoar.com