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

    contex

  3. Offline

    MonsieurApple

    Awesome! I'm going to be installing this soon, I'll let you know how it goes :)

    Also XenForo support would be nice too :p
     
  4. Offline

    contex

    On it's way :)!
    [MERGETIME="1300184774"][/MERGETIME]
    With ALOT of help by Wulfspider, I've made some changes to the plugin. First of all, it will be renamed to AuthDB (cause ForumAuth is more focused on just forums). With AuthDB you can enable authentication through every that uses a MySQL database to manage it.

    This could be everything from CMS software like Joomla, Drupal, Wordpress and so on, but also forum boards as phpBB, SMF and more. A neat feature will be the usage of external authetication method like OpenID Google and several of others, we will see how far it goes.
    I added support for CraftIRC and customized messages. Also added support against illegal-characters (ยค%&#/), will be in the next release.

    I also managed to clean the code up a little bit for a source release: AuthDB @ Github
    I'm looking forward working with this!
     
    Spazmic likes this.
  5. Offline

    Alf999111

    And WBB3
     
  6. Offline

    contex

    Added to the todo list, thanks!
     
  7. Offline

    Spazmic

    Works perfectly! I am using it with Whitelist, and it is amazing! You sir , have no idea how much you helped me. You should add a Paypal donate button.

    Only problem so far :

    Someone that connects to the server with an admin name, can use Worldedit commands before login in. It gives an opportunity to offline-mode hackers to crash the server by creating 10000000000 blocks in 1 sec... Also, they can use /jumpto to move around. I know this is an issue with Rena4ka authentication plugin since it is not related to the forum. Personally, I would have used the source code of Anjosecurity :p
     
  8. Offline

    contex

    It's fixed for next release :) Thanks for reporting, it really means alot!
     
  9. Offline

    goldseed

    AWESOME!!!!!!!!!!!!!!!!

    can you support punBB???
     
  10. Offline

    contex

    Anything that runs a database. Added to the ToDo list, thanks!
     
  11. Offline

    Zero9195

    Hi ;) really nice plugin you are devloping here^^ Wanted to ask if Joomla is supported or will be supported? Really need it so would e great if you do so^^ Thanks for the Plugin^^
     
  12. Offline

    contex

    Going to release a stable version today (new boards/cms will be added tommrorow), had a lot of trouble with yaml files.
     
  13. Offline

    swedish2011

    Code:
    00:15:56 [INFO] Starting minecraft server version Beta 1.3
    00:15:56 [INFO] Loading properties
    00:15:56 [INFO] Starting Minecraft server on *:27777
    00:15:56 [VARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
    00:15:56 [VARNING] The server will make no attempt to authenticate usernames. Be
    ware.
    00:15:56 [VARNING] While this makes the game possible to play without internet a
    ccess, it also opens up the ability for hackers to connect with any username the
    y choose.
    00:15:56 [VARNING] To change this, set "online-mode" to "true" in the server.set
    tings file.
    00:15:56 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-516-
    gdf87bb3-b531jnks (MC: 1.3)
    00:15:56 [INFO] Preparing level "world"
    00:15:56 [INFO] Preparing start region
    00:15:56 [ALLVARLIG] java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    00:15:56 [ALLVARLIG]    at java.net.URLClassLoader$1.run(Unknown Source)
    00:15:56 [ALLVARLIG]    at java.security.AccessController.doPrivileged(Native Me
    thod)
    00:15:56 [ALLVARLIG]    at java.net.URLClassLoader.findClass(Unknown Source)
    00:15:56 [ALLVARLIG]    at org.bukkit.plugin.java.PluginClassLoader.findClass(Pl
    uginClassLoader.java:30)
    00:15:56 [ALLVARLIG]    at java.lang.ClassLoader.loadClass(Unknown Source)
    00:15:56 [ALLVARLIG]    at java.lang.ClassLoader.loadClass(Unknown Source)
    00:15:56 [ALLVARLIG]    at java.lang.Class.forName0(Native Method)
    00:15:56 [ALLVARLIG]    at java.lang.Class.forName(Unknown Source)
    00:15:56 [ALLVARLIG]    at com.contex.bukkit.forumauth.ForumAuthMySQL.connect(Fo
    rumAuthMySQL.java:19)
    00:15:56 [ALLVARLIG]    at com.contex.bukkit.forumauth.ForumAuth.onEnable(ForumA
    uth.java:148)
    00:15:56 [ALLVARLIG]    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlug
    in.java:118)
    00:15:56 [ALLVARLIG]    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(
    JavaPluginLoader.java:451)
    00:15:56 [ALLVARLIG]    at org.bukkit.plugin.SimplePluginManager.enablePlugin(Si
    mplePluginManager.java:217)
    00:15:56 [ALLVARLIG]    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftSe
    rver.java:83)
    00:15:56 [ALLVARLIG]    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftS
    erver.java:61)
    00:15:56 [ALLVARLIG]    at net.minecraft.server.MinecraftServer.e(MinecraftServe
    r.java:204)
    00:15:56 [ALLVARLIG]    at net.minecraft.server.MinecraftServer.a(MinecraftServe
    r.java:191)
    00:15:56 [ALLVARLIG]    at net.minecraft.server.MinecraftServer.d(MinecraftServe
    r.java:131)
    00:15:56 [ALLVARLIG]    at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:246)
    00:15:56 [ALLVARLIG]    at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:366)
    00:15:56 [VARNING] [ForumAuth] ERRORS in the ClassNotFoundException. Plugin will
    NOT work. Disabling it.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [VARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
    enabled. It may be misbehaving and the author needs to fix this.
    00:15:56 [INFO] [ForumAuth] ForumAuth plugin build 3 is enabled
    00:15:56 [INFO] Done (0,059s)! For help, type "help" or "?"
    >
    :/
     
  14. Offline

    Xeronix

    So I currently get
    Code:
    2011-03-16 17:10:03 [SEVERE] java.lang.IllegalStateException: Failed to remove player. net.minecraft.server.EntityPlayer@4079(xeronix at 67.3682034455751,70.0,1778.5188913255888) isn't in chunk 14, $
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.PlayerInstance.b(PlayerInstance.java:49)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.PlayerManager.b(PlayerManager.java:101)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:114)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:96)
    2011-03-16 17:10:03 [SEVERE]    at org.bukkit.craftbukkit.entity.CraftPlayer.kickPlayer(CraftPlayer.java:124)
    2011-03-16 17:10:03 [SEVERE]    at com.contex.bukkit.forumauth.listeners.ForumAuthPlayerListener.onPlayerQuit(ForumAuthPlayerListener.java:56)
    2011-03-16 17:10:03 [SEVERE]    at org.bukkit.plugin.java.JavaPluginLoader$2.execute(JavaPluginLoader.java:167)
    2011-03-16 17:10:03 [SEVERE]    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    2011-03-16 17:10:03 [SEVERE]    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:255)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:115)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:551)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.NetworkManager.a(SourceFile:234)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:76)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:357)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:272)
    2011-03-16 17:10:03 [SEVERE]    at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    
    spammed into my console whenever someone quits because they couldn't move.

    Looking at it, is it caused by the lack of the ability to kick a player? It seems that it can't kick a player on wrong password.

    However, kicking isn't enabled on wrong password...
     
  15. Offline

    SunyYun

    Xpress Engine Support Please?


    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

    --
    -- database: `minecraft`
    --

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

    --
    -- table `xe_member`
    --

    CREATE TABLE IF NOT EXISTS `xe_member` (
    `member_srl` bigint(11) NOT NULL,
    `user_id` varchar(80) NOT NULL,
    `email_address` varchar(250) NOT NULL,
    `password` varchar(60) NOT NULL,
    `email_id` varchar(80) NOT NULL,
    `email_host` varchar(160) default NULL,
    `user_name` varchar(40) NOT NULL,
    `nick_name` varchar(40) NOT NULL,
    `find_account_question` bigint(11) default NULL,
    `find_account_answer` varchar(250) default NULL,
    `homepage` varchar(250) default NULL,
    `blog` varchar(250) default NULL,
    `birthday` char(8) default NULL,
    `allow_mailing` char(1) NOT NULL default 'Y',
    `allow_message` char(1) NOT NULL default 'Y',
    `denied` char(1) default 'N',
    `limit_date` varchar(14) default NULL,
    `regdate` varchar(14) default NULL,
    `last_login` varchar(14) default NULL,
    `change_password_date` varchar(14) default NULL,
    `is_admin` char(1) default 'N',
    `description` text,
    `extra_vars` text,
    `list_order` bigint(11) NOT NULL,
    PRIMARY KEY (`member_srl`),
    UNIQUE KEY `unique_user_id` (`user_id`),
    UNIQUE KEY `unique_email_address` (`email_address`),
    UNIQUE KEY `unique_nick_name` (`nick_name`),
    KEY `idx_email_host` (`email_host`),
    KEY `idx_allow_mailing` (`allow_mailing`),
    KEY `idx_is_denied` (`denied`),
    KEY `idx_regdate` (`regdate`),
    KEY `idx_last_login` (`last_login`),
    KEY `idx_is_admin` (`is_admin`),
    KEY `idx_list_order` (`list_order`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    Xpress Engine Support Please?


    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

    --
    -- database: `minecraft`
    --

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

    --
    -- table `xe_member`
    --

    CREATE TABLE IF NOT EXISTS `xe_member` (
    `member_srl` bigint(11) NOT NULL,
    `user_id` varchar(80) NOT NULL,
    `email_address` varchar(250) NOT NULL,
    `password` varchar(60) NOT NULL,
    `email_id` varchar(80) NOT NULL,
    `email_host` varchar(160) default NULL,
    `user_name` varchar(40) NOT NULL,
    `nick_name` varchar(40) NOT NULL,
    `find_account_question` bigint(11) default NULL,
    `find_account_answer` varchar(250) default NULL,
    `homepage` varchar(250) default NULL,
    `blog` varchar(250) default NULL,
    `birthday` char(8) default NULL,
    `allow_mailing` char(1) NOT NULL default 'Y',
    `allow_message` char(1) NOT NULL default 'Y',
    `denied` char(1) default 'N',
    `limit_date` varchar(14) default NULL,
    `regdate` varchar(14) default NULL,
    `last_login` varchar(14) default NULL,
    `change_password_date` varchar(14) default NULL,
    `is_admin` char(1) default 'N',
    `description` text,
    `extra_vars` text,
    `list_order` bigint(11) NOT NULL,
    PRIMARY KEY (`member_srl`),
    UNIQUE KEY `unique_user_id` (`user_id`),
    UNIQUE KEY `unique_email_address` (`email_address`),
    UNIQUE KEY `unique_nick_name` (`nick_name`),
    KEY `idx_email_host` (`email_host`),
    KEY `idx_allow_mailing` (`allow_mailing`),
    KEY `idx_is_denied` (`denied`),
    KEY `idx_regdate` (`regdate`),
    KEY `idx_last_login` (`last_login`),
    KEY `idx_is_admin` (`is_admin`),
    KEY `idx_list_order` (`list_order`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

    Wulfspider

    The next version fixes this issue.

    I will double check with @contex on this, but I believe what was causing this has been fixed.

    I will add it to the To-Do list. Although, it may be hard to add support if I can't get to the Xpress Engine website. ;) I did find a download for it, so I will take a look to see what it uses in terms of password encryption.

    Support for a a lot more forums as well as blogs, CMS, and wikis will be coming soon too.
    New version of the plugin under it's new name, AuthDB, should be released soon that includes a lot of fixes and a few new features. @contex was hoping to release it yesterday, but he ran into a few problems that are being resolved.
     
  17. Offline

    Xeronix

    That sounds great. Keep us updated? :p
     
  18. Offline

    contex

  19. Offline

    Jonathan Bloom

    Can you add Vanilla forums support?
     
  20. Offline

    andret

    I want to integrate the whitelisting on my server with that of our forums. But since many of our members have another username on the forum then ingame, I need the ability to log into the server with username and password. Will this be implemented in this plugin?
     
  21. Offline

    contex

    Already added to the ToDo list :)

    Meaning a setting that enables /login USERNAME PASSWORD instead of just /login PASSWORD?
    If so, added to the todo list!
     
  22. Offline

    andret

    Yea thats what im looking for :) Thanks. Oh, and ofcourse xenforo support:)
     
  23. Offline

    contex

    Added to the list then, thanks for the idea! And yes, XenForo is in the ToDo list already :)
     
  24. Offline

    Wulfspider

    This updated ForumAuth 1.3 should work for both of you.
    Download (JAR Only)
    Download (ZIP)
     
  25. Offline

    Xeronix

    I believe I was using 1.3 while I was getting that error.. is it like a V1.3_01?
     
  26. Offline

    Wulfspider

    Maaaybe, I'm not sure how Contex wants to do the versioning. The only thing I changed was the manifest file inside the jar and I moved the mysql-connector-java-bin.jar to /lib and renamed mysql.jar as that is where I think it should be ;). Either way, the MySQL connector can be mysql.jar, mysql-connector-java-bin.jar, and a few other versioned names and can be placed in the root bukkit folder or under /lib. I tested it and it works for me unlike the original 1.3.
     
  27. Offline

    zwarmapapa

    Features:

    • Movement protection
    • Chat protection
    • Item using block replacement protection
    • Health protection
    • Commands and chat protection
    • Inventory protection

    I'm sorry, but you said "chat protection" twice xD
     
  28. Offline

    Wulfspider

    Wasn't meee! I've made an updated post for @contex once, so he can update that when he is online.
     
  29. Offline

    Xeronix

    Just tried it - I get that error spammed a LOTTTTT of times when someone leaves
     
  30. Offline

    Wulfspider

    Are you getting "Could not pass ENTITY_DAMAGED to ForumAuth" or something like that?
    Read THAT as AN for some reason... What CraftBukkit build are you using? I'm not getting any errors at all with my tests with ForumAuth 1.3 and CB 531 and 556.

    Edit: ahhh, there it is... took a bit for it to appear. Should be fixed in AuthDB 1.4.
     
  31. Offline

    Carve

    Would be nice if either / or both of these worked: bbPress & Wordpress
     

Share This Page