[prev in list] [next in list] [prev in thread] [next in thread] 

List:       opensim-users
Subject:    [Opensim-users] user authentication and deletion
From:       fishwick () cise ! ufl ! edu (Paul Fishwick)
Date:       2008-12-23 21:03:32
Message-ID: 49515224.3040806 () cise ! ufl ! edu
[Download RAW message or body]


Justin Clark-Casey wrote:
> Paul Fishwick wrote:
> 
> > I am testing on Ubuntu Linux, OpenSim r7840, and wanted to check that
> > I was performing the right actions:
> > 
> > 1) "Test User" was the default user on login, so I created another user with
> > "create user" in the OpenSim console. However when using sqlite3 from
> > the shell, or using the Firefox sqlite plugin, the only user shown when
> > opening database "userprofiles.db" and querying
> > "select * from users" is "Test User", not the other one. I can log 
> > in with the
> > other one fine, so it must be storing it somewhere. Any idea where?
> > 
> 
> Should be there.  Seems to be working right now.
> 
yes, I downloaded 7863 and now it is working. My testing I think was on 
7797 instead
of 7840 so something might have been amiss back then.
> 
> > 2) I tried resetting the password for Test User using "reset user password"
> > at the OpenSim console, but this fails because relogging-in as Test User
> > uses the old password "test", not the new one. has anyone else 
> > noticed this?
> > 
> 
> Ah, now this actually was broken.  This is fixed in r7862.
> 
ok, thanks.
> 
> > 3) What is the preferred method of deleting a user? I guess if I can get (1)
> > above working, I can use Sqlite to remove the row in userprofiles.db or
> > or wherever the user info is stored?
> > 
> 
> At the moment I believe it has to be done in sql.  I think an explicit console \
> command for this would be useful, though  really I think that it should delete that \
> user's inventory entries in grid mode as well (which makes it much less  trivial to \
> implement). 
for sqlite, it looks like two sql calls will do it:

 1. for userprofiles.db, select * where firstname= .... and lastname = 
......
     then,  grab UUID of that agent
 2. on inventorystore.db, delete * where agentID = UUID

these can be done manually for now.

-p



-- 
Paul Fishwick, PhD
Professor and Director, Digital Arts and Sciences Programs
University of Florida
Computer & Information Science and Eng. Dept.
Bldg. CSE, Room 301
P.O. Box 116120
Gainesville, FL 32611
Email: fishwick at cise.ufl.edu
Phone: (352) 392-1414
Fax: (352) 392-1220
Web: http://www.cise.ufl.edu/~fishwick


[prev in list] [next in list] [prev in thread] [next in thread]