Metin2 Server Repair (DB, Channels, mob_proto Fix)
Budget: $10 – $50 USD
I need an experienced Metin2 developer to fix several issues with my server.
Here is the current diagnosis:
Database connection issues: Channels (CH1–CH4) cannot connect to DB cache (port 15000), causing all channels to appear offline even though ports 1300x are open.
mob_proto errors: Schema mismatch with size column (enum), corrupted or inconsistent data in mob_proto.txt vs database table, causing repeated SQL errors like "Data truncated for column 'size'".
Crashed or inconsistent tables: Likely MyISAM corruption due to previous improper shutdowns.
Login issues: Players cannot log in because auth works, but channels fail to connect to DB.
Ideal Skills and Experience:
Strong experience with Metin2 server management.
Proficiency in troubleshooting and repairing MySQL tables (MyISAM).
Familiarity with mob_proto schema alignment (TXT/SQL) and fixing data corruption.
Ability to resolve DB cache and channel connection issues.
Please provide a detailed plan of how you would approach solving these issues.
Note:
The issues listed above are the ones we have diagnosed so far, but there may be additional problems that appear during the repair process. The selected freelancer must be able to identify and resolve all issues until the server is fully stable, all channels are online, and players can log in successfully without errors (100% working condition)
Here is the current diagnosis:
Database connection issues: Channels (CH1–CH4) cannot connect to DB cache (port 15000), causing all channels to appear offline even though ports 1300x are open.
mob_proto errors: Schema mismatch with size column (enum), corrupted or inconsistent data in mob_proto.txt vs database table, causing repeated SQL errors like "Data truncated for column 'size'".
Crashed or inconsistent tables: Likely MyISAM corruption due to previous improper shutdowns.
Login issues: Players cannot log in because auth works, but channels fail to connect to DB.
Ideal Skills and Experience:
Strong experience with Metin2 server management.
Proficiency in troubleshooting and repairing MySQL tables (MyISAM).
Familiarity with mob_proto schema alignment (TXT/SQL) and fixing data corruption.
Ability to resolve DB cache and channel connection issues.
Please provide a detailed plan of how you would approach solving these issues.
Note:
The issues listed above are the ones we have diagnosed so far, but there may be additional problems that appear during the repair process. The selected freelancer must be able to identify and resolve all issues until the server is fully stable, all channels are online, and players can log in successfully without errors (100% working condition)