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

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.​

 

@Wulfspider
@contex

with buil 181 the lose of inventory occuring and i have this error:

Code:

[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:79)
    at com.authdb.util.databases.EBean.sync(EBean.java:97)
    at com.authdb.util.databases.EBean.sync(EBean.java:83)
    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

 

ok i'll do that
cause i seriously dont want to put this on my live server... if that happens

Edit: Also what would be cool if you guys add a feature where if Register=False there will be a diffrent message output when someone logs in not registered? like Please Register At <website> to access the Server.. Custom Message

 

Current view of plugin dir http://s47.radikal.ru/i116/1108/b4/920f08e3c91c.png

 

Already in the bug list, but thanks for confirming

Don't test it on your live server, cause currently there are a few bugs we have to fix.
Also, I will ask @Wulfspider to add a message for that, thank you for the idea.

 

Trying 181 and still getting "Could not pass ...." after first login and losing inventory...

Same as @Massimo1993

 

Glad To Help..... ok well i tried /logout then /login <password> my inventory didnt wipe....
i force crash my local server and it wiped my inventory i think thats what its suppose to do.. i guess lol

Edit: Not Getting Any Errors When i Login nor losing inventory..... but i have one question
when i upgrade my live server from authdb 2.2.0 - 2.3.0 since the file "PlayerName_inv" will everyone lose their inventory that way? should i tell them to clear inventory before switching?

Edit 2:Also maybe from the bugs located on top list your
plugins ran with authdb

Edit 3: Build 181 :Ok well i tried set my character have full inventory of cobblestone i typed /logout... Crashed the Server without saving... ran the server again.... Typed /login <password> and my cobblestone is still there

 

More errors..

Code:

2011-08-31 23:41:30 [INFO] [AuthDB] Launching function: replaceStrings(String string, Player player, String additional)
2011-08-31 23:41:30 [SEVERE] Could not pass event ENTITY_DAMAGE to AuthDB
java.lang.NullPointerException
at com.craftfire.util.managers.PlayerManager.getIP(PlayerManager.java:163)
at com.authdb.util.Util.replaceStrings(Util.java:1083)
at com.authdb.util.Messages.sendMessage(Messages.java:397)
at com.authdb.listeners.AuthDBEntityListener.checkGuest(AuthDBEntityListener.java:102)
at com.authdb.listeners.AuthDBEntityListener.onEntityDamage(AuthDBEntityListener.java:64)
at org.bukkit.plugin.java.JavaPluginLoader$59.execute(JavaPluginLoader.java:656)
at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
at net.minecraft.server.EntityHuman.damageEntity(EntityHuman.java:427)
at net.minecraft.server.EntityPlayer.damageEntity(EntityPlayer.java:180)
at net.minecraft.server.EntityHuman.d(EntityHuman.java:566)
at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:883)
at net.minecraft.server.Packet7UseEntity.a(SourceFile: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)
2011-08-31 23:41:53 [INFO] [AuthDB] Launching function: replaceStrings(String string, Player player, String additional)

Using WorldGuard , bananregion .

 

It is possible to use old mysql structre mit 2.3.0. Because, every time when I try to login, i get the message, i were not registered.

 

Examined mysq logs and noticed that plugin is asking for authdb_users table. While config files are set in such way:

Code:

plugin:
  language:
    commands: English                              # Language you want to use for commands that matches a directory under translations.
    messages: English                              # Language you want to use for messages 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: mad_j                                      # Name of the database you are connecting to. MySQL only.
  keepalive: false                                 # Enable/disable keeping database connection alive. Do not use if your connection limit is low. MySQL only.
script:
  name: joomla                                     # Name of the script you are using.
  version: 1.6.1                                   # Version of the script you are using.
  tableprefix: jos_                              # Database table prefix for the script, if you use one.
#  passwordsalt:                                    # NOT IMPLEMENTED YET! Unique/custom password salt, if needed by the script.

Code:

customdb:
  enabled: false                                   # Enable/disable custom database support. Leave this disabled if using a script such as phpBB.
  autocreate: false                                 # Enable/disable automatic creation of the database tables and columns for a custom database.
  table: authdb_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: 4 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: 4 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: Contex,Wulfspider                     # Usernames to exclude from username and password filtering.

 

No idea whats wrong with my version? Sad Maybe I'll just wait for the next bugfixed version...

 

Had some reports of people getting their inventory cleared after reload/restarts. Has anyone else encountered this problem?

 

Yes i'm actually also getting inventory wipes at Build 181... says its being fixed

 

I had it once so after that i returned to 2.2.0

 

@contex
I will wait for the bugfixed version, and test it out with it again. Until then, good luck finding the other bugs

 

The authdb_users is also the name of the local table inside AuthDB.db that AuthDB syncs your MySQL database with locally.

 

@Wulfspider

Do you understand what problem is it? (player lose inventory)

 

Any ideas what to do?

 

The inventory bug is our biggest issue right now and we are trying to resolve it.

We're trying to get it fixed.

Yes, we are trying to get the inventory bug fixed.

Do you get the same message after you leave the server and join again?

Are you using a script or customdb?

I think we'll need to add something that looks for inv files or just make sure that everyone has logged in before the switched perhaps so that their inventory is not stored in the files.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

how i add items in blacklist.yml ? just the ID like ex: 4,3,32,12

ups sorry

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Wha? There is no blacklist.yml. What are you talking about?

 

yes it is CraftBukkit\plugins\AdminCmd

 

Wrong plugin thread? It's AuthDB thread

 

I think you are looking for this thread: http://forums.bukkit.org/threads/ad...ll-warp-weather-afk-multi-lingual-1060.10770/
They moved to: http://dev.bukkit.org/server-mods/admincmd/

Oh right, try: "find / -name 'AuthDB.db' ", see if that results anything

We havent fixed it yet, you could however use AuthDB 2.2.0.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Yeah, wrong plugin thread. This is for AuthDB, not AdminCmd.

No problem.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

I apologize for being so annoying, but what my next step should be?

Review:
1. Getting com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't0.equipment' in 'field list'" error
2. Using AuthDB 181 build, CraftBukkit 1066, Spout 258, CentOS Linux 6.0
3. Setting to connect Joomla 1.6.1
4. Already uploaded AuthDB.db into plugins/AuthDB. No changes.

 

I know whats wrong, but I cant understand why that is going on.
It seems like it finds the AuthDB.db (but you are using a few days old AuthDB.db), are you sure that its not located anywhere else? What if you type "find AuthDB.db /" and let it scan your whole vps/pc.

 

Nothing found. Scanned from / directory.

 

@contex

hi excuse me again, i know you have work to do but i have a dedicate server with 50 people and i've installed auth db 181, you can relase a dev build only with inventory bug fixed please or i loose all player ç.ç

@contex

Code:

settings:
    spawn-radius: 16
    permissions-file: permissions.yml
    update-folder: update
aliases:
    icanhasbukkit:
    - version
database:
    username: bukkit
    isolation: SERIALIZABLE
    driver: org.sqlite.JDBC
    password: walrus
    url: jdbc:sqlite:{DIR}{NAME}.db

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Blank result. Nothing.

Firs thought of error cause was permission mistake.. but no. Permissions are alright. 755 on whole server folder. Recursively

 

with 2.2 i've too much error and the server lag