Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-36069

Portal Setup Wizard causes JDBC access denied error

    Details

    • Fix Priority:
      5

      Description

      1.) Create empty Mysql database 'lportal'
      2.) Build Liferay Portal
      3.) Include the following in tomcat-7.0.40\webapps\ROOT\WEB-INF\classes\portal-ext.properties:

      jdbc.default.driverClassName=com.mysql.jdbc.Driver
      jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
      jdbc.default.username=
      jdbc.default.password=

      4.) Ensure that the Setup Wizard properties file doesn't already exist in the Liferay home folder
      5.) Start Liferay
      6.) Click Finish Configuration

      The following exceptions will appear in the console:

      16:51:27,726 WARN  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#3][BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7fc49aaa -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: 
      java.sql.SQLException: Access denied for user 'test@liferay.com'@'localhost' (using password: YES)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
      	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
      	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
      	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
      	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
      	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
      	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
      	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
      	at sun.reflect.GeneratedConstructorAccessor33.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
      	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
      	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
      	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
      	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
      	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
      	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
      	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
      	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
      16:51:27,729 WARN  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2][BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5a9a5361 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: 
      java.sql.SQLException: Access denied for user 'test@liferay.com'@'localhost' (using password: YES)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
      	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
      	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
      	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
      	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
      	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
      	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
      	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
      	at sun.reflect.GeneratedConstructorAccessor33.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
      	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
      	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
      	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
      	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
      	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
      	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
      	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
      	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
      16:51:27,729 WARN  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#9][BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@32ea1b50 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: 
      java.sql.SQLException: Access denied for user 'test@liferay.com'@'localhost' (using password: YES)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
      	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
      	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
      	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
      	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
      	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
      	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
      	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
      	at sun.reflect.GeneratedConstructorAccessor33.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
      	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
      	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
      	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
      	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
      	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
      	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
      	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
      	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
      16:51:27,729 WARN  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#4][BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@e2794aa -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: 
      java.sql.SQLException: Access denied for user 'test@liferay.com'@'localhost' (using password: YES)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
      	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
      	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
      	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
      	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
      	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
      	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
      	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
      	at sun.reflect.GeneratedConstructorAccessor33.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
      	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
      	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
      	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
      	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
      	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
      	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
      	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
      	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
      16:51:27,729 WARN  [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0][BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@30524069 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: 
      java.sql.SQLException: Access denied for user 'test@liferay.com'@'localhost' (using password: YES)
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
      	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
      	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
      	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
      	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
      	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
      	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
      	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
      	at sun.reflect.GeneratedConstructorAccessor33.newInstance(Unknown Source)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
      	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
      	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
      	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
      	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1P