Skocz do zawartości
  • 0

Wygląda na to, że moje hasło do MySQL się nagle, z nikąd zmienia.

Kiler_630

Pytanie zadane przez Kiler_630,

 Udostępnij

Pytanie

Kiler_630

Kiler_630 0

Opublikowano
Opublikowano (edytowane)

 

Mam bazę my SQL i używam jej do pluginu nLogin, który mam zainstalowany na lobby i BungeeCord.  Używam VPS Almalinux.

W configu pluginu dałem hasło, dane itp mysql. No i plugin śmiga spoko, ale tylko tymczasowo - po może ok. 1 godzinie? plugin traci dostęp do mysql (i ja również) a ten plugin wymaga połączenia z bazą danych, więc plugin zamyka cały serwer. Jak uruchamiam, pisze access denied for root@localhost na konsoli.

Oraz Kiedy wpisuję komendę sudo -u root -p, pisze tam "access denied for root@localhost, using password: YES'. Muszę znowu ustawić hasło, więc wpisuję sudo mysql secure_installation, wpisuje hasło, włączam znowu serwer i wszystko śmiga. No i potem nagle znowu traci dostęp. No i tak w kółko. 

W ogóle, nadal mogę grać na serwerze i używac pluginu, ale teraz zobaczyłem coś na konsoli BungeeCorda:

Logi na dole, a tutaj dam

Edit: Zaczyna się. Mam taki log na consoli:, (a te następne to są z wcześniej, konkretnie ten środkowy to jest ten błąd na konsoli o którym mówiłem, a ten ostatni jest z przed kilku dni) Edit: a, i swoją drogą, się myliłem chyba - serwer się nie zamyka teraz, ale nie mogę na niego poprostu wejść ( sorry , this database operation coudl ot be completed) 

04:41:55 [SEVERE] [nLogin] Could not update Kiler_630 account's 50853626 [write fail?]
java.sql.SQLException: [Database] Could not get a pooled connection.
	at com.nickuc.login.νζΠΣζπχθαΔδθφ.d(:38)
	at com.nickuc.login.ΔΦξΩΣαγλθεΓβχ.a(:205)
	at com.nickuc.login.χιδΔΣιΩηΓ.a(:151)
	at com.nickuc.login.ζĎΛχχμΩιĎκγοπδĎ.b(:53)
	at com.nickuc.login.νμηαΣεφη.a(:116)
	at com.nickuc.login.θΓζκΠĎηΣχΩΓĎζΓβ.a(:66)
	at com.nickuc.login.ĎιυΦĎβΛθωλτ.a(:524)
	at com.nickuc.login.ĎιυΦĎβΛθωλτ.a(:520)
	at com.nickuc.login.ΓφτνĎνυĎÎŁ.d(:83)
	at com.nickuc.login.ĎτκκζγκτΠδςχπχ.b(:419)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at net.md_5.bungee.event.EventHandlerMethod.invoke(EventHandlerMethod.java:19)
	at net.md_5.bungee.event.EventBus.post(EventBus.java:49)
	at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:413)
	at net.md_5.bungee.connection.UpstreamBridge.disconnected(UpstreamBridge.java:68)
	at net.md_5.bungee.netty.HandlerBoss.channelInactive(HandlerBoss.java:60)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:305)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:281)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:274)
	at io.netty.channel.ChannelInboundHandlerAdapter.channelInactive(ChannelInboundHandlerAdapter.java:81)
	at io.netty.handler.timeout.IdleStateHandler.channelInactive(IdleStateHandler.java:277)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:303)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:281)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:274)
	at io.netty.handler.codec.ByteToMessageDecoder.channelInputClosed(ByteToMessageDecoder.java:411)
	at io.netty.handler.codec.ByteToMessageDecoder.channelInactive(ByteToMessageDecoder.java:376)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:305)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:281)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:274)
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelInactive(DefaultChannelPipeline.java:1405)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:301)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:281)
	at io.netty.channel.DefaultChannelPipeline.fireChannelInactive(DefaultChannelPipeline.java:901)
	at io.netty.channel.AbstractChannel$AbstractUnsafe$7.run(AbstractChannel.java:813)
	at io.netty.util.concurrent.AbstractEventExecutor.runTask(AbstractEventExecutor.java:174)
	at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:167)
	at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:470)
	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:566)
	at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
	at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.sql.SQLTransientConnectionException: nlogin-hikaricp - Connection is not available, request timed out after 5000ms.
	at com.nickuc.login.lib.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
	at com.nickuc.login.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
	at com.nickuc.login.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
	at com.nickuc.login.lib.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
	at com.nickuc.login.νζΠΣζπχθαΔδθφ.d(:36)
	... 43 more
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.nickuc.login.lib.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.nickuc.login.lib.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.nickuc.login.lib.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at com.nickuc.login.lib.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
	at com.nickuc.login.lib.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
	at com.nickuc.login.lib.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
	at com.nickuc.login.lib.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
	at com.nickuc.login.lib.hikari.pool.HikariPool.access$100(HikariPool.java:71)
	at com.nickuc.login.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
	at com.nickuc.login.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	... 1 more
