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

in reply to: SQL not inserting variables #5732 |

Chrisbarr,

We need more details on this so we could help.
How the query looks like, what type of data this query should return…

Bernard

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

in reply to: MYSQL Queries #5730 |

Amir,

If I understand this correctly you don’t need two queries.
If you wish to obtain username and id from cc_user table, you just need #2 query.
Use this query “select username,id from cc_user where username=${pin}” and in “Edit DbQuery” window select “mysql-pin” and “ID” variables under the “Variables” section, this way “username” will be stored in “mysql-pin” and “id” in “ID” variable.

Raman

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

in reply to: MYSQL Queries #5729 |

Thanks it works. but I need to get other data from same table also and store it in other variables ,

Here is my current query , and this query will save only pin in mysql-pin variables in visual dial plan, how can I
run other query (#2) and store ping in mysql-pin and ID in ID variables in mysql Embedded IS.” I mean to add data from mysql to two different variables in VD.

@@${pin}=5513563105
select username from cc_user where username=${pin}

Query #2

@@${pin}=5513563105
select username,id from cc_user where username=${pin}

thanks,

Amir

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

in reply to: MYSQL Queries #5728 |

Aaboonasr,

Check this tutorial, it explains how to create and use SELECT statement http://www.w3schools.com/sql/sql_select.asp.

Also, read this tutorial
http://www.apstel.com/visual-dialplan-tutorials/database-connectivity/

It explains how to use IS and how to create and execute sql queries. It also contains a simple example on how to use dial plan variables within SQL query.

You should be able to create the query after reading this tutorials.

Raman

• This reply was modified 10 years, 6 months ago by  admin.

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

in reply to: DBQuery component is not executing a working query in IS #5726 |

Robert,

can you upload Integration Server log file (located in the log folder under the folder where you installed IS) so we could have more information about that issue?

Raman

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

in reply to: Text to Speech Engine #5724 |

Hello JamesArturo,

I used Festival with VDP a while ago and it worked.

I think the issue you are facing here is that you didn’t setup Festival with Asterisk.
The easiest way to setup Festival with Asterisk is to modify the festival configuration file.
Find the file festival.scm (should be in /etc, may also be hidden in /usr/share/festival, /usr/lib/festival or /usr/local/lib/festival) and add this command to it:

;; Enable access to localhost (needed by debian users)
(set! server_access_list ‘(“localhost\\.localdomain” “localhost”))

;; set italian voice
;;(language_italian)
;;(set! voice_default ‘voice_pc_diphone)

;;; Command for Asterisk begin

(define (tts_textasterisk string mode)
“(tts_textasterisk STRING MODE)
Apply tts to STRING. This function is specifically designed for
use in server mode so a single function call may synthesize the string.
This function name may be added to the server safe functions.”
(let ((wholeutt (utt.synth (eval (list ‘Utterance ‘Text string)))))
(utt.wave.resample wholeutt 8000)
(utt.wave.rescale wholeutt 5)
(utt.send.wave.client wholeutt)))

;;; Command for Asterisk end

Place this code anywhere within that file, except between other parentheses.
Then restart the Festival server.

Now, it should work.

Raman

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

in reply to: Call dropping during IS data query #5722 |

Arturo,

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

Raman

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

in reply to: Call dropping during IS data query #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]

in reply to: Call dropping during IS data query #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:04 am Post count: 327]

in reply to: Deploy error #5718 |

Lcastellanos,

You should try this workaround from Apstel FAQ section.

I got error message ‘Deploy to the Integration Server Embedded IS failed’ when I tried to deploy the dial plan.
Solution:
This usually happens if your name server is not configured properly.
The work around is to properly set hosts on your Linux mahcine. Try with the following work around:
1. open “/etc/hosts” file
2. enter the following tree lines:
127.0.0.1 localhost.localdomain localhost
127.0.0.1 localhost.localdomain YourHostName
::1 localhost6.localdomain6 localhost6
3. reset your network settings:
service network restart

Make sure to change YourHostName with appropriate host name, your host name.
The most common means to find your host name is to open up a terminal window and enter the command: hostname

If this does not help then you should probably contact Apstel support.

Bernard

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

in reply to: Not connecting #5716 |

This could also be an issue with firewall or database privileges.

I hope this have been of some help to you.

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

in reply to: Not connecting #5715 |

Agustinux,

IS blocks require that you answer the channel first, so my question is did you put the answer block at the beginning of the dial plan callflow?
Also, it would help if we could see the dial plan and asterisk log.

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

in reply to: Licensing #5713 |

Lee,

There are no separate/upgrade licenses, you will just order another lot of 10 licenses and add it to the IS.

Michael Denich
Apstel support team

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

in reply to: Licensing #5712 |

Lee,

Feel free to start with 10 licenses and if your needs grow and you want to handle 20 concurrent calls with your dial plan, you will
need to purchase 10 additional licenses.

Michael Denich
Apstel support team

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

in reply to: Licensing #5711 |

Michael,

Thanks again!

If I start off with 10 licenses and want to upgrade to 20 do I just order another lot of 10 and add these or are there separate upgrade licenses?

Thanks,

Lee