[help] Ошибка

Сборка: L2jofficial_rev_274
СОбсно.
вот

FATAL: Failed loading GameServerTable. Reason: Access denied for user 'root'@'lo
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:96)
at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:185)
at net.sf.l2j.loginserver.GameServerTable.loadRegisteredGameServers(Game
ServerTable.java:152)
at net.sf.l2j.loginserver.GameServerTable.<init>(GameServerTable.java:85
)
at net.sf.l2j.loginserver.GameServerTable.load(GameServerTable.java:67)
at net.sf.l2j.gsregistering.GameServerRegister.main(GameServerRegister.j
ava:46)
Для продолжения нажмите любую клавишу . . .

Где и что поправить.

настрой в конфигах геймсервера и логинсервера название базы, логин и пароль

геймсервер тебе говорит что логин root и пароль не подходят. ты не вписал в конфиг свои

# ---------------------------------------------------------------------------
# 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 = C:\Program Files\MySQL\MySQL Server 5.0\bin
#Driver = C:\Program Files\MySQL\MySQL Server 5.0\bin
#Driver = C:\Program Files\MySQL\MySQL Server 5.0\bin
URL = jdbc:mysql://localhost/l2jdb
#URL = jdbc:hsqldb:hsql://localhost/l2jdb
#URL = jdbc:sqlserver://localhost/database = l2jdb/user = root/password =12345
#Database user info (using root user is not recommended)
Login = root
Password = 12345

ну если это из конфига твоего геймсервера,и если твой логин в мускуле действительно root, то у меня только один вариант - #Database user info (using root user is not recommended) может у них с этим проблемы))глупо звучит,но мало ли)

короче я впалил такую фишку что database_instaler базы не устанавливает... в навикате пустая база не одной таблицы нет.
хз как лечить =(

когда у меня не пахал инсталлер, я *.sql все добавлял через навикат...по 1му....))))))

открой блокнотом батник,посмотри,может там нужно логин с паролем сменить.и название базы

Проверь правильность настроек дб инсталера... все пути там правильно указал?

:configure
call :colors 17
title L2JDP installer - Setup
cls
set config_version=1
if NOT %upgrade_mode% == 2 (
set fresh_setup=1
set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.2\bin
set lsuser=root
set lspass=ferum90nsk
set lsdb=l2jdb
set lshost=localhost
set gsuser=root
set gspass=ferum90nsk
set gsdb=l2jdb
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)
set mysqlPath=%mysqlBinPath%\mysql.exe
echo New settings will be created for this tool to run in
echo your computer, so I need to ask you some questions.
echo.
echo 1-MySql Binaries
echo --------------------
echo In order to perform my tasks, I need the path for commands
echo such as 'mysql' and 'mysqldump'. Both executables are
echo usually stored in the same place.
echo.
if "%mysqlBinPath%" == "" (
set mysqlBinPath=use path
echo I can't determine if the binaries are available with your
echo default settings.
) else (
echo I can try to find out if the current setting actually works...
echo.
echo %mysqlPath%
)
if not "%mysqlBinPath%" == "use path" call :binaryfind
echo.
path|find "MySQL">NUL
if %errorlevel% == 0 (
echo I found MySQL is in your PATH, this will be used by default.
echo If you want to use something different, change 'use path' for
echo something else.
set mysqlBinPath=use path
) else (
echo Look, I can't find "MYSQL" in your PATH environment variable.
echo It would be good if you go and find out where "mysql.exe" and
echo "mysqldump.exe" are.
echo.
echo If you have no idea about the meaning of words such as MYSQL
echo or PATH, you'd better close this window, and consider googling
echo and reading about it. Setup and host an L2J server requires a
echo minimum of technical skills.
)
echo.
echo Write the path to your MySQL binaries (no trailing slash needed):
set /P mysqlBinPath="(default %mysqlBinPath%): "
cls
echo.
echo 2-LoginServer settings
echo --------------------
echo I will connect to the MySQL server you specify, and setup a
echo Loginserver database there, most people use a single MySQL
echo server and database for both Login and Gameserver tables.
echo.
set /P lsuser="MySQL Username (default is '%lsuser%'): "
set /P lspass="Password (will be shown as you type, default '%lspass%'): "
set /P lsdb="Database (default is '%lsdb%'): "
set /P lshost="Host (default is '%lshost%'): "
if NOT "%lsuser%"=="%gsuser%" set gsuser=%lsuser%
if NOT "%lspass%"=="%gspass%" set gspass=%lspass%
if NOT "%lsdb%"=="%gsdb%" set gsdb=%lsdb%
if NOT "%lshost%"=="%gshost%" set gshost=%lshost%
echo.
echo 3-GameServer settings
echo --------------------
set /P gsuser="User (default is '%gsuser%'): "
set /P gspass="Pass (default is '%gspass%'): "
set /P gsdb="Database (default is '%gsdb%'): "
set /P gshost="Host (default is '%gshost%'): "
echo.
echo 4-Misc. settings
echo --------------------
set /P cmode="Color mode ©olor or (n)on-color, default %cmode% : "
set /P backup="Path for your backups (default '%backup%'): "
set /P logdir="Path for your logs (default '%logdir%'): "
:safe1
set safemode=y
set /P safemode="Debugging messages and increase verbosity a lil bit (y/n, default '%safemode%'): "
if /i %safemode%==y (set safe_mode=1&goto safe2)
if /i %safemode%==n (set safe_mode=0&goto safe2)
goto safe1
:safe2
echo.
if "%mysqlBinPath%" == "use path" (
set mysqlBinPath=
set mysqldumpPath=mysqldump
set mysqlPath=mysql
) else (
set mysqldumpPath=%mysqlBinPath%\mysqldump.exe
set mysqlPath=%mysqlBinPath%\mysql.exe
)
echo @echo off > %config_file%
echo set config_version=%config_version% >> %config_file%
echo set cmode=%cmode%>> %config_file%
echo set safe_mode=%safe_mode% >> %config_file%
echo set mysqlPath=%mysqlPath%>> %config_file%
echo set mysqlBinPath=%mysqlBinPath%>> %config_file%
echo set mysqldumpPath=%mysqldumpPath%>> %config_file%
echo set lsuser=%lsuser%>> %config_file%
echo set lspass=%lspass%>> %config_file%
echo set lsdb=%lsdb%>> %config_file%
echo set lshost=%lshost% >> %config_file%
echo set gsuser=%gsuser%>> %config_file%
echo set gspass=%gspass%>> %config_file%
echo set gsdb=%gsdb%>> %config_file%
echo set gshost=%gshost%>> %config_file%
echo set logdir=%logdir%>> %config_file%
echo set backup=%backup%>> %config_file%
echo.
echo Script setup complete, your settings were saved in the
echo '%config_file%' file. Remember: your passwords are stored
echo as clear text.
echo.
echo press any key to continue...
pause> nul
goto loadconfig

