Stránka 1 z 1
AuthMe - mysql
Napsal: 05 črc 2016, 00:23
od Misso
Server: IP:93.91.250.102:27140
Čaute. Na jednom servery mám authme pripojený na mysql. A mám aj druhý server a chcel by som aby tam používali tie isté heslá aké mali. Ako to mám spraviť ?
Re: AuthMe - mysql
Napsal: 05 črc 2016, 00:33
od Smexhy
Dať na ten druhý server plugin AuthMe a napojiť ho na rovnakú DB.
Re: AuthMe - mysql
Napsal: 05 črc 2016, 00:43
od Misso
tak som to aj skúšal ale zhadzovalo mi server
takto som to mal:
Kód: Vybrat vše
DataSource:
# What type of database do you want to use?
# Valid values: sqlite, mysql
backend: 'mysql'
# Enable database caching, should improve database performance
caching: true
# Database host address
mySQLHost: '127.0.0.1'
# Database port
mySQLPort: '3306'
# Username about Database Connection Infos
mySQLUsername: '120951_mysql_db'
# Password about Database Connection Infos
mySQLPassword: '*********'
# Database Name, use with converters or as SQLITE database name
mySQLDatabase: '120951_mysql_db'
# Table of the database
mySQLTablename: 'authme'
# Column of IDs to sort data
mySQLColumnId: 'id'
# Column for storing or checking players nickname
mySQLColumnName: 'username'
# Column for storing or checking players RealName
mySQLRealName: 'realname'
# Column for storing players passwords
mySQLColumnPassword: 'password'
# Column for storing players emails
mySQLColumnEmail: 'email'
# Column for storing if a player is logged in or not
mySQLColumnLogged: 'isLogged'
# Column for storing players ips
mySQLColumnIp: 'ip'
# Column for storing players lastlogins
mySQLColumnLastLogin: 'lastlogin'
# Column for storing player LastLocation - X
mySQLlastlocX: 'x'
# Column for storing player LastLocation - Y
mySQLlastlocY: 'y'
# Column for storing player LastLocation - Z
mySQLlastlocZ: 'z'
# Column for storing player LastLocation - World Name
mySQLlastlocWorld: 'world'
# Enable this when you allow registration through a website
mySQLWebsite: falseerror v konzoly:
Kód: Vybrat vše
[code]>[2K [00:42:20 INFO]: [AuthMe] Enabling AuthMe v5.2-SNAPSHOT-b870
>[2K [00:42:20 INFO]: [AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
>[2K [00:42:20 INFO]: AuthMeMYSQLPool - Started.
>[2K [00:42:20 INFO]: AuthMeMYSQLPool - Close initiated...
>[2K [00:42:20 INFO]: AuthMeMYSQLPool - Closed.
>[2K [00:42:20 WARN]: [AuthMe] Fatal error occurred during database connection! Authme initialization aborted! [PoolInitializationException]: Failed to initialize pool: Access denied for user '120951_mysql_db'@'localhost' (using password: YES)
>[2K [00:42:20 WARN]: [AuthMe] THE SERVER IS GOING TO SHUT DOWN AS DEFINED IN THE CONFIGURATION![/code]tak som to skúšal napojiť na druhú DB a tam to išlo ale museli sa znova registrovať ..
Re: AuthMe - mysql
Napsal: 05 črc 2016, 00:52
od Smexhy
Ah tak FH to asi blokuje a povoluje len MySQL priradenu k serveru. Vyexportuj teda tabulku Authme a importuj do druhej db.
Re: AuthMe - mysql
Napsal: 05 črc 2016, 01:07
od Misso
jop dík
K +