MySQL- Dotazy / Kontrola

Technická podpora k herním serverům Minecraft a Tekkit
Message
Autor
Uživatelský avatar
Bisyss
Příspěvky: 760
Věk: 10
Registrován: 07 lis 2014, 15:54
Reputation: 1
Bydliště: http://netsword.cz/
Kontaktovat uživatele:

MySQL- Dotazy / Kontrola

#1 Příspěvekod Bisyss » 25 úno 2015, 16:49

Server: 93.91.250.119:27053

Ahoj lidi,

1)Mam dotaz ohledně MySQL.
K čemu to je? Pomáhá to nějak serveru? Je mi to k něčemu když nemam WEB od FH? K čemu to slouží?
(Já vim že jsou to směšné otázky ale já to prostě nevim ..... asi jsem blb nebo co :D)

2) Mam na serveru tyto pluginy ..... které by šly připojit na MySQL a zlepšilo by to něco?

Kód: Vybrat vše

Plugins (28): FakaHedaMinequery, WorldEdit, AreaChecker, Vault, PermissionsEx, AutoMessage, iConomy, GUIShop, AntiAd, ASkyBlock, 1vs1, ProtocolLib, NahodnyTeleport, Essentials, Residence, Jobs, NoCheatPlus, EssentialsSpawn, SkinsRestorer, Multiverse-Core, LWC, Paintball, MineResetLite, AuthMe, EssentialsChat, MobArena, Multiverse-Inventories, CreativeControl


Děkuji za rady ..... a odpovědi na mé debilní otázky ..... (ale nějak se to dozvědět musim ....)
Naposledy upravil(a) Bisyss dne 25 úno 2015, 19:26, celkem upraveno 1 x.
Konec .....

Uživatelský avatar
Hanakocz
Příspěvky: 3228
Věk: 34
Registrován: 25 črc 2013, 20:53
Reputation: 7
Kontaktovat uživatele:

Re: MySQL- Dotazy

#2 Příspěvekod Hanakocz » 25 úno 2015, 17:04

No, nejdřív pár slov k tomu, co server využívá , když nevyužívá MySQL.
Pro každá data si musí udělat soubor. Třeba texťák, nebo yaml nebo nějaký pseudo databáze...co je tam za problém je nasnadě ->
Pro přečtení dat musí ten soubor otevřít a celý přečíst. Pak najde, kde tam co potřebuje. Pro zápis to samé.
V statistikách serveru sis určitě všiml kolonky "otevřené soubory" - to je přesně to.....zabírá to paměť, pro větší soubory to trvá docela dlouho, než to přelouská.

A teď co je MySQL...
ve zkratce to je uspořádaná tabulka, která má podtabulky, pojmenovaný nějak, plus všechny záznamy v těch jednotlivých tabulkách jsou očíslovaný podle nějakýho klíče. Každá tabulka má i nadefinováno, jaké hodnoty a jakého druhu jsou kde skladovaný podle názvu sloupečku, takže pro nalezení určitého údaje se stačí kouknout na jeden sloupeček a nemuset procházet dalších 15, tudíž potřebuješ přečíst velmi malý zlomek dat. Pro zápis je to ještě lepší, tam se to totiž koukne jen na čísla řádků ....a pamatuje si, u jakýho čísla skončil...tak tam jen přidá další....(oproti souboru, který se musí celý přečíst a na konci přidat záznam)

U malýho počtu dat to není takový rozdíl, ale jak data přibývají (hráči v authme atd), tak je stále těžší a těžší najít rychle ty správné informace. Proto je VELMI doporučováno vše napojit na MySQL, protože to může docela neuvěřitelně serveru pomoci být rychlejší....nezapomeň, že na "jeden tick, jednu operaci", má jen 1/20 sekundy.....pokud nestihne, jsou lagy....:)
Takže shrnutí: Pokud máš lagy, tak MySQL jich kopu zmizí. Pokud nemáš, časem bez MySQL mít budeš

Web od fakahedy je zcela jedno, databáze je zvlášť od webu i od serveru, nicméně k serveru máš databázi zdarma -> použij ji pokud možno jen k tomu jednomu serveru....proč? protože to jede na stejné mašině a tudíž neposílá požadavky přes internet, ale na localhost...

2) k těm pluginům:
PEX, iConomy, LWC, AuthMe -> určitě jde
pro všechny ostatní ti neřeknu, nepoužíval jsem je...
ALE -> projdi všechny configy a pokud tam v nich najdeš nastavení pro mysql, tak to mysql umí a napoj to. Většina pluginů má i nějakou tu funkci na převedení dat -> projdi dokumentace....pro PEX tu jsou i návody, doporučuji přečíst, osvětí se ti, jak to cca vše provést....to nastavení je pro všechny cca podobný.
Industry 2.0 -> 1.7.10 GregTech6 server. Pro připojení stačí napsat.
Člen ligy pro aktualizaci serverů na novější verze a rozšíření modovaného MC.
Discord FH : http://discord.fakaheda.eu/ (sem psát pokud chcete poradit s MC mody akutně)

Uživatelský avatar
Bisyss
Příspěvky: 760
Věk: 10
Registrován: 07 lis 2014, 15:54
Reputation: 1
Bydliště: http://netsword.cz/
Kontaktovat uživatele:

Re: MySQL- Dotazy

#3 Příspěvekod Bisyss » 25 úno 2015, 17:49

Hanakocz WOW díky .......

Ok ale furt netušim jak to připojit. Připojil by mi někdo zde zmíněné plugin prosím? :D (PEX, iConomy, LWC, AuthMe)

