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

    • Fix Priority:
      3

      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
          db2.PNG
          10 kB
        2. db2.txt
          35 kB
        3. db2-mysql.PNG
          db2-mysql.PNG
          8 kB
        4. db2-mysql.txt
          44 kB
        5. inactive.JPG
          inactive.JPG
          22 kB
        6. loading.JPG
          loading.JPG
          87 kB
        7. setup wizard exception.txt
          39 kB
        8. startup wizard exception.txt
          13 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:
                  5 years, 44 weeks, 4 days ago