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

    noneandnonly

    Sooo... If you're already registered but not logged in "inventory: true" doesn't have any effect?
     
  3. Offline

    Wulfspider

    Correct, as it's just an option for if you want guests to store items or not.
     
  4. Offline

    noneandnonly

    Ah, I didn't know that. That's why it didn't work :D
    Thanks for your reply and I hope you'll be able to get the enchantment-fix soon :)
    Until then my players have to store their enchanted items in a chest when logging out.
     
  5. Offline

    Zerkhan

    Hi!

    I have a little problem ... I have a server running with "AuthDB" and "Factions." The problem is a player can execute commands from plugin "Faction" when is not logged.

    For example, a player can connects to the account of the leader of the faction, and may delete territory, exclude members etc ... What to do to block the use of these commands without being connected ...

    Thank you and especially good job for this plugin!
     
  6. Offline

    Fress_

    Got this error:

    Code:
    2011/12/24 12:51:11 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/12/24 12:51:11 - Class name: com.authdb.listeners.AuthDBPlayerListener
    2011/12/24 12:51:11 - File name: AuthDBPlayerListener.java
    2011/12/24 12:51:11 - Function name: onPlayerCommandPreprocess
    2011/12/24 12:51:11 - Error line: 418
    2011/12/24 12:51:11 - AuthDB version: 2.3.2.220
    2011/12/24 12:51:11 - Keep alive: false
    2011/12/24 12:51:11 - MySQL connection: true
    2011/12/24 12:51:11 - Latest query: com.mysql.jdbc.JDBC4PreparedStatement@635abf40: INSERT INTO `authdb_users` (`username1`,`password1`)  VALUES ('Snooki_','29a2c5230127d257d7211b706a7ea1f7')
    2011/12/24 12:51:11 - Script: Custom
    2011/12/24 12:51:11 - Custom table: authdb_users
    2011/12/24 12:51:11 - Custom passfield: x
    2011/12/24 12:51:11 - Custom userfield: x
    2011/12/24 12:51:11 - Custom encryption: md5
    2011/12/24 12:51:11 - Custom table schema:
    2011/12/24 12:51:11 - Table Name : authdb_users
    2011/12/24 12:51:11 - Column	Type(size)
    2011/12/24 12:51:11 - id	INT(4)
    2011/12/24 12:51:11 - regdate	TIMESTAMP(19)
    2011/12/24 12:51:11 - username	VARCHAR(40)
    2011/12/24 12:51:11 - password	VARCHAR(40)
    2011/12/24 12:51:11 - email	VARCHAR(100)
    2011/12/24 12:51:11 - Plugins: PermissionsEx 1.17, Vanish2 0.2.0, NoCheat 2.21a, ChatManager 1.15, Lockette 1.4.9 beta, Essentials 2.7.2, HeroicDeath 1.11.2, Modifyworld 1.16, FoundDiamonds 2.0, Permissions 2.7.7, WorldEdit 5.0, EssentialsProtect 2.7.2, EssentialsGeoIP 2.7.2, EssentialsSpawn 2.7.2, WorldGuard 5.4, dynmap 0.27-663, WorldBorder 1.5.0, HawkEye 1.0.5b, AuthDB 2.3.2.220,
    2011/12/24 12:51:11 - --------------------------- STACKTRACE START ---------------------------
    2011/12/24 12:51:11 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/12/24 12:51:11 - sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011/12/24 12:51:11 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011/12/24 12:51:11 - java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011/12/24 12:51:11 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/12/24 12:51:11 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/12/24 12:51:11 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011/12/24 12:51:11 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011/12/24 12:51:11 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011/12/24 12:51:11 - com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011/12/24 12:51:11 - com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011/12/24 12:51:11 - com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011/12/24 12:51:11 - com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011/12/24 12:51:11 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2011/12/24 12:51:11 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2011/12/24 12:51:11 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2011/12/24 12:51:11 - com.authdb.scripts.Custom.adduser(Custom.java:52)
    2011/12/24 12:51:11 - com.authdb.util.Util.checkScript(Util.java:119)
    2011/12/24 12:51:11 - com.authdb.AuthDB.register(AuthDB.java:648)
    2011/12/24 12:51:11 - com.authdb.listeners.AuthDBPlayerListener.onPlayerCommandPreprocess(AuthDBPlayerListener.java:404)
    2011/12/24 12:51:11 - org.bukkit.plugin.java.JavaPluginLoader$5.execute(JavaPluginLoader.java:293)
    2011/12/24 12:51:11 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/12/24 12:51:11 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:339)
    2011/12/24 12:51:11 - net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:750)
    2011/12/24 12:51:11 - net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
    2011/12/24 12:51:11 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
    2011/12/24 12:51:11 - net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    2011/12/24 12:51:11 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/12/24 12:51:11 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:93)
    2011/12/24 12:51:11 - net.minecraft.server.NetworkListenThread.a(SourceFile:108)
    2011/12/24 12:51:11 - net.minecraft.server.MinecraftServer.w(MinecraftServer.java:527)
    2011/12/24 12:51:11 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
    2011/12/24 12:51:11 - net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
    2011/12/24 12:51:11 - ---------------------------- STACKTRACE END ----------------------------
    
     
  7. Offline

    theask

    Please update for 1.0.0
     
  8. Offline

    Max Black

    Hey, just wanted to say you're doing a great job ;). Actually came to ask for an enchantment fix, but it looks like the 20 people above me have that covered, so I just figured you should know that even with some of these issues, it's still a great plugin; I believe the last of its kind (none of the others even work with the current builds).
     
  9. Offline

    The Wizard

    xAuth is dead, I want to switch to AuthDB, but I want to know when it will possible to convert all the data.
    Now I'm using a home made php script for registration, I want to know if I can stop in game registrations and leave only the website for accounts.
     
  10. Offline

    Nosxxx

    Does it work for 1.0.0 ?

    Thank you for your fast Support ;)

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Sep 9, 2018
  11. Offline

    Wulfspider

    Not completely. Hopefully we'll have some updates out soon. Main thing that has issues is enchantments.
     
  12. Offline

    Nosxxx

    Thanks, does it already works with Xenforo ?
     
  13. Offline

    Wulfspider

    Yup! I haven't tested with 1.1.0-1.1.1 yet, but I'm fairly certain nothing changed in terms of what we use in AuthDB.

    We started working on implementing an option for the same password type that xAuth uses, but it hasn't been finished yet.

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

    Phinary

    Its nice to see development is continuing to some extent for authdb. Honestly, and I have no intentions to being rude, but I prefer xAuth over AuthDB any day. I actually talked to the developer of xAuth and he implimented many things that fit my server perfectly.

    The sad news is that I recently switched to AuthDB. xAuth was dead, and AuthDB seemed like the only decent option at the time. Will be nice to see if you guys get the time to be able to implement new features. Now that I am using AuthDB, I have no intentions to change to anything else.
     
  15. Offline

    Wulfspider

    Things have been a little inactive lately being as Contex has been busy with real-life things. He's back currently and working on getting things fixed and updated. Hopefully we can get some of the requested changes done too.

    No problem. :)

    In the works. ;)

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

    Nosxxx

    Dear Wulfspider,
    I am trying to use ur Plugin autdb for my Multiplayer Minecraft Server but the Plugin isnt fully updatet to the newest version of Minecraft so I would like to ask u if it is possible to quickly update the Plugin version because i am having some issues with Greefers on my Server and would like to use ur plugin to prevent Greefers from Login into my Server with Admin names.

    Best Regards
     
  17. Offline

    veN1337

    Read his last post:
    It is "In the works ;)"
     
  18. Offline

    Nosxxx

    Would you possibly be so kind as to tell me how long it will still take ?
     
  19. Guys whats the prob? Its working atm? Atleast I dont experience any probs. Except my users are logged in forever :p
     
  20. Offline

    Nosxxx

    Hey thanks ;), it is working without Probs.

    Will AuthDB support Premissions EX in future time, because actually it says
    [INFO] [AuthDB] Could not load a permissions plugin, going over to OP!
     
  21. Offline

    Mrchasez

    How can i switch to this from xAuth and keep passwords etc??
    Does everything work on 1.0.1-R1
     
  22. Offline

    bren4q

    Feature request - Could you add a command that allows either a player or an admin to reset/change someone's password?

    This is needed mainly when AuthDB is configured to use a custom database, since players have no forum or any other UI that allows them to change their passwords. My server is using the local AuthDB.db file and a couple of players wanted to change their passwords. There is no command that allows this (unless I missed something) so I had to use an SQLite editor to remove their user entries. An in-game command that handled this would be a lot slicker.
    Thanks,
    Bren
     
    Fress_ likes this.
  23. Offline

    DerET

  24. Offline

    nhx

    For those who can't wait for the official release with enchantments fix, here a version who can handle this

    Mod edit (NuclearW): Removed unofficial release link

    (no CraftIRC and BackpackManager support)

    PS: i've never programmed in java before so it's crappy as hell but it works
     
  25. Offline

    CainFoool

    @Wulfspider:

    Does this work with vBulletin 4.1.9? I have tried it and the accounts do not register on the forum however it still says "Hey, I remember you! You're logged in!" and no I'm not using a custom database :/
     
  26. Offline

    FunCraft

    so i tryed to integrate this with my website
    first i've got an index.php file from DynamicEffectWhitelist and edited it so instead of the Minecraft username field i now have also a Password field
    and what i write in that password filed is going to be added into my MySQL database in the table "auth", column "password"
    the problem is that i don't know how to encrypt it using MD5 so it can be compatible with AuthDB
    here is the index.php file that i am using and maybe you can edit it to encrypt the password with MD5 so AuthDB can use it
    NOTE:I am not a PHP coder that's why i am asking for help!
     

    Attached Files:

  27. Offline

    Max Black

    I'd love to use this, but I'm not one to use unsupported branches, and I can't code java (much less the bukkit api) to save my life. Can someone a bit more advanced then I pick through his code? I really need enchantments on our server, it's really causing issues (we have a daily restart, where if anyone has an enchanted item, it breaks..)

    Soo, I was bored, and recoded what you gave me. It's a simple script that should work for most people.. Note, you will need to modify your mysql database to something like:
    Code:
    CREATE TABLE `MC_Auth` (
      `id` int(10) NOT NULL COMMENT 'Auto Incremented ID' AUTO_INCREMENT PRIMARY KEY,
      `username` varchar(200) NOT NULL COMMENT 'Minecraft Username',
      `email` varchar(200) NOT NULL,
      `password` varchar(32) NOT NULL COMMENT 'MD5 hashed salt',
      `date_created` datetime NOT NULL COMMENT 'date user registered'
    ) COMMENT='' ENGINE='InnoDB';
    Index.php

    PHP:
    <html>
    <head>
        <title>Minecraft Registration</title>
    </head>
    <body>
    <?php
    //require_once("libs/recaptchalib.php");
    require("config.php");

    $formErrorTexts = array();
    if (isset(
    $_POST["submit"]))
    {
        
    $formErrors = array();
        
    //validate form
        
    $username $_POST["username"];
        if (!isset(
    $username) || strlen($username) == 0)
            
    $formErrors["username"][] = "Please enter a username";

        
    $email $_POST["email"];
        if (!isset(
    $email) || strlen($email) == 0)
            
    $formErrors["email"][] = "Please enter an email";
        if (
    strpos($email'@') === FALSE//very basic email validation
            
    $formErrors["email"][] = "Please enter a valid email";

        
    $password $_POST["password"];
        if (!isset(
    $password) || strlen($password) == 0)
            
    $formErrors["password"][] = "Please enter a password";

        
    $cpassword $_POST["cpassword"];
        if (!isset(
    $cpassword) || strlen($cpassword) == 0)
            
    $formErrors["cpassword"][] = "Please confirm your password";
        if (
    $password != $cpassword)
            
    $formErrors["cpassword"][] = "Entered passwords do not match";

        
    $resp recaptcha_check_answer (RE_PRIVATEKEY,
                            
    $_SERVER["REMOTE_ADDR"],
                            
    $_POST["recaptcha_challenge_field"],
                            
    $_POST["recaptcha_response_field"]);
        if (
    $recaptcha_enabled === false || $resp->is_valid)
            
    $formErrors["captcha"][] = "Captcha isn't correct";

        if (
    count($formErrors) > 0)
        {
            
    //Errors were found
            
    foreach ($formErrors as $input=>$errors)
                
    $formErrorTexts[$input] = implode("<br />"$errors);
        }
        else
        {
            
    $con = @mysql_connect(MS_HOSTMS_USERNAMEMS_PASSWORD);
            if(
    $con != null)
            {
                if (@
    mysql_select_db(MS_DB))
                {
                    
    $sql "INSERT INTO `".TABLE."` VALUES (null,
                           '"
    .mysql_real_escape_string($username)."',
                           '"
    .mysql_real_escape_string($email)."',
                           MD5('"
    .mysql_real_escape_string($password)."'),
                           NOW());"
    ;
                    
    $result = @mysql_query($sql);

                    if (
    $result)
                        echo 
    "You have been successfully registered!";
                    else
                        echo 
    "Error registering, please try again later. " . (DEBUG?mysql_error():"");
                }
                else
                    echo 
    "Error selecting db. " . (DEBUG?mysql_error:"");
            }
            else
                echo 
    "Error connecting to database, please try again later. " . (DEBUG?mysql_error():"");
        }
    }

    if (
    count($formErrorTexts) > || !isset($_POST["submit"])) //if errors, or the form wasn't submitted
    {
    ?>
    <form action="<?php echo $_SERVER['php_info']; ?>" method="post">
        <label for="username">Username</label>: <input type="text" name="username" value="<?php echo htmlspecialchars($_POST["username"]); ?>" /><br/>
        <?php if (isset($formErrorTexts["username"])) { echo '<span class="error">'.$formErrorTexts["username"].'</span><br/>'; } ?>
        <label for="email"></label>Email: <input type="text" name="email" value="<?php echo htmlspecialchars($_POST["email"]); ?>" /><br/>
        <?php if (isset($formErrorTexts["email"])) { echo '<span class="error">'.$formErrorTexts["email"].'</span><br/>'; } ?>
        <label for="password">Password</label>: <input type="password" name="password" value="<?php echo htmlspecialchars($_POST["password"]); ?>" /><br/>
        <?php if (isset($formErrorTexts["password"])) { echo '<span class="error">'.$formErrorTexts["password"].'</span><br/>'; } ?>
        <label for="cpassword">Confirm Password</label>: <input type="password" name="cpassword" value="<?php echo htmlspecialchars($_POST["cpassword"]); ?>" /><br/>
        <?php if (isset($formErrorTexts["cpassword"])) { echo '<span class="error">'.$formErrorTexts["cpassword"].'</span><br/>'; } ?>

        <?php
        
    if(RECAPTCHA_ENABLED)
        {
            echo 
    "Anti-bot verification:<br />";
            echo 
    recaptcha_get_html(RE_PUBLICKEY);
            if (isset(
    $formErrorTexts["captcha"])) { echo '<span class="error">'.$formErrorTexts["captcha"].'</span><br/>'; }
        }
        
    ?>
        <input type="submit" name="submit" value="Register" />
    </form>
    <?php
    }
    ?>
    </body>
    </html>
    config.php:
    PHP:
    <?php
    #CONFIG
    define("DEBUG"true);

    define("RECAPTCHA_ENABLED"true);
    define("RE_PUBLICKEY""");
    define("RE_PRIVATEKEY""");

    define("MS_HOST""localhost");
    define("TABLE""MC_Auth");
    define("MS_USERNAME""");
    define("MS_PASSWORD""");
    define("MS_DB""");
    ?>
    Spent a bit of time on that, so I hope it helps some.. Feel free to ask any questions, and don't quote this entire post in a reply.
    Max

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

    kevinwinkel

    Link is dead..
    doesn't work with my SMF 2.0.2 (supported 2.0.0.5 but is the same for users)

    Help wanted ;)

    BTW: best auth-plugin ever
     
  29. Offline

    Fress_

    Could anyone pick this up, this is truly an amazing and much needed plugin :/.
     
  30. Offline

    algiuxas

    May we have a heads-up from plugin developers? How is it going with updating the plugin?
     
  31. Offline

    theask

    I need the Update too... My Members want Enchants *-*
    If Someone type a wrong Password it says to all Players "You Type a wrong password"...
     

Share This Page