Straik29a

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

Помогите пожалуйста настроить сервер на внешнюю базу данных, которая расположена на хостинге. И можно ли вообще так сделать? В общем указываю хост сервера, логин, пароль и имя бд. Логин сервер выдает вот такое: [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

Помоги еще плис. Как сделать запрос в БД? =) например: INSERT INTO skill_trees VALUES (0, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (10, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (18, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (25, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (31, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (38, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (44, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (49, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (53, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (123, 1050, 2, "Return", 0, 1); INSERT INTO skill_trees VALUES (124, 1050, 2, "Return", 0, 1);

http://zhyk.ru/forum/showthread.php?t=79073 Сойдет?

Спасибо! Дай плиз ссылку на какойнить сайт Сборка серва L2jSoftware 59

Как сайт к серву привязать?)