Za pomoc K+ !!!
Naposledy upravil(a) Bisyss dne 25 úno 2015, 19:18, celkem upraveno 1 x.
Konec .....

Uživatelský avatar
DenOwq
Příspěvky: 2703
Věk: 28
Registrován: 06 bře 2014, 21:26
Reputation: 2

Re: MySQL- Dotazy

#4 Příspěvekod DenOwq » 25 úno 2015, 18:06

Zkus si to napojit sám, nikdo tu není od toho aby vše udělal za tebe, pokud ti to nepůjde tak ti rádi pomůžeme.
Muhahha.

Uživatelský avatar
Hanakocz
Příspěvky: 3228
Věk: 34
Registrován: 25 črc 2013, 20:53
Reputation: 7
Kontaktovat uživatele:

Re: MySQL- Dotazy

#5 Příspěvekod Hanakocz » 25 úno 2015, 18:06

Vůbec se nesnažíš! :twisted:
1) zálohuj vše
2) radši dej whitelist nebo něco, ať ti tam nikdo nechodí, stejně bude potřeba hodně restartů (možná lepší plugin po pluginu, ne všechny naráz)
3) začni třeba tu: viewtopic.php?f=85&t=7854
Industry 2.0 -> 1.7.10 GregTech6 server. Pro připojení stačí napsat.
Člen ligy pro aktualizaci serverů na novější verze a rozšíření modovaného MC.
Discord FH : http://discord.fakaheda.eu/ (sem psát pokud chcete poradit s MC mody akutně)

Uživatelský avatar
Bisyss
Příspěvky: 760
Věk: 10
Registrován: 07 lis 2014, 15:54
Reputation: 1
Bydliště: http://netsword.cz/
Kontaktovat uživatele:

Re: MySQL- Dotazy

#6 Příspěvekod Bisyss » 25 úno 2015, 18:15

Nevim tak to jsem asi fakt hodně blbej ...... z toho navodu na PEX jsem nepobral ani slovo ..... a furt nic nechápu ......

ale i tak Hanakocz díky za snahu ....... a K+

-- 25 úno 2015, 17:52 --

Tak já jsem si stáhnul configy jednotlivých pluginu do PC a tam jsem to upravil tak to zde dávám ke kontrole ......

MySQL udaje:
-----------------------------------------
dbserver: clark.fakaheda.eu
dbname: 173592_mysql_db
dbuser: 173592_mysql_db
dbpass: ******
-----------------------------------------

AuthMe

Kód: Vybrat vše

DataSource:
  mySQLColumnName: username
  mySQLTablename: authme
  mySQLUsername: 173592_mysql_db
  backend: mysql
  mySQLColumnLastLogin: lastlogin
  mySQLDatabase: 173592_mysql_db
  mySQLPort: '3306'
  mySQLColumnIp: ip
  mySQLHost: 127.0.0.1
  mySQLColumnPassword: password
  mySQLPassword: ********
  caching: true
  mySQLlastlocX: x
  mySQLlastlocY: y
  mySQLlastlocZ: z
  mySQLlastlocWorld: world
  mySQLColumnEmail: email
  mySQLColumnId: id
  mySQLColumnLogged: isLogged
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: 3
    maxNicknameLength: 20
    ForceSingleSession: true
    ForceSpawnLocOnJoinEnabled: false
    SaveQuitLocation: false
    AllowRestrictedUser: false
    AllowedRestrictedUser:
    - playername;127.0.0.1
    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
    spawnPriority: authme,essentials,multiverse,default
    maxLoginPerIp: 0
    maxJoinPerIp: 0
    noTeleport: false
  GameMode:
    ForceSurvivalMode: true
    ResetInventoryIfCreative: false
    ForceOnlyAfterLogin: false
  security:
    minPasswordLength: 4
    unLoggedinGroup: unLoggedinGroup
    passwordHash: SHA256
    doubleMD5SaltLength: 8
    supportOldPasswordHash: false
    unsafePasswords: []
  registration:
    enabled: true
    messageInterval: 5
    force: true
    enableEmailRegistrationSystem: false
    doubleEmailCheck: false
    forceKickAfterRegister: false
    forceLoginAfterRegister: false
  unrestrictions:
    UnrestrictedName: []
  messagesLanguage: en
  forceCommands: []
  forceCommandsAsConsole: []
  useWelcomeMessage: true
  broadcastWelcomeMessage: false
  delayJoinMessage: false
ExternalBoardOptions:
  mySQLColumnSalt: ''
  mySQLColumnGroup: ''
  nonActivedUserGroup: -1
  mySQLOtherUsernameColumns: []
  bCryptLog2Round: 10
  phpbbTablePrefix: phpbb_
  phpbbActivatedGroupId: 2
  wordpressTablePrefix: wp_
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: true
  captcha:
    useCaptcha: false
    maxLoginTry: 5
    captchaLength: 5
Converter:
  Rakamak:
    fileName: users.rak
    useIP: false
    ipFileName: UsersIp.rak
Email:
  mailSMTP: smtp.gmail.com
  mailPort: 465
  mailAccount: ''
  mailPassword: ''
  mailSenderName: ''
  RecoveryPasswordLength: 8
  mailSubject: Your new AuthMe Password
  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'
  maxRegPerEmail: 1
  recallPlayers: false
  delayRecall: 5
Hooks:
  multiverse: true
  chestshop: true
  bungeecord: false
  notifications: true
  disableSocialSpy: true
  useEssentialsMotd: false
Performances:
  useMultiThreading: true
Purge:
  useAutoPurge: false
  daysBeforeRemovePlayer: 60
  removePlayerDat: false
  removeEssentialsFile: false
  defaultWorld: world
  removeLimitedCreativesInventories: false
  removeAntiXRayFile: false
