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?

Thank you eKoMiracle. It is working !

and what to change there? can you maybe send me your etcitemgrp ? tag id drop_type drop_anim_type drop_radius drop_height UNK_0 drop_mesh1 drop_mesh2 drop_mesh3 drop_tex1 drop_tex2 drop_tex3 icon[0] icon[1] icon[2] icon[3] icon[4] durability weight material crystallizable type1 mesh_tex_pair_cntm mesh_tex_pair_m[0] mesh_tex_pair_cntt mesh_tex_pair_t[0] item_sound equip_sound stackable family grade i cant see something like a group what i need to do

Hello. if i click on a potion (in my example i clicked the greater healing potion) every potion is shown as reloading. (only shown as reloading, i can still use them) example: where is the problem here?

works. SOLVED

Hello. After i killed scarlet van halisha the frintezza disappears and the gameserver is giving me : 10:07:47.693 update EpicBossState: ID:29045, RespawnDate:1358932067, State:ALIV E 10:13:24.821 [RaidBossSpawnManager]: Scheduled Scarlet van Halisha for respawn in 1000d 10:13:46.020 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.048 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.051 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.054 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.077 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.107 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.119 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.140 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.226 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.276 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.296 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:46.400 update EpicBossState: ID:29045, RespawnDate:1358932426, State:INTE RVAL 10:13:53.893 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.896 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.898 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.900 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.902 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.904 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.905 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.907 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.909 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.911 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.912 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.928 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.976 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.978 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.988 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.990 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.992 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.982 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:53.992 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.132 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.132 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.103 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.196 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.207 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.339 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.389 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.393 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.527 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.527 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.528 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.528 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.527 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.528 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.529 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.528 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.593 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.595 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.596 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.595 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.623 update EpicBossState: ID:29045, RespawnDate:1358932433, State:INTE RVAL 10:13:54.631 update EpicBossState: ID:29045, RespawnDate:1358932434, State:INTE RVAL 10:13:54.694 update EpicBossState: ID:29045, RespawnDate:1358932434, State:INTE RVAL 10:13:54.847 update EpicBossState: ID:29045, RespawnDate:1358932434, State:INTE RVAL 10:13:54.877 update EpicBossState: ID:29045, RespawnDate:1358932434, State:INTE RVAL 10:13:54.885 update EpicBossState: ID:29045, RespawnDate:1358932434, State:INTE RVAL 10:13:54.996 update EpicBossState: ID:29045, RespawnDate:1358932434, State:INTE RVAL 10:13:55.452 update EpicBossState: ID:29045, RespawnDate:1358932435, State:INTE RVAL 10:13:55.553 update EpicBossState: ID:29045, RespawnDate:1358932435, State:INTE RVAL 10:13:55.765 update EpicBossState: ID:29045, RespawnDate:1358932435, State:INTE RVAL 10:13:55.875 update EpicBossState: ID:29045, RespawnDate:1358932435, State:INTE RVAL 10:13:55.917 update EpicBossState: ID:29045, RespawnDate:1358932435, State:INTE RVAL 10:13:55.946 update EpicBossState: ID:29045, RespawnDate:1358932435, State:INTE RVAL 10:13:56.868 update EpicBossState: ID:29045, RespawnDate:1358932436, State:INTE RVAL 10:13:56.899 update EpicBossState: ID:29045, RespawnDate:1358932436, State:INTE RVAL 10:13:57.041 update EpicBossState: ID:29045, RespawnDate:1358932437, State:INTE RVAL 10:13:57.130 update EpicBossState: ID:29045, RespawnDate:1358932437, State:INTE RVAL 10:13:57.158 update EpicBossState: ID:29045, RespawnDate:1358932437, State:INTE RVAL 10:13:57.317 update EpicBossState: ID:29045, RespawnDate:1358932437, State:INTE RVAL 10:13:57.585 update EpicBossState: ID:29045, RespawnDate:1358932437, State:INTE RVAL 10:13:57.835 update EpicBossState: ID:29045, RespawnDate:1358932437, State:INTE RVAL 10:13:57.990 update EpicBossState: ID:29045, RespawnDate:1358932437, State:INTE RVAL 10:13:58.121 update EpicBossState: ID:29045, RespawnDate:1358932438, State:INTE RVAL 10:13:58.222 update EpicBossState: ID:29045, RespawnDate:1358932438, State:INTE RVAL 10:13:58.304 update EpicBossState: ID:29045, RespawnDate:1358932438, State:INTE RVAL 10:13:59.164 update EpicBossState: ID:29045, RespawnDate:1358932439, State:INTE RVAL 10:13:59.170 update EpicBossState: ID:29045, RespawnDate:1358932439, State:INTE RVAL 10:13:59.277 update EpicBossState: ID:29045, RespawnDate:1358932439, State:INTE RVAL 10:13:59.537 update EpicBossState: ID:29045, RespawnDate:1358932439, State:INTE RVAL 10:13:59.595 update EpicBossState: ID:29045, RespawnDate:1358932439, State:INTE RVAL 10:13:59.654 update EpicBossState: ID:29045, RespawnDate:1358932439, State:INTE RVAL 10:13:59.671 update EpicBossState: ID:29045, RespawnDate:1358932439, State:INTE RVAL 10:14:00.070 update EpicBossState: ID:29045, RespawnDate:1358932440, State:INTE RVAL 10:14:00.281 update EpicBossState: ID:29045, RespawnDate:1358932440, State:INTE RVAL 10:14:00.587 update EpicBossState: ID:29045, RespawnDate:1358932440, State:INTE RVAL 10:14:00.650 update EpicBossState: ID:29045, RespawnDate:1358932440, State:INTE RVAL 10:14:00.654 update EpicBossState: ID:29045, RespawnDate:1358932440, State:INTE RVAL 10:14:01.495 update EpicBossState: ID:29045, RespawnDate:1358932441, State:INTE RVAL 10:14:01.564 update EpicBossState: ID:29045, RespawnDate:1358932441, State:INTE RVAL 10:14:01.574 update EpicBossState: ID:29045, RespawnDate:1358932441, State:INTE RVAL 10:14:01.701 update EpicBossState: ID:29045, RespawnDate:1358932441, State:INTE RVAL 10:14:01.725 update EpicBossState: ID:29045, RespawnDate:1358932441, State:INTE RVAL 10:14:01.933 update EpicBossState: ID:29045, RespawnDate:1358932441, State:INTE RVAL 10:14:01.951 update EpicBossState: ID:29045, RespawnDate:1358932441, State:INTE RVAL 10:14:02.072 update EpicBossState: ID:29045, RespawnDate:1358932442, State:INTE RVAL 10:14:02.667 update EpicBossState: ID:29045, RespawnDate:1358932442, State:INTE RVAL 10:14:02.692 update EpicBossState: ID:29045, RespawnDate:1358932442, State:INTE RVAL 10:14:02.893 update EpicBossState: ID:29045, RespawnDate:1358932442, State:INTE RVAL 10:14:02.998 update EpicBossState: ID:29045, RespawnDate:1358932442, State:INTE RVAL 10:14:03.669 update EpicBossState: ID:29045, RespawnDate:1358932443, State:INTE RVAL 10:14:03.782 update EpicBossState: ID:29045, RespawnDate:1358932443, State:INTE RVAL 10:14:03.954 update EpicBossState: ID:29045, RespawnDate:1358932443, State:INTE RVAL 10:14:03.961 update EpicBossState: ID:29045, RespawnDate:1358932443, State:INTE RVAL 10:14:04.001 update EpicBossState: ID:29045, RespawnDate:1358932444, State:INTE RVAL 10:14:04.109 update EpicBossState: ID:29045, RespawnDate:1358932444, State:INTE RVAL 10:14:04.171 update EpicBossState: ID:29045, RespawnDate:1358932444, State:INTE RVAL 10:14:04.246 update EpicBossState: ID:29045, RespawnDate:1358932444, State:INTE RVAL 10:14:04.807 update EpicBossState: ID:29045, RespawnDate:1358932444, State:INTE RVAL 10:14:04.948 update EpicBossState: ID:29045, RespawnDate:1358932444, State:INTE RVAL 10:14:05.323 update EpicBossState: ID:29045, RespawnDate:1358932445, State:INTE RVAL 10:14:05.405 update EpicBossState: ID:29045, RespawnDate:1358932445, State:INTE RVAL anyone knows what to do?