04:41:55 [WARNING] Plugin listener com.nickuc.login.ĎτκκζγκτΠδςχπχ took 5,013ms to process event PlayerDisconnectEvent(player=Kiler_630)!
04:41:55 [WARNING] Event PlayerDisconnectEvent(player=Kiler_630) took 5,014ms to process!
04:41:55 [INFO] [Kiler_630] -> UpstreamBridge has disconnected
04:41:55 [INFO] [Kiler_630] <-> DownstreamBridge <-> [lobby] has disconnected
04:42:23 [INFO] [/130.162.240.20:39520] <-> InitialHandler has pinged
04:42:31 [INFO] [/217.97.66.131:55130] <-> InitialHandler has pinged
04:42:32 [INFO] [Kiler_630,/217.97.66.131:55138] <-> InitialHandler has connected
04:42:37 [SEVERE] [nLogin] Failed to build the account using "WHERE `last_name` = ? AND `bedrock_id` IS NULL LIMIT 3" with values "[Kiler_630]"
java.sql.SQLException: [Database] Could not get a pooled connection.
	at com.nickuc.login.νζΠΣζπχθαΔδθφ.d(:38)
	at com.nickuc.login.ΔΦξΩΣαγλθεΓβχ.a(:205)
	at com.nickuc.login.χιδΔΣιΩηΓ.a(:151)
	at com.nickuc.login.ζĎΛχχμΩιĎκγοπδĎ.a(:73)
	at com.nickuc.login.θΓζκΠĎηΣχΩΓĎζΓβ.a(:147)
	at com.nickuc.login.ĎιυΦĎβΛθωλτ.a(:43)
	at com.nickuc.login.ĎιυΦĎβΛθωλτ.a(:138)
	at com.nickuc.login.ĎτκκζγκτΠδςχπχ.b(:216)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at net.md_5.bungee.event.EventHandlerMethod.invoke(EventHandlerMethod.java:19)
	at net.md_5.bungee.event.EventBus.post(EventBus.java:49)
	at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:413)
	at net.md_5.bungee.connection.InitialHandler.handle(InitialHandler.java:457)
	at net.md_5.bungee.protocol.packet.LoginRequest.handle(LoginRequest.java:66)
	at net.md_5.bungee.netty.HandlerBoss.channelRead(HandlerBoss.java:114)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346)
	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.handler.codec.ByteToMessageDecoder.handlerRemoved(ByteToMessageDecoder.java:266)
	at io.netty.handler.codec.ByteToMessageDecoder.decodeRemovalReentryProtection(ByteToMessageDecoder.java:536)
	at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:468)
	at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:290)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
	at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
	at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
	at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
	at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724)
	at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650)
	at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
	at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
	at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
	at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: java.sql.SQLTransientConnectionException: nlogin-hikaricp - Connection is not available, request timed out after 5000ms.
	at com.nickuc.login.lib.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
	at com.nickuc.login.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
	at com.nickuc.login.lib.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
	at com.nickuc.login.lib.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
	at com.nickuc.login.νζΠΣζπχθαΔδθφ.d(:36)
	... 52 more
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.nickuc.login.lib.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.nickuc.login.lib.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.nickuc.login.lib.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at com.nickuc.login.lib.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
	at com.nickuc.login.lib.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
	at com.nickuc.login.lib.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
	at com.nickuc.login.lib.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
	at com.nickuc.login.lib.hikari.pool.HikariPool.access$100(HikariPool.java:71)
	at com.nickuc.login.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
	at com.nickuc.login.lib.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	... 1 more
