AuthMe - Prepojenie s MySQL databázov

Technická podpora k herním serverům Minecraft a Tekkit
Message
Autor
xXArthomXx
Příspěvky: 68
Registrován: 11 úno 2013, 22:03
Reputation: 0

AuthMe - Prepojenie s MySQL databázov

#1 Příspěvekod xXArthomXx » 09 črc 2013, 16:31

93.91.240.163:27179

Ahojte, no preinštaloval som si server na 1.6.1, idem si dať plugin AuthMe na registráciu, chcem ho prepojiť s MySQL databázov (pracujem na svojom webovom account systéme pre server) a odrazu ma nechce pripojiť. Webhosting mám u wedosu.
Config z AuthMe:
Spoiler: zobrazit

Kód: Vybrat vše

DataSource:
  mySQLColumnName: username
  mySQLTablename: authme
  mySQLUsername: a42116_authme
  backend: MySQL
  mySQLColumnLastLogin: lastlogin
  mySQLDatabase: d42116_authme
  mySQLPort: '3306'
  mySQLColumnIp: ip
  mySQLHost: wm38.wedos.net
  mySQLColumnPassword: password
  mySQLPassword: '*********'
  caching: true
  mySQLlastlocX: x
  mySQLlastlocY: y
  mySQLlastlocZ: z
  mySQLlastlocWorld: world
  mySQLColumnEmail: email
  mySQLColumnId: id
GroupOptions:
  UnregisteredPlayerGroup: ''
  RegisteredPlayerGroup: ''
  Permissions:
    PermissionsOnJoin: []
settings:
  sessions:
    enabled: false
    timeout: 10
    sessionExpireOnIpChange: false
  restrictions:
    allowChat: false
    allowCommands:
    - /login
    - /register
    - /l
    - /reg
    - /passpartu
    - /email
    - /captcha
    maxRegPerIp: 1
    maxNicknameLength: 20
    ForceSingleSession: true
    ForceSpawnLocOnJoinEnabled: false
    SaveQuitLocation: false
    AllowRestrictedUser: false
    AllowedRestrictedUser: []
    kickNonRegistered: false
    kickOnWrongPassword: false
    teleportUnAuthedToSpawn: false
    minNicknameLength: 3
    allowMovement: false
    timeout: 30
    allowedNicknameCharacters: '[a-zA-Z0-9_?]*'
    allowedMovementRadius: 100
    enablePasswordVerifier: true
    ProtectInventoryBeforeLogIn: true
    displayOtherAccounts: true
    ForceSpawnOnTheseWorlds:
    - world
    - world_nether
    - world_the_end
    banUnsafedIP: false
  GameMode:
    ForceSurvivalMode: false
    ResetInventoryIfCreative: false
  security:
    minPasswordLength: 4
    unLoggedinGroup: unLoggedinGroup
    passwordHash: SHA256
    doubleMD5SaltLength: 8
  registration:
    enabled: true
    messageInterval: 5
    force: true
    enableEmailRegistrationSystem: false
    doubleEmailCheck: false
  unrestrictions:
    UnrestrictedName: []
  messagesLanguage: en
ExternalBoardOptions:
  mySQLColumnSalt: ''
  mySQLColumnGroup: ''
  nonActivedUserGroup: -1
  mySQLOtherUsernameColumns: []
  bCryptLog2Round: 10
Xenoforo:
  predefinedSalt: ''
permission:
  EnablePermissionCheck: false
BackupSystem:
  ActivateBackup: false
  OnServerStart: false
  OnServerStop: true
  MysqlWindowsPath: C:\\Program Files\\MySQL\\MySQL Server 5.1\\
Passpartu:
  enablePasspartu: false
Security:
  SQLProblem:
    stopServer: true
  ReloadCommand:
    useReloadCommandSupport: true
  console:
    noConsoleSpam: false
    removePassword: false
    logConsole: false
  captcha:
    useCaptcha: false
    maxLoginTry: 5
    captchaLength: 5
Converter:
  Rakamak:
    fileName: users.rak
    useIP: false
    ipFileName: UsersIp.rak
    newPasswordHash: SHA256
Email:
  mailSMTP: smtp.gmail.com
  mailPort: 465
  mailAccount: ''
  mailPassword: ''
  mailSenderName: ''
  RecoveryPasswordLength: 8
  mailSubject: Your new AuthMe Password
  maxRegPerEmail: 1
  mailText: 'Dear <playername>, <br /><br /> This is your new AuthMe password for
    the server <br /><br /> <servername> : <br /><br /> <generatedpass><br /><br />Do
    not forget to change password after login! <br /> /changepassword <generatedpass>
    newPassword'
Hooks:
  multiverse: true
  chestshop: true
  bungeecord: false
  notifications: true
  disableSocialSpy: true
