Talking around the World

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((n' at line 8 query: SELECT DISTINCT (((1 * (MATCH(node_revisions.title) AGAINST('Integracion de un sistema de TTS Text to Speech en Asterisk - Cepstral Actualizado 11 Septiembre 2009 Un programa TTS (Text to Speech), entre otras cosas, transforma un texto en voz. En el caso de Asterisk esto es posible usando Festival.&nbsp; Para que el modulo venga correctamente instalado, antes de compilar asterisk tenemos que instalar el programa y sus fuentes. yum install festival festival-devel Compilamos y ya. No se si alguien logr&oacute; alcanzar un nivel de s&iacute;ntesis vocal bueno. Yo la verdad no. Es por eso que prefer&iacute; probar Cepstral, otro sistema de TTS que se puede integrar en asterisk (versi&oacute;n 1.4 y 1.6) gracias a un modulo dedicado. Antes que nada hay que decir que Cepstral no es un programa gratuito y que cada voz cuesta 29,99 d&oacute;lares. El modulo para la integraci&oacute;n de Cepstral en Asterisk lo escribi&oacute; y lo actualiza Darren Sessions. Primero descargamos una voz de prueba en el sitio de Cepstral (en mi caso para Linux 64bit) cd /opt wget http://downloads.cepstral.com/cepstral/x86-64-linux/Cepstral_Marta-8kHz_x86-64-linux_5.1.0.tar.gz La descomprimimos tar -xf Cepstral_Marta-8kHz_x86-64-linux_5.1.0.tar.gz y la instalamos cd Cepstral_Marta-8kHz_x86-64-linux_5.1.0 ./install.sh Aceptamos la licencia, escogemos la carpeta /opt/swift para la instalaci&oacute;n y confirmamos los datos. Ahora tenemos que decirle a Linux donde buscar las librer&iacute;as del programa. abrimos el archivo ld.so.conf nano /etc/ld.so.conf a&ntilde;adimos una l&iacute;nea /opt/swift/lib Guardamos y actualizamos ldconfig -v Listo. Ahora tenemos que instalar el modulo para asterisk cd /usr/src Para asterisk 1.4.X wget http://www.voztovoice.org/tmp/app_swift-1.4.2.tar.gz Para Asterisk 1.6.X wget http://www.voztovoice.org/tmp/app_swift-1.6.2.tar.gz lo descomprimimos tar -xf app_swift-1.6.2.tar.gz Entramos en la carpeta: cd app_swift-1.6.2 compilamos y instalamos make make install Paramos y volvemos a arrancar asterisk /etc/init.d/asterisk stop /etc/init.d/asterisk start y averiguamos que el modulo est&eacute; cargado asterisk -rvvvvvvvvvvv CLI> module show like app_s Module&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Description&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Use Count app_sayunixtime.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Say time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_sendtext.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Send Text Applications&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_senddtmf.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Send DTMF digits Application&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_swift.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cepstral Swift TTS Application&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_setcallerid.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set CallerID Presentation Application&nbsp;&nbsp;&nbsp; 0 app_system.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Generic System() application&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_softhangup.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hangs up the requested channel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_saycountpl.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Say polish counting words&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_sms.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SMS/PSTN handler&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_speech_utils.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dialplan Speech Applications&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_stack.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dialplan subroutines (Gosub, Return, etc 0 11 modules loaded La sinopsis del comando CLI> core show application swift &nbsp; -= Info about application \'Swift\' =- [Synopsis] Speak text through Swift text-to-speech engine. [Description] Syntax: Swift(text[|timeout in ms|maximum digits]) Example: Swift(Hello World|5000|5) = 5 second delay between 5 digits This application operates in two modes. One is processing text-to-speech while listening for DTMF and the other just processes the text-to-speech while ignoring DTMF entirely. Unless the timeout and maximum digits options are BOTH specified, the application will automatically ignore DTMF. Returns -1 on hangup or 0 otherwise. salimos de la consola: CLI> quit En la carpeta donde est&aacute;n los archivos de configuraci&oacute;n de asterisk encontraremos un nuevo archivo: swift.conf. Tenemos que modificarlo para terminar la integraci&oacute;n de Cepstral en Asterisk nano /etc/asterisk/swift.conf [general] buffer_size=65535 goto_exten=yes voice=Marta-8kHz Guardamos los cambios y actualizamos asterisk /etc/init.d/asterisk reload Quitamos y volvemos a cargar el modulo (por las moscas) asterisk -rvvvvvvvvvvvvvvvvvvvvvv *CLI> module unload app_swift &nbsp; == Unregistered application \'Swift\' CLI> module load app_swift &nbsp; == Registered application \'Swift\' &nbsp; == Parsing \'/etc/asterisk/swift.conf\':&nbsp;&nbsp; == Found [Oct 25 17:05:15] DEBUG[11038]: app_swift.c:545 load_module: Config buffer_size is 65535 [Oct 25 17:05:15] DEBUG[11038]: app_swift.c:552 load_module: Config goto_exten is 1 [Oct 25 17:05:15] DEBUG[11038]: app_swift.c:557 load_module: Config voice is Miguel-8kHz Loaded app_swift => (Cepstral Swift TTS Application) Salimos de la consola: CLI>&nbsp;quit Ahora probamos la instalaci&oacute;n en nuestra centralita. Creamos estas l&iacute;neas en extension.conf (en el contexto donde llegan todas las llamadas externas) nano /etc/asterisk/extensions.conf exten => s,1,Answer() exten => s,n,Playback(welcome) exten => s,n,Swift(En el centro de comunicaciones de VoztoVoice. Espere mientras lo conectamos con una operadora) exten => s,n,Wait(2) exten => s,n,Hangup Guardamos y actualizamos el dialplan asterisk -rvvvvvvvv CLI> dialplan reload Ahora desde su softphone hagan sus pruebas y me comentan.'))) + (1 * (MATCH(node_revisions.body) AGAINST('Integracion de un sistema de TTS Text to Speech en Asterisk - Cepstral Actualizado 11 Septiembre 2009 Un programa TTS (Text to Speech), entre otras cosas, transforma un texto en voz. En el caso de Asterisk esto es posible usando Festival.&nbsp; Para que el modulo venga correctamente instalado, antes de compilar asterisk tenemos que instalar el programa y sus fuentes. yum install festival festival-devel Compilamos y ya. No se si alguien logr&oacute; alcanzar un nivel de s&iacute;ntesis vocal bueno. Yo la verdad no. Es por eso que prefer&iacute; probar Cepstral, otro sistema de TTS que se puede integrar en asterisk (versi&oacute;n 1.4 y 1.6) gracias a un modulo dedicado. Antes que nada hay que decir que Cepstral no es un programa gratuito y que cada voz cuesta 29,99 d&oacute;lares. El modulo para la integraci&oacute;n de Cepstral en Asterisk lo escribi&oacute; y lo actualiza Darren Sessions. Primero descargamos una voz de prueba en el sitio de Cepstral (en mi caso para Linux 64bit) cd /opt wget http://downloads.cepstral.com/cepstral/x86-64-linux/Cepstral_Marta-8kHz_x86-64-linux_5.1.0.tar.gz La descomprimimos tar -xf Cepstral_Marta-8kHz_x86-64-linux_5.1.0.tar.gz y la instalamos cd Cepstral_Marta-8kHz_x86-64-linux_5.1.0 ./install.sh Aceptamos la licencia, escogemos la carpeta /opt/swift para la instalaci&oacute;n y confirmamos los datos. Ahora tenemos que decirle a Linux donde buscar las librer&iacute;as del programa. abrimos el archivo ld.so.conf nano /etc/ld.so.conf a&ntilde;adimos una l&iacute;nea /opt/swift/lib Guardamos y actualizamos ldconfig -v Listo. Ahora tenemos que instalar el modulo para asterisk cd /usr/src Para asterisk 1.4.X wget http://www.voztovoice.org/tmp/app_swift-1.4.2.tar.gz Para Asterisk 1.6.X wget http://www.voztovoice.org/tmp/app_swift-1.6.2.tar.gz lo descomprimimos tar -xf app_swift-1.6.2.tar.gz Entramos en la carpeta: cd app_swift-1.6.2 compilamos y instalamos make make install Paramos y volvemos a arrancar asterisk /etc/init.d/asterisk stop /etc/init.d/asterisk start y averiguamos que el modulo est&eacute; cargado asterisk -rvvvvvvvvvvv CLI> module show like app_s Module&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Description&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Use Count app_sayunixtime.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Say time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_sendtext.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Send Text Applications&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_senddtmf.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Send DTMF digits Application&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_swift.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cepstral Swift TTS Application&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_setcallerid.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set CallerID Presentation Application&nbsp;&nbsp;&nbsp; 0 app_system.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Generic System() application&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_softhangup.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hangs up the requested channel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_saycountpl.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Say polish counting words&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_sms.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SMS/PSTN handler&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_speech_utils.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dialplan Speech Applications&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 app_stack.so&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dialplan subroutines (Gosub, Return, etc 0 11 modules loaded La sinopsis del comando CLI> core show application swift &nbsp; -= Info about application \'Swift\' =- [Synopsis] Speak text through Swift text-to-speech engine. [Description] Syntax: Swift(text[|timeout in ms|maximum digits]) Example: Swift(Hello World|5000|5) = 5 second delay between 5 digits This application operates in two modes. One is processing text-to-speech while listening for DTMF and the other just processes the text-to-speech while ignoring DTMF entirely. Unless the timeout and maximum digits options are BOTH specified, the application will automatically ignore DTMF. Returns -1 on hangup or 0 otherwise. salimos de la consola: CLI> quit En la carpeta donde est&aacute;n los archivos de configuraci&oacute;n de asterisk encontraremos un nuevo archivo: swift.conf. Tenemos que modificarlo para terminar la integraci&oacute;n de Cepstral en Asterisk nano /etc/asterisk/swift.conf [general] buffer_size=65535 goto_exten=yes voice=Marta-8kHz Guardamos los cambios y actualizamos asterisk /etc/init.d/asterisk reload Quitamos y volvemos a cargar el modulo (por las moscas) asterisk -rvvvvvvvvvvvvvvvvvvvvvv *CLI> module unload app_swift &nbsp; == Unregistered application \'Swift\' CLI> module load app_swift &nbsp; == Registered application \'Swift\' &nbsp; == Parsing \'/etc/asterisk/swift.conf\':&nbsp;&nbsp; == Found [Oct 25 17:05:15] DEBUG[11038]: app_swift.c:545 load_module: Config buffer_size is 65535 [Oct 25 17:05:15] DEBUG[11038]: app_swift.c:552 load_module: Config goto_exten is 1 [Oct 25 17:05:15] DEBUG[11038]: app_swift.c:557 load_module: Config voice is Miguel-8kHz Loaded app_swift => (Cepstral Swift TTS Application) Salimos de la consola: CLI>&nbsp;quit Ahora probamos la instalaci&oacute;n en nuestra centralita. Creamos estas l&iacute;neas en extension.conf (en el contexto donde llegan todas las llamadas externas) nano /etc/asterisk/extensions.conf exten => s,1,Answer() exten => s,n,Playback(welcome) exten => s,n,Swift(En el centro de comunicaciones de VoztoVoice. Espere mientras lo conectamos con una operadora) exten => s,n,Wait(2) exten => s,n,Hangup Guardamos y actualizamos el dialplan asterisk -rvvvvvvvv CLI> dialplan reload Ahora desde su softphone hagan sus pruebas y me comentan.')))) / 2) AS score, node.title AS node_title, node.nid AS nid, node.language AS node_language FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status = 1) AND (node_revisions.nid <> 61) INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) GROUP BY score, node_title, nid, node_language HAVING score > (1) ORDER BY score DESC LIMIT 0, 8 in /home/voztovoice/public_html/modules/views/plugins/views_plugin_query_default.inc on line 1150.