L2J Server

L2J Server Discussion Board
https://l2jserver.com/forum/

erors

https://l2jserver.com/forum/viewtopic.php?t=18749

Page 1 of 2

erors

Posted: Tue Sep 14, 2010 12:29 pm
by Ai17
I have some eror when i go to javas trow eclipse no erors but when start server trow putty it writes this :


Code: Select all

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 [numThreadsAwaitingCheckoutDefaultUser] ]Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920)    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4000)    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1285)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2186)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:772)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:696)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:257)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:271)    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)    at com.l2jserver.L2DatabaseFactory.<init>(L2DatabaseFactory.java:96)    at com.l2jserver.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:207)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:489)

Re: erors

Posted: Tue Sep 14, 2010 12:34 pm
by SolidSnake
First, wrong section
Second, set your loginserver and server.properties

Code: Select all

Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)

Re: erors

Posted: Tue Sep 14, 2010 12:40 pm
by Ai17
mmm a little incomprehension... were i need to change this ?

Re: erors

Posted: Tue Sep 14, 2010 1:06 pm
by Ai17
where and how i msut change ? if octal i set 0777

Re: erors

Posted: Tue Sep 14, 2010 1:10 pm
by SolidSnake

Code: Select all

# Database user info (default is "root" but it's not recommended)-Login = root+Login = your database user info# Database connection password-Password =+Password = your database password

Re: erors

Posted: Tue Sep 14, 2010 1:28 pm
by Ai17
i change and it still

Code: Select all

Loading GameServer Configuration Files...L2Properties: Missing property for key - DatapackRootLoaded 5 Filter Words.-----------------------------------------------------------------=[ Database ]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 [numThreadsAwaitingCheckoutDefaultUser] ]Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920)    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4000)    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1285)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2186)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)    at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)    at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:772)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:696)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:257)    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:271)    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)    at com.l2jserver.L2DatabaseFactory.<init>(L2DatabaseFactory.java:96)    at com.l2jserver.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:207)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:489)

Code: Select all

# 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.SQLServerDriverDriver = 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 passwordPassword = "My pw" # Default: 100MaximumDbConnections = 100 # Default: 0MaximumDbIdleTime = 0

Re: erors

Posted: Tue Sep 14, 2010 2:05 pm
by SolidSnake
server and loginserver.properties? Are both setted ?

Re: erors

Posted: Tue Sep 14, 2010 2:13 pm
by _DS_
Not ab bugreport, topic moved.

Re: erors

Posted: Tue Sep 14, 2010 2:15 pm
by Ai17

Code: Select all

# 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.SQLServerDriverDriver = 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 passwordPassword = 'my pasword' # Default: 10MaximumDbConnections = 10 # Default: 0MaximumDbIdleTime = 0 

mabye i register my server wrong trow putty ?

in putty i put this : mysql -u root -p bembis then pw (and this pw must be in server properties yes ? ) and what now i need to do ? o mabye somethink with my phpadmin ? http://yfrog.com/n0phpoj

Re: erors

Posted: Tue Sep 14, 2010 3:17 pm
by Ai17
Solidsnake mabye this ??>? because im not in localhost and my name is not "l2jdb" it "bembis"


# # 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

Re: erors

Posted: Tue Sep 14, 2010 3:37 pm
by SolidSnake
Open navicat, click right on 'bembis' and choose Connection Information

So write in login and server.properties 'URL = jdbc:mysql://localhost(<- replace this with host name/IP address)/l2jdb(<- replace this with connection name, 'bembis')

Code: Select all

-URL = jdbc:mysql://localhost/l2jdb+URL = jdbc:mysql://host name/bembis

Re: erors

Posted: Tue Sep 14, 2010 4:07 pm
by Ai17
login server is working but when i go to game i still cant login but game server is same eror

# URL = jdbc:sqlserver://178.63.197.105/database = bembis/user = sa/password = "my pv" is this right ?


java0 : 2010.09.14 17:52:49,681 INFO 10 com.l2jserver.util.L2Properties L2Properties: Missing property for key - DatapackRoot

Re: erors

Posted: Tue Sep 14, 2010 9:27 pm
by jurchiks
omg...
you don't use jdbc:sqlserver, you use jdbc:mysql

Re: erors

Posted: Tue Sep 14, 2010 11:39 pm
by dinor
Ai17 try to read the configs and make the changes...
At least read this: http://www.l2jserver.com/wiki/index.php/Setup_Server

Re: erors

Posted: Wed Sep 15, 2010 5:13 am
by Ai17
dinor your are the funnt guy, you dont understand, when i was holding my server by my own it was ok no erors and i know how instal database, but now i put my files to private server and i need to instal database through putty and use comands and i think i have made some mistakes but no one undertand's,
All times are UTC
Page 1 of 2

Powered by phpBB® Forum Software © phpBB Limited