04:42:37 [WARNING] Plugin listener com.nickuc.login.ĎτκκζγκτΠδςχπχ took 5,014ms to process event PreLoginEvent(cancelled=true, cancelReasonComponents=[TextComponent{text=Sorry, this database operation could not be completed. Check the console for more details., BaseComponent(color=§c, font=null, bold=null, italic=null, underlined=null, strikethrough=null, obfuscated=null, insertion=null, extra=null, clickEvent=null, hoverEvent=null, reset=true)}], connection=[Kiler_630,/217.97.66.131:55138] <-> InitialHandler)!
04:42:37 [WARNING] Event PreLoginEvent(cancelled=true, cancelReasonComponents=[TextComponent{text=Sorry, this database operation could not be completed. Check the console for more details., BaseComponent(color=§c, font=null, bold=null, italic=null, underlined=null, strikethrough=null, obfuscated=null, insertion=null, extra=null, clickEvent=null, hoverEvent=null, reset=true)}], connection=[Kiler_630,/217.97.66.131:55138] <-> InitialHandler) took 5,015ms to process!
04:42:59 [INFO] [/130.162.240.20:43194] <-> InitialHandler has pinged
04:43:30 [INFO] [Kiler_630,/217.97.66.131:55155] <-> InitialHandler has connected
04:43:34 [INFO] [/130.162.240.20:50236] <-> InitialHandler has pinged
04:43:35 [SEVERE] [nLogin] Failed to build the account using "WHERE `last_name` = ? AND `bedrock_id` IS NULL LIMIT 3" with values "[Kiler_630]"
java.sql.SQLException: [Database] Could not get a pooled connection.
	at com.nickuc.login.νζΠΣζπχθαΔδθφ.d(:38)
	at com.nickuc.login.ΔΦξΩΣαγλθεΓβχ.a(:205)
	at com.nickuc.login.χιδΔΣιΩηΓ.a(:151)