Protection:
  enableProtection: false
  countries:
  - US
  - GB
  countriesBlacklist:
  - A1
  enableAntiBot: false
  antiBotSensibility: 5
  antiBotDuration: 10
VeryGames:
  enableIpCheck: false


LWC

Kód: Vybrat vše

core:
    locale: cz
    flushInterval: 10
    cacheSize: 10000
    precache: -1
    showNotices: true
    showMyNotices: false
    opIsLWCAdmin: true
    disableHistory: false
    townyBorders: false
    groupPrefix: group.
    updateNotifier: true
optional:
    onlyProtectWhenOwnerIsOnline: false
    onlyProtectWhenOwnerIsOffline: false
    exemptBlocks: []
    optOut: false
    blacklistedBlocks:
    - '166'
    - '154'
    blacklistedPlayers:
    - plr
    useProtectionLimits: true
database:
    adapter: MySQL
    path: plugins/LWC/lwc.db
    host: localhost
    database: 173592_mysql_db
    username: '173592_mysql_db'
    password: '***********'
    prefix: lwc_
    ping_interval: 300
protections:
    denyRedstone: false
    denyHoppers: true
    autoRegister: false
    ignoreBlockDestruction: false
    ignoreLeftClick: false
    ignoreRightClick: false
    ignoreExplosions: false
    allowEntityBreakDoor: false
    allowEntityInteract: false
    quiet: false
    readonly-modify: false
    readonly-remove: false
    blocks:
        chest:
            enabled: true
        furnace:
            enabled: true
        dispenser:
            enabled: true
        sign:
            enabled: true
        wooden_door:
            enabled: true
        iron_door:
            enabled: true
        spruce_door:
            enabled: true
        birch_door:
            enabled: true
        jungle_door:
            enabled: true
        acacia_door:
            enabled: true
        dark_oak_door:
            enabled: true
        trap_door:
            enabled: true
        iron_trapdoor:
            enabled: true
        fence_gate:
            enabled: true
        spruce_fence_gate:
            enabled: true
        birch_fence_gate:
            enabled: true
        jungle_fence_gate:
            enabled: true
        acacia_fence_gate:
            enabled: true
        dark_oak_fence_gate:
            enabled: true
        trapped_chest:
            enabled: true
modes:
    droptransfer:
        enabled: true
        crossWorld: false
    persist:
        enabled: true


iConomy

Kód: Vybrat vše

# iConomy 6.0.8b
# @author     Nijikokun <nijikokun@gmail.com>
# @license    GPLv2
# @copyright  Copyright AniGaiku LLC (C) 2010-2011
##
# Setup Notes
#   - Seconds
#         Basic Table:
#           1 minute = 60 seconds
#           1 hour = 1 minute * 60 = 3600 seconds
#           1 day = 1 hour * 24 = 86400 seconds
#           1 week = 1 day * 7 = 604800 seconds
#   - Database
#           Do not use remote databases from free sites, please use either a
#           remote database from a personal hosted VPS or DEDI or a local
#           database. This will prevent any 'timeout' or 'invalid settings'
#           or 'cannot connect to database' issues. Thank you :)!
##

