Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

在BC端使用时Q群内发消息会导致控制台报错且不转发消息 #69

Open
2 tasks done
CUX-LI opened this issue Jan 20, 2023 · 8 comments
Open
2 tasks done

在BC端使用时Q群内发消息会导致控制台报错且不转发消息 #69

CUX-LI opened this issue Jan 20, 2023 · 8 comments
Labels
漏洞 某些东西爆炸了

Comments

@CUX-LI
Copy link

CUX-LI commented Jan 20, 2023 •
edited

问题描述

将Chat2QQ直接拖进插件文件夹然后简单修改机器人账号和群这些然后启动服务端不行，尝试开启世界黑名单功能也不行，关掉前缀词检测还是一样报错，转发功能虽然失效，但玩家进退服务器时群内正常输出消息；群内输入任意消息（无论带不带前缀）均会报错,将Chat2QQ删掉后群内消息就可以正常显示在控制台且不会报错。

复现方法

1.配置文件内填写好机器人账号和群号之后直接启动就可以复现

服务端类型

BungeeCord

服务端版本

git-Purpur-1760 (MC: 1.19.2)* || git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT

MiraiMC 插件版本

1.7.1

Chat2QQ 插件版本

1,6

服务端日志

[03:26:48] [main/INFO]: Using standard Java JCE cipher.
[03:26:48] [main/INFO]: Using standard Java compressor.
[03:26:48] [main/INFO]: Enabled Waterfall version git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507
[03:26:48] [main/INFO]: Discovered module: ModuleSpec(name=cmd_alert, file=modules\cmd_alert.jar, provider=JenkinsModuleSource())
[03:26:48] [main/INFO]: Discovered module: ModuleSpec(name=cmd_find, file=modules\cmd_find.jar, provider=JenkinsModuleSource())
[03:26:48] [main/INFO]: Discovered module: ModuleSpec(name=cmd_list, file=modules\cmd_list.jar, provider=JenkinsModuleSource())
[03:26:48] [main/INFO]: Discovered module: ModuleSpec(name=cmd_send, file=modules\cmd_send.jar, provider=JenkinsModuleSource())
[03:26:48] [main/INFO]: Discovered module: ModuleSpec(name=cmd_server, file=modules\cmd_server.jar, provider=JenkinsModuleSource())
[03:26:48] [main/INFO]: Discovered module: ModuleSpec(name=reconnect_yaml, file=modules\reconnect_yaml.jar, provider=JenkinsModuleSource())
[03:26:48] [main/INFO]: Loaded plugin MiniMOTD version 2.0.9 by jmp
[03:26:48] [main/INFO]: Loaded plugin reconnect_yaml version git:reconnect_yaml:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:49] [main/INFO]: Loaded plugin LuckPerms version 5.4.52 by Luck
[03:26:49] [main/INFO]: Loaded plugin AllMusic version 2.18.0 by Color_yr
[03:26:49] [main/INFO]: Loading library org.jetbrains.kotlin:kotlin-stdlib-common:1.5.31
[03:26:49] [main/INFO]: Loading library org.jetbrains.kotlin:kotlin-stdlib:1.5.31
[03:26:49] [main/INFO]: Loading library org.jetbrains:annotations:13.0
[03:26:49] [main/INFO]: Loading library org.jetbrains.kotlin:kotlin-stdlib-jdk7:1.5.31
[03:26:49] [main/INFO]: Loading library org.jetbrains.kotlin:kotlin-stdlib-jdk8:1.5.31
[03:26:49] [ForkJoinPool.commonPool-worker-9/INFO]: Loading library org.apache.commons:commons-jexl3:3.2.1
[03:26:49] [ForkJoinPool.commonPool-worker-10/INFO]: Loading library org.yaml:snakeyaml:1.32
[03:26:49] [ForkJoinPool.commonPool-worker-9/INFO]: Loading library com.mojang:datafixerupper:4.0.26
[03:26:49] [ForkJoinPool.commonPool-worker-10/INFO]: Loading library com.typesafe:config:1.4.2
[03:26:49] [ForkJoinPool.commonPool-worker-10/INFO]: Loading library com.electronwill.night-config:core:3.6.6
[03:26:49] [ForkJoinPool.commonPool-worker-5/INFO]: Loading library redis.clients:jedis:4.2.3
[03:26:49] [ForkJoinPool.commonPool-worker-10/INFO]: Loading library com.electronwill.night-config:toml:3.6.6
[03:26:49] [ForkJoinPool.commonPool-worker-5/INFO]: Loading library org.apache.commons:commons-pool2:2.11.1
[03:26:49] [ForkJoinPool.commonPool-worker-10/INFO]: Loading library com.electronwill.night-config:json:3.6.6
[03:26:49] [ForkJoinPool.commonPool-worker-5/INFO]: Loading library org.json:json:20211205
[03:26:49] [ForkJoinPool.commonPool-worker-10/INFO]: Loading library com.electronwill.night-config:hocon:3.6.6
[03:26:49] [ForkJoinPool.commonPool-worker-14/INFO]: Loading library org.openjdk.nashorn:nashorn-core:15.3
[03:26:49] [ForkJoinPool.commonPool-worker-14/INFO]: Loading library org.ow2.asm:asm-commons:7.3.1
[03:26:49] [ForkJoinPool.commonPool-worker-14/INFO]: Loading library org.ow2.asm:asm-tree:7.3.1
[03:26:49] [ForkJoinPool.commonPool-worker-14/INFO]: Loading library org.ow2.asm:asm:7.3.1
[03:26:49] [ForkJoinPool.commonPool-worker-14/INFO]: Loading library org.ow2.asm:asm-util:7.3.1
[03:26:50] [ForkJoinPool.commonPool-worker-13/INFO]: Loading library com.zaxxer:HikariCP:4.0.3
[03:26:50] [ForkJoinPool.commonPool-worker-13/INFO]: Loading library org.slf4j:slf4j-api:2.0.6
[03:26:51] [main/INFO]: Loading library net.kyori:examination-api:1.3.0
[03:26:51] [main/INFO]: Loading library net.kyori:adventure-key:4.11.0
[03:26:51] [main/INFO]: Loading library net.kyori:adventure-api:4.11.0
[03:26:51] [main/INFO]: Loading library net.kyori:examination-string:1.3.0
[03:26:51] [main/INFO]: Loading library net.kyori:adventure-platform-bungeecord:4.1.2
[03:26:51] [main/INFO]: Loading library net.kyori:adventure-text-serializer-gson:4.11.0
[03:26:51] [main/INFO]: Loading library net.kyori:adventure-text-serializer-legacy:4.11.0
[03:26:51] [main/INFO]: Loading library net.kyori:adventure-text-serializer-bungeecord:4.1.2
[03:26:51] [main/INFO]: Loading library net.kyori:adventure-platform-api:4.1.2
[03:26:51] [main/INFO]: Loading library net.kyori:adventure-platform-facet:4.1.2
[03:26:51] [main/INFO]: 
[03:26:51] [main/INFO]: 正在加载 TrChat... git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507
[03:26:51] [main/INFO]: 
[03:26:51] [main/INFO]: [TrChat] 已支持 Bungee 通讯.
[03:26:51] [main/INFO]: Loaded plugin TrChat version 2.0.0-RC-6 by Arasple, ItsFlicker
[03:26:51] [main/INFO]: Loaded plugin AntiAttack version 1.0.0 by Vlvxingze
[03:26:51] [main/INFO]: Loaded plugin cmd_list version git:cmd_list:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:51] [main/INFO]: Loaded plugin cmd_find version git:cmd_find:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:51] [main/INFO]: Loaded plugin BungeeHub version 4.4 by Bing_Yanchi
[03:26:52] [main/INFO] [MiraiMC]: Verifying mirai-core-all-2.13.2.jar
[03:26:52] [main/INFO] [MiraiMC]: Loading library plugins\MiraiMC\MiraiBot\libs\mirai-core-all-2.13.2.jar
[03:26:52] [main/INFO]: Loaded plugin MiraiMC version 1.7.1 by DreamVoid
[03:26:52] [main/INFO]: Loaded plugin BungeeKick version 2.2 by Bing_Yanchi
[03:26:53] [main/INFO]: Loaded plugin ViaVersion version 4.5.1 by _MylesC, creeper123123321, Gerrygames, kennytv, Matsv
[03:26:53] [main/INFO]: Loaded plugin cmd_server version git:cmd_server:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:53] [main/INFO]: Loaded plugin cmd_alert version git:cmd_alert:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:53] [main/INFO]: Loaded plugin CMIB version 1.0.1.0 by Zrips
[03:26:53] [main/INFO]: Loaded plugin cmd_send version git:cmd_send:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:53] [main/INFO]: Loaded plugin ViaBackwards version 4.5.1 by Matsv, kennytv, Gerrygames, creeper123123321, ForceUpdate1
[03:26:53] [main/INFO]: Loaded plugin BungeeTabListPlus version 3.5.2 by CodeCrafter47
[03:26:53] [main/INFO]: Loaded plugin Chat2QQ version 1.6 by DreamVoid
[03:26:53] [main/WARN]: Forced host server pvp is not defined
[03:26:53] [main/INFO]: Enabled plugin MiniMOTD version 2.0.9 by jmp
[03:26:53] [main/INFO]: Enabled plugin reconnect_yaml version git:reconnect_yaml:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:53] [main/INFO]:         __    
[03:26:53] [main/INFO]:   |    |__)   LuckPerms v5.4.52
[03:26:53] [main/INFO]:   |___ |      Running on BungeeCord - Waterfall
[03:26:53] [main/INFO]: 
[03:26:53] [main/INFO] [LuckPerms]: Loading configuration...
[03:26:53] [main/INFO] [LuckPerms]: Loading storage provider... [H2]
[03:26:54] [MiniMOTD Pool Thread #0/INFO] [MiniMOTD]: There is an update available for MiniMOTD!
[03:26:54] [MiniMOTD Pool Thread #0/INFO] [MiniMOTD]: This server is running version v2.0.9, which is 1 versions outdated.
[03:26:54] [MiniMOTD Pool Thread #0/INFO] [MiniMOTD]: Download the latest version, v2.0.10 from GitHub at the link below:
[03:26:54] [MiniMOTD Pool Thread #0/INFO] [MiniMOTD]: https://github.com/jpenilla/MiniMOTD/releases/tag/v2.0.10
[03:26:54] [main/INFO] [LuckPerms]: Loading internal permission managers...
[03:26:54] [main/INFO] [LuckPerms]: Performing initial data load...
[03:26:54] [main/INFO] [LuckPerms]: Successfully enabled. (took 996ms)
[03:26:54] [main/INFO]: Enabled plugin LuckPerms version 5.4.52 by Luck
[03:26:54] [main/INFO]: [AllMusic]正在启动，感谢使用，本插件交流群：571239090
[03:26:54] [main/INFO]: [AllMusic]当前语言配置文件版本为：103，你的语言文件版本为：103
[03:26:54] [main/INFO]: [AllMusic]当前插件配置文件版本为：103，你的配置文件版本为：103
[03:26:54] [main/INFO]: 正在初始化数据库
[03:26:54] [main/INFO]: 正在读取数据库所有内容
[03:26:54] [main/INFO]: [AllMusic]已启动-2.18.0
[03:26:54] [main/INFO]: Enabled plugin AllMusic version 2.18.0 by Color_yr
[03:26:54] [main/WARN] [TrChat]: org.bukkit.event.player.PlayerJoinEvent not found, use @Ghost to turn off this warning
[03:26:54] [main/WARN] [TrChat]: org.bukkit.event.player.PlayerQuitEvent not found, use @Ghost to turn off this warning
[03:26:54] [main/WARN] [TrChat]: org.bukkit.event.player.PlayerJoinEvent not found, use @Ghost to turn off this warning
[03:26:54] [main/WARN] [TrChat]: org.bukkit.event.player.PlayerQuitEvent not found, use @Ghost to turn off this warning
[03:26:54] [main/INFO]: [TrChat] 聊天 | 成功载入 0 个聊天频道... [1 Ms]
[03:26:54] [main/INFO]: [TrChat] 信息 | 加载完毕. TrChat v2.0.0-RC-6 现已启用, 敬请使用.
[03:26:54] [main/INFO]: Enabled plugin TrChat version 2.0.0-RC-6 by Arasple, ItsFlicker
[03:26:54] [main/INFO] [AntiAttack]: RLV406-启用中...
[03:26:54] [main/INFO] [AntiAttack]: Here we go！ Good to go！ネプテューヌ！
[03:26:54] [main/INFO] [AntiAttack]: 乐乐——插件交流反馈群: 580659670
[03:26:54] [main/INFO]: Enabled plugin AntiAttack version 1.0.0 by Vlvxingze
[03:26:54] [main/INFO]: Enabled plugin cmd_list version git:cmd_list:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:54] [main/INFO]: Enabled plugin cmd_find version git:cmd_find:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:54] [main/INFO] [BungeeHub]: Loaded successfully.
[03:26:54] [main/INFO] [BungeeHub]: Enabled successfully.
[03:26:54] [main/INFO]: Enabled plugin BungeeHub version 4.4 by Bing_Yanchi
[03:26:54] [main/INFO] [MiraiMC]: Mirai working dir: default
[03:26:54] [main/INFO] [MiraiMC]: Starting Mirai-Events listener.
[03:26:54] [main/INFO] [MiraiMC]: Registering commands.
[03:26:54] [main/INFO] [MiraiMC]: Registering events.
[03:26:55] [main/INFO] [MiraiMC]: Loading auto-login file.
[03:26:55] [main/INFO] [MiraiMC]: Initializing MySQL database.
[03:26:55] [MiraiMC Pool Thread #0/INFO] [MiraiMC]: [AutoLogin] Starting auto login task.
[03:26:55] [MiraiMC Pool Thread #0/INFO] [MiraiMC]: [AutoLogin] Auto login bot account: 2126781882 Protocol: ANDROID_PHONE
[03:26:55] [MiraiMC Pool Thread #0/INFO] [MiraiMC]: 登录新的机器人账号: 2126781882, 协议: ANDROID_PHONE
[03:26:55] [main/INFO] [me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.HikariDataSource]: HikariPool-1 - Starting...
[03:26:55] [DefaultDispatcher-worker-1/INFO] [MiraiMC]: Loaded account secrets from local cache.
[03:26:55] [DefaultDispatcher-worker-1/INFO] [MiraiMC]: ECDH key is valid.
[03:26:55] [DefaultDispatcher-worker-1/INFO] [MiraiMC]: Saved account secrets to local cache for fast login.
[03:26:55] [DefaultDispatcher-worker-1/INFO] [MiraiMC]: Login successful.
[03:26:55] [nioEventLoopGroup-2-4/INFO] [MiraiMC]: Server time updated, serverTime: 1674242813, diff: -2ms=-0.002s
[03:26:55] [DefaultDispatcher-worker-3/INFO] [MiraiMC]: Syncing friend message history...
[03:26:55] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Start loading friend list...
[03:26:55] [DefaultDispatcher-worker-8/INFO] [MiraiMC]: Start loading stranger list...
[03:26:55] [DefaultDispatcher-worker-9/INFO] [MiraiMC]: Start loading friendGroup list...
[03:26:55] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Successfully loaded stranger list: 0 in total
[03:26:55] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Start loading group list...
[03:26:56] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Successfully loaded friend list: 18 in total
[03:26:56] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Successfully loaded friendGroup list: 4 in total
[03:26:56] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Syncing friend message history: Success.
[03:26:56] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Online OtherClients: mirai(MOBILE)
[03:26:56] [main/ERROR] [me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool]: HikariPool-1 - Exception during pool initialization.
java.sql.SQLSyntaxErrorException: Access denied for user 'CUXLII'@'localhost' to database 'miraimc'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) ~[?:?]
	at me.dreamvoid.miraimc.internal.Utils.initializeMySQL(Utils.java:75) ~[?:?]
	at me.dreamvoid.miraimc.bungee.BungeePlugin.onEnable(BungeePlugin.java:87) ~[?:?]
	at net.md_5.bungee.api.plugin.PluginManager.enablePlugins(PluginManager.java:315) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.BungeeCord.start(BungeeCord.java:299) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.BungeeCordLauncher.main(BungeeCordLauncher.java:67) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.Bootstrap.main(Bootstrap.java:15) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
[03:26:56] [main/WARN]: Exception encountered when loading plugin: MiraiMC
me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Access denied for user 'CUXLII'@'localhost' to database 'miraimc'
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) ~[?:?]
	at me.dreamvoid.miraimc.internal.Utils.initializeMySQL(Utils.java:75) ~[?:?]
	at me.dreamvoid.miraimc.bungee.BungeePlugin.onEnable(BungeePlugin.java:87) ~[?:?]
	at net.md_5.bungee.api.plugin.PluginManager.enablePlugins(PluginManager.java:315) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.BungeeCord.start(BungeeCord.java:299) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.BungeeCordLauncher.main(BungeeCordLauncher.java:67) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.Bootstrap.main(Bootstrap.java:15) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
Caused by: java.sql.SQLSyntaxErrorException: Access denied for user 'CUXLII'@'localhost' to database 'miraimc'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[?:?]
	at me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[?:?]
	... 8 more
[03:26:56] [main/INFO] [BungeeKick]: null
[03:26:56] [main/INFO] [BungeeKick]: Enabled successfully.
[03:26:56] [main/INFO]: Enabled plugin BungeeKick version 2.2 by Bing_Yanchi
[03:26:56] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Successfully loaded group list: 4 in total.
[03:26:56] [DefaultDispatcher-worker-3/INFO] [MiraiMC]: Scheduled refresh login session in 19d 23h 55min 0.0s.
[03:26:56] [DefaultDispatcher-worker-8/INFO] [MiraiMC]: Scheduled key refresh in 23h 55min 0.0s.
[03:26:56] [DefaultDispatcher-worker-5/INFO] [MiraiMC]: Bot login successful.
[03:26:56] [MiraiMC Pool Thread #0/INFO] [MiraiMC]: α(2126781882) 登录成功
[03:26:56] [Via-Mappingloader-0/INFO] [ViaVersion]: Loading 1.12 -> 1.13 mappings...
[03:26:56] [Via-Mappingloader-1/INFO] [ViaVersion]: Loading 1.13 -> 1.13.2 mappings...
[03:26:56] [Via-Mappingloader-2/INFO] [ViaVersion]: Loading 1.13.2 -> 1.14 mappings...
[03:26:56] [Via-Mappingloader-3/INFO] [ViaVersion]: Loading 1.14 -> 1.15 mappings...
[03:26:56] [Via-Mappingloader-4/INFO] [ViaVersion]: Loading 1.15 -> 1.16 mappings...
[03:26:56] [Via-Mappingloader-5/INFO] [ViaVersion]: Loading 1.16 -> 1.16.2 mappings...
[03:26:56] [Via-Mappingloader-6/INFO] [ViaVersion]: Loading 1.16.2 -> 1.17 mappings...
[03:26:56] [Via-Mappingloader-0/INFO] [ViaVersion]: Loading block connection mappings ...
[03:26:56] [Via-Mappingloader-1/INFO] [ViaVersion]: Loading 1.17 -> 1.18 mappings...
[03:26:56] [Via-Mappingloader-4/INFO] [ViaVersion]: Loading 1.18 -> 1.19 mappings...
[03:26:56] [Via-Mappingloader-1/INFO] [ViaVersion]: Loading 1.19 -> 1.19.3 mappings...
[03:26:56] [main/INFO] [ViaBackwards]: Loading translations...
[03:26:56] [Via-Mappingloader-1/INFO] [ViaBackwards]: Loading 1.10 -> 1.9.4 mappings...
[03:26:56] [Via-Mappingloader-1/INFO] [ViaBackwards]: Loading 1.11 -> 1.10 mappings...
[03:26:56] [Via-Mappingloader-1/INFO] [ViaBackwards]: Loading 1.12 -> 1.11 mappings...
[03:26:56] [Via-Mappingloader-1/INFO] [ViaBackwards]: Loading 1.13 -> 1.12 mappings...
[03:26:56] [Via-Mappingloader-0/INFO] [ViaBackwards]: Loading 1.13.2 -> 1.13 mappings...
[03:26:56] [Via-Mappingloader-0/INFO] [ViaBackwards]: Loading 1.14 -> 1.13.2 mappings...
[03:26:56] [Via-Mappingloader-1/INFO] [ViaBackwards]: Loading 1.15 -> 1.14 mappings...
[03:26:57] [Via-Mappingloader-1/INFO] [ViaBackwards]: Loading 1.16 -> 1.15 mappings...
[03:26:57] [Via-Mappingloader-0/INFO] [ViaBackwards]: Loading 1.16.2 -> 1.16 mappings...
[03:26:57] [Via-Mappingloader-0/INFO] [ViaBackwards]: Loading 1.17 -> 1.16.2 mappings...
[03:26:57] [Via-Mappingloader-0/INFO] [ViaBackwards]: Loading 1.18 -> 1.17 mappings...
[03:26:57] [Via-Mappingloader-0/INFO] [ViaBackwards]: Loading 1.19 -> 1.18 mappings...
[03:26:57] [Via-Mappingloader-0/INFO] [ViaBackwards]: Loading 1.19.3 -> 1.19 mappings...
[03:26:57] [main/INFO]: Enabled plugin ViaVersion version 4.5.1 by _MylesC, creeper123123321, Gerrygames, kennytv, Matsv
[03:26:57] [ViaVersion Pool Thread #1/INFO] [ViaVersion]: ViaVersion detected lowest supported version by the proxy: 1.8.x (47)
[03:26:57] [main/INFO]: Enabled plugin cmd_server version git:cmd_server:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:57] [ViaVersion Pool Thread #1/INFO] [ViaVersion]: Highest supported version by the proxy: 1.19.1/2 (760)
[03:26:57] [main/INFO]: Enabled plugin cmd_alert version git:cmd_alert:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:57] [main/INFO] [CMIB]: Registered channel!
[03:26:57] [main/INFO] [CMIB]: Registered listeners!
[03:26:57] [main/INFO]: Enabled plugin CMIB version 1.0.1.0 by Zrips
[03:26:57] [main/INFO]: Enabled plugin cmd_send version git:cmd_send:1.19-R0.1-SNAPSHOT:82114a5:507 by WaterfallMC
[03:26:57] [main/INFO]: Enabled plugin ViaBackwards version 4.5.1 by Matsv, kennytv, Gerrygames, creeper123123321, ForceUpdate1
[03:26:57] [ViaVersion Pool Thread #3/INFO] [ViaVersion]: Finished mapping loading, shutting down loader executor!
[03:26:57] [main/INFO] [BungeeTabListPlus]: Starting UpdateChecker Task
[03:26:57] [main/INFO]: Enabled plugin BungeeTabListPlus version 3.5.2 by CodeCrafter47
[03:26:57] [main/INFO]: Enabled plugin Chat2QQ version 1.6 by DreamVoid
[03:26:57] [Netty Boss IO Thread #0/INFO]: Listening on /192.168.4.189:27523
[03:27:25] [AntiAttack Pool Thread #0/INFO] [AntiAttack]: 插件在更新时出现错误!
[03:27:59] [DefaultDispatcher-worker-9/INFO] [MiraiMC]: [GroupMessage/2126781882] [测试机器人(513064743)] (2752329702) -> 测试消息
[03:27:59] [DefaultDispatcher-worker-9/WARN]: Error dispatching event GroupMessageEvent(group=513064743, senderName=初醒离, sender=2752329702, permission=OWNER, message=[mirai:source:ids=[3193], internalIds=[592599989], from group 2752329702 to 513064743 at 1674242876]测试消息) to listener me.dreamvoid.chat2qq.bungee.listener.onGroupMessage@7f0977d6
java.lang.NullPointerException: Cannot invoke "me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.HikariDataSource.getConnection()" because "me.dreamvoid.miraimc.internal.Utils.ds" is null
	at me.dreamvoid.miraimc.api.MiraiMC.getBind(MiraiMC.java:421) ~[?:?]
	at me.dreamvoid.chat2qq.bungee.listener.onGroupMessage.onGroupMessageReceive(onGroupMessage.java:40) ~[?:?]
	at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:577) ~[?:?]
	at net.md_5.bungee.event.EventHandlerMethod.invoke(EventHandlerMethod.java:19) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.event.EventBus.post(EventBus.java:50) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:466) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at me.dreamvoid.miraimc.bungee.MiraiEvent.lambda$startListenEvent$8(MiraiEvent.java:117) ~[?:?]
	at net.mamoe.mirai.event.EventChannel$subscribeAlways$2$1.invoke(EventChannel.kt:626) ~[?:?]
	at net.mamoe.mirai.event.EventChannel$subscribeAlways$2$1.invoke(EventChannel.kt:626) ~[?:?]
	at kotlinx.coroutines.InterruptibleKt.runInterruptibleInExpectedContext(Interruptible.kt:51) ~[?:?]
	at kotlinx.coroutines.InterruptibleKt.access$runInterruptibleInExpectedContext(Interruptible.kt:1) ~[?:?]
	at kotlinx.coroutines.InterruptibleKt$runInterruptible$2.invokeSuspend(Interruptible.kt:43) ~[?:?]
	at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33) ~[?:?]
	at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:106) ~[?:?]
	at kotlinx.coroutines.internal.LimitedDispatcher.run(LimitedDispatcher.kt:42) ~[?:?]
	at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:95) ~[?:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:570) ~[?:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:750) ~[?:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:677) ~[?:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:664) ~[?:?]
[03:28:11] [DefaultDispatcher-worker-9/INFO] [MiraiMC]: [GroupMessage/2126781882] [测试机器人(513064743)] (2752329702) -> 测试消息2
[03:28:11] [DefaultDispatcher-worker-9/WARN]: Error dispatching event GroupMessageEvent(group=513064743, senderName=初醒离, sender=2752329702, permission=OWNER, message=[mirai:source:ids=[3194], internalIds=[744155218], from group 2752329702 to 513064743 at 1674242888]测试消息2) to listener me.dreamvoid.chat2qq.bungee.listener.onGroupMessage@7f0977d6
java.lang.NullPointerException: Cannot invoke "me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.HikariDataSource.getConnection()" because "me.dreamvoid.miraimc.internal.Utils.ds" is null
	at me.dreamvoid.miraimc.api.MiraiMC.getBind(MiraiMC.java:421) ~[?:?]
	at me.dreamvoid.chat2qq.bungee.listener.onGroupMessage.onGroupMessageReceive(onGroupMessage.java:40) ~[?:?]
	at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:577) ~[?:?]
	at net.md_5.bungee.event.EventHandlerMethod.invoke(EventHandlerMethod.java:19) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.event.EventBus.post(EventBus.java:50) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:466) ~[waterfall.jar:git:Waterfall-Bootstrap:1.19-R0.1-SNAPSHOT:82114a5:507]
	at me.dreamvoid.miraimc.bungee.MiraiEvent.lambda$startListenEvent$8(MiraiEvent.java:117) ~[?:?]
	at net.mamoe.mirai.event.EventChannel$subscribeAlways$2$1.invoke(EventChannel.kt:626) ~[?:?]
	at net.mamoe.mirai.event.EventChannel$subscribeAlways$2$1.invoke(EventChannel.kt:626) ~[?:?]
	at kotlinx.coroutines.InterruptibleKt.runInterruptibleInExpectedContext(Interruptible.kt:51) ~[?:?]
	at kotlinx.coroutines.InterruptibleKt.access$runInterruptibleInExpectedContext(Interruptible.kt:1) ~[?:?]
	at kotlinx.coroutines.InterruptibleKt$runInterruptible$2.invokeSuspend(Interruptible.kt:43) ~[?:?]
	at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33) ~[?:?]
	at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:106) ~[?:?]
	at kotlinx.coroutines.internal.LimitedDispatcher.run(LimitedDispatcher.kt:42) ~[?:?]
	at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:95) ~[?:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:570) ~[?:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:750) ~[?:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:677) ~[?:?]
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:664) ~[?:?]