03:59:43 [INFO] [Kiler_630,/IP:53861] <-> InitialHandler has connected
03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@f5c83d1 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@151fa4f0 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@7aa6bd34 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@110ffbba (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@3d1361b0 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@55437ac6 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@1a432247 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@747fd89e (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@52c73940 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

03:59:43 [SEVERE] [Netty IO Thread #15] WARN com.nickuc.login.lib.hikari.pool.PoolBase - nlogin-hikaricp - Failed to validate connection com.nickuc.login.lib.mysql.cj.jdbc.ConnectionImpl@1c1cec94 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

Tutaj są logi pluginu nLogin z poprzednich kilku dni, kiedy właśnie tak się nagle stało. 

Spoiler

[11/19/2023 19:14:01]: [nLogin] The user ErOshi592__51 has successfully registered.
[11/19/2023 19:19:40]: [nLogin] [DEBUG] [MySQL] [UPDATE]: "UPDATE `nlogin` SET `last_name` = 'ErOshi592__51', `unique_id` = 00df8f3c0cd03199a716c67fb9bcc1e7,  `mojang_id` = null,  `bedrock_id` = null,  `password` = '$SHA512$702bd1c8acc91308e580982c6d972827b9517ae8fddc982c56b490d0b5e6c48ef45af0ac92ab5197cf23df19c5026cd7db29ab6b2fb2288bb6450ba33a6d617a$CKOMTAINUJeurGyLhMHrUPCu', `last_ip` = '217.173.4.59', `creation_date` = 2023-11-19 19:14:01.219, `last_login` = 2023-11-19 19:14:01.219, `email` = null, `discord` = null, `settings` = '{"settings":[{"value":"Kf4OuPuXZyNd2lLBKNjgMZp12b3Gg5dMim0JYPv+YdJetWN4KRq6npFAJ4M+Jykps3HADFc47zxXh4Rd8A0FmEA/Hj5e8FYZxq+lrkN91nLUqdJY3PTEM5Uwtd59RQhknGPbEF8oQ10TMK7SQpQdpbreEd3qo79RnumyqJ6ifemgg+x1/kVPnhtx2Kx8xyPH6PZ7NGSiSohAGdKJyadC7Ba23ElESk5CLoif/P73eU3LJEqP93yYdl+3eoCPL9JuqXLe4XrTTzoB+z26HhuTufIv+u345/2GLaNv0q/q47DC0ZUQf+QsaZQdPZE7QhchRApnrzkmE9lmTjjzFkpWLSKs9M+zxuAX4mCOD7TvlO4XrE8Q5V/0IfZ++aH7haIz+cly8XcXjbqdOTAHK6B0lHu4vqP3eDjmryHRLSKmrS1SYNJAJSFSOjkdz6cit4epBFq5BCWhV1bfWu8ma9T7yVnq+FvMU+6GmDMxCnHFikTvXO8vDWz1v4fz+7h24kYbzarsVdqn88Lj7GQ2dPupvWCFPyQmZ0AqX43i+3OUp49SpKoyvEKWsg8yeF5PEhrFvyo5aTjSrQz+q576ZYIGZtxOSfgCd1IWce9QtFkG0QrQCINNvcsTx06H+wI0FyotostTsU5j9jnLkmSo2Tbt+q02xvdSOxmdMrFjPZBvn5E=:ymXNFdLrqt4OvKk6H3BcfQ/J7H/0HMqty3F7mtyVAlBMHaN+uXNhSaRA4i7qG8yka08aIQU2","key":"encrypted"},{"value":"skyblock","key":"last-server"},{"value":"en","key":"language"}],"version":0}' WHERE `ai` = 2"
[11/19/2023 19:19:44]: [nLogin] [DEBUG] [MySQL] [UPDATE]: "UPDATE `nlogin` SET `last_name` = 'ErOshi592__51', `unique_id` = 00df8f3c0cd03199a716c67fb9bcc1e7,  `mojang_id` = null,  `bedrock_id` = null,  `password` = '$SHA512$702bd1c8acc91308e580982c6d972827b9517ae8fddc982c56b490d0b5e6c48ef45af0ac92ab5197cf23df19c5026cd7db29ab6b2fb2288bb6450ba33a6d617a$CKOMTAINUJeurGyLhMHrUPCu', `last_ip` = '217.173.4.59', `creation_date` = 2023-11-19 19:14:01.0, `last_login` = 2023-11-19 19:14:01.0, `email` = null, `discord` = null, `settings` = '{"settings":[{"value":"Kf4OuPuXZyNd2lLBKNjgMZp12b3Gg5dMim0JYPv+YdJetWN4KRq6npFAJ4M+Jykps3HADFc47zxXh4Rd8A0FmEA/Hj5e8FYZxq+lrkN91nLUqdJY3PTEM5Uwtd59RQhknGPbEF8oQ10TMK7SQpQdpbreEd3qo79RnumyqJ6ifemgg+x1/kVPnhtx2Kx8xyPH6PZ7NGSiSohAGdKJyadC7Ba23ElESk5CLoif/P73eU3LJEqP93yYdl+3eoCPL9JuqXLe4XrTTzoB+z26HhuTufIv+u345/2GLaNv0q/q47DC0ZUQf+QsaZQdPZE7QhchRApnrzkmE9lmTjjzFkpWLSKs9M+zxuAX4mCOD7TvlO4XrE8Q5V/0IfZ++aH7haIz+cly8XcXjbqdOTAHK6B0lHu4vqP3eDjmryHRLSKmrS1SYNJAJSFSOjkdz6cit4epBFq5BCWhV1bfWu8ma9T7yVnq+FvMU+6GmDMxCnHFikTvXO8vDWz1v4fz+7h24kYbzarsVdqn88Lj7GQ2dPupvWCFPyQmZ0AqX43i+3OUp49SpKoyvEKWsg8yeF5PEhrFvyo5aTjSrQz+q576ZYIGZtxOSfgCd1IWce9QtFkG0QrQCINNvcsTx06H+wI0FyotostTsU5j9jnLkmSo2Tbt+q02xvdSOxmdMrFjPZBvn5E=:ymXNFdLrqt4OvKk6H3BcfQ/J7H/0HMqty3F7mtyVAlBMHaN+uXNhSaRA4i7qG8yka08aIQU2","key":"encrypted"},{"value":"lobby","key":"last-server"},{"value":"en","key":"language"}],"version":0}' WHERE `ai` = 2"
[11/19/2023 19:20:10]: [nLogin] [ERROR] Could not update ErOshi592__51 account's 1035334051 [write fail?]
com.nickuc.login.lib.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    at com.nickuc.login.lib.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
    at com.nickuc.login.lib.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
    at com.nickuc.login.lib.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:555)
    at com.nickuc.login.lib.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:339)
    at com.nickuc.login.lib.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
    at com.nickuc.login.lib.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009)
    at com.nickuc.login.lib.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320)
    at com.nickuc.login.lib.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994)
    at com.nickuc.login.lib.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
    at com.nickuc.login.lib.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
    at com.nickuc.login.ζĎΛχχμΩιĎκγοπδĎ.b(:56)
    at com.nickuc.login.νμηαΣεφη.a(:116)
    at com.nickuc.login.θΓζκΠĎηΣχΩΓĎζΓβ.a(:66)
    at com.nickuc.login.ĎιυΦĎβΛθωλτ.a(:524)
    at com.nickuc.login.ĎιυΦĎβΛθωλτ.a(:520)
    at com.nickuc.login.ΓφτνĎνυĎÎŁ.d(:83)
    at com.nickuc.login.ĎτκκζγκτΠδςχπχ.b(:419)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:568)
    at net.md_5.bungee.event.EventHandlerMethod.invoke(EventHandlerMethod.java:19)
    at net.md_5.bungee.event.EventBus.post(EventBus.java:49)
    at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:413)
    at net.md_5.bungee.connection.UpstreamBridge.disconnected(UpstreamBridge.java:68)
    at net.md_5.bungee.netty.HandlerBoss.channelInactive(HandlerBoss.java:60)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:305)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:281)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:274)
    at io.netty.channel.ChannelInboundHandlerAdapter.channelInactive(ChannelInboundHandlerAdapter.java:81)
    at io.netty.handler.timeout.IdleStateHandler.channelInactive(IdleStateHandler.java:277)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:303)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:281)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:274)
    at io.netty.handler.codec.ByteToMessageDecoder.channelInputClosed(ByteToMessageDecoder.java:411)
    at io.netty.handler.codec.ByteToMessageDecoder.channelInactive(ByteToMessageDecoder.java:376)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:305)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:281)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelInactive(AbstractChannelHandlerContext.java:274)
    at io.netty.channel.DefaultChannelPipeline$HeadContext.channelInactive(DefaultChannelPipeline.java:1405)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:301)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelInactive(AbstractChannelHandlerContext.java:281)
    at io.netty.channel.DefaultChannelPipeline.fireChannelInactive(DefaultChannelPipeline.java:901)
    at io.netty.channel.AbstractChannel$AbstractUnsafe$7.run(AbstractChannel.java:813)
    at io.netty.util.concurrent.AbstractEventExecutor.runTask(AbstractEventExecutor.java:174)
    at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:167)
    at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:470)
    at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:566)
    at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
    at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
    at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: com.nickuc.login.lib.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
    at com.nickuc.login.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
    at com.nickuc.login.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
    at com.nickuc.login.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
    at com.nickuc.login.lib.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
    at com.nickuc.login.lib.mysql.cj.protocol.a.NativeProtocol.clearInputStream(NativeProtocol.java:869)
    at com.nickuc.login.lib.mysql.cj.NativeSession.clearInputStream(NativeSession.java:287)
    at com.nickuc.login.lib.mysql.cj.ServerPreparedQuery.serverResetStatement(ServerPreparedQuery.java:574)
    at com.nickuc.login.lib.mysql.cj.ServerPreparedQuery.prepareExecutePacket(ServerPreparedQuery.java:224)
    at com.nickuc.login.lib.mysql.cj.ServerPreparedQuery.serverExecute(ServerPreparedQuery.java:199)
    at com.nickuc.login.lib.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:553)
    ... 48 more
