[Freeswitch-users] How can I use an external database to create new users?

Tue Sep 26 06:41:41 UTC 2017

Hi Bipin,

I found this tutorial searching about the comment of other response:
https://github.com/intralanman/fs_curl   (It's looks fine but I think that
are too complex)

I just look for the way to force FS to load and register users (previously
created) from a database. The dialplan and others configuration must be
used as usual (from XML configuration files).

Can you explain me in more detail your solution and pass me the register
script? Thanks!

José David Jurado Alonso <josedavid at zennio.com>

*Área de Desarrollo de Software de Alto Nivel*

*Dpto. Ingeniería*

[image: Descripción: cid:image010.jpg at 01D27631.DF7E30F0]

Zennio Avance y Tecnología, S.L.

C/ Rio Jarama,132. Nave P-8.11

45007 - Toledo (Spain)

T: +34 925 232 002

www.zennio.com

[image: Descripción: Descripción: C:\Users\jjmanjarres\Desktop\Z zennio.jpg]
<http://www.zennio.com/> [image: Descripción: Descripción:
C:\Users\jjmanjarres\Desktop\twitter.jpg] <http://www.twitter.com/Zennio_en>
 [image: Descripción: Descripción:
C:\Users\jjmanjarres\Desktop\descarga.jpg]
<http://www.facebook.com/ZennioInternational> [image: Descripción:
Descripción: C:\Users\jjmanjarres\Desktop\linkedin.png]
<http://www.linkedin.com/company/zennio> [image: Descripción: Descripción:
C:\Users\jjmanjarres\Desktop\youtube.jpg]
<https://www.youtube.com/user/ZennioEnglish>

Zennio Avance y Tecnología S.L le informa de los siguientes extremos:
Los datos por usted suministrados pasarán a formar parte de un fichero cuyo
responsable es Zennio Avance y Tecnología S.L. Dicho fichero se encuentra
legalmente inscrito en el Registro General de Protección de Datos de la
Agencia Española de Protección de Datos. Los datos por usted suministrados
serán empleados con fines de gestión, Zennio Avance y Tecnología S.L ha
adoptado las medidas de seguridad exigidas en función del nivel de los
datos suministrados, instalando las medidas técnicas y organizativas
necesarias, habida cuenta del estado de la tecnología, a fin de evitar su
pérdida, alteración, uso inadecuado o accesos no autorizados a los mismos.
Para el ejercicio de sus derechos de acceso, rectificación, cancelación y
oposición deberá dirigirse a la dirección del Responsable de Fichero Zennio
Avance y Tecnología S.L C/ Rio Jarama, 132. Nave P-8.11, 45007, TOLEDO o a
la dirección de correo electrónico: info at zennio.com

Please, consider the environment before printing this e-mail... Save energy!

Por favor, piensa en el medio ambiente antes de imprimir este e-mail... ¡Ahorra
energía!

Disclaimer:
This message and any attached files transmitted with it, is confidential,
especially as regards personal data. It is intended solely for the use of
the individual or entity to whom it is addressed. If you are not the
intended recipient and have received this information in error or have
accessed it for any reason, please notify us of this fact by email reply
and then destroy or delete the message, refraining from any reproduction,
use, alteration, filing or communication to third parties of this message
and attached files on penalty of incurring legal responsibilities. The
opinions contained in this message and the attached archives, belong
exclusively to their sender and they do not represent the opinion of the
company unless it is said specifically and the sender is authorized for it.
The sender does not guarantee the integrity, the accuracy, the swift
delivery or the security of this email transmission, and assumes no
responsibility for any possible damage incurred through data capture, virus
incorporation or any manipulation carried out by third parties.

