acis access denied

[l2howto]

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

[SweeTs]

Silly question, but.. Are you sure you're using the same password as to database (navicat)? :P

[l2howto]

Silly question, but.. Are you sure you're using the same password as to database (navicat)? :P

yes to 100%

[cyberghoser1]

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

[l2howto]

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.

[cyberghoser1]

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.

[l2howto]

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.

[cyberghoser1]

Remove completely mysql and re-install, set user and password from the beggining should fix that

[l2howto]

Remove completely mysql and re-install, set user and password from the beggining should fix that

there are 2 different machines with FRESH install of mysql.

[Zohan]

there are 2 different machines with FRESH install of mysql.

Unistall your mysql + navicat.

Then remove mysql + navicat from disks (C:/ or D:/)

And install mysql + navicat again.