Настройка Сервера На Внешнюю Базу Данных

[Straik29a 0]

Помогите пожалуйста настроить сервер на внешнюю базу данных, которая расположена на хостинге. И можно ли вообще так сделать?

 

В общем указываю хост сервера, логин, пароль и имя бд. Логин сервер выдает вот такое:

 

 

[08.08.14 00:07:20] L2DatabaseFactory: Connected to database server

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] System Time: 08-08-2014 12:07:20 AM

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] OS: Windows 7 Build: 6.1

[08.08.14 00:07:20] OS Arch: amd64

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] Avaible CPU(s): 6

[08.08.14 00:07:20] Processor(s) Identifier: AMD64 Family 21 Model 1 Stepping 2, AuthenticAMD

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] Runtime Information

[08.08.14 00:07:20] Current Free Heap Size: 126 mb

[08.08.14 00:07:20] Current Heap Size: 129 mb

[08.08.14 00:07:20] Maximum Heap Size: 455 mb

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] Java Platform Information

[08.08.14 00:07:20] Java Runtime Name: Java SE Runtime Environment

[08.08.14 00:07:20] Java Version: 1.8.0_11

[08.08.14 00:07:20] Java Class Version: 52.0

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] Virtual Machine Information (JVM)

[08.08.14 00:07:20] JVM Name: Java HotSpot 64-Bit Server VM

[08.08.14 00:07:20] JVM installation directory: C:\Program Files\Java\jdk1.8.0_11\jre

[08.08.14 00:07:20] JVM version: 25.11-b03

[08.08.14 00:07:20] JVM Vendor: Oracle Corporation

[08.08.14 00:07:20] JVM Info: mixed mode

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] ..................................................

[08.08.14 00:07:20] GameServerManager: Loaded 127 server name(s)

[08.08.14 00:07:20] L2DatabaseFactory: Failed to retrieve database connection!

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (null, message from server: "Host '178.46.166.143' is not allowed to connect to this MySQL server")

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

at ru.catssoftware.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:140)

at ru.catssoftware.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:131)

at ru.catssoftware.loginserver.manager.GameServerManager.load(GameServerManager.java:222)

at ru.catssoftware.loginserver.manager.GameServerManager.(GameServerManager.java:125)

at ru.catssoftware.loginserver.manager.GameServerManager.getInstance(GameServerManager.java:88)

at ru.catssoftware.loginserver.L2LoginServer.(L2LoginServer.java:102)

at ru.catssoftware.loginserver.L2LoginServer.main(L2LoginServer.java:52)

Caused by: java.sql.SQLException: null, message from server: "Host '178.46.166.143' is not allowed to connect to this MySQL server"

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:986)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:981)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1104)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2183)

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:784)

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:408)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:354)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)

at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)

... 9 more

[08.08.14 00:07:21] L2DatabaseFactory: Failed to retrieve database connection!

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (null, message from server: "Host '178.46.166.143' is not allowed to

[Artur_xD 403]

Простите, ответил не прочитав пост до конца.

Изменено 7 августа, 2014 пользователем Artur_xD

[Lovely 307]

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (null, message from server: "Host '178.46.166.143' is not allowed to connect to this MySQL server")

[Straik29a 0]

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (null, message from server: "Host '178.46.166.143' is not allowed to connect to this MySQL server")

 

Из этого я понимаю только что хосту 178.46.166.143 не разрешается подключение к серверу. Но на сервере настроен доступ к базе пользователю именно с этого ip адреса и с этого ip я запускаю логин сервер

[SadamarK 24]

Настроишь сервер на внешнюю базу - добавишь лагов.