Hi, I am running fs 1.10 on Debian 10 64bit. I have searched for help configuring FreeSwitch to use MySQL. I have configured db.conf.xml for Mysql: <param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=serveriphere;UID=userhere;PWD=passwordhere;DATABASE=freeswitch;OPTION=67108864" /> I have reloaded, restarted and rebooted. FreeSwitch continues to use sqlite. Is there more to configure? Do I need to install unixODBC and/or MySql driver? Here is the error: 2020-04-05 20:57:48.159620 [ERR] switch_odbc.c:368 STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib 'mysql' : file not found 2020-04-05 20:57:48.159658 [CRIT] switch_core_sqldb.c:646 Failure to connect to ODBC DRIVER=mysql;SERVER=127.0.0.1;UID=xxxxxx;PWD=XXXXXXXXXX;DATABASE=freeswitch;OPTION=67108864! 2020-04-05 20:57:48.160130 [CONSOLE] switch_loadable_module.c:1804 Successfully Loaded [mod_db] 2020-04-05 20:57:48.160146 [NOTICE] switch_loadable_module.c:350 Adding Application 'db'
does i_sql work? Have you installed libmysql client? Regards, David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337 On Sun, Apr 5, 2020 at 11:24 PM Sean Devoy <sdevoy@bizfocused.com> wrote:
Hi,
I am running fs 1.10 on Debian 10 64bit.
I have searched for help configuring FreeSwitch to use MySQL. I have configured db.conf.xml for Mysql:
<param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=serveriphere;UID=userhere;PWD=passwordhere;DATABASE=freeswitch;OPTION=67108864" />
I have reloaded, restarted and rebooted. FreeSwitch continues to use sqlite.
Is there more to configure?
Do I need to install unixODBC and/or MySql driver?
Here is the error:
2020-04-05 20:57:48.159620 [ERR] switch_odbc.c:368 STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib 'mysql' : file not found
2020-04-05 20:57:48.159658 [CRIT] switch_core_sqldb.c:646 Failure to connect to ODBC DRIVER=mysql;SERVER=127.0.0.1;UID=xxxxxx;PWD=XXXXXXXXXX;DATABASE=freeswitch;OPTION=67108864!
2020-04-05 20:57:48.160130 [CONSOLE] switch_loadable_module.c:1804 Successfully Loaded [mod_db]
2020-04-05 20:57:48.160146 [NOTICE] switch_loadable_module.c:350 Adding Application 'db' _________________________________________________________________________
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
Hello, You can either install both and configure them , or you can use this directly with mariadb <param name="core-db-dsn" value="mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=pass;" /> On Mon, Apr 6, 2020 at 1:26 AM Sean Devoy <sdevoy@bizfocused.com> wrote:
Hi,
I am running fs 1.10 on Debian 10 64bit.
I have searched for help configuring FreeSwitch to use MySQL. I have configured db.conf.xml for Mysql:
<param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=serveriphere;UID=userhere;PWD=passwordhere;DATABASE=freeswitch;OPTION=67108864" />
I have reloaded, restarted and rebooted. FreeSwitch continues to use sqlite.
Is there more to configure?
Do I need to install unixODBC and/or MySql driver?
Here is the error:
2020-04-05 20:57:48.159620 [ERR] switch_odbc.c:368 STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib 'mysql' : file not found
2020-04-05 20:57:48.159658 [CRIT] switch_core_sqldb.c:646 Failure to connect to ODBC DRIVER=mysql;SERVER=127.0.0.1;UID=xxxxxx;PWD=XXXXXXXXXX;DATABASE=freeswitch;OPTION=67108864!
2020-04-05 20:57:48.160130 [CONSOLE] switch_loadable_module.c:1804 Successfully Loaded [mod_db]
2020-04-05 20:57:48.160146 [NOTICE] switch_loadable_module.c:350 Adding Application 'db' _________________________________________________________________________
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
+1 The best choice On Mon, 6 Apr 2020 at 11:07, Vlad Toma <vldtoma@gmail.com> wrote:
Hello,
You can either install both and configure them , or you can use this directly with mariadb <param name="core-db-dsn" value="mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=pass;" />
On Mon, Apr 6, 2020 at 1:26 AM Sean Devoy <sdevoy@bizfocused.com> wrote:
Hi,
I am running fs 1.10 on Debian 10 64bit.
I have searched for help configuring FreeSwitch to use MySQL. I have configured db.conf.xml for Mysql:
<param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=serveriphere;UID=userhere;PWD=passwordhere;DATABASE=freeswitch;OPTION=67108864" />
I have reloaded, restarted and rebooted. FreeSwitch continues to use sqlite.
Is there more to configure?
Do I need to install unixODBC and/or MySql driver?
Here is the error:
2020-04-05 20:57:48.159620 [ERR] switch_odbc.c:368 STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib 'mysql' : file not found
2020-04-05 20:57:48.159658 [CRIT] switch_core_sqldb.c:646 Failure to connect to ODBC DRIVER=mysql;SERVER=127.0.0.1;UID=xxxxxx;PWD=XXXXXXXXXX;DATABASE=freeswitch;OPTION=67108864!
2020-04-05 20:57:48.160130 [CONSOLE] switch_loadable_module.c:1804 Successfully Loaded [mod_db]
2020-04-05 20:57:48.160146 [NOTICE] switch_loadable_module.c:350 Adding Application 'db' _________________________________________________________________________
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
_________________________________________________________________________
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
-- Regards, David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
Hi, If you go with unixODBC: 1) You need to install unixodbc (apt-get -y install unixodbc) 2) Install odbc connector for MariaDB, for me it worked only 2.0.* version on Debian 10 (wget https://downloads.mariadb.com/Connectors/odbc/connector-odbc-2.0.19/mariadb-... && tar -xvzf mariadb-co* && install lib/libmaodbc.so) 3) Configure odbc connector, something like this: https://mariadb.com/kb/en/creating-a-data-source-with-mariadb-connectorodbc/ 4) test if you can connect to MariaDB using isql command. At this point there will left only Freeswitch to configure. I believe you do not have installed unixodbc or odbc connector. Jurijs On Mon, Apr 6, 2020 at 1:56 PM David Villasmil < david.villasmil.work@gmail.com> wrote:
+1 The best choice
On Mon, 6 Apr 2020 at 11:07, Vlad Toma <vldtoma@gmail.com> wrote:
Hello,
You can either install both and configure them , or you can use this directly with mariadb <param name="core-db-dsn" value="mariadb://Server=localhost;Database=freeswitch;Uid=freeswitch;Pwd=pass;" />
On Mon, Apr 6, 2020 at 1:26 AM Sean Devoy <sdevoy@bizfocused.com> wrote:
Hi,
I am running fs 1.10 on Debian 10 64bit.
I have searched for help configuring FreeSwitch to use MySQL. I have configured db.conf.xml for Mysql:
<param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=serveriphere;UID=userhere;PWD=passwordhere;DATABASE=freeswitch;OPTION=67108864" />
I have reloaded, restarted and rebooted. FreeSwitch continues to use sqlite.
Is there more to configure?
Do I need to install unixODBC and/or MySql driver?
Here is the error:
2020-04-05 20:57:48.159620 [ERR] switch_odbc.c:368 STATE: 01000 CODE 0 ERROR: [unixODBC][Driver Manager]Can't open lib 'mysql' : file not found
2020-04-05 20:57:48.159658 [CRIT] switch_core_sqldb.c:646 Failure to connect to ODBC DRIVER=mysql;SERVER=127.0.0.1;UID=xxxxxx;PWD=XXXXXXXXXX;DATABASE=freeswitch;OPTION=67108864!
2020-04-05 20:57:48.160130 [CONSOLE] switch_loadable_module.c:1804 Successfully Loaded [mod_db]
2020-04-05 20:57:48.160146 [NOTICE] switch_loadable_module.c:350 Adding Application 'db' _________________________________________________________________________
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
_________________________________________________________________________
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
-- Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337 _________________________________________________________________________
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
participants (4)
-
David Villasmil
-
Jurijs Ivolga
-
Sean Devoy
-
Vlad Toma