Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-1186

Installer 2.2.1 problem with Oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 2.2.1, 2.2.2
    • 2.2.1
    • grouperInstaller
    • None
    • Ubuntu 14.04, with ojdbc7.jar in the grouper.apiBinary-2.2.1/lib/custom directory

    Description

      imholzj@grouper-dev-app-v:/usr/local/grouper.install-2.2.1$ java -cp .:grouperInstaller.jar:/usr/local/grouper/grouper.apiBinary-2.2.1/lib/custom/ojdbc7.jar edu.internet2.middleware.grouperInstaller.GrouperInstaller
      Do you want to 'install' a new installation of grouper, 'upgrade' an existing installation,
      'patch' an existing installation, or 'createPatch' for Grouper developers
      (enter: 'install', 'upgrade', 'patch', 'createPatch' or blank for the default) [install]:
      Enter in the Grouper install directory (note: better if no spaces or special chars) [/usr/local/grouper.install-2.2.1]: /usr/local/grouper
      Enter the default IP address for checking ports (just hit enter to accept the default unless on a machine with no network, might want to change to 127.0.0.1): [0.0.0.0]:
      Installing grouper version: 2.2.1
      File exists: /usr/local/grouper/grouper.apiBinary-2.2.1.tar.gz, should we use the local file (t|f)? [t]:
      Unzipped file exists: /usr/local/grouper/grouper.apiBinary-2.2.1.tar, use unzipped file (t|f)? [t]:
      Untarred dir exists: /usr/local/grouper/grouper.apiBinary-2.2.1, use untarred dir (t|f)? [t]:
      Do you want to set gsh script to executable (t|f)? [t]: f

      ##################################

      Example mysql URL: jdbc:mysql://localhost:3306/grouper
      Example oracle URL: jdbc:oracle:thin:@server.school.edu:1521:sid
      Example hsqldb URL: jdbc:hsqldb:hsql://localhost:9001/grouper
      Example postgres URL: jdbc:postgresql://localhost:5432/database
      Example mssql URL: jdbc:sqlserver://localhost:3280;databaseName=grouper

      Enter the database URL [jdbc:oracle:thin:@grouper-oracle-v.mdc.musc.edu:1521:grpr]:
      Database user [grouper_v1_5]:
      Database password (note, you aren't setting the pass here, you are using an existing pass, this will be echoed back) [*****]:
      Editing /usr/local/grouper/grouper.apiBinary-2.2.1/conf/grouper.hibernate.properties:

      • property hibernate.connection.url already was set to: jdbc:oracle:thin:@grouper-oracle-v.mdc.musc.edu:1521:grpr, not changing file
      • property hibernate.connection.username already was set to: grouper_v1_5, not changing file
      • property hibernate.connection.password already was set to: ******, not changing file
        Checking database with query: select 1 from dual
        Aug 27, 2015 2:31:58 PM edu.internet2.middleware.grouperInstaller.util.GiDbUtils rollbackQuietly
        SEVERE: Problem rolling back
        java.sql.SQLException: Could not rollback with auto-commit set on
        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:4510)
        at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.rollbackQuietly(GiDbUtils.java:419)
        at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:403)
        at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:323)
        at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.select(GiDbUtils.java:334)
        at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.checkConnection(GiDbUtils.java:474)
        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.checkDatabaseConnection(GrouperInstaller.java:7292)
        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainInstallLogic(GrouperInstaller.java:5721)
        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.access$300(GrouperInstaller.java:77)
        at edu.internet2.middleware.grouperInstaller.GrouperInstaller$GrouperInstallerMainFunction$1.logic(GrouperInstaller.java:969)
        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainLogic(GrouperInstaller.java:1031)
        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.main(GrouperInstaller.java:302)

      Successfully tested database connection

                                    1. Checking patch grouper_v2_2_1_api_patch_0

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            imholzj John Imholz (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: