[Migrated from old forumParticipant April 5, 2015 at 11:21 am Post count: 327]

#5748 |

I am running the sample is-db-multiselect.vdp and I am running into some problems.

I have IS properly installed on my local machine and when I test a SQL query it works fine. 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? Here is a copy of my log when I try to deploy the dialplan.

2013-05-18 08:02:51 VERBOSE1884C-00000083 pbx.c: — Executing 756@from-internal:1 ResetCDR(“SIP/701-000000a2”, “”) in new stack
2013-05-18 08:02:51 VERBOSE1884C-00000083 pbx.c: — Executing 756@from-internal:2 NoCDR(“SIP/701-000000a2”, “”) in new stack
2013-05-18 08:02:51 VERBOSE1884C-00000083 pbx.c: — Executing 756@from-internal:3 Progress(“SIP/701-000000a2”, “”) in new stack
2013-05-18 08:02:51 VERBOSE1884C-00000083 pbx.c: — Executing 756@from-internal:4 Wait(“SIP/701-000000a2”, “1”) in new stack
2013-05-18 08:02:52 VERBOSE1884C-00000083 pbx.c: — Executing 756@from-internal:5 Progress(“SIP/701-000000a2”, “”) in new stack
2013-05-18 08:02:52 VERBOSE1884C-00000083 pbx.c: — Executing 756@from-internal:6 Playback(“SIP/701-000000a2”, “silence/1&cannot-complete-as-dialed&check-number-dial-again,noanswer”) in new stack
2013-05-18 08:02:52 VERBOSE1884C-00000083 file.c: — Playing ‘silence/1.gsm’ (language ‘en’)
2013-05-18 08:02:53 VERBOSE1884C-00000083 file.c: — Playing ‘cannot-complete-as-dialed.gsm’ (language ‘en’)
2013-05-18 08:02:56 VERBOSE1884C-00000083 file.c: — Playing ‘check-number-dial-again.gsm’ (language ‘en’)
2013-05-18 08:02:57 VERBOSE1884C-00000083 pbx.c: == Spawn extension (from-internal, 756, 6) exited non-zero on ‘SIP/701-000000a2’
2013-05-18 08:02:57 VERBOSE1884C-00000083 pbx.c: — Executing h@from-internal:1 Hangup(“SIP/701-000000a2”, “”) in new stack
2013-05-18 08:02:57 VERBOSE1884C-00000083 pbx.c: == Spawn extension (from-internal, h, 1) exited non-zero on ‘SIP/701-000000a2’
2013-05-18 08:03:16 VERBOSE19872C-00000084 netsock2.c: == Using SIP RTP TOS bits 184
2013-05-18 08:03:16 VERBOSE19872C-00000084 netsock2.c: == Using SIP RTP CoS mark 5
2013-05-18 08:03:16 VERBOSE1886C-00000084 pbx.c: — Executing 765@from-internal:1 Answer(“SIP/701-000000a3”, “”) in new stack
2013-05-18 08:03:17 VERBOSE1886C-00000084 pbx.c: — Executing 765@from-internal:2 Read(“SIP/701-000000a3”, “pin,conf-getpin,3,,1,10”) in new stack
2013-05-18 08:03:17 VERBOSE1886C-00000084 app_read.c: — Accepting a maximum of 3 digits.
2013-05-18 08:03:17 VERBOSE1886C-00000084 file.c: — Playing ‘conf-getpin.gsm’ (language ‘en’)
2013-05-18 08:03:20 VERBOSE1886C-00000084 app_read.c: — User entered ‘123’
2013-05-18 08:03:20 VERBOSE1886C-00000084 pbx.c: — Executing 765@from-internal:3 Set(“SIP/701-000000a3”, “total=0”) in new stack
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 unreachable
2013-05-18 08:03:20 WARNING1886C-00000084 res_agi.c: Connect to ‘agi://192.168.1.219:9110/DatabaseQuery.agi?db=Embedded+Database&callbackApp=Gosub&query=GetOrders&callback=list_orders&as=54.235.112.69’ failed: Network is unreachable
2013-05-18 08:03:20 VERBOSE1886C-00000084 pbx.c: — Executing 765@from-internal:5 SayNumber(“SIP/701-000000a3”, “0,m”) in new stack
2013-05-18 08:03:20 VERBOSE1886C-00000084 file.c: — Playing ‘digits/0.gsm’ (language ‘en’)
2013-05-18 08:03:21 VERBOSE1886C-00000084 pbx.c: — Executing 765@from-internal:6 Hangup(“SIP/701-000000a3”, “”) in new stack
2013-05-18 08:03:21 VERBOSE1886C-00000084 pbx.c: == Spawn extension (from-internal, 765, 6) exited non-zero on ‘SIP/701-000000a3’
2013-05-18 08:03:21 VERBOSE1886C-00000084 pbx.c: — Executing h@from-internal:1 Hangup(“SIP/701-000000a3”, “”) in new stack
2013-05-18 08:03:21 VERBOSE1886C-00000084 pbx.c: == Spawn extension (from-internal, h, 1) exited non-zero on ‘SIP/701-000000a3’
2013-05-18 08:11:24 VERBOSE19872C-00000085 netsock2.c: == Using SIP RTP TOS bits 184
2013-05-18 08:11:24 VERBOSE19872C-00000085 netsock2.c: == Using SIP RTP CoS mark 5
2013-05-18 08:11:24 VERBOSE2008C-00000085 pbx.c: — Executing 765@from-internal:1 Answer(“SIP/701-000000a4”, “”) in new stack
2013-05-18 08:11:24 VERBOSE2008C-00000085 pbx.c: — Executing 765@from-internal:2 Read(“SIP/701-000000a4”, “pin,conf-getpin,3,,1,10”) in new stack
2013-05-18 08:11:24 VERBOSE2008C-00000085 app_read.c: — Accepting a maximum of 3 digits.
2013-05-18 08:11:24 VERBOSE2008C-00000085 file.c: — Playing ‘conf-getpin.gsm’ (language ‘en’)
2013-05-18 08:11:26 VERBOSE2008C-00000085 app_read.c: — User entered ‘123’
2013-05-18 08:11:26 VERBOSE2008C-00000085 pbx.c: — Executing 765@from-internal:3 Set(“SIP/701-000000a4”, “total=0”) in new stack
2013-05-18 08:11:26 VERBOSE2008C-00000085 pbx.c: — Executing 765@from-internal:4 AGI(“SIP/701-000000a4”, “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:11:26 ERROR2008C-00000085 utils.c: write() returned error: Network is unreachable
2013-05-18 08:11:26 WARNING2008C-00000085 res_agi.c: Connect to ‘agi://192.168.1.219:9110/DatabaseQuery.agi?db=Embedded+Database&callbackApp=Gosub&query=GetOrders&callback=list_orders&as=54.235.112.69’ failed: Network is unreachable
2013-05-18 08:11:26 VERBOSE2008C-00000085 pbx.c: — Executing 765@from-internal:5 SayNumber(“SIP/701-000000a4”, “0,m”) in new stack
2013-05-18 08:11:26 VERBOSE2008C-00000085 file.c: — Playing ‘digits/0.gsm’ (language ‘en’)
2013-05-18 08:11:27 VERBOSE2008C-00000085 pbx.c: — Executing 765@from-internal:6 Hangup(“SIP/701-000000a4”, “”) in new stack
2013-05-18 08:11:27 VERBOSE2008C-00000085 pbx.c: == Spawn extension (from-internal, 765, 6) exited non-zero on ‘SIP/701-000000a4’
2013-05-18 08:11:27 VERBOSE2008C-00000085 pbx.c: — Executing h@from-internal:1 Hangup(“SIP/701-000000a4”, “”) in new stack
2013-05-18 08:11:27 VERBOSE2008C-00000085 pbx.c: == Spawn extension (from-internal, h, 1) exited non-zero on ‘SIP/701-000000a4’

am I supposed to somehow set up the database remotely?

Thanks

[Migrated from old forumParticipant April 5, 2015 at 11:21 am Post count: 327]

#5749 |

> 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 unreachable

According 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

[Migrated from old forumParticipant April 5, 2015 at 11:21 am Post count: 327]

#5750 |

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

[Migrated from old forumParticipant April 5, 2015 at 11:22 am Post count: 327]

#5751 |

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