Jump to content

Connection fail when I put the right user/pass

isaacsousa
 Share

Recommended Posts

isaacsousa Rookie

isaacsousa 5

Posted
Posted (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

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:

 

 

 

Edited by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites
  • Replies 17
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

isaacsousa Rookie

isaacsousa 5

Posted
  • Author
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

Link to comment
Share on other sites
  • Premium
FlorinMarian Proficient

FlorinMarian 122

Posted
  • Premium
Posted
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)

C041cab.gif

 

Shared Hosting | Domain names | Dedicated Servers | VPS ⭐ HAZI.ro

 

Link to comment
Share on other sites
isaacsousa Rookie

isaacsousa 5

Posted
  • Author
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... 

Link to comment
Share on other sites
isaacsousa Rookie

isaacsousa 5

Posted
  • Author
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
 

 

Link to comment
Share on other sites
WhiteHat Apprentice

WhiteHat 5

Posted
Posted

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
isaacsousa Rookie

isaacsousa 5

Posted
  • Author
Posted (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 by Metin2 Dev
Core X - External 2 Internal
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing

Announcements



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