额外说明

系统为WIN10Pro 22H2，java版本为zulu18.32.13-ca-jdk18.0.2.1-win_x64,无其他依赖mirai的插件
以下为BC端所有安装插件
image

协议
@CUX-LI CUX-LI added the 漏洞 某些东西爆炸了 label Jan 20, 2023
@DreamVoid
Copy link
Owner

检查miraimc数据库连接

@CUX-LI
Copy link
Author

CUX-LI commented Jan 21, 2023

确实是数据库问题，关掉这一项后恢复正常
image
但数据库（mysql5,7）运行正常且账户密码地址什么的都是正确填写的。

PS：因为whitelist4QQ没有Bungee版本所以我在子服另外登录了一个mirai机器人（与Bungee端非同一账号）来进行白名单添加，且子服数据库与Bungee端mirai数据库为同一个。

@CUX-LI
Copy link
Author

CUX-LI commented Jan 21, 2023

这是子服数据库
image

群内申请白名单后正常进行了玩家绑定

@CUX-LI
Copy link
Author

CUX-LI commented Jan 21, 2023 •
edited

看这一栏报错
[03:26:56] [main/ERROR] [me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool]: HikariPool-1 - Exception during pool initialization.
java.sql.SQLSyntaxErrorException: Access denied for user 'CUXLII'@'localhost' to database 'miraimc'

