When I run my app it tries to make changes to my keychain #315

dmytro-i · 2023-09-28T13:23:24Z

dmytro-i
Sep 28, 2023

My connection string looks like this:
string connectionString = "User Id=username;password=secretPass;Data Source=(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=redacted.oraclecloud.com))(connect_data=(service_name=redacted.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))";

Then I add Oracle connection like so:
services.AddOracle<CryptoasterDataContext>(conString);

If I run the app I see a pop-up saying that my app wants to make changes to the keychain on my Mac and I don't want that.

I have ADB for transaction processing and was able to connect with a wallet.

mTLS is not required for this ADB.

Answered by alexkeh

Oct 2, 2023

The Oracle .NET team has reproduced this error on macOS. It appears to affect newer macOS versions only from our observations. We have created bug 35865628 to track this issue.

View full answer

alexkeh · 2023-09-28T17:03:40Z

alexkeh
Sep 28, 2023
Maintainer

There should be a way to disable this pop up messages on the macOS configuration. I'm not that familiar with the OS and how to disable it myself.

0 replies

alexkeh · 2023-09-28T17:38:08Z

alexkeh
Sep 28, 2023
Maintainer

BTW, if you are not using the client side wallet at all, you shouldn't see this pop up message unless you are using OAuth or some other token-based authentication. If you are not using token auth, is CryptoasterDataContext doing something app specific to trigger the pop up?

0 replies

dmytro-i · 2023-09-28T18:13:00Z

dmytro-i
Sep 28, 2023
Author

I'm not using OAuth and don't have anything special in the context initialization code. This pop-up actually masked the real problem.
I found ORA-00542: Failure during SSL handshake in the stacktrace. It may be related to #148
But I don't understand why it works with the wallet. It also works with JDBC connection.

0 replies

alexkeh · 2023-09-28T18:42:03Z

alexkeh
Sep 28, 2023
Maintainer

It's hard to diagnose an ORA-00542 without a trace. Can you turn on ODP.NET tracing and share the trace?

Add the following two lines of code (and set the output directory) prior to opening the connection:

OracleConfiguration.TraceFileLocation = @"C:\traces";
OracleConfiguration.TraceLevel = 7;

0 replies

dmytro-i · 2023-09-28T18:44:28Z

dmytro-i
Sep 28, 2023
Author

       ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
       ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
       ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
       ---> Interop+AppleCrypto+SslException: unknown Cert Authority

Is at the bottom of the stacktrace. It appears when I let it access the keychain.

0 replies

dmytro-i · 2023-09-28T18:56:41Z

dmytro-i
Sep 28, 2023
Author

2023-09-28 20:49:37.223536 TID:7   (CFG) (ENV)      Machine Name : [redacted]
2023-09-28 20:49:37.223653 TID:7   (CFG) (ENV)      User Name : [redacted]
2023-09-28 20:49:37.223685 TID:7   (CFG) (ENV)      OS Version : Unix 13.5.2
2023-09-28 20:49:37.223697 TID:7   (CFG) (ENV)      64-bit OS : True
2023-09-28 20:49:37.223705 TID:7   (CFG) (ENV)      64-bit Process : True
2023-09-28 20:49:37.223729 TID:7   (CFG) (ENV)      .NET Core Runtime Version : 7.0.2
2023-09-28 20:49:37.223735 TID:7   (CFG) (ENV)      Application Directory : /Users/[redacted]/dev/[redacted]/cryptobot-2.0/src/Cryptoaster.App/bin/Debug/net7.0
2023-09-28 20:49:37.223746 TID:7   (CFG) (VER)      Oracle Data Provider for .NET Core Driver Version : 3.1.21.1
2023-09-28 20:49:37.226814 TID:7   (CFG) (VER)      Oracle Data Provider for .NET Core Driver Informational Version : 3.1.21.1:20230701
2023-09-28 20:49:37.227539 TID:7   (CFG) (SQLNET)   FilePath : (null)
2023-09-28 20:49:37.227553 TID:7   (CFG) (TNSNAMES) FilePath : (null)
2023-09-28 20:49:37.228860 TID:7   (CFG) (OCFG)     OracleConfiguration.DumpInfo()  TraceFileLocation : /Users/[redacted]/traces
 TraceLevel : 7

