Auth - Revision history

Gwyneth Llewelyn: /* Auth Fields */ Added the references to the SL wiki mentioned on the webLoginKey entry

2020-07-05T20:17:46Z

‎Auth Fields: Added the references to the SL wiki mentioned on the webLoginKey entry

CodyCooper: /* Auth Fields */

2019-04-09T18:57:45Z

‎Auth Fields

Kcozens: Minor formatting changes to match other database documentation pages

2016-04-12T02:06:27Z

Minor formatting changes to match other database documentation pages

Kcozens: Changed colours in Table Structure table. Removed unneeded
's. Adjusted line spacing in field details.

2016-04-12T00:27:31Z

Changed colours in Table Structure table. Removed unneeded <br/>'s. Adjusted line spacing in field details.

Kcozens: Added a note about the purspose of the table

2012-07-25T21:34:06Z

Added a note about the purspose of the table

Kcozens: Created page to document the auth database table

2012-07-25T18:34:43Z

Created page to document the auth database table

New page

== auth Table Structure ==

The current structure of the auth table is as follows:

{| style="border:1px solid #ccc;"
|- style="background:#eef;"
! Field
! Type
! Collation
! Attributes
! Null
! Default
! Extra
|-
| '''[[#uuid|UUID]]''' || char(36) || utf8_general_ci || || No || ''None'' ||
|-
| '''[[#passwordHash|passwordHash]]''' || char(36) || utf8_general_ci || || No || ||
|-
| '''[[#passwordSalt|passwordSalt]]''' || char(32) || utf8_general_ci || || No || ||
|-
| '''[[#webLoginKey|webLoginKey]]''' || varchar(255) || utf8_general_ci || || No || ||
|-
| '''[[#accountType|accountType]]''' || varchar(32) || utf8_general_ci || || No || ''UserAccount'' ||
|}
<br />
<br />
      (back to [[Database Documentation]])
----

== Auth Fields ==

;<div id="uuid">'''UUID'''</div>
:UUID of an avatar
<br />

;<div id="passwordHash">'''passwordHash'''</div>
:An MD5 hash of the users password and the salt string.
:The hash is calculated as follows: md5(md5("password") + ":" + [[#passwordSalt|passwordSalt]])
<br />

;<div id="passwordSalt">'''passwordSalt'''</div>
:A string used in the encryption of the password
<br />

;<div id="webLoginKey">'''webLoginKey'''</div>
:<i style="color:red;">needs to be documented</i>
<br />

;<div id="accountType">'''accountType'''</div>
:A string that can be used to distinguish different types of avatar accounts
<br />
<br />
      (back to [[Database Documentation]])
----

@@ Line 43: / Line 43: @@
 ;<div id="webLoginKey">'''webLoginKey'''</div>
-: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**
+: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])
 ;<div id="accountType">'''accountType'''</div>

← Older revision		Revision as of 21:34, 25 July 2012
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 47: / Line 47: @@
 ;<div id="accountType">'''accountType'''</div>
 :A string that can be used to distinguish different types of avatar accounts
 <br />
 ----
 <br />
 [[Category:Database]]

@@ Line 6: / Line 6: @@
 {| style="border:1px solid #ccc;"
-|- style="background:#eef;"
+|- style="background:#cce;"
 ! Field
 ! Type
@@ Line 16: / Line 16: @@
 |-
 | '''[[#uuid|UUID]]''' || char(36) || utf8_general_ci || || No || ''None'' ||
-|-
+|- style="background:#eee;"
 | '''[[#passwordHash|passwordHash]]''' || char(36) || utf8_general_ci ||  || No ||  ||
 |-
 | '''[[#passwordSalt|passwordSalt]]''' || char(32) || utf8_general_ci ||  || No ||  ||
-|-
+|- style="background:#eee;"
 | '''[[#webLoginKey|webLoginKey]]''' || varchar(255) || utf8_general_ci ||  || No ||  ||
 |-
@@ Line 34: / Line 34: @@
 ;<div id="uuid">'''UUID'''</div>
 :UUID of an avatar
 ;<div id="passwordHash">'''passwordHash'''</div>
 :An MD5 hash of the users password and the salt string.
 :The hash is calculated as follows: md5(md5("password") + ":" + [[#passwordSalt|passwordSalt]])
 ;<div id="passwordSalt">'''passwordSalt'''</div>
 :A string used in the encryption of the password
 ;<div id="webLoginKey">'''webLoginKey'''</div>
 :<i style="color:red;">needs to be documented</i>
 ;<div id="accountType">'''accountType'''</div>
 :A string that can be used to distinguish different types of avatar accounts
 <br />
 <br />
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-----