System:
  Permissions:
    Use:
      # Should a user have the 'iConomy.holdings' to use /money
      # By default this is false, so that people stop complaining that
      # iConomy doesn't work. Yes, people actually report that.
      # If you are one of those people, leave this false.
      Holdings: false

  Default:
    Currency:
      # Major is the first segment [Major].Minor

      # Major ([Major].Minor) 1.00 Dollar (With Seperate 1 Dollar)
      Major: [ 'Dollar', 'Dollars' ]

      # Minor (Major.[Minor]) 0.23 Coins  (With Seperate 0 Dollars, 23 Coins)
      Minor: [ 'Coin', 'Coins' ]

    Account:
      # Default account balance when created
      Holdings: 30.0

  # Controls how money is formatted through methods
  Formatting:
    # Minor allows you to use the Minor amounts for amounts <1
    # Example (true) 0.23 Coins and 1.23 Dollars (false) 0.23 Dollars and 1.23 Dollars
    Minor: false

    # Seperate allows your money to be shown in an alternative way,
    # instead of 1.32 it will show as 1 Dollar 23 Coins
    # !!! NOTICE: This only works if Minor is set to true !!!
    Seperate: false                               # Example (true) 1 Dollar, 23 Coins (false) 1.23 Dollars (Only if Minor is true)

    # Single shows your money in another alternative way.
    # Instead of 1.23 Dollars you will see: 1 Dollar.
    # If your money is 0.23 you will see 0 Dollars if Minor is false, 23 Coins if Minor is true.
    # !!! Notice: This overrides seperate !!!
    Single: false

  # Logs all monetary transactions passed through iConomy
  Logging:
    Enabled: false

  # Purges Default Balances at Loading
  # Good way to keep unused accounts or default accounts wiped out and lower database usage.
  Purging:
    Enabled: true

  # Controls amount of money gained at a set interval.
  Interest:
    Enabled: false

    # Only give interest to players who are currently online?
    Online: true

    Announce:
      # Send a message when the player gains interest?
      Enabled: false

    Interval:
      #  Interval is done in seconds, here is a easy reference table for commonly set intervals:
      #   1 minute = 60 seconds
      #   1 hour = 1 minute * 60 = 3600 seconds
      #   1 day = 1 hour * 24 = 86400 seconds
      #   1 week = 1 day * 7 = 604800 seconds
      Seconds: 60

    Amount:
      # The balance to be met where we stop giving interest.
      # 0.0 for no limit
      Cutoff: 0.0

      # Percentage of holdings to give / take (Negative to take) (Overrides Min/Max)
      Percent: 0.0

      # This is range based, to set a "flat" or "constant" rate, set each (Maximum and Minimum) to the same number.
      # If the two numbers are different, it will be a random amount in-between the two.
      Maximum: 1
      Minimum: 2

  Database:
    # Databases Supported:
    # Flatfile, FF, mini, minidb
    #  - These all equate to miniDB
    ##
    # item, items, inventory, inventoryDB
    #  - These all equate to InventoryDB, which uses inventory for storage
    ##
    # xp, exp, orb, xpdb, expdb, orbdb
    #  - These all equate to ExperienceDB, which relies on Experience for balance.
    ##
    # mysql, mysqldb
    #  - These will attempt to connect to MySQL
    ##
    # sqlite, sqlite2, sqlite3, sqlitedb
    #  - These will attempt to create & connect to SQLite
    ##
    # postgre, postgreSQL, postgreDB
    #  - These will attempt to connect to PostgreSQL
    Type: 'mysql'
   
    # These are for InventoryDB only.
    #
    # InventoryDB is essentially Physical Money.
    #   It isn't logged in a database, its based on the users inventory
    #   and the two items selected below.
    #
    # MajorItem is the item or block ID of the major currency
    # MinorItem is the item or block ID of the minor currency
    # e.g. MajorItem: 266, MinorItem: 265 for Gold/Iron
    MajorItem: 266
    MinorItem: 265

    # This controls the database name, by default it is iConomy
    Table: 'iConomy'

    # URL is for SQL Databases Only
    ##
    # Path to iConomy folder is easy, it's the COMPLETE path.
    # (Mine) G:\MineCraft\plugins\iConomy\
    # Won't be the same as yours, but it usually looks like that.
    ##
    # [H2DB Default] h2:path/to/iConomy/folder/iConomy;AUTO_RECONNECT=TRUE
    # [SQLite Default] sqlite:path/to/iConomy/folder/iConomy.db
    ##
    # Binary Databases use ip:port style connections.
    # ip
    #  - is the connection identifier (internet protocol)
    #  - for ipv6 usually encased in brackets [::1]
    # port
    #  - the port that the database is listening on
    #  - defaults: 3306 for mysql, postgre is either 5740 or 5432
    ##
    # [MySQL Default] mysql://localhost:3306/iConomy
    # [Postgre Default] postgresql://localhost:5740/iConomy
    URL: 'mysql://localhost:3306/iConomy'

    # Login details for binary databases
    Username: '173592_mysql_db'
    Password: '**********'

    ##############################################################
    # !!! Conversion is not your database settings !!!
    ##############################################################
    # Conversion allows you to convert your old 5.x to the new 6.x
    # All is currently unused.
    ##############################################################
    # URL is for MySQL only, H2DB doesn't use it.
    ##############################################################
    Conversion:
      # Set to True, After converting, change this back to false!
      Enabled: false

      # Database Type, H2DB or MySQL
      Type: 'H2DB'

      # Database Table
      Table: 'iConomy'

      # Database URL without table at the end.
      URL: 'mysql://localhost:3306'

      # Username / Password
      # H2DB does not use this. MySQL Only.
      Username: '173592_mysql_db'
      Password: '********'

      # Unused ATM.
      All: true


CC

Kód: Vybrat vše

Database:
  ## MySQL, the database type, can be SQLite, MySQL or H2
  Type: MySQL
  ## host, the MySQL host name
  host: localhost
  ## port, the MySQL port
  port: 3306
  ## user, the MySQL user name
  user: 173592_mysql_db
  ## pass, the MySQL password, '' if none.
  pass:  ************
  ## database, the MySQL database to be used by this plugin
  database: 173592_mysql_db
  ## prefix, the prefix used to create the tables in the sql database
  prefix: crcr_

## This section will define which group the player will be added when he changes his gamemode.
Permissions:
  ## ChangeGroups, if true, creative players will be added to the 'CreativeGroup'
  ChangeGroups: false
  ## CreativeGroup, the group that the player will be put on when changing to creative
  CreativeGroup: MembersCreative
  ## KeepCurrentGroup, if true, the player will not lose his current group, the creative group will just be added to its current groups.
  KeepCurrentGroup: true
  ## OpHasPerm, if true, ops will have all the permissions and will not be checked by your permissions plugin
  OpHasPerm: false

Queue:
  ## Threads, the number of threads to be use to process the database
  Threads: 2
  ## Speed, the speed of the queue, if your server is taking too long to shutdown, increase this option.
  Speed: 0.1

Cache:
  ## MaxCapacity, the maximum cache capacity, higher this value is, better will be the performance, but also the memory usage will increase.
  MaxCapacity: 15000
  ## PreCache, the amount of items to be cached on startup, if you have a big database, this may increase the load time.
  PreCache: 10000

Configurations:
  ## Single, if true, only the world.yml file will be used, other ones will be ignored.
  Single: false
  ## Conflict, if true, if required, some functions of this plugin will be automatically disabled to avoid conflict.
  Conflict: true
  ## FriendSystem, if true, the friend system will be enabled, this may take a bit of resources, just a bit.
  FriendSystem: false

Updater:
  ## Check for updates?
  Enabled: true

Selection:
  ## UseWorldEdit, if true, worldedit will be used to make selections. Otherwise the tool defined below will be used.
  UseWorldEdit: true
  ## The Item ID used to select regions, if UseWorldEdit is false
  Tool: 369

