It's possible that my database doesn't connect. I just went into my database and it doesn't seem that it created anything:

val dataSource = HikariDataSource().apply {
        maximumPoolSize = 20
        driverClassName = "com.mysql.jdbc.Driver"
        jdbcUrl = File("jdbc_url.txt").readText()
        isAutoCommit = false
    }

    Database.Companion.connect(dataSource)

    transaction {
        SchemaUtils.create(MediaPropertiesTable)
        SchemaUtils.create(MediaContentTable)
        SchemaUtils.create(UserAPIKeysTable)
        SchemaUtils.create(UserTable)
    }

The file jdbc_url.txt does exist and has a connection url generated from pterodactyl UPDATE: Tried removing pterodactyl from the equation and still doesnt work. It gets past the create code and all, nothing gets logged even after adding

addLogger(StdOutSqlLogger)

and the tables arent in the db.

maybe the problem is in

autoCommit = false

, try like this:

transaction { 
  // create 
  commit () 
}

the query is displayed in the log?

@Dominick , can you connect to database without the HikariDataSource? Also I can't see that you provide username/password, are they in jdbc_url?

I've solved the problem, in the end I think it was the jdbc url & the connector, I switched to a mysql jdbc url and specifying the username & password with addDataSourceProperty, and ensuring the connector I depended on was mysql-connector-java, even though it's a mariadb.