+- 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)
+----- Thread: Timed out on client. (/showthread.php?tid=4731)
- Hanji - 05-12-2021
Hello, when I try to log into the client (server compiled and running) I get timed out.
This is the GS log file which I believe is the problem.
Also the connector log which says
2021-05-11 21:47:31,769 INFO [ Log.cpp : 86] - LOGIN_FAIL > test : From : 1 : 2
2021-05-11 21:47:31,770 INFO [ Log.cpp : 86] - SYS_ERR > test : From : 1 : Not Found User
2021-05-11 21:47:34,200 INFO [ Log.cpp : 86] - LOGIN_FAIL > test : From : 1 : 2
2021-05-11 21:47:34,201 INFO [ Log.cpp : 86] - SYS_ERR > test : From : 1 : Not Found User
2021-05-11 21:47:52,178 ERROR [ DBCmd.cpp : 113] - query error (mysql_real_query) : error[The user specified as a definer ('root'@'%') does not exist] query[UPDATE t_users SET a_end_date=NOW(), a_server_num = 1, a_subnum = 1, a_zone_num = 0, a_timestamp = a_timestamp + 0 WHERE a_portal_index = 1 AND a_zone_num=-1]
2021-05-11 21:47:52,178 INFO [ Log.cpp : 86] - LOGIN_FAIL > test : From : 1 : 1
2021-05-11 21:47:52,179 INFO [ Log.cpp : 86] - SYS_ERR > test : From : 1 : Not Found User
2021-05-11 21:47:54,824 INFO [ Log.cpp : 86] - LOGIN_FAIL > test : From : 1 : 3
2021-05-11 21:47:54,825 INFO [ Log.cpp : 86] - SYS_ERR > test : From : 1 : Not Found User
Can someone help me with this?
22
- cristiangramosa - 05-12-2021
Empty the t_user table and bg_user.
- Scura - 05-12-2021
4 hours ago, Hanji said:
Hello, when I try to log into the client (server compiled and running) I get timed out.
This is the GS log file which I believe is the problem.
Also the connector log which says
2021-05-11 21:47:31,769 INFO [ Log.cpp : 86] - LOGIN_FAIL > test : From : 1 : 2
2021-05-11 21:47:31,770 INFO [ Log.cpp : 86] - SYS_ERR > test : From : 1 : Not Found User
2021-05-11 21:47:34,200 INFO [ Log.cpp : 86] - LOGIN_FAIL > test : From : 1 : 2
2021-05-11 21:47:34,201 INFO [ Log.cpp : 86] - SYS_ERR > test : From : 1 : Not Found User
2021-05-11 21:47:52,178 ERROR [ DBCmd.cpp : 113] - query error (mysql_real_query) : error[The user specified as a definer ('root'@'%') does not exist] query[UPDATE t_users SET a_end_date=NOW(), a_server_num = 1, a_subnum = 1, a_zone_num = 0, a_timestamp = a_timestamp + 0 WHERE a_portal_index = 1 AND a_zone_num=-1]
2021-05-11 21:47:52,178 INFO [ Log.cpp : 86] - LOGIN_FAIL > test : From : 1 : 1
2021-05-11 21:47:52,179 INFO [ Log.cpp : 86] - SYS_ERR > test : From : 1 : Not Found User
2021-05-11 21:47:54,824 INFO [ Log.cpp : 86] - LOGIN_FAIL > test : From : 1 : 3
2021-05-11 21:47:54,825 INFO [ Log.cpp : 86] - SYS_ERR > test : From : 1 : Not Found User
Can someone help me with this?
22
Seems you have some problem with mysql root user ... suggest you to create a new user ... but if the root user doesn't work .... maybe you have some error with mysql connection ... which kind of OS are you using? What about the mysql services version??