Uploaded image for project: '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

      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]

        Attachments

        1. db2.PNG
          10 kB
          Christine Pince
        2. db2.txt
          35 kB
          Christine Pince
        3. db2-mysql.PNG
          8 kB
          Christine Pince
        4. db2-mysql.txt
          44 kB
          Christine Pince
        5. inactive.JPG
          22 kB
          Christine Pince
        6. loading.JPG
          87 kB
          Christine Pince
        7. setup wizard exception.txt
          39 kB
          Christine Pince
        8. startup wizard exception.txt
          13 kB
          Christine Pince

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  8 years, 41 weeks, 1 day ago

                  Packages

                  Version Package
                  6.1.0 CE GA1
                  --Sprint 11/12
                  6.2.0 CE M2