• Trong thời gian này, bạn không thể tạo bài mới, đăng comment, hay tạo tài nguyên mới để diễn đàn dọn dẹp nội dung.
    Diễn đàn sẽ sớm mở trở lại, chi tiết hãy theo dõi tại Discord
TUANHP0

Web Authme + wordpress

  • Người tạo chủ đề Người tạo chủ đề TUANHP0
  • Ngày gửi Ngày gửi
mk có tạo database là home nhưng khi tạo tài khoản trên wordpress thì nó sẽ có user là 'wp_user'
còn authme sẽ tạo ra là authme (nếu mySQLTablename: 'authme')
Thì mk muốn cho cái authme và wp_user là 1 thì làm ntn ạ
mySQLTablename: 'wp_users' thì authme sẽ báo lỗi

---------------------------------------------------------

[10-03 23:27:42]: [INFO] Connection arguments loaded, Hikari ConnectionPool ready!
[10-03 23:27:44]: [WARN] Can't initialize the MySQL database: [MySQLSyntaxErrorException]: Specified key was too long; max key length is 767 bytes
[10-03 23:27:44]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
at fr.xephi.authme.libs.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:174)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
at java.lang.Thread.run(Unknown Source)

[10-03 23:27:44]: [WARN] Please check your database settings in the config.yml file!
[10-03 23:27:44]: [WARN] Could not create data source: [MySQLSyntaxErrorException]: Specified key was too long; max key length is 767 bytes
[10-03 23:27:44]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
at fr.xephi.authme.libs.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:174)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
at java.lang.Thread.run(Unknown Source)

[10-03 23:27:44]: [WARN] Aborting initialization of AuthMe: [IllegalStateException]: Error during initialization of data source
[10-03 23:27:44]: java.lang.IllegalStateException: Error during initialization of data source
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:52)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:26)
at fr.xephi.authme.libs.jalu.injector.handlers.provider.ProviderHandlerImpl$UninitializedProviderInstantiation.instantiateWith(ProviderHandlerImpl.java:141)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.instantiate(InjectorImpl.java:181)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.get(InjectorImpl.java:155)
at fr.xephi.authme.libs.jalu.injector.InjectorImpl.getSingleton(InjectorImpl.java:56)
at fr.xephi.authme.AuthMe.instantiateServices(AuthMe.java:246)
at fr.xephi.authme.AuthMe.initialize(AuthMe.java:221)
at fr.xephi.authme.AuthMe.onEnable(AuthMe.java:136)
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:335)
at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:356)
at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:316)
at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:402)
at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:370)
at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:325)
at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:211)
at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:505)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
at fr.xephi.authme.libs.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
at fr.xephi.authme.libs.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
at fr.xephi.authme.datasource.MySQL.checkTablesAndColumns(MySQL.java:174)
at fr.xephi.authme.datasource.MySQL.<init>(MySQL.java:69)
at fr.xephi.authme.initialization.DataSourceProvider.createDataSource(DataSourceProvider.java:72)
at fr.xephi.authme.initialization.DataSourceProvider.get(DataSourceProvider.java:49)
... 19 more

[10-03 23:27:44]: [WARN] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION!
[10-03 23:27:44]: [INFO] AuthMe 5.4.0-b1877 disabled!
 
10-03 23:27:44]: [WARN] Could not create data source: [MySQLSyntaxErrorException]: Specified key was too long; max key length is 767 bytes
[10-03 23:27:44]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
 
Cấu hình authme vào wp_users
nhớ chọn kiểu mã hóa password là wordpress
 
Nội dung tương tự Xem nhiều nhất Xem thêm

Thống kê nội dung

Tạo
TUANHP0,
Trả lời lần cuối từ
TUANHP0,
Trả lời
4
Lượt xem
1,395
Quay lại
Trên cùng