Performances:
  useMultiThreading: false


A tu je z konzole:
Spoiler: zobrazit

Kód: Vybrat vše

[FakaHeda] Successfully authorized 178.40.93.41!
> 16:29:02 [INFO] Starting minecraft server version 1.6.1
> 16:29:02 [INFO] Loading properties
> 16:29:02 [INFO] Default game type: SURVIVAL
> 16:29:02 [INFO] Generating keypair
> 16:29:02 [INFO] Starting Minecraft server on 93.91.240.163:27179
> 16:29:02 [INFO] This server is running CraftBukkit version git-Bukkit-1.5.2-R1.0-3-g3fa57f6-b2795jnks (MC: 1.6.1) (Implementing API version 1.6.1-R0.1-SNAPSHOT)
> 16:29:03 [INFO] [PermissionsEx] sql backend registered!
> 16:29:03 [INFO] [PermissionsEx] file backend registered!
> 16:29:03 [INFO] [PermissionsEx] PermissionEx plugin initialized.
> 16:29:03 [INFO] [LagMeter] Loading LagMeter v1.9.0
> 16:29:03 [INFO] [Vault] Loading Vault v1.2.25-b320
> 16:29:03 [INFO] ultiverse-Core] Loading Multiverse-Core v2.4-b527
> 16:29:03 [INFO] ----- Bukkit Auto Updater -----
> 16:29:03 [INFO] [PermissionsEx] Loading PermissionsEx v1.19.6
> 16:29:03 [INFO] It appears that you're running a Development Build, when you've specified in bukkit.yml that you prefer to run Recommended Builds.
> 16:29:03 [INFO] If you would like to be kept informed about new Development Build releases, it is recommended that you change 'preferred-channel' in your bukkit.yml to 'dev'.
> 16:29:03 [INFO] With that set, you will be told whenever a new version is available for download, so that you can always keep up to date and secure with the latest fixes.
> 16:29:03 [INFO] If you would like to disable this warning, simply set 'suggest-channels' to false in bukkit.yml.
> 16:29:03 [INFO] ----- ------------------- -----
> 16:29:03 [INFO] [PermissionsEx] Initializing file backend
> 16:29:03 [INFO] Permissions file successfully reloaded
> 16:29:03 [INFO] [FakaHedaMinequery] Loading FakaHedaMinequery v1.2
> 16:29:03 [INFO] [Essentials] Loading Essentials v2.11.1
> 16:29:03 [INFO] [ChatManager] Loading ChatManager v1.19.1
> 16:29:03 [INFO] [EssentialsSpawn] Loading EssentialsSpawn v2.11.1
> 16:29:03 [INFO] [AuthMe] Loading AuthMe v2.8
> 16:29:03 [INFO] [Vault] Enabling Vault v1.2.25-b320
> 16:29:03 [INFO] [Vault][Economy] Essentials Economy found: Waiting
> 16:29:03 [INFO] [Vault][Permission] PermissionsEx found: Waiting
> 16:29:03 [INFO] [Vault][Permission] SuperPermissions loaded as backup permission system.
> 16:29:03 [INFO] [Vault][Chat] PermissionsEx found: Waiting
> 16:29:03 [INFO] [Vault] Enabled Version 1.2.25-b320
> 16:29:03 [INFO] [Vault][Economy] Essentials Economy hooked.
> 16:29:03 [INFO] [Vault][Permission] PermissionsEx hooked.
> 16:29:03 [WARNING] **** SERVER IS RUNNING IN OFFLINE/INSECURE MODE!
> 16:29:03 [WARNING] The server will make no attempt to authenticate usernames. Beware.
> 16:29:03 [WARNING] While this makes the game possible to play without internet access, it also opens up the ability for hackers to connect with any username they choose.
> 16:29:03 [WARNING] To change this, set "online-mode" to "true" in the server.properties file.
> 16:29:03 [INFO] Preparing level "world"
> 16:29:03 [INFO] Preparing start region for level 0 (Seed: -4085746499223128259)
> 16:29:03 [INFO] Preparing start region for level 0 (Seed: -4085746499223128259)
> 16:29:05 [INFO] Preparing spawn area: 186%
> 16:29:05 [INFO] Preparing start region for level 0 (Seed: -4085746499223128259)
> 16:29:05 [INFO] [LagMeter] Enabling LagMeter v1.9.0
> 16:29:05 [INFO] [LagMeter] Not using logs folder.
> 16:29:05 [INFO] [LagMeter 1.9.0] Enabled! Polling every 40 server ticks. Logging to /hlserver/27179/plugins/LagMeter/lag.log
> 16:29:05 [INFO] ultiverse-Core] Enabling Multiverse-Core v2.4-b527
> 16:29:05 [INFO] ultiverse-Core] - Version 2.4-b527 (API v14) Enabled - By Rigby, fernferret, lithium3141 and main--
> 16:29:05 [INFO] [AllPay] - Version 10.0 - hooked into Essentials Economy for Multiverse-Core v2.4-b527
> 16:29:05 [INFO] ultiverse-Core] Loading World & Settings - 'world' - Env: NORMAL - Type: NORMAL & seed: -4085746499223128259
> 16:29:05 [INFO] ultiverse-Core] Loading World & Settings - 'world_nether' - Env: NETHER - Type: NORMAL & seed: -4085746499223128259
> 16:29:05 [INFO] ultiverse-Core] Loading World & Settings - 'world_the_end' - Env: THE_END - Type: NORMAL & seed: -4085746499223128259
> 16:29:05 [SEVERE] Reached end of stream for /37.157.194.249
> 16:29:05 [INFO] ultiverse-Core] 3 - World(s) loaded.
> 16:29:05 [INFO] [PermissionsEx] Enabling PermissionsEx v1.19.6
> 16:29:05 [INFO] [PermissionsEx] Superperms support enabled.
> 16:29:05 [INFO] [PermissionsEx] v1.19.6 enabled
> 16:29:05 [INFO] [Vault][Chat] PermissionsEx_Chat hooked.
> 16:29:05 [INFO] [FakaHedaMinequery] Enabling FakaHedaMinequery v1.2
> 16:29:05 [INFO] Starting FakaHedaMinequery server on 93.91.240.163:28179
> 16:29:05 [INFO] [Essentials] Enabling Essentials v2.11.1
> 16:29:05 [INFO] Essentials: Using PermissionsEx based permissions.
> 16:29:05 [INFO] [ChatManager] Enabling ChatManager v1.19.1
> 16:29:05 [INFO] [ChatManager] ChatManager disabled. Check config.yml!
> 16:29:05 [INFO] [ChatManager] Disabling ChatManager v1.19.1
> 16:29:05 [INFO] [ChatManager] ChatManager disabled!
> 16:29:05 [INFO] [EssentialsSpawn] Enabling EssentialsSpawn v2.11.1
> 16:29:05 [INFO] [AuthMe] Enabling AuthMe v2.8
> 16:29:05 [INFO] [AuthMe] Loading Configuration File...
> 16:29:05 [INFO] [AuthMe] Merge new Config Options if needed..
> 16:29:05 [INFO] [AuthMe] Set Language: en
> 16:29:05 [INFO] [AuthMe] Hook with Multiverse-Core for SpawnLocations
> 16:29:05 [INFO] [AuthMe] Hook with Essentials plugin
> 16:29:05 [INFO] [AuthMe] Hook with EssentialsSpawn plugin
> 16:29:05 [INFO] [AuthMe] MySQL driver loaded
> 16:29:05 [INFO] [AuthMe] Connection pool ready
> 16:29:08 [SEVERE] Reached end of stream for /178.41.69.198
> 16:29:15 [SEVERE] Reached end of stream for /178.41.69.198
> 16:29:23 [SEVERE] Reached end of stream for /178.41.69.198
> 16:29:28 [SEVERE] Reached end of stream for /178.41.69.198
> 16:29:32 [SEVERE] Reached end of stream for /178.41.69.198
> 16:29:37 [SEVERE] Reached end of stream for /178.41.69.198
> 16:29:46 [SEVERE] Reached end of stream for /178.41.69.198
> 16:29:52 [SEVERE] Reached end of stream for /88.212.37.78
> 16:29:59 [SEVERE] Reached end of stream for /178.41.69.198
> 16:30:12 [SEVERE] Reached end of stream for /178.18.73.30
> 16:30:17 [SEVERE] [AuthMe] ERROR: Timeout while waiting for a valid database connection.
> 16:30:17 [SEVERE] [AuthMe] ERROR: Can't use MySQL... Please input correct MySQL informations ! SHUTDOWN...
> 16:30:17 [INFO] Server permissions file permissions.yml is empty, ignoring it
> 16:30:17 [INFO] Done (74.079s)! For help, type "help" or "?"
> 16:30:17 [INFO] Starting GS4 status listener
> 16:30:17 [WARNING] Unable to initialise query system on world_the_end:27179 (Unknown Host): world_the_end: Name or service not known
> 16:30:17 [INFO] Starting remote control listener
> 16:30:17 [WARNING] Unable to initialise rcon on world_the_end:26179 : world_the_end
> 16:30:17 [INFO] Stopping server
> 16:30:17 [INFO] [AuthMe] Disabling AuthMe v2.8
> 16:30:17 [INFO] [EssentialsSpawn] Disabling EssentialsSpawn v2.11.1
> 16:30:17 [INFO] [Essentials] Disabling Essentials v2.11.1
> 16:30:17 [INFO] [Vault][Economy] Essentials Economy unhooked.
> 16:30:17 [INFO] [FakaHedaMinequery] Disabling FakaHedaMinequery v1.2
> 16:30:17 [INFO] Stopping FakaHedaMinequery server
> 16:30:17 [INFO] [PermissionsEx] Disabling PermissionsEx v1.19.6
> 16:30:17 [INFO] [Vault][Permission] PermissionsEx un-hooked.
> 16:30:17 [INFO] [Vault][Chat] PermissionsEx_Chat un-hooked.
> 16:30:17 [INFO] Permissions file successfully reloaded
> 16:30:17 [INFO] [PermissionsEx] v1.19.6 disabled successfully.
> 16:30:17 [INFO] ultiverse-Core] Disabling Multiverse-Core v2.4-b527
> 16:30:17 [INFO] ultiverse-Core] - Disabled
> 16:30:17 [INFO] [Vault] Disabling Vault v1.2.25-b320
> 16:30:17 [INFO] [LagMeter] Disabling LagMeter v1.9.0
> 16:30:17 [INFO] [LagMeter 1.9.0] Disabled!
> 16:30:17 [INFO] Saving players
> 16:30:17 [WARNING] DSCT: Socket closed
> 16:30:17 [INFO] Saving worlds
> 16:30:17 [INFO] Closing listening thread
> 16:30:17 [INFO] Saving chunks for level 'world'/Overworld
> 16:30:17 [INFO] Saving chunks for level 'world_nether'/Nether
> 16:30:17 [INFO] Saving chunks for level 'world_the_end'/The End
> 16:30:17 [INFO] Stopping server
> > 16:30:17 [INFO] Saving players
Connection is closed...

