[help] Проблема с Registergameserve
Сборка l2jServer 6269. Грация финал ставлю на Vertrigo-221 Запускаю RegisterGameServer.bat Выдаёт такое
calhost' (using password: YES)
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password
: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
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:95)
at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:206)
at net.sf.l2j.loginserver.GameServerTable.loadRegisteredGameServers(Game
ServerTable.java:155)
at net.sf.l2j.loginserver.GameServerTable.<init>(GameServerTable.java:88
)
at net.sf.l2j.loginserver.GameServerTable.load(GameServerTable.java:69)
at net.sf.l2j.gsregistering.GameServerRegister.main(GameServerRegister.j
ava:46)
Для продолжения нажмите любую клавишу . . .
Базу переустонавливал 5 раз со стандартным паролем для Vertrigo password vertrigo
Исамое главное Гейм сервер запускается и нормально работает
В конфигах пароль прописан правильною
FATAL: Failed loading GameServerTable. Reason: Access denied for user 'root'@'lo
calhost' (using password: YES)
Выводы делай сам.
— Тру падонак
Пароль я прописал всё правильно
# 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 = 127.0.0.1
# 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
# ---------------------------------------------------------------------------
# Specify the appropriate driver and url for the database you're using.
# Examples:
# Driver = com.mysql.jdbc.Driver (default)
# Driver = org.hsqldb.jdbcDriver
# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver = com.mysql.jdbc.Driver
# Database URL
# URL = jdbc:mysql://localhost/l2jdb (default)
# URL = jdbc:hsqldb:hsql://localhost/l2jdb
# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
URL = jdbc:mysql://localhost/l2jdb
# Database user info (default is "root" but it's not recommended)
Login = root
# Database connection password
Password =vertrigo
# 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
# ---------------------------------------------------------------------------
# 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 = Здесь вводи свои IP
# ---------------------------------------------------------------------------
# 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 = Здесь вводи свои IP
# Bind ip of the LoginServer, use * to bind on all available IPs
# Default: *
LoginserverHostname = Здесь вводи свои IP
# Default: 2106
LoginserverPort = 2106
# The address on which login will listen for GameServers, use * to bind on all available IPs
# Default: *
LoginHostname = Здесь вводи свои IP
# 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
# ---------------------------------------------------------------------------
# Specify the appropriate driver and url for the database you're using.
# Examples:
# Driver = com.mysql.jdbc.Driver (default)
# Driver = org.hsqldb.jdbcDriver
# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver = com.mysql.jdbc.Driver
# Database URL
# URL = jdbc:mysql://localhost/l2jdb (default)
# URL = jdbc:hsqldb:hsql://localhost/l2jdb
# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
URL = jdbc:mysql://localhost/l2jdb
# Database user info (default is "root" but it's not recommended)
Login = root
# Database connection password
Password =vertrigo
# 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 = Fals
# URL = jdbc:mysql://localhost/l2jdb (default)
# URL = jdbc:hsqldb:hsql://localhost/l2jdb
# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
URL = jdbc:mysql://localhost/l2jdb
# Database user info (default is "root" but it's not recommended)
база у тебя точно называется l2jdb? если нет поменяй названия на свое
# URL = jdbc:mysql://localhost/свое название базы(default)
# URL = jdbc:hsqldb:hsql://localhost/свое название базы
# URL = jdbc:sqlserver://localhost/database = свое название базы/user = sa/password =
URL = jdbc:mysql://localhost/свое название базы
Я просто умираю Всё правильно настроино Только что у становил заново L2Jfree-graciapart2-rev1.2.11-stable Всё работает А финалка нет.Предпологаю что Датаинсталер поработал кривоюДайте ссылку на норм серв Грации финал только не Emul
presario: Я просто умираю Всё правильно настроино Только что у становил заново L2Jfree-graciapart2-rev1.2.11-stable Всё работает А финалка нет.Предпологаю что Датаинсталер поработал кривоюДайте ссылку на норм серв Грации финал только не Emul
Я дал тебе ответ.. В пароль после знака = пробел сделай
— А что тут надо писать? :D
Делал но бестолку
В данный момент пробую установить сборку L2J_Server-6301 но регистргем сервера пишет
А где должен находится этот файл и его путь ичто сним делать незнаю
Мда..... Если ты так будешь менять сервера не понять проблемы, ПУСТЬ СОПУТСТВУЕТ ТЕБЕ УДАЧА!!!!!
Сделай ТАк:
# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Specify the appropriate driver and url for the database you're using.
# Examples:
# Driver = com.mysql.jdbc.Driver (default)
# Driver = org.hsqldb.jdbcDriver
# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver = com.mysql.jdbc.Driver
# Database URL
# URL = jdbc:mysql://localhost/l2jdb (default)
# URL = jdbc:hsqldb:hsql://localhost/l2jdb
# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
URL = jdbc:mysql://localhost/l2jdb
# Database user info (default is "root" but it's not recommended)
Login=root
# Database connection password
Password=vertrigo
Если не покатит
То так:
# ---------------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------------
# Specify the appropriate driver and url for the database you're using.
# Examples:
# Driver = com.mysql.jdbc.Driver (default)
# Driver = org.hsqldb.jdbcDriver
# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver = com.mysql.jdbc.Driver
# Database URL
# URL = jdbc:mysql://localhost/l2jdb (default)
# URL = jdbc:hsqldb:hsql://localhost/l2jdb
# URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password =
URL = jdbc:mysql://localhost/l2jdb
# Database user info (default is "root" but it's not recommended)
Login = root
# Database connection password
Password = vertrigo
И еще! У вертиги, там Мускул настроен не верно! И вообще Юзай xampp если же ты хочешь ставить сайт! "Vertrigo" отстой! Она гонимая.......
И смотря какая версия у тебя, у меня такого не было, ну я хз, пробуй!
Переустанови ее, и по новой сделай, если не поможет, поставь блин Mysql 5.1 x64 если Винда 64бит, ибо 32 ставь, и xampp и все что нужно, НАвикаты фигаты, МУскул более понятен! И пароль там установить можно Любой, ну в вертиге тоже можно, а ты увереен что он именне vertrigo. а ты зайди в Админку удостоверься! Возможно там пароль другой, ну так смени!)
И вообще если пишит FATAL: Failed loading GameServerTable. Reason: Access denied for user 'root'@'localhost' (using password: YES) Это значит что такой пароль был установлен ранее, значит его уже нельзя использовать, ибо утебя он наложен на другой, там хер пойми, Удали ее на "х" и не мучайся! И все у тебя получится!!