hykilpikonna / AquaDX

A certain magical arcade server
https://aquadx.net
Other
251 stars 57 forks source link

An error occurred after building and attempting to run the project #27

Closed kanon511 closed 5 months ago

kanon511 commented 5 months ago

My English is not good, so I can only use translation software for conversations.

After building the v1 branch, I attempted to run it and encountered an error that I found difficult to determine and resolve. The following is the console log. Environment: Java 21, Windows 11, AMD R7 5800H.

Cmd Log

. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 04-06 18:45:32 INFO ENTRYK | EntryKt : Starting EntryKt v1.0.0 using Java 21.0.2 with PID 3960 (D:\Chunithm\ChunithmLum\bin\aqua.jar started by 27503 in D:\Chunithm\ChunithmLum\bin) 04-06 18:45:32 INFO ENTRYK | EntryKt : No active profile set, falling back to 1 default profile: "default" 04-06 18:45:33 INFO SYSTEM | .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 04-06 18:45:34 INFO SYSTEM | .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 526 ms. Found 154 JPA repository interfaces. 04-06 18:45:35 INFO SYSTEM | o.s.b.w.e.j.JettyServletWebServerFactory : Server initialized with port: 80 04-06 18:45:35 INFO SYSTEM | org.eclipse.jetty.server.Server : jetty-12.0.6; built: 2024-01-30T02:43:24.387Z; git: 78ab6e6ba163f89cdd97f2ae0283fbb5e371cfaf; jvm 21.0.2+13-LTS 04-06 18:45:35 INFO SYSTEM | o.e.j.s.h.ContextHandler.application : Initializing Spring embedded WebApplicationContext 04-06 18:45:35 INFO SYSTEM | w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2964 ms 04-06 18:45:35 INFO SYSTEM | o.e.j.session.DefaultSessionIdManager : Session workerName=node0 04-06 18:45:35 INFO SYSTEM | o.e.jetty.server.handler.ContextHandler : Started osbwej.JettyEmbeddedWebAppContext@5169db2f{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.9323039900460735826/,a=AVAILABLE,h=oeje10s.SessionHandler@912a644{STARTED}} 04-06 18:45:35 INFO SYSTEM | o.e.j.e.servlet.ServletContextHandler : Started osbwej.JettyEmbeddedWebAppContext@5169db2f{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.9323039900460735826/,a=AVAILABLE,h=oeje10s.SessionHandler@912a644{STARTED}} 04-06 18:45:35 INFO SYSTEM | org.eclipse.jetty.server.Server : Started oejs.Server@5470753a{STARTING}[12.0.6,sto=0] @5011ms 04-06 18:45:35 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 04-06 18:45:35 INFO SYSTEM | com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection org.sqlite.jdbc4.JDBC4Connection@54ddd7e4 04-06 18:45:35 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 04-06 18:45:36 INFO SYSTEM | org.flywaydb.core.FlywayExecutor : Database: jdbc:sqlite:data/db.sqlite (SQLite 3.45) 04-06 18:45:36 INFO SYSTEM | o.f.core.internal.command.DbValidate : Successfully validated 158 migrations (execution time 00:00.147s) 04-06 18:45:36 INFO SYSTEM | o.f.core.internal.command.DbMigrate : Current version of schema "main": 257 04-06 18:45:36 WARN SYSTEM | o.f.core.internal.command.DbMigrate : outOfOrder mode is active. Migration of schema "main" may not be reproducible. 04-06 18:45:36 INFO SYSTEM | o.f.core.internal.command.DbMigrate : Schema "main" is up to date. No migration necessary. 04-06 18:45:36 INFO SYSTEM | o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 04-06 18:45:36 INFO SYSTEM | org.hibernate.Version : HHH000412: Hibernate ORM core version 6.4.4.Final 04-06 18:45:36 INFO SYSTEM | o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 04-06 18:45:36 INFO SYSTEM | o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 04-06 18:45:36 WARN SYSTEM | o.h.e.j.e.i.JdbcEnvironmentInitiator : HHH000342: Could not obtain connection to query metadata org.hibernate.boot.registry.selector.spi.StrategySelectionException: Unable to resolve name [org.sqlite.hibernate.dialect.SQLiteDialect] as strategy [org.hibernate.dialect.Dialect] at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.selectStrategyImplementor(StrategySelectorImpl.java:154) at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:236) at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:189) at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:123) at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:88) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:328) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$1.execute(JdbcEnvironmentInitiator.java:277) at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:58) at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:70) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:276) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:107) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:130) at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215) at org.hibernate.boot.model.relational.Database.(Database.java:45) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:223) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.(InFlightMetadataCollectorImpl.java:191) at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:170) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1432) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1503) at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:75) at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:388) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:364) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1833) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1231) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:949) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) at icu.samnyan.aqua.EntryKt.main(Entry.kt:19) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53) at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58) Caused by: org.hibernate.boot.registry.classloading.spi.ClassLoadingException: Unable to load class [org.sqlite.hibernate.dialect.SQLiteDialect] at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:126) at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.selectStrategyImplementor(StrategySelectorImpl.java:150) ... 50 common frames omitted Caused by: java.lang.ClassNotFoundException: Could not load requested class : org.sqlite.hibernate.dialect.SQLiteDialect at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:216) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:593) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526) at java.base/java.lang.Class.forName0(Native Method) at java.base/java.lang.Class.forName(Class.java:534) at java.base/java.lang.Class.forName(Class.java:513) at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:123) ... 51 common frames omitted Caused by: java.lang.Throwable: null at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:209) ... 57 common frames omitted Suppressed: java.lang.ClassNotFoundException: org.sqlite.hibernate.dialect.SQLiteDialect at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:445) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:593) at org.springframework.boot.loader.net.protocol.jar.JarUrlClassLoader.loadClass(JarUrlClassLoader.java:104) at org.springframework.boot.loader.launch.LaunchedClassLoader.loadClass(LaunchedClassLoader.java:91) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526) at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:206) ... 57 common frames omitted Suppressed: java.lang.ClassNotFoundException: org.sqlite.hibernate.dialect.SQLiteDialect at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:445) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:593) at org.springframework.boot.loader.net.protocol.jar.JarUrlClassLoader.loadClass(JarUrlClassLoader.java:104) at org.springframework.boot.loader.launch.LaunchedClassLoader.loadClass(LaunchedClassLoader.java:91) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526) at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:206) ... 57 common frames omitted Suppressed: java.lang.ClassNotFoundException: org.sqlite.hibernate.dialect.SQLiteDialect at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641) at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526) at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:206) ... 57 common frames omitted 04-06 18:45:36 ERROR SYSTEM | j.LocalContainerEntityManagerFactoryBean : Failed to initialize JPA EntityManagerFactory: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to resolve name [org.sqlite.hibernate.dialect.SQLiteDialect] as strategy [org.hibernate.dialect.Dialect] 04-06 18:45:36 WARN SYSTEM | ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to resolve name [org.sqlite.hibernate.dialect.SQLiteDialect] as strategy [org.hibernate.dialect.Dialect] 04-06 18:45:36 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 04-06 18:45:36 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. 04-06 18:45:36 INFO SYSTEM | org.eclipse.jetty.server.Server : Stopped oejs.Server@5470753a{STOPPING}[12.0.6,sto=0] 04-06 18:45:36 INFO SYSTEM | o.e.j.e.servlet.ServletContextHandler : Stopped osbwej.JettyEmbeddedWebAppContext@5169db2f{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.9323039900460735826/,a=AVAILABLE,h=oeje10s.SessionHandler@912a644{STOPPED}} 04-06 18:45:36 INFO SYSTEM | .s.b.a.l.ConditionEvaluationReportLogger : Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled. 04-06 18:45:36 ERROR SYSTEM | o.s.boot.SpringApplication : Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to resolve name [org.sqlite.hibernate.dialect.SQLiteDialect] as strategy [org.hibernate.dialect.Dialect] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1786) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1231) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:949) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) at icu.samnyan.aqua.EntryKt.main(Entry.kt:19) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53) at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58) Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Unable to resolve name [org.sqlite.hibernate.dialect.SQLiteDialect] as strategy [org.hibernate.dialect.Dialect] at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:276) at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:238) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:215) at org.hibernate.boot.model.relational.Database.(Database.java:45) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:223) at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.(InFlightMetadataCollectorImpl.java:191) at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:170) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1432) at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1503) at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:75) at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:388) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:364) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1833) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) ... 21 common frames omitted Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Unable to resolve name [org.sqlite.hibernate.dialect.SQLiteDialect] as strategy [org.hibernate.dialect.Dialect] at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.selectStrategyImplementor(StrategySelectorImpl.java:154) at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:236) at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:189) at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:123) at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:88) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentWithDefaults(JdbcEnvironmentInitiator.java:143) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentUsingJdbcMetadata(JdbcEnvironmentInitiator.java:348) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:107) at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:130) at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) ... 36 common frames omitted Caused by: org.hibernate.boot.registry.classloading.spi.ClassLoadingException: Unable to load class [org.sqlite.hibernate.dialect.SQLiteDialect] at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:126) at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.selectStrategyImplementor(StrategySelectorImpl.java:150) ... 46 common frames omitted Caused by: java.lang.ClassNotFoundException: Could not load requested class : org.sqlite.hibernate.dialect.SQLiteDialect at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:216) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:593) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526) at java.base/java.lang.Class.forName0(Native Method) at java.base/java.lang.Class.forName(Class.java:534) at java.base/java.lang.Class.forName(Class.java:513) at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:123) ... 47 common frames omitted Caused by: java.lang.Throwable: null at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:209) ... 53 common frames omitted Suppressed: java.lang.ClassNotFoundException: org.sqlite.hibernate.dialect.SQLiteDialect at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:445) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:593) at org.springframework.boot.loader.net.protocol.jar.JarUrlClassLoader.loadClass(JarUrlClassLoader.java:104) at org.springframework.boot.loader.launch.LaunchedClassLoader.loadClass(LaunchedClassLoader.java:91) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526) at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:206) ... 53 common frames omitted Suppressed: java.lang.ClassNotFoundException: org.sqlite.hibernate.dialect.SQLiteDialect at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:445) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:593) at org.springframework.boot.loader.net.protocol.jar.JarUrlClassLoader.loadClass(JarUrlClassLoader.java:104) at org.springframework.boot.loader.launch.LaunchedClassLoader.loadClass(LaunchedClassLoader.java:91) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526) at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:206) ... 53 common frames omitted Suppressed: java.lang.ClassNotFoundException: org.sqlite.hibernate.dialect.SQLiteDialect at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641) at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526) at org.hibernate.boot.registry.classloading.internal.AggregatedClassLoader.findClass(AggregatedClassLoader.java:206) ... 53 common frames omitted

