查看“ADW - Autonomous Database details”的源代码

===Oracle Cloud ADW - Autonomous Database details===
Run Python Application Without a Wallet
===Network===
====Access type:====
*Allow secure access from specified IPs and VCNs
====Access control list:====
*Enabled IP: 36.112.25.131,132.145.51.204
====Mutual TLS (mTLS) authentication:====
*Not Required
 DSN='(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.uk-london-1.oraclecloud .com))(connect_data=(service_name=g0afda210a8192f_bidb_medium.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=a dwc.eucom-central-1.oraclecloud.com, OU=Oracle BMCS FRANKFURT, O=Oracle Corporation, L=Redwood City, ST=California,  C=US")))'
 USER='admin'
 PASSWD='PASSWORD'
 
 import oracledb
 
 conn=oracledb.connect(user=USER, password=PASSWD, dsn=DSN)
 cur=conn.cursor()
 res=cur.execute("select count(*) from tab")
 for TN in res:
     print(TN)
===Error===
====AttributeError: module 'lib' has no attribute 'X509_V_FLAG_CB_ISSUER_CHECK'====
系统当前的python和pyOpenSSL版本不对应
 mv /usr/lib/python3/dist-packages/OpenSSL /tmp/
 
 pip3 install pyOpenSSL --upgrade

 Collecting pyOpenSSL
   Downloading pyOpenSSL-22.1.0-py3-none-any.whl (57 kB)
      |████████████████████████████████| 57 kB 5.5 MB/s 
 Requirement already satisfied, skipping upgrade: cryptography<39,>=38.0.0 in /usr/local/lib/python3.8/dist-packages ( from pyOpenSSL) (38.0.4)
 Requirement already satisfied, skipping upgrade: cffi>=1.12 in /usr/local/lib/python3.8/dist-packages (from  cryptography<39,>=38.0.0->pyOpenSSL) (1.15.0)
 Requirement already satisfied, skipping upgrade: pycparser in /usr/local/lib/python3.8/dist-packages (from  cffi>=1.12->cryptography<39,>=38.0.0->pyOpenSSL) (2.21)
 Installing collected packages: pyOpenSSL
   Attempting uninstall: pyOpenSSL
     Found existing installation: pyOpenSSL 19.0.0
     Not uninstalling pyopenssl at /usr/lib/python3/dist-packages, outside environment /usr
     Can't uninstall 'pyOpenSSL'. No files were found to uninstall.
 Successfully installed pyOpenSSL-22.1.0
[[分类:Develop]]
[[分类:DB]]
{{DEFAULTSORT:ADW_Autonomous_Database_details}}
[[分类:Oracle]]