<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:12pt"><div>Well, I dont *know* if the MySQL has this issue or not, yet. I went ahead and reported what I had heard.<br><br>*If* we have this issue, then it is one of Regions/region.xml files registering a region with a long name and/or a name with spaces in the front. <br><br>It seemed appropriate to discuss it as it is one theory why some searches are causing clients to crash.<br><br>Charles<br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Chris Hart <Chris@codetorque.co.uk><br><b><span style="font-weight: bold;">To:</span></b> opensim-dev@lists.berlios.de<br><b><span style="font-weight:
bold;">Sent:</span></b> Sunday, March 29, 2009 1:33:25 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [Opensim-dev] funky region names?<br></font><br>
<style>
<!--
_filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
span.EmailStyle18
{font-family:"Calibri", "sans-serif";color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
_filtered {margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">The MSSQL database schema limits region names to 20 characters,
so having discovered the hard way that names longer than that cause trouble
when registering with a grid we’ve now avoided that problem with
validation on the web app we use that serves the region xml. I have no idea
when 20 characters was set for the limit, and had assumed this was just one of
those numbers dictated by the client and didn’t think we were different
from the MySQL configuration until this email. </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">That aside, if there are client issues over 32 characters then regions
shouldn’t be allowed to register with the grid if the client used to
connect to those regions is the LL client. Perhaps there could be a regex
setting in the ini for validating region names? Would leave room for different
validation requirements for different clients.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Chris</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";" lang="EN-US">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";" lang="EN-US"> opensim-dev-bounces@lists.berlios.de
[mailto:opensim-dev-bounces@lists.berlios.de] <b>On Behalf Of </b>Charles
Krinke<br>
<b>Sent:</b> 29 March 2009 21:22<br>
<b>To:</b> opensim-dev<br>
<b>Subject:</b> [Opensim-dev] funky region names?</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><span style="font-family: "Arial","sans-serif";"><br>
I am getting some comments about region names beginning with spaces *and*<br>
region names longer then 32 characters having some side effects in map
and<br>
search from OSGrid users.<br>
<br>
It makes me wonder if the grid server should have some additional<br>
constraints to trim leading spaces and names longer then 32 characters so<br>
associated .PHP programs and the client do not get unhappy.<br>
<br>
So, I pose the question and wonder what folks think is the proper
solution.<br>
<br>
Charles</span></p>
</div>
</div>
<p><span style="font-size: 10pt; font-family: "Arial","sans-serif";">No virus
found in this incoming message.<br>
Checked by AVG - <a target="_blank" href="http://www.avg.com">www.avg.com</a><br>
Version: 8.0.238 / Virus Database: 270.11.31/2028 - Release Date: 03/28/09
07:16:00</span></p>
</div>
</div></div></div></body></html>