Forum Replies Created
-
Mcdeeiis,
use Read block to collect user inputs and Integration Server to store inputs in database.
Hermann,
The primary difference between the gui asterisk distros (PIAF, trixbox, elastix,etc) is where the config files are kept, what they are named, and what other files they include themselves. The underlying dialplan code is all the same. So to answer your question, yes, you can take the code from the VDP generated context in trixbox and move that code into the appropriate file in a “vanilla” asterisk system and it will work the same. Hope this helps.Kevin
I am not sure about the database you refer to but Visual Dialplan can access almost any database that has odbc or jdbc driver.
Check Integration Server at their web site, it supports MySQL, MS SQL …I don’t know the table where FreePBX stores phone directory but it must bu in the MySQL database that comes with FreePBX.
Make sure to set appropriate access rights at MySQL database so the Integration Server can access it.— Mat
Thanks for the reply,
OK, I have my network issues resolved. I realized that instead of having my local IP address listed in the database configuration
I needed to have the public IP address of my computer running Visual Dialplan in the configuration so that my remote PBX can reach
the database.My question now is , can Visual Dialplan access the database that is native to Asterisk/FreePBX? like I believe there is a phone directory? and maybe some other data actually stored at the PBX. Can the dialplan access that data? and if so how?
Thanks
> 2013-05-18 08:03:20 VERBOSE1886C-00000084 pbx.c: — Executing 765@from-internal:4 AGI(“SIP/701-000000a3”, “agi://192.168.1.219:9110/DatabaseQuery.agi?db=Embedded+Database&callbackApp=Gosub&query=GetOrders&callback=list_orders&as=54.235.112.69”) in new stack
> 2013-05-18 08:03:20 ERROR1886C-00000084 utils.c: write() returned error: Network is unreachableAccording the log records above, your Asterisk server (54.235.112.69) can not reach your IS server (192.168.1.219).
> I have IS properly installed on my local machine and when I test a SQL query it works fine.
When you test SQL query from Visual Dialplan you are actually executing SQL on local machine because both, Visual Dialplan and IS are on the same machine. And it works fine. And will work fine always.
> But when I deploy it to my remote server, I believe I get an error. I think it is looking for the database in the remote location, but that was not set up. am I correct?
But when you deploy the call flow to Asterisk server, the code will run on Asterisk server and the Asterisk server will try to execute AGI script on your IS server (deployed at your local machine).
And there is a network problem, it looks like your Asterisk server can not reach IS server.— Matt
Just curious, how the remote software can ‘see’ the local IP? It should see only public IP, right?
And in case somehow it can see local IP, how to know what is the right local IP when there are several local IPs (which is usual config)?— Mike
This turned out to be a bug in the Apstel Program. When remotely configuring a server.. It will tell the IS server the public IP and not the local ip, in some cases this is fine, but in cases of nat it is not.
I see that, but i am only using one. I guess that is my question. Why do I get that error when i am only using one? here is the the conf file. Now it did create a inboung and outbound.. could that be it?
; Generated by Visual Dialplan Professional.
Creation date
2012-12-07 14:13:44.564; Created from:
;This context is used to handle all outbound calls.
vdp-outboundexten => 0055,1,Answer()
exten => 0055,n,Set(amount=20)
exten => 0055,n,Read(card_number,EnterCardNumber,16,,3,4)
exten => 0055,n,Read(exp_month,EnterExpMonth,2,,3,5)
exten => 0055,n,Read(exp_year,EnterExpYear,2,,3,4)
exten => 0055,n,Set(ojki_is_pay_amt=${amount})
exten => 0055,n,Set(ojki_is_pay_ccNum=${card_number})
exten => 0055,n,Set(ojki_is_pay_ccExpYr=${exp_year})
exten => 0055,n,Set(ojki_is_pay_ccExpMo=${exp_month})
exten => 0055,n,Set(ojki_is_pay_cardCode=123)
exten => 0055,n,Set(ojki_is_pay_dupWin=11)
exten => 0055,n,Set(ojki_is_pay_invoiceNum=1111)
exten => 0055,n,Set(ojki_is_pay_desc=Sample Transaction)
exten => 0055,n,Set(ojki_is_pay_custFName=John)
exten => 0055,n,Set(ojki_is_pay_custLName=Doe)
exten => 0055,n,Set(ojki_is_pay_custCompany=Apstel)
exten => 0055,n,Set(ojki_is_pay_custAddr=1234 Street)
exten => 0055,n,Set(ojki_is_pay_custCity=NewYork)
exten => 0055,n,Set(ojki_is_pay_custState=WA)
exten => 0055,n,Set(ojki_is_pay_custZip=98004)
exten => 0055,n,Set(ojki_is_pay_custCountry=USA)
exten => 0055,n,Set(ojki_is_pay_custPhone=1233456678)
exten => 0055,n,Set(ojki_is_pay_custEmail=12@12)
exten => 0055,n,AGI(agi://192.168.0.241:9110/SendPayment.agi?srv=Auth.net+Gateway&tid=ojki&as=192.168.0.241)
exten => 0055,n,Hangup();This context is used to handle all inbound calls.
vdp-inboundexten => 0055,1,Answer()
exten => 0055,n,Set(amount=20)
exten => 0055,n,Read(card_number,EnterCardNumber,16,,3,4)
exten => 0055,n,Read(exp_month,EnterExpMonth,2,,3,5)
exten => 0055,n,Read(exp_year,EnterExpYear,2,,3,4)
exten => 0055,n,Set(vbta_is_pay_amt=${amount})
exten => 0055,n,Set(vbta_is_pay_ccNum=${card_number})
exten => 0055,n,Set(vbta_is_pay_ccExpYr=${exp_year})
exten => 0055,n,Set(vbta_is_pay_ccExpMo=${exp_month})
exten => 0055,n,Set(vbta_is_pay_cardCode=123)
exten => 0055,n,Set(vbta_is_pay_dupWin=11)
exten => 0055,n,Set(vbta_is_pay_invoiceNum=1111)
exten => 0055,n,Set(vbta_is_pay_desc=Sample Transaction)
exten => 0055,n,Set(vbta_is_pay_custFName=John)
exten => 0055,n,Set(vbta_is_pay_custLName=Doe)
exten => 0055,n,Set(vbta_is_pay_custCompany=Gardian)
exten => 0055,n,Set(vbta_is_pay_custAddr=1234 Street)
exten => 0055,n,Set(vbta_is_pay_custCity=Columbus)
exten => 0055,n,Set(vbta_is_pay_custState=OH)
exten => 0055,n,Set(vbta_is_pay_custZip=43017)
exten => 0055,n,Set(vbta_is_pay_custCountry=USA)
exten => 0055,n,Set(vbta_is_pay_custPhone=1233456678)
exten => 0055,n,Set(vbta_is_pay_custEmail=12@12)
exten => 0055,n,AGI(agi://192.168.0.241:9110/SendPayment.agi?srv=Guard_Auth_Net&tid=vbta&as=192.168.0.241)
exten => 0055,n,Hangup()Not sure about the error but you have no more free licenses, according to the first line in the log…
— Mike
Under the Visual Dialplan installation folder, there is a jdbc/ sub folder.
You should copy your Oracle JDBC JAR file there. After that you will be able to create Oracle database in the Intergation Server View in the Visual Dialplan.You will also have to copy the Oracle JDBC JAR in the jdbc/ sub folder in the Integration Server (IS) installation folder.
Hope this helps.
Bandino
Thanks.
We hace changed the configuration of IS to “Development mode”, in the section Authorize.net.
Now ,the log is:
…
2012-08-06 11:24:59,672 Asterisk-Java DaemonPool-1-thread-8 INFO apstel.is.com.apstel.is.B.A.E – response4: (TESTMODE) This transaction has been approved.-
This reply was modified 10 years, 6 months ago by
Migrated from old forum.
> 2012-08-02 14:11:56,142 Asterisk-Java DaemonPool-1-thread-1
> INFO apstel.is.com.apstel.is.B.A.E – response4:
> (TESTMODE) This account has not been given the permission(s) required for this request.It looks like the account does not have permissions required.
Check it with authorize.net.–Mark
Hi,
Version of java is:
root@elastix ~# java -version
java version “1.7.0_05”
Java(TM) SE Runtime Environment (build 1.7.0_05-b06)
Java HotSpot(TM) Client VM (build 23.1-b03, mixed mode, sharing)Our log of Integration Server:
2012-08-02 09:42:57,542 HSQLDB Server @1257687 INFO SystemOut – Server@1257687: Startup sequence completed in 3814 ms.
2012-08-02 09:42:57,788 HSQLDB Server @1257687 INFO SystemOut – Server@1257687: 2012-08-02 09:42:57.786 HSQLDB server 2.0.0 is online on port 9112
2012-08-02 09:42:57,788 HSQLDB Server @1257687 INFO SystemOut – Server@1257687: To close normally, connect and execute SHUTDOWN SQL
2012-08-02 09:42:57,789 HSQLDB Server @1257687 INFO SystemOut – Server@1257687: From command line, use Ctrl+C to abort abruptly
2012-08-02 09:42:59,386 main INFO apstel.is. – Starting embedded JES server…
2012-08-02 09:43:06,872 Thread-3 INFO apstel.is.slog – INFO. MEMORY DUMP:
—————-
ae12ec65227d0dd489992968ff072b144511b4b017118dd79bdea15af5ac9bb4b19bb5f1603b5e26732ec24fd5f75daecb63d2263d93021b07c63283a82597d51fbe3444250ba23d
—————-
2012-08-02 14:11:53,321 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.F – uniqueId: 1343909488.35channelId: DAHDI/2-1 Processing Send Payment script…
2012-08-02 14:11:53,322 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.F – uniqueId: 1343909488.35channelId: DAHDI/2-1 Argument asteriskServer is: 192.168.1.201
2012-08-02 14:11:53,323 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.F – uniqueId: 1343909488.35channelId: DAHDI/2-1 Argument payment server is: Auth.net Gateway
2012-08-02 14:11:53,323 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.F – uniqueId: 1343909488.35channelId: DAHDI/2-1 Argument transaction ID is: aphy
2012-08-02 14:11:53,323 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.A – Payment server requested for server: 192.168.1.201 and payment server: Auth.net Gateway
2012-08-02 14:11:53,324 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.A – This is first request for the Payment Server for server: 192.168.1.201
2012-08-02 14:11:53,324 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.A – This is the first request for payment server for: 192.168.1.201 and payment server: Auth.net Gateway
2012-08-02 14:11:53,324 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.A – Creating payment server for server: 192.168.1.201 and payment server: Auth.net Gateway
2012-08-02 14:11:53,330 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.A – Payment server cfg file is: /home/ruben/Y/deploy/192.168.1.201/payment/srv__Auth.net Gateway.properties
2012-08-02 14:11:53,349 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.A – Created payment server is: com.apstel.is.B.A.C@552379
2012-08-02 14:11:53,349 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.A – Payment server returned: com.apstel.is.B.A.C@552379
2012-08-02 14:11:53,350 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.F – uniqueId: 1343909488.35channelId: DAHDI/2-1 Payment session object is: com.apstel.is.B.A.C@552379
2012-08-02 14:11:53,433 Asterisk-Java DaemonPool-1-thread-1 INFO apstel.is.com.apstel.is.B.A.E – Submitting transaction for payment server Auth.net Gateway
2012-08-02 14:11:56,140 Asterisk-Java DaemonPool-1-thread-1 INFO apstel.is.com.apstel.is.B.A.E – Response from Authorize.Net processor:
2012-08-02 14:11:56,141 Asterisk-Java DaemonPool-1-thread-1 INFO apstel.is.com.apstel.is.B.A.E – response1: 3
2012-08-02 14:11:56,141 Asterisk-Java DaemonPool-1-thread-1 INFO apstel.is.com.apstel.is.B.A.E – response2: 3
2012-08-02 14:11:56,141 Asterisk-Java DaemonPool-1-thread-1 INFO apstel.is.com.apstel.is.B.A.E – response3: 123
2012-08-02 14:11:56,142 Asterisk-Java DaemonPool-1-thread-1 INFO apstel.is.com.apstel.is.B.A.E – response4: (TESTMODE) This account has not been given the permission(s) required for this request.
2012-08-02 14:11:56,142 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response5: 000000
2012-08-02 14:11:56,143 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response6: P
2012-08-02 14:11:56,143 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response7: 0
2012-08-02 14:11:56,143 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response8:
2012-08-02 14:11:56,143 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response9:
2012-08-02 14:11:56,143 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response10: 20.00
2012-08-02 14:11:56,144 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response11:
2012-08-02 14:11:56,144 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response12: auth_capture
2012-08-02 14:11:56,144 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response13:
2012-08-02 14:11:56,144 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response14:
2012-08-02 14:11:56,144 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response15:
2012-08-02 14:11:56,145 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response16:
2012-08-02 14:11:56,145 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response17:
2012-08-02 14:11:56,145 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response18:
2012-08-02 14:11:56,145 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response19:
2012-08-02 14:11:56,145 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response20:
2012-08-02 14:11:56,146 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response21:
2012-08-02 14:11:56,146 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response22:
2012-08-02 14:11:56,146 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response23:
2012-08-02 14:11:56,146 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response24:
2012-08-02 14:11:56,146 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response25:
2012-08-02 14:11:56,147 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response26:
2012-08-02 14:11:56,147 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response27:
2012-08-02 14:11:56,147 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response28:
2012-08-02 14:11:56,147 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response29:
2012-08-02 14:11:56,147 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response30:
2012-08-02 14:11:56,147 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response31:
2012-08-02 14:11:56,148 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response32:
2012-08-02 14:11:56,148 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response33:
2012-08-02 14:11:56,148 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response34:
2012-08-02 14:11:56,148 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response35:
2012-08-02 14:11:56,148 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response36:
2012-08-02 14:11:56,149 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response37:
2012-08-02 14:11:56,149 Asterisk-Java DaemonPool-1-thread-1 DEBUG apstel.is.com.apstel.is.B.A.E – response38: 0D9A9FC75973241B57E9E39E22EA05D2
2012-08-02 14:11:56,157 Asterisk-Java DaemonPool-1-thread-1 ERROR apstel.is.com.apstel.is.B.A.E – Error while processing payment transaction.
com.apstel.is.B.A.B: Payment gateway returned error response.
at com.apstel.is.B.A.E.A(Unknown Source)
at com.apstel.is.B.A.E.A(Unknown Source)
at com.apstel.is.B.A.F.service(Unknown Source)
at com.apstel.is.G.A.A.service(Unknown Source)
at org.asteriskjava.fastagi.internal.AgiConnectionHandler.runScript(AgiConnectionHandler.java:159)
at org.asteriskjava.fastagi.internal.AgiConnectionHandler.run(AgiConnectionHandler.java:131)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2012-08-02 14:11:56,161 Asterisk-Java DaemonPool-1-thread-1 ERROR apstel.is.com.apstel.is.B.A.F – uniqueId: 1343909488.35channelId: DAHDI/2-1 Error happened during transaction processing.
com.apstel.is.B.A.B: com.apstel.is.B.A.B: Payment gateway returned error response.
at com.apstel.is.B.A.E.A(Unknown Source)
at com.apstel.is.B.A.F.service(Unknown Source)
at com.apstel.is.G.A.A.service(Unknown Source)
at org.asteriskjava.fastagi.internal.AgiConnectionHandler.runScript(AgiConnectionHandler.java:159)
at org.asteriskjava.fastagi.internal.AgiConnectionHandler.run(AgiConnectionHandler.java:131)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.apstel.is.B.A.B: Payment gateway returned error response.
at com.apstel.is.B.A.E.A(Unknown Source)
… 8 more
2012-08-02 14:11:56,165 Asterisk-Java DaemonPool-1-thread-1 ERROR org.asteriskjava.fastagi.internal.FastAgiConnectionHandler – AgiException running AgiScript com.apstel.is.G.A.B on Asterisk-Java DaemonPool-1-thread-1
org.asteriskjava.fastagi.AgiException: Error happened during transaction processing.
at com.apstel.is.B.A.F.service(Unknown Source)
at com.apstel.is.G.A.A.service(Unknown Source)
at org.asteriskjava.fastagi.internal.AgiConnectionHandler.runScript(AgiConnectionHandler.java:159)
at org.asteriskjava.fastagi.internal.AgiConnectionHandler.run(AgiConnectionHandler.java:131)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.apstel.is.B.A.B: com.apstel.is.B.A.B: Payment gateway returned error response.
at com.apstel.is.B.A.E.A(Unknown Source)
… 7 more
Caused by: com.apstel.is.B.A.B: Payment gateway returned error response.
at com.apstel.is.B.A.E.A(Unknown Source)
… 8 moreThanks
Hello Carlo,
As much as I know there is no option available for attaching documents in the current version of Integration Server.
You may contact Apstel support to see if there are any plans for implementing this feature.Raman
Ups…my mistake, what types of data you want to insert(not to return).
Bernard
-
This reply was modified 10 years, 6 months ago by