Xauth nebo authme

[SodanCZE]

Server: IP:93.91.250.109:27076

jaky plugin je lepsi? hci to mit na registraci prez web, a aby to nehackovaly

[Vojko]

To už je na tebe.
Posledná aktualizácia xAuthu opravila bug s "hackovaním", takže je to na tebe.
Pokiaľ to chceš mať cez web, je to jedno, ale musíš si buď xAuth alebo AuthMe napojiť na MySQL.

[SodanCZE]

jak nastavit Xauth na mysql


confing mam takto ale stejnak to nejde

Kód: Vybrat vše

main:
    # How should xAuth store data (Accounts, sessions, etc.)?
    # Possible values: h2, mysql
    datasource: mysql
    # If set to true, xAuth will disable itself if the server is in online-mode
    auto-disable: true
    # If set to true, all required library files will be automatically downloaded
    download-libraries: true
    # When set to true, if a player connects with the same name as someone who is
    # already online, the player connecting will be kicked instead of the online player
    reverse-enforce-single-session: true

authurl:
    # Send user/pass data to authURL for authentication instead of the database
    # This option disables registration and password changes
    enabled: false
    # The URL to send user/pass data to, look at the example auth.php for an
    # example that works with SMF forums.
    url: http://127.0.0.1/auth.php?field=minecra

mysql:
    # Location of the MySQL server. Can be either a host name or IP address
    host: localhost
    # Port used by MySQL. Default is 3306
    port: 3306
    # User name used to connect to the MySQL server
    username: gs_27076_1
    # Password used to connect to the MySQL server
    password:  heslotu
    # Name of the database that will be used by xAuth
    database: gs_27076_1
    # Names of the tables xAuth will use to store data
    tables:
        account: accounts
        session: sessions
        strike: strikes
        location: tele_locations
        inventory: inventory

registration:
    # Enable/disable new registrations
    enabled: true
    # If set to true, everyone must register
    forced: true
    # Setting this to true requires a player to enter an email address when they register
    require-email: false
    # If set to true, a valid email address is required
    validate-email: true
    # How many accounts per IP address will be allowed. Set as 0 for unlimited
    account-limit: 0
    # Used with web registrations that require account activation
    activation: false

login:
    strikes:
        # Amount of times a player can enter an incorrect password before action is taken
        # Set as 0 to disable
        amount: 5
        # What action to take when the strike threshold is reached
        # Possible values: kick, lockout
        action: kick
        # Length of time, in seconds, that a strike will remain in the database
        strike-length: 3600
        # Length of time, in seconds, that a player will remain locked out
        lockout-length: 900

password:
    # Minimum length a password may be
    min-length: 6
    # Enable/disable password changes
    allow-change: true
    # Require at least one of the character types below that are set to true
    complexity:
        lowercase: false
        uppercase: false
        number: false
        symbol: false

guest:
    # Amount of time, in seconds, that a player has to log in before they are kicked
    # Set as 0 to disable
    timeout: 300
    # Amount of time, in seconds, between "You must be logged in.." messages
    notify-cooldown: 5
    # Commands that players who are not registered or logged in may execute
    allowed-commands: [register, login, l]
    # Turn on/off location protection
    protect-location: true

session:
    # Amount of time, in seconds, that a session will remain valid
    length: 3600
    # Verify a player's IP address when resuming a session
    verifyip: true
    # Length of time, in seconds, that a player will have godmode upon logging in
    # set as 0 to disable
    godmode-length: 5

filter:
    # Minimum length a players name can be
    min-length: 2
    # Characters that may be present in a players name. Use an asterisk (*) to allow all
    allowed: '*'
    # If set to false, players with blank names can connect
    blankname: true

# INTERNAL USE ONLY! DO NOT TOUCH!
version: 5


do logu to pise toto:

Kód: Vybrat vše

2012-02-03 17:42:56 [SEVERE] [xAuth] SQL query failure [read] (SELECT a.*, s.* FROM `accounts` a LEFT JOIN `sessions` s ON a.id = s.accountid WHERE `playername` = ?)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'gs_27076_1.accounts' doesn't exist
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
   at com.mysql.jdbc.Util.getInstance(Util.java:382)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
   at com.cypherx.xauth.database.Database.queryRead(Database.java:69)
   at com.cypherx.xauth.database.DbUtil.getPlayerFromDb(DbUtil.java:421)
   at com.cypherx.xauth.xAuth.getPlayer(xAuth.java:250)
   at com.cypherx.xauth.xAuth.onDisable(xAuth.java:59)
   at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:232)
   at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:1083)
   at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:397)
   at org.bukkit.plugin.SimplePluginManager.disablePlugins(SimplePluginManager.java:390)
   at org.bukkit.craftbukkit.CraftServer.disablePlugins(CraftServer.java:186)
   at net.minecraft.server.MinecraftServer.stop(MinecraftServer.java:385)
   at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:465)
   at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
2012-02-03 17:42:56 [SEVERE] Error occurred while disabling xAuth v3.1 (Is it up to date?): null
java.lang.NullPointerException
   at com.cypherx.xauth.database.DbUtil.getPlayerFromDb(DbUtil.java:437)
   at com.cypherx.xauth.xAuth.getPlayer(xAuth.java:250)
   at com.cypherx.xauth.xAuth.onDisable(xAuth.java:59)
   at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:232)
   at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:1083)
   at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:397)
   at org.bukkit.plugin.SimplePluginManager.disablePlugins(SimplePluginManager.java:390)
   at org.bukkit.craftbukkit.CraftServer.disablePlugins(CraftServer.java:186)
   at net.minecraft.server.MinecraftServer.stop(MinecraftServer.java:385)
   at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:465)
   at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)

[Shaggy84675]

Píše to, že databáze neexistuje, zažádal jsi o ní u FakaHedy?

[SodanCZE]

jo to nebylo tim, už jsem to vyřešil

[LavorekCZ]

Vyřešeno --> LOCK