Перейти к содержимому
La2Base
Главная
ЗагрузкиВикиФорумFAQ
ruen
Регистрация Войти
ГлавнаяФайлыВикиВойти
  • Главная
  • Загрузки
  • Вики
  • FAQ
  • Обратная связь
  • О проекте
  • Правила
  • Конфиденциальность
  • Условия использования

© 2026 la2base.com · Все права защищены

ruen
Форум/Форум для новичков[JAVA]/[help]Помогите Нубу
Поиск

[help]Помогите Нубу

9 ответов178 просмотровСейчас просматривают: 1
gemon
gemon

Пользователь

Участник

Постов: 47

На форуме с: 02.11.2008

Рейтинг: 0

· 22.05.2009, 06:23

Сборка: Gracia Final, L2J, 2000+

Всем привет, помогите мне сделать доступ от сервера к БД, Бд стоит на хостинге как я только конфиги сервера непереписывал всё време при запуске выдаёт ошипку
Кому не сложно скажите нубу что и где писать чтоб был доступ к бд
За ранее спасиба
Вот конфиги

читать тут
Скрытый текст







==================ГС===============






# ---------------------------------------------------------------------------
# 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 *.
# ---------------------------------------------------------------------------
# Default: *
ExternalHostname = *

# ---------------------------------------------------------------------------
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname.
# This can be the internal IP such as 127.0.0.1 or the computer's IP such as 192.168.x.x.
# If this IP is resolvable by the Login Server, just leave *.
# ---------------------------------------------------------------------------
# Default: *
InternalHostname = *

# Default: 127.0.0.1
LoginHost = 127.0.0.1

# Default: 9014
LoginPort = 9014

# Default: *
GameserverHostname = *

# Default: 7777
GameserverPort = 7777


# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Uncomment the appropriate driver and url for the database you're using. If you don't know what this is... www.google.com
Driver = com.mysql.jdbc.Driver
#Driver = org.hsqldb.jdbcDriver
#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
URL = jdbc:mysql://localhost/l2jdb
#URL = jdbc:hsqldb:hsql://localhost/l2jdb
#URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
#Database user info (using root user is not recommended)
Login = root
Password =

# Default: 100
MaximumDbConnections = 100

# Default: 0
MaximumDbIdleTime = 0

# ---------------------------------------------------------------------------
# Misc Server Settings
# ---------------------------------------------------------------------------
# This is the server ID that the Game Server will request.
# Example: 1 = Bartz
# Default: 1
RequestServerID = 1

# True = The Login Server will give an other ID to the server if the requested ID is already reserved.
# Default: True
AcceptAlternateID = True

# Datapack root directory.
# Defaults to current directory from which the server is started unless the below line is uncommented.
#DatapackRoot = C:/Work/tmp/DataPack

# Define how many players are allowed to play simultaneously on your server.
# Default: 100
MaximumOnlineUsers = 100

# Minimum and maximum protocol revision that server allow to connect.
# Warning: You must make sure that the minimum revision is always less than or equal to the maximum revision.
# Default: 12
MinProtocolRevision = 83

# Default: 17
MaxProtocolRevision = 83


# ---------------------------------------------------------------------------
# Misc Player Settings
# ---------------------------------------------------------------------------
# Character name template.
# Example: CnameTemplate = [A-Z][a-z]{3,3}[A-Za-z0-9]*
# The above setting will allow names with first capital letter, next three small letters, and any (capital or not) letter or number, like OmfgWTF1
# Most rational to have CnameTemplate = [A-Z][a-z]*
# The above setting will allow names only of letters with first one capital, like Omfgwtf
# Default .* (as many of any symbols)
CnameTemplate = .*
PetNameTemplate = .*

# Maximum number of characters per account.
# Default: 7 (client limit)
CharMaxNumber = 7



Скрытый текст




==============================ЛС===========




# ---------------------------------------------------------------------------
# Login 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.
# ---------------------------------------------------------------------------
# Default: 127.0.0.1
ExternalHostname = 127.0.0.1

# ---------------------------------------------------------------------------
# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname.
# This can be the internal IP such as 127.0.0.1 or the computer's IP such as 192.168.x.x.
# ---------------------------------------------------------------------------
# Default: 127.0.0.1
InternalHostname = 127.0.0.1

# Bind ip of the LoginServer, use * to bind on all available IPs
# Default: *
LoginserverHostname = *

# Default: 2106
LoginserverPort = 2106

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

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

# The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic)
# Default: 15
IpUpdateTime = 15


# ---------------------------------------------------------------------------
# Security
# ---------------------------------------------------------------------------
# Default: True
LogLoginController = True

# How many times you can provide an invalid account/pass before the IP gets banned.
# Default: 10
LoginTryBeforeBan = 10

# Time you won't be able to login back again after LoginTryBeforeBan tries to login.
# Default: 600 (10 minutes)
LoginBlockAfterBan = 600

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

# Enforce GameGuard authorization from client?
# If True, login server will kick client if the client bypassed GameGuard authentication.
# Default: True
ForceGGAuth = True

# Flood Protection. All values are in MILISECONDS.
# Default: True
EnableFloodProtection = True