2023-09-28 20:49:37.221596 TID:7   (PUB) (ENT) OracleConnection.Open() (conid=14017677) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a) 
2023-09-28 20:49:37.229967 TID:7   (PRI) (ENT) (CP) OracleConnectionDispenser..cctor()
2023-09-28 20:49:37.230289 TID:7   (PRI) (EXT) (CP) OracleConnectionDispenser..cctor()
2023-09-28 20:49:37.230308 TID:7   (PRI) (ENT) (CP) OracleConnectionDispenser.Get()
2023-09-28 20:49:37.231867 TID:7   (PRI) (ENT) (CP) PoolManager.ctor()
2023-09-28 20:49:37.232286 TID:7   (PRI) (EXT) (CP) PoolManager.ctor()
2023-09-28 20:49:37.233001 TID:7   (PRI) (ENT) (CP) PoolManager.Initialize() (constr=User Id=CRYPTOASTER;password=;Data Source=(description=(address=(protocol=tcps)(port=1521)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes))))
2023-09-28 20:49:37.233059 TID:7   (PRI) (CP) PoolManager.ctor() (dedicated.thread.function=DedicatedThreadFunc)(threadID=16)
2023-09-28 20:49:37.233196 TID:7   (PRI) (EXT) (CP) PoolManager.Initialize() (pmid=21413001) (constr=User Id=CRYPTOASTER;password=;Data Source=(description=(address=(protocol=tcps)(port=1521)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes))))
2023-09-28 20:49:37.233484 TID:16  (PRI) (ENT) (CP) PoolManager.DedicatedThreadFunc()
2023-09-28 20:49:37.233497 TID:16  (PRI) (CP) PoolManager.DedicatedThreadFunc() Entering dedicated.thread.while.loop
2023-09-28 20:49:37.238833 TID:7   (PRI) (BUF) (OBP.CTOR) (poolid:35540417) (OracleConnectionDispenser`3.GetPM)
2023-09-28 20:49:37.239779 TID:7   (PRI) (ENT) (CP) OraclePoolManager.Get()
2023-09-28 20:49:37.244870 TID:7   (PRI) (ENT) (CP) PoolManager.Get() (txnid=n/a) (bForceMatch=F)
2023-09-28 20:49:37.244911 TID:7   (PRI) (ENT) (CP) PoolManager.Get() MultiTenant : Searching for a idle connection, retryCountWithoutAffinity: 0 (pm.get.loop.count=0)
2023-09-28 20:49:37.244969 TID:7   (PRI) (ENT) (CP) PoolManager.Get() WaitHandle.WaitAny(m_IdleAndMaxHandles) : (bIdleSemObtained=False) (bMaxSemObtained=False) (bIncrSemObtained=False) (m_pmListPR.Count=0)
2023-09-28 20:49:37.245018 TID:7   (PRI) (EXT) (CP) PoolManager.Get() WaitHandle.WaitAny(m_IdleAndMaxHandles) : (hIndex = 1) (max semaphore) : (bIdleSemObtained=False) (bMaxSemObtained=True) (bIncrSemObtained=False) (m_pmListPR.Count=0)
2023-09-28 20:49:37.245106 TID:7   (PRI) (ENT) PoolManager.ProcessCriteriaCtx_NonEnlistedConnection()
2023-09-28 20:49:37.245116 TID:7   (PRI) (EXT) PoolManager.ProcessCriteriaCtx_NonEnlistedConnection()
2023-09-28 20:49:37.245123 TID:7   (PRI) (ENT) (CP) PoolManager.Get() WaitOne(m_semIncrPoolSize) : (bIdleSemObtained=False) (bMaxSemObtained=True) (bIncrSemObtained=False) (m_pmListPR.Count=0)
2023-09-28 20:49:37.245129 TID:7   (PRI) (EXT) (CP) PoolManager.Get() WaitOne(m_semIncrPoolSize) : (bIdleSemObtained=False) (bMaxSemObtained=True) (bIncrSemObtained=True) (m_pmListPR.Count=0)
2023-09-28 20:49:37.246278 TID:7   (PRI) (ENT) (CP) PoolManager.CreateNewPR() (txnid=n/a) 
2023-09-28 20:49:37.246845 TID:7   (PRI) (ENT) (CP) PoolManager.CreateNewPR() Connecting with session time zone as the Region name
2023-09-28 20:49:37.246976 TID:7   (PRI) (ENT) (CP) PoolManager.CreateConsUsingDedicatedThread()
2023-09-28 20:49:37.246999 TID:7   (PRI) (EXT) (CP) PoolManager.CreateConsUsingDedicatedThread()
2023-09-28 20:49:37.247013 TID:7   (PRI) (CP) PoolManager.CreateNewPR() Waiting for idle connection to be available or new connection to be created
2023-09-28 20:49:37.247443 TID:16  (PRI) (ENT) (CP) PoolManager.CreateNewPRThreadFunc()
2023-09-28 20:49:37.247461 TID:16  (PRI) (ENT) (CP) PoolManager.CreateNewPRThreadFunc() (initiated by TID:7)
2023-09-28 20:49:37.250510 TID:16  (PRI) (SVC) (ENT) OracleConnectionImpl.get_ServiceName() (CONNECTION_OPTION:SERVICE_NAME=) (ISNULL=FALSE)
2023-09-28 20:49:37.250684 TID:16  (PRI) (SVC) (ENT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (pr.service=) (pr.pdb=) (pr.edition=) (sessid=-1:-1) (F;F;F;;N) (pmid=21413001) 
2023-09-28 20:49:37.251247 TID:16  (PRI) (BUF) (COBP.CTOR) (poolid:1) (parentpoolid:35540417) (OracleConnectionImpl.Connect)
2023-09-28 20:49:37.252659 TID:16  (PRI) (.NET) (tnsnames.ora) Searching for '/Users/[redacted]/dev/[redacted]/cryptobot-2.0/src/Cryptoaster.App/bin/Debug/net7.0/./tnsnames.ora' : not found
2023-09-28 20:49:37.252742 TID:16  (PRI) (.NET) (tnsnames.ora) Searching for '/Users/[redacted]/dev/[redacted]/cryptobot-2.0/src/Cryptoaster.App/bin/Debug/net7.0/tnsnames.ora' : not found
2023-09-28 20:49:37.252753 TID:16  (CFG) (SQLNET)   FilePath : (null)
2023-09-28 20:49:37.252757 TID:16  (CFG) (TNSNAMES) FilePath : (null)
2023-09-28 20:49:37.307128 TID:16  (NET)      Using host: 138.1.3.227 and hostname: adb.eu-frankfurt-1.oraclecloud.com
2023-09-28 20:49:37.308619 TID:16  (NET) (ENT) TcpsTransportAdapter.Connect()
2023-09-28 20:49:37.308819 TID:16  (NET) (ENT) TcpTransportAdapter.Connect()
2023-09-28 20:49:37.308905 TID:16  (NET)      Trying (host=138.1.3.227) (port=1521)
2023-09-28 20:49:37.308912 TID:16  (NET) (EXT) TcpTransportAdapter.Connect()
2023-09-28 20:49:37.308916 TID:16  (NET) (EXT) TcpsTransportAdapter.Connect()
2023-09-28 20:49:37.308965 TID:16  (NET) (ENT) TcpsTransportAdapter.ConnectIterate()
2023-09-28 20:49:37.309548 TID:16  (NET) (ENT) TcpTransportAdapter.ConnectIterate()
2023-09-28 20:49:37.309589 TID:16  (NET)      Trying (address=138.1.3.227) (port=1521)
2023-09-28 20:49:37.350500 TID:16  (NET) (ENT) TcpsTransportAdapter.Negotiate()
2023-09-28 20:49:37.350629 TID:16  (NET) (SQLNET) SSLVersion = 0. SSLProtocol = Tls, Tls11, Tls12, Tls13.
2023-09-28 20:49:40.016052 TID:16  (NET) (ENT) TcpsTransportAdapter.ConnectIterate()
2023-09-28 20:49:40.016333 TID:16  (NET) (ENT) TcpTransportAdapter.ConnectIterate()
2023-09-28 20:49:40.016338 TID:16  (NET) (EXT) TcpsTransportAdapter.ConnectIterate()
2023-09-28 20:49:40.016922 TID:16  (PRI) (ENT) OracleConnectionImpl.Connect()
2023-09-28 20:49:40.017022 TID:16  (PRI) (ENT) OracleException.ctor()
2023-09-28 20:49:40.017171 TID:16  (PRI) (ENT) OracleError.ctor()
2023-09-28 20:49:40.017303 TID:16  (PRI) (EXT) OracleError.ctor()
2023-09-28 20:49:40.017312 TID:16  (PRI) (EXT) OracleException.ctor()
2023-09-28 20:49:40.020255 TID:16  (PRI) (SVC) (ERR) OracleConnectionImpl.Connect() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: Internal error
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
2023-09-28 20:49:40.020294 TID:16  (PRI) (EXT) OracleConnectionImpl.Connect()
2023-09-28 20:49:40.020343 TID:16  (PRI) (SVC) (ENT) OracleConnectionImpl.get_ServiceName() (CONNECTION_OPTION:SERVICE_NAME=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com) (ISNULL=FALSE)
2023-09-28 20:49:40.020354 TID:16  (PRI) (SVC) (EXT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (pr.service=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com) (pr.pdb=) (pr.edition=) (sessid=-1:-1) (F;F;F;;N) (pmid=21413001) 
2023-09-28 20:49:40.020385 TID:16  (PRI) (CP) PoolManager.CreateNewPRThreadFunc() [MAX:REL:18] PM.CreateNewPRThreadFunc() : Max Sempahore count=99
2023-09-28 20:49:40.020403 TID:7   (PRI) (CP) PoolManager.CreateNewPR() New connection is available
2023-09-28 20:49:40.020430 TID:16  (PRI) (EXT) (CP) PoolManager.CreateNewPRThreadFunc()
2023-09-28 20:49:40.020436 TID:16  (PRI) (EXT) (CP) PoolManager.DedicatedThreadFunc() Ending dedicated thread.
2023-09-28 20:49:40.020576 TID:7   (PRI) (ENT) PoolManager.CreateNewPR()
2023-09-28 20:49:40.020721 TID:7   (PRI) (ERR) (CP) PoolManager.CreateNewPR() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: Internal error
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
   at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, OracleConnection connRefForCriteria, Boolean bMaxSemObtained, Boolean bIgnoreIdleSem, Boolean& bIdleSemObtainedWhileCreatingPR, String instanceName, List`1 switchFailedInstNames)
