search

HackAllSec / XuanQiong

XuanQiong（玄穹），一款高性能的开源漏洞库平台，中小型团队自建漏洞库的合适之选。支持漏洞提交、漏洞审核、漏洞搜索、漏洞排行榜、消息推送等功能。
https://demo.hackall.cn
Apache License 2.0
30 stars 1 forks source link

无法登录，账户被锁定 #2

Closed FeiNiao closed 3 days ago

FeiNiao commented 1 week ago

image

使用windows-amd64 版本的配置完mysql启动后，使用cmd提供的admin和密码登录显示账户被锁定无法登录

NHPT commented 4 days ago

默认错误5次会锁定IP，去数据库删除锁定IP就好了

FeiNiao commented 4 days ago

image

您好，上面的问题并未解决，我尝试了在数据库中查找IP，但没有找到，尝试用注册功能去进去，也是不行，数据库中除了注册的时候获取验证码产生的code数据，其他的并没有数据，如用户名密码，锁定的IP image

NHPT commented 4 days ago

xq_lockips这个表里边，注册功能默认也是不开启的

FeiNiao commented 4 days ago

image 很抱歉，xq_lockips表中无任何数据，我还是登录不上去

NHPT commented 4 days ago

我试了下没问题，没复现出来你这个问题，你可以重新安装试试

din4e commented 3 days ago

我也遇到相同问题，xq_user 表也是空的。 image

NHPT commented 3 days ago

数据库是啥版本，执行的日志看看

din4e commented 3 days ago

数据库是啥版本，执行的日志看看

docker 启动的 mysql:8.0。


