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

#5719 |

I am making a database query to a Postgresql table with the dbQuery Component returning the values to a Macro using the Result Set: ${arg-name} example shown in the help documentation. Every thing validates and deploys successfully. But the call is dropped during the query. The component build code is:

AGI(agi://myserver:9111/DatabaseQuery.agi?
db=OUSA+Student+Data+Table&callbackApp=Gosub&query=getDataWithStudentID&callback=getStudentData)
GotoIf($”${AJ_AGISTATUS}” = “FAILED”?:)

Are there any vdp logs that will tell me what the error might be? Everything is wired up correctly. Are there any logs that will tell me what went wrong. VDP is a great tool, but I need to make this Database Integration work or it would be all for naught.

Thanks,

Arturo

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

#5720 |

I created a test dialplan with a simple query that worked. Added it to my dialplan and nothing changed. It turns out that my extension.conf file was not getting updated from the extension_vdp.conf file which had all my changes in it. So I replaced the extension.conf file with VDP file, restarted asterisk and everything worked. So, my question is: How do I get VDP to update my asterisk extensions file reliably?

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

#5721 |

Hello Arturo,

You may check IS log by using the Integration Server administrative web interface which can be accessed at the following URL:
http://Integration-Server-Host:9111
Maintenance tab.

extensions_vdp.conf is included in extensions.conf file so there is no need to update anything.
Did you save the changes to the dial plan before hitting a deploy button?

Also, what Asterisk server do you use?

Raman

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

#5722 |

Arturo,

you may also consider uploading the IS log file so we could take a look at the issue part.

Raman