Stránka 1 z 1
Xauth nebo authme
Napsal: 03 úno 2012, 17:57
od SodanCZE
Server: IP:93.91.250.109:27076
jaky plugin je lepsi? hci to mit na registraci prez web, a aby to nehackovaly
Re: Xauth nebo authme
Napsal: 03 úno 2012, 18:00
od 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.
Re: Xauth nebo authme
Napsal: 03 úno 2012, 18:22
od 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)
Re: Xauth nebo authme
Napsal: 05 úno 2012, 03:11
od Shaggy84675
Píše to, že databáze neexistuje, zažádal jsi o ní u FakaHedy?
Re: Xauth nebo authme
Napsal: 05 úno 2012, 03:28
od SodanCZE
jo to nebylo tim, už jsem to vyřešil
Re: Xauth nebo authme
Napsal: 05 úno 2012, 10:49
od LavorekCZ
Vyřešeno --> LOCK