Ошипка БД

professor · 14 Ноя 2019

Вот что пишет сервер в логах . Я не селен в этом деле . Кто в курсе в чем причина помогите !

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)
------

klubheads · 15 Ноя 2019

Пароль не вписан в настройках.

professor · 15 Ноя 2019

klubheads написал(а):
Пароль не вписан в настройках.

Проверил все пароли все вписано верно . Ошибка как вылазида так и вылазиет . Может посмотрите сами что не так через скайп или другие приблуды ?

klubheads · 15 Ноя 2019

professor написал(а):
Проверил все пароли все вписано верно . Ошибка как вылазида так и вылазиет

Показывайте конфиги где проверяли. В таблице gameservers пароль совпадает с тем что вписан в конфигах ?

professor · 15 Ноя 2019

Вот что имеем на сейчас

==================================[ 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 (http://java.sun.com/webapps/bugreport) 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

klubheads · 15 Ноя 2019

File C:\Users\╨║╨╛╤В\Desktop\aionserver3.9\game\libs\al-commons-1.3.jar is not valid jar file
Так это уже другая ошибка, с паролями разобрались
Не должно быть кириллицы не в путях не в названиях.

professor · 15 Ноя 2019

вроде все хорошо ноо смущает Это Может я и ошибаюсь ноооо

===============================[ 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...

romanz · 15 Ноя 2019

одна сплошная "Ошипка"

))

professor · 15 Ноя 2019

Так не бывает мой друг =}}}

klubheads · 16 Ноя 2019

professor написал(а):
at com.aionemu.gameserver.services.HousingBidService.executeTask(HousingBidService.java:286) ~[AL-Game.jar:na]

аук домов не стартанул.

romanz · 16 Ноя 2019

professor написал(а):
Так не бывает мой друг =}}}

название своей темы посмотри )

professor · 16 Ноя 2019

romanz написал(а):
название своей темы посмотри )

Вооо блин слона и не заметил

professor · 16 Ноя 2019

klubheads написал(а):
аук домов не стартанул.

Благодарю ВАС помощь . Вроде все работает . Ребенок счастлив

. Спасибо Вам!

azraelim · 18 Ноя 2019

ОшиПка, Вылазиет, не сЕлен, ну жесть блин.

AngryBoris · 19 Ноя 2019

azraelim написал(а):
ОшиПка, Вылазиет, не сЕлен, ну жесть блин.

хули... "профессор" же

Ошипка БД

professor

Рядовой

klubheads

Сержант

professor

Рядовой

klubheads

Сержант

professor

Рядовой

klubheads

Сержант

professor

Рядовой

romanz

Ефрейтор

professor

Рядовой

klubheads

Сержант

romanz

Ефрейтор

professor

Рядовой

professor

Рядовой

azraelim

Ефрейтор

AngryBoris

Рядовой