PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-22971

Setup Wizard does not allow user to change database if different from portal-ext

    Details

    • Fix Priority:
      3
    • Similar Issues:
      Show 5 results 

      Description

      Setup Wizard does not allow user to change database if different from portal-ext. If a user wanted to configure Liferay to use a different database (eg. MySQL) than what was set in their portal-ext (eg. SQL Server), exceptions are thrown and Liferay instance becomes inactive.

      Steps to reproduce:

      1. Configure portal-ext with the following properties
        setup.wizard.enabled=true
        jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver
        jdbc.default.url=jdbc:jtds:sqlserver://localhost/lportal
        jdbc.default.username=sa
        jdbc.default.password=password
        
      2. Create 'lportal' database in SQL Server
      3. Create 'lportaltrunk' database in MySQL
      4. Start Liferay
      5. Assert that Liferay starts with lportal database in SQL Server
      6. Change the Database Type in the setup wizard to be MySQL
      7. Configure the JDBC URL to hit 'lportaltrunk' database
        jdbc:mysql://localhost/lportaltrunk?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
        com.mysql.jdbc.Driver
        
      8. Click the "Finish Configuration" button
        Page displays "This instance is inactive. Please contact the administrator." and exceptions are thrown in the console [attached]
      1. db2.txt
        35 kB
        Christine Pince
      2. db2-mysql.txt
        44 kB
        Christine Pince
      3. setup wizard exception.txt
        39 kB
        Christine Pince
      4. startup wizard exception.txt
        13 kB
        Christine Pince
      1. db2.PNG
        10 kB
      2. db2-mysql.PNG
        8 kB
      3. inactive.JPG
        22 kB
      4. loading.JPG
        87 kB

        Issue Links

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 32 weeks, 2 days ago

                Development

                  Structure Helper Panel