Connector Login Fail
#1

Hi,
The Connector shows this error every time I want to enter in Server :

- LOGIN_FAIL > tester : From : 1 : 1
- SYS_ERR > tester : From : 1 : Not Found User

Also the GameServer shows this error :

- LOGIN REQ > tester : VERSION : 20140731 : MODE : 0 : IP : 192.168.1.35 : NATION : 9 : PROSITE :
- CONN_ERR > tester : CONNECTOR SYSTEM error

And client shows "Timed Out" (I use this 2 with these 2)  :

 

 

I'm using the EP4 Server Files compiled for Windows, if this can help!

 

Sorry for my bad english, and Thank you very much in advance!

#2
look game server, connector, login server, that help Wink

#3
Thanks for you reply, but only Connector and GameServer shows that error, the others one acts normally.

#4
you need look the error in the correctly table, for that look Connector and Game Server, when they tell you where are the error [i am sure is in a table] then clic secondary and empty table Wink

#5

I checked the logs file, but I couldn't see any error related to users table (only npc and catalog error), but now I've seen that every time I get "Timed out", the Gameserver decreases my user_id :

- LOGIN REQ > tester : VERSION : 20140731 : MODE : 0 : IP : 192.168.1.35 : NATION : 9 : PROSITE :
- CONN_ERR > tester : CONNECTOR SYSTEM error
- bnf manual close - ip : 192.168.1.35 : unique id : 0000000009 : reason : Login check fail from connect server
- bnf closed - ip : 192.168.1.35 : unique id : 0000000009
- TOTAL CONNECTION TIME : userIndex : -1 userId : tester time : 2015-07-08 18:27:03 - 2015-07-08 18:27:03 total_sec : 0 sec
- send logout msg to Connector : user_index[-1] id[tester]

#6
Look connecto there u got the error

#7
Is your login an connector config correct ? Please post it, so we can see if there is a problem.

#8

user index -1 cant found, how looks your bg_user ? and your t_user?

 

 

 

Code Snipp of the Error, so the user cant found, the user will be load from the gserver userlist with the subno so i think database problem

#9
In my database column user_code in bg_user is unsigned, so I wonder how the code can be -1  Huh

#10

In my database column user_code in bg_user is unsigned, so I wonder how the code can be -1  Huh

 

 

user index -1 cant found, how looks your bg_user ? and your t_user?

 

 

 

Code Snipp of the Error, so the user cant found, the user will be load from the gserver userlist with the subno so i think database problem

 

bg_user :

+-----------+---------+------------+--------+------------+-------+-------------+------------+---------------+---------------------+---------------------+-------+------+---------+------+----------+--------+------+------+-------+----------+---------------+----------+------+------------+----------+------------+------------+
| user_code | user_id | truepasswd | passwd | chk_tester | jumin | chk_service | partner_id | active_passwd | active_time | create_date | email | ip | hashigh | send | question | answer | cash | team | refby | cashused | cashtotalused | event_id | tier | write_time | used_all | enc_jumin1 | enc_jumin3 |
+-----------+---------+------------+--------+------------+-------+-------------+------------+---------------+---------------------+---------------------+-------+------+---------+------+----------+--------+------+------+-------+----------+---------------+----------+------+------------+----------+------------+------------+
| 0 | tester | tester | tester | N | 0 | Y | LC | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NULL | NULL | NULL | 0 | NULL | NULL | 0 | 0 | NULL | 0 | 0 | 1 | 0 | NULL | NULL | NULL | NULL |
+-----------+---------+------------+--------+------------+-------+-------------+------------+---------------+---------------------+---------------------+-------+------+---------+------+----------+--------+------+------+-------+----------+---------------+----------+------+------------+----------+------------+------------+

t_users :

+---------+----------+----------+----------------+---------------------+---------------------+----------+--------------+----------+------------+-------------+---------------+--------------+------------------+----------------+----------------+------------------+---------------+--------------+-----------+----------+----------+---------+--------------+--------------+
| a_index | a_idname | a_passwd | a_portal_index | a_regi_date | a_end_date | a_enable | a_server_num | a_subnum | a_zone_num | a_timestamp | a_preopen_chk | a_eventpoint | a_eventpoint_use | a_stash_passwd | a_stash_sealed | a_stash_password | a_pcbang_time | a_login_time | a_restart | bancount | banreson | bantime | a_block_time | a_fail_count |
+---------+----------+----------+----------------+---------------------+---------------------+----------+--------------+----------+------------+-------------+---------------+--------------+------------------+----------------+----------------+------------------+---------------+--------------+-----------+----------+----------+---------+--------------+--------------+
| 0 | tester | tester | 2 | 2015-01-17 18:05:46 | 2015-01-20 01:01:07 | 1 | 1 | 1 | -1 | 1421544419 | 0 | 10 | 0 | | 0 | | 0 | 0 | 0 | 0 | | 0 | 0 | 0 |
+---------+----------+----------+----------------+---------------------+---------------------+----------+--------------+----------+------------+-------------+---------------+--------------+------------------+----------------+----------------+------------------+---------------+--------------+-----------+----------+----------+---------+--------------+--------------+

Is your login an connector config correct ? Please post it, so we can see if there is a problem.

Connector :

 

;-------------------------------------------------------------------------

; SERVER CONFIG

;-------------------------------------------------------------------------

[server]

Number=1

MaxSubServer=1

IP=127.0.0.1

Port=4006

HARDCORE=FALE

 

;-------------------------------------------------------------------------

; DATA CONFIG

;-------------------------------------------------------------------------

[user DB]

IP=localhost

DBName=newproject_db_auth

User=root

Password=

 

[Auth DB]

IP=localhost

DBName=newproject_db_auth

User=root

Password=

 

 

[Event DB]

IP=localhost

DBName=newproject_db_auth

User=root

Password=

 

;-------------------------------------------------------------------------

; BILLING CONNECTION

;-------------------------------------------------------------------------

[billing Server]

IP=127.0.0.1

Port=2072

 

 

 

LoginServer :

 

;-------------------------------------------------------------------------

;                            SERVER CONFIG

;-------------------------------------------------------------------------

[server]

No=1

IP=192.168.1.35

Port=4001

AllowExternalIP=TRUE

 

[GM ID]

egbs=1

 

;-------------------------------------------------------------------------

;                            DATA CONFIG

;-------------------------------------------------------------------------

[user DB]

IP=localhost

DBName=newproject_db

User=root

Password=

 

 

[Data DB]

IP=localhost

DBName=newproject_data

User=root

Password=

 

 

[Auth DB]

IP=localhost

DBName=newproject_db_auth

User=root

Password=

 

;-------------------------------------------------------------------------

;                            SERVER CONNECTION

;-------------------------------------------------------------------------

[Messenger Server]

IP=127.0.0.1

Port=4000

 

[Connector Server]

Count=1

 

[Connector_0]

Number=1

MaxSubNumber=1

IP=127.0.0.1

Port=4006

 

[Connector_1]

Number=1

MaxSubNumber=1

IP=127.0.0.1

Port=4016

 

;-------------------------------------------------------------------------

;                                IP CONFIG

;-------------------------------------------------------------------------

[block IP]

Number=0

 

[block Band]

Number=0

Band0=A-211.094.000.000-211.103.255.255

 

[Auto Block]

Refresh=2

MaxTry=5

ExIP61.104.44.146=1

 

 

[block ExID]

ExIDckh386=1

 

 

 

Thanks in advance Big Grin !



Forum Jump:


Users browsing this thread: 1 Guest(s)