1. Marco Meoni
  2. PowerServer
  3. Tuesday, 22 February 2022 17:27 PM UTC

Hello,

PS 2021 and Oracle 12c.

Web APIs -> DB configuration results in ORA-01017, as simple as "invalid username/password; connection denied". Same parameters work from PB DB profile.

Technically, I have been provided with an Oracle proxy user (https://docs.oracle.com/database/121/ODPNT/featConnecting.htm#ODPNT188). As easy as it sounds, it may have some configuration difference that at the moment is unclear to me.

Have been through a variety of posts and questions trying to find an answer here, but so far I've had no luck. Most relevant thread: 

Oracle.ManagedDataAccess and ORA-01017: invalid username/password; logon denied

Provided that username contains some special chars but the error is stil there when they are prefixed by back quotes, I may go for the FIPS security policy suggestion.
However, changing HKLM registry settings on a server is not my ideal test and would like beforehand to know if anyone has same configuration or has experience with Oracle proxy and .NET.

Last but not least, PS 2021 project -> DB configuration -> Advanced  has indeed Security proxy user and proxy password entries, but no luck too.

Best,

.m

 

David Xiong @Appeon Accepted Answer Pending Moderation
  1. Thursday, 24 February 2022 09:50 AM UTC
  2. PowerServer
  3. # 1

Hi Marco,

PowerServer 2021 Project -> Web APIs -> DB Configuration does not support using a proxy user to connect to the Oracle database. I suggest that you open a new ticket on our support portal https://www.appeon.com/standardsupport/newbug so we can better track this problem. Currently, you will have to use a non-proxy user to connect to the Oracle database.

Regards,

David

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.