[Opensim-users] A note about XmlRpcGroupsServer and UTF8

[Gwyneth Llewelyn]

Hi Fleep,

In my case, things are a bit unclear. The original database I used for Groups came from the XmlRpcGroupsServer that I had downloaded in May 2010. This works flawlessly, to my bafflement and surprise, using UTF8 under MySQL 5.1.53/Linux. It worked under 0.7.0.1 and 0.7.0.2, and it did not stop working under 0.7.2 (I skipped 0.7.1 :) ). Since it works so well, I'm scared to touch any of it — either the code from May 2010, or the created tables :)

When installing Xoopensim (yes, I've been following your experiences and trying to replicate them as best as possible!), I thought I ought to give Xoopensim's built-in groups a try. Although the databases created are a perfect replica of what XmlRpcGroupsServer uses — they don't work. When copying over exactly the same content I had in the "old" tables to Xoopensim's own — Groups stopped working.

I gave up on Xoopensim's groups and went back to XmlRpcGroupsServer's instead. They remain functional. Again, they're in UTF8. As a matter of fact, Groups are the *only* thing I can get to work (well, and the Broker, too, because that at least has such an easy protocol that I wrote something quickly — even though it's less useful than I thought, I imagined I'd get at least the *name* of the avatar that changed regions). Everything else refuses to work. Profiles worked under 0.6.9 or so, but not since the upgrade to 0.7.X, and it's hard to say "why" — I just get "slow POST requests" and unacknowledged LLSD packets — and both OSProfiles and Xoopensim's own implementation give similar results.

From the error you describe, I might just have been lucky and not require long keys, and that's why I managed to create those tables back in May 2010, but I guess that an alternative to keep as most of the code using UTF8 as possible, is to change the key length somewhere. Now if one could figure out *where*, it would be tremendously helpful :)

Cheers,

	- Gwyn

On 2011/11/04, at 19:41, Fleep Tuque wrote:

> Hi all,
> 
> Given the problems I had with installing Xoopensim, I decided to go the other route and try to install the various modules individually for groups and profiles and so on.
> 
> First note: I noticed that there are two pages on the wiki, when I think there should perhaps only be one, or one should redirect to the other:
> 
> http://opensimulator.org/wiki/Groups is the first page, and it seems incomplete.
> 
> http://opensimulator.org/wiki/Enabling_Groups is the second page, and its instructions are much more fleshed out and clear.
> 
> The first page should probably redirect or link to the second page, no?
> 
> 
> Second note:  I ran into problems installing the XmpRpcGroupsServer at first, and finally after some digging around discovered the problem was that I installed MySQL with the utf8 charset, and due to this bug:  http://bugs.mysql.com/bug.php?id=4541 some of the tables needed for the groups functionality were not being created.  Upon trying to create the tables, I was getting an error message:
> 
> Specified key was too long; max key length is 1000 bytes
> 
> Since all things considered we hadn't done too much with anything yet, I resintalled MySQL with the latin1 charset and voila, the groups functionality seems to be working perfectly.
> 
> Before I notate the groups page about this problem, I just wanted to confirm that anyone else has seen this error with utf8 and resolved it with the latin1 charset?  Are the folks who developed the XmlRpcGroupsServer planning to fix this issue for those who need international characters?
> 
> Is this a known problem and I'm just behind the curve (as usual)? 
> 
> :)
> 
> - Chris/Fleep
> 
> 
> Chris M. Collins (SL: Fleep Tuque)
> Project Manager, UC Second Life 
> UCit Instructional & Research Computing
> University of Cincinnati 
> 406E Zimmer Hall
> PO Box 210088
> Cincinnati, OH 45221-0088
> (513)556-3018
> chris.collins at uc.edu
> 
> http://www.uc.edu/ucit/learningtools/secondlife.html
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20111110/5cbe6b7e/attachment.html>