AuthMe - mysql

[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ť ?

[Smexhy]

Dať na ten druhý server plugin AuthMe a napojiť ho na rovnakú DB.

[Misso]

tak som to aj skúšal ale zhadzovalo mi server
takto som to mal:

Spoiler: zobrazit

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: false

error v konzoly:

Spoiler: zobrazit

Kód: Vybrat vše

[code]> [00:42:20 INFO]: [AuthMe] Enabling AuthMe v5.2-SNAPSHOT-b870
> [00:42:20 INFO]: [AuthMe] Connection arguments loaded, Hikari ConnectionPool ready!
> [00:42:20 INFO]: AuthMeMYSQLPool - Started.
> [00:42:20 INFO]: AuthMeMYSQLPool - Close initiated...
> [00:42:20 INFO]: AuthMeMYSQLPool - Closed.
> [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)
> [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ť ..

[Smexhy]

Ah tak FH to asi blokuje a povoluje len MySQL priradenu k serveru. Vyexportuj teda tabulku Authme a importuj do druhej db.

[Misso]

jop dík
K +