Caused by: java.io.IOException: Socket is closed
    at com.nickuc.login.lib.mysql.cj.protocol.AbstractSocketConnection.getMysqlInput(AbstractSocketConnection.java:72)
    at com.nickuc.login.lib.mysql.cj.protocol.a.NativeProtocol.clearInputStream(NativeProtocol.java:865)
    ... 53 more
[11/19/2023 19:20:10]: [nLogin] [DEBUG] [MySQL] [UPDATE]: "UPDATE `nlogin` SET `last_name` = 'ErOshi592__51', `unique_id` = 00df8f3c0cd03199a716c67fb9bcc1e7,  `mojang_id` = null,  `bedrock_id` = null,  `password` = '$SHA512$702bd1c8acc91308e580982c6d972827b9517ae8fddc982c56b490d0b5e6c48ef45af0ac92ab5197cf23df19c5026cd7db29ab6b2fb2288bb6450ba33a6d617a$CKOMTAINUJeurGyLhMHrUPCu', `last_ip` = '217.173.4.59', `creation_date` = 2023-11-19 19:14:01.0, `last_login` = 2023-11-19 19:14:01.0, `email` = null, `discord` = null, `settings` = '{"settings":[{"value":"Kf4OuPuXZyNd2lLBKNjgMZp12b3Gg5dMim0JYPv+YdJetWN4KRq6npFAJ4M+Jykps3HADFc47zxXh4Rd8A0FmEA/Hj5e8FYZxq+lrkN91nLUqdJY3PTEM5Uwtd59RQhknGPbEF8oQ10TMK7SQpQdpbreEd3qo79RnumyqJ6ifemgg+x1/kVPnhtx2Kx8xyPH6PZ7NGSiSohAGdKJyadC7Ba23ElESk5CLoif/P73eU3LJEqP93yYdl+3eoCPL9JuqXLe4XrTTzoB+z26HhuTufIv+u345/2GLaNv0q/q47DC0ZUQf+QsaZQdPZE7QhchRApnrzkmE9lmTjjzFkpWLSKs9M+zxuAX4mCOD7TvlO4XrE8Q5V/0IfZ++aH7haIz+cly8XcXjbqdOTAHK6B0lHu4vqP3eDjmryHRLSKmrS1SYNJAJSFSOjkdz6cit4epBFq5BCWhV1bfWu8ma9T7yVnq+FvMU+6GmDMxCnHFikTvXO8vDWz1v4fz+7h24kYbzarsVdqn88Lj7GQ2dPupvWCFPyQmZ0AqX43i+3OUp49SpKoyvEKWsg8yeF5PEhrFvyo5aTjSrQz+q576ZYIGZtxOSfgCd1IWce9QtFkG0QrQCINNvcsTx06H+wI0FyotostTsU5j9jnLkmSo2Tbt+q02xvdSOxmdMrFjPZBvn5E=:ymXNFdLrqt4OvKk6H3BcfQ/J7H/0HMqty3F7mtyVAlBMHaN+uXNhSaRA4i7qG8yka08aIQU2","key":"encrypted"},{"value":"lobby","key":"last-server"},{"value":"en","key":"language"}],"version":0}' WHERE `ai` = 2"
[11/19/2023 19:20:12]: [nLogin] [ERROR] Failed to build the account using "WHERE `last_name` = ? AND `bedrock_id` IS NULL LIMIT 3" with values "[ErOshi592__51]"
com.nickuc.login.lib.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    at com.nickuc.login.lib.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
    at com.nickuc.login.lib.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
    at com.nickuc.login.lib.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
    at com.nickuc.login.lib.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
    at com.nickuc.login.lib.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
    at com.nickuc.login.lib.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
    at com.nickuc.login.ζĎΛχχμΩιĎκγοπδĎ.a(:79)
    at com.nickuc.login.θΓζκΠĎηΣχΩΓĎζΓβ.a(:147)
    at com.nickuc.login.ĎιυΦĎβΛθωλτ.a(:43)
    at com.nickuc.login.ĎιυΦĎβΛθωλτ.a(:138)
    at com.nickuc.login.ĎτκκζγκτΠδςχπχ.b(:216)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:568)
    at net.md_5.bungee.event.EventHandlerMethod.invoke(EventHandlerMethod.java:19)
    at net.md_5.bungee.event.EventBus.post(EventBus.java:49)
    at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:413)
    at net.md_5.bungee.connection.InitialHandler.handle(InitialHandler.java:457)
    at net.md_5.bungee.protocol.packet.LoginRequest.handle(LoginRequest.java:66)
    at net.md_5.bungee.netty.HandlerBoss.channelRead(HandlerBoss.java:114)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346)
    at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.handler.codec.ByteToMessageDecoder.handlerRemoved(ByteToMessageDecoder.java:266)
    at io.netty.handler.codec.ByteToMessageDecoder.decodeRemovalReentryProtection(ByteToMessageDecoder.java:536)
    at io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:468)
    at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:290)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
    at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
    at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
    at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
    at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
    at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724)
    at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650)
    at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
    at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
    at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
    at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: com.nickuc.login.lib.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
    at jdk.internal.reflect.GeneratedConstructorAccessor38.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
    at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
    at com.nickuc.login.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
    at com.nickuc.login.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
    at com.nickuc.login.lib.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
    at com.nickuc.login.lib.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
    at com.nickuc.login.lib.mysql.cj.protocol.a.NativeProtocol.clearInputStream(NativeProtocol.java:869)
    at com.nickuc.login.lib.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:681)
    at com.nickuc.login.lib.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
    at com.nickuc.login.lib.mysql.cj.NativeSession.execSQL(NativeSession.java:665)
    at com.nickuc.login.lib.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:893)
    ... 53 more
