Auth

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(Created page to document the auth database table)
 
m (Auth Fields: Added the references to the SL wiki mentioned on the webLoginKey entry)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
The auth table contains user authentication information. It holds an encrypted version of the password used by a user to login to OpenSimulator.
 +
 
== auth Table Structure ==
 
== auth Table Structure ==
  
Line 4: Line 6:
  
 
{| style="border:1px solid #ccc;"
 
{| style="border:1px solid #ccc;"
|- style="background:#eef;"
+
|- style="background:#cce;"
 
! Field
 
! Field
 
! Type
 
! Type
Line 14: Line 16:
 
|-
 
|-
 
| '''[[#uuid|UUID]]''' || char(36) || utf8_general_ci || || No || ''None'' ||  
 
| '''[[#uuid|UUID]]''' || char(36) || utf8_general_ci || || No || ''None'' ||  
|-
+
|- style="background:#eee;"
 
| '''[[#passwordHash|passwordHash]]''' || char(36) || utf8_general_ci ||  || No ||  ||  
 
| '''[[#passwordHash|passwordHash]]''' || char(36) || utf8_general_ci ||  || No ||  ||  
 
|-
 
|-
 
| '''[[#passwordSalt|passwordSalt]]''' || char(32) || utf8_general_ci ||  || No ||  ||  
 
| '''[[#passwordSalt|passwordSalt]]''' || char(32) || utf8_general_ci ||  || No ||  ||  
|-
+
|- style="background:#eee;"
 
| '''[[#webLoginKey|webLoginKey]]''' || varchar(255) || utf8_general_ci ||  || No ||  ||
 
| '''[[#webLoginKey|webLoginKey]]''' || varchar(255) || utf8_general_ci ||  || No ||  ||
 
|-
 
|-
Line 32: Line 34:
 
;<div id="uuid">'''UUID'''</div>
 
;<div id="uuid">'''UUID'''</div>
 
:UUID of an avatar
 
:UUID of an avatar
<br />
 
  
 
;<div id="passwordHash">'''passwordHash'''</div>
 
;<div id="passwordHash">'''passwordHash'''</div>
 
:An MD5 hash of the users password and the salt string.
 
:An MD5 hash of the users password and the salt string.
 
:The hash is calculated as follows: md5(md5("password") + ":" + [[#passwordSalt|passwordSalt]])
 
:The hash is calculated as follows: md5(md5("password") + ":" + [[#passwordSalt|passwordSalt]])
<br />
 
  
 
;<div id="passwordSalt">'''passwordSalt'''</div>
 
;<div id="passwordSalt">'''passwordSalt'''</div>
 
:A string used in the encryption of the password
 
:A string used in the encryption of the password
<br />
 
  
 
;<div id="webLoginKey">'''webLoginKey'''</div>
 
;<div id="webLoginKey">'''webLoginKey'''</div>
:<i style="color:red;">needs to be documented</i>
+
:Used in SLURL where The Grid Can Start a Session and Login the User from the Web, then the User Goes to a secondlife:// link that opens the viewer and bypasses the wait time for the User as everything got prepared beforehand(except for the Graphics) '''** THIS MAY NOT BE CORRECT, BUT IT WHAT WAS LEARNED FROM SECOND LIFE WIKI**''' (References on the Second Life wiki: [https://wiki.secondlife.com/wiki/Web_login_code/python Python script from 2007/8], [http://wiki.secondlife.com/wiki/Web_login_code/php5 PHP5 script from 2008])
<br />
+
  
 
;<div id="accountType">'''accountType'''</div>
 
;<div id="accountType">'''accountType'''</div>
 
:A string that can be used to distinguish different types of avatar accounts
 
:A string that can be used to distinguish different types of avatar accounts
 
<br />
 
<br />
<br />
+
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
+
 
----
 
----
 +
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 +
<br />
 +
 +
[[Category:Database]]

Latest revision as of 13:17, 5 July 2020

The auth table contains user authentication information. It holds an encrypted version of the password used by a user to login to OpenSimulator.

[edit] auth Table Structure

The current structure of the auth table is as follows:

Field Type Collation Attributes Null Default Extra
UUID char(36) utf8_general_ci No None
passwordHash char(36) utf8_general_ci No
passwordSalt char(32) utf8_general_ci No
webLoginKey varchar(255) utf8_general_ci No
accountType varchar(32) utf8_general_ci No UserAccount



      (back to Database Documentation)


[edit] Auth Fields

UUID
UUID of an avatar
passwordHash
An MD5 hash of the users password and the salt string.
The hash is calculated as follows: md5(md5("password") + ":" + passwordSalt)
passwordSalt
A string used in the encryption of the password
webLoginKey
Used in SLURL where The Grid Can Start a Session and Login the User from the Web, then the User Goes to a secondlife:// link that opens the viewer and bypasses the wait time for the User as everything got prepared beforehand(except for the Graphics) ** THIS MAY NOT BE CORRECT, BUT IT WHAT WAS LEARNED FROM SECOND LIFE WIKI** (References on the Second Life wiki: Python script from 2007/8, PHP5 script from 2008)
accountType
A string that can be used to distinguish different types of avatar accounts



      (back to Database Documentation)

Personal tools
General
About This Wiki