[Opensim-users] A note about XmlRpcGroupsServer and UTF8

Thu Nov 10 11:16:31 UTC 2011

Hi Gwyn!

That's really quite interesting as I had the opposite experience initially
- the Xoopensim groups were the only thing that DID work out of the gate on
FleepGrid (WinXP, MySQL 5.1, latin1 charset) but I couldn't even install
Xoopensim at all on the University of Cincinnati grid (WinServer 2008 R2,
MySQL 5.5.16, utf8).

I decided to downgrade UC's MySQL version to MySQL 5.1.59 thinking that
might be the issue with Xoopensim, but still couldn't get that to install,
then tried the XmlRpcGroupsServer and ran into the MySQL bug about
character length, reinstalled MySQL for the third time to change the
charset to latin1 and finally got XmlRpcGroupsServer to work.

I still cannot get OSProfile or OSSearch to work, but finally DID get
Offline IMs working thanks to jor3l.

All in all the module installation experience has been quite painful, I
must say.  For my part, I am fairly novice at most of this so I tend to
assume if something isn't working it's probably because I did something
idiotic, but if I ever get things actually working I want to try to help
improve the documentation in terms that a novice like me can understand,
because most of the instructions assume either that the user is running on
linux or they assume much more implicit knowledge about the process than I
actually have.

I'm trying to document my experiences in as much detail as I can muster,
for FleepGrid the change log is at http://fleep.wikispaces.com/FleepGrid and
for the UC Grid at http://ucopensim.wikispaces.com/Server+Change+Log so if
those details help anyone, I'm glad to hear it.

Wishing you best of luck too!

- 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

On Thu, Nov 10, 2011 at 3:37 AM, Gwyneth Llewelyn <
gwyneth.llewelyn at gwynethllewelyn.net> wrote:

> 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
>
>
>
> _______________________________________________
> 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/9a43022e/attachment.html>