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

    BioBG

    2012-01-26 17:26:26 [SEVERE] Could not pass event org.bukkit.event.player.PlayerQuitEvent to AuthDB
    javax.persistence.PersistenceException: java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned. No connections are free. You need to Increase the max connections of [20] or look for a connection pool leak using datasource.xxx.capturestacktrace=true
    at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
    at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
    at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
    at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:57)
    at com.authdb.AuthDB.isRegistered(AuthDB.java:757)
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerQuit(AuthDBPlayerListener.java:273)
    at org.bukkit.plugin.java.JavaPluginLoader$2.execute(JavaPluginLoader.java:277)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:57)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:453)
    at net.minecraft.server.ServerConfigurationManager.disconnect(ServerConfigurationManager.java:161)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:660)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:231)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:100)
    at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:587)
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:536)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:434)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
    Caused by: java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned. No connections are free. You need to Increase the max connections of [20] or look for a connection pool leak using datasource.xxx.capturestacktrace=true
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
    at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
    ... 21 more


    ??
     
  3. Offline

    dragonhib

    How possible people don't read a few posts above before post that ??
    So project is still active, but development takes time, and time is the thing most lacking
     
  4. Offline

    EnigmA-X

    I did a clean install of AuthDB today, using customdb settings on CraftBukkit 1.1

    The default setting of AuthDB is:

    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

    What I have tested:

    Without registered account
    With the default setting, the first session will be kicked if you join with another session using the same username. The second session is unable to do anything, so nothing appears to be bypassed. As far as I can see, the protection does not work, because the user is not registered.

    With registered account, logged in
    Now, first client is logged in. Second client joining is not working, the first client is protected properly.

    With registered account, logged out
    First client is connected, waiting for password. After second client connects, first client is kicked as it is not logged in, thus not protected.

    All together, with the default settings it looks pretty safe to me. I guess you have changed another setting as well in your configuration and forgot to mention it here.
     
  5. Offline

    Wulfspider

    Yes, but we've just been busy lately. Contex and I are working on some fixes for it right now before starting a complete rewrite for AuthDB 3.0.

    Yes, it's still active and hopefully we'll get a couple guys to help out soon.

    Do you have keepalive: true under your basic.yml? If so, I suggest disabling it.

    Fixed in an upcoming build.

    Fixed in an upcoming build.

    The first is fixed in an upcoming build.
    The second I was unable to reproduce.

    Fixed in an upcoming build.

    The first I was unable to reproduce, the second was the same as the one that was already fixed.

    AuthDB v2.3.3 released!
    Download latest released ZIP bundle or JAR only

    I apologize for the delay in getting these fixes in. Contex and I knocked out a few tonight and hopefully some issues fixed within the next few days.

    Changes:
    • Changed from CC license to LGPLv3
    • Fixed enchantments not saving after logout
    • Fixed register and login timeout kick messages not working
    • Fixed critical bug where user could login as admin when session start set to logoff
    • Fixed error in console when IP could not be detected
    • Removed BukkitContrib and Spout dependencies and code
    • Updated license headers in all Java source
    • Updated pom.xml with new license information and other misc changes

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

    TobyG123

    No XenForo bug fix ^^^^ *sniff* *sniff*
     
  7. Offline

    The Wizard

    Was this added "Importing of other auth plugin databases such as AuthMe, xAuth, and possibly more."?
     
  8. Offline

    Wulfspider

    No. That likely won't happen for awhile. We're planning a complete rewrite after some bug fixes.

    Soon. This update was just to get some of the more major bugs resolved.

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

    KremeChoco

    So for
    " host: localhost # MySQL server hostname, domain, IP, or localhost for local connections. MySQL only."

    What do I put if it's a remote connection?
    example:
    NamecheapHoster, domain.com, 23.434.4.3
    ? Just like that?
     
  10. Offline

    Everlong

    Only need one, 23.434.4.3 for example.
     
  11. Offline

    gamerantonlol

    Can Someone tell me How to set up AuthDB with Vbulletin 4.0.4
    Use Bukkit 1.0.1 R2
     
  12. Offline

    Wulfspider

    I should probably remove server hostname, as it's not really a valid option. ^_^
    You only need one of the other options though depending on what you are using and have available.

    Under basic.yml

    Change the following lines:

    script: vbulletin
    version: 4.0.4
    prefix: whateveryouhaveset_ (typically vb_)

    The rest of the configuration is the remaining MySQL settings such as database, username, and password which are unique to you.

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

    gamerantonlol

    Ok i´ve check that but still no reason i have tried the Coustom Database option, but the problem is VB 4.0.4 uses MD5+Salt so i dont know wich salt can you explain me if you can??
     
  14. Offline

    Wulfspider

    You do not use or even touch the custom database option when using it with vBulletin. That should be disabled unless you are connecting to a CUSTOM database such as one that was made for a basic PHP script and such.
     
  15. Offline

    gamerantonlol

    can you send me your Config.yml file i do not understand!
     
  16. Offline

    gamerantonlol

    22:29:10 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERRORS IN CHECKING USER. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    22:29:10 [INFO] [AuthDB] Unloading AuthDB v2.3.3.228.
    22:29:10 [INFO] [AuthDB] 2.3.3.228 has been disabled
    22:29:10 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    22:29:10 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    22:29:10 [WARNING] [AuthDB] File name: AuthDB.java
    22:29:10 [WARNING] [AuthDB] Function name: isRegistered
    22:29:10 [WARNING] [AuthDB] Error line: 797
    22:29:10 [WARNING] [AuthDB] Check log file: plugins\AuthDB\logs\error\01-02-2012
    -error.log
    22:29:10 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERRORS IN CHECKING USER. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    22:29:10 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    22:29:10 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    22:29:10 [WARNING] [AuthDB] File name: AuthDB.java
    22:29:10 [WARNING] [AuthDB] Function name: isRegistered
    22:29:10 [WARNING] [AuthDB] Error line: 741
    22:29:10 [WARNING] [AuthDB] Check log file: plugins\AuthDB\logs\error\01-02-2012
    -error.log

    i have upload the error Report!
     

    Attached Files:

  17. Offline

    Wulfspider

    You can show me your basic.yml and advanced.yml and I can show you what you did wrong. Use www.pastie.org and hide the username password information.
     
  18. Offline

    PinguinAman

    Hi,
    I installed AuthDB a few hours ago and I'm getting the following error kinda randomly:
    http://dev.bukkit.org/paste/lm4gvzq5xjehd1p0/

    Most of the time it occurs, it is because someone joined the server.
    Although it happened once without someone joining, too.

    basic.yml:
    http://dev.bukkit.org/paste/tyufxnpzqwlir6dh/
    advanced.yml:
    http://dev.bukkit.org/paste/qsyfcvuw7r58edbn/

    I'm hoping for a quick solution since it's very unstable like that. :/

    Seems to be the same problem gamerantonlol has.
     
  19. Offline

    Wulfspider

    It's not the same issue gamerantonlol is having, they can't figure out how to configure it correctly, your error is due to MySQL having issues. I suggest turning keepalive to false and trying that.
     
  20. Offline

    DeltaDevil

    I seem to have the very same problem.
     
  21. Offline

    Wulfspider

    Your problem is with MyBB, entirely different script and issue. ;)
    Looking into things now.
     
  22. Offline

    theask

    Hey Wulfspider...

    After install the new Version I see that the Inventory have only one bug...
    If I have a enchanted Weapon the Inventory it is Empty after a Logout...
    Whats Wrong?
     
  23. Offline

    TobyG123

    **Whistles a tune....*** ;)
     
  24. Offline

    Wulfspider

    We tested it and never had that happen. If you can give us exact steps to reproduce, that would be helpful.
     
  25. Offline

    TobyG123

    Don't forget the XenForo script....
     
  26. Offline

    IJosephI

    I had huge problems using your plugin and joomla 1.7.0 together. AuthDB said that passwords was wrong but it was strange because i set in authdb config hash type - md5 and joomla uses it too.
    So i had a lot of hours boiling my brain...

    At the end i installed joomla 1.5.23, set script for authdb to joomla 1.5.23 and all started to work perfect.

    So why i just said all that before? - Please add script for Joomla 1.7.0
     
  27. Offline

    KremeChoco

    Silly question, but has anyone got this to work with vB 4.1.10?
     
  28. Offline

    theask

    I have download the new Version and put it to the Plugins folder...
    Have I to do new Config files?

    EDIT Ahh and I use Multiinv too... Try Multiverse Inventorys...?
     
  29. Offline

    Wulfspider

    Yeah, we'll have to add something just for MultiInv most likely as we have with others in the past.
     
  30. Offline

    fragger505

    So any idea when we will actually get the Groups plugin? Last time that I've checked in it was scheduled for release back in either October or November. :(
     
  31. Offline

    Wulfspider

    Not likely anytime soon as there are other things that need to be done first.
     

Share This Page