za každú pomoc ďakujem

Uživatelský avatar
Sejsel
Příspěvky: 4131
Registrován: 19 čer 2011, 09:43
Reputation: 0
Bydliště: /home/sejsel/
Kontaktovat uživatele:

Re: AuthMe - Prepojenie s MySQL databázov

#2 Příspěvekod Sejsel » 09 črc 2013, 17:10

Nepodařilo se připojit k wm38.wedos.net. Máš povolené připojování zvenčí na tu databázi?
01101110011101010110001001110111

xXArthomXx
Příspěvky: 68
Registrován: 11 úno 2013, 22:03
Reputation: 0

Re: AuthMe - Prepojenie s MySQL databázov

#3 Příspěvekod xXArthomXx » 09 črc 2013, 17:18

ehm.. trošku som ťa nepochopil, ako povolenie pripájanie zvonkajška?

Uživatelský avatar
Sejsel
Příspěvky: 4131
Registrován: 19 čer 2011, 09:43
Reputation: 0
Bydliště: /home/sejsel/
Kontaktovat uživatele:

Re: AuthMe - Prepojenie s MySQL databázov

#4 Příspěvekod Sejsel » 09 črc 2013, 17:28

Ano.
01101110011101010110001001110111

xXArthomXx
Příspěvky: 68
Registrován: 11 úno 2013, 22:03
Reputation: 0

