Jump to content

isaacsousa

Inactive Member
 View Profile  See their activity

  • Posts

    8

  • Joined

  • Last visited

  • Feedback

    0%

 Content Type 

Forums

Store

Third Party - Providers Directory

Feature Plan

Release Notes

Docs

Events

Posts posted by isaacsousa

    Connection fail when I put the right user/pass

    in Community Support - Questions & Answers

    Posted · Edited by Metin2 Dev
    Core X - External 2 Internal

    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
     

     

    How to make metin2dev dance

    in Off Topic

    Posted

    Press F12, go console and enter this:

     

    Spoiler

    javascript:(function(){function c(){var e=document.createElement("link");e.setAttribute("type","text/css");e.setAttribute("rel","stylesheet");e.setAttribute("href",f);e.setAttribute("class",l);document.body.appendChild(e)}function h(){var e=document.getElementsByClassName(l);for(var t=0;t<e.length;t++){document.body.removeChild(e[t])}}function p(){var e=document.createElement("div");e.setAttribute("class",a);document.body.appendChild(e);setTimeout(function(){document.body.removeChild(e)},100)}function d(e){return{height:e.offsetHeight,width:e.offsetWidth}}function v(i){var s=d(i);return s.height>e&&s.height<n&&s.width>t&&s.width<r}function m(e){var t=e;var n=0;while(!!t){n+=t.offsetTop;t=t.offsetParent}return n}function g(){var e=document.documentElement;if(!!window.innerWidth){return window.innerHeight}else if(e&&!isNaN(e.clientHeight)){return e.clientHeight}return 0}function y(){if(window.pageYOffset){return window.pageYOffset}return Math.max(document.documentElement.scrollTop,document.body.scrollTop)}function E(e){var t=m(e);return t>=w&&t<=b+w}function S(){var e=document.createElement("audio");e.setAttribute("class",l);e.src=i;e.loop=false;e.addEventListener("canplay",function(){setTimeout(function(){x(k)},500);setTimeout(function(){N();p();for(var e=0;e<O.length;e++){T(O[e])}},15500)},true);e.addEventListener("ended",function(){N();h()},true);e.innerHTML=" <p>If you are reading this, it is because your browser does not support the audio element. We recommend that you get a new browser.</p> <p>";document.body.appendChild(e);e.play()}function x(e){e.className+=" "+s+" "+o}function T(e){e.className+=" "+s+" "+u[Math.floor(Math.random()*u.length)]}function N(){var e=document.getElementsByClassName(s);var t=new RegExp("\\b"+s+"\\b");for(var n=0;n<e.length;){e[n].className=e[n].className.replace(t,"")}}var e=30;var t=30;var n=350;var r=350;var i="//s3.amazonaws.com/moovweb-marketing/playground/harlem-shake.mp3";var s="mw-harlem_shake_me";var o="im_first";var u=["im_drunk","im_baked","im_trippin","im_blown"];var a="mw-strobe_light";var f="//s3.amazonaws.com/moovweb-marketing/playground/harlem-shake-style.css";var l="mw_added_css";var b=g();var w=y();var C=document.getElementsByTagName("*");var k=null;for(var L=0;L<C.length;L++){var A=C[L];if(v(A)){if(E(A)){k=A;break}}}if(A===null){console.warn("Could not find a node of the right size. Please try a different page.");return}c();S();var O=[];for(var L=0;L<C.length;L++){var A=C[L];if(v(A)){O.push(A)}}})()

     

    :D

     

    • Lmao 1
    • Good 1
    • Love 4

    Connection fail when I put the right user/pass

    in Community Support - Questions & Answers

    Posted

    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
     

     

    Connection fail when I put the right user/pass

    in Community Support - Questions & Answers

    Posted

    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... 

    Connection fail when I put the right user/pass

    in Community Support - Questions & Answers

    Posted

    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

    Connection fail when I put the right user/pass

    in Community Support - Questions & Answers

    Posted · Edited by Metin2 Dev
    Core X - External 2 Internal

    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

    cd9bf724ee3c4529a6c39f712a214626.png

    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

    f59b861c69744327b5b367888395422c.png

    As you can see, it warns me that my ID or password are wrong...

    But If I put both ID and password correctly:

    Spoiler

    f843cf17604240fd87fabacdb45ebb7f.png

    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 :mellow:

     

     

     

×
×
  • Create New...

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.