Events:
  ## Use PlayerMoveEvent? This may take a lot of resources on large servers, but is required to Creative/Survival regions work.
  PlayerMove: false
  ## Enable MiscProtections? Not recommended to use, I'll probably remove it on future releases.
  MiscProtection: false

PlayerData:
  ## Inventory, if true, players will have an inventory to survival, other to creative an other to adventurer
  Inventory: false
  ## Status, if true, will save the player survival status [e.g Health, Food, etc]
  Status: true
  ## Teleport, if true, the player will be teleported to the floor on login if needed
  Teleport: false
  ## SetSurvival, if true, the player will be set to survival on login (ATTENTTION: THIS MAY GLITCH WITH AUTH PLUGINS)
  SetSurvival: false
  ## FallGlith, if true, if the player is falling and right before hitting the ground he change its gamemode to survival he wont take damage
  FallGlitch: false
  ## HideInventory, if true, the player inventory will be hidden until login using an auth plugin
  HideInventory: false

## This section will define the armor to set on every creative player, for advanced options, while wearing the armor type /cc set armor.
CreativeArmor:
  ## Helmet, the player helmet
  Helmet: 0
  ## Chestplate, the player chestplate
  Chestplate: 0
  ## Leggings, the player leggings
  Leggings: 0
  ## Boots, the player boots
  Boots: 0

Communicator:
  ## Quiet, if true, any messages will be displayed
  Quiet: false

Debug:
  ## Console, if true, debug messages will be displayed in the console
  Console: false
  ## Stack, if true, common errors will be printed by full [leave it true C:]
  Stack: true

# End of the file -->


Jobs

Kód: Vybrat vše

#   The general configuration for the jobs plugin mostly includes how often the plugin
# saves user data (when the user is in the game), the storage method, whether
# to broadcast a message to the server when a user goes up a skill level.
#   It also allows admins to set the maximum number of jobs a player can have at
# any one time.

# Default language.  Use your languages two digit ISO 639-1 code, and optionally followed by the ISO-3166-1 country code.
# Example: en, en_US
locale-language: en
# storage method, can be MySQL, sqlite
storage-method: MySQL
# Requires Mysql.
mysql-username: 173592_mysql_db
mysql-password: '*********'
mysql-hostname: localhost:3306
mysql-database: minecraft
mysql-table-prefix: jobs_
# How often in minutes you want it to save.  This must be a non-zero number
save-period: 10
# Should player data be saved on disconnect?
# Player data is always periodically auto-saved and autosaved during a clean shutdown.
# Only enable this if you have a multi-server setup, or have a really good reason for enabling this.
# Turning this on will decrease database performance.
save-on-disconnect: false
# Do all players get a message when somone goes up a skill level?
broadcast-on-skill-up: false
# Do all players get a message when somone goes up a level?
broadcast-on-level-up: false
# Maximum number of jobs a player can join.
# Use 0 for no maximum
max-jobs: 3
# Hide jobs from player if they lack the permission to join the job
hide-jobs-without-permission: false
# option to allow payment to be made when killing mobs from a spawner
enable-pay-near-spawner: false
# option to allow payment to be made in creative mode
enable-pay-creative: false
# Adds the Jobs xp recieved to the player's Minecraft XP bar
add-xp-player: false
# Modifys chat to add chat titles.  If you're using a chat manager, you may add the tag {jobs} to your chat format and disable this.
modify-chat: true
# Changes how often, in seconds, players are paid out.  Default is 5 seconds.
# Setting this too low may cause tick lag.  Increase this to improve economy performance (at the cost of delays in payment)
economy-batch-delay: 5
# Enable async economy calls.
# Only enable if your economy plugin is thread safe, use with EXTREME caution.
economy-async: false


Jinak děkuji

+ jak to mam provéct?

1) Zapnout WL
2) Vypnout server
3) Vložit ty upravene configy
4) Zapnout server a sledovat konzoly jestli to nehází errory.....
Když vše půjde tak je to napojené a vše je ok? Nebo je potřeba ještě něco nastavit?

Jinak u těch configu jsem zkontroloval formátování ale kouknul by se mi ne to někdo jestli je vše OK ???
Naposledy upravil(a) Bisyss dne 25 úno 2015, 23:09, celkem upraveno 1 x.
Konec .....

Uživatelský avatar
Huurcz
Příspěvky: 138
Registrován: 15 úno 2012, 16:45
Reputation: 0

Re: MySQL- Dotazy / Kontrola

#7 Příspěvekod Huurcz » 25 úno 2015, 22:55

u AuthMe
zmen:

Kód: Vybrat vše

backend: file
na
backend: mysql


+ pokud chces zapni si i češtinu

Kód: Vybrat vše

messagesLanguage: en
zmen na
messagesLanguage: cz
:-)

Uživatelský avatar
Bisyss
Příspěvky: 760
Věk: 10
Registrován: 07 lis 2014, 15:54
Reputation: 1
Bydliště: http://netsword.cz/
Kontaktovat uživatele:

Re: MySQL- Dotazy / Kontrola

#8 Příspěvekod Bisyss » 25 úno 2015, 23:12

Tak vše co je víš jsem dal na server.....

Zdej e log při startu serveru?

Kód: Vybrat vše

