l2howto

there are 2 different machines with FRESH install of mysql.

got this problem on 2 machines with different mysql installations.

already done properly. still the same. never had something like this before. its just doesnt let me connect to it.

yes to 100%

Hello. Today i tried to setup acis server. i installed the dabatase correctly and can connect to the database also (on localhost). when i try to start the loginserver now, its telling me that access is denied. config files are set right as it seems. database name : acis user: root password: password ---------------------------------------------------------------------=[ aCis ] Loading loginserver configuration files. MLog clients using java 1.4+ standard logging. Initializing c3p0-0.9.2-pre1 [built 27-May-2010 01:00:49 -0400; debug? true; tra ce: 10] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans .IntrospectionException: java.lang.reflect.InvocationTargetException [numThreads AwaitingCheckoutDefaultUser] ] Exception in thread "main" java.sql.SQLException: Access denied for user 'root '@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4612) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2412) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2 445) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) 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:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java :334) 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:866) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled ConnectionPool(C3P0PooledConnectionPoolManager.java:789) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0 PooledConnectionPoolManager.java:298) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0 PooledConnectionPoolManager.java:312) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A bstractPoolBackedDataSource.java:128) at net.sf.l2j.L2DatabaseFactory.<init>(L2DatabaseFactory.java:97) at net.sf.l2j.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:204) at net.sf.l2j.loginserver.L2LoginServer.<init>(L2LoginServer.java:80) at net.sf.l2j.loginserver.L2LoginServer.main(L2LoginServer.java:50) Server have terminated abnormaly. loginserver #============================================================= # Loginserver #============================================================= # This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname 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 InternalHostname = 127.0.0.1 # Bind ip of the LoginServer, use * to bind on all available IPs LoginserverHostname = * LoginserverPort = 2106 # How many times you can provide an invalid account/pass before the IP gets banned LoginTryBeforeBan = 10 # Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600) LoginBlockAfterBan = 600 # The address on which login will listen for GameServers, use * to bind on all available IPs LoginHostname = * # The port on which login will listen for GameServers LoginPort = 9014 # If set to true any GameServer can register on your login's free slots AcceptNewGameServer = False # If false, the licence (after the login) will not be shown # It is highly recomended for Account Security to leave this option as default (True) ShowLicence = True #============================================================= # Database informations #============================================================= # Database info Driver = com.mysql.jdbc.Driver #Driver = org.hsqldb.jdbcDriver #Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver URL = jdbc:mysql://localhost/acis #URL = jdbc:hsqldb:hsql://localhost/acis #URL = jdbc:sqlserver://localhost/database=acis/user=sa/password= Login = root Password = password MaximumDbConnections = 10 # Usable values: "true" - "false", use this option to choose whether accounts will be created automatically or not. AutoCreateAccounts = True # The delay in minutes after which the login updates the gameservers IP's (useful when their ip is dynamic) IpUpdateTime = 15 #============================================================= # Security #============================================================= # Log all events from loginserver (account creation, failed/success login, etc) LogLoginController = False # Enforce GG Authorization from client # Login server will kick client if client bypassed GameGuard authentication ForceGGAuth = True # FloodProtection. time in ms EnableFloodProtection = True FastConnectionLimit = 15 NormalConnectionTime = 700 FastConnectionTime = 350 MaxConnectionPerIP = 50 #============================================================= # Test server, shoudnt be touched in live server #============================================================= Debug = False Developer = False PacketHandlerDebug = False

4 hours :O

true :-beep- yeah:

testing oly at the moment. still everyhting seems to be perfect !

Still :not bad:

fapping probably.

:forever alone like a boss:

playing 1 week on beta now (not much people play beta). and i have to say that this will definitely rock.

very nice video !

online?

Hello again, when i use mana drug it gives me rice cake icon in my buffbar. also it tells me in system : "Rice cake's effect can be felt". how to change that?