# Default: 15
FastConnectionLimit = 15

# Default: 700
NormalConnectionTime = 700

# Default: 350
FastConnectionTime = 350

# Default: 50
MaxConnectionPerIP = 50


# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Uncomment the appropriate driver and url for the database you're using. If you don't know what this is... www.google.com
Driver = com.mysql.jdbc.Driver
#Driver = org.hsqldb.jdbcDriver
#Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
URL = jdbc:mysql://localhost/l2jdb
#URL = jdbc:hsqldb:hsql://localhost/l2jdb
#URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
#Database user info (using root user is not recommended)
Login = root
Password =

# Default: 10
MaximumDbConnections = 10

# Default: 0
MaximumDbIdleTime = 0


# ---------------------------------------------------------------------------
# Misc.
# ---------------------------------------------------------------------------
# If False, the license (after the login) will not be shown.
# Default: True
ShowLicence = True

# Default: True
AutoCreateAccounts = True


# ---------------------------------------------------------------------------
# Developer Settings
# ---------------------------------------------------------------------------
# Default: False
Debug = False

# Default: False
Assert = False

# Default: False
Developer = False

0
gemon
gemon

Пользователь

Участник

Постов: 47

На форуме с: 02.11.2008

Рейтинг: 0

· 22.05.2009, 06:45

Сделал всё равно не работает

0
PAROVOZ
PAROVOZ

Пользователь

Бывалый

Постов: 164

На форуме с: 04.03.2009

Репутация: +36

Рейтинг: 0

· 22.05.2009, 06:50

foXSer:
Скрытый текст
# ---------------------------------------------------------------------------
URL = jdbc:mysql://localhost/l2jdb           а если базы на хосте думаю и тут надо изменять
#URL = jdbc:hsqldb:hsql://localhost/l2jdb   и тут тоже.
#URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password = ну естественно и тут.
[/color]


А вот моё личное мнение , зачем ставить базу на хостинг??думаю ненадо да и думаю хуже будет.Ставь базу себе на машину.


просвяти меня нуба, зачем здесь #URL = jdbc:hsqldb:hsql://localhost/l2jdb писать ?это пример!
URL = jdbc:mysql://localhost/l2jdb  - здесь вместо localhost адрес твоей базы, вместо l2jdb - название твоей базы

0
gemon
gemon

Пользователь

Участник

Постов: 47

На форуме с: 02.11.2008

Рейтинг: 0

· 22.05.2009, 07:07

Вставил , и не работает
Сервер как бы ищет базу у меня в компе

Раскрывающийся текст
Starting L2J Game Server.

Loading GameServer Configuration Files...
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

Last packet sent to the server was 0 ms ago.
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:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
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:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:282)
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 net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:96)
at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:185)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:543)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communicatio
ns link failure

Last packet sent to the server was 0 ms ago.
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:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
074)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
... 20 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
va:253)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
... 21 more

Server terminated abnormaly


server terminated

Для продолжения нажмите любую клавишу . . .


Вот что пишет LS, когда в нём тоже поменял
Раскрывающийся текст
Starting L2J Login Server.

loading login config
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] ]
FATAL: Failed initializing database. Reason: Communications link failure

Last packet sent to the server was 0 ms ago.

Server terminated abnormaly


server terminated

Для продолжения нажмите любую клавишу . . .


0
gemon
gemon

Пользователь

Участник

Постов: 47

На форуме с: 02.11.2008

Рейтинг: 0

· 22.05.2009, 07:39

Что мне делать?

0
_IMP_
_IMP_

Пользователь

Бывалый

Постов: 205

На форуме с: 15.09.2008

Репутация: +128

Рейтинг: 0

· 22.05.2009, 08:01

Яву переустанови другую

!WTS GM-Shop-http://la2base.ru/forum/index.php?showtopic=47716&st=20&gopid=330940&
!WTS Shield of Destiny. Предлы в аську
Видео: http://dump.ru/file/3116803 <<<ТУТ
Скрины:http://dump.ru/file/3116852 <<<ТУТ и http://dump.ru/file/3116851 <<<ТУТ
Все мои новые работы вы можете найти и скачать на des.clan.su/forum

0
gemon
gemon

Пользователь

Участник

Постов: 47

На форуме с: 02.11.2008

Рейтинг: 0

· 22.05.2009, 10:56

Всё равно тоже самое

0
Арман
Арман

Пользователь

Бывалый

Постов: 200

На форуме с: 14.01.2009

Репутация: +61

Рейтинг: 0

· 22.05.2009, 11:13

gemon: Всё равно тоже самое

Демон в аську пиши 437-175-441 договоримся

0
Святослав
Святослав

Пользователь

Участник

Постов: 63

На форуме с: 15.11.2007

Репутация: +12

Рейтинг: 0

· 22.05.2009, 14:05

xDDDD БД на хостинге, а сервер дома?
Зачем тебе лишняя нагрузка на канал?
Сделай на оборот, что-бы сайт стоял на хостинге и база у тебя на компе)
и будет тебе щастье...

И зачем нужны аватары?

0
Тема закрыта для ответов