[FakaHeda] Succesfully authorized (rw)!
> [22:20:35 INFO]: [NoCheatPlus] Available (and activated) packet level hooks: FlyingFrequency | SoundDistance
> [22:20:35 INFO]: [NoCheatPlus] Version 3.11.1-RC-sMD5NET-b743 is enabled.
> [22:20:35 INFO]: [EssentialsSpawn] Enabling EssentialsSpawn vTeamCity
> [22:20:35 INFO]: [Paintball] Enabling Paintball v1.3.3
> [22:20:35 INFO]: [Paintball] Loading the default language: enUS.txt
> [22:20:35 INFO]: [Paintball] Scanned lines: 379 | Skipped lines: 0
> [22:20:35 INFO]: [Paintball] Using the default language now: enUS.txt
> [22:20:35 INFO]: [Paintball] Loading the specified melody now: win.txt
> [22:20:35 INFO]: [Paintball] Scanned .txt melody sucessfully. Lines: 20
> [22:20:35 INFO]: [Paintball] Loading the specified melody now: defeat.txt
> [22:20:35 INFO]: [Paintball] Scanned .txt melody sucessfully. Lines: 43
> [22:20:35 INFO]: [Paintball] Loading the specified melody now: draw.txt
> [22:20:35 INFO]: [Paintball] Scanned .txt melody sucessfully. Lines: 29
> [22:20:35 INFO]: [Paintball] Loading ranks..
> [22:20:35 INFO]: [Paintball] Plugin 'InSigns' not found. Additional sign features disabled.
> [22:20:35 INFO]: [Paintball] Plugin 'TagAPI' not found. Additional tag features disabled.
> [22:20:35 INFO]: [Paintball] Plugin 'Votifier' not found. Additional vote features disabled.
> [22:20:35 INFO]: [Paintball] By blablubbabc enabled.
> [22:20:35 INFO]: ineResetLite] Enabling MineResetLite v0.3.6
> [22:20:35 INFO]: ineResetLite] Loading mine from file 'glowstone.mine.yml'...
> [22:20:35 INFO]: ineResetLite] Loading mine from file 'brick.mine.yml'...
> [22:20:35 INFO]: ineResetLite] Loading mine from file 'drevo.mine.yml'...
> [22:20:35 INFO]: ineResetLite] Loading mine from file 'pisek.mine.yml'...
> [22:20:35 INFO]: ineResetLite] Loading mine from file 'kamen.mine.yml'...
> [22:20:35 INFO]: ineResetLite] Loading mine from file 'vlna.mine.yml'...
> [22:20:35 INFO]: ineResetLite] MineResetLite version 0.3.6 enabled!
> [22:20:35 INFO]: [AuthMe] Enabling AuthMe v3.4
> [22:20:35 INFO]: [AuthMe] Loading Configuration File...
> [22:20:35 INFO]: [AuthMe] Set Language: en
> [22:20:35 INFO]: [AuthMe] Vault plugin detected, hook with PermissionsEx system
> [22:20:35 INFO]: [AuthMe] Hook with Multiverse-Core for SpawnLocations
> [22:20:35 INFO]: [AuthMe] Hook with Essentials plugin
> [22:20:35 INFO]: [AuthMe] Hook with EssentialsSpawn plugin
> [22:20:35 INFO]: [AuthMe] MySQL driver loaded
> [22:20:35 INFO]: [AuthMe] Connection pool ready
> [22:20:36 INFO]: [AuthMe] LICENSE : This product includes GeoLite data created by MaxMind, available from http://www.maxmind.com
> [22:20:36 INFO]: [AuthMe] Authme 3.4 enabled
> [22:20:36 INFO]: [EssentialsChat] Enabling EssentialsChat vTeamCity
> [22:20:36 INFO]: obArena] Enabling MobArena v0.96.9
> [22:20:36 WARN]: org.bukkit.configuration.InvalidConfigurationException: expected '<document start>', but found Scalar
in 'string', line 53, column 1:
WAVE_SPECIAL=Vlna #%! [ZVLASTNOS ...
^

> [22:20:36 WARN]: at org.bukkit.configuration.file.YamlConfiguration.loadFromString(YamlConfiguration.java:57)
> [22:20:36 WARN]: at org.bukkit.configuration.file.FileConfiguration.load(FileConfiguration.java:226)
> [22:20:36 WARN]: at org.bukkit.configuration.file.FileConfiguration.load(FileConfiguration.java:169)
> [22:20:36 WARN]: at com.garbagemule.MobArena.MobArena.loadAnnouncementsFile(MobArena.java:198)
> [22:20:36 WARN]: at com.garbagemule.MobArena.MobArena.onEnable(MobArena.java:69)
> [22:20:36 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321)
> [22:20:36 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:327)
> [22:20:36 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404)
> [22:20:36 WARN]: at org.bukkit.craftbukkit.v1_8_R1.CraftServer.loadPlugin(CraftServer.java:340)
> [22:20:36 WARN]: at org.bukkit.craftbukkit.v1_8_R1.CraftServer.enablePlugins(CraftServer.java:312)
> [22:20:36 WARN]: at net.minecraft.server.v1_8_R1.MinecraftServer.q(MinecraftServer.java:394)
> [22:20:36 WARN]: at net.minecraft.server.v1_8_R1.MinecraftServer.k(MinecraftServer.java:362)
> [22:20:36 WARN]: at net.minecraft.server.v1_8_R1.MinecraftServer.a(MinecraftServer.java:317)
> [22:20:36 WARN]: at net.minecraft.server.v1_8_R1.DedicatedServer.init(DedicatedServer.java:190)
> [22:20:36 WARN]: at net.minecraft.server.v1_8_R1.MinecraftServer.run(MinecraftServer.java:473)
> [22:20:36 WARN]: at java.lang.Thread.run(Thread.java:744)
> [22:20:36 WARN]: Caused by: expected '<document start>', but found Scalar
in 'string', line 53, column 1:
WAVE_SPECIAL=Vlna #%! [ZVLASTNOS ...
^

