[Opensim-users] the concept of "visitor"

Tue Feb 2 21:05:01 UTC 2010

Well I have some experience with SQL. The one thing I know is that it wont
change anything if you just add info and delete info. It cleans itself if
your using MySQL for OpenSim. Not sure on the other databases. The reason
the OpenSim database grows IS because of the assets. Keep in mind, there is
a HUGE installment of all assets once a user is created. HOWEVER with that
point in mind, when a user deletes their account, it deletes that and all
its previous assets. We tested that and it works. So to create a database
that is seperate that holds the USER PW and DATE boolian settings would then
check once an hour to keep the database clean.

EXAMPLE : OpenSim.SQL holds the REAL info. TempVisitor.SQL holds the User
NAME and its time frame. Only those three ( first and last name count as two
fields ) fields.

Now in the INI of OpenSim you already have an option to execute a script.
That script could call a PHP file that could then check the database and
remove the unwanted names. If it finds a name, then BOTH the SQL files will
be updated. The TempVisitors will delete the USER and its info and the
OpenSim SQL will delete the user and all its info. Since most sites do not
have that many "visitors" logging in all at once this is not as much
bandwidth as one might originally think. I at first thought it would be, but
I am glad someone else thought about this too. I have been wanting to
discuss this very topic.

On Tue, Feb 2, 2010 at 3:56 PM, Paul Fishwick <fishwick at cise.ufl.edu> wrote:

> 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
>

-- 
John Mieske / Sonya Pencuca
http://johnmieske.org
Space Grid Station
"Religion - The art of killing people to prove who's imaginary friend is
better."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20100202/7312c2d7/attachment.html>