Timed out on client.

[Hanji]

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]

Empty the t_user table and bg_user.

[Scura]

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