我觉得可能是使用了默认的datebase：“miraimc”，而不是我自己数据库的datebase名称

@DreamVoid
Copy link
Owner

看这一栏报错 [03:26:56] [main/ERROR] [me.dreamvoid.miraimc.libraries.com.zaxxer.hikari.pool.HikariPool]: HikariPool-1 - Exception during pool initialization. java.sql.SQLSyntaxErrorException: Access denied for user 'CUXLII'@'localhost' to database 'miraimc'

我觉得可能是使用了默认的datebase：“miraimc”，而不是我自己数据库的datebase名称

请附上MiraiMC的config.yml文件

@CUX-LI
Copy link
Author

CUX-LI commented Jan 21, 2023

以下是Bungee服MiraiMC的配置文件

这是 MiraiMC 插件的配置文件

如需获取有关调整配置的帮助，请访问 https://docs.miraimc.dreamvoid.me/docs/configure-file

Github: https://github.com/DreamVoid/MiraiMC

MCBBS: https://www.mcbbs.net/thread-1207462-1-1.html

general:
allow-bStats: true
check-update: true
disable-safe-warning-message: false
mirai-working-dir: default
mirai-core-version: stable
maven-repo-url: https://maven.aliyun.com/nexus/content/groups/public/
enable-http-api: false
legacy-event-support: false
bot:
disable-network-logs: false
disable-bot-logs: false
use-minecraft-logger:
bot-logs: true
network-logs: true
log-events: true
contact-cache:
enable-friend-list-cache: false
enable-group-member-list-cache: false
save-interval-millis: 60000
database:
type: mysql
mysql:
address: localhost:2752
username: CUXLII
password: Admin1009
database: 114514
pool:
connectionTimeout: 30000
idleTimeout: 600000
maxLifetime: 1800000
maximumPoolSize: 15
keepaliveTime: 0
minimumIdle: 5
http-api:
url: http://localhost:8080
message-fetch:
interval: 10
count: 10

