Jump to content
  • 0

acis access denied





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
        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
        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
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
        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

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname =

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname =

# 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

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

  • 0

You are probably using a second instance of mysl, just remove mysql and re-install it and setup correctly password again.

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

Link to comment
Share on other sites

  • 0

Try with a blank password, just to be sure, sometimes when i remove mysql and re-install it does not recognize my password even if i set one.

got this problem on 2 machines with different mysql installations.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...