Вот что пишет сервер в логах . Я не селен в этом деле . Кто в курсе в чем причина помогите ! 2019-11-14 18:23:13,064 Error while creating DB Connection pool java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/al_server_gs?useUnicode=true&characterEncoding=UTF-8, username = root. Terminating connection pool. Original Exception: ------ java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256) at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:305) at com.aionemu.commons.database.DatabaseFactory.init(DatabaseFactory.java:102) at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(GameServer.java:365) at com.aionemu.gameserver.GameServer.main(GameServer.java:164) ------
Проверил все пароли все вписано верно . Ошибка как вылазида так и вылазиет . Может посмотрите сами что не так через скайп или другие приблуды ?
Показывайте конфиги где проверяли. В таблице gameservers пароль совпадает с тем что вписан в конфигах ?
Вот что имеем на сейчас ==================================[ DataBase ]================================== 14:00:04.946 INFO [main]: - Successfully connected to database An exception has occurred in the compiler (compiler message file broken: key=compiler.misc.version.resource.missing arguments=1.7.0_21, {1}, {2}, {3}, {4}, {5}, {6}, {7}). Please file a bug at the Java Developer Connection (Please login or register to view links) after checking the Bug Parade for duplicates. Include your program and the following diagnostic in your report. Thank you. java.lang.IllegalArgumentException: File C:\Users\╨║╨╛╤В\Desktop\aionserver3.9\game\libs\al-commons-1.3.jar is not valid jar file at com.aionemu.commons.utils.ClassUtils.getClassNamesFromJarFile(ClassUtils.java:171) at com.aionemu.commons.scripting.ScriptClassLoader.addJarFile(ScriptClassLoader.java:107) at com.aionemu.commons.scripting.impl.javacompiler.ScriptClassLoaderImpl.getClassesForPackage(ScriptClassLoaderImpl.java:144) at com.aionemu.commons.scripting.impl.javacompiler.ClassFileManager.list(ClassFileManager.java:179) at com.sun.tools.javac.jvm.ClassReader.fillIn(ClassReader.java:2133) at com.sun.tools.javac.jvm.ClassReader.complete(ClassReader.java:1790) at com.sun.tools.javac.code.Symbol.complete(Symbol.java:404) at com.sun.tools.javac.code.Symbol$PackageSymbol.flags(Symbol.java:642) at com.sun.tools.javac.comp.Attr.checkId(Attr.java:2171) at com.sun.tools.javac.comp.Attr.visitIdent(Attr.java:1826) at com.sun.tools.javac.tree.JCTree$JCIdent.accept(JCTree.java:1676) at com.sun.tools.javac.comp.Attr.attribTree(Attr.java:374) at com.sun.tools.javac.comp.Attr.visitSelect(Attr.java:1843) at com.sun.tools.javac.tree.JCTree$JCFieldAccess.accept(JCTree.java:1648) at com.sun.tools.javac.comp.Attr.attribTree(Attr.java:374) at com.sun.tools.javac.comp.Attr.visitSelect(Attr.java:1843) at com.sun.tools.javac.tree.JCTree$JCFieldAccess.accept(JCTree.java:1648) at com.sun.tools.javac.comp.Attr.attribTree(Attr.java:374) at com.sun.tools.javac.comp.Attr.visitSelect(Attr.java:1843) at com.sun.tools.javac.tree.JCTree$JCFieldAccess.accept(JCTree.java:1648) at com.sun.tools.javac.comp.Attr.attribTree(Attr.java:374) at com.sun.tools.javac.comp.MemberEnter.visitImport(MemberEnter.java:543) at com.sun.tools.javac.tree.JCTree$JCImport.accept(JCTree.java:504) at com.sun.tools.javac.comp.MemberEnter.memberEnter(MemberEnter.java:403) at com.sun.tools.javac.comp.MemberEnter.memberEnter(MemberEnter.java:415) at com.sun.tools.javac.comp.MemberEnter.visitTopLevel(MemberEnter.java:527) at com.sun.tools.javac.tree.JCTree$JCCompilationUnit.accept(JCTree.java:451) at com.sun.tools.javac.comp.MemberEnter.memberEnter(MemberEnter.java:403) at com.sun.tools.javac.comp.MemberEnter.complete(MemberEnter.java:840) at com.sun.tools.javac.code.Symbol.complete(Symbol.java:404) at com.sun.tools.javac.code.Symbol$ClassSymbol.complete(Symbol.java:793) at com.sun.tools.javac.comp.Enter.complete(Enter.java:468) at com.sun.tools.javac.comp.Enter.main(Enter.java:446) at com.sun.tools.javac.main.JavaCompiler.enterTrees(JavaCompiler.java:867) at com.sun.tools.javac.main.JavaCompiler.compile(JavaCompiler.java:772) at com.sun.tools.javac.main.Main.compile(Main.java:393) at com.sun.tools.javac.api.JavacTaskImpl.call(JavacTaskImpl.java:138) at com.aionemu.commons.scripting.impl.javacompiler.ScriptCompilerImpl.doCompilation(ScriptCompilerImpl.java:193) at com.aionemu.commons.scripting.impl.javacompiler.ScriptCompilerImpl.compile(ScriptCompilerImpl.java:163) at com.aionemu.commons.scripting.impl.ScriptContextImpl.init(ScriptContextImpl.java:141) at com.aionemu.commons.scripting.scriptmanager.ScriptManager.load(ScriptManager.java:96) at com.aionemu.commons.database.dao.DAOManager.init(DAOManager.java:70) at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(GameServer.java:367) at com.aionemu.gameserver.GameServer.main(GameServer.java:164) 14:00:05.630 ERROR[main]: - Critical Error - Thread: main terminated abnormaly: java.lang.Error: Error while compiling classes java.lang.Error: Error while compiling classes at com.aionemu.commons.database.dao.DAOManager.init(DAOManager.java:73) ~[al-commons-1.3.jar:na] at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(GameServer.java:367) ~[AL-Game.jar:na] at com.aionemu.gameserver.GameServer.main(GameServer.java:164) ~[AL-Game.jar:na] Caused by: java.lang.RuntimeException: Error while compiling classes at com.aionemu.commons.scripting.impl.javacompiler.ScriptCompilerImpl.doCompilation(ScriptCompilerImpl.java:194) ~[al-commons-1.3.jar:na] at com.aionemu.commons.scripting.impl.javacompiler.ScriptCompilerImpl.compile(ScriptCompilerImpl.java:163) ~[al-commons-1.3.jar:na] at com.aionemu.commons.scripting.impl.ScriptContextImpl.init(ScriptContextImpl.java:141) ~[al-commons-1.3.jar:na] at com.aionemu.commons.scripting.scriptmanager.ScriptManager.load(ScriptManager.java:96) ~[al-commons-1.3.jar:na] at com.aionemu.commons.database.dao.DAOManager.init(DAOManager.java:70) ~[al-commons-1.3.jar:na] ... 2 common frames omitted ГАМЭ Database Config's: # ---------------------------- # This class represents database driver class that will be used while connecting to database database.driver = com.mysql.jdbc.Driver # This is database url. database.url = jdbc:mysql://localhost:3306/al_server_gs?useUnicode=true&characterEncoding=UTF-8 # Database user database.user = root # Database password # NOTE: Change this! Root password is not safe! database.password = 12345 # Number of partitions created by bonecp database.bonecp.partition.count = 2 # Minimal amount of connections kept in bonecp partition database.bonecp.partition.connections.min = 2 # Maximal amount of connections kept in bonecp partition database.bonecp.partition.connections.max = 5 # Script context that will be loaded by database factory, it should implement DAO instances database.scriptcontext.descriptor = ./data/scripts/system/database.xml ЛОГИН Database Config's: # ---------------------------- # This class represents database driver class that will be used while connecting to database database.driver = com.mysql.jdbc.Driver # This is database url. database.url = jdbc:mysql://localhost:3306/al_server_ls?useUnicode=true&characterEncoding=UTF-8 # Database user database.user = root # Database password # NOTE: Change this! Root password is not safe! database.password = 12345 # Number of partitions created by bonecp database.bonecp.partition.count = 2 # Minimal amount of connections kept in bonecp partition database.bonecp.partition.connections.min = 2 # Maximal amount of connections kept in bonecp partition database.bonecp.partition.connections.max = 5 # Script context that will be loaded by database factory, it should implement DAO instances database.scriptcontext.descriptor = ./data/scripts/system/database.xml Please login or register to view links
File C:\Users\╨║╨╛╤В\Desktop\aionserver3.9\game\libs\al-commons-1.3.jar is not valid jar file Так это уже другая ошибка, с паролями разобрались Не должно быть кириллицы не в путях не в названиях.
вроде все хорошо ноо смущает Это Может я и ошибаюсь ноооо ===============================[ GameServerLog ]=============================== 17:51:45.292 INFO [main]: - AL Game Server started in 88 seconds. ==============================[ Starting Network ]============================== 17:51:45.317 INFO [main]: - Server listening on all available IPs on Port 7777 for Game Connections 17:51:45.319 INFO [main]: - Connecting to LoginServer: localhost/127.0.0.1:9014 17:51:45.326 INFO [main]: - Connected to LoginServer! 17:51:45.849 INFO [ReadWrite-0 Dispatcher]: - Loaded 0 banned mac addesses 17:51:46.375 INFO [InstantPool-5]: - MovementNotifyTask: Initialized. 17:51:46.379 INFO [InstantPool-5]: - ZoneUpdateService: Initialized. 17:54:34.124 INFO [pool-3-thread-11]: - Sending current game time to all players 17:54:34.125 INFO [pool-3-thread-11]: - Game time saved... ==================================[ Dredgion ]================================== 17:51:34.448 INFO [main]: - Scheduled Dredgion: based on cron expression: 0 0 0,12,20 ? * * Duration: 120 in minutes 17:51:34.452 INFO [main]: - PlayerTransferService loaded. With 0 restricted skills. 17:51:34.460 INFO [main]: - Loading house bids... эю 15, 2019 5:51:34 PM java.util.logging.LogManager$RootLogger log WARNING: Unevenly distributed hash code - Degraded Performance 17:51:34.504 INFO [main]: - HousingBidService: auction auto filling enabled. 17:51:41.797 INFO [main]: - HousingBidService: added 72 new house bids. 17:51:41.798 INFO [main]: - HousingBidService loaded. Minutes till start: 0 17:51:41.804 INFO [main]: - Initializing House maintenance task... 17:51:41.982 WARN [pool-3-thread-5]: - Exception in a Runnable execution: java.lang.NullPointerException: null at com.aionemu.gameserver.services.HousingBidService.executeTask(HousingBidService.java:286) ~[AL-Game.jar:na] at com.aionemu.gameserver.taskmanager.AbstractCronTask.run(AbstractCronTask.java:147) ~[AL-Game.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:46) ~[al-commons-1.3.jar:na] at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:38) [al-commons-1.3.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:476) [na:na] at java.util.concurrent.FutureTask.run(FutureTask.java:237) [na:na] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:151) [na:na] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:264) [na:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1115) [na:na] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:586) [na:na] at java.lang.Thread.run(Unknown Source) [na:1.7.0_21] 17:51:41.984 WARN [pool-3-thread-5]: - class com.aionemu.gameserver.services.HousingBidService - execution time: 7524msec 17:51:44.138 INFO [main]: - Loaded 25 elyos towns. 17:51:44.139 INFO [main]: - Loaded 25 asmodians towns. 17:51:44.146 INFO [main]: - ChallengeTaskService initialized. ===============================[ GameServerLog ]=============================== 17:51:45.292 INFO [main]: - AL Game Server started in 88 seconds. ==============================[ Starting Network ]============================== 17:51:45.317 INFO [main]: - Server listening on all available IPs on Port 7777 for Game Connections 17:51:45.319 INFO [main]: - Connecting to LoginServer: localhost/127.0.0.1:9014 17:51:45.326 INFO [main]: - Connected to LoginServer! 17:51:45.849 INFO [ReadWrite-0 Dispatcher]: - Loaded 0 banned mac addesses 17:51:46.375 INFO [InstantPool-5]: - MovementNotifyTask: Initialized. 17:51:46.379 INFO [InstantPool-5]: - ZoneUpdateService: Initialized. 17:54:34.124 INFO [pool-3-thread-11]: - Sending current game time to all players 17:54:34.125 INFO [pool-3-thread-11]: - Game time saved... 17:57:34.126 INFO [pool-3-thread-29]: - Sending current game time to all players 17:57:34.127 INFO [pool-3-thread-29]: - Game time saved...
