<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>I just finished getting out of using mysql with ODBC driver on
FS. If you have the option, strongly recommend moving to the
mariadb support in 1.8. <br>
</p>
I had an .odbcinst.ini in freeswitch user homedir or possibly
/etc/odbcinst.init file containing:
<p>[freeswitch]<br>
Driver =
/local/fslibs/install/lib/libmyodbc5a.so (path to
your libmyodbc lib file)<br>
SERVER = serverfqdn (this is optional)<br>
PORT = 3306<br>
DATABASE = databasename (optional)<br>
OPTION = 67108864<br>
</p>
<p>Then the dsn I previously used was:</p>
<p> odbc://INSTANCE:USER:PASSWORD<br>
</p>
<p>where INSTANCE = the "freeswitch" in the odbcinst.init, USER =
the userid on database, PASSWORD = password on db</p>
<p><br>
</p>
<p>mariadb support is much simpler, no extra setup, just use dsn
like:</p>
<p><br>
</p>
<p>
mariadb://Server=serverfqdn;Database=databasname;Uid=userid;Pwd=password;:<br>
</p>
<p><br>
</p>
<p>and yes, you want that ;: at the end)<br>
</p>
<p><br>
</p>
<p>-- Nathan<br>
</p>
<div class="moz-cite-prefix">On 2/14/20 5:31 PM, Joli Martinez
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CANeteifmeqsO7d-Fkhk1Jgek1Ar=Q_Em6aY6V3uPHo63e7Ezqw@mail.gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">I have tried the following code in the
switch.conf.xml file and did not work. I went ahead and
have followed the instructions in the link below, but I
can't seem to access the "<a
href="https://freeswitch.org/confluence/pages/editpage.action?pageId=6586653#UsingODBCinthecore-CompileFreeSWITCHwithODBCsupport"
rel="nofollow"
style="color:rgb(0,82,204);font-family:-apple-system,BlinkMacSystemFont,"Segoe
UI",Roboto,Oxygen,Ubuntu,"Fira
Sans","Droid Sans","Helvetica
Neue",sans-serif;font-size:14px"
moz-do-not-send="true">Compile FreeSWITCH with ODBC
Support</a><font face="-apple-system,
BlinkMacSystemFont, Segoe UI, Roboto, Oxygen, Ubuntu,
Fira Sans, Droid Sans, Helvetica Neue, sans-serif"
color="#172b4d"><span style="font-size:14px">"
section.</span></font></div>
<div dir="ltr"><font face="-apple-system,
BlinkMacSystemFont, Segoe UI, Roboto, Oxygen, Ubuntu,
Fira Sans, Droid Sans, Helvetica Neue, sans-serif"
color="#172b4d"><span style="font-size:14px">We are
running freeswitch 1.6.19 and it was originally
installed from the Debian repos. (yes I know it is
an old build and we will upgrade, but it shouldn't
affect what I am trying to do at the moment)</span><br>
</font>
<div><br>
</div>
<div><param name="core-db-dsn"
value="odbc://DRIVER=mysql;SERVER=<ip>;UID=devsca01;PWD=<password>;DATABASE=devsca01"><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><a
href="https://freeswitch.org/confluence/display/FREESWITCH/Using+ODBC+in+the+core"
moz-do-not-send="true">https://freeswitch.org/confluence/display/FREESWITCH/Using+ODBC+in+the+core</a><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>I have created a remote DB and gave it the proper
permissions. When I tested it, it appears to connect,
but not sure where to go from here.</div>
<div><br>
</div>
<div>
<div>root@dev-sca01a:/etc/freeswitch# isql -v devsca01
</div>
<div>+---------------------------------------+</div>
<div>| Connected! |</div>
<div>| |</div>
<div>| sql-statement |</div>
<div>| help [tablename] |</div>
<div>| quit |</div>
<div>| |</div>
<div>+---------------------------------------+</div>
<div>SQL> </div>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, Feb 14, 2020 at 12:36
PM David Villasmil <<a
href="mailto:david.villasmil.work@gmail.com"
moz-do-not-send="true">david.villasmil.work@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
<div>
<div dir="auto">That’s right. You don’t need to do anything
else. Just make sure the user you setup in freeswitch has
rights to create db, tables, etc.</div>
</div>
<div><br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, 14 Feb 2020 at
11:59, Joli Martinez <<a
href="mailto:mrjoli021@gmail.com" target="_blank"
moz-do-not-send="true">mrjoli021@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)">
<div dir="ltr">Hello,
<div><br>
</div>
<div>So if I understand correctly. I will create a
new mysql DB, update the switch.conf.xml and
restart FS.</div>
<div><br>
</div>
<div>Is that correct?</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, Feb 14, 2020
at 10:30 AM Giovanni Maruzzelli <<a
href="mailto:gmaruzz@gmail.com" target="_blank"
moz-do-not-send="true">gmaruzz@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px
0.8ex;border-left-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)">
<div dir="ltr">
<div>Hello,</div>
<div><br>
</div>
<div>you don't need to import anything, all tables
are created runtime, and they are for internal
FreeSWITCH usage, so FS will populate them, you
do not need to do anything. Obviously, you will
lose all registrations, until phones
re-register.</div>
<div><br>
</div>
<div>Do a lab, and experiment a little to get the
Knack of it</div>
<div><br>
</div>
<div>-giovanni</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri, Feb 14,
2020 at 4:03 PM Joli Martinez <<a
href="mailto:mrjoli021@gmail.com"
target="_blank" moz-do-not-send="true">mrjoli021@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px
0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)">
<div dir="ltr">Hello,
<div><br>
</div>
<div>We have several freeswitch boxes that are
running sqlite. We have outgrown this and
need to move the DB to mySQL. Not sure how
to import it, or if there is a procedure
already in place for this. What would be
the best option for this?</div>
<div><br>
</div>
<div>let me know</div>
</div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by
SignalWire <a href="https://signalwire.com"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive
priced SMS and PSTN services.<br>
Build your next product on our scalable cloud
platform.<br>
<br>
Join our online community to chat in real time <a
href="https://signalwire.community"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com"
target="_blank" moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
<br clear="all">
<br>
-- <br>
<div dir="ltr">Sincerely,<br>
<br>
Giovanni Maruzzelli<br>
OpenTelecom.IT<br>
cell: +39 347 266 56 18<br>
<br>
</div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a
href="https://signalwire.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive
priced SMS and PSTN services.<br>
Build your next product on our scalable cloud
platform.<br>
<br>
Join our online community to chat in real time <a
href="https://signalwire.community"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com"
target="_blank" moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a
href="https://signalwire.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced
SMS and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a
href="https://signalwire.community" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank"
moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence"
rel="noreferrer" target="_blank"
moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
</div>
-- <br>
<div dir="ltr">
<div dir="ltr">
<div>Regards,</div>
<div><br>
</div>
David Villasmil
<div>email: <a
href="mailto:david.villasmil.work@gmail.com"
target="_blank" moz-do-not-send="true">david.villasmil.work@gmail.com</a></div>
<div>phone: +34669448337</div>
</div>
</div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a
href="https://signalwire.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and
PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a
href="https://signalwire.community" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank"
moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank"
moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire <a class="moz-txt-link-freetext" href="https://signalwire.com">https://signalwire.com</a>
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 <a class="moz-txt-link-freetext" href="https://signalwire.community">https://signalwire.community</a>
Professional FreeSWITCH Services
<a class="moz-txt-link-abbreviated" href="mailto:sales@freeswitch.com">sales@freeswitch.com</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com">https://freeswitch.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="https://freeswitch.com/oss">https://freeswitch.com/oss</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.org/confluence">https://freeswitch.org/confluence</a>
<a class="moz-txt-link-freetext" href="https://cluecon.com">https://cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com">https://freeswitch.com</a></pre>
</blockquote>
<pre class="moz-signature" cols="120">--
------------------------------------------------------------
Nathan Neulinger <a class="moz-txt-link-abbreviated" href="mailto:nneul@mst.edu">nneul@mst.edu</a>
Missouri S&T Information Technology (573) 341-6679
System Administrator - Architect (573) 612-1412
System and Desktop Infrastructure Team Manager</pre>
</body>
</html>