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

    CraftFire

    We will try. This is something with Minecraft but we may be able to do something about it.
     
  3. Offline

    Swadon

    Ok, Thank You ;)
     
  4. xAuth is able to avoid disconnection of connected player (only between us xD)
     
  5. Offline

    CraftFire

    Well, then I guess it's possible and we'll be able to add it. :)
     
  6. I tried configuring this from what it say on the tutorial, but it does nothing, it cant find my forum or something.
    I think im just missing something, so iw as wondering if any had a working file, that i could modify for me.
     
  7. Offline

    contex

    The included config works perfectly fine, what kind of errors are you getting?
    Where is your forum's webhost located?
    If external, is MySQL's port open?
    Do you have a script (phpBB3, Joomla, etc) installed?

    Reply back if you need further help!
     
  8. Offline

    CraftFire

    The default config.yml works out of the box as long as you configure it with your unique MySQL and script settings. Your database provider needs to allow remote access as stated in the requirements section unless you are hosting your database on the same machine as your CraftBukkit server. Check for errors in the console related to AuthDB and MySQL and post your link us to your config.yml on pastebin.com or similar site with your username and password values removed or hidden with ******. This would assist us in helping you further.
     
  9. My forum is located at powerminers.net, but when i type that in the script, it tries to connetc to powerminers.net/minecraft_forum:3306 and theres nothing there.
    So how do i let it connect to powerminers.net:3306
     
  10. Offline

    Grandcruiser

    Ah, it is but there's a new version of IP.Board coming out. I don't know if it would break compatibility with AuthDB or not.
     
  11. Offline

    CraftFire

    Then you most likely have something wrong in your config.yml. Please link us to your config.yml so we can further assist you.
    I think I have the beta for it. I'll look and see.
     
  12. Offline

    contex

    As we spoke about in the IRC. If you need any more help just contact us :)!
     
  13. I'm getting tired of this :S
    It keeps giving me the error minecraft.users doesn't excist while i see it with my OWN EYES, it is there.
    What is happening here?
     
  14. Offline

    CraftFire

    Without knowing what your config.yml looks like, it's hard to help you.
     
  15. Offline

    djxitec

    I need an update to Joomla 1.6.3

    Unfortunately, I always use the latest version because of security updates.

    I can not authdb connect with Joomla 1.6.3. :-(
     
  16. Offline

    CraftFire

    From what I can tell, 1.6.3 should not be a problem. It has the exact same database schema and password encryption as the previous 1.6 versions. Have you been able to connect with 1.6, 1.6.1, or 1.6.2?
     
  17. Offline

    davedavy

    Can anyone help me? I try to register myself , but i get always the note: Registration failed! I use a extern database, and i get an error if i start the server, do i need to add the tables manually?
     
  18. It's the same as everyone's
    plugin:
    debugmode: false
    usagestats: true
    database:
    driver: mysql
    host: localhost
    port: 3306
    username: ***
    password: ***
    name: minecraft
    prefix: script:
    name: phpMyAdmin
    version: 3.4.1
    customdb:
    enabled: true
    table: users_try
    userfield: ***
    passfield: ***
    emailfield: email
    encryption: md5
     
  19. Offline

    Sunbeam

    If i try to register the programm always sais invalid email adress registration failed!

    can i register without email or put it off that no email is needed?
     
  20. Got it working! Kept screwing around, seemed my port was f'ed up, but now i have the "WARNING: COULD NOT FIND A COMPATIBLE SCRIPT VERSION, PLEASE CHECK YOUR SCRIPT VERSION AND TRY AGAIN, PLUGIN MAY OR MAY NOT WORK! " And i have to register everytime i connect :S.
     
  21. Offline

    mido

    can you give me dump for custom db. I think that: I don't need CMS or forum but, i want to use this plugin
     
  22. I use this:
    Code:
    CREATE TABLE IF NOT EXISTS `players` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(24) NOT NULL,
      `password` varchar(32) NOT NULL,
      `email` varchar(96) NOT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `user` (`name`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
     
  23. Offline

    CraftFire

    Yes, as stated in previous posts, the tables are not created automatically when using a custom database.
    You could use something simple like this: http://google.com/search?q=referral+links#/AnOir3S.

    Your config may be the same as everyones before it was changed by you and each person who set it to their unique settings.

    Why do you have phpMyAdmin as the script name? phpMyAdmin isn't a script we support and see no reason why it would be one that would be needed to be added. You also have customdb enabled, which means you are trying to connect to the table that you set, users_try. If you are connecting to a forum, you need to actually use it's name, version, and disable customdb.

    http://dl.dropbox.com/u/7446930/CraftFire/Plugins/AuthDB/authdb_users.sql
    You can use something like that or what Digi posted.

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

    nala3

    Ok so let me get this clear, this forces users to register on the forums to be able to play on the server? if that is the case can you add suport for Advanced Electron Forum? Would be greatly appreciated ^_^ I dont think its very popular but still a nice forum setup
     
  25. Offline

    CraftFire

    Sure, I'll add it to the list and see what is needed for it. :)
     
  26. Offline

    firefwing24

    Here's my settings..

    database:
    driver: mysql
    host: localhost
    port: 3306
    username: root
    password: **********
    name: minecraft_forum(i honestly dont know what to put here lol)
    prefix: (Idk here either)

    I have a few questions...
    Is it possible to do this without a pHp?
    Just store everything in MySQL.
    I don't really need this for a website atm


    And yes it is
    1. The correct password
    2. I do have the java connector
    3. My bukkitserver and the MySQL database are on this very computer I'm typing this message


    Code:
    [WARNING] [AuthDB] MYSQL CANNOT CONNECT!!!
    2011-06-20 14:52:15 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'minecraft_forum'
    2011-06-20 14:52:15 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-20 14:52:15 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-20 14:52:15 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-20 14:52:15 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2011-06-20 14:52:15 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-20 14:52:15 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-20 14:52:15 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-20 14:52:15 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    2011-06-20 14:52:15 [SEVERE]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    2011-06-20 14:52:15 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-20 14:52:15 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-20 14:52:15 [SEVERE]     at com.authdb.util.databases.MySQL.connect(MySQL.java:70)
    2011-06-20 14:52:15 [SEVERE]     at com.authdb.AuthDB.onEnable(AuthDB.java:173)
    2011-06-20 14:52:15 [SEVERE]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:125)
    2011-06-20 14:52:15 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:799)
    2011-06-20 14:52:15 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:253)
    2011-06-20 14:52:15 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:140)
    2011-06-20 14:52:15 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:118)
    2011-06-20 14:52:15 [SEVERE]     at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:232)
    2011-06-20 14:52:15 [SEVERE]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:219)
    2011-06-20 14:52:15 [SEVERE]     at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:146)
    2011-06-20 14:52:15 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-06-20 14:52:15 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-20 14:52:15 [INFO] [AuthDB] AuthDB plugin 2.2.0 is enabled
    2011-06-20 14:52:15 [INFO] [AuthDB] AuthDB is developed by CraftFire <[email protected]>
    2011-06-20 
     
  27. Offline

    CraftFire

    name: is where you set the database name to connect to. The table and fields are not automatically created either.
    prefix: is the prefix if any that you use with your database name. Most script uses prefixes such as phpbb_ or minecraft_. If you do not care to use a prefix, you can simply leave that setting with no value.

    You can use it without PHP as this plugin has nothing to do with PHP. AuthDB communicates purely with the MySQL database and not the script that uses it if there is one.

    You also do not need the MySQL Java Connector standalone as the latest builds of CraftBukkit include it inside it.
     
  28. Offline

    firefwing24

    My MySQL must be really wierd.... I get errors with MySQL on every single plugin...

    Ok.. So first off... I dont need my MySQL java connector
    Even without it it still gives me the same error

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

    CraftFire

    Please read the other parts of what I wrote. I explained what you need to do to fix it.
    customdb also needs to be enabled being as you aren't using a script. So make sure that is enabled.
    The MySQL connector has nothing to do with the problem. I was simply saying you do not need to have it as it's already included with CraftBukkit.
     
  30. Offline

    firefwing24

    Ok.. So.. I enabled customdb But i get the same error

    Also i read about the name...
    Could having plugins using different databases cause a problem?

    Edit... Nevermind it doesnt..
    Can i ask how to access databases?
     
  31. Offline

    CraftFire

    Do you have a database named minecraft_forum? Is that what you are setting for name as it's value? Do you have a prefix set now? There should be no problem connecting to it because if it did, you would be receiving a completely different error.

    The problem you are having is that it can't find any database named minecraft_forum which is the default we have hard-coded in the plugin if no value is specified for name in config.yml for the database settings.
    No, you either have a name set in the config.yml for a database that doesn't exist or you have nothing set at all.
     

Share This Page