Re: send text msg to phone from IBM i

Evan,
Thanks for breaking down the links.
I wonder if any of them worked for him?

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

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Evan Harris
Sent: Saturday, November 19, 2022 3:07 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: send text msg to phone from IBM i

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


I went and looked at the link; worked fine for me.

Here is a link to the group in case that is somehow the problem:
https://www.linkedin.com/groups/1107217/

Here is a link to the linked in discussion again (the one that I think does
not work for you):

https://www.linkedin.com/feed/update/urn:li:activity:6920058466698956801/?utm_source=share&utm_medium=member_desktop

Here is the common presentation referenced in the linked in discussion:

https://learn.common.org/products/isee-rest-apis-from-dad-jokes-to-sending-text-messages-to-your-phone?packages%5B%5D=46368&in_package=46368&sort_by=package_order&ref=package&ref_id=46368

Here is the actual text from the discussion (which might be slightly
difficult to follow but not as hard as the link not working)

Excerpt 1 from linked in discussion:
I am trying a new SQL service I learned about while looking at a
presentation https://lnkd.in/dHj5eMfp
I am trying the service HTTP_POST to send a text. We too use twilio. So I
modified it to:
values QSYS2.HTTP_POST(
'https://lnkd.in/dvQQ4rDt',
cast(
'&To=+12605551212' concat
'&From=+12675551212' concat
-- '&MessagingServiceSid=???' concat -- Huh??
'&Body=Sample Text ' as varchar(855)),
'{"basicAuth":"ACredacted,redacted",
"header":"content-type,application/x-www-form-urlencoded"}');
Now I am getting:
CPF503E User-defined function error on member QSQPTABL. 2022-04-13
12:59:10.718949 30 SENDER Cause . . . . . : An error occurred while
invoking user-defined function HTTP_POST in library QSYS2. The error
occurred while invoking the associated external program or service program
QSQAXISC in library QSYS, program entry point or external name
axiscPostClob, specific name HTTP_POST. The error occurred on member
QSQPTABL file QSQPTABL in library QSYS2. The error code is 1. The error
codes and their meanings follow: 1 -- The external program or service
program returned SQLSTATE 38501. The text message returned from the program
is: 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. .
Recovery . . . : For error codes 1 and 2, determine the cause of the error
from either the SQLSTATE or a previously listed message.
Possible choices for replying to message . . . . . . . . . . . . . . . : &B
C -- The request is canceled. &B I -- The request is ignored. ROB QSYS
QDBIOERRQO QDBIOERRQO SEND_MESSAGE 4160 QSYS QDBIOERRQO QDBIOERRQO
SEND_MESSAGE 4160

I'm trying to figure out what certificate or whatever I need to put into
DCM.
(Followed by link to common link as above)

Excerpt 2 from linked in discussion:
I followed some examples on how to export certificates from twilio and
import them into DCM, modifying them slightly for the new DCM .
Now the sql works like a champ.
https://docs.bvstools.com/home/ssl-documentation

Excerpt 3 from linked in discussion:
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 . What say
ye?
BTW: /QOpenSys/QIBM/ProdData/JavaVM/jdk11/64bit has no jre subdirectory on
my machine. jdk80 does.

Excerpt 4 from linked in discussion:
Simple solution.
Go into New Navigator.
Bookmarks
IBM Digital Certificate Manager for i
Open or Create the *SYSTEM store
"Populate with CAs"
Simple as pie!





On Sun, Nov 20, 2022 at 8:44 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

hate to keep beating this dead horse but still trying to figure out how

to

access that linkedin link you provide Rob.

I have searched your activity feed, and searched for IBM i professionals
under groups and cannot even find the group.

Perhaps I don't have access to the group and why I don't have access to

the

link? can you check?

thanks

jay

On Wed, Nov 9, 2022 at 9:20 AM Rob Berendt <rob@xxxxxxxxx> wrote:

"You can do anything with sql".
Do you "LinkedIn"?

https://www.linkedin.com/feed/update/urn:li:activity:6920058466698956801?utm_source=share&utm_medium=member_desktop

This has a link to a post on how to do it via sql.
The final comment is really important on getting the certs right.

Simple

as heck!

Ok, if you think LinkedIn is the devil's tool then try this:

https://learn.common.org/products/isee-rest-apis-from-dad-jokes-to-sending-text-messages-to-your-phone?packages%5B%5D=46368&in_package=46368&sort_by=package_order&ref=package&ref_id=46368

And the final comment on that LinkedIn post:
Simple solution.
Go into New Navigator.
Bookmarks
IBM Digital Certificate Manager for i
Open or Create the *SYSTEM store
"Populate with CAs"
Simple as pie!

Apparently IBM ships the certs, they just don't populate them
automatically. The above step fixes that.

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

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of

Jay

Vaughn
Sent: Sunday, November 6, 2022 6:28 PM
To: Midrange Systems Technical Discussion <

midrange-l@xxxxxxxxxxxxxxxxxx

Subject: send text msg to phone from IBM i

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and

know

the content is safe.


I know you can send a txt msg with the SNDSMTPEMM command if you know

the

phone number's carrier...

Aside from calling a 3rd party web api, is there a way to send text
messages from the IBM i to a phone number if you don't know the

carrier?

tia

Jay
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--

Regards
Evan Harris
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com