8 Replies Latest reply on Nov 3, 2015 1:21 AM by thomas.nemet

    how to enable password encryption when connecting DPA to Sybase DB?

    thomas.nemet

      Hi,

       

      i would like to know how one can set up password encryption during the first time "Register Instance Wizard" when you start DPA installation.

      The Sybase ASE Database requires encryption of the login password on the network.

       

      2015-10-26_15h21_40.png

       

      I´ve tried to set the JDBC connection property "ENCRYPT_PASSWORD=true" in the advanced connection properties window, but had no success.

       

      Does anybody had same expierence?

       

      regards,  Thomas.

        • Re: how to enable password encryption when connecting DPA to Sybase DB?
          gcp

          You might need to raise this with support given the lack of responses here unfortunately.

          It may also be worth looking through the DPA logs first to see if there are any other clues buried there (on the DPA server under iwc/tomcat/logs directory).

          • Re: how to enable password encryption when connecting DPA to Sybase DB?
            thomas.nemet

            The logs are only pointing to the fact that you need password encryption when you try to connect to a Sybase DB:

             

            Database connection failed: A connection to the database could not be established [cause=org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Adaptive Server requires encryption of the login password on the network.]

             

            Can´t imagine that i`m the only person that wants to monitor a Sybase DB with DPA. Isn´t there any property i could set up in "Regist instance wizard" to enable password encryption?

              • Re: how to enable password encryption when connecting DPA to Sybase DB?
                gcp

                thomas.nemet wrote:

                 

                Can´t imagine that i`m the only person that wants to monitor a Sybase DB with DPA. Isn´t there any property i could set up in "Regist instance wizard" to enable password encryption?

                 

                You really need to lodge a support ticket to get those answers.  They don't bite. Much.

                • Re: how to enable password encryption when connecting DPA to Sybase DB?
                  mandevil

                  Thomas - we'll need to see logs and potentially up the verbosity to get a better error stack. Just for fun, have you tried that parameter is the additional jdbc url properties field? I agree though, a support case for this would be the next step.

                    • Re: how to enable password encryption when connecting DPA to Sybase DB?
                      thomas.nemet

                      I´ve tried this JDBC_URL property:

                       

                      2015-11-02_10h24_41.png

                      Parameter as documented in: SyBooks Online

                      and here: SyBooks Online

                      and here: SyBooks Online

                       

                      But still not working.

                        • Re: how to enable password encryption when connecting DPA to Sybase DB?
                          thomas.nemet

                          LOG:

                           

                           

                           

                          INFO   (2015-11-02 10:33:48,057.MEZ) [http-8123-2] WizardFlowExecutionListener - Flow Action=TRANSITION EXECUTING;  Flow ID=register-mondb-flow;  Transition ID=error;  Target State=monDbConnectionInfo

                          INFO   (2015-11-02 10:33:58,620.MEZ) [http-8123-2] WizardFlowExecutionListener - Flow Action=TRANSITION EXECUTING;  Flow ID=register-mondb-flow;  Transition ID=next;  Target State=validateConnInfo

                          DEBUG  (2015-11-02 10:33:58,635.MEZ) [http-8123-2] DatabaseRegistrationServiceImpl - Validating database instance for monitoring [connProps=Connection Properties [databaseType=Sybase,source=Database,host=10.66.3.13,port=4901,databaseName=master,fullUserName=sapsso,domain=null,user=sapsso,overrideUrl=null,socketTimeout=300,jdbcDriverProperties [ENCRYPT_PASSWORD=TRUE], userValidationAttributes [[ADMIN_USER_AVAILABLE]]], user=sapsso]

                          DEBUG  (2015-11-02 10:33:58,635.MEZ) [http-8123-2] DatabaseRegistrationServiceImpl - Checking that a Repository has been created

                          DEBUG  (2015-11-02 10:33:58,635.MEZ) [http-8123-2] DatabaseRegistrationServiceImpl - Setting connection database to master [dbType=Sybase]

                          DEBUG  (2015-11-02 10:33:58,635.MEZ) [http-8123-2] DatabaseRegistrationServiceImpl - Creating datasource [Connection Properties [databaseType=Sybase,source=Database,host=10.66.3.13,port=4901,databaseName=master,fullUserName=sapsso,domain=null,user=sapsso,overrideUrl=null,socketTimeout=300,jdbcDriverProperties [ENCRYPT_PASSWORD=TRUE], userValidationAttributes [[ADMIN_USER_AVAILABLE]]]]

                          WARN   (2015-11-02 10:33:58,635.MEZ) [http-8123-2] DatabaseRegistrationServiceImpl - Database connection failed: A connection to the database could not be established [cause=org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Adaptive Server requires encryption of the login password on the network.

                          ]

                          Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Adaptive Server requires encryption of the login password on the network.

                           

                           

                          Connection Properties [databaseType=Sybase,source=Database,host=10.66.3.13,port=4901,databaseName=master,fullUserName=sapsso,domain=null,user=sapsso,overrideUrl=null,socketTimeout=300,jdbcDriverProperties [ENCRYPT_PASSWORD=TRUE], userValidationAttributes [[ADMIN_USER_AVAILABLE]]]

                          DEBUG  (2015-11-02 10:33:58,635.MEZ) [http-8123-2] DatabaseRegistrationServiceImpl - Connection to database failed [exception=com.confio.ignite.common.jdbc.exceptions.DatabaseConnectionException: A connection to the database could not be established [cause=org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Adaptive Server requires encryption of the login password on the network.

                          ]]

                          DEBUG  (2015-11-02 10:33:58,635.MEZ) [http-8123-2] DatabaseRegistrationServiceImpl - Closing datasource [Connection Properties [databaseType=Sybase,source=Database,host=10.66.3.13,port=4901,databaseName=master,fullUserName=sapsso,domain=null,user=sapsso,overrideUrl=null,socketTimeout=300,jdbcDriverProperties [ENCRYPT_PASSWORD=TRUE], userValidationAttributes [[ADMIN_USER_AVAILABLE]]]]

                          INFO   (2015-11-02 10:33:58,635.MEZ) [http-8123-2] RegisterMonDbAction - org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Adaptive Server requires encryption of the login password on the network.

                           

                           

                          INFO   (2015-11-02 10:34:00,651.MEZ) [http-8123-2] WizardFlowExecutionListener - Flow Action=TRANSITION EXECUTING;  Flow ID=register-mondb-flow;  Transition ID=error;  Target State=monDbConnectionInfo