than it is giving me the error just in another way ArmorType cannot be resolved to a variable

Hello. I am tryin to add the anti heavy code from this thread -> http://maxcheaters.com/forum/index.php?topic=196515.0 in L2Armor.java i got this public enum ArmorType { NONE(1, "None"), LIGHT(2, "Light"), HEAVY(3, "Heavy"), MAGIC(4, "Magic"), PET(5, "Pet"), SIGIL(5, "Sigil"); final int _id; final String _name; ArmorType(int id, String name) { _id = id; _name = name; } public int mask() { return 1 << _id + 20; } and in UseItem.java i added this if ((item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 8) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 23) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 35) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 93) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 101) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 108) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 9) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 24) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 37) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 92) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 102) || (item.getItem().getItemType() == L2ArmorType.HEAVY) && (activeChar.getClassId().getId() == 109)) { activeChar.sendPacket(new SystemMessage(SystemMessage.S1_CANNOT_BE_USED_DUE_TO_UNSUITABLE_TERMS)); return; } but its giving me L2ArmorType cannot be resolved to a variable and yes i also imported L2Armor.java to UseItem.java

hello. if i add a icon from a random item into a html from npc i can only see it, if i got the item in my inventory. how can it be shown without having it? example: <td width="32" valign="top"><img src="item_canuse09" width="32" height="32" align="top" /></td>

great

very nice