Auth
From OpenSimulator
(Difference between revisions)
m (Added a note about the purspose of the table) |
m (→Auth Fields: Added the references to the SL wiki mentioned on the webLoginKey entry) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
{| style="border:1px solid #ccc;" | {| style="border:1px solid #ccc;" | ||
| − | |- style="background:# | + | |- style="background:#cce;" |
! Field | ! Field | ||
! Type | ! Type | ||
| Line 16: | 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 34: | Line 34: | ||
;<div id="uuid">'''UUID'''</div> | ;<div id="uuid">'''UUID'''</div> | ||
:UUID of an avatar | :UUID of an avatar | ||
| − | |||
;<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]]) | ||
| − | |||
;<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 | ||
| − | |||
;<div id="webLoginKey">'''webLoginKey'''</div> | ;<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**''' (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> | ;<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 /> | ||
| − | + | ||
| + | ---- | ||
| + | |||
(back to [[Database Documentation]]) | (back to [[Database Documentation]]) | ||
| − | + | <br /> | |
| + | |||
| + | [[Category:Database]] | ||
Latest revision as of 12: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)
