erors

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Ai17
Posts: 191
Joined: Tue Jun 29, 2010 8:05 am

erors

Post 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)
Top
User avatar
SolidSnake
Posts: 865
Joined: Wed Jan 20, 2010 6:54 pm
Location: Italy

Re: erors

Post 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)
Image
Top
Ai17
Posts: 191
Joined: Tue Jun 29, 2010 8:05 am

Re: erors

Post by Ai17 »

mmm a little incomprehension... were i need to change this ?
Top
Ai17
Posts: 191
Joined: Tue Jun 29, 2010 8:05 am

Re: erors

Post by Ai17 »

where and how i msut change ? if octal i set 0777
Top
User avatar
SolidSnake
Posts: 865
Joined: Wed Jan 20, 2010 6:54 pm
Location: Italy

Re: erors

Post 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
Image
Top
Ai17
Posts: 191
Joined: Tue Jun 29, 2010 8:05 am

Re: erors

Post 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
Top
User avatar
SolidSnake
Posts: 865
Joined: Wed Jan 20, 2010 6:54 pm
Location: Italy

Re: erors

Post by SolidSnake »

server and loginserver.properties? Are both setted ?
Image
Top
_DS_
L2j Veteran
L2j Veteran
Posts: 3437
Joined: Wed Apr 30, 2008 8:53 am
Location: Russia

Re: erors

Post by _DS_ »

Not ab bugreport, topic moved.
Commiter of the shit
public static final int PI = 3.1415926535897932384626433832795;
Top
Ai17
Posts: 191
Joined: Tue Jun 29, 2010 8:05 am

Re: erors

Post 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
Top
Ai17
Posts: 191
Joined: Tue Jun 29, 2010 8:05 am

Re: erors

Post 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
Top
User avatar
SolidSnake
Posts: 865
Joined: Wed Jan 20, 2010 6:54 pm
Location: Italy

Re: erors

Post 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
Image
Top
Ai17
Posts: 191
Joined: Tue Jun 29, 2010 8:05 am

Re: erors

Post 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
Top
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: erors

Post by jurchiks »

omg...
you don't use jdbc:sqlserver, you use jdbc:mysql
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Top
dinor
Posts: 141
Joined: Tue Aug 26, 2008 10:07 am

Re: erors

Post 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
Top
Ai17
Posts: 191
Joined: Tue Jun 29, 2010 8:05 am

Re: erors

Post 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,
Top
Post Reply

Return to “High Five Support”