2023-09-28 20:49:40.020731 TID:7   (PRI) (EXT) PoolManager.CreateNewPR()
2023-09-28 20:49:40.020816 TID:7   (PRI) (SVC) (ENT) OracleConnectionImpl.get_ServiceName() (CONNECTION_OPTION:SERVICE_NAME=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com) (ISNULL=FALSE)
2023-09-28 20:49:40.020826 TID:7   (PRI) (EXT) (CP) PoolManager.CreateNewPR() (aff=n/a) (inst=) (affmatch=n/a) (pr.service=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com) (pr.pdb=) (pr.edition=) (sessid=-1:-1) (F;F;F;;N) (pmid=21413001) 
2023-09-28 20:49:40.020849 TID:7   (PRI) (CP) PoolManager.Put() [INCR:REL:11] PM.Put() : Incr Sempahore count=4
2023-09-28 20:49:40.020886 TID:7   (PRI) (EXT) (CP) PoolManager.Get() (txnid=n/a) PM.Get(aff=;force=F) returning (null)
2023-09-28 20:49:40.020905 TID:7   (PRI) (ENT) OraclePoolManager.Get()
2023-09-28 20:49:40.021063 TID:7   (PRI) (ERR) (CP) OraclePoolManager.Get() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: Internal error
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
2023-09-28 20:49:40.021070 TID:7   (PRI) (EXT) OraclePoolManager.Get()
2023-09-28 20:49:40.021106 TID:7   (PRI) (EXT) (CP) OraclePoolManager.Get() (txnid=n/a) 
2023-09-28 20:49:40.021647 TID:7   (PRI) (ENT) OracleConnectionDispenser.Get()
2023-09-28 20:49:40.021759 TID:7   (PRI) (ERR) (CP) OracleConnectionDispenser.Get() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: Internal error
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
2023-09-28 20:49:40.021776 TID:7   (PRI) (EXT) OracleConnectionDispenser.Get()
2023-09-28 20:49:40.021819 TID:7   (PRI) (EXT) (CP) OracleConnectionDispenser.Get() (txnid=n/a) 
2023-09-28 20:49:40.021838 TID:7   (PRI) (ENT) OracleConnection.Open()
2023-09-28 20:49:40.023329 TID:7   (PUB) (ERR) OracleConnection.Open() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: Internal error
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
2023-09-28 20:49:40.023578 TID:7   (PRI) (EXT) OracleConnection.Open()
2023-09-28 20:49:40.023646 TID:7   (PUB) (EXT) OracleConnection.Open() (conid=14017677) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a) 
2023-09-28 20:49:40.036689 TID:7   (PUB) (ENT) OracleConnection.Close() (conid=14017677) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a) 
2023-09-28 20:49:40.036748 TID:7   (PUB) (EXT) OracleConnection.Close() (conid=14017677) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a) 
2023-09-28 20:49:40.038301 TID:7   (PUB) (ENT) OracleConnection.Dispose()
2023-09-28 20:49:40.038344 TID:7   (PUB) (EXT) OracleConnection.Dispose()

