The reason I need the SP to do the HTTPS Post via some method is because
the transaction table with the trigger that fires the SP that runs cURL
and parses the result is being inserted by three different separate
systems simultaneously.
1) The IVR via Oterro ODBC to the RBase database by Callmaster running
my Callmaster Basic scripts
2) The Web Server which is CodeCharge PHP/IIS/Rbase/Oterro ODBC to the
database
3) Customer Service people running Rbase 7.6ee direct to the Rbase
database on the local network.
All three systems insert a transaction record to the EFTRequest table
that fires the SP that launches cURL. The response from the POST is
parsed in the SP and updates the EFTRequest record with Auth or Decline.
Either I get this launch to work or we build a UDF, WinUDF, DLL, Plugin
or something to send a HTTPS POST and capture the response.
Thanx
Thom
MikeB wrote:
Well I'm not too sure you can't send it from your Callmaster Basic, if
it has a mechanism to Create a COM object. But in the absence of
that, we should still be able to do it with Windows Scripting and
write the results to a file like you are doing now, but the thing I
haven't tried is LAUNCH in Oterro.
Stay tuned.....
----- Original Message ----- From: "Thomas Cimicato"
<[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 6:31 PM
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
The cURL.exe that needs to be launched sends an HTTPS URL POST and
collects the result to a .txt file that I parse. This works well when
the stored procedure runs in RBase. I can't get anything to launch
when the SP runs from Oterro.
So really I think the problem is that I can't get Oterro to launch
anything. BTW....this is all running on a test server Win NT 4.0 that
runs the IVR.Dialogic, ODBC, Oterro 3.5, and RBase 7.6.
Mike you are correct about the .exe just being the HTTPS wrapper. If
there is a way for RBase to send a HTTPS POST and capture the result
back from it, then I don't need to launch cURL.exe from the stored
procedure.
Thom
MikeB wrote:
Thanks Razzak, but I'm not sure it's going to be the help Thom is
looking for.
He has an EXE he wants to launch. That EXE is just a wrapper for
the XMLHTTP request object to a remote server running PHP.
The EXE is designed to collect a return value from the remote server
and beyond that I don't know how the EXE passes the return value
back to the SP he uses to call the EXE.
Since it worked in 7.6, but didn't work in the Oterro session, I
thought he had possibly AV or something on that machine that
prevented the EXE from running (like spawning a process from a virus).
----- Original Message ----- From: "A. Razzak Memon"
<[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 5:17 PM
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
Emmitt,
I will upload the requested document as soon as I reach the mainland.
My iPhone does not have R:Upload app <g>.
Very Best R:egards,
Razzak.
Sent from my iPhone
On Mar 19, 2010, at 5:06 PM, "Emmitt Dove"
<[email protected]> wrote:
I don't know that Razzak would have the 3.0 What's New online any
more.
Emmitt Dove
Manager, Converting Applications Development
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of MikeB
Sent: Friday, March 19, 2010 17:01
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
I don't have Oterro installed. What's the link to the online?
----- Original Message -----
From: "Emmitt Dove" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 4:30 PM
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
See WhatsNewInOterro30.pdf.
Emmitt Dove
Manager, Converting Applications Development
Evergreen Packaging, Inc.
[email protected]
(203) 214-5683 m
(203) 643-8022 o
(203) 643-8086 f
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
MikeB
Sent: Friday, March 19, 2010 16:13
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
OK. The normal thing to do would be to have the Scripting
language do the
request, depending on the result from the stored procedure. Not
having
done
a LAUNCH from a SP, I will take it from Emmitt that it is
permissible.
I take it the following is in the SP?
SET VAR vLaunch = 'LAUNCH request.cmd'
&vLaunch
If it is, I don't see how you get a value into vLaunch as LAUNCH
doesn't
have a mechanism to return a variable.
Is request.cmd a dos batch file or an RBase command file?
----- Original Message -----
From: "Thomas Cimicato" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 3:35 PM
Subject: [RBASE-L] - Re: Oterro Launching cmd.com
ok...well.....I built an IVR system that uses ODBC to connect to
the
RBase
database using the Oterro 3.5 driver. The IVR works great
reading and
writing to the Rbase database through Oterro ODBC driver and
executes the
stored procedure from a trigger just dandy. Its the stored
procedure
executed by Oterro that needs to launch a DOS command file that
runs
cURL.exe.
I don't know what language the IVR system was written in. My IVR
scripts
are called Callmaster Basic. Its an interpreted scripting
language for
that IVR system (kinda like rbase command files are interpreted by
Rbase).
So its not compiled Oterro Dll's. We are using the Oterro ODBC
driver to
get to the database.
I have even tried to use the Rbase 7.6 ODBC driver for the IVR
and that
works fine too. Its the launch command in the stored procedure
that won't
run. Maybe its my syntax for the launch command in the stored
procedure.
SET VAR vLaunch = 'LAUNCH request.cmd'
&vLaunch
Thom
MikeB wrote:
Also Thom, you haven't said what programming language you are
using for
the front end to Oterro, or is the Oterro instance on the
server being
accessed by your RBase sessions on the Lan and the Wan?
----- Original Message ----- From: "Thomas Cimicato"
<[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, March 19, 2010 12:20 PM
Subject: [RBASE-L] - Oterro Launching cmd.com
Can Oterro 3.5 running a stored procedure "launch" a command line
process .bat or .cmd file? I can get it to work in my local
RBase 7.6
environment but Oterro does not seem to execute the launch.
Oterro
executes the stored procedure/trigger nicely it but it doesn't
execute
the "launch test.bat" DOS command file that I need the stored
procedure
to run.
Will Oterro execute a UDF if I convert the batch file to a
UDF of some
sort?
Any comments are welcome.
Thanx
Thom
