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
> [email protected]
>
> http://www.uc.edu/ucit/learningtools/secondlife.html
> _______________________________________________
> Opensim-users mailing list
> [email protected]
> https://lists.berlios.de/mailman/listinfo/opensim-users
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
