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

    Wulfspider

    Well, looks like you found your user table then and it's obvious as to what the prefix is; xf_

    Code:
     database:
        driver: mysql
        host: localhost
        port: 3306
        username: mydbusername
        password: mypass
        name: Mybasename
        prefix: xf_
      script:
        name: xf
        version: 1.0.1
      customdb:
        enabled: false
    Yes, I know the wp_users contains all the users, but AuthDB does not look in that table and it can't as you are technically still using XenForo, except the bridge is making a copy of the users in the wp_users table.

    Try logging in to a user directly instead of linking to see if it works. Are you getting any errors in the console?
     
  3. Offline

    fourgotten

    xf_users doesn't contains password hashes.

    ok, I will try different prefixes tomorrow. Thanks.
     
  4. Offline

    Wulfspider

    Has AuthDB ever been working with your XenForo install? You must have some screwy setup with your database.
     
  5. Offline

    fourgotten

    I didn't try AuthDB on Xenforo before this..

    Well, can I look on structure of original xf_users table (which AuthDB works correctly)?
     
  6. Offline

    Wulfspider

    The password hash for each user isn't stored in xf_user. They are stored in xf_user_authenticate. Your AuthDB config.yml was correct except for the database prefix which should be xf_
    As for the linking... either the user or pass you are using is more than likely incorrect if the linking is not working. You could enabled debugmode for more info in the CraftBukkit console too.
     
  7. Offline

    TheBosser

    Hello, I tried to install and use AuthDB on my minecraft bukkit server (with phpBB), I configured it correctly with the good host, username, password, database name, and prefix for MySQL perhaps when I try to use AuthDB there is an error for connecting to MySQL :
    I have the last version of MySQL (5.1.57), I tried to disable my firewall to retry AuthDB but there is the same error that appears.

    That's why I post a message here, sorry for bad english I'm French.

    Thanks for all !
     
  8. Offline

    Wulfspider

    Your MySQL host doesn't allow remote connections or your CraftBukkit server IP is not allowed to connect to it.
     
  9. Offline

    TheBosser

    But I set host to localhost, and my MySQL server is the same server where my CraftBukkit server is.
    What do I need to change in my MySQL configuration for AuthDB to work with it ?

    Thanks !
     
  10. Offline

    Wulfspider

    So the MySQL server is on the same pyhysical machine as the craftbukkit server?
     
  11. Offline

    TheBosser

    Yes that's it.


    Okay thanks for your help I will search what can block this !

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

    Wulfspider

    Well, it can't see it still so check that it is running and can be connected to with the username and password you setup.
     
  13. Offline

    TheBosser

    I have already some websites using this MySQL server and they are working perfectly, I also tried to log into phpMyAdmin with the username and the password I setup, and it's working too.
     
  14. Offline

    Wulfspider

    Are you sure your CraftBukkit server is on the same server? The error you are getting is a that the server CraftBukkit is on is not allow to talk to the server MySQL is on. So more than likely you have something blocking CraftBukkit. It's not an issue with AuthDB.
     
  15. Offline

    TheBosser

    Could it be an issue with JDBC that AuthDB is using to connect to the MySQL Server ?

    Thanks !
     
  16. Offline

    Wulfspider

    Could, but unlikely. I do not think that Bukkit has changed the connector since they started building it into CraftBukkit and since you are the only one currently having the issue, then it sounds like something is just blocking it.
     
  17. Offline

    Swadon

    Hello everyone,

    I've a problem : when I'm connected and another player connects using my nickname, I'm kick.

    How can I fix this ?

    Thank you for helping me.
     
  18. Offline

    Wulfspider

    That is part of Minecraft. We will be adding options for it in an upcoming version.
     
  19. Offline

    Swadon

    Okay, Thank You for your answer ;)
     
  20. Offline

    DerET

    Is there a way to use it with Woltlab Burning Board?
     
  21. Offline

    Wulfspider

    We were trying to get both of their versions to install, but never could. I'll have to try them on another server later.
     
  22. Offline

    DerET

    I could try to use the custon database option if I will have installed my forum?!
     
  23. Offline

    Wulfspider

    I would not recommend that. As I've said before in a previous post; there is a lot that goes on behind the scenes in some of the connections to the forum scripts to make it all work properly if they were to use the forum on the web as well. ;)
     
  24. Offline

    DerET

    I do not need to enable registering on the server. And it seems to work (my username was found) but I do not know the password encryption method and how to bypass the salt.
     
  25. Offline

    Wulfspider

    As we do not have any salt options or placement of the salt, it will be a little tough to do what you want yet. ;)
    We will have both in an upcoming version along with Woltlab once we get the script installed.
    I haven't looking into what it uses yet either.
     
  26. Offline

    DerET

    It seems to use SHA1 - but I'm not sure. Anyway it doesn't work, because it's using (a?) salt to increase password strength.
     
  27. I don't understand much about Mysql and all these configs but I managed to get this to work with wordpress.

    I don't know how to make it work with wordpress passwords since wordpress uses phpass and notMD5. Don't even know if this plugin supports phpass, never tried it. I installed the plugin "MD5 Password Hashes" which makes wordpress save it's password as md5 instead. (the existing users needs to login once on the wordpress-site to make the password change to md5).

    Perhaps good to know?

    I have one problem since I got this working ok.
    No matter how I try I can't make it so that you can move when you're not logged in. It worked before I got it connected with wordpress but now you can't do anything until ju have logged in, no matter that I have "move" set to true in the config. How come?
     
  28. Offline

    Wulfspider

    You might have just been able to use it as bbPress as we support that and it should ne the same. I havent tested it personally though. If you can't move, then yu are probably getting an error or something conflicting. Check the console for errors and maybe with debugmode on too.
     
  29. I tried bbpress first but didn't get it to work. Right now it seems to work ok. The only problem reported is that it couldn't find a compatible scriptversion, but that shouldn't be a problem since I don't run any of the preconfig scripts, right?
    The way I got it working now works flawless. You register on my wordpress site and then you can play on the server with the username and password you used on the site.

    No matter what I change in the config, I still can't do anything before I type in my password, but thats a small thing to pay. :)
     
  30. Offline

    Wulfspider

    Yeah, the script version message is a mistake in 2.2.0 where it shows for customdb too which has been fixed for 2.2.1+.

    What you are describing is the whole point of AuthDB. You aren't supposed to be able to do anything when you log in as a registered user, because someone else could login as that play and impersonate them. The guest node in the config is only for allowing guests to do certain things.
     
  31. Ah. That explains alot.
    When I first logged in and could move around without typing my password I had a name that wasn't registered.
    Then since I made it work with wordpress and I couldn't move until I typed the password I was playing with a name that was registered. Guess that's why I could move the first time and not later and that means it all works exactly as it should. Perfect :)

    Thanks for a great plugin then :)

    Btw. If anyone have any problems getting this plugin to work with wordpress they can send me a msg and I'll help since I got mine working :)

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

Share This Page