Auth
From OpenSimulator
(Difference between revisions)
												
			CodyCooper  (Talk | contribs)  (→Auth Fields)  | 
			m (→Auth Fields:  Added the references to the SL wiki mentioned on the webLoginKey entry)  | 
			||
| Line 43: | Line 43: | ||
;<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**  | + | :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>  | ||
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)