I had this same problem today.<br>I solved it using <br>OPTION = 67108864<br>instead of <br>OPTIONS = 67108864<br><br>I'm using CentOS5.3 (x86_64)<br><br>br,<br>takeshi<br><br><div class="gmail_quote">On Sat, Nov 28, 2009 at 12:36 AM, Frank @ Impact <span dir="ltr"><<a href="mailto:frank@impactfax.com">frank@impactfax.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="blue" style="word-wrap: break-word;" lang="EN-US">
<div>
<p class="MsoNormal"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">Yes. I am using version 5.1<span> </span>I am using Fedora 12.</span></font></p>
<p class="MsoNormal"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font></p>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma;"><div class="im">-----Original Message-----<br>
<b><span style="font-weight: bold;">From:</span></b> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>
[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>] <b><span style="font-weight: bold;">On Behalf Of </span></b>Leon de Rooij<br>
</div><div><div></div><div class="h5"><b><span style="font-weight: bold;">Sent:</span></b> Friday, November 27, 2009
10:19 AM<br>
<b><span style="font-weight: bold;">To:</span></b>
<a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [Freeswitch-users]
odbc FLAG_MULTI_STATMENTS</div></div></span></font></p><div><div></div><div class="h5">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">Are you using the myodbc 3.51.18 version or higher ?</span></font></p>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">I'm using 3.51.19 (ubuntu karmic) and it works
properly. I also had to upgrade from jaunty..</span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">regards,</span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">Leon</span></font></p>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
<div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">On Nov 27, 2009, at 3:41 PM, Frank @ Impact wrote:</span></font></p>
</div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"><br>
<br>
</span></font></p>
<span style="word-spacing: 0px;">
<div link="blue" vlink="blue" style="word-wrap: break-word;">
<div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">Thanks. <span> </span>But when I made these entries in
/etc/odbc.ini and rebooted…</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">[<span>freeswitch</span>]</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">Driver <span> </span>=<span> </span><span>MySQL</span></span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">SERVER <span> </span>= 127.0.0.1</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">PORT <span> </span>= 4040</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">DATABASE <span> </span>=<span> </span><span>mydb</span></span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">OPTIONS <span> </span>= 67108864</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">…I still get FS
complaining with this.</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">Nov 27<span> </span>08:45:57<span> </span>P3<span> </span><span>freeswitch[</span>27933]:
2009-11-27 08:45:57.016744 [WARNING] sofia_glue.c:3918 GREAT SCOTT!!! Cannot
execute batched statements<span>!#</span>012If you are using<span> </span><span>mysql</span>, make
sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><span><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">FreeSWITCH</span></font></span><font color="blue" face="Arial"><span style="font-family: Arial; color: blue;">>version</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><span><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">FreeSWITCH</span></font></span><span><font color="blue" face="Arial"><span style="font-family: Arial; color: blue;"> </span></font></span><font color="blue" face="Arial"><span style="font-family: Arial; color: blue;">Version
1.0.trunk (15660)</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">Linux <a href="http://P3.dom.com" target="_blank">P3.dom.com</a>
2.6.30.9-96.fc11.x86_64 #1 SMP<span> </span>Wed
Nov 4 00:02:04 EST 2009 x86_64<span> </span><span>x86_64</span><span> </span><span>x86_64</span><span> </span>GNU/Linux</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">From /etc/odbcinst.ini</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">DRIVER =
/usr/lib64/<a href="http://libmyodbc5-5.1.5.so" target="_blank">libmyodbc5-5.1.5.so</a></span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">Setup =
/usr/lib64/libodbcmyS.so</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;">Is this a FS<span> </span><span>issue ?</span> <span> </span><span>or</span><span> </span>an issue with<span> </span><span>mysql</span><span> </span><span>odbc</span>? <span> </span>Any insight would be great.</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="blue" face="Arial"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="2" color="black" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; color: black;">-----Original
Message-----<br>
<b><span style="font-weight: bold;">From:</span></b><span> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a><span> </span>[<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>]<span> </span><b><span style="font-weight: bold;">On
Behalf Of<span> </span></span></b>Leon de
Rooij<br>
<b><span style="font-weight: bold;">Sent:</span></b><span> </span>Friday,
November 27, 2009<span> </span>3:37
AM<br>
<b><span style="font-weight: bold;">To:</span></b><span> </span><a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a><br>
<b><span style="font-weight: bold;">Subject:</span></b><span> </span>Re: [Freeswitch-users] odbc
FLAG_MULTI_STATMENTS</span></font><font color="black"><span style="color: black;"></span></font></p>
</div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;">There's a
little info here on how to enable it with odbc:</span></font></p>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"><a href="http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#CentOS_5.2" target="_blank">http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#CentOS_5.2</a></span></font></p>
</div>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;">regards,</span></font></p>
</div>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;">Leon</span></font></p>
</div>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
<div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;">On Nov 26,
2009, at 10:48 PM, Tihomir Culjaga wrote:</span></font></p>
</div>
</div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"><br>
<br>
<br>
</span></font></p>
</div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;">On Thu, Nov
26, 2009 at 9:53 PM, Michael Jerris <<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>>
wrote:</span></font></p>
</div>
<div style="word-wrap: break-word;"><pre style="margin-left: 1in;"><font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"><a href="http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-news-3-51-18.html" target="_blank">http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-news-3-51-18.html</a></span></font></pre>
<pre style="margin-left: 1in;"><font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"> </span></font></pre><pre style="margin-left: 1in;"><font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;">MySQL Connector/ODBC now supports batched statements. In order to enable</span></font></pre>
<pre style="margin-left: 1in;"><font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"> cached statement support you must switch enable the batched</span></font></pre><pre style="margin-left: 1in;">
<font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"> statement option (<code><font face="Courier New">FLAG_MULTI_STATEMENTS</font></code>,</span></font></pre><pre style="margin-left: 1in;">
<font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"> 67108864, or Allow multiple statements</span></font></pre><pre style="margin-left: 1in;"><font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"> within a GUI configuration). Be aware that batched statements</span></font></pre>
<pre style="margin-left: 1in;"><font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"> create an increased chance of SQL injection attacks and you must</span></font></pre><pre style="margin-left: 1in;">
<font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"> ensure that your application protects against this scenario.</span></font></pre><pre style="margin-left: 1in;"><font size="2" color="black" face="Courier New"><span style="font-size: 10pt; color: black;"> (<a href="http://bugs.mysql.com/7445" target="_blank">Bug#7445</a>)</span></font></pre>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
</div>
</div>
<div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"><br>
so, is this the right patch ?<br>
<br>
<a href="http://bugs.mysql.com/file.php?id=6994" target="_blank">http://bugs.mysql.com/file.php?id=6994</a><br>
<br>
<br>
T.</span></font></p>
</div>
</div>
</div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"><br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></span></font></p>
</div>
</div>
<div style="margin-left: 0.5in;">
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" color="black" face="Times New Roman"><span style="font-size: 12pt; color: black;"> </span></font></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="4" color="black" face="Helvetica"><span style="font-size: 13.5pt; font-family: Helvetica; color: black;">_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br>
</span></font></p>
</div>
</span></div>
<p class="MsoNormal" style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"></span> </font></p>
</div>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br>