2024/11/22 14:32:25 /root/XuanQiong/backend/models/dbo.go:54
[error] failed to initialize database, got error dial tcp [::1]:3306: connect: connection refused

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:69 Error 1146 (42S02): Table 'dbname.xq_users' doesn't exist
[3.920ms] [rows:-] SELECT * FROM xq_users WHERE username = 'admin'

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:77 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[2.033ms] [rows:0] INSERT INTO `xq_system_configs` (`user_register`,`user_display`,`max_attempts`,`lockout_duration`,`create_time`,`update_time`) VALUES (false,'佚名',5,3600,'2024-11-22 14:37:08.715','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:81 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.425ms] [rows:0] INSERT INTO `xq_jwt_configs` (`jwt_secret`,`jwt_expires`,`create_time`,`update_time`) VALUES ('-eMoKJTSp9V2HxH8eimfv7D7a4JHaNCZDs7685r6uYk=',3600,'2024-11-22 14:37:08.72','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:85 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.388ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('信息泄露','2024-11-22 14:37:08.723','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:86 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.264ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('远程代码执行','2024-11-22 14:37:08.725','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:87 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.198ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('反序列化','2024-11-22 14:37:08.726','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:88 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.573ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('SQL注入','2024-11-22 14:37:08.727','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:89 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.156ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('命令注入','2024-11-22 14:37:08.729','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:90 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.469ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('跨站脚本攻击','2024-11-22 14:37:08.73','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:91 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.405ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('本地文件包含','2024-11-22 14:37:08.732','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:92 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[2.023ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('远程文件包含','2024-11-22 14:37:08.733','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:93 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.345ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('跨站请求伪造','2024-11-22 14:37:08.736','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:94 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.216ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('服务器端请求伪造','2024-11-22 14:37:08.737','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:95 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.569ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('任意文件上传','2024-11-22 14:37:08.739','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:96 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[2.114ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('任意文件读取/下载','2024-11-22 14:37:08.74','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:97 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.427ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('拒绝服务','2024-11-22 14:37:08.742','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:98 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.412ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('权限提升','2024-11-22 14:37:08.744','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:99 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.177ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('暴力破解','2024-11-22 14:37:08.745','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.227ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('弱口令','2024-11-22 14:37:08.747','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:101 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.153ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('XML外部实体注入','2024-11-22 14:37:08.748','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:102 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.275ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('未授权访问','2024-11-22 14:37:08.749','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:103 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.211ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('水平越权','2024-11-22 14:37:08.75','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:104 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.067ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('垂直越权','2024-11-22 14:37:08.752','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:105 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.207ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('登录绕过','2024-11-22 14:37:08.753','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:106 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.087ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('任意密码重置','2024-11-22 14:37:08.754','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:107 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.219ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('负值反冲','2024-11-22 14:37:08.755','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:108 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.113ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('短信轰炸','2024-11-22 14:37:08.757','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:109 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.044ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('邮件轰炸','2024-11-22 14:37:08.758','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:110 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.958ms] [rows:0] INSERT INTO `xq_vuln_types` (`name`,`create_time`,`update_time`) VALUES ('其他','2024-11-22 14:37:08.759','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:114 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.163ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (1,'Xray、Nuclei、Goby等完整Poc，误报低',20,1,'2024-11-22 14:37:08.762','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:115 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.195ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (1,'Xray、Nuclei、Goby等完整Poc，误报较高',10,1,'2024-11-22 14:37:08.763','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:116 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.920ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (1,'仅包含Payload或无法工具化的Poc',5,1,'2024-11-22 14:37:08.765','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:117 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.944ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (2,'Xray、Nuclei、Goby等完整Exp，误报低',30,1,'2024-11-22 14:37:08.766','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:118 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.998ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (2,'Xray、Nuclei、Goby等完整Exp，误报较高',15,1,'2024-11-22 14:37:08.767','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:119 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.022ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (2,'仅包含Payload或无法工具化的Exp',5,1,'2024-11-22 14:37:08.768','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:120 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.877ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (3,'互联网资产数大于 5000',30,1,'2024-11-22 14:37:08.769','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:121 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.915ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (3,'互联网资产数介于 1000 到 5000',20,1,'2024-11-22 14:37:08.77','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/dbo.go:122 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.990ms] [rows:0] INSERT INTO `xq_score_rules` (`type`,`rule`,`score`,`coefficient`,`create_time`,`update_time`) VALUES (3,'互联网资产数小于 1000',10,1,'2024-11-22 14:37:08.771','0000-00-00 00:00:00')

2024/11/22 14:37:08 /root/XuanQiong/backend/models/users.go:94 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.505ms] [rows:0] INSERT INTO `xq_users` (`username`,`password`,`avatar`,`email`,`phone`,`ranking`,`role`,`status`,`token`,`create_time`,`update_time`) VALUES ('admin','$2a$10$Ku/8vo6mAHGcEaOlnGIl/.Qil9EFj1zbSBH8jrHE0VkYpeyFHtxya','','','',0,1,1,'','2024-11-22 14:37:08.857','0000-00-00 00:00:00')

2024/11/22 14:38:37 /root/XuanQiong/backend/models/users.go:94 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.949ms] [rows:0] INSERT INTO `xq_users` (`username`,`password`,`avatar`,`email`,`phone`,`ranking`,`role`,`status`,`token`,`create_time`,`update_time`) VALUES ('admin','$2a$10$dp.6JIAFlxncWIBq1YeDau5giQH8OE8cyRjU2HtzPh7p5xZq23Pk6','','','',0,1,1,'','2024-11-22 14:38:37.473','0000-00-00 00:00:00')

2024/11/22 14:38:47 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.947ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('211.90.238.142','2024-11-22 14:38:47.996',1,'2024-11-22 14:38:47.996','0000-00-00 00:00:00')

2024/11/22 14:38:54 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.028ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('211.90.238.142','2024-11-22 14:38:54.583',1,'2024-11-22 14:38:54.583','0000-00-00 00:00:00')

2024/11/22 14:39:11 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.042ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('211.90.238.142','2024-11-22 14:39:11.33',1,'2024-11-22 14:39:11.33','0000-00-00 00:00:00')

2024/11/22 14:48:27 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.138ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('45.15.9.122','2024-11-22 14:48:27.109',1,'2024-11-22 14:48:27.109','0000-00-00 00:00:00')

2024/11/22 14:52:22 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.161ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('45.15.9.122','2024-11-22 14:52:22.624',1,'2024-11-22 14:52:22.624','0000-00-00 00:00:00')

2024/11/22 14:53:39 /root/XuanQiong/backend/models/users.go:94 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[2.419ms] [rows:0] INSERT INTO `xq_users` (`username`,`password`,`avatar`,`email`,`phone`,`ranking`,`role`,`status`,`token`,`create_time`,`update_time`) VALUES ('admin','$2a$10$LP8iVv4C8MZ/7YIFooDV/eobVHTp4ZXH.dkNa.ysZFqUw34dG.wXi','','','',0,1,1,'','2024-11-22 14:53:39.526','0000-00-00 00:00:00')

2024/11/22 14:54:41 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.921ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('','2024-11-22 14:54:41.713',1,'2024-11-22 14:54:41.713','0000-00-00 00:00:00')

2024/11/22 14:56:14 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.106ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('','2024-11-22 14:56:14.736',1,'2024-11-22 14:56:14.736','0000-00-00 00:00:00')

2024/11/25 08:35:05 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[2.742ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('','2024-11-25 08:35:05.94',1,'2024-11-25 08:35:05.94','0000-00-00 00:00:00')

2024/11/25 09:36:05 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[1.195ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('','2024-11-25 09:36:05.947',1,'2024-11-25 09:36:05.947','0000-00-00 00:00:00')

2024/11/25 09:36:13 /root/XuanQiong/backend/models/sysconfig.go:100 Error 1292 (22007): Incorrect datetime value: '0000-00-00' for column 'update_time' at row 1
[0.958ms] [rows:0] INSERT INTO `xq_lockips` (`client_ip`,`lockout_until`,`status`,`create_time`,`update_time`) VALUES ('','2024-11-25 09:36:13.135',1,'2024-11-25 09:36:13.135','0000-00-00 00:00:00')
NHPT commented 3 days ago

试了下 mysql 8.x确实没数据

jibaoman commented 3 days ago

mysql 5.7也有相同的问题： mysql> show tables; +---------------------+ | Tables_in_xuanqiong | +---------------------+ | xq_attachments | | xq_email_configs | | xq_jwt_configs | | xq_lockips | | xq_notice_configs | | xq_ranking_details | | xq_score_rules | | xq_system_configs | | xq_users | | xq_verify_codes | | xq_vuln_types | | xq_vulnerabilities | +---------------------+ 12 rows in set (0.00 sec)

mysql> select * from xq_lockips; Empty set (0.00 sec) ![Uploading mysql-lock.png…]()

jibaoman commented 3 days ago

部署完后默认的管理员用户密码是什么？ admin/Admin@123提示被锁定。

NHPT commented 3 days ago

密码随机生成，运行的终端有输出

jibaoman commented 3 days ago

也是提示被锁定，数据库使用的是5.7.44，查了xq_lockips表是空的； mysql> select * from xq_lockips; Empty set (0.00 sec)

NHPT commented 3 days ago

删了数据库重新运行下试试吧 我用宝塔的5.7.44没出现任何问题，其它版本的我再测试一下

jibaoman commented 3 days ago

重新建库也是一样的错误。

NHPT commented 3 days ago

你用的也是docker版的mysql？

sqws651515 commented 2 days ago

你用的也是docker版的mysql？

docker版本 MySQL

NHPT commented 2 days ago

问题解决了 1.0.8应该不会有问题了

sqws651515 commented 2 days ago

问题解决了 1.0.8应该不会有问题了

好的 我测试一下。