0 replies

dmytro-i · 2023-09-28T18:57:30Z

dmytro-i
Sep 28, 2023
Author

This is when I let it use keychain

2023-09-28 20:50:42.395698 TID:14  (CFG) (ENV)      Machine Name : [redacted]
2023-09-28 20:50:42.395795 TID:14  (CFG) (ENV)      User Name : [redacted]
2023-09-28 20:50:42.395825 TID:14  (CFG) (ENV)      OS Version : Unix 13.5.2
2023-09-28 20:50:42.395838 TID:14  (CFG) (ENV)      64-bit OS : True
2023-09-28 20:50:42.395846 TID:14  (CFG) (ENV)      64-bit Process : True
2023-09-28 20:50:42.395874 TID:14  (CFG) (ENV)      .NET Core Runtime Version : 7.0.2
2023-09-28 20:50:42.395880 TID:14  (CFG) (ENV)      Application Directory : /Users/[redacted]/dev/[redacted]/cryptobot-2.0/src/Cryptoaster.App/bin/Debug/net7.0
2023-09-28 20:50:42.395889 TID:14  (CFG) (VER)      Oracle Data Provider for .NET Core Driver Version : 3.1.21.1
2023-09-28 20:50:42.398926 TID:14  (CFG) (VER)      Oracle Data Provider for .NET Core Driver Informational Version : 3.1.21.1:20230701
2023-09-28 20:50:42.399705 TID:14  (CFG) (SQLNET)   FilePath : (null)
2023-09-28 20:50:42.399715 TID:14  (CFG) (TNSNAMES) FilePath : (null)
2023-09-28 20:50:42.401076 TID:14  (CFG) (OCFG)     OracleConfiguration.DumpInfo()  TraceFileLocation : /Users/[redacted]/traces
 TraceLevel : 7

