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

          Hide
          Manuel de la Peña added a comment -

          Hello Christine, can you type your enviroment configuration? You can see it at SQLServer Studio Main Menu -> Help -> About

          We have tested it on these enviroments:

          Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
          Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
          Microsoft MSXML 2.6 3.0 6.0
          Microsoft Internet Explorer 6.0.2900.2096
          Microsoft .NET Framework 2.0.50727.3053
          Operating System 5.1.2600 (WinXP)

          Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
          Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
          Microsoft MSXML 2.6 3.0 6.0
          Microsoft Internet Explorer 6.0.3790.1830
          Microsoft .NET Framework 2.0.50727.3053
          Sistema operativo 5.2.3790 (Win2003 R2)

          Thanks!

          Show
          Manuel de la Peña added a comment - Hello Christine, can you type your enviroment configuration? You can see it at SQLServer Studio Main Menu -> Help -> About We have tested it on these enviroments: Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ) Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 6.0.2900.2096 Microsoft .NET Framework 2.0.50727.3053 Operating System 5.1.2600 (WinXP) Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ) Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 6.0.3790.1830 Microsoft .NET Framework 2.0.50727.3053 Sistema operativo 5.2.3790 (Win2003 R2) Thanks!
          Hide
          Christine Pince (Inactive) added a comment -

          Hi Manuel,

          I'm using Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
          Mar 29 2009 10:27:29
          Copyright (c) 1988-2008 Microsoft Corporation
          Standard Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
          Operating System Microsoft Windows XP Professional Version 2002 SP3

          Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
                 Feb 9 2007 22:47:07
                 Copyright 1988-2005 Microsoft Corporation
                 Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

          Let me know if you have any more questions.

          Show
          Christine Pince (Inactive) added a comment - Hi Manuel, I'm using Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) Operating System Microsoft Windows XP Professional Version 2002 SP3 Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)        Feb 9 2007 22:47:07        Copyright 1988-2005 Microsoft Corporation        Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 3) Let me know if you have any more questions.
          Hide
          Christine Pince (Inactive) added a comment -

          Hi Manuel,

          I'm using Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
          Mar 29 2009 10:27:29
          Copyright (c) 1988-2008 Microsoft Corporation
          Standard Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
          Operating System Microsoft Windows XP Professional Version 2002 SP3

          Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
                 Feb 9 2007 22:47:07
                 Copyright 1988-2005 Microsoft Corporation
                 Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

          Let me know if you have any more questions.

          Show
          Christine Pince (Inactive) added a comment - Hi Manuel, I'm using Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) Operating System Microsoft Windows XP Professional Version 2002 SP3 Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)        Feb 9 2007 22:47:07        Copyright 1988-2005 Microsoft Corporation        Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 3) Let me know if you have any more questions.
          Hide
          Christine Pince (Inactive) added a comment -

          After the fix on 6.1.x GIT ID: 33b7a6a27a4dfa7aae7b2276eaed39f9cdbaff77.

          MySQL >> SQL Server 2008 : FAIL (perputual loading -no exception)
          SQL Server 2008 >> HSQL : FAIL (perputual loading -no exception)
          HSQL >> DB2 : FAIL (attached db2.txt)
          MySQL >> DB2 : FAIL (attahced db2-mysql.txt)

          MySQL >> Oracle : PASS
          MySQL >> PostgreSQL 8.4.2 : PASS
          HSQL >> Oracle : PASS
          HSQL >> PostgreSQL 8.4.2 : PASS
          HSQL >> MySQL : PASS

          PostgreSQL 8.4.2 >> MySQL : PASS
          SQL Server 2008 >> MySQL : PASS

          Show
          Christine Pince (Inactive) added a comment - After the fix on 6.1.x GIT ID: 33b7a6a27a4dfa7aae7b2276eaed39f9cdbaff77. MySQL >> SQL Server 2008 : FAIL (perputual loading -no exception) SQL Server 2008 >> HSQL : FAIL (perputual loading -no exception) HSQL >> DB2 : FAIL (attached db2.txt) MySQL >> DB2 : FAIL (attahced db2-mysql.txt) MySQL >> Oracle : PASS MySQL >> PostgreSQL 8.4.2 : PASS HSQL >> Oracle : PASS HSQL >> PostgreSQL 8.4.2 : PASS HSQL >> MySQL : PASS PostgreSQL 8.4.2 >> MySQL : PASS SQL Server 2008 >> MySQL : PASS
          Hide
          Christine Pince (Inactive) added a comment -

          PASSED Manual Testing following the steps in the description.

          MySQL >> DB2 : PASS
          MySQL >> Oracle : PASS
          MySQL >> PostgreSQL 8.4.2 : PASS
          MySQL >> SQL Server 2008 : PASS

          HSQL >> DB2 : PASS
          HSQL >> Oracle : PASS
          HSQL >> PostgreSQL 8.4.2 : PASS
          HSQL >> MySQL : PASS

          SQL Server 2008 >> HSQL : PASS
          PostgreSQL 8.4.2 >> MySQL : PASS
          SQL Server 2008 >> MySQL : PASS

          Fixed in:
          Tomcat 7.0 + HSQL. 6.1.x GIT ID: 939b0df90fae779383787020da1dfd1d15e790cb

          Show
          Christine Pince (Inactive) added a comment - PASSED Manual Testing following the steps in the description. MySQL >> DB2 : PASS MySQL >> Oracle : PASS MySQL >> PostgreSQL 8.4.2 : PASS MySQL >> SQL Server 2008 : PASS HSQL >> DB2 : PASS HSQL >> Oracle : PASS HSQL >> PostgreSQL 8.4.2 : PASS HSQL >> MySQL : PASS SQL Server 2008 >> HSQL : PASS PostgreSQL 8.4.2 >> MySQL : PASS SQL Server 2008 >> MySQL : PASS Fixed in: Tomcat 7.0 + HSQL. 6.1.x GIT ID: 939b0df90fae779383787020da1dfd1d15e790cb

            People

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

              Dates

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

                Development

                  Structure Helper Panel