Hi, I am using the latest Debian distro. I am proficient with SQL. How can I access the data that has been inserted using application="db" data="insert/..."? I am fine to use either a command line login or XML dial plan? If it is by command line I will need some help getting connected/authenticated. I don't even know which database the default distro uses. Thanks, Sean
By default, mod_db uses sqlite to store data, so you can access these files, usually on /usr/local/freeswitch/db (when manually compiled). You can also configure mod_db to store on another database engine, such as PostgreSQL or MySQL (or MariaDB). This configuration is done at [fs_config_path]/autoload_configs/db.conf.xml. Once its on your preferred db engine, you can access the way you want. Em dom, 25 de ago de 2019 às 20:59, Sean Devoy <sdevoy@bizfocused.com> escreveu:
Hi,
I am using the latest Debian distro. I am proficient with SQL. How can I access the data that has been inserted using application=”db” data=”insert/…”?
I am fine to use either a command line login or XML dial plan? If it is by command line I will need some help getting connected/authenticated. I don’t even know which database the default distro uses.
Thanks,
Sean _________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
-- *Carlos E. Wagner* *Tecnólogo em Telecomunicações, OCP, dCAA* *E-mail:* *kaduww@gmail.com <kaduww@gmail.com>* *Fone:* +55 48 9981-0894 *Skype:* carlos.e.wagner www.blogdovoip.com
Sorry for the late follow up, Thanks for the reply. Db.conf contains only a single comment. <!--<param name="odbc-dsn" value="dsn:user:pass"/>--> The is no /usr/local/freeswitch. ??? Thanks, Sean From: FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> On Behalf Of Carlos Eduardo Sent: Sunday, August 25, 2019 9:32 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] mod_db values By default, mod_db uses sqlite to store data, so you can access these files, usually on /usr/local/freeswitch/db (when manually compiled). You can also configure mod_db to store on another database engine, such as PostgreSQL or MySQL (or MariaDB). This configuration is done at [fs_config_path]/autoload_configs/db.conf.xml. Once its on your preferred db engine, you can access the way you want. Em dom, 25 de ago de 2019 às 20:59, Sean Devoy <sdevoy@bizfocused.com<mailto:sdevoy@bizfocused.com>> escreveu: Hi, I am using the latest Debian distro. I am proficient with SQL. How can I access the data that has been inserted using application=”db” data=”insert/…”? I am fine to use either a command line login or XML dial plan? If it is by command line I will need some help getting connected/authenticated. I don’t even know which database the default distro uses. Thanks, Sean _________________________________________________________________________ The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform. Join our online community to chat in real time https://signalwire.community Professional FreeSWITCH Services sales@freeswitch.com<mailto:sales@freeswitch.com> https://freeswitch.com Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org<mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com -- Carlos E. Wagner Tecnólogo em Telecomunicações, OCP, dCAA E-mail: kaduww@gmail.com<mailto:kaduww@gmail.com> Fone: +55 48 9981-0894 Skype: carlos.e.wagner www.blogdovoip.com<http://www.blogdovoip.com>
participants (2)
-
Carlos Eduardo
-
Sean Devoy