> [22:20:36 WARN]: at org.yaml.snakeyaml.parser.ParserImpl$ParseDocumentStart.produce(ParserImpl.java:225)
> [22:20:36 WARN]: at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:158)
> [22:20:36 WARN]: at org.yaml.snakeyaml.parser.ParserImpl.checkEvent(ParserImpl.java:143)
> [22:20:36 WARN]: at org.yaml.snakeyaml.composer.Composer.getSingleNode(Composer.java:108)
> [22:20:36 WARN]: at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:120)
> [22:20:36 WARN]: at org.yaml.snakeyaml.Yaml.loadFromReader(Yaml.java:481)
> [22:20:36 WARN]: at org.yaml.snakeyaml.Yaml.load(Yaml.java:400)
> [22:20:36 WARN]: at org.bukkit.configuration.file.YamlConfiguration.loadFromString(YamlConfiguration.java:55)
> [22:20:36 WARN]: ... 15 more
> [22:20:36 INFO]: obArena] Vault found; economy rewards enabled.
> [22:20:36 INFO]: obArena] Loaded arena 'default'
> [22:20:36 INFO]: obArena] v0.96.9 enabled.
> [22:20:36 INFO]: ultiverse-Inventories] Enabling Multiverse-Inventories v2.5-b335
> [22:20:36 INFO]: ultiverse-Inventories 2.5-b335] enabled.
> [22:20:36 INFO]: [CreativeControl] Enabling CreativeControl v6.4
> [22:20:36 INFO]: Initializing configurations...
> [22:20:36 INFO]: Loading Modules...
> [22:20:36 INFO]: Connecting to the MySQL database...
> [22:20:36 INFO]: MySQL database connected Successfuly!
> [22:20:36 INFO]: Registring Events...
> [22:20:36 INFO]: MobArena support enabled!
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: Multiverse-Inventories Detected!!
> [22:20:36 INFO]: Per-GameMode inventories will be disabled by this plugin
> [22:20:36 INFO]: Use the multiverse inventories manager!
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: Multiverse-Inventories Detected!!
> [22:20:36 INFO]: Per-GameMode inventories will be disabled by this plugin
> [22:20:36 INFO]: Use the multiverse inventories manager!
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: Multiverse-Inventories Detected!!
> [22:20:36 INFO]: Per-GameMode inventories will be disabled by this plugin
> [22:20:36 INFO]: Use the multiverse inventories manager!
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: Multiverse-Inventories Detected!!
> [22:20:36 INFO]: Per-GameMode inventories will be disabled by this plugin
> [22:20:36 INFO]: Use the multiverse inventories manager!
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: Multiverse-Inventories Detected!!
> [22:20:36 INFO]: Per-GameMode inventories will be disabled by this plugin
> [22:20:36 INFO]: Use the multiverse inventories manager!
> [22:20:36 INFO]: ***************************************************
> [22:20:36 INFO]: Vault hooked as permissions plugin
> [22:20:36 INFO]: CreativeControl v6.4 loaded in 67 ms!
> [22:20:36 INFO]: Server permissions file permissions.yml is empty, ignoring it
> [22:20:36 INFO]: Done (5.742s)! For help, type "help" or "?"
> [22:20:36 INFO]: Starting GS4 status listener
> [22:20:36 INFO]: Starting remote control listener
> [22:20:36 INFO]: Query running on 93.91.250.119:27053
> [22:20:36 WARN]: No rcon password set in '/hlserver/27053/server.properties', rcon disabled!
> [22:20:36 INFO]: Trying to register generator with Multiverse
> [22:20:36 INFO]: Multiverse already knows about 'ASkyBlock'!
> [22:20:36 INFO]: Success! Property generator was set to ASkyBlock
> [22:20:36 INFO]: Multiverse already knows about 'ASkyBlock_nether'!
> [22:20:36 INFO]: [ASkyBlock] Loading warps...
> [22:20:36 INFO]: [Jobs] [Jobs] Successfully linked with Vault.
> [22:20:36 INFO]: Cached 0 protections
> [22:20:36 INFO]: Loaded 0 regions
> [22:20:36 INFO]: 0 blocks protected
> [22:20:36 WARN]: [NoCheatPlus] The block breaking data is incomplete, default to allow instant breaking:
> [22:20:36 WARN]: --- Missing entries -------------------------------
> [22:20:36 WARN]: * MISSING 165(SLIME_BLOCK / SOLID+GROUND)
> [22:20:36 WARN]: * MISSING 166(BARRIER / SOLID+GROUND)
> [22:20:36 WARN]: * MISSING 167(IRON_TRAPDOOR / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 168(PRISMARINE / SOLID+GROUND)
> [22:20:36 WARN]: * MISSING 169(SEA_LANTERN / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 176(STANDING_BANNER / IGN_PASSABLE)
> [22:20:36 WARN]: * MISSING 177(WALL_BANNER / IGN_PASSABLE)
> [22:20:36 WARN]: * MISSING 178(DAYLIGHT_DETECTOR_INVERTED / IGN_PASSABLE)
> [22:20:36 WARN]: * MISSING 179(RED_SANDSTONE / SOLID+GROUND)
> [22:20:36 WARN]: * MISSING 180(RED_SANDSTONE_STAIRS / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 181(DOUBLE_STONE_SLAB2 / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 182(STONE_SLAB2 / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 183(SPRUCE_FENCE_GATE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 184(BIRCH_FENCE_GATE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 185(JUNGLE_FENCE_GATE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 186(DARK_OAK_FENCE_GATE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 187(ACACIA_FENCE_GATE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 188(SPRUCE_FENCE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 189(BIRCH_FENCE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 190(JUNGLE_FENCE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 191(DARK_OAK_FENCE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 192(ACACIA_FENCE / SOLID+IGN_PASSABLE+GROUND+GROUND_HEIGHT)
> [22:20:36 WARN]: * MISSING 193(SPRUCE_DOOR / IGN_PASSABLE)
> [22:20:36 WARN]: * MISSING 194(BIRCH_DOOR / IGN_PASSABLE)
> [22:20:36 WARN]: * MISSING 195(JUNGLE_DOOR / IGN_PASSABLE)
> [22:20:36 WARN]: * MISSING 196(ACACIA_DOOR / IGN_PASSABLE)
> [22:20:36 WARN]: * MISSING 197(DARK_OAK_DOOR / IGN_PASSABLE)
> [22:20:36 INFO]: [NoCheatPlus] Post-enable running...
> [22:20:36 INFO]: [NoCheatPlus] Post-enable finished.
> [22:20:36 ERROR]: [WorldEdit] Got request to set EditSessionFactory of type me.FurH.CreativeControl.integration.worldedit.CreativeEditSessionFactory from me.FurH.CreativeControl.integration.worldedit but EditSessionFactories have been removed in favor of extending EditSession's extents.

This may mean that any block logger / intercepters addons/plugins/mods that you have installed will not intercept WorldEdit's changes! Please notify the maintainer of the other addon about this.
> [22:20:36 INFO]: [Vault] Checking for Updates ...
> [22:20:36 INFO]: [ASkyBlock] Loading island grid...
> [22:20:36 INFO]: [ASkyBlock] Loading islands.yml
> [22:20:36 INFO]: [ASkyBlock] All files loaded. Ready to play...
> [22:20:36 INFO]: [Vault] No new version available
> [22:20:37 INFO]: [1vs1] ***** 1vs1 Version Checker *****
> [22:20:37 INFO]: [1vs1] Stable Build: #211
> [22:20:37 INFO]: [1vs1] Current Build: #211
> [22:20:37 INFO]: [1vs1] No new version available
> [22:20:37 INFO]: [1vs1] *********************************
> [22:20:37 INFO]: [Paintball] --------- Checking version ----------
> [22:20:37 INFO]: [Paintball] You are running the latest version (or a dev- or compat-build). :)
> [22:20:37 INFO]: [Paintball] --------- ---------------- ----------
> [22:20:39 INFO]: 
> [22:20:39 INFO]:  **************************************************
> [22:20:39 INFO]:  ----------------- PAINTBALL INFO -----------------
> [22:20:39 INFO]: 
> [22:20:39 INFO]:  License stuff:
> [22:20:39 INFO]:  - Usage on own risk. I give no warranties for anything.
> [22:20:39 INFO]:  - Do not modify. Use it as it is!
> [22:20:39 INFO]:  - Do not redistribute/upload/use parts of it/copy/give away.
> [22:20:39 INFO]:  - Do not use for commercial purposes!
> [22:20:39 INFO]:  -> No benefits for paying players/donors!
> [22:20:39 INFO]:  -> This also applies to any kind of add-on you are using
> [22:20:39 INFO]:  related to this plugin!
> [22:20:39 INFO]: 
> [22:20:39 INFO]:  If you like this plugin: Give feedback and donate at
> [22:20:39 INFO]:  ->http://dev.bukkit.org/server-mods/paintball_pure_war/ 
> [22:20:39 INFO]: 
> [22:20:39 INFO]:  Thank you and good shooting!
> [22:20:39 INFO]:  - blablubbabc :)
> [22:20:39 INFO]: 
> [22:20:39 INFO]:  ---------------- Detected Problems ---------------
> [22:20:39 INFO]: 
> [22:20:39 INFO]:  No problems found. :)
> [22:20:39 INFO]: 
> [22:20:39 INFO]:  **************************************************
> [22:20:39 INFO]: 



Je vše v pořádku? A co mám dělat teď? Musí se ještě něco nastavit?
Konec .....

Uživatelský avatar
Hanakocz
Příspěvky: 3228
Věk: 34
Registrován: 25 črc 2013, 20:53
Reputation: 7
Kontaktovat uživatele:

Re: MySQL- Dotazy / Kontrola

#9 Příspěvekod Hanakocz » 25 úno 2015, 23:39

Spravil bych ten mobarena config

Kód: Vybrat vše

[22:20:36 INFO]: obArena] Enabling MobArena v0.96.9
> [22:20:36 WARN]: org.bukkit.configuration.InvalidConfigurationException: expected '<document start>', but found Scalar
in 'string', line 53, column 1:
WAVE_SPECIAL=Vlna #%! [ZVLASTNOS ...
^



Plus, povedlo se ti převést data z souborů do tý databáze?
Industry 2.0 -> 1.7.10 GregTech6 server. Pro připojení stačí napsat.
Člen ligy pro aktualizaci serverů na novější verze a rozšíření modovaného MC.
Discord FH : http://discord.fakaheda.eu/ (sem psát pokud chcete poradit s MC mody akutně)

Uživatelský avatar
Frank_ACE
Příspěvky: 548
Registrován: 08 dub 2014, 21:10
Reputation: 0

Re: MySQL- Dotazy / Kontrola

#10 Příspěvekod Frank_ACE » 26 úno 2015, 08:47

Vzdyt ti staci 4 udaje. Jmeno databaze, jmeno usera, heslo a adresa databaze. No a ty 4 udaje musis dopast do configu pluginu. Nic vic a nic min. Vsechny udaje musis mit nekde na mailu. Je to opravdu tak slozity?


Zpět na „Minecraft, Tekkit“

Kdo je online

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