hykilpikonna commented 5 months ago

This is because you're using SQLite as your database in the config. SQLite is not supported in v1 yet. Please either setup MariaDB or run it using Docker (install Docker Desktop, clone the repo, and run docker compose up)

kanon511 commented 5 months ago

I installed Docker and ran the "docker compose up" command in the project folder, but there was an error during the build. Forgive me for not understanding databases and network communication enough, thank you.


2024/04/06 22:28:13 http2: server: error reading preface from client //./pipe/docker_engine: file has already been closed
[+] Building 1.4s (13/16)                                                                                docker:default
 => [app internal] load build definition from Dockerfile                                                           0.0s
 => => transferring dockerfile: 1.13kB                                                                             0.0s
 => [app internal] load metadata for docker.io/library/eclipse-temurin:21-jre-alpine                               1.1s
 => [app internal] load metadata for docker.io/library/gradle:jdk21-alpine                                         1.1s
 => [app internal] load .dockerignore                                                                              0.0s
 => => transferring context: 2B                                                                                    0.0s
 => [app builder 1/8] FROM docker.io/library/gradle:jdk21-alpine@sha256:338482545fed2af5a66c84223145c8cfa094c9b57  0.0s
 => [app internal] load build context                                                                              0.1s
 => => transferring context: 117.93kB                                                                              0.0s
 => [app stage-1 1/3] FROM docker.io/library/eclipse-temurin:21-jre-alpine@sha256:6f78a61a2aa1e6907dda2da3eb791d4  0.0s
 => CACHED [app stage-1 2/3] WORKDIR /app                                                                          0.0s
 => CACHED [app builder 2/8] COPY --chown=gradle:gradle gradlew /home/gradle/                                      0.0s
 => CACHED [app builder 3/8] COPY --chown=gradle:gradle gradle /home/gradle/gradle                                 0.0s
 => CACHED [app builder 4/8] COPY --chown=gradle:gradle build.gradle.kts settings.gradle.kts /home/gradle/         0.0s
 => CACHED [app builder 5/8] WORKDIR /home/gradle                                                                  0.0s
 => ERROR [app builder 6/8] RUN ./gradlew dependencies                                                             0.2s