Advertencia legal:
Este mensaje y, en su caso, los ficheros anexos son confidenciales,
especialmente en lo que respecta a los datos personales, y se dirigen
exclusivamente al destinatario referenciado. Si usted no lo es y lo ha
recibido por error o tiene conocimiento del mismo por cualquier motivo, le
rogamos que nos lo comunique por este medio y proceda a destruirlo o
borrarlo, y que en todo caso se abstenga de utilizar, reproducir, alterar,
archivar o comunicar a terceros el presente mensaje y ficheros anexos, todo
ello bajo pena de incurrir en responsabilidades legales. Las opiniones
contenidas en este mensaje y en los archivos adjuntos, pertenecen
exclusivamente a su remitente y no representan la opinión de la empresa
salvo que se diga expresamente y el remitente esté autorizado para ello. El
emisor no garantiza la integridad, rapidez o seguridad del presente correo,
ni se responsabiliza de posibles perjuicios derivados de la captura,
incorporaciones de virus o cualesquiera otras manipulaciones efectuadas por
terceros.

2017-09-25 15:44 GMT+02:00 Bipin Patel <bipin at xbipin.com>:

> hi,
>
> we use a different switch with its db running on mysql but sadly that
> doesnt supports tls and srtp so we use freeswitch for that so users
> register to FS and we use xml curl for directory users where FS calls a php
> script which inturn fetches the id/pass of the user and returns it to FS
> which then allows users to register to FS. The script is only called when
> users register to FS, its quiet simple if u ask me.
>
>
> Regards,
> Bipin
>
>
> ------------------------------
> -------- Original Message --------
> Subject: Re: [Freeswitch-users] How can I use an external database to
> create new users?
> From: Igor Olhovskiy <igorolhovskiy at gmail.com> <igorolhovskiy at gmail.com>
> To: Thorsten Göllner <tg-maillistings at level5.de>
> <tg-maillistings at level5.de>, FreeSWITCH Users Help
> <freeswitch-users at lists.freeswitch.org>
> <freeswitch-users at lists.freeswitch.org>
> Date: 9/25/2017, 5:05:45 PM
>
> mod_xml_curl will ask some http server with username and domain and will
> require as a response XML-formatted directory entry.
> So you need to write some intermediate layer, that will on request go to
> database and provide back info in necessary format.
>
> Regards, Igor
>
> On 25 сент. 2017 г., 14:22 +0300, Jose David Jurado Alonso
> <josedavid at zennio.com> <josedavid at zennio.com>, wrote:
>
> Hi,
>
> Yes, but I need a custom web app to users management.
>
> I tried using postgresql as core-db-dsn and I work properly in some cases
> (register appears) but no show any about users.
>
> José David Jurado Alonso <josedavid at zennio.com>
>
> *Área de Desarrollo de Software de Alto Nivel*
>
> *Dpto. Ingeniería*
>
> [image: Descripción: cid:image010.jpg at 01D27631.DF7E30F0]
>
> Zennio Avance y Tecnología, S.L.
>
> C/ Rio Jarama,132. Nave P-8.11
>
> 45007 - Toledo (Spain)
>
> T: +34 925 232 002 <+34%20925%2023%2020%2002>
>
> www.zennio.com
>
> [image: Descripción: Descripción: C:\Users\jjmanjarres\Desktop\Z
> zennio.jpg] <http://www.zennio.com/> [image: Descripción: Descripción:
> C:\Users\jjmanjarres\Desktop\twitter.jpg]
> <http://www.twitter.com/Zennio_en> [image: Descripción: Descripción:
> C:\Users\jjmanjarres\Desktop\descarga.jpg]
> <http://www.facebook.com/ZennioInternational> [image: Descripción:
> Descripción: C:\Users\jjmanjarres\Desktop\linkedin.png]
> <http://www.linkedin.com/company/zennio> [image: Descripción:
> Descripción: C:\Users\jjmanjarres\Desktop\youtube.jpg]
> <https://www.youtube.com/user/ZennioEnglish>
>
> Zennio Avance y Tecnología S.L le informa de los siguientes extremos:
> Los datos por usted suministrados pasarán a formar parte de un fichero
> cuyo responsable es Zennio Avance y Tecnología S.L. Dicho fichero se
> encuentra legalmente inscrito en el Registro General de Protección de Datos
> de la Agencia Española de Protección de Datos. Los datos por usted
> suministrados serán empleados con fines de gestión, Zennio Avance y
> Tecnología S.L ha adoptado las medidas de seguridad exigidas en función del
> nivel de los datos suministrados, instalando las medidas técnicas y
> organizativas necesarias, habida cuenta del estado de la tecnología, a fin
> de evitar su pérdida, alteración, uso inadecuado o accesos no autorizados a
> los mismos.
> Para el ejercicio de sus derechos de acceso, rectificación, cancelación y
> oposición deberá dirigirse a la dirección del Responsable de Fichero Zennio
> Avance y Tecnología S.L C/ Rio Jarama, 132. Nave P-8.11, 45007, TOLEDO o a
> la dirección de correo electrónico: info at zennio.com
>
> Please, consider the environment before printing this e-mail... Save
> energy!
>
> Por favor, piensa en el medio ambiente antes de imprimir este e-mail... ¡Ahorra
> energía!
>
> Disclaimer:
> This message and any attached files transmitted with it, is confidential,
> especially as regards personal data. It is intended solely for the use of
> the individual or entity to whom it is addressed. If you are not the
> intended recipient and have received this information in error or have
> accessed it for any reason, please notify us of this fact by email reply
> and then destroy or delete the message, refraining from any reproduction,
> use, alteration, filing or communication to third parties of this message
> and attached files on penalty of incurring legal responsibilities. The
> opinions contained in this message and the attached archives, belong
> exclusively to their sender and they do not represent the opinion of the
> company unless it is said specifically and the sender is authorized for it.
> The sender does not guarantee the integrity, the accuracy, the swift
> delivery or the security of this email transmission, and assumes no
> responsibility for any possible damage incurred through data capture, virus
> incorporation or any manipulation carried out by third parties.
>
> Advertencia legal:
> Este mensaje y, en su caso, los ficheros anexos son confidenciales,
> especialmente en lo que respecta a los datos personales, y se dirigen
> exclusivamente al destinatario referenciado. Si usted no lo es y lo ha
> recibido por error o tiene conocimiento del mismo por cualquier motivo, le
> rogamos que nos lo comunique por este medio y proceda a destruirlo o
> borrarlo, y que en todo caso se abstenga de utilizar, reproducir, alterar,
> archivar o comunicar a terceros el presente mensaje y ficheros anexos, todo
> ello bajo pena de incurrir en responsabilidades legales. Las opiniones
> contenidas en este mensaje y en los archivos adjuntos, pertenecen
> exclusivamente a su remitente y no representan la opinión de la empresa
> salvo que se diga expresamente y el remitente esté autorizado para ello. El
> emisor no garantiza la integridad, rapidez o seguridad del presente correo,
> ni se responsabiliza de posibles perjuicios derivados de la captura,
> incorporaciones de virus o cualesquiera otras manipulaciones efectuadas por
> terceros.
>
> 2017-09-25 12:44 GMT+02:00 Thorsten Göllner <tg-maillistings at level5.de>:
>
>> Hi,
>>
>> did you take a look at existing (Web)Guis like FusionPBX?
>>
>> https://www.fusionpbx.com/
>>
>> Thorsten
>>
>>
>> Am 25.09.2017 um 10:28 schrieb Jose David Jurado Alonso:
>>
>> Hi,
>>
>> I'm thinking to create a web application to create, edit and delete users
>> in a simpler way than creating XML by hand but I don't find information
>> about it.
>>
>> I've seen something about the module "mod_xml_curl" but I'm not sure how
>> it interacts with the database nor if it's necessary some additional module
>> more.
>>
>> I would like to use MySQL or postgreSQL, does anyone know how you can do
>> it or some tutorial or reference application?
>>
>> Thanks,
>>
>> José D.
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>>
>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>>
>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>>
>>
>>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 966 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 8B4A4DDC14194DCE894E7C7028D43C6D.png
Type: image/png
Size: 2503 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 1196 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 523FFCFF7BF046C1B5CFA91015D2762F.png
Type: image/png
Size: 3473 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 1006 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0005.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.jpg
Type: image/jpeg
Size: 1135 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0006.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 84B30DD7B9644095B89314DE97B86FD8.png
Type: image/png
Size: 2955 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 1024 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0007.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: E76187EDEE97489A8488840449B6E462.png
Type: image/png
Size: 1121 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 1D0CFFE6F50B4129BE6BF73A214643FC.png
Type: image/png
Size: 2374 bytes
Desc: not available
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170926/5bd21387/attachment-0011.png>