×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I am trying an example I saw in a Tim Rowe & Scott Forstie example to send a text message from IBM i using SQL. Basically it goes like this:
values QSYS2.HTTP_POST(
'
https://api.twilio.com/2010-04-01/Accounts/AC<redacted>/Messages.json',
cast(
'&To=+12605551212' concat
'&From=+12675551212' concat
'&Body=Sample Text ' as varchar(855)),
'{"basicAuth":"AC<redacted>,<redacted>",
"header":"content-type,application/x-www-form-urlencoded"}');
However I am getting
SQL State: 38501
Vendor Code: -443
Message: [SQL0443] AXISC ERROR : HTTPTransportException: Cannot initialize a channel to the remote end.
Failed to establish SSL connection to server, the operation gsk_secure_soc_init() failed.
GSKit Error is 6000 - Certificate is not signed by a trusted certificate authority.
Coworker suggested this link:
https://www.ibm.com/docs/en/i/7.4?topic=programming-http-functions-overview
Basically it looks like either I figure out the certificate issues and put them into DCM or run the script at this site and create a new store and always specify this store when running any https type service .
I looked at twilio's site. I see this chain:
DigiCert
-DigiCert TLS RSA SHA256 2020 CA1
--*.twilio.com
Do I perform actions based on this chain? Or do I just do that script on Knowledge Center?
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com
midrange.com
