Class SQLCoreProvider

java.lang.Object

pro.gravit.launchserver.auth.core.AuthCoreProvider

pro.gravit.launchserver.auth.core.AbstractSQLCoreProvider

pro.gravit.launchserver.auth.core.SQLCoreProvider

All Implemented Interfaces:

AutoCloseable, AuthSupport, AuthSupportExtendedCheckServer, AuthSupportHardware, AuthSupportSudo, Reconfigurable

public class SQLCoreProvider
extends AbstractSQLCoreProvider
implements AuthSupportHardware, AuthSupportExtendedCheckServer

SQL-backed auth provider with hardware-ID tracking and optional TOTP support.

Required configuration fields (in addition to base class)

• hardwareIdColumn – FK column in the user table pointing to the hwids table

Optional configuration fields

• AbstractSQLCoreProvider.totpSecretColumn – when set, the TOTP secret is read from this column and stored on AbstractSQLCoreProvider.SQLUser.totpSecret. When null the column is completely absent from every SELECT query and ResultSet mapping.
• tableHWID – defaults to "hwids"
• tableHWIDLog – defaults to "hwidLog"
• criticalCompareLevel – fuzzy-match threshold, defaults to 1.0

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	SQLCoreProvider.SQLUser
static class	SQLCoreProvider.SQLUserHardware	Immutable hardware record (except mutable publicKey and banned).
class	SQLCoreProvider.SQLUserSession	Session with lazy-loaded hardware info.

Nested classes/interfaces inherited from class AbstractSQLCoreProvider

AbstractSQLCoreProvider.ColumnFeature<U,T>

Nested classes/interfaces inherited from class AuthCoreProvider

AuthCoreProvider.OAuthAccessTokenExpired, AuthCoreProvider.PasswordVerifyReport

Nested classes/interfaces inherited from interface AuthSupportHardware

AuthSupportHardware.HardwareInfoCompareResult

Field Summary

Fields

Modifier and Type	Field	Description
double	criticalCompareLevel	Minimum similarity level for a hardware record to be considered a match in getHardwareInfoByData(HardwareReportRequest.HardwareInfo).
String	customCreateHardware
String	customCreateHWIDLog
String	customFindHardwareByData
String	customFindHardwareById
String	customFindHardwareByPublicKey
String	customUpdateHardwarePublicKey
String	customUsersByHwidId
String	hardwareIdColumn	Column in the user table that holds the hardware-ID foreign key (required).
HikariSQLSourceConfig	holder	Hikari connection-pool config (required).
String	tableHWID	Hardware-info table name.
String	tableHWIDLog	Hardware-change audit-log table name.

Fields inherited from class AbstractSQLCoreProvider

accessTokenColumn, codeGenerator, customQueryByLoginSQL, customQueryByUsernameSQL, customQueryByUUIDSQL, customQueryPermissionsByUUIDSQL, customQueryRolesByUserUUID, customUpdateAuthSQL, customUpdateServerIdSQL, expireSeconds, logger, passwordColumn, passwordVerifier, permissionsPermissionColumn, permissionsTable, permissionsUUIDColumn, rolesNameColumn, rolesTable, rolesUUIDColumn, serverIDColumn, table, timeProvider, totpSecretColumn, usernameColumn, uuidColumn, verifier

Fields inherited from class AuthCoreProvider

pair, providers, server

Constructor Summary

Constructors

Constructor	Description
SQLCoreProvider()

Method Summary

Modifier and Type	Method	Description
void	addPublicKeyToHardwareInfo(UserHardware hardware, byte[] publicKey)
void	banHardware(UserHardware hardware)
protected void	buildPreparedQueries()	Builds all transient SQL strings.
void	close()
void	connectUserAndHardware(UserSession userSession, UserHardware hardware)
protected SQLCoreProvider.SQLUser	constructUserFromRow(ResultSet set)	Reads all required columns plus hardwareIdColumn, then lets the base class apply every registered optional column (including AbstractSQLCoreProvider.totpSecretColumn when enabled) via the AbstractSQLCoreProvider.ColumnFeature registry.
UserHardware	createHardwareInfo(pro.gravit.launcher.base.request.secure.HardwareReportRequest.HardwareInfo info, byte[] publicKey)
protected SQLCoreProvider.SQLUserSession	createSession(AbstractSQLCoreProvider.SQLUser user)
UserSession	extendedCheckServer(Client client, String username, String serverID)
UserHardware	getHardwareInfoByData(pro.gravit.launcher.base.request.secure.HardwareReportRequest.HardwareInfo info)
UserHardware	getHardwareInfoById(String id)
UserHardware	getHardwareInfoByPublicKey(byte[] publicKey)
SQLSourceConfig	getSQLConfig()
Iterable<User>	getUsersByHardwareInfo(UserHardware hardware)
void	init(LaunchServer server, AuthProviderPair pair)
protected String	makeUserCols()	hardwareIdColumn is a required column for this provider, so it is appended here rather than through the optional registry.
void	unbanHardware(UserHardware hardware)

Methods inherited from class AbstractSQLCoreProvider

