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

    fragger505

    @Wulfspider
    Was glancing at your roadmap for 2.3.2 and it was probably just a typo, but it should be.
    guest: mobdamage: true
     
  3. Offline

    Wulfspider

    Yup, was a mistake. Fixed.
     
  4. Offline

    Curthiany

    @Wulfspider
    hey i thought when someone logout/login it doesnt lag anymore???
    i'm still getting some lag
    is it cause keepalive: false ??
     
  5. Offline

    contex

    keepalive: false means that when performing a MySQL query, it will connect and close the connection after each query. That is why we have th eoption to have keepalive: true; but this is only for those who have an user that can have unlimited connections.
     
  6. Offline

    Curthiany

    Unlimited Connection Meaning? server slots?.... can you explain why everytime someone joins and leaves server , the server gets a lag spike and a cant keep up message appears?
     
  7. Offline

    Wulfspider

    What are the specs of your server?

    He meant your MySQL server allowing for A LOT of connections at one time. Most don't.
     
  8. Offline

    Curthiany

    Ohhh yes my MySQL supports many connections.. But is that what's causing the lag?

    Edit 2: How Many Connections is it exactly?.... Also Just Asked My Server Provider and he says its unlimited.
     
  9. Offline

    Wulfspider

    Shouldn't be. When is it lagging and what is it doing? What are your server specs?
     
  10. Offline

    Curthiany

    When Someone Joins it Lags.. When Someone Leaves.. it Lag..
    Server Specs are not exact but this is what i get

    1024 gb
    24 slots
    Cpu has 4 cores i believe..

    I cant Get an Exacty Cause he doesn't release the full specs in public..my server provider... if you want to know which my provider is its DevilDogsHosting
     
  11. Offline

    dawon

    Testing 2.3.1 and still getting http://pastebin.com/y7QvhfWS error after firts login... I've deleted AuthDB.db...

    Otherwise not having any other issues, thanks!
     
  12. Offline

    contex

    It shouldnt lag, it takes about 1-3 second for a player to join cause its syncing information from the MySQL, same with during /login. However when someone leaves it shouldnt lag.
    1GB ram should be enough. How is the server performing without AuthDB?

    At work atm and my pc at home is broken. I will check it during lunch time :), I think we missed that issue.
     
  13. Offline

    forceserver

    i am using spout so i download auth-dev lasted
    however error massge

    18:00:09 [SEVERE] Could not pass event PLAYER_LOGIN to AuthDB
    java.lang.NullPointerException
    at org.bukkit.craftbukkit.entity.CraftPlayer.getAddress(CraftPlayer.java:61)
    at com.craftfire.util.managers.PlayerManager.getIP(PlayerManager.java:171)
    at com.authdb.util.Util.replaceStrings(Util.java:1221)
    at com.authdb.util.Messages.sendMessage(Messages.java:364)
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerLogin(AuthDBPlayerListener.java:75)
    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)
    18:00:09 [INFO] Nomoohyun [/211.117.131.102:2617] logged in with entity id 61 at ([world] -753.125, 52.0, 96.25)
    18:00:10 [INFO] [MultiInv] Shared worlds loaded with no errors
    18:00:11 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    18:00:11 [INFO] Reading data
    18:00:11 [INFO] [Spout] Successfully authenticated Nomoohyun's Spoutcraft client. Running client version: 1.0.5.262
    >

    please tell me what can i do?
     
  14. Offline

    contex

    Are you using 2.3.1?
    If so, show me your config.
     
    forceserver likes this.
  15. Offline

    forceserver

    ---------------------------------------------------------------------------------------------------------------------------------------------------
    advanced.yml
    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: xe_member # Table name to use for your custom database.
    userfield: user_id # Field/column name to use for storing user names.
    passfield: password # Field/column name to use for storing user passwords.
    emailfield: email_address # Field/column name to use for storing u
    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: false # Enable/disable allowing users to register.
    force: false # Enable/disable forcing users to register.
    delay: 4 seconds # Amount of time before register message is shown to player.
    timeout: 3 minutes # Amount of time a playerh as 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: 4 seconds # Amount of time before login messaage 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: false # Enable/disable username linking.
    rename: false # Enable/disable renaming users to linked name on link.
    unlink:
    enabled: false # Enable/disable username unlinking.
    rename: false # Enable/disable renaming users to original name on unlink.
    username:
    minimum: 3 # Minumum number of characters a username can be.
    maximum: 16 # Maximum number of characters a username can be.
    password:
    minimum: 6 # Minumum 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: Contex,Wulfspider # Usernames to exclude from username and password filtering.




    --------------------------------------------------------------------------------------------------------------------------------------------------------
    basic.yml
    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: root # Username used to connect to your database. Only valid for MySQL.
    password: ******* # Password used to connect to your dat
    name: linux # 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.

    i join nomoohyun
    my forum is uning Xpreessengine
    this error reason is that ?
    my bukkit verssion 1060 i use spout ..

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

    contex

    Are you using AuthDB 2.3.1?
     
  17. Offline

    forceserver

    yes i using authdb 2.3.1
    are you qusetion is useing lasted version ??
    i am using lasted authdb-dev
     
  18. Offline

    contex

    What username are you using when joining?
     
  19. Offline

    Zero9195

    @contex
    Everything works now. Thank you :)
    Also, AuthDB works with phpBB3 v3.0.9, I let you know so ou can ad it to the list ;)
     
  20. Offline

    contex

    Thanks :) Updated the range.

    Could you test build 210 for me: http://ci.craftfire.com/job/AuthDB/210/

    Strange. Could you test with http://ci.craftfire.com/job/AuthDB/210/ ?

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

    forceserver

  22. Offline

    Black_Jack

    Does not fixed with last(3 hours ago) development build.
    Code:
    2011-09-05 17:00:15 [INFO] MrYadro [/109.174.64.44:50197] logged in with entity id 6021 at ([Main] -162.125, 5.0, 133.59375)
    2011-09-05 17:00:15 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-09-05 17:00:15 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-09-05 17:00:15 [WARNING] [AuthDB] File name: AuthDB.java
    2011-09-05 17:00:15 [WARNING] [AuthDB] Function name: isRegistered
    2011-09-05 17:00:15 [WARNING] [AuthDB] Error line: 830
    2011-09-05 17:00:15 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-09-05-error.log
    2011-09-05 17:00:15 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERRORS IN CHECKING USER. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    2011-09-05 17:00:15 [INFO] [AuthDB] 2.3.1.207 has been disabled
    2011-09-05 17:00:15 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-09-05 17:00:15 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-09-05 17:00:15 [WARNING] [AuthDB] File name: AuthDB.java
    2011-09-05 17:00:15 [WARNING] [AuthDB] Function name: isRegistered
    2011-09-05 17:00:15 [WARNING] [AuthDB] Error line: 830
    2011-09-05 17:00:15 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-09-05-error.log
    2011-09-05 17:00:15 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERRORS IN CHECKING USER. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    2011-09-05 17:00:15 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-09-05 17:00:15 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-09-05 17:00:15 [WARNING] [AuthDB] File name: AuthDB.java
    2011-09-05 17:00:15 [WARNING] [AuthDB] Function name: isRegistered
    2011-09-05 17:00:15 [WARNING] [AuthDB] Error line: 774
    2011-09-05 17:00:15 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-09-05-error.log
    2011-09-05 17:00:15 [INFO] connect from ip 109.174.64.44
    2011-09-05 17:00:30 [INFO] MrYadro lost connection: disconnect.quitting
    
    Trying to test it with 210 build right now
     
  23. Offline

    contex

    Could you give the the error.log file?

    When does it not save inventory?

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

    forceserver

    it doesn't save when rejoin or server reboot
    NOT Always
    just sometimes
     
  25. Offline

    contex

    That is not normal, inventory should be fixed and I dont see why you are having a problem with it.
    Could you do me a favour and tell me what kind of plugins you are using?
     
  26. Offline

    Black_Jack

    Hmm, okay.
    I have found another strange error
    Code:
    17:10:36 [INFO] Disconnecting MrYadro [/109.174.64.44:55068]: Kicked because username contains bad characters. `~!@#$%^&*()-=+{[]}|\:;"<,>.?/ !
    
    error.log is included in attachements
     

    Attached Files:

  27. Offline

    contex

    Doesnt look like you are using the newest version, could you try 3.2.1?
     
  28. Offline

    Wulfspider

    Yeah, I just got this again with my testing. It just seems to be after first login of each player like you said. Doesn't seem to affect anything, but we'll see if we can get a fix for it.

    I would stick to using the version that is linked from the original post, not a dev version right now.
    Also, we do not know if XpressEngine works under customdb because we haven't looked at how it encrypts the passwords yet. So that may be part of the cause.

    I'd stick to using v2.3.1 linked on the original post of this thread instead of the dev versions right now.

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

    dawon

    Iteresting, it started kicking players because of bad Characters in their nicks, but they was connecting normally before (and even when I add them into whitelist...)

    Was using newest devbuild, downgraded to 2.3.1 and its ok now...
     
  30. Offline

    Wulfspider

    It should be fixed now. Silly mistake on my part while cleaning things up last night. :)
     
  31. Offline

    dawon

    Yep, it seems to be fixed, thank you!
     

Share This Page