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

Fail to start bundle with portal-setup-wizard.properties

    Details

      Description

      Steps to Reproduce

      1. Add setup.wizard.enabled=true property in portat-ext.properties
      2. Start bundle with any database but not HSQL
      3. Change the database configuration, only need update the user name and password if you set the location of JDBC URL is validate
        1. Database Type: Hypersonic
        2. JDBC URL: jdbc:hsqldb:$ {liferay.home}/data/hypersonic/${database.hypersonic.schema}
          1. e.g.: jdbc:hsqldb:L:/Git/tomcat/7.0.x-private/7.0.x-private20180131/data/hypersonic/lportal
        3. JDBC Driver Class Name: org.hsqldb.jdbc.JDBCDriver
        4. User Name:sa
        5. Password:(blank)
      4. Finish Configuration
      5. Restart you bundle

      Expect Result
      Bundle can start with HSQL successfully, without any error on condole

      Actually result
      Fail to start the bundle with following console error.
      NOTE: After adding database.hypersonic.password=_into the auto generated _portal-setup-wizard.properties file, the bundle can satart as expected.

       2018-02-01 02:57:23.689 ERROR [localhost-startStop-1][DialectDetector:144] java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification
       java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification
       at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:327)
       at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:113)
       at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3618)
       at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:318)
       at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:260)
       at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
       at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
       at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:346)
       at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:196)
       at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:442)
       at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:505)
       at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)
       at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)
       at com.liferay.portal.spring.hibernate.DialectDetector.getDialect(DialectDetector.java:52)
       at com.liferay.portal.dao.jdbc.DataSourceFactoryImpl.initDataSource(DataSourceFactoryImpl.java:207)
       at com.liferay.portal.kernel.dao.jdbc.DataSourceFactoryUtil.initDataSource(DataSourceFactoryUtil.java:44)
       at com.liferay.portal.dao.jdbc.spring.DataSourceFactoryBean.createInstance(DataSourceFactoryBean.java:44)
       at com.liferay.portal.dao.jdbc.spring.DataSourceFactoryBean.createInstance(DataSourceFactoryBean.java:30)
       at org.springframework.beans.factory.config.AbstractFactoryBean.afterPropertiesSet(AbstractFactoryBean.java:134)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1631)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1568)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
       at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
       at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
       at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
       at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
       at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
       at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
       at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
       at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
       at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1475)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1220)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
       at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
       at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
       at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
       at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
       at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
       at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
       at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:762)
       at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
       at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
       at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
       at com.liferay.portal.spring.context.ArrayApplicationContext.<init>(ArrayApplicationContext.java:31)
       at com.liferay.portal.spring.context.PortalContextLoaderListener.contextInitialized(PortalContextLoaderListener.java:247)
       at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4812)
       at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5255)
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
       at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
       at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
       at java.util.concurrent.FutureTask.run(FutureTask.java:266)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
       at java.lang.Thread.run(Thread.java:745)
       Caused by: org.hsqldb.HsqlException: invalid authorization specification
       at org.hsqldb.error.Error.error(Error.java:136)
       at org.hsqldb.error.Error.error(Error.java:106)
       at org.hsqldb.rights.User.checkPassword(User.java:108)
       at org.hsqldb.rights.UserManager.getUser(UserManager.java:244)
       at org.hsqldb.Database.connect(Database.java:382)
       at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:158)
       at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3593)
       ... 74 more
       01-Feb-2018 02:57:23.692 SEVERE [localhost-startStop-1] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class com.liferay.portal.spring.context.PortalContextLoaderListener
       java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'counterSessionFactory' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot resolve reference to bean 'counterHibernateSessionFactory' while setting bean property 'sessionFactoryImplementor'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'counterHibernateSessionFactory' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot resolve reference to bean 'counterDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'counterDataSource' defined in class path resource [META-INF/counter-infrastructure-spring.xml]: Cannot resolve reference to bean 'counterDataSourceImpl' while setting bean property 'targetDataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'counterDataSourceImpl' defined in class path resource [META-INF/counter-infrastructure-spring.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: No dialect found
       at com.liferay.portal.spring.context.PortalContextLoaderListener.contextInitialized(PortalContextLoaderListener.java:262)
       at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4812)
       at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5255)
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
       at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
       at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
       at java.util.concurrent.FutureTask.run(FutureTask.java:266)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
       at java.lang.Thread.run(Thread.java:745)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sharry.shi Sharry Shi
                Reporter:
                sharry.shi Sharry Shi
                Participants of an Issue:
                Recent user:
                Csaba Turcsan
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 17 weeks, 6 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP48
                  7.0.0 DXP SP8
                  7.0.X
                  7.1.0 Alpha
                  7.1.X
                  Master