isaacsousa 5 Posted July 19, 2016 Share Posted July 19, 2016 (edited) Hi there, I came here with a problem, I'm trying this for days and no results... Well, it's the first time I ever used an VPS to host some serverfiles, so maybe the problem is there, but here it is: I downloaded some files, and followed an tutorial about how to install them... I did every single step it asks on it... : This is on it's "start.sh", and there is the only place I can see that it could need my ip, so I already changed it (already checked CONFIG files on each core). Spoiler Also, I've changed the serverinfo.py located on root files on client. All the IP that were there, I changed to mine. Okay, so far so good, now here's the problem: If I put the wrong password when login: Spoiler As you can see, it warns me that my ID or password are wrong... But If I put both ID and password correctly: Spoiler As you can see, it says that it failed to connect to the server... I've been looking alot these days, but I couldn't find anything... Do you know why is it making such "error"? Do you know how to fix it? Please, I need your help Edited August 24, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
WhiteHat 5 Posted July 19, 2016 Share Posted July 19, 2016 Show us syerr of auth, DB, cliënt Link to comment Share on other sites More sharing options...
Premium FlorinMarian 122 Posted July 19, 2016 Premium Share Posted July 19, 2016 check if your server it's really started ( I think auth/ch1 failed) How to check ? http://your-ip:port --> port from CH1/AUTH If your server really works you will see something like this: ýÿ7Áó; . Shared Hosting | Domain names | Dedicated Servers | VPS HAZI.ro Link to comment Share on other sites More sharing options...
isaacsousa 5 Posted July 19, 2016 Author Share Posted July 19, 2016 2 hours ago, WhiteHat said: Show us syerr of auth, DB, cliënt Auth: Spoiler SYSERR: Jul 19 01:22:00 :: pid_init: Start of pid: 6519 SYSERR: Jul 19 01:51:08 :: ChildLoop: MySQL connection was reconnected. querying locale set SYSERR: Jul 19 02:05:11 :: DirectQuery: MySQL connection was reconnected. querying locale set DB (it's a huge file, but it says all the same thing:): Spoiler SYSERR: Jul 19 01:20:11 :: pid_init: Start of pid: 6429 SYSERR: Jul 19 01:20:11 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jul 19 01:21:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 19 01:21:40 :: pid_deinit: End of pid SYSERR: Jul 19 01:21:55 :: pid_init: Start of pid: 6505 SYSERR: Jul 19 01:21:55 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jul 19 01:23:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:23:35 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:23:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:23:40 :: ChildLoop: AsyncSQL: retrying (...) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:44 :: ChildLoop: MySQL connection was reconnected. querying locale set SYSERR: Jul 19 01:41:59 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1317) SYSERR: Jul 19 01:42:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:42:04 :: ChildLoop: AsyncSQL: retrying Client (empty): Spoiler ----------------------------------------------------------------------------------------------------- 2 hours ago, FlorinMarian said: check if your server it's really started ( I think auth/ch1 failed) How to check ? http://your-ip:port --> port from CH1/AUTH If your server really works you will see something like this: ýÿ7Áó; . Ch1 what core? I have 5 :/ I tried the auth, it just downloads something called download... Thanks for your help, you both Link to comment Share on other sites More sharing options...
Premium FlorinMarian 122 Posted July 19, 2016 Premium Share Posted July 19, 2016 2 hours ago, isaacsousa said: Auth: Reveal hidden contents SYSERR: Jul 19 01:22:00 :: pid_init: Start of pid: 6519 SYSERR: Jul 19 01:51:08 :: ChildLoop: MySQL connection was reconnected. querying locale set SYSERR: Jul 19 02:05:11 :: DirectQuery: MySQL connection was reconnected. querying locale set DB (it's a huge file, but it says all the same thing:): Reveal hidden contents SYSERR: Jul 19 01:20:11 :: pid_init: Start of pid: 6429 SYSERR: Jul 19 01:20:11 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jul 19 01:21:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 19 01:21:40 :: pid_deinit: End of pid SYSERR: Jul 19 01:21:55 :: pid_init: Start of pid: 6505 SYSERR: Jul 19 01:21:55 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jul 19 01:23:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:23:35 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:23:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:23:40 :: ChildLoop: AsyncSQL: retrying (...) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:37:39 :: ChildLoop: AsyncSQL: retrying SYSERR: Jul 19 01:37:44 :: ChildLoop: MySQL connection was reconnected. querying locale set SYSERR: Jul 19 01:41:59 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1317) SYSERR: Jul 19 01:42:04 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002) SYSERR: Jul 19 01:42:04 :: ChildLoop: AsyncSQL: retrying Client (empty): Reveal hidden contents ----------------------------------------------------------------------------------------------------- Ch1 what core? I have 5 :/ I tried the auth, it just downloads something called download... Thanks for your help, you both CORE1 bro(I think that it's in serverinfo.py on root) Shared Hosting | Domain names | Dedicated Servers | VPS HAZI.ro Link to comment Share on other sites More sharing options...
isaacsousa 5 Posted July 19, 2016 Author Share Posted July 19, 2016 22 minutes ago, FlorinMarian said: CORE1 bro(I think that it's in serverinfo.py on root) *my ip* refused to connect. ERR_CONNECTION_REFUSED Link to comment Share on other sites More sharing options...
Premium FlorinMarian 122 Posted July 20, 2016 Premium Share Posted July 20, 2016 so, your server do not run. Check syserr from channel1_core1 to see where is the problem Shared Hosting | Domain names | Dedicated Servers | VPS HAZI.ro Link to comment Share on other sites More sharing options...
GTS 1 Posted July 20, 2016 Share Posted July 20, 2016 Editing db source code can trigger this response. If u edited something in db source, run clean version and compare. Link to comment Share on other sites More sharing options...
isaacsousa 5 Posted July 20, 2016 Author Share Posted July 20, 2016 5 hours ago, FlorinMarian said: so, your server do not run. Check syserr from channel1_core1 to see where is the problem syserr: Spoiler SYSERR: Jul 19 01:22:00 :: pid_init: Start of pid: 6521 SYSERR: Jul 19 01:22:03 :: BuildStateIndexToName: QUEST wrong quest state file for quest Eisland_W?chter SYSERR: Jul 19 01:22:09 :: GetQuestStateIndex: QUEST wrong quest state file Eisland_W?chter.start SYSERR: Jul 19 01:22:09 :: GetQuestStateIndex: QUEST wrong quest state file Eisland_W?chter.start SYSERR: Jul 19 01:22:09 :: GetQuestStateIndex: QUEST wrong quest state file Eisland_W?chter.start 4 hours ago, GTS said: Editing db source code can trigger this response. If u edited something in db source, run clean version and compare. No man, I just downloaded this and upload it right away, already compiled... I do not believe the problem is on the serverfiles it self, but maybe on the vps itself I guess... There was a tutorial on the youtube that shows a guy instaling the same files on a vps, and they work fine on him... And I followed step by step... Honestly, I don't have a clue why mine doesnt work and his work... Link to comment Share on other sites More sharing options...
GTS 1 Posted July 20, 2016 Share Posted July 20, 2016 give me your : db/conf.txt auth/config ch1/config try to run server and send me screen with command bsd "ps" Link to comment Share on other sites More sharing options...
isaacsousa 5 Posted July 20, 2016 Author Share Posted July 20, 2016 6 hours ago, GTS said: give me your : db/conf.txt auth/config ch1/config try to run server and send me screen with command bsd "ps" db: Spoiler WELCOME_MSG = "Die Datenbank funzt freut euch was läuft unso" SQL_ACCOUNT = "localhost account mt2 mt2!@# 0" SQL_PLAYER = "localhost player mt2 mt2!@# 0" SQL_COMMON = "localhost common mt2 mt2!@# 0" SQL_HOTBACKUP = "localhost hotbackup mt2 mt2!@# 0" TABLE_POSTFIX = "" BIND_PORT = 15001 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 = 250 PLAYER_DELETE_LEVEL_LIMIT_LOWER = 1 ITEM_ID_RANGE = 2000000000 2100000000 MIN_LENGTH_OF_SOCIAL_ID = 6 #NAME_COLUMN = "locale_name" #LOCALE = "germany" SIMPLE_SOCIALID = 1 NO_TXT = 1 Block "Y/QSB7omi36awq4ctpUxuiwRARM=" auth: Spoiler HOSTNAME: auth_test CHANNEL: 1 PORT: 21002 P2P_PORT: 78000 DB_PORT: 15001 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: localhost mt2 mt2!@# account COMMON_SQL: localhost mt2 mt2!@# common LOG_SQL: localhost mt2 mt2!@# log LOCALE_SERVICE: GERMANY adminpage_ip: 127.0.0.1 adminpage_password: 21279Hdfs432dsfqwa3e2qw4erKBdsaLJHGdsa323weqw ch-1 Spoiler HOSTNAME: channel1_core1_test CHANNEL: 1 PORT: 23070 P2P_PORT: 25001 DB_PORT: 15001 DB_ADDR: localhost MAP_ALLOW: 1 3 4 5 21 23 24 25 41 43 44 45 63 64 65 66 67 68 69 70 TABLE_POSTFIX: PASSES_PER_SEC: 25 SAVE_EVENT_SECOND_CYCLE: 180 PING_EVENT_SECOND_CYCLE: 180 PLAYER_SQL: localhost mt2 mt2!@# player COMMON_SQL: localhost mt2 mt2!@# common LOG_SQL: localhost mt2 mt2!@# log NO_PK: 1 VIEW_RANGE: 6000 CHECK_MULTIHACK: 0 LOCALE_SERVICE: GERMANY MAX_LEVEL: 250 adminpage_ip: 127.0.0.1 adminpage_password: 21279Hdfs432dsfqwa3e2qw4erKBdsaLJHGdsa323weqw FN_log_adminpage: 1 mark_server 1 mark_min_level 1 traffic_profile: 1 empire_whisper: 1 user_limit: 1000 #hackshield_enable: 1 #hackshield_first_check_time: 10 #hackshield_check_cycle_time: 10 speedhack_limit_count: 10 speedhack_limit_bonus: 10 spam_block_duration: 10 spam_block_score: 10 spam_block_reload_cycle: 10 spam_block_max_level: 90 protect_normal_player: 1 TEST_SERVER: 1 global_chat: 1 enable_full_hp: 1 max_gold: 999999999999999 add_bonus_chance: 100 add_bonus_chance5: 100 set_taxes: 0 add_stone_chance: 100 max_level_status: 250 ATTR_RARE_ENABLE: 1 add_accessory_chance: 100 block_player_yangdropp: 0 SKILL_MASTER_UPGRADE: 17 GLASS_NEEDED: 1 command ps: Spoiler root@Metin2:~ # ps PID TT STAT TIME COMMAND 749 u0 Is+ 0:00.00 /usr/libexec/getty std.9600 ttyu0 741 v0 IWs 0:00.00 login [pam] (login) 757 v0 I+ 0:00.03 -csh (csh) 742 v1 Is+ 0:00.00 /usr/libexec/getty Pc ttyv1 743 v2 Is+ 0:00.00 /usr/libexec/getty Pc ttyv2 744 v3 Is+ 0:00.00 /usr/libexec/getty Pc ttyv3 745 v4 Is+ 0:00.00 /usr/libexec/getty Pc ttyv4 746 v5 Is+ 0:00.00 /usr/libexec/getty Pc ttyv5 747 v6 Is+ 0:00.00 /usr/libexec/getty Pc ttyv6 748 v7 Is+ 0:00.00 /usr/libexec/getty Pc ttyv7 6505 0- I 5:32.78 ./database -I 178.62.113.216 (db) 6519 0- I 19:44.74 ./auth -I 178.62.113.216 (game) 6523 0- I 32:41.10 ./channel1_core2 -I 178.62.113.216 (game) 6525 0- I 20:55.82 ./channel1_core3 -I 178.62.113.216 (game) 6527 0- I 21:00.86 ./channel1_core4 -I 178.62.113.216 (game) 6533 0- I 21:21.78 ./channel99_core1 -I 178.62.113.216 (game) 6535 0- I 21:48.96 ./channel99_core2 -I 178.62.113.216 (game) 6540 0- I 19:56.02 ./channel99_core3 -I 178.62.113.216 (game) 6542 0- I 20:44.50 ./channel99_core4 -I 178.62.113.216 (game) 6544 0- I 20:02.86 ./channel99_core5 -I 178.62.113.216 (game) 14508 1 Ss 0:00.04 -csh (csh) 14512 1 R+ 0:00.02 ps Link to comment Share on other sites More sharing options...
Premium Crystal™ 25 Posted July 21, 2016 Premium Share Posted July 21, 2016 All right , post here your serverinfo to take a look and fix it for you bro...I don't think that you've got any problems with your servers , just the ports on your client are incorrect... Link to comment Share on other sites More sharing options...
WhiteHat 5 Posted July 21, 2016 Share Posted July 21, 2016 Your DB says: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Your MySQL.Tar.gz is not meant for your mysql-server you can fix this by use the performance_schema and MySQL DB from the default MySQL folder you get when you install mysql then it will work Just use your account,player,common db. This worked for me. Good luck Click solve when it helped! Link to comment Share on other sites More sharing options...
isaacsousa 5 Posted July 21, 2016 Author Share Posted July 21, 2016 (edited) 2 hours ago, WhiteHat said: Your DB says: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Your MySQL.Tar.gz is not meant for your mysql-server you can fix this by use the performance_schema and MySQL DB from the default MySQL folder you get when you install mysql then it will work Just use your account,player,common db. This worked for me. Good luck Click solve when it helped! https://metin2.download/picture/r3F9504x09DVmF8K988YXgTtGTP6KMUj/.gif Do you know what files on both of those folders (performance_schema and MySQL) change all the passwords? (because the files must have an password, and all the passwords from the account on db are empty. Or do you know how to change the password used by the game? thx 2 hours ago, Crystal™ said: All right , post here your serverinfo to take a look and fix it for you bro...I don't think that you've got any problems with your servers , just the ports on your client are incorrect... serverinfo.py: Spoiler import app app.ServerName = None STATE_NONE = '...' STATE_DICT = { 0 : '....', 1 : 'NORM', 2 : 'BUSY', 3 : 'FULL' } SERVER1_CHANNEL_DICT = { 1:{'key':11,'name':'CH1 ','ip':'*my.ip*6','tcp_port':23070,'udp_port':23070,'state':STATE_NONE,}, # 2:{'key':12,'name':'CH2 ','ip':'*my.ip*','tcp_port':24070,'udp_port':24070,'state':STATE_NONE,}, } REGION_NAME_DICT = { 0 : 'TAIWAN', } REGION_AUTH_SERVER_DICT = { 0 : { 1 : { 'ip':'*my.ip*', 'port':21002, }, } } REGION_DICT = { 0 : { 1 : { 'name' : 'Kori Server', 'channel' : SERVER1_CHANNEL_DICT, }, }, } MARKADDR_DICT = { 10 : { 'ip' : '*my.ip*', 'tcp_port' : 23070, 'mark' : '10.tga', 'symbol_path' : '10', }, } TESTADDR = { 'ip' : '*my.ip*', 'tcp_port' : 50000, 'udp_port' : 50000, } #DONE Edited September 3, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium Crystal™ 25 Posted July 21, 2016 Premium Share Posted July 21, 2016 Did you replace the m_ip with your ip Link to comment Share on other sites More sharing options...
isaacsousa 5 Posted July 21, 2016 Author Share Posted July 21, 2016 2 hours ago, Crystal™ said: Did you replace the m_ip with your ip Yes Link to comment Share on other sites More sharing options...
Active Member ReFresh 2340 Posted July 21, 2016 Active Member Share Posted July 21, 2016 Try to change account table. I'll be always helpful! Link to comment Share on other sites More sharing options...
GTS 1 Posted July 23, 2016 Share Posted July 23, 2016 your table account/player its correct ? Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now