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

    I did just test, and it does seem that there an issue with case sensitivity in the usernames too. Thanks for bringing this to our attention. Should be fixed in the next version. :)

    Edit: It seems that both Username and username work after a server restart. I believe this has to do with the AuthDB cache. We will work on getting this fixed.
     
  3. Offline

    Snip3d

    I can confirm restarting the server fixed the problem of some people not being detected as registered ingame. Very annoying problem though.

    Hope to see the new version with fixes soon.
     
  4. Offline

    contex

    Should be fixed for next version as well :)
     
  5. Offline

    jenrik

    it's need the abilities too set a custom database name.
    fx when you don't have forum
     
  6. Offline

    contex

    You should already be able to do that? (database -> name)

    database:
    driver: mysql
    host: localhost
    port: 3306
    username: root
    password: password
    name: NAMEHERE
    prefix: phpbb_
     
  7. Offline

    Wulfspider

    Already in there...

    just change the name and prefix:

    database:
    driver: mysql
    host: localhost
    port: 3306
    username: root
    password:
    name:

    prefix: phpbb_

    and for set the table info and enable:

    customdb:
    enabled: true
    table: authdb_users
    userfield: username
    passfield: password
    emailfield: email
    encryption: md5


     
  8. Offline

    jenrik

    thanks a lot.
    and awesome plugin.¨
    and here is a gift [diamond][cake][diamond] (diamonde cake)
     
    JWhy and contex like this.
  9. Offline

    Wulfspider

    Haha, thanks! Birthday and possibly anniversary (join date) gift(s) will be coming up in an upcoming version too. ;)
     
  10. Offline

    contex

    Why, thank you !
     
  11. Offline

    neatek

  12. Offline

    Wulfspider

    I'll check it out and see what it's using. :) Can probably fit it into one of the next versions if it's not using something complicated for passwords.
     
  13. Offline

    hunty197

    Is there a way if a new player logs on they can just register themselves?
     
  14. Offline

    Wulfspider

    Yes? They just use /register password email.
     
  15. Offline

    hunty197

    I tried that but it still just logs you in and you cant do anything.
     
  16. Offline

    Wulfspider

    I have no idea how it would be logging you in. Is it welcoming you as a guest when you join the server?
     
  17. Offline

    hunty197

    I'm not sure. But I have just been trying it out with just my account and it logs me in without asking me to register and takes all my stuff away, wont let me move or use the chat. And i want it so it just registers new players and then they can log on because i already have permissions set so new players cant do anything.
     
  18. Offline

    Wulfspider

    Does it give you any messages when you join your server? Do you have any errors in your server console?

    Post your config with passwords x'ed out or replaced too please. Also, what CraftBukkit build and AuthDB version are you using?
     
  19. Offline

    Jonathan Bloom

    I moved to a new host and I don't have FTP access. Can you make the next version auto-generate config files?
     
  20. Offline

    neatek

    I can restrict registration in the game? I just did not particularly speak and read English, sorry :(
     
  21. Offline

    Wulfspider

    Tsk tsk... yes, it's been planned. You could use shell to wget a custom zip hosted with your edited config files for now.

    You could post in both English and your native language and I could try to understand what you are saying in both. :p

    Restrict registration as in... only certain people can register? If that is the case, then might as well use a whitelist only.

    Sounds like it's still using the default localhost for the host. Are the rest of your settings working as you have them configured in the config.yml?

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

    neatek

    I want use web registration for auto adding(registration on server) in whitelist.
    and restrict registration on server.

    registration allowed only on web site.

    its really?
     
  23. Offline

    Wulfspider

    Yes, in your config, just look for this part and set it as shown:


    register:
    enabled: false

    This will disable registering in-game, and you can still set guest restrictions using AuthDB or other plugins.

    guest:
    commands: false
    chat: false
    building: false
    destruction: false
    movement: false
    interactions: false
    inventory: false
    drop: false
    pickup: false
    health: false
    pvp: false
    mobtargeting: false
    mobdamage: false

    The above part of the AuthDB config.yml would prevent guests from doing anything on the server without being registered. You can set what you want to true to allow certain things if wanted.
     
  24. Offline

    uBuild

    Hello, I am having some issues with this plugin. I am wanting to use a remote host for the mysql database. I have entered the host: to the remote host ip. The problem is in the server log, it shows the plugin trying to connect to the ip of the server and not the remote host. Is there something i am doing wrong?

    Thanks for taking the time to make this plugin and anwsering my questions.
     
  25. Offline

    Wulfspider

    You enabled debugmode and saw what IP it was connecting to? Are you sure your MySQL server can be accessed remotely? Post or link to your config.yml with passwords removed or X'ed out please.
     
  26. Offline

    uBuild

    Config
    Core:
    plugin:
    debugmode: false
    usagestats: true
    database:
    driver: mysql
    host: 184.82.118.128
    port: 3306
    username: ubuild_xxxxxxxxx
    password: xxxxxxxxxxxxxxxxxx
    name: ubuild_xxxxxxxxxxxxxxxxxx
    prefix:
    There is no prefix on the db for vbulletin.
    host: 184.82.118.128 is the remote host ip
    yes i can receive remote connections.

    Code:
    2011-04-22 07:29:49 [WARNING] [AuthDB] MYSQL CANNOT CONNECT!!!
    2011-04-22 07:29:49 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'ubuild_xxxxxxx'@'64.37.49.62' to database 'ubuild_xxxxxxxxxxx'
    2011-04-22 07:29:49 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-22 07:29:49 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2011-04-22 07:29:49 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011-04-22 07:29:49 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2011-04-22 07:29:49 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-22 07:29:49 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2011-04-22 07:29:49 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011-04-22 07:29:49 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    2011-04-22 07:29:49 [SEVERE]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    2011-04-22 07:29:49 [SEVERE]     at java.sql.DriverManager.getConnection(DriverManager.java:620)
    2011-04-22 07:29:49 [SEVERE]     at java.sql.DriverManager.getConnection(DriverManager.java:200)
    2011-04-22 07:29:49 [SEVERE]     at com.authdb.util.databases.MySQL.connect(MySQL.java:71)
    2011-04-22 07:29:49 [SEVERE]     at com.authdb.AuthDB.onEnable(AuthDB.java:169)
    2011-04-22 07:29:49 [SEVERE]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-22 07:29:49 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-22 07:29:49 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-22 07:29:49 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    2011-04-22 07:29:49 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    2011-04-22 07:29:49 [SEVERE]     at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    2011-04-22 07:29:49 [SEVERE]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    2011-04-22 07:29:49 [SEVERE]     at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    2011-04-22 07:29:49 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    2011-04-22 07:29:49 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-22 07:29:49 [INFO] [AuthDB] AuthDB plugin 2.1.5 is enabled
    2011-04-22 07:29:49 [INFO] [AuthDB] AuthDB is developed by CraftFire <[email protected]>
    
    As you can see the error is :
    2011-04-22 07:29:49 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'ubuild_xxxxxxx'@'64.37.49.62' to database 'ubuild_xxxxxxxxxxx'
    it is using the wrong ip

    Thanks for the help
     
  27. Offline

    nbeerbower

    I'm using this plugin now with a phpBB forum and it works great! Thanks a lot!

    Could you add a feature that gets rid of the "XXXXXX joined the game" and replace it with "XXXXXXX logged in." once they're confirmed.

    Thanks,
    -nbeerbower
     
  28. Offline

    uBuild

    yes far as i can tell. if i load the plugin and go into the server i cant do anything as it says cant connect to mysql contact admin

    it seems like it isn't reading the config file... i just turned debug on and it doesnt show anything else.

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

    Wulfspider

    What would the point of that be? It already tells you when they actually join the server, and when a user attempts to login with a password.

    Did you use the zip version and have the config files in the right location?
     
  30. Offline

    uBuild

    Ya i used the zip version config is in correct location, it is reading the config.yml because it showing the db name and username just the wrong host. my mistake.
     
  31. Offline

    contex

    Glad you fixed it :)
     

Share This Page