kutnuzer 24 Опубликовано 10 января, 2014 Вообщем собственно, настроил сервер залил базу данных(использую сборку L2JFrozen), и тут появилась ошибка которой раньше не было, вот полный лог game server Starting L2J-Frozen Core Game Server. Official website : http://www.l2jfrozen.com Enjoy by server core. Bee happy! ------------------------------ ======================================================================-[ Team ] # ##### ##### ##### ##### ##### ##### ## # # # # # # # # # # # # # # ### #### ### # # # # # ### # # # # # # ### # # # # # # # ##### ##### # # ## ##### ##### ##### # ## ==================================================================-[ Database ] MLog clients using java 1.4+ standard logging. Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans .IntrospectionException: java.lang.reflect.InvocationTargetException [numThreads AwaitingCheckoutDefaultUser] ] Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsExcepti on: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driv er has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1 116) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:346) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2 371) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) 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 Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :305) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag erDataSource.java:119) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:143) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:132) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu tomaticTestTable(C3P0PooledConnectionPoolManager.java:772) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled ConnectionPool(C3P0PooledConnectionPoolManager.java:696) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0 PooledConnectionPoolManager.java:257) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0 PooledConnectionPoolManager.java:271) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A bstractPoolBackedDataSource.java:128) at com.l2jfrozen.util.database.L2DatabaseFactory_c3p0.<init>(L2DatabaseF actory_c3p0.java:88) at com.l2jfrozen.util.database.L2DatabaseFactory.getInstance(L2DatabaseF actory.java:51) at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:208) Caused by: java.net.UnknownHostException: localhostgameserver_beta at java.net.InetAddress.getAllByName0(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja va:244) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:295) ... 23 more Server terminated abnormally Send you bug to : http://www.l2jfrozen.com server terminated Send you bug to : http://www.l2jfrozen.com Restart(r) or Quit(q) Mysql сервер у меня на vertrigo, и главное что логин сервер запускаеться нормально без ошибок, вот прикладываю конфиг gameserver: # ===================================# # Game Server Settings # # ===================================# # This is the server configuration file. Here you can set up the connection information for your server. # This was written with the assumption that you are behind a router. # Dumbed Down Definitions... # LAN (LOCAL area network) - typically consists of computers connected to the same router as you. # WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet). # x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers. # ----------------------------------------------------------------------------------------------------------------------------------------------------------------- # Networking # ----------------------------------------------------------------------------------------------------------------------------------------------------------------- # This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname # Common settings... # 127.0.0.1 - If you are playing alone on a test server # 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect # x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server. # If this IP is resolvable by the Login Server, just leave *. # ---------------------------------------------------------------------------------------- # Enter here (ip) address of your game server, or use the symbol * GameserverHostname = * GameserverPort = 7777 # Configure your external ip ExternalHostname = 127.0.0.1 # Configure your internal ip InternalHostname = 127.0.0.1 # Bunch ID and game server. It is better not to change. LoginPort = 9014 LoginHost = 127.0.0.1 # Database Pool Type # Possible Values: c3p0 or BoneCP # c3p0: more stable # BoneCP: more performance DatabasePoolType = c3p0 # Parameters Databases - MYSQL Driver = com.mysql.jdbc.Driver URL = jdbc:mysql://localhost # Database name GameserverDB = gameserver_beta LoginserverDB = loginserver_beta # Login - Mysql's user Login = root # Password - Mysql's Password Password = Тут был пароль # Attention: lazy init connections disabled! # Please, set only real values for your database # Default: 100 MaximumDbConnections = 50 # Default: 0 MaximumDbIdleTime = 0 # The timeout before a new connection to the database (in ms) # 0 - to remove restrictions TimeOutConDb = 0 # The timeout before the single connection must be closed (in ms) # if a connection life is more then this timeout, a Runtime Exception # is rised up. Post the exception on forum (www.l2jfrozen.com) to solve # it. SingleConnectionTimeOutDb = 200000 # Sets number of partitions to use.- BoneCP # In order to reduce lock contention and thus improve performance, # each incoming connection request picks off a connection from a pool that has thread-affinity, # i.e. pool[threadId % partition_count]. The higher this number, the better your performance will be for the case # when you have plenty of short-lived threads. Beyond a certain threshold, maintenance of these pools will start # to have a negative effect on performance (and only for the case when connections on a partition start running out). PartitionCount = 3 # Setting emulation off the kernel (package SendStatus) RemoteWhoLog = True RemoteWhoSendTrash = True RemoteWhoMaxOnline = 329 RemoteOnlineIncrement = 50 RemoteWhoForceInc = 50 RemotePrivStoreFactor = 12 # Datapack folder # To exacute the server under debugger with eclipse use: # DatapackRoot = ../L2jFrozen_DataPack # or point the folder directly to your server. DatapackRoot = . Пользовался поиском, не чего решающего эту проблему не нашел, поэтому написал сюда, пробовал переустонавливать бд несколько раз, не помогло. Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
desolator 267 Опубликовано 10 января, 2014 (изменено) URL = jdbc:mysql://localhost тут 127.0.0.1 Изменено 10 января, 2014 пользователем desolator Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
kutnuzer 24 Опубликовано 10 января, 2014 Не много не понял ваше сообщение, можно укзаать, что нужно исправить? Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
kutnuzer 24 Опубликовано 10 января, 2014 Заменил на это: URL = jdbc:mysql://localhost/gameserver_beta Проблема осталась... Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты
kutnuzer 24 Опубликовано 10 января, 2014 Во всем разобрался тему офф. Поделиться сообщением Ссылка на сообщение Поделиться на другие сайты