2023-09-28 20:50:42.394141 TID:14  (PUB) (ENT) OracleConnection.Open() (conid=52648047) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a) 
2023-09-28 20:50:42.402165 TID:14  (PRI) (ENT) (CP) OracleConnectionDispenser..cctor()
2023-09-28 20:50:42.402402 TID:14  (PRI) (EXT) (CP) OracleConnectionDispenser..cctor()
2023-09-28 20:50:42.402411 TID:14  (PRI) (ENT) (CP) OracleConnectionDispenser.Get()
2023-09-28 20:50:42.403701 TID:14  (PRI) (ENT) (CP) PoolManager.ctor()
2023-09-28 20:50:42.404100 TID:14  (PRI) (EXT) (CP) PoolManager.ctor()
2023-09-28 20:50:42.404775 TID:14  (PRI) (ENT) (CP) PoolManager.Initialize() (constr=User Id=CRYPTOASTER;password=;Data Source=(description=(address=(protocol=tcps)(port=1521)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes))))
2023-09-28 20:50:42.404832 TID:14  (PRI) (CP) PoolManager.ctor() (dedicated.thread.function=DedicatedThreadFunc)(threadID=16)
2023-09-28 20:50:42.404985 TID:14  (PRI) (EXT) (CP) PoolManager.Initialize() (pmid=9759436) (constr=User Id=CRYPTOASTER;password=;Data Source=(description=(address=(protocol=tcps)(port=1521)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes))))
2023-09-28 20:50:42.405239 TID:16  (PRI) (ENT) (CP) PoolManager.DedicatedThreadFunc()
2023-09-28 20:50:42.405249 TID:16  (PRI) (CP) PoolManager.DedicatedThreadFunc() Entering dedicated.thread.while.loop
2023-09-28 20:50:42.410396 TID:14  (PRI) (BUF) (OBP.CTOR) (poolid:58454706) (OracleConnectionDispenser`3.GetPM)
2023-09-28 20:50:42.411282 TID:14  (PRI) (ENT) (CP) OraclePoolManager.Get()
2023-09-28 20:50:42.416179 TID:14  (PRI) (ENT) (CP) PoolManager.Get() (txnid=n/a) (bForceMatch=F)
2023-09-28 20:50:42.416211 TID:14  (PRI) (ENT) (CP) PoolManager.Get() MultiTenant : Searching for a idle connection, retryCountWithoutAffinity: 0 (pm.get.loop.count=0)
2023-09-28 20:50:42.416255 TID:14  (PRI) (ENT) (CP) PoolManager.Get() WaitHandle.WaitAny(m_IdleAndMaxHandles) : (bIdleSemObtained=False) (bMaxSemObtained=False) (bIncrSemObtained=False) (m_pmListPR.Count=0)
2023-09-28 20:50:42.416297 TID:14  (PRI) (EXT) (CP) PoolManager.Get() WaitHandle.WaitAny(m_IdleAndMaxHandles) : (hIndex = 1) (max semaphore) : (bIdleSemObtained=False) (bMaxSemObtained=True) (bIncrSemObtained=False) (m_pmListPR.Count=0)
2023-09-28 20:50:42.416383 TID:14  (PRI) (ENT) PoolManager.ProcessCriteriaCtx_NonEnlistedConnection()
2023-09-28 20:50:42.416392 TID:14  (PRI) (EXT) PoolManager.ProcessCriteriaCtx_NonEnlistedConnection()
2023-09-28 20:50:42.416397 TID:14  (PRI) (ENT) (CP) PoolManager.Get() WaitOne(m_semIncrPoolSize) : (bIdleSemObtained=False) (bMaxSemObtained=True) (bIncrSemObtained=False) (m_pmListPR.Count=0)
2023-09-28 20:50:42.416404 TID:14  (PRI) (EXT) (CP) PoolManager.Get() WaitOne(m_semIncrPoolSize) : (bIdleSemObtained=False) (bMaxSemObtained=True) (bIncrSemObtained=True) (m_pmListPR.Count=0)
2023-09-28 20:50:42.417560 TID:14  (PRI) (ENT) (CP) PoolManager.CreateNewPR() (txnid=n/a) 
2023-09-28 20:50:42.418080 TID:14  (PRI) (ENT) (CP) PoolManager.CreateNewPR() Connecting with session time zone as the Region name
2023-09-28 20:50:42.418157 TID:14  (PRI) (ENT) (CP) PoolManager.CreateConsUsingDedicatedThread()
2023-09-28 20:50:42.418171 TID:14  (PRI) (EXT) (CP) PoolManager.CreateConsUsingDedicatedThread()
2023-09-28 20:50:42.418176 TID:14  (PRI) (CP) PoolManager.CreateNewPR() Waiting for idle connection to be available or new connection to be created
2023-09-28 20:50:42.418545 TID:16  (PRI) (ENT) (CP) PoolManager.CreateNewPRThreadFunc()
2023-09-28 20:50:42.418583 TID:16  (PRI) (ENT) (CP) PoolManager.CreateNewPRThreadFunc() (initiated by TID:14)
2023-09-28 20:50:42.421770 TID:16  (PRI) (SVC) (ENT) OracleConnectionImpl.get_ServiceName() (CONNECTION_OPTION:SERVICE_NAME=) (ISNULL=FALSE)
2023-09-28 20:50:42.421960 TID:16  (PRI) (SVC) (ENT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (pr.service=) (pr.pdb=) (pr.edition=) (sessid=-1:-1) (F;F;F;;N) (pmid=9759436) 
2023-09-28 20:50:42.422590 TID:16  (PRI) (BUF) (COBP.CTOR) (poolid:1) (parentpoolid:58454706) (OracleConnectionImpl.Connect)
2023-09-28 20:50:42.424244 TID:16  (PRI) (.NET) (tnsnames.ora) Searching for '/Users/[redacted]/dev/[redacted]/cryptobot-2.0/src/Cryptoaster.App/bin/Debug/net7.0/./tnsnames.ora' : not found
2023-09-28 20:50:42.424321 TID:16  (PRI) (.NET) (tnsnames.ora) Searching for '/Users/[redacted]/dev/[redacted]/cryptobot-2.0/src/Cryptoaster.App/bin/Debug/net7.0/tnsnames.ora' : not found
2023-09-28 20:50:42.424331 TID:16  (CFG) (SQLNET)   FilePath : (null)
2023-09-28 20:50:42.424337 TID:16  (CFG) (TNSNAMES) FilePath : (null)
2023-09-28 20:50:42.477727 TID:16  (NET)      Using host: 138.1.3.227 and hostname: adb.eu-frankfurt-1.oraclecloud.com
2023-09-28 20:50:42.479227 TID:16  (NET) (ENT) TcpsTransportAdapter.Connect()
2023-09-28 20:50:42.479419 TID:16  (NET) (ENT) TcpTransportAdapter.Connect()
2023-09-28 20:50:42.479498 TID:16  (NET)      Trying (host=138.1.3.227) (port=1521)
2023-09-28 20:50:42.479504 TID:16  (NET) (EXT) TcpTransportAdapter.Connect()
2023-09-28 20:50:42.479508 TID:16  (NET) (EXT) TcpsTransportAdapter.Connect()
2023-09-28 20:50:42.479554 TID:16  (NET) (ENT) TcpsTransportAdapter.ConnectIterate()
2023-09-28 20:50:42.480154 TID:16  (NET) (ENT) TcpTransportAdapter.ConnectIterate()
2023-09-28 20:50:42.480193 TID:16  (NET)      Trying (address=138.1.3.227) (port=1521)
2023-09-28 20:50:42.528320 TID:16  (NET) (ENT) TcpsTransportAdapter.Negotiate()
2023-09-28 20:50:42.528427 TID:16  (NET) (SQLNET) SSLVersion = 0. SSLProtocol = Tls, Tls11, Tls12, Tls13.
2023-09-28 20:50:51.532719 TID:16  (NET) (ENT) TcpsTransportAdapter.ConnectIterate()
2023-09-28 20:50:51.532974 TID:16  (NET) (ENT) TcpTransportAdapter.ConnectIterate()
2023-09-28 20:50:51.532981 TID:16  (NET) (EXT) TcpsTransportAdapter.ConnectIterate()
2023-09-28 20:50:51.533619 TID:16  (PRI) (ENT) OracleConnectionImpl.Connect()
2023-09-28 20:50:51.533740 TID:16  (PRI) (ENT) OracleException.ctor()
2023-09-28 20:50:51.533873 TID:16  (PRI) (ENT) OracleError.ctor()
2023-09-28 20:50:51.534008 TID:16  (PRI) (EXT) OracleError.ctor()
2023-09-28 20:50:51.534016 TID:16  (PRI) (EXT) OracleException.ctor()
2023-09-28 20:50:51.536759 TID:16  (PRI) (SVC) (ERR) OracleConnectionImpl.Connect() (txnid=n/a) OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: unknown Cert Authority
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
2023-09-28 20:50:51.536789 TID:16  (PRI) (EXT) OracleConnectionImpl.Connect()
2023-09-28 20:50:51.536823 TID:16  (PRI) (SVC) (ENT) OracleConnectionImpl.get_ServiceName() (CONNECTION_OPTION:SERVICE_NAME=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com) (ISNULL=FALSE)
2023-09-28 20:50:51.536833 TID:16  (PRI) (SVC) (EXT) OracleConnectionImpl.Connect() (oper=open) (aff=n/a) (inst=) (affmatch=n/a) (pr.service=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com) (pr.pdb=) (pr.edition=) (sessid=-1:-1) (F;F;F;;N) (pmid=9759436) 
2023-09-28 20:50:51.536865 TID:16  (PRI) (CP) PoolManager.CreateNewPRThreadFunc() [MAX:REL:18] PM.CreateNewPRThreadFunc() : Max Sempahore count=99
2023-09-28 20:50:51.536881 TID:14  (PRI) (CP) PoolManager.CreateNewPR() New connection is available
2023-09-28 20:50:51.536905 TID:16  (PRI) (EXT) (CP) PoolManager.CreateNewPRThreadFunc()
2023-09-28 20:50:51.536911 TID:16  (PRI) (EXT) (CP) PoolManager.DedicatedThreadFunc() Ending dedicated thread.
2023-09-28 20:50:51.537015 TID:14  (PRI) (ENT) PoolManager.CreateNewPR()
2023-09-28 20:50:51.537147 TID:14  (PRI) (ERR) (CP) PoolManager.CreateNewPR() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: unknown Cert Authority
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
   at OracleInternal.ConnectionPool.PoolManager`3.CreateNewPR(Int32 reqCount, Boolean bForPoolPopulation, ConnectionString csWithDiffOrNewPwd, OracleConnection connRefForCriteria, Boolean bMaxSemObtained, Boolean bIgnoreIdleSem, Boolean& bIdleSemObtainedWhileCreatingPR, String instanceName, List`1 switchFailedInstNames)
2023-09-28 20:50:51.537156 TID:14  (PRI) (EXT) PoolManager.CreateNewPR()
2023-09-28 20:50:51.537226 TID:14  (PRI) (SVC) (ENT) OracleConnectionImpl.get_ServiceName() (CONNECTION_OPTION:SERVICE_NAME=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com) (ISNULL=FALSE)
2023-09-28 20:50:51.537236 TID:14  (PRI) (EXT) (CP) PoolManager.CreateNewPR() (aff=n/a) (inst=) (affmatch=n/a) (pr.service=g22b5279b41bc45_cryptoaster_tp.adb.oraclecloud.com) (pr.pdb=) (pr.edition=) (sessid=-1:-1) (F;F;F;;N) (pmid=9759436) 
2023-09-28 20:50:51.537257 TID:14  (PRI) (CP) PoolManager.Put() [INCR:REL:11] PM.Put() : Incr Sempahore count=4
2023-09-28 20:50:51.537294 TID:14  (PRI) (EXT) (CP) PoolManager.Get() (txnid=n/a) PM.Get(aff=;force=F) returning (null)
2023-09-28 20:50:51.537313 TID:14  (PRI) (ENT) OraclePoolManager.Get()
2023-09-28 20:50:51.537465 TID:14  (PRI) (ERR) (CP) OraclePoolManager.Get() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: unknown Cert Authority
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
2023-09-28 20:50:51.537475 TID:14  (PRI) (EXT) OraclePoolManager.Get()
2023-09-28 20:50:51.537508 TID:14  (PRI) (EXT) (CP) OraclePoolManager.Get() (txnid=n/a) 
2023-09-28 20:50:51.537961 TID:14  (PRI) (ENT) OracleConnectionDispenser.Get()
2023-09-28 20:50:51.538042 TID:14  (PRI) (ERR) (CP) OracleConnectionDispenser.Get() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: unknown Cert Authority
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
2023-09-28 20:50:51.538055 TID:14  (PRI) (EXT) OracleConnectionDispenser.Get()
2023-09-28 20:50:51.538095 TID:14  (PRI) (EXT) (CP) OracleConnectionDispenser.Get() (txnid=n/a) 
2023-09-28 20:50:51.538112 TID:14  (PRI) (ENT) OracleConnection.Open()
2023-09-28 20:50:51.538218 TID:14  (PUB) (ERR) OracleConnection.Open() (txnid=n/a) Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle Communication: Failed to connect to server or failed to parse connect string
 ---> OracleInternal.Network.NetworkException (0x80004005): ORA-00542: Failure during SSL handshake
 ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception.
 ---> Interop+AppleCrypto+SslException: unknown Cert Authority
   --- End of inner exception stack trace ---
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](Boolean receiveFirst, Byte[] reAuthenticationData, CancellationToken cancellationToken)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.Negotiate(ConnectionOption conOption)
   at OracleInternal.Network.TcpsTransportAdapter.ConnectIterate()
   at OracleInternal.Network.OracleCommunication.ConnectViaCO(ConnectionOption connOption, AddressResolution addrRes)
   at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
   at OracleInternal.Network.OracleCommunication.Connect(String tnsDescriptor, Boolean doNAHandshake, String IName, ConnectionOption CO)
   at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName)
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
2023-09-28 20:50:51.538225 TID:14  (PRI) (EXT) OracleConnection.Open()
2023-09-28 20:50:51.538272 TID:14  (PUB) (EXT) OracleConnection.Open() (conid=52648047) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a) 
2023-09-28 20:50:51.550106 TID:14  (PUB) (ENT) OracleConnection.Close() (conid=52648047) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a) 
2023-09-28 20:50:51.550156 TID:14  (PUB) (EXT) OracleConnection.Close() (conid=52648047) (state=Closed) (sessid=0) (implid=0) (pooling=T) (txnid=n/a) 
2023-09-28 20:50:51.551503 TID:14  (PUB) (ENT) OracleConnection.Dispose()
2023-09-28 20:50:51.551529 TID:14  (PUB) (EXT) OracleConnection.Dispose()

0 replies

alexkeh · 2023-09-28T20:00:04Z

alexkeh
Sep 28, 2023
Maintainer

The first trace implies the wrong trust root was inserted. Can you review to verify you're using the correct one?

1 reply

dmytro-i Sep 28, 2023
Author

Not sure how to do that. And don't remember doing anything like this when I was trying to connect.

dmytro-i · 2023-09-29T08:28:45Z

dmytro-i
Sep 29, 2023
Author

It appears to be only reproducible on my development machine. When I put it on the server it works fine.

0 replies

alexkeh · 2023-10-02T16:50:58Z

alexkeh
Oct 2, 2023
Maintainer

The Oracle .NET team has reproduced this error on macOS. It appears to affect newer macOS versions only from our observations. We have created bug 35865628 to track this issue.

0 replies

When I run my app it tries to make changes to my keychain #315

Uh oh!

dmytro-i Sep 28, 2023

Replies: 10 comments · 1 reply

Uh oh!

alexkeh Sep 28, 2023 Maintainer

Uh oh!

alexkeh Sep 28, 2023 Maintainer

Uh oh!

dmytro-i Sep 28, 2023 Author

Uh oh!

alexkeh Sep 28, 2023 Maintainer

Uh oh!

dmytro-i Sep 28, 2023 Author

Uh oh!

dmytro-i Sep 28, 2023 Author

Uh oh!

dmytro-i Sep 28, 2023 Author

Uh oh!

alexkeh Sep 28, 2023 Maintainer

Uh oh!

dmytro-i Sep 28, 2023 Author

Uh oh!

dmytro-i Sep 29, 2023 Author

Uh oh!

alexkeh Oct 2, 2023 Maintainer

dmytro-i
Sep 28, 2023

Replies: 10 comments 1 reply

alexkeh
Sep 28, 2023
Maintainer

alexkeh
Sep 28, 2023
Maintainer

dmytro-i
Sep 28, 2023
Author

alexkeh
Sep 28, 2023
Maintainer

dmytro-i
Sep 28, 2023
Author

dmytro-i
Sep 28, 2023
Author

dmytro-i
Sep 28, 2023
Author

alexkeh
Sep 28, 2023
Maintainer

dmytro-i Sep 28, 2023
Author

dmytro-i
Sep 29, 2023
Author

alexkeh
Oct 2, 2023
Maintainer