@CUX-LI
Copy link
Author

CUX-LI commented Jan 21, 2023

以下是子服里MiraiMC的配置文件

这是 MiraiMC 插件的配置文件

如需获取有关调整配置的帮助，请访问 https://docs.miraimc.dreamvoid.me/docs/configure-file

Github: https://github.com/DreamVoid/MiraiMC

MCBBS: https://www.mcbbs.net/thread-1207462-1-1.html

general:
allow-bStats: true
check-update: true
disable-safe-warning-message: false
mirai-working-dir: default
mirai-core-version: stable
maven-repo-url: https://maven.aliyun.com/nexus/content/groups/public/
enable-http-api: false
legacy-event-support: false
bot:
disable-network-logs: false
disable-bot-logs: false
use-minecraft-logger:
bot-logs: true
network-logs: true
log-events: true
contact-cache:
enable-friend-list-cache: false
enable-group-member-list-cache: false
save-interval-millis: 60000
database:
type: mysql
mysql:
address: localhost:2752
username: CUXLII
password: Admin1009
database: 114514
pool:
connectionTimeout: 30000
idleTimeout: 600000
maxLifetime: 1800000
maximumPoolSize: 15
keepaliveTime: 0
minimumIdle: 5
http-api:
url: http://localhost:8080
message-fetch:
interval: 10
count: 10

@CUX-LI
Copy link
Author

CUX-LI commented Jan 23, 2023 •
edited

机器人被腾讯拦截了，ticket 输完跟我说网络不稳定，放弃了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
漏洞 某些东西爆炸了
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@DreamVoid @CUX-LI