[Opensim-users] the concept of "visitor"
Bob Wellman
bob.wellman at hotmail.co.uk
Wed Feb 3 00:12:08 UTC 2010
Hi
We over at PMgrid have been worried about asset bloat too for quite some time.
So...
We created a web based php tool to analyse asset usage and to archive redundant assets. You would be amazed at what a large % of assets are redundant in even a small grid such as ours.
We also created a tool to analyse assets to identify and rationalise duplicate assets.
We also created a few other tools to make managing or investigating the Opensim database easier for grid operators (i.e. ourselves) and some tools to enable ordinary users access via the website to thier own avatars details such as thier profile data, thier friends list, clothes worn, attachments worn, inventory and regions owned.
At the London Meetup last Sunday some of the people there were kind enough to suggest this may be of interest to other grid operators. So I thought I would post this to see if interest really exists.
These tools were created for our own use. Our tool set is not (yet) packaged in a way that can be passed to others for thier use. We are thinking of maybe doing that later this year and giving it as open source to the community. We dont have expertise in packaging stuff up for Open Source so if we do this we will have to ask for guidance/help from someone who does.
However that time scale may be delayed. Very large changes to the Opensim database are imminent, due to work on the work being done by Diva and Melanie, which will probably break our tool. So we will wait until they are in and we can bring our tool up to the new database level (no idea how long that will take to do and test) before even attempting packaging a MK1 version. No point in delivering something that is out of date on the day after delivery.
In the meantime, we may considering setting up a demo of it on a test version of PMgrid for people to take a look at how it works, if there is enough interest in the idea. If you are interested please email me Bob.Wellman at hotmail.co.uk and I will tell you more about what we have written.
Regards... Bob Wellman and Peetr Maynard over at PMgrid
> Date: Tue, 2 Feb 2010 14:22:53 -0800
> From: karen_palen at yahoo.com
> To: opensim-users at lists.berlios.de
> Subject: Re: [Opensim-users] the concept of "visitor"
>
> I too suspect that there is a need for a tool to clean out the "kruft"!
>
> I dumped my sim out to four OAR files and several IAR files then reloaded them into a new MySQL database. The DB went from 1.3Gb to 220Mb! About 90% of that was in the "asset" section.
>
> at the moment I am unsure just how much of the "kruft" was due to system glitches and bad loads of experimental OAR files, but clearly there is a need to clean up the leftovers from such experiments!
>
> To judge by the Second Life experience, we will never be entirely free of system glitches that leave "orphan" assets. The only real question is when they become significant enough to clean up!
>
> It would seem that an experimental sim like mine would naturally accumulate more "kruft", but at the same time it is much easier to rebuild the database on such a sim! I shudder to think at the effort that would be involved in rebuilding the huge Second Life database!
>
> Karen
>
> --- On Tue, 2/2/10, Paul Fishwick <fishwick at cise.ufl.edu> wrote:
>
> > From: Paul Fishwick <fishwick at cise.ufl.edu>
> > Subject: Re: [Opensim-users] the concept of "visitor"
> > To: opensim-users at lists.berlios.de
> > Date: Tuesday, February 2, 2010, 1:56 PM
> > Good suggestions. I have someone
> > working on an opensim SQL toolkit and
> > it probably could
> > be adapted in that way. The toolkit will also include the
> > option to do a
> > db cleaning, deleting
> > users, deleting regions, showing specific stats, etc.
> >
> > The separate db for the timelimit is an interesting
> > idea -- that would
> > certainly clean the slate,
> > say, every 24 hours.
> >
> > @Master_Mirage: the kruft ... it isn't clear to me how much
> > there is yet
> > but I do know that our
> > database has grown at a significant rate that does not
> > appear to be
> > commensurate with the added
> > assets and prims that we have put into it. Still needs some
> > analysis to
> > know exactly what is going
> > on. Once the SQL tool has been developed, we should have
> > results of this
> > analysis.
> >
> > p
> >
> > John Mieske wrote:
> > > why not add a PHP file that does this all for you
> > ? Example : They
> > > click a button that says Visitor John. It gives them a
> > temp user and
> > > PW with full instructions to their e-mail. They log
> > in. Now the timer
> > > on the PHP can delete the temp user and PW after 24
> > hours. You can
> > > even have a php that refreshes every hour that checks
> > the database and
> > > removes the temp users that has no need to be there.
> > Make sure you
> > > create a seperate database for the time limit so that
> > it wont have to
> > > be added to the MAIN SQL database. If the "extra" SQL
> > databse has the
> > > name and user's time stamp ready for deletion then it
> > removes it from
> > > the MAIN database for the name and PW and then goes
> > back to the temp
> > > and removes it there too. So two databases with name
> > and PW to show
> > > which is fake.
> > >
> > > This can be done in many ways. Just a thought.
> > >
> > > John Mieske / Sonya Penucca
> > >
> > > On Tue, Feb 2, 2010 at 10:49 AM, Paul Fishwick <fishwick at cise.ufl.edu
> >
> > > <mailto:fishwick at cise.ufl.edu>>
> > wrote:
> > >
> > > I would like to open up one of
> > our worlds to the general public by
> > > allowing people
> > > to log in as visitors. This is
> > related to the "anonymous login"
> > > and has
> > > been discussed
> > > in various forms, but here is
> > the concept - not sure if anything
> > > exists
> > > yet in trunk to
> > > support this:
> > >
> > > 1. A user logs in using
> > whatever name they want. If authentication is
> > > turned off, this is
> > > no problem. However,
> > what would be ideal is that when the user logs
> > > off, any trace
> > > of them is removed from
> > the database-- they do not persist.
> > >
> > > 2. When the user logs in, they
> > have access to the Library part of the
> > > inventory, but are
> > > unable to load any assets
> > to the server, thus they would have
> > > nothing under "My Inventory"
> > > or be able to copy items
> > from the Library or the world into My
> > > Inventory. The Library
> > > would contain all
> > necessities (clothing, basic objects and scripts
> > > that they require
> > > in the space).
> > >
> > > 3. The user cannot build on
> > the island but can run scripts and
> > > navigate
> > > performing full
> > > interaction.
> > >
> > > #1 is not a huge issue since I
> > would imagine that the incremental
> > > space
> > > allocation for
> > > users just means additional
> > rows in the user/agent tables -- shouldn't
> > > take up too much
> > > room. #2 is a bigger problem -
> > visitors should not be taxing the asset
> > > server. #3
> > > can be handled by unchecking
> > both boxes next to Create Objects in
> > > About
> > > Land->Options.
> > >
> > > Are either #1 or #2 possible?
> > They would seem to be a prerequisite for
> > > something approaching
> > > basic web page services:
> > people come in, visit, and exit while
> > > leaving a
> > > minimal trace.
> > > Builders on the other hand,
> > have special login names that give
> > > them the
> > > capability to build
> > > and load assets (possible with
> > groups?).
> > >
> > > -p
> > >
> > > --
> > > Paul Fishwick, PhD
> > > Professor
> > > University of Florida
> > > CISE Department, CSE 301
> > > Gainesville, FL 32611
> > > Email: fishwick at cise.ufl.edu
> > <mailto:fishwick at cise.ufl.edu>
> > > Web: http://www.cise.ufl.edu/~fishwick
> > > <http://www.cise.ufl.edu/%7Efishwick>
> > >
> > >
> > _______________________________________________
> > > Opensim-users mailing list
> > > Opensim-users at lists.berlios.de
> > <mailto: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
> > >
> >
> >
> > --
> > Paul Fishwick, PhD
> > Professor
> > University of Florida
> > CISE Department, CSE 301
> > Gainesville, FL 32611
> > Email: fishwick at cise.ufl.edu
> > Web: http://www.cise.ufl.edu/~fishwick
> >
> > _______________________________________________
> > 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
_________________________________________________________________
Do you have a story that started on Hotmail? Tell us now
http://clk.atdmt.com/UKM/go/195013117/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20100203/c13513e2/attachment.html>
More information about the Opensim-users
mailing list