Caused by: java.io.IOException: Socket is closed
    at com.nickuc.login.lib.mysql.cj.protocol.AbstractSocketConnection.getMysqlInput(AbstractSocketConnection.java:72)
    at com.nickuc.login.lib.mysql.cj.protocol.a.NativeProtocol.clearInputStream(NativeProtocol.java:865)
    ... 57 more

 

Edytowane przez Kiler_630
Odnośnik do komentarza
https://skript.pl/temat/56565-wygl%C4%85da-na-to-%C5%BCe-moje-has%C5%82o-do-mysql-si%C4%99-nagle-z-nik%C4%85d-zmienia/
Udostępnij na innych stronach

2 odpowiedzi na to pytanie

Rekomendowane odpowiedzi

  • 0
makstale

makstale 35

Opublikowano
Opublikowano (edytowane)

Możliwe, że plugin tworzy ticket i podmienia na swoje. Spróbuj wgl nie dawać hasła, tak na test, i zobacz co się będzie dało. Jeżeli Ci to pomoże, to znalazłem instrukcje jak można w łatwy sposób śledzić zmiany hasła w SQL.

https://social.technet.microsoft.com/wiki/contents/articles/51424.sql-server-how-to-track-login-password-changes.aspx

Ewentualnie popróbuj z innym programem, którego używasz do baz, bo widzę że prawdopodobnie hostujesz je lokalnie, więc pewnie jakiś xampp czy coś. Jeżeli nie, to upewij się 100 razy, że na pewno wszystko dobrze skonfigurowałeś.

