Inactive [ADMN/SEC] AuthDB v2.3.6 - Database authentication and protection [1.1-1.4.5]

Discussion in 'Inactive/Unsupported Plugins' started by CraftFire, Mar 13, 2011.

  1. Offline

    CraftFire

    In order to centralize support of our legacy projects, we will no longer be providing support on Bukkit. Please use www.spout.org for support with our projects going forward.
     
  2. Offline

    TheNsA

    Hello everyone,

    Here, since the upgrade from 2.3.0 -> 2.3.1, it is impossible to use the commands, even adding the permissions as shown in the wiki.

    in the console I get this error:

    CB : 1060

    Code:
    %
    2011-09-07 09:06:00 [INFO] pong MCMA
    2011-09-07 09:08:59 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'login' in plugin AuthDB v2.3.0.178
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:348)
            at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:737)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
            at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.NullPointerException
            at com.authdb.AuthDB.commandString(AuthDB.java:372)
            at com.authdb.AuthDB.onCommand(AuthDB.java:393)
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
            ... 12 more
    2011-09-07 09:09:04 [INFO] <.[31m[Admin]TheNsA.[37m> l.[0m
    2011-09-07 09:09:06 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'link' in plugin AuthDB v2.3.0.178
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:348)
            at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:737)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
            at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.NullPointerException
            at com.authdb.AuthDB.commandString(AuthDB.java:372)
            at com.authdb.AuthDB.onCommand(AuthDB.java:393)
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
            ... 12 more
    
     
  3. Offline

    contex

    You are not using the newest version.
    Download 2.3.1 and try again, if that doesnt work we will help you fix it :)
     
  4. Offline

    forceserver

    17:31:44 [INFO] Closing Connection[AuthDB.0] psReuse[24] psCreate[5] psSize[5]
    17:31:44 [SEVERE] Could not pass event PLAYER_LOGIN to AuthDB
    javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[[SQLITE_CONSTRAINT] Abort due to constraint violation (PRIMARY KEY must be unique)]
    at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:116)
    at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.insert(DmlBeanPersister.java:76)
    at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeInsertBean(DefaultPersistExecute.java:91)
    at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:527)
    at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:557)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.insert(DefaultPersister.java:404)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaInsert(DefaultPersister.java:377)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaRecurse(DefaultPersister.java:361)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(DefaultPersister.java:308)
    at com.avaje.ebeaninternal.server.persist.DefaultPersister.save(DefaultPersister.java:282)
    at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1577)
    at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1567)
    at com.authdb.util.databases.EBean.save(EBean.java:80)
    at com.authdb.util.databases.EBean.sync(EBean.java:98)
    at com.authdb.util.databases.EBean.sync(EBean.java:84)
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerLogin(AuthDBPlayerListener.java:64)
    at org.bukkit.plugin.java.JavaPluginLoader$13.execute(JavaPluginLoader.java:328)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    at net.minecraft.server.ServerConfigurationManager.a(ServerConfigurationManager.java:184)
    at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:82)
    at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
    at net.minecraft.server.Packet1Login.a(SourceFile:43)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.sql.SQLException: [SQLITE_CONSTRAINT] Abort due to constraint violation (PRIMARY KEY must be unique)
    at org.sqlite.DB.newSQLException(DB.java:383)
    at org.sqlite.DB.newSQLException(DB.java:387)
    at org.sqlite.DB.execute(DB.java:342)
    at org.sqlite.DB.executeUpdate(DB.java:363)
    at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:85)
    at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.executeUpdate(ExtendedPreparedStatement.java:164)
    at com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:74)
    at com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(InsertHandler.java:155)
    at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
    ... 28 more

    it don't save inventory T_T
     
  5. Offline

    TheNsA

    thank you
    I had forgotten to delete the old version
     
  6. Offline

    oglop

    Ubuntu linux
     
  7. Offline

    contex

    Is that for everyone or just for a new player?

    Glad you got it fixed :)
    Okay, I will start a VMware image later with Ubuntu and test.
     
  8. Offline

    forceserver

    when plugin update 2.4
    please add choice table rank....T_T......
    example
    table:member
    user=username
    password=password
    email=emailaddress
    table:rank
    table:group


    please.T_T
     
  9. Offline

    contex

    Rank? Could you explain a bit more?

    I well check more about that delay thing when I get home from work. Do you have access to your MySQL database with phpMyAdmin or any kind of MySQL browser? If so, could you give me the schema of the table "users", I think the problem is caused by the default value NOT being NULL.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Mar 26, 2019
  10. Offline

    IOn Vash

    the latest version for me wont let anyone register.

    Code:
    2011/09/07 08:16:58 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/09/07 08:16:58 - Class name: com.authdb.listeners.AuthDBPlayerListener
    2011/09/07 08:16:58 - File name: AuthDBPlayerListener.java
    2011/09/07 08:16:58 - Function name: onPlayerCommandPreprocess
    2011/09/07 08:16:58 - Error line: 409
    2011/09/07 08:16:58 - Script: phpbb
    2011/09/07 08:16:58 - Script version: 3.0.8
    2011/09/07 08:16:58 - Table prefix: phpbb_
    2011/09/07 08:16:58 - Keep alive: true
    2011/09/07 08:16:58 - MySQL connected: true
    2011/09/07 08:16:58 - Latest query: INSERT INTO `users` (`username`,`password`,`email`)  VALUES (testreg, e10adc3949ba59abbe56e057f20f883e, [email protected])
    2011/09/07 08:16:58 - Plugins: AutoAnnouncer 1.3-06.25, BigBrother 1.10.1-SNAPSHOT, BlockCantKeepUpSpam 0.1, ChopTree 1.24, Cleaner 1.8, Commands Logging 0.2, CommandBook 1.5.2-customized, EasyBan 1.7, FalseBookBlock 0.87alpha DEV#3, FalseBookChat 0.87alpha DEV#2, FalseBookCore 0.87alpha DEV#3, FalseBookIC 0.87alpha DEV#3, Fastgrow 1.4, HeavenlyMob 0.3, Help 0.2, LEPHome 0.1, NSCommand 0.2, OpenInv 1.3.3, OwnBlocksX 0.2.3, Permissions 2.5.5, Persistence 0.64, PlgDisableCmd 1.3, PlgWarp 2.2, properTime 1.8.9, RageQuit 0.3, RawcriticsOreObfuscationPlugin 1.6.4.4, SignLogger 1.2, SimpleHome 1.5, StopTalkingAutoBan 0.1, TreeAssist 1.1, Vault 1.0.0dev-b31, WorldEdit 4.6, WorldGuard 5.2.2, dynmap 0.21.1, iChat 2.3.3, LWC 3.3, AuthDB 2.3.1.200, NoCheat 1.14f,
    2011/09/07 08:16:58 - --------------------------- STACKTRACE START ---------------------------
    2011/09/07 08:16:58 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    2011/09/07 08:16:58 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011/09/07 08:16:58 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011/09/07 08:16:58 - com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011/09/07 08:16:58 - com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011/09/07 08:16:58 - com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011/09/07 08:16:58 - com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011/09/07 08:16:58 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2011/09/07 08:16:58 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2011/09/07 08:16:58 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2011/09/07 08:16:58 - com.authdb.scripts.Custom.adduser(Custom.java:46)
    2011/09/07 08:16:58 - com.authdb.util.Util.checkScript(Util.java:114)
    2011/09/07 08:16:58 - com.authdb.AuthDB.register(AuthDB.java:655)
    2011/09/07 08:16:58 - com.authdb.listeners.AuthDBPlayerListener.onPlayerCommandPreprocess(AuthDBPlayerListener.java:395)
    2011/09/07 08:16:58 - org.bukkit.plugin.java.JavaPluginLoader$5.execute(JavaPluginLoader.java:272)
    2011/09/07 08:16:58 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/09/07 08:16:58 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/09/07 08:16:58 - net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:730)
    2011/09/07 08:16:58 - net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
    2011/09/07 08:16:58 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
    2011/09/07 08:16:58 - net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    2011/09/07 08:16:58 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/09/07 08:16:58 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    2011/09/07 08:16:58 - net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011/09/07 08:16:58 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    2011/09/07 08:16:58 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/09/07 08:16:58 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/09/07 08:16:58 - ---------------------------- STACKTRACE END ----------------------------
     
  11. Offline

    contex

    It seems like the MySQL query is failing, could you test build #216: http://ci.craftfire.com/job/AuthDB/216/ and see if that works.

    Could you execute this MySQL query through your MySQL browser:
    INSERT INTO `users` (`username`,`password`,`email`) VALUES ('testreg', 'e10adc3949ba59abbe56e057f20f883e', '[email protected]')

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 6, 2019
  12. Offline

    IOn Vash

  13. Offline

    contex

    Strange, I think I might know whats wrong. Could you test http://ci.craftfire.com/job/AuthDB/217 once it is done building and give me the stacktrace again?

    Thank you :)
     
  14. Offline

    IOn Vash

    here

    Code:
    2011/09/07 08:51:16 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/09/07 08:51:16 - Class name: com.authdb.listeners.AuthDBPlayerListener
    2011/09/07 08:51:16 - File name: AuthDBPlayerListener.java
    2011/09/07 08:51:16 - Function name: onPlayerCommandPreprocess
    2011/09/07 08:51:16 - Error line: 420
    2011/09/07 08:51:16 - AuthDB version: 2.3.1.217
    2011/09/07 08:51:16 - Script: Custom
    2011/09/07 08:51:16 - Custom table: users
    2011/09/07 08:51:16 - Custom passfield: password
    2011/09/07 08:51:16 - Custom userfield: username
    2011/09/07 08:51:16 - Custom encryption: md5
    2011/09/07 08:51:16 - Custom table schema:
    2011/09/07 08:51:16 - Table Name : users
    2011/09/07 08:51:16 - Field     size    DataType
    2011/09/07 08:51:16 - id
    2011/09/07 08:51:16 - 4
    2011/09/07 08:51:16 - INT
    2011/09/07 08:51:16 - username
    2011/09/07 08:51:16 - 40
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - password
    2011/09/07 08:51:16 - 40
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - email
    2011/09/07 08:51:16 - 100
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - linkedname
    2011/09/07 08:51:16 - 255
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - salt
    2011/09/07 08:51:16 - 255
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - ip
    2011/09/07 08:51:16 - 255
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - inventory
    2011/09/07 08:51:16 - 255
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - equipment
    2011/09/07 08:51:16 - 255
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - activated
    2011/09/07 08:51:16 - 45
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - authorized
    2011/09/07 08:51:16 - 45
    2011/09/07 08:51:16 - VARCHAR
    2011/09/07 08:51:16 - timeoutid
    2011/09/07 08:51:16 - 11
    2011/09/07 08:51:16 - INT
    2011/09/07 08:51:16 - reloadtime
    2011/09/07 08:51:16 - 20
    2011/09/07 08:51:16 - BIGINT
    2011/09/07 08:51:16 - sessiontime
    2011/09/07 08:51:16 - 20
    2011/09/07 08:51:16 - BIGINT
    2011/09/07 08:51:16 - Keep alive: true
    2011/09/07 08:51:16 - MySQL connection: true
    2011/09/07 08:51:16 - Latest query: SELECT * FROM users
    2011/09/07 08:51:16 - Plugins: AutoAnnouncer 1.3-06.25, BigBrother 1.10.1-SNAPSHOT, BlockCantKeepUpSpam 0.1, ChopTree 1.24, Cleaner 1.8, Commands Logging 0.2, CommandBook 1.5.2-customized, EasyBan 1.7, FalseBookBlock 0.87alpha DEV#3, FalseBookChat 0.87alpha DEV#2, FalseBookCore 0.87alpha DEV#3, FalseBookIC 0.87alpha DEV#3, Fastgrow 1.4, HeavenlyMob 0.3, Help 0.2, LEPHome 0.1, NSCommand 0.2, OpenInv 1.3.3, OwnBlocksX 0.2.3, Permissions 2.5.5, Persistence 0.64, PlgDisableCmd 1.3, PlgWarp 2.2, properTime 1.8.9, RageQuit 0.3, RawcriticsOreObfuscationPlugin 1.6.4.4, SignLogger 1.2, SimpleHome 1.5, StopTalkingAutoBan 0.1, TreeAssist 1.1, Vault 1.0.0dev-b31, WorldEdit 4.6, WorldGuard 5.2.2, dynmap 0.21.1, iChat 2.3.3, LWC 3.3, AuthDB 2.3.1.217, NoCheat 1.14f,
    2011/09/07 08:51:16 - --------------------------- STACKTRACE START ---------------------------
    2011/09/07 08:51:16 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    2011/09/07 08:51:16 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011/09/07 08:51:16 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011/09/07 08:51:16 - com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011/09/07 08:51:16 - com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011/09/07 08:51:16 - com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011/09/07 08:51:16 - com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011/09/07 08:51:16 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2011/09/07 08:51:16 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2011/09/07 08:51:16 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2011/09/07 08:51:16 - com.authdb.scripts.Custom.adduser(Custom.java:52)
    2011/09/07 08:51:16 - com.authdb.util.Util.checkScript(Util.java:119)
    2011/09/07 08:51:16 - com.authdb.AuthDB.register(AuthDB.java:649)
    2011/09/07 08:51:16 - com.authdb.listeners.AuthDBPlayerListener.onPlayerCommandPreprocess(AuthDBPlayerListener.java:406)
    2011/09/07 08:51:16 - org.bukkit.plugin.java.JavaPluginLoader$5.execute(JavaPluginLoader.java:272)
    2011/09/07 08:51:16 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/09/07 08:51:16 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/09/07 08:51:16 - net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:730)
    2011/09/07 08:51:16 - net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
    2011/09/07 08:51:16 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
    2011/09/07 08:51:16 - net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    2011/09/07 08:51:16 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/09/07 08:51:16 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    2011/09/07 08:51:16 - net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011/09/07 08:51:16 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    2011/09/07 08:51:16 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/09/07 08:51:16 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/09/07 08:51:16 - ---------------------------- STACKTRACE END ----------------------------
    I also noticed that the message telling players is not being delayed like it should be in the settings. So it ends up on top and no one sees it.
     
  15. Offline

    IOn Vash

    Ya I do and the default value of everything is null
     
  16. Offline

    Wulfspider

    He's wanting us to add support for more custom fields because I think he's trying to make XpressEngine work through customdb...
     
  17. Offline

    IOn Vash

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `users` (`username`,`password`,`email`) VALUES ('testreg', 'e10adc39' at line 1
     
  18. Offline

    Wulfspider

    You can have spaces.
     
  19. Offline

    IOn Vash

    ya i realized that after i posted lol

    I tried adding the data manually and it gave me this error.

    Field 'linkedname' doesn't have a default value

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  20. Offline

    Wulfspider

    Did you modify bukkit.yml to store in MySQL instead of eBeans?

    Could you show me your bukkit.yml from the root of your server and basic.yml and advanced.yml from AuthDB?
     
  21. Offline

    IOn Vash

    its set to use MySQL because people can login just fine but no one can register
     
  22. Offline

    Wulfspider

    Can I please see them? Right now you are basically storing twice in MySQL because of those settings. AuthDB was meant to store locally in eBeans as a cache, and the way you have it setup, it's storing in the database table you have set in AuthDB + the table you have setup in bukkit.yml.
     
  23. Offline

    IOn Vash

    bukkit.yml
    Code:
    database:
        username: ******
        isolation: SERIALIZABLE
        driver: com.mysql.jdbc.Driver
        password: ******
        url: jdbc:mysql://localhost/minecraft
    settings:
        update-folder: update
        spawn-radius: 5
        permissions-file: permissions.yml
    aliases:
        icanhasbukkit:
        - version
    

    advanced.yml
    Code:
    customdb:
      enabled: true                                   # Enable/disable custom database support. Leave this disabled if using a script such as phpBB.
      autocreate: true                                 # Enable/disable automatic creation of the database tables and columns for a custom database.
      table: users                              # Table name to use for your custom database.
      userfield: username                              # Field/column name to use for storing user names.
      passfield: password                              # Field/column name to use for storing user passwords.
      emailfield: email                                # Field/column name to use for storing user email addresses. Leave blank to disable email requirement.
      emailrequired: false                             # Enable/disable registration email requirement.
      encryption: md5                                  # Encription type to use for password hashing. Options are MD5, SHA1, and SHA512.
    #  saltfield: salt                                  # NOT IMPLEMENTED YET! Field/column name to use for storing the passwordsalt.
    #  hashformat: "{PASSWORD}{SALT}{NAME}"             # NOT IMPLEMENTED YET! Format/layout to use for the password hash.
    register:
      enabled: true                                    # Enable/disable allowing users to register.
      force: true                                      # Enable/disable forcing users to register.
      delay: 10 seconds                                 # Amount of time before register message is shown to player.
      timeout: 3 minutes                               # Amount of time a player has to register before the configured action is taken.
    login:
    #  enabled: true                                    # NOT IMPLEMENTED YET! Enable/disable players being able to login.
      method: prompt                                   # Login method to use. Options are normal and prompt.
      delay: 10 seconds                                 # Amount of time before login message is shown to player.
      timeout: 3 minutes                               # Amount of time a player has to login before the configured action is taken.
      tries: 3                                         # Number of allowed incorrect password tries.
      action: kick                                     # Action to perform when a maximum number of password tries is reached. Currently only option is kick.
    link:
      enabled: true                                    # Enable/disable username linking.
      rename: true                                     # Enable/disable renaming users to linked name on link.
    unlink:
      enabled: true                                    # Enable/disable username unlinking.
      rename: true                                     # Enable/disable renaming users to original name on unlink.
    username:
      minimum: 3                                       # Minimum number of characters a username can be.
      maximum: 16                                      # Maximum number of characters a username can be.
    password:
      minimum: 6                                       # Minimum number of characters a password can be.
      maximum: 16                                      # Maximum number of characters a password can be.
    session:
      enabled: true                                    # Enable/disable player sessions.
      start: login                                     # When to start the player's session. Options are login and logoff.
      length: 1 hour                                   # Length of the player's session. Can be any number of seconds, minutes, hours, or days.
      protect: true                                    # Enable/disable protecting player from being logged out from another location.
    guest:
      commands: false                                  # Enable/disable guest commands.
      chat: false                                      # Enable/disable guest chat.
      building: false                                  # Enable/disable guest building.
      destruction: false                               # Enable/disable guest destruction.
      movement: false                                  # Enable/disable guest movement.
      interactions: false                              # Enable/disable guest interactions with objects.
      inventory: false                                 # Enable/disable guest inventory usage.
      drop: false                                      # Enable/disable guest being able to drop items.
      pickup: false                                    # Enable/disable guest being able to pickup items.
      health: false                                    # Enable/disable guest getting hurt.
      pvp: false                                       # Enable/disable guest hurting players.
      mobtargeting: false                              # Enable/disable mobs targeting guest.
      mobdamage: false                                 # Enable/disable mob damage from guest.
    protection:
      freeze:
        enabled: true                                  # Enable/disable freezing players on join to prevent movement.
        delay: 2 seconds                               # Amount of time before players are frozen and unable to move.
      notify:
        enabled: true                                  # Enable/disable protection message being sent to player.
        delay: 3 seconds                               # Amount of time before protection message can be sent to player again.
    filter:
      action: kick                                     # Action to perform when a username matches the filter. Options are kick and rename.
      username: "`~!@#$%^&*()-=+{[]}|\\:;\"<,>.?/ "    # Characters and symbols to check for in usernames. We recommend leaving this as is.
      password: "$&\\\""                               # Characters and symbols to check for in passwords. We recommend leaving this as is.
      whitelist:                      # Usernames to exclude from username and password filtering.
    

    basic.yml
    Code:
    plugin:
      language: English                                # Language you want to use that matches a directory under translations.
      debugmode: false                                 # Enable/disable debugging mode and additional console output.
      usagestats: true                                 # Enable/disable usage stats reporting to CraftFire devs.
      logging: true                                    # Enable/disable logging to files.
      logformat: yyyy-MM-dd                            # Filename format of the AuthDB debug and error log files.
    database:
      type: mysql                                      # Database type/driver to use. Current options are MySQL and eBean (Bukkit persistence).
      host: localhost                                  # MySQL server hostname, domain, IP, or localhost for local connections. MySQL only.
      port: 3306                                       # Port used for connecting to your MySQL server. This is usually 3306. MySQL only.
      username: ******                                   # Username used to connect to your database. Only valid for MySQL.
      password: ******                                   # Password used to connect to your database. MySQL only.
      name: minecraft                                      # Name of the database you are connecting to. MySQL only.
      keepalive: true                                  # Enable/disable keeping database connection alive. MySQL only.
    script:
      name: phpBB                                      # Name of the script you are using.
      version: 3.0.8                                   # Version of the script you are using.
      tableprefix: phpbb_                              # Database table prefix for the script, if you use one.
    #  passwordsalt:                                    # NOT IMPLEMENTED YET! Unique/custom password salt, if needed by the script.
    
    Ive been using the same settings and database for a long time now and never had a problem until I updated today.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  24. Offline

    Wulfspider

    It's just silly that you are inserting twice into MySQL. Do you have 2 tables in your database, authdb_users and users?
     
  25. Offline

    IOn Vash

    no
     
  26. Offline

    contex

    Did you by any chance rename the table from "authdb_users" to "users"?
     
  27. Offline

    oglop

    Hello this happened me right now, is problem in my database or in authDB (restart didn't helepd) bild #216

    Show Spoiler

    2011/09/07 16:55:32 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:32 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:55:32 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:32 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:55:32 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:32 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:55:32 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:32 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:55:32 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:32 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:55:32 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:32 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:55:32 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:32 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:55:32 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:32 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:55:48 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:55:48 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:56:27 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:56:27 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:57:54 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:57:54 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:57:54 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:57:54 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:57:54 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:57:54 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:57:54 - Cannot connect to MySQL server on localhost!
    2011/09/07 16:57:54 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    2011/09/07 16:57:55 - Cannot connect to MySQL server on localhost!
     
  28. Offline

    Black_Jack

    Any solution for "You are not authorized to do that" and "You have no permission for this command" at /login password?
     
  29. Offline

    IOn Vash

    back when i first started using the plugin ya i did.

    Ya IDK I fixed it, and I'm not sure how but its working with my old database again.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Oct 10, 2018
  30. Offline

    contex


    It seems like AuthDB is not able to connect to the database, are you sure the MySQL server is up and running?

    You are not authorized to do that is a message when a player tries to move/lookaround/chat etc while not authorized. "No permission" message is cause the user needs permissions to use the command, are you using any type of Permission system? If so give the default user this permission: "authdb.command.user.*". Check http://wiki.bukkit.org/AuthDB/Permissions for more nodes.
     
  31. Offline

    Wulfspider

    You are not authorized to do that" is something to do with the freezing of the user. Ignore it as we are trying to work on a better fix so you don't see it right away at login unless you actually move.

    The permission message is because you need to assign permissions to that group. authdb.command.user.login and such. PermissionsBukkit should use the defaults that are set in plugin.yml, but I don't think older plugins such as Permissions 3.x do.
     

Share This Page