Всем привет !

Пытаюсь реализовать отправку уведомлений в Telegram средствами PL SQL

Шаги следующие

1) Экспортируем серт с api.telegram.org

2) Копируем cерт в /home/oracle/api-telegram.cer

3) Создаем бумажник (пароль welcome_tg)

mkdir /home/oracle/wallet
orapki wallet create -wallet /home/oracle/wallet -auto_login -pwd welcome_tg

4) Добавляем серт

orapki wallet add -wallet /home/oracle/wallet -trusted_cert -cert /home/oracle/api-telegram.cer -pwd welcome_tg


5) Просмотрим бумажник

orapki wallet display -complete -wallet /home/oracle/wallet




Requested Certificates:
User Certificates:
Trusted Certificates:
Subject: CN=Go Daddy Secure Certificate Authority - G2,OU=http://certs.godaddy.com/repository/,O=GoDaddy.com\, Inc.,L=Scottsdale,ST=Arizona,C=US
Issuer: CN=Go Daddy Root Certificate Authority - G2,O=GoDaddy.com\, Inc.,L=Scottsdale,ST=Arizona,C=US
Serial Number: 07
Key Length 2048
MD5 digest: 96:C2:50:31:BC:0D:C3:5C:FB:A7:23:73:1E:1B:41:40
SHA digest: 27:AC:93:69:FA:F2:52:07:BB:26:27:CE:FA:CC:BE:4E:F9:C3:19:B8

Subject: CN=Go Daddy Root Certificate Authority - G2,O=GoDaddy.com\, Inc.,L=Scottsdale,ST=Arizona,C=US
Issuer: CN=Go Daddy Root Certificate Authority - G2,O=GoDaddy.com\, Inc.,L=Scottsdale,ST=Arizona,C=US
Serial Number: 00
Key Length 2048
MD5 digest: 80:3A:BC:22:C1:E6:FB:8D:9B:3B:27:4A:32:1B:9A:01
SHA digest: 47:BE:AB:C9:22:EA:E8:0E:78:78:34:62:A7:9F:45:C2:54:FD:E6:8B

Subject: CN=api.telegram.org,OU=Domain Control Validated
Issuer: CN=Go Daddy Secure Certificate Authority - G2,OU=http://certs.godaddy.com/repository/,O=GoDaddy.com\, Inc.,L=Scottsdale,ST=Arizona,C=US
Serial Number: 0D:03:23:A0:90:B6:80:42
Key Length 2048
MD5 digest: F1:66:BE:C6:ED:1D:63:D3:2B:17:63:7E:D5:C5:C7:6B
SHA digest: F2:AD:29:9C:34:48:DD:8D:F4:CF:52:32:F6:57:33:68:2E:81:C1:90


6) Пробуем

select UTL_HTTP.request('https://api.telegram.org/bot2137664:AAFccDDwYyEFqZMwTF1LyFipYbSdBlopcfIIs/getUpdates',null,'file:/home/oracle/wallet', 'welcome_tg') from dual;


Получаю ошибку

ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1501
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1441
ORA-06512: at line 1



Судя по ошибке , проблема в сертификате . Пробовал разные манипуляции с сертификатом - ошибка одна и таже ORA-29024

SQL> exec UTL_HTTP.set_wallet('file:/home/oracle/wallet', 'welcome_tg');

PL/SQL procedure successfully completed.

SQL> select UTL_HTTP.request('https://api.telegram.org/bot2137664:AAFccDDwYyEFqZMwTF1LyFipYbSdBlopcfIIs/getUpdates') from dual;
select UTL_HTTP.request('https://api.telegram.org/bot2137664:AAFccDDwYyEFqZMwTF1LyFipYbSdBlopcfIIs/getUpdates') from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1501
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1441
ORA-06512: at line 1

т е не указывать пароль к бумажнику?

так ?


SQL> exec UTL_HTTP.set_wallet('file:/home/oracle/wallet',null);

PL/SQL procedure successfully completed.

SQL> select UTL_HTTP.request('https://api.telegram.org/bot2137664:AAFccDDwYyEFqZMwTF1LyFipYbSdBlopcfIIs/getUpdates') from dual;
select UTL_HTTP.request('https://api.telegram.org/bot2137664:AAFccDDwYyEFqZMwTF1LyFipYbSdBlopcfIIs/getUpdates') from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1501
ORA-29024: Certificate validation failure
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1441
ORA-06512: at line 1


SQL>

Я так и экспортировал как у тебя на скрине .
Можешь прикрепить файл сертификата ?
или хотя бы показать вывод команды


orapki wallet display -complete -wallet /home/u01/app/oracle/product/19.3.0/dbhome_1/wallet

Aleks Niches

спасибо огромное. получилось