applyOptionalColumns, authorize, checkServer, constructUser, executeSingleUpdate, getDetails, getUserByLogin, getUserByUsername, getUserByUUID, getUserSessionByOAuthAccessToken, isPermissionsEnabled, isRolesEnabled, joinServer, loadPermissions, refreshAccessToken, registerColumnFeature, registerOptionalColumns, safeQueryUser, sudo, updateAuth, updateServerID, verifyTotpCode

Methods inherited from class AuthCoreProvider

authorize, getCommands, isSupport, registerProviders, verifyAuth

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface AuthSupportHardware

compareHardwareInfo, normalizeHardwareInfo

Methods inherited from interface Reconfigurable

defaultCommandsMap

Field Details

holder

public HikariSQLSourceConfig holder

Hikari connection-pool config (required).

hardwareIdColumn

public String hardwareIdColumn

Column in the user table that holds the hardware-ID foreign key (required). This is a required column for this provider — it is always included in SELECT queries via makeUserCols(), not via the optional registry.

tableHWID

public String tableHWID

Hardware-info table name.

tableHWIDLog

public String tableHWIDLog

Hardware-change audit-log table name.

criticalCompareLevel

public double criticalCompareLevel

Minimum similarity level for a hardware record to be considered a match in getHardwareInfoByData(HardwareReportRequest.HardwareInfo).

customFindHardwareByPublicKey

public String customFindHardwareByPublicKey

customFindHardwareByData

public String customFindHardwareByData

customFindHardwareById

public String customFindHardwareById

customCreateHardware

public String customCreateHardware

customCreateHWIDLog

public String customCreateHWIDLog

customUpdateHardwarePublicKey

public String customUpdateHardwarePublicKey

customUsersByHwidId

public String customUsersByHwidId

Constructor Details

SQLCoreProvider

public SQLCoreProvider()

Method Details

getSQLConfig

public SQLSourceConfig getSQLConfig()

Specified by:

getSQLConfig in class AbstractSQLCoreProvider

init

public void init(LaunchServer server,
 AuthProviderPair pair)

Overrides:

init in class AbstractSQLCoreProvider

makeUserCols

protected String makeUserCols()

hardwareIdColumn is a required column for this provider, so it is appended here rather than through the optional registry. Optional columns (e.g. AbstractSQLCoreProvider.totpSecretColumn) are appended by AbstractSQLCoreProvider automatically after the required set.

Overrides:

makeUserCols in class AbstractSQLCoreProvider

buildPreparedQueries

protected void buildPreparedQueries()

Description copied from class: AbstractSQLCoreProvider

Builds all transient SQL strings. Called once per AbstractSQLCoreProvider.init(LaunchServer, AuthProviderPair) after the optional-column registry is finalised.

Subclasses that need additional SQL should override this and call super.buildPreparedQueries() first.

Overrides:

buildPreparedQueries in class AbstractSQLCoreProvider

constructUserFromRow

protected SQLCoreProvider.SQLUser constructUserFromRow(ResultSet set)
                                                throws SQLException

Reads all required columns plus hardwareIdColumn, then lets the base class apply every registered optional column (including AbstractSQLCoreProvider.totpSecretColumn when enabled) via the AbstractSQLCoreProvider.ColumnFeature registry.

Overrides:

constructUserFromRow in class AbstractSQLCoreProvider

Throws:

SQLException

close

public void close()

Specified by:

close in interface AutoCloseable

Overrides:

close in class AbstractSQLCoreProvider

getHardwareInfoByPublicKey

public UserHardware getHardwareInfoByPublicKey(byte[] publicKey)

Specified by:

getHardwareInfoByPublicKey in interface AuthSupportHardware

getHardwareInfoByData

public UserHardware getHardwareInfoByData(pro.gravit.launcher.base.request.secure.HardwareReportRequest.HardwareInfo info)

Specified by:

getHardwareInfoByData in interface AuthSupportHardware

getHardwareInfoById

public UserHardware getHardwareInfoById(String id)

Specified by:

getHardwareInfoById in interface AuthSupportHardware

createHardwareInfo

public UserHardware createHardwareInfo(pro.gravit.launcher.base.request.secure.HardwareReportRequest.HardwareInfo info,
 byte[] publicKey)

Specified by:

createHardwareInfo in interface AuthSupportHardware

connectUserAndHardware

public void connectUserAndHardware(UserSession userSession,
 UserHardware hardware)

Specified by:

connectUserAndHardware in interface AuthSupportHardware

addPublicKeyToHardwareInfo

public void addPublicKeyToHardwareInfo(UserHardware hardware,
 byte[] publicKey)

Specified by:

addPublicKeyToHardwareInfo in interface AuthSupportHardware

getUsersByHardwareInfo

public Iterable<User> getUsersByHardwareInfo(UserHardware hardware)

Specified by:

getUsersByHardwareInfo in interface AuthSupportHardware

banHardware

public void banHardware(UserHardware hardware)

Specified by:

banHardware in interface AuthSupportHardware

unbanHardware

public void unbanHardware(UserHardware hardware)

Specified by:

unbanHardware in interface AuthSupportHardware

extendedCheckServer

public UserSession extendedCheckServer(Client client,
 String username,
 String serverID)

Specified by:

extendedCheckServer in interface AuthSupportExtendedCheckServer

createSession

protected SQLCoreProvider.SQLUserSession createSession(AbstractSQLCoreProvider.SQLUser user)

Overrides:

createSession in class AbstractSQLCoreProvider