------
 > [app builder 6/8] RUN ./gradlew dependencies:
0.190 /bin/sh: ./gradlew: not found
------
failed to solve: process "/bin/sh -c ./gradlew dependencies" did not complete successfully: exit code: 127```
kanon511 commented 5 months ago

I tried to run MariaDB directly as the database, and the tables in the database were successfully initialized, but there were errors during further loading after initialization.

Cmd Log

. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 04-07 15:46:54 INFO ENTRYK | EntryKt : Starting EntryKt v1.0.0 using Java 21.0.2 with PID 8020 (D:\Chunithm\ChunithmLum\bin\aqua.jar started by 27503 in D:\Chunithm\ChunithmLum\bin) 04-07 15:46:55 INFO ENTRYK | EntryKt : No active profile set, falling back to 1 default profile: "default" 04-07 15:46:56 INFO SYSTEM | .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 04-07 15:46:57 INFO SYSTEM | .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 551 ms. Found 154 JPA repository interfaces. 04-07 15:46:58 INFO SYSTEM | o.s.b.w.e.j.JettyServletWebServerFactory : Server initialized with port: 80 04-07 15:46:58 INFO SYSTEM | org.eclipse.jetty.server.Server : jetty-12.0.6; built: 2024-01-30T02:43:24.387Z; git: 78ab6e6ba163f89cdd97f2ae0283fbb5e371cfaf; jvm 21.0.2+13-LTS 04-07 15:46:59 INFO SYSTEM | o.e.j.s.h.ContextHandler.application : Initializing Spring embedded WebApplicationContext 04-07 15:46:59 INFO SYSTEM | w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 3493 ms 04-07 15:46:59 INFO SYSTEM | o.e.j.session.DefaultSessionIdManager : Session workerName=node0 04-07 15:46:59 INFO SYSTEM | o.e.jetty.server.handler.ContextHandler : Started osbwej.JettyEmbeddedWebAppContext@1a53ac0c{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.5311132248979856959/,a=AVAILABLE,h=oeje10s.SessionHandler@7fdf7359{STARTED}} 04-07 15:46:59 INFO SYSTEM | o.e.j.e.servlet.ServletContextHandler : Started osbwej.JettyEmbeddedWebAppContext@1a53ac0c{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.5311132248979856959/,a=AVAILABLE,h=oeje10s.SessionHandler@7fdf7359{STARTED}} 04-07 15:46:59 INFO SYSTEM | org.eclipse.jetty.server.Server : Started oejs.Server@ea45a5b{STARTING}[12.0.6,sto=0] @5963ms 04-07 15:46:59 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 04-07 15:46:59 INFO SYSTEM | com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection org.mariadb.jdbc.Connection@7369208e 04-07 15:46:59 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 04-07 15:46:59 WARN SYSTEM | o.m.jdbc.message.server.ErrorPacket : Error: 1193-HY000: Unknown system variable 'WSREP_ON' 04-07 15:46:59 INFO SYSTEM | org.flywaydb.core.FlywayExecutor : Database: jdbc:mariadb://localhost/aqua (MariaDB 11.2) 04-07 15:47:00 INFO SYSTEM | o.f.core.internal.command.DbValidate : Successfully validated 174 migrations (execution time 00:00.124s) 04-07 15:47:00 INFO SYSTEM | o.f.core.internal.command.DbMigrate : Current version of schema `aqua`: 1000.14 04-07 15:47:00 WARN SYSTEM | o.f.core.internal.command.DbMigrate : outOfOrder mode is active. Migration of schema `aqua` may not be reproducible. 04-07 15:47:00 INFO SYSTEM | o.f.core.internal.command.DbMigrate : Schema `aqua` is up to date. No migration necessary. 04-07 15:47:00 INFO SYSTEM | o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 04-07 15:47:00 INFO SYSTEM | org.hibernate.Version : HHH000412: Hibernate ORM core version 6.4.4.Final 04-07 15:47:00 INFO SYSTEM | o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 04-07 15:47:00 INFO SYSTEM | o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 04-07 15:47:03 INFO SYSTEM | o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration) 04-07 15:47:03 INFO SYSTEM | j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 04-07 15:47:04 INFO SYSTEM | o.s.d.j.r.query.QueryEnhancerFactory : Hibernate is in classpath; If applicable, HQL parser will be used. 04-07 15:47:07 WARN NET | net.components.JWT : USING DEFAULT JWT SECRET, PLEASE SET aqua-net.jwt IN CONFIGURATION 04-07 15:47:07 WARN NET | net.components.JWT : JWT Secret is less than 256 bits, padding with 0. PLEASE USE A STRONGER SECRET! 04-07 15:47:07 INFO NET | net.components.JWT : JWT Service Enabled 04-07 15:47:07 WARN SYSTEM | ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'emailService' defined in URL [jar:nested:/D:/Chunithm/ChunithmLum/bin/aqua.jar/!BOOT-INF/classes/!/icu/samnyan/aqua/net/components/EmailService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'defaultMailer' defined in class path resource [org/simplejavamail/springsupport/SimpleJavaMailSpringSupport.class]: Failed to instantiate [org.simplejavamail.api.mailer.Mailer]: Factory method 'defaultMailer' threw exception with message: SMTP server host missing 04-07 15:47:07 INFO SYSTEM | j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' 04-07 15:47:07 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 04-07 15:47:07 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. 04-07 15:47:07 INFO SYSTEM | org.eclipse.jetty.server.Server : Stopped oejs.Server@ea45a5b{STOPPING}[12.0.6,sto=0] 04-07 15:47:07 INFO SYSTEM | o.e.j.e.servlet.ServletContextHandler : Stopped osbwej.JettyEmbeddedWebAppContext@1a53ac0c{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.5311132248979856959/,a=AVAILABLE,h=oeje10s.SessionHandler@7fdf7359{STOPPED}} 04-07 15:47:07 INFO SYSTEM | .s.b.a.l.ConditionEvaluationReportLogger : Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled. 04-07 15:47:07 ERROR SYSTEM | o.s.boot.SpringApplication : Application run failed org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'emailService' defined in URL [jar:nested:/D:/Chunithm/ChunithmLum/bin/aqua.jar/!BOOT-INF/classes/!/icu/samnyan/aqua/net/components/EmailService.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'defaultMailer' defined in class path resource [org/simplejavamail/springsupport/SimpleJavaMailSpringSupport.class]: Failed to instantiate [org.simplejavamail.api.mailer.Mailer]: Factory method 'defaultMailer' threw exception with message: SMTP server host missing at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:798) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:237) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1355) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1192) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:959) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) at icu.samnyan.aqua.EntryKt.main(Entry.kt:19) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53) at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultMailer' defined in class path resource [org/simplejavamail/springsupport/SimpleJavaMailSpringSupport.class]: Failed to instantiate [org.simplejavamail.api.mailer.Mailer]: Factory method 'defaultMailer' threw exception with message: SMTP server host missing at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:651) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:639) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1335) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1165) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:562) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:254) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1443) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1353) at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:907) at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:785) ... 24 common frames omitted Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.simplejavamail.api.mailer.Mailer]: Factory method 'defaultMailer' threw exception with message: SMTP server host missing at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:177) at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:647) ... 38 common frames omitted Caused by: java.lang.IllegalArgumentException: SMTP server host missing at org.simplejavamail.internal.util.MiscUtil.checkArgumentNotEmpty(MiscUtil.java:76) at org.simplejavamail.mailer.internal.MailerRegularBuilderImpl.buildServerConfig(MailerRegularBuilderImpl.java:221) at org.simplejavamail.mailer.internal.MailerImpl.(MailerImpl.java:123) at org.simplejavamail.mailer.internal.MailerRegularBuilderImpl.buildMailer(MailerRegularBuilderImpl.java:212) at org.simplejavamail.springsupport.SimpleJavaMailSpringSupport.defaultMailer(SimpleJavaMailSpringSupport.java:117) at org.simplejavamail.springsupport.SimpleJavaMailSpringSupport$$SpringCGLIB$$0.CGLIB$defaultMailer$0() at org.simplejavamail.springsupport.SimpleJavaMailSpringSupport$$SpringCGLIB$$FastClass$$1.invoke() at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:258) at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) at org.simplejavamail.springsupport.SimpleJavaMailSpringSupport$$SpringCGLIB$$0.defaultMailer() at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:140) ... 39 common frames omitted

application.properties

## This is a configuration file which included in the Aqua Server package. ## AimeDb server setting aimedb.server.enable=true aimedb.server.port=22345 ## Billing server setting billing.server.enable=true billing.server.port=8443 ## Server host & port return to client when boot up. ## By default the same address and port from the client connection is returned. ## Please notice most games won't work with localhost or 127.0.0.1 allnet.server.host=localhost allnet.server.port=80 ## This is for some games that use shop name for in-game functions. ## Specify the place name here if you need it. By default it is empty. #allnet.server.place-name= ## This enables client serial validation during power on request using keychip table in database. ## Only enable this if you know what you are doing. #allnet.server.check-keychip=false ## Http Server Port ## Only change this if you have a reverse proxy running. ## The game rely on 80 port for boot up command # server.port=80 ## Static file server ## This is used to server static files in /web/ directory, which is Aquaviewer # aquaviewer.server.enable=true ## Chunithm ## This enables team function if you set team name here. Leave this blank to disable it. game.chunithm.team-name= ## Chusan ## The version of your client data. If this doesn't match with your game, you will not be able to play some game modes. ## Match this with data.conf file in latest option. ## For example, if data.conf says "VerMajor = 2, VerMinor = 5, VerRelease = 4" then this need to be 2.05.04 game.chusan.version=2.20.00 ## The version of your client rom. Same applies as above. ## Match this with version in "Game system information" of test menu. game.chusan.rom-version=2.20.01 ## This enables team function if you set team name here. Leave this blank to disable it. game.chusan.team-name= ## This enables user use login bonus function if set to true. game.chusan.loginbonus-enable=false ## Ongeki ## The version of your client. Match this with DataConfig.xml file in latest option. (only if bright memory and up) ## For example, if DataConfig.xml says "1, 35, 1" then this need to be 1.35.01 game.ongeki.version=1.05.00 ## Limit rival list size for per user, it will be unlimited if this value <= 0 (CAUTION!). game.ongeki.rival.rivals-max-count=10 ## Maimai DX ## Set this true if you are using old version of Splash network patch and have no other choice. ## This is a dirty workaround. If enabled, you probably won't able to play other versions. game.maimai2.splash-old-patch=false ## Allow users take photo as their avatar/portrait photo. game.maimai2.userPhoto.enable=true ## Specify folder path that user portrait photo and its (.json) data save to. game.maimai2.userPhoto.picSavePath=data/userPhoto ## When uploading user portraits, limit the divMaxLength parameter. 1 divLength is about equal to the file size of 10kb. ## The default value is 32 (320kb), and the minimum value is 1 (10kb) game.maimai2.userPhoto.divMaxLength=32 ## Logging spring.servlet.multipart.max-file-size=10MB spring.servlet.multipart.max-request-size=20MB ## Database Setting ########## For Sqlite ########## # spring.datasource.driver-class-name=org.sqlite.JDBC # spring.datasource.url=jdbc:sqlite:data/db.sqlite # spring.jpa.properties.hibernate.dialect=org.sqlite.hibernate.dialect.SQLiteDialect ########## For MariaDB ########## spring.datasource.driver-class-name=org.mariadb.jdbc.Driver spring.datasource.username=*** spring.datasource.password=*** spring.datasource.url=jdbc:mariadb://localhost:3306/aqua # ?allowPublicKeyRetrieval=true&useSSL=false spring.datasource.hikari.maximum-pool-size=10 ########## For MySQL ########## #spring.datasource.driver-class-name=com.mysql.jdbc.Driver #spring.datasource.username= #spring.datasource.password= #spring.datasource.url=jdbc:mysql://localhost:3306/insert_db_name_here?allowPublicKeyRetrieval=true&useSSL=false #spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect #spring.datasource.hikari.maximum-pool-size=10 ## You can add any Spring Boot properties below

Becods commented 5 months ago

https://github.com/hykilpikonna/AquaDX/blob/4ef0ac3feee581ae8fb94afda8f7dfd8832540f4/config/application.properties#L103-L115

kanon511 commented 5 months ago

I want to set up a personal local server on Windows. Do I need to configure the SMTP service. If I enable the SMTP service in the configuration file, the Cmdwill pop up:

Open

. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.3) 04-07 19:25:33 INFO ENTRYK | EntryKt : Starting EntryKt v1.0.0 using Java 21.0.2 with PID 26680 (D:\Chunithm\ChunithmLum\bin\aqua.jar started by 27503 in D:\Chunithm\ChunithmLum\bin) 04-07 19:25:34 INFO ENTRYK | EntryKt : No active profile set, falling back to 1 default profile: "default" 04-07 19:25:35 INFO SYSTEM | .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 04-07 19:25:36 INFO SYSTEM | .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 438 ms. Found 154 JPA repository interfaces. 04-07 19:25:37 INFO SYSTEM | o.s.b.w.e.j.JettyServletWebServerFactory : Server initialized with port: 80 04-07 19:25:37 INFO SYSTEM | org.eclipse.jetty.server.Server : jetty-12.0.6; built: 2024-01-30T02:43:24.387Z; git: 78ab6e6ba163f89cdd97f2ae0283fbb5e371cfaf; jvm 21.0.2+13-LTS 04-07 19:25:37 INFO SYSTEM | o.e.j.s.h.ContextHandler.application : Initializing Spring embedded WebApplicationContext 04-07 19:25:37 INFO SYSTEM | w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 3303 ms 04-07 19:25:38 INFO SYSTEM | o.e.j.session.DefaultSessionIdManager : Session workerName=node0 04-07 19:25:38 INFO SYSTEM | o.e.jetty.server.handler.ContextHandler : Started osbwej.JettyEmbeddedWebAppContext@4603c412{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.5043154362857996712/,a=AVAILABLE,h=oeje10s.SessionHandler@66851aa5{STARTED}} 04-07 19:25:38 INFO SYSTEM | o.e.j.e.servlet.ServletContextHandler : Started osbwej.JettyEmbeddedWebAppContext@4603c412{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.5043154362857996712/,a=AVAILABLE,h=oeje10s.SessionHandler@66851aa5{STARTED}} 04-07 19:25:38 INFO SYSTEM | org.eclipse.jetty.server.Server : Started oejs.Server@131c5bd{STARTING}[12.0.6,sto=0] @5890ms 04-07 19:25:38 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 04-07 19:25:38 INFO SYSTEM | com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection org.mariadb.jdbc.Connection@6265a548 04-07 19:25:38 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 04-07 19:25:38 WARN SYSTEM | o.m.jdbc.message.server.ErrorPacket : Error: 1193-HY000: Unknown system variable 'WSREP_ON' 04-07 19:25:38 INFO SYSTEM | org.flywaydb.core.FlywayExecutor : Database: jdbc:mariadb://localhost/aqua (MariaDB 11.2) 04-07 19:25:38 INFO SYSTEM | o.f.core.internal.command.DbValidate : Successfully validated 174 migrations (execution time 00:00.131s) 04-07 19:25:38 INFO SYSTEM | o.f.core.internal.command.DbMigrate : Current version of schema `aqua`: 1000.14 04-07 19:25:38 WARN SYSTEM | o.f.core.internal.command.DbMigrate : outOfOrder mode is active. Migration of schema `aqua` may not be reproducible. 04-07 19:25:38 INFO SYSTEM | o.f.core.internal.command.DbMigrate : Schema `aqua` is up to date. No migration necessary. 04-07 19:25:39 INFO SYSTEM | o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 04-07 19:25:39 INFO SYSTEM | org.hibernate.Version : HHH000412: Hibernate ORM core version 6.4.4.Final 04-07 19:25:39 INFO SYSTEM | o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 04-07 19:25:39 INFO SYSTEM | o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 04-07 19:25:42 INFO SYSTEM | o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration) 04-07 19:25:42 INFO SYSTEM | j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 04-07 19:25:43 INFO SYSTEM | o.s.d.j.r.query.QueryEnhancerFactory : Hibernate is in classpath; If applicable, HQL parser will be used. 04-07 19:25:46 WARN NET | net.components.JWT : USING DEFAULT JWT SECRET, PLEASE SET aqua-net.jwt IN CONFIGURATION 04-07 19:25:46 WARN NET | net.components.JWT : JWT Secret is less than 256 bits, padding with 0. PLEASE USE A STRONGER SECRET! 04-07 19:25:46 INFO NET | net.components.JWT : JWT Service Enabled 04-07 19:25:46 ERROR NET | net.components.GeoIP : GeoIP Service is enabled but GeoLite2 database is not found, trying to download from GitHub. 04-07 19:25:46 INFO NET | net.components.GeoIP : Downloading GeoLite2 database to data/GeoLite2-Country.mmdb 04-07 19:25:47 ERROR NET | net.components.GeoIP : Failed to download GeoLite2 database java.net.UnknownHostException: raw.githubusercontent.com at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:567) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) at java.base/java.net.Socket.connect(Socket.java:751) at java.base/sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:304) at java.base/sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:181) at java.base/sun.net.NetworkClient.doConnect(NetworkClient.java:183) at java.base/sun.net.www.http.HttpClient.openServer(HttpClient.java:531) at java.base/sun.net.www.http.HttpClient.openServer(HttpClient.java:636) at java.base/sun.net.www.protocol.https.HttpsClient.(HttpsClient.java:264) at java.base/sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:377) at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:193) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1237) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1123) at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:179) at java.base/sun.net.www.protocol.http.HttpURLConnection.followRedirect0(HttpURLConnection.java:2909) at java.base/sun.net.www.protocol.http.HttpURLConnection.followRedirect(HttpURLConnection.java:2818) at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1929) at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1599) at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:223) at java.base/java.net.URL.openStream(URL.java:1325) at icu.samnyan.aqua.net.components.GeoIP.onLoad(GeoIP.kt:41) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMethod.invoke(InitDestroyAnnotationBeanPostProcessor.java:457) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:401) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:219) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:422) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1778) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:959) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) at icu.samnyan.aqua.EntryKt.main(Entry.kt:19) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53) at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58) 04-07 19:25:47 WARN SYSTEM | ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'geoIP': Invocation of init method failed 04-07 19:25:47 WARN SYSTEM | o.s.b.f.support.DisposableBeanAdapter : Invocation of close method failed on bean with name 'defaultMailer': org.simplejavamail.internal.moduleloader.ModuleLoaderException: Batch module not found, make sure it is on the classpath (https://github.com/bbottema/simple-java-mail/tree/develop/modules/batch-module) 04-07 19:25:47 INFO SYSTEM | j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default' 04-07 19:25:47 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 04-07 19:25:47 INFO SYSTEM | com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. 04-07 19:25:47 INFO SYSTEM | org.eclipse.jetty.server.Server : Stopped oejs.Server@131c5bd{STOPPING}[12.0.6,sto=0] 04-07 19:25:47 INFO SYSTEM | o.e.j.e.servlet.ServletContextHandler : Stopped osbwej.JettyEmbeddedWebAppContext@4603c412{application,/,b=file:/C:/Users/27503/AppData/Local/Temp/jetty-docbase.80.5043154362857996712/,a=AVAILABLE,h=oeje10s.SessionHandler@66851aa5{STOPPED}} 04-07 19:25:47 INFO SYSTEM | .s.b.a.l.ConditionEvaluationReportLogger : Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled. 04-07 19:25:47 ERROR SYSTEM | o.s.boot.SpringApplication : Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'geoIP': Invocation of init method failed at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:222) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:422) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1778) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:959) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) at icu.samnyan.aqua.EntryKt.main(Entry.kt:19) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91) at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53) at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58) Caused by: java.net.UnknownHostException: raw.githubusercontent.com at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:567) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327) at java.base/java.net.Socket.connect(Socket.java:751) at java.base/sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:304) at java.base/sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:181) at java.base/sun.net.NetworkClient.doConnect(NetworkClient.java:183) at java.base/sun.net.www.http.HttpClient.openServer(HttpClient.java:531) at java.base/sun.net.www.http.HttpClient.openServer(HttpClient.java:636) at java.base/sun.net.www.protocol.https.HttpsClient.(HttpsClient.java:264) at java.base/sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:377) at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:193) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1237) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1123) at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:179) at java.base/sun.net.www.protocol.http.HttpURLConnection.followRedirect0(HttpURLConnection.java:2909) at java.base/sun.net.www.protocol.http.HttpURLConnection.followRedirect(HttpURLConnection.java:2818) at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1929) at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1599) at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:223) at java.base/java.net.URL.openStream(URL.java:1325) at icu.samnyan.aqua.net.components.GeoIP.onLoad(GeoIP.kt:41) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMethod.invoke(InitDestroyAnnotationBeanPostProcessor.java:457) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:401) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:219) ... 23 common frames omitted

kanon511 commented 5 months ago

Although there is currently an online server for CHUNITHM LUMINUS, before that, I used 0.046 Aqua to deploy my own server locally. Switching online servers will prevent my server data from being imported or inherited, so I would like to try building this project branch.

If possible, I would like to obtain an Aqua server that has as little configuration as possible about public servers or can be easily built. Thank you.

kanon511 commented 5 months ago

Thank you. I have already resolved it.

Due to network issues, the GeoLite2 Country.mmdb file cannot be updated correctly. I choose to manually select https://git.io/GeoLite2-Country.mmdb Download the file and place it in the data folder.

The project has run successfully and can be connected to the network normally in LUMINUS.