Authme怎么从sqlite转MySQL - 联机问答

是波板糖呀

本帖最后由是波板糖呀于 2021-12-4 13:11 编辑

Authme5.6.0
server1.17.1airplane
MySQL 5.5.62
phpMyAdmin 5.0
参考过站内文章以及Github教程
通过站内文章还是无法导入找不到问题
通过Github教程
即提示
[AuthMe] Successfully started sqliteToSql
Please configure your connection to MYSQL and re-run this command

文件貌似都是配置好了的，有点搞不懂
已自行解决
解决方法：
Command: /authme converter sqliteToSql
Set your config.yml to use the MySQL database you want to convert to. The SQLite database must be in plugins/AuthMe and have the same name as the configured database name ("DataSource.mySQLDatabase" in config.yml).

sqlite和mysql数据库名称一样即可

ABlueCat

发一下你的config.yml看看？

是波板糖呀

dengyu 发表于 2021-12-2 20:58
发一下你的config.yml看看？

DataSource:
# What type of database do you want to use?
# Valid values: SQLITE, MYSQL, POSTGRESQL
backend: MYSQL
# Enable the database caching system, should be disabled on bungeecord environments
# or when a website integration is being used.
caching: true
# Database host address
mySQLHost: 127.0.0.1
# Database port
mySQLPort: '3306'
# Connect to MySQL database over SSL
mySQLUseSSL: false
# Verification of server's certificate.
# We would not recommend to set this option to false.
# Set this option to false at your own risk if and only if you know what you're doing
mySQLCheckServerCertificate: true
# Username to connect to the MySQL database
mySQLUsername: texxxxx
# Password to connect to the MySQL database
mySQLPassword: dPxxx
# Driver Name of the MySQL database.
# Built-in drivers:
#    MySQL: 'com.mysql.cj.jdbc.Driver'
#    MariaDB: 'org.mariadb.jdbc.Driver'
mySQLDriverClassName: com.mysql.cj.jdbc.Driver
# Database Name, use with converters or as SQLITE database name
mySQLDatabase: texxxx
# 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 passwords salts
mySQLColumnSalt: ''
# Column for storing players emails
mySQLColumnEmail: email
# Column for storing if a player is logged in or not
mySQLColumnLogged: isLogged
# Column for storing if a player has a valid session or not
mySQLColumnHasSession: hasSession
# Column for storing a player's TOTP key (for two-factor authentication)
mySQLtotpKey: totp
# Column for storing the player's last IP
mySQLColumnIp: ip
# Column for storing players lastlogins
mySQLColumnLastLogin: lastlogin
# Column storing the registration date
mySQLColumnRegisterDate: regdate
# Column for storing the IP address at the time of registration
mySQLColumnRegisterIp: regip
# 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
# Column for storing player LastLocation - Yaw
mySQLlastlocYaw: yaw
# Column for storing player LastLocation - Pitch
mySQLlastlocPitch: pitch
# Column for storing players uuids (optional)
mySQLPlayerUUID: ''
# Overrides the size of the DB Connection Pool, default = 10
poolSize: 10
# The maximum lifetime of a connection in the pool, default = 1800 seconds
# You should set this at least 30 seconds less than mysql server wait_timeout
maxLifetime: 10

CrazyLogin:
      # CrazyLogin database file name
      fileName: TangBao.db
loginSecurity:
      # LoginSecurity: convert from SQLite; if false we use MySQL
      useSqlite: false
      mySql:
         # LoginSecurity MySQL: database host
         host: 127.0.0.1
         # LoginSecurity MySQL: database name
         database: texxx
         # LoginSecurity MySQL: database user
         user: texxx
         # LoginSecurity MySQL: password for database user
         password: dxxxxxxxx

ABlueCat

看起来似乎没问题，发一下Log？

是波板糖呀

dengyu 发表于 2021-12-2 21:20
看起来似乎没问题，发一下Log？

latest.log (7.7 KB, 下载次数: 3)

Ayamuta

数据库的database用配置默认的试试？

tnt-2

默认他存储的是sqlite的文件,应该你现在是想换做mysql的数据库:
1)把sqlite的数据库文件复制一份出来,并把config改为mysql;参考config

2)使用数据库第三方软件,如navicat;将复制出来的sqlite数据库文件进行加载
3)使用数据导出功能,导出默认表(表名字就叫authme)为第三格式(如导出为xls或sql文件)
4)新建一个mysql数据库,使用刚才导出的文件,导入向导至新建的这个数据库
5)注意配置好config的表名;数据库用户名;数据库密码

是波板糖呀

tnt-2 发表于 2021-12-3 10:37
默认他存储的是sqlite的文件,应该你现在是想换做mysql的数据库:
1)把sqlite的数据库文件复制一份出来,并把c ...

是波板糖呀

Ayamuta 发表于 2021-12-3 08:04
数据库的database用配置默认的试试？

貌似就是默认的吧