[Opensim-users] user authentication and deletion

[Paul Fishwick]

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