[Помогите!] ОШИБКА В ГС

[Наверника]

Dedicated сервер ОС: Ubuntu 12.04
Сервер Interlude <L2jFrozen>

Ошибка при запуске ГС:

Цитата: Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC onnectionException: Could not create connection to database server. at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Construc tor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1015) at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:975) at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:920) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Co nnectionImpl.java:2565) at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2301) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:834) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Construc tor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1) at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:416) at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:317) at com.mchange.v2.c3p0.DriverManagerDataSource.getCon nection(DriverManagerDataSource.java:119) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnection(WrapperConnectionPoolDataSou rce.java:143) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc e.getPooledConnection(WrapperConnectionPoolDataSou rce.java:132) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.initializeAutomaticTestTable(C3P0PooledConn ectionPoolManager.java:772) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.createPooledConnectionPool(C3P0PooledConnec tionPoolManager.java:696) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0PooledConnectionPoolManager.jav a:257) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolM anager.getPool(C3P0PooledConnectionPoolManager.jav a:271) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(AbstractPoolBackedDataSource.jav a:128) at com.l2jfrozen.util.database.L2DatabaseFactory_c3p0 .<init>(L2DatabaseFactory_c3p0.java:88) at com.l2jfrozen.util.database.L2DatabaseFactory.getI nstance(L2DatabaseFactory.java:51) at com.l2jfrozen.gameserver.GameServer.main(GameServe r.java:206) Caused by: java.lang.NullPointerException at com.mysql.jdbc.Buffer.<init>(Buffer.java:55) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggab leAuthentication(MysqlIO.java:1694) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 50) at com.mysql.jdbc.ConnectionImpl.coreConnect(Connecti onImpl.java:2483) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Co nnectionImpl.java:2516) ... 21 more

При запуске ЛС ошибка не выдается и нормально функционирует.

Если не ошибаюсь, сервер не может подключиться к БД. БД установлена на там же где и сборка.

Конфиг ГС:

# Enter here (ip) address of your game server, or use the symbol *
GameserverHostname = *
GameserverPort = 7721

# Configure your external ip
ExternalHostname = 62.109.18.134

# 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 = l2game
LoginserverDB = l2login

# Login - Mysql's user
Login = root
# Password - Mysql's Password
Password = pass
# Attention: lazy init connections disabled!
# Please, set only real values for your database
# Default: 100
MaximumDbConnections = 50

Конфиг ЛС (который работает):

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname = 62.109.18.134

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname = 127.0.0.1

# Bind ip of the loginServer, use * to bind on all available IPs
LoginserverHostname = *
LoginserverPort = 2106

# How many times you can provide an invalid account/pass before the IP gets banned
LoginTryBeforeBan = 20

# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)  
LoginBlockAfterBan = 600
GMMinLevel = 100

# The address on which login will listen for GameServers, use * to bind on all available IPs  
LoginHostname = 127.0.0.1

# The port on which login will listen for GameServers
LoginPort = 9014

# If set to True any GameServer can register on your login's free slots
AcceptNewGameServer = False

# If False, the licence (after the login) will not be shown
# It is highly recomended for Account Seciurity to leave this option as defalut (True)
ShowLicence = False

# Database Pool Type
# Possible Values: c3p0 or BoneCP
# c3p0: more stable
# BoneCP: more performance
DatabasePoolType = c3p0

# Database info
Driver = com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

# Database Settings
URL = jdbc:mysql://localhost/l2login
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=

# Parameters Databases - MYSQL
# Login - Mysql's user
Login = root
# Password - Mysql's Password
Password = pass
# maximum number of simultaneous connecting to the database
MaximumDbConnections = 50

При загрузке database_installer.sh ошибок не выдавало.

Объясните, в чём проблема, что не запускается гс?!

[Наверника]

Цитата: # ===================================# # 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 [Ссылки могут видеть только зарегистрированные пользователи. ]. 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 = 7721 # Configure your external ip ExternalHostname = 62.109.18.134 # 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 = l2game LoginserverDB = l2login # Login - Mysql's user Login = root # Password - Mysql's Password Password = pass # 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 ([Ссылки могут видеть только зарегистрированные пользователи. ]) 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 = .

С такими же параметрами у меня работает на Windows. Но на Linux выдаёт эту ошибку. По идее путь у БД верен.

БД создано отдельно для логина (l2login) и гейма (l2game). Пробовал создать 1 БД для всего. та жа ошибка.

Запускал его как мог. Отдельно прописывал chmod -R 777 *.sh (full privileges). Всё равно ERROR.

Так же переустановил JAVA: с Java 7 => Java 6. 0 результата.

Добавлено через 14 часов 28 минут
Может недостаточно привилегий? хотя вводил cmod 777 *.sh и chmod -R 777 *.sh

Добавлено через 15 часов 40 минут
Пробовал подключиться у БД на другом хостинге. та же история.

Добавлено через 16 часов 0 минут
К БД ГС могу подключиться как с сайта, так со своего компа. А вот с ГС на хостинге не могу(

[Наверника]

Исправил. Просто лыжа не поддеживает новые версии мускул. Пришлось удалить из сборки файл поддержки мускул и заменит на новый от феникса к примеру

[Humoki]

Цитата: Сообщение от Наверника Dedicated сервер ОС: Ubuntu 12.04 Сервер Interlude <L2jFrozen> Ошибка при запуске ГС: При запуске ЛС ошибка не выдается и нормально функционирует. Если не ошибаюсь, сервер не может подключиться к БД. БД установлена на там же где и сборка. Конфиг ГС: # Enter here (ip) address of your game server, or use the symbol * GameserverHostname = * GameserverPort = 7721 # Configure your external ip ExternalHostname = 62.109.18.134 # 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 = l2game LoginserverDB = l2login # Login - Mysql's user Login = root # Password - Mysql's Password Password = pass # Attention: lazy init connections disabled! # Please, set only real values for your database # Default: 100 MaximumDbConnections = 50 Конфиг ЛС (который работает): # This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname ExternalHostname = 62.109.18.134 # This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname InternalHostname = 127.0.0.1 # Bind ip of the loginServer, use * to bind on all available IPs LoginserverHostname = * LoginserverPort = 2106 # How many times you can provide an invalid account/pass before the IP gets banned LoginTryBeforeBan = 20 # Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600) LoginBlockAfterBan = 600 GMMinLevel = 100 # The address on which login will listen for GameServers, use * to bind on all available IPs LoginHostname = 127.0.0.1 # The port on which login will listen for GameServers LoginPort = 9014 # If set to True any GameServer can register on your login's free slots AcceptNewGameServer = False # If False, the licence (after the login) will not be shown # It is highly recomended for Account Seciurity to leave this option as defalut (True) ShowLicence = False # Database Pool Type # Possible Values: c3p0 or BoneCP # c3p0: more stable # BoneCP: more performance DatabasePoolType = c3p0 # Database info Driver = com.mysql.jdbc.Driver #Driver=org.hsqldb.jdbcDriver #Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver # Database Settings URL = jdbc:mysql://localhost/l2login #URL=jdbc:hsqldb:hsql://localhost/l2jdb #URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password= # Parameters Databases - MYSQL # Login - Mysql's user Login = root # Password - Mysql's Password Password = pass # maximum number of simultaneous connecting to the database MaximumDbConnections = 50 При загрузке database_installer.sh ошибок не выдавало. Объясните, в чём проблема, что не запускается гс?!

Таблица "exceptions" не отвечает