<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Gary,<br>
<br>
You can always hack and recompile your mysql cluster src with larger
row support ( beware it's not an easy hack ).<br>
<br>
I don't know the presence stuff in FS, but if it's storing xml msgs
received from UA's, you may store truncated stuff using your
modified scheme and this will break functionnality, same for the
'description' field, it's been too long I didn't take a look at FS
src to answer precisely...<br>
<br>
Regards,<br>
<br>
Gled.<br>
<br>
Le 21/03/2012 20:05, GCHEN00 a écrit :
<blockquote
cite="mid:A9146DD85FCD4D1688678287D02FAA7C@lightyeaaeqfyt"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19190">
<style></style>
<div><font face="Arial" size="2">mysql cluster 7.2.4 </font></div>
<div><font face="Arial" size="2">and newest FS</font></div>
<div> </div>
<div><font face="Arial" size="2">I am trying to use ODBC to
connect mysql cluster database.</font></div>
<div><font face="Arial" size="2">When FS start, it has ERRORs to
create the tables channel and interfaces, So I tried to
manually create these two tables with schema from non-cluster
mysql database.</font></div>
<div><font face="Arial" size="2">With engine=NDBCLUSTER for the
tables, I got this error: "The maximum row size for the used
table type, not counting BLOBs, is 14000. You have to change
some columns to TEXT or BLOBs"</font></div>
<div> </div>
<div><font face="Arial" size="2">I can use engine=InnoDB but not
NDBCLUSTER. </font></div>
<div> </div>
<div><font face="Arial" size="2">So I changed fields 'presence_id'
and 'presence_data' in channel table from size 4096 to 512 and
field 'description' in interfaces table from 4096 to 1024. And
it worked.</font></div>
<div> </div>
<div><font face="Arial" size="2">I am wordering will these table
changes cause any problem down the road.</font></div>
<div> </div>
<div><font face="Arial" size="2">Any other suggestion to solve
this problem?</font></div>
<div> </div>
<div><font face="Arial" size="2">Gary</font></div>
<div> </div>
<div> </div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a class="moz-txt-link-freetext" href="http://www.cudatel.com">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.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="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Tristan Mahé
B&C
08.25.59.50.59
</pre>
</body>
</html>