grntbg
Full Member
Omnis anima potestatibus sublimioribus subdita sit.
Posts: 295
|
Post by grntbg on Jul 13, 2020 7:12:48 GMT
This is in response to Fionn's comment about there being a ".db file" in which all block placements are logged, but there is no such file if this server avoids SQLite for large databases as it should. CoreProtect has native in-game log purging which means that purging logs from [x] server wipes ago would be possible if server wipes were conducted automatically and not at the whim of admins. Had no idea at all about this. Thanks for telling me!!1!1 You don't need to be sorry because I wasn't "telling you" given that this thread is a discussion about the plugin and has nothing to do with you. I'm telling the person which inferred on purging logs which is easy to find with a cursory keyword search.
|
|
|
Post by DragonSlayer2189 on Jul 13, 2020 16:49:42 GMT
ok because of this I decided to look at the plugin status and turns out we are indeed using SQLite for Core Protect (and only for that, TFM is using My SQL), i dont know if this is as easy as just changing a config value or if theres something more to it, but we should prob switch to something like MySQL for it
|
|
StevenNL2000
Forum Admin
Posts: 6,415
| Likes: 6,936
IGN: StevenNL2000
Timezone: UTC+01:00
Member is Staff. Need immediate assistance? Send a PM
|
Post by StevenNL2000 on Jul 13, 2020 18:12:07 GMT
ok because of this I decided to look at the plugin status and turns out we are indeed using SQLite for Core Protect (and only for that, TFM is using My SQL), i dont know if this is as easy as just changing a config value or if theres something more to it, but we should prob switch to something like MySQL for it This is in the config file: # MySQL is optional and not required. # If you prefer to use MySQL, enable the following and fill out the fields. use-mysql: true table-prefix: co_ mysql-host: 0.0.0.0 mysql-port: 3306 mysql-database: coreprotect mysql-username: totalfreedom mysql-password: <censored> It looks like MySQL is configured incorrectly. Notice the last line of these logs: [12:15:08] [Server thread/INFO]: [CoreProtect] Enabling CoreProtect v19.0 [12:15:09] [Server thread/INFO]: [CoreProtect] Unable to connect to MySQL server. [12:15:09] [Server thread/WARN]: java.sql.SQLException: null, message from server: "Host '176.9.64.37' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1031) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) [12:15:09] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [12:15:09] [Server thread/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [12:15:09] [Server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [12:15:09] [Server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) [12:15:09] [Server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) [12:15:09] [Server thread/WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:664) [12:15:09] [Server thread/WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:247) [12:15:09] [Server thread/WARN]: at net.coreprotect.database.Database.getConnection(Database.java:136) [12:15:09] [Server thread/WARN]: at net.coreprotect.Functions.createDatabaseTables(Functions.java:530) [12:15:09] [Server thread/WARN]: at net.coreprotect.config.ConfigHandler.loadDatabase(ConfigHandler.java:191) [12:15:09] [Server thread/WARN]: at net.coreprotect.config.ConfigHandler.performInitialization(ConfigHandler.java:348) [12:15:09] [Server thread/WARN]: at net.coreprotect.CoreProtect.onEnable(CoreProtect.java:72) [12:15:09] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:263) [12:15:09] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:380) [12:15:09] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:483) [12:15:09] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_16_R1.CraftServer.enablePlugin(CraftServer.java:500) [12:15:09] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_16_R1.CraftServer.enablePlugins(CraftServer.java:414) [12:15:09] [Server thread/WARN]: at net.minecraft.server.v1_16_R1.MinecraftServer.loadWorld(MinecraftServer.java:471) [12:15:09] [Server thread/WARN]: at net.minecraft.server.v1_16_R1.DedicatedServer.init(DedicatedServer.java:241) [12:15:09] [Server thread/WARN]: at net.minecraft.server.v1_16_R1.MinecraftServer.v(MinecraftServer.java:940) [12:15:09] [Server thread/WARN]: at net.minecraft.server.v1_16_R1.MinecraftServer.lambda$a$0(MinecraftServer.java:177) [12:15:09] [Server thread/WARN]: at java.lang.Thread.run(Thread.java:748) [12:15:09] [Server thread/INFO]: [CoreProtect] CoreProtect has been successfully enabled! [12:15:09] [Server thread/INFO]: [CoreProtect] Using SQLite for data storage.
|
|