Эта часть правильно??

инсталер пишет "системе не удалось найти указаный путь"

set mysqlPath=%mysqlBinPath%\mysql.exe и подобные строки исправь под себя, укажи свой пусть к мускулу. или в файле vars.txt

а база точно l2jdb? если да,то не понимаю в чем проблема....наверно уже за компом пересидел я))

VARS.TXT выглядит так

@echo off
set config_version=1
set cmode=c
set safe_mode=1
set mysqlPath=C:\Program Files\MySQL Server 5.2\bin\mysql.exe
set mysqlBinPath=C:\Program Files\MySQL Server 5.2\bin
set mysqldumpPath=C:\Program Files\MySQL Server 5.2\bin\mysqldump.exe
set lsuser=root
set lspass=ferum90nsk
set lsdb=l2jdb
set lshost=localhost
set gsuser=root
set gspass=ferum90nsk
set gsdb=l2jdb
set gshost=localhost
set logdir='.'
set backup='.'

ну если у тебя база действительно l2jdb, логин действительно root, пароль действительно ferum90nsk и путь до папки bin действительно C:\Program Files\MySQL Server 5.2\bin, то, думаю, тут только один вариант - включить мускул=) возможно он выключен)

Навикат конектится с базой. Но в ней пусто.
а инсталер выдаёт такую тему

Trying to make a backup of your loginserver database.
Системе не удается найти указанный путь.

LOGINSERVER DATABASE install type:

(f)ull: I will destroy data in your `accounts` and
and `gameserver` tables.

(s)kip: I'll take you to the gameserver database
installation and upgrade options.

®econfigure: You'll be able to redefine MySQL path,
user and database information and start over with
those fresh values.

(q)uit

Choose (default skip) :

ну сравни то,что ты писал в навикате для коннекта, и то,что есть в инсталлере и в vars....

плин всё буква в букву совподает =(

Блин, как может быть 2 разных пасса? Поставь тот пасс который в мускуле!

Ska: Блин, как может быть 2 разных пасса? Поставь тот пасс который в мускуле!

Код

#Database user info (using root user is not recommended)
Login = root
Password = 12345

<---- здесь такой

Код

set lsuser=root
set lspass=ferum90nsk <---- а здесь такой
set lsdb=l2jdb
set lshost=localhost

Так базы то я поправил... Но терь такая проблемка...
Регистер сервер не создаёт фаила Хексид


java.sql.SQLException: could not init DB connection:java.lang.ClassNotFoundExcep
tion: C:Program FilesMySQLMySQL Server 5.2bin
at l2d.db.L2DatabaseFactory.<init>(L2DatabaseFactory.java:86)
at l2d.db.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:93)
at l2d.login.GameServerTable.loadRegisteredGameServers(GameServerTable.j
ava:147)
at l2d.login.GameServerTable.<init>(GameServerTable.java:84)
at l2d.gsreg.GSReg.main(GSReg.java:25)
L2Dream Game Server Register
Enter The id of the server you want to register or type help to get a list of id
s:
Your choice:
1
Exception in thread "main" java.lang.NullPointerException
at l2d.gsreg.GSReg.main(GSReg.java:48)
Для продолжения нажмите любую клавишу . . .


если кому удобнее в аську то 226519202

onfigure
call :colors 17
title L2JDP installer - Setup
cls
set config_version=1
if NOT %upgrade_mode% == 2 (
set fresh_setup=1
set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.2\bin
set lsuser=root
set lspass=ferum90nsk
set lsdb=l2jdb
set lshost=localhost
set gsuser=root
set gspass=ferum90nsk
set gsdb=l2jdb
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)
set mysqlPath=%mysqlBinPath%\mysql.exe
echo New settings will be created for this tool to run in
echo your computer, so I need to ask you some questions.
echo.

У тебя точно 5.2 Mysql попробуй поставь 5.0 и пробуй установить!!!

Помог жми спасибку