Przy analizie błędów zastanawiały mnie te znaczki xD 

at com.nickuc.login.νζΠΣζπχθαΔδθφ.d(:38)
	at com.nickuc.login.ΔΦξΩΣαγλθεΓβχ.a(:205)
	at com.nickuc.login.χιδΔΣιΩηΓ.a(:151)

Jak sie okazało po dekompilacji, ten plugin nie ma open source. Jest po prostu zaszyfrowany, więc nie dojdziemy z czego wynikają błędy w tych linijkach. Nie mniej jednak, całokształt to po prostu utrata połączenia z bazą i błędy na skutek braku możliwości wykonania kwerend przez plugin.

Natomiast do tego co dałeś na samym dole masz tutaj linka, ten sam problem. 

https://stackoverflow.com/questions/60310858/possibly-consider-using-a-shorter-maxlifetime-value-hikari-connection-pool-spr

Edytowane przez makstale
  • 0
Kiler_630

Kiler_630 0

Opublikowano
  • Autor
Opublikowano

Okej, wszystko juz dziala (jak na razie) zainstalowalem baze mysql od nowa, i zamiast z roota utworzyłem nowe konto z mniejszymi uprawnieniami i baze danych, no i haslo sie juz nie resetuje

Dołącz do dyskusji

Możesz dodać zawartość już teraz a zarejestrować się później. Jeśli posiadasz już konto, zaloguj się aby dodać zawartość za jego pomocą.

Nieaktywny
Odpowiedz na pytanie...

×   Wklejono zawartość z formatowaniem.   Usuń formatowanie

  Dozwolonych jest tylko 75 emoji.

×   Odnośnik został automatycznie osadzony.   Przywróć wyświetlanie jako odnośnik

×   Przywrócono poprzednią zawartość.   Wyczyść edytor

×   Nie możesz bezpośrednio wkleić grafiki. Dodaj lub załącz grafiki z adresu URL.

×
 Udostępnij
Pytania

  • Ostatnio przeglądający   0 użytkowników

    • Brak zarejestrowanych użytkowników przeglądających tę stronę.
×
×
  • Dodaj nową pozycję...