Facing NoRespositoryAvailablePage issue while trying to setup MYSQL in dev environment of v12.6.9 Archetype Project

Experience Manager (PaaS/OnPrem)
1

Hi All,

Trying to setup mysql in development environment of archetype v12.6.9 peoject. We are getting NoRepositoryAvailablePage exception when trying to access the CMS from the browser.
PFB more details.

I have followed the steps which are mentioned in below link.

Use MySQL in a Development Environment - Bloomreach Experience - Open Source CMS

Please let me know, if I am missing any.

Log details:

[WARNING] [talledLocalContainer] 03-Dec-2020 19:30:46.364 WARNING [localhost-startStop-1] org.apache.catalina.core.NamingContextListener.addResource Fai
led to register in JMX: [javax.naming.NamingException: Unexpected exception resolving reference [Root exception is java.sql.SQLException: Cannot create
PoolableConnectionFactory (Access denied for user ‘hippo’@‘localhost’ (using password: YES))]]
[INFO] [talledLocalContainer] 03-Dec-2020 19:30:46.384 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of
web application directory [C:\Workspace\Vanilla\V12.6.9\myhippoproject\target\tomcat8x\webapps\host-manager] has finished in [346] ms
[INFO] [talledLocalContainer] 03-Dec-2020 19:30:46.384 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web
application directory [C:\Workspace\Vanilla\V12.6.9\myhippoproject\target\tomcat8x\webapps\manager]
[WARNING] [talledLocalContainer] 03-Dec-2020 19:30:46.742 WARNING [localhost-startStop-1] org.apache.naming.NamingContext.lookup Unexpected exception re
solving reference
[INFO] [talledLocalContainer] java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user ‘hippo’@‘localhost’ (using passwor
d: YES))

Steps which i have performed.

  1. Added below chunk in conf/Context.xml
    Resource
    name=“jdbc/repositoryDS” auth=“Container” type=“javax.sql.DataSource”
    maxTotal=“20” maxIdle=“10” initialSize=“2” maxWaitMillis=“10000”
    testWhileIdle=“true” testOnBorrow=“false” validationQuery=“SELECT 1”
    timeBetweenEvictionRunsMillis=“10000”
    minEvictableIdleTimeMillis=“60000”
    username=“hippo” password=“hippo”
    driverClassName=“com.mysql.jdbc.Driver”
    url=“jdbc:mysql://localhost:3306/localjcrdb?characterEncoding=utf8”

  2. Copied Repository.xml from above link.

  3. Modified root pom.xml as mentioned in the link.
    3.1. Added below dependency after dependencymanagement in root pom.xml
    dependencies
    dependency
    mysql
    mysql-connector-java
    5.1.44
    provided
    dependency
    dependencies
    3.2 Added <repo.config> in systemproperties of the cargo.run profile
    3.3 Added below dependency after systemproperties .
    dependencies
    dependency
    mysql
    mysql-connector-java
    extra
    dependency
    dependencies

Thanks and Regards,
Yeshwanth Lagala.

2

Access denied for user ‘hippo’@‘localhost’ (using password: YES))

see for example: