Ошибка при запуске Ubuntu lineage 2

[spartana]

1350133053592 INFO 19 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053592 INFO 16 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053652 INFO 21 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053656 INFO 18 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053686 INFO 15 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053693 INFO 17 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053701 INFO 19 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053701 INFO 16 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053753 INFO 21 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053756 INFO 18 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053787 INFO 15 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053794 INFO 17 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053802 INFO 16 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053802 INFO 19 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053854 INFO 21 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053857 INFO 18 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053888 INFO 15 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053895 INFO 17 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053903 INFO 16 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053903 INFO 19 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053955 INFO 21 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053958 INFO 18 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053989 INFO 15 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.
1350133053995 INFO 17 com.mchange.v2.resourcepool.BasicResourcePool An exception occurred while acquiring a poolable resource. Will retry.


Подскажите в чем может быть трабла???

[keni2006]

1. Попробуй поменять прикрепил по ссылке ниже
mysql-connector-java-5.1.7-bin.jar
c3p0-0.9.1.2.jar
2.Закинь stdout.log на какойнибудь pastebin и так же вывод cat GameServer_loop.sh
3.Вариант свяжись со мной

[spartana]

at java.net.Socket.<init>(Socket.java:392)
at java.net.Socket.<init>(Socket.java:235)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 20 more
терь вот такое выводит что в логине то и в гейме

Добавлено через 24 минуты
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2333)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
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)

[ProDev]

Этих логов не совсем достаточно. Для начала стандартный рецепт:

Код:

telnet [MYSQL_SERVER_IP] [MYSQL_SERVER_PORT]

Порт по умолчанию 3306.

СУБД стоит на той же машине или на разных? Проблем может быть много, вплоть до межсетевых экранов, если таковые на пути от одной машины на другую имеются)

[spartana]

порт 3306
машина одна
ВПН соединение интернет от билайн

Добавлено через 4 минуты
Driver=com.mysql.jdbc.Driver
URL=jdbc:mysql://localhost/l2rdb

[ProDev]

Для начала перегрузите СУБД, клиентом (Aqua Data Studio, Squirrel, Navicat и др.) можете подключиться и выполнить запрос? telnet'ом проверяли, получается подключиться?

Код:

telnet localhost 3306

Выше верно отменили, нужно также проверить mysql - дайрвер. Хотя в случае с mysql проблем не припомню.

P.S. На всякий случай вот ссылка с описанием схожей проблемы: http://serverfault.com/questions/89955/u...externally

[spartana]

gerodot@ivgamers:~$ telnet localhost 3306
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused

Добавлено через 1 минуту
запрос проверял через ssh

Добавлено через 5 минут
telnet linage.ivgamers.ru 3306
Trying 128.73.137.184...
Connected to ivgamers.dyndns.org.
Escape character is '^]'.
[
5.5.24-0ubuntu0.12.04.1 PNu$PGT▒uy$B`=OT8\H3mysql_native_passwordConnection closed by foreign host.

[ProDev]

Значит у вас mysql прибинден не на localhost. В конфиге замените connection url на:

Код:

URL=jdbc:mysql://linage.ivgamers.ru/l2rdb

P.S. Ваша СУБД доступна из инета, что не есть хорошо. Если машина под управлением Linux, то очень рекомендую в iptables прикрыть порт 3306 и разрешить на него коннект только с нужного IP, делается это так:

Код:

iptables -I INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j DROP
iptables -I INPUT -s [YOUR_SERVER_IP] -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

Где [YOUR_SERVER_IP] нужно заменить на IP-адрес сервера, с которого LS/GS будет обращаться к СУБД

[keni2006]

более простой вариант /etc/mysq/my.cnf
bind-address =127.0.0.1

[ProDev]

Если СУБД и сервер стоят на одной машине, то, разумеется, так проще)