This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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

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.

  • 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).

  • 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?

  • 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. emoticons_wink.png

  • 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.

  • 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.

  • 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

  • Did you try in connection properties also?  Shouldn't matter.

    I strongly encourage you to submit a ticket with support at this point as this will likely need to go to engineering.

  • Sure i did, but it makes no difference.

    I contacted support and it turns out that encryption is not implemented yet! But it is planned for future updates.

    Thank you guys anyway for helping out.

    Regards, Thomas.