Re: AuthMe - Prepojenie s MySQL databázov

#5 Příspěvekod xXArthomXx » 09 črc 2013, 17:29

úplný prístup pre úpravu v databázi? áno, ten uživateľ znamená plný prístup do MySQL databázy

Uživatelský avatar
Server.FT
Příspěvky: 210
Věk: 26
Registrován: 13 dub 2013, 11:41
Reputation: 0
Kontaktovat uživatele:

Re: AuthMe - Prepojenie s MySQL databázov

#6 Příspěvekod Server.FT » 09 črc 2013, 17:55

Vytvoř si u fakahedy databázi a udělej to přes tu.
Když ti někdo s něčím pomůže , tak karma + neuškodí. http://Funny-Gaming.4fan.cz/
Obrázek

Uživatelský avatar
siOnzee
Příspěvky: 810
Věk: 28
Registrován: 30 lis 2011, 21:40
Reputation: 4
Bydliště: siOnzee.cz
Kontaktovat uživatele:

Re: AuthMe - Prepojenie s MySQL databázov

#7 Příspěvekod siOnzee » 10 črc 2013, 01:35

Nemůžeš MySQL databázi dávát na MySQL Databázi webhostingu. Pač Wedos podporuje pouze přístup do databáze jako localhost. Nikoliv jinak.
Musíš požádat fakahedu o databázi na server.


Zpět na „Minecraft, Tekkit“

Kdo je online

Uživatelé prohlížející si toto fórum: Žádní registrovaní uživatelé a 61 hostů