09:23:44.333 [http-nio-80-exec-1] INFO o.a.c.c.C.[.[.[/] - [log,173] - Initializing Spring DispatcherServlet 'dispatcherServlet'
09:23:44.351 [http-nio-80-exec-1] INFO o.a.s.s.m.AbstractValidatingSessionManager - [enableSessionValidation,233] - Enabling session validation scheduler...
09:23:44.351 [http-nio-80-exec-1] DEBUG c.r.f.s.w.s.SpringSessionValidationScheduler - [enableSessionValidation,82] - Scheduling session validation job using Spring Scheduler with session validation interval of [10]ms...
09:23:44.352 [http-nio-80-exec-1] DEBUG c.r.f.s.w.s.SpringSessionValidationScheduler - [enableSessionValidation,104] - Session validation job successfully scheduled with Spring Scheduler.
09:23:44.378 [http-nio-80-exec-1] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [shiro-activeSessionCache]
09:23:44.421 [http-nio-80-exec-2] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-config]
09:23:44.429 [http-nio-80-exec-2] DEBUG c.r.s.m.S.selectConfig - [debug,137] - ==> Preparing: select config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark from sys_config WHERE config_key = ?
09:23:44.429 [http-nio-80-exec-2] DEBUG c.r.s.m.S.selectConfig - [debug,137] - ==> Parameters: sys.account.registerUser(String)
09:23:44.432 [http-nio-80-exec-2] DEBUG c.r.s.m.S.selectConfig - [debug,137] - <== Total: 0
09:23:45.354 [schedule-pool-1] INFO c.r.f.s.w.s.OnlineWebSessionManager - [validateSessions,100] - invalidation sessions...
09:23:45.355 [schedule-pool-1] DEBUG c.r.s.m.S.selectOnlineByExpired - [debug,137] - ==> Preparing: select sessionId, login_name, dept_name, ipaddr, login_location, browser, os, status, start_timestamp, last_access_time, expire_time from sys_user_online o WHERE o.last_access_time <= ? ORDER BY o.last_access_time ASC
09:23:45.360 [schedule-pool-1] DEBUG c.r.s.m.S.selectOnlineByExpired - [debug,137] - ==> Parameters: 2023-03-05 08:53:45(String)
09:23:45.362 [schedule-pool-1] DEBUG c.r.s.m.S.selectOnlineByExpired - [debug,137] - <== Total: 0
09:23:45.363 [schedule-pool-1] INFO c.r.f.s.w.s.OnlineWebSessionManager - [validateSessions,165] - Finished invalidation session. No sessions were stopped.
09:23:55.528 [http-nio-80-exec-34] INFO o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-config]
09:23:55.528 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectConfig - [debug,137] - ==> Preparing: select config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark from sys_config WHERE config_key = ?
09:23:55.529 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectConfig - [debug,137] - ==> Parameters: sys.login.blackIPList(String)
09:23:55.531 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectConfig - [debug,137] - <== Total: 0
09:23:55.539 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectUserByLoginName - [debug,137] - ==> Preparing: select u.user_id, u.dept_id, u.login_name, u.user_name, u.user_type, u.email, u.avatar, u.phonenumber, u.sex, u.password, u.salt, u.status, u.del_flag, u.login_ip, u.login_date, u.pwd_update_date, u.create_time, u.remark, d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.status as dept_status, r.role_id, r.role_name, r.role_key, r.role_sort, r.data_scope, r.status as role_status from sys_user u left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id where u.login_name = ? and u.del_flag = '0'
09:23:55.545 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectUserByLoginName - [debug,137] - ==> Parameters: admin(String)
09:23:55.552 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectUserByLoginName - [debug,137] - <== Total: 0
09:23:55.574 [schedule-pool-2] INFO sys-user - [run,109] - [127.0.0.1]内网IP[admin][Error][用户不存在/密码错误]
09:23:55.576 [schedule-pool-2] DEBUG c.r.s.m.S.insertLogininfor - [debug,137] - ==> Preparing: insert into sys_logininfor (login_name, status, ipaddr, login_location, browser, os, msg, login_time) values (?, ?, ?, ?, ?, ?, ?, sysdate())
09:23:55.591 [schedule-pool-2] DEBUG c.r.s.m.S.insertLogininfor - [debug,137] - ==> Parameters: admin(String), 1(String), 127.0.0.1(String), 内网IP(String), Chrome 11(String), Windows 10(String), 用户不存在/密码错误(String)
09:23:55.651 [schedule-pool-2] ERROR c.r.c.utils.Threads - [printException,96] -
### Error updating database. Cause: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
### The error may exist in file [C:\Users\admin\Desktop\RuoYi-master\ruoyi-system\target\classes\mapper\system\SysLogininforMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysLogininforMapper.insertLogininfor-Inline
### The error occurred while setting parameters
### SQL: insert into sys_logininfor (login_name, status, ipaddr, login_location, browser, os, msg, login_time) values (?, ?, ?, ?, ?, ?, ?, sysdate())
### Cause: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
### The error may exist in file [C:\Users\admin\Desktop\RuoYi-master\ruoyi-system\target\classes\mapper\system\SysLogininforMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysLogininforMapper.insertLogininfor-Inline
### The error occurred while setting parameters
### SQL: insert into sys_logininfor (login_name, status, ipaddr, login_location, browser, os, msg, login_time) values (?, ?, ?, ?, ?, ?, ?, sysdate())
### Cause: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy84.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
at com.sun.proxy.$Proxy110.insertLogininfor(Unknown Source)
at com.ruoyi.system.service.impl.SysLogininforServiceImpl.insertLogininfor(SysLogininforServiceImpl.java:31)
at com.ruoyi.framework.manager.factory.AsyncFactory$3.run(AsyncFactory.java:132)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
at com.sun.proxy.$Proxy98.execute(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
at com.sun.proxy.$Proxy163.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
... 15 common frames omitted
检查下你的数据编码是不是utf8
1、检查数据库是否导入，查看user表是否有用户
2、检查配置文件中的数据库表名以及账号密码是否跟本地的一样
3、检查redis是否启动
4、抓请求在后端对应的控制类打断点调试