+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep4 Support (https://lckb.dev/forum/forumdisplay.php?fid=128)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=158)
+------ Thread: Connector Login Fail (/showthread.php?tid=2561)
Pages:
1
2
- AdiH97 - 07-08-2015
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!
- kravens - 07-08-2015
look game server, connector, login server, that help
- AdiH97 - 07-08-2015
Thanks for you reply, but only Connector and GameServer shows that error, the others one acts normally.
- kravens - 07-08-2015
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
- AdiH97 - 07-08-2015
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]
- kravens - 07-08-2015
Look connecto there u got the error
- Inhale - 07-08-2015
Is your login an connector config correct ? Please post it, so we can see if there is a problem.
- DamonA - 07-08-2015
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
- Inhale - 07-08-2015
In my database column user_code in bg_user is unsigned, so I wonder how the code can be -1
- AdiH97 - 07-08-2015
In my database column user_code in bg_user is unsigned, so I wonder how the code can be -1
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
!