Task:Single sign-on/Account info stored in ldap - Revision history

dneary: /* bugs.maemo.org */

dneary — Thu, 16 Sep 2010 12:42:23 GMT

bugs.maemo.org

← Older revision		Revision as of 12:42, 16 September 2010
Line 133:		Line 133:
	\|-		\|-
	\| extern_id \|\| char(64)		\| extern_id \|\| char(64)
		+	\|}
		+
		+	=== wiki.maemo.org ===
		+	Table mw_user.
		+
		+	There is also mw_user_groups describing access rights the user has.
		+
		+	{\| class="wikitable sortable"
		+	\|-
		+	! Field
		+	! Datatype
		+	\|-
		+	\| user_id \|\| int(10) unsigned
		+	\|-
		+	\| user_name \|\| varchar(255)
		+	\|-
		+	\| user_real_name \|\| varchar(255)
		+	\|-
		+	\| user_password \|\| tinyblob
		+	\|-
		+	\| user_newpassword \|\| tinyblob
		+	\|-
		+	\| user_newpass_time \|\| binary(14)
		+	\|-
		+	\| user_email \|\| tinytext
		+	\|-
		+	\| user_options \|\| blob
		+	\|-
		+	\| user_touched \|\| binary(14)
		+	\|-
		+	\| user_token \|\| binary(32)
		+	\|-
		+	\| user_email_authenticated \|\| binary(14)
		+	\|-
		+	\| user_email_token \|\| binary(32)
		+	\|-
		+	\| user_email_token_expires \|\| binary(14)
		+	\|-
		+	\| user_registration \|\| binary(14)
		+	\|-
		+	\| user_editcount \|\| int(11)
	\|}		\|}

	[[Category:Tasks]]		[[Category:Tasks]]

amigadave: categorize

amigadave — Tue, 11 May 2010 08:38:32 GMT

categorize

← Older revision		Revision as of 08:38, 11 May 2010
Line 134:		Line 134:
	\| extern_id \|\| char(64)		\| extern_id \|\| char(64)
	\|}		\|}
		+
		+	[[Category:Tasks]]

feri: added bugs.maemo.org info

feri — Fri, 20 Nov 2009 10:49:25 GMT

added bugs.maemo.org info

← Older revision		Revision as of 10:49, 20 November 2009
Line 112:		Line 112:
	\|-		\|-
	\| skype \|\| varchar(32)		\| skype \|\| varchar(32)
		+	\|}
		+
		+	=== bugs.maemo.org ===
		+	{\| class="wikitable sortable"
		+	\|-
		+	! Field
		+	! Datatype
		+	\|-
		+	\| userid \|\| int(9)
		+	\|-
		+	\| cryptpassword \|\| char(128)
		+	\|-
		+	\| realname \|\| char(255)
		+	\|-
		+	\| disabledtext \|\| char(255)
		+	\|-
		+	\| mybugslink \|\| int(4)
		+	\|-
		+	\| refreshed_when \|\| datetime
		+	\|-
		+	\| extern_id \|\| char(64)
	\|}		\|}

rsuplido: Added Talk vBulletin structure

rsuplido — Wed, 27 May 2009 14:33:11 GMT

Added Talk vBulletin structure

← Older revision		Revision as of 14:33, 27 May 2009
Line 79:		Line 79:
	\|-		\|-
	\| ccode \|\| char(2)		\| ccode \|\| char(2)
		+	\|}
		+
		+	=== Talk ===
		+	{\| class="wikitable sortable"
		+	\|-
		+	! Field
		+	! Datatype
		+	\|-
		+	\| userid \|\| int(10)
		+	\|-
		+	\| username \|\| varchar(100)
		+	\|-
		+	\| password \|\| varchar(32)
		+	\|-
		+	\| joindate \|\| int(10)
		+	\|-
		+	\| email \|\| varchar(100)
		+	\|-
		+	\| homepage \|\| varchar(100)
		+	\|-
		+	\| icq \|\| varchar(20)
		+	\|-
		+	\| aim \|\| varchar(20)
		+	\|-
		+	\| yahoo \|\| varchar(32)
		+	\|-
		+	\| birthday \|\| varchar(10)
		+	\|-
		+	\| msn \|\| varchar(100)
		+	\|-
		+	\| jabber \|\| varchar(250)
		+	\|-
		+	\| skype \|\| varchar(32)
	\|}		\|}

xfade: Add maemo.org info(not complete yet)

xfade — Wed, 27 May 2009 14:15:13 GMT

Add maemo.org info(not complete yet)

← Older revision		Revision as of 14:15, 27 May 2009
Line 17:		Line 17:
	\|-		\|-
	\| wiki.maemo.org \|\| Mediawiki		\| wiki.maemo.org \|\| Mediawiki
		+	\|}
		+
		+	=== maemo.org ===
		+	{\| class="wikitable sortable"
		+	\|-
		+	! Field
		+	! Datatype
		+	\|-
		+	\| id \|\| int(11)
		+	\|-
		+	\| username \|\| char(255)
		+	\|-
		+	\| firstname \|\| char(255)
		+	\|-
		+	\| lastname \|\| char(255)
		+	\|-
		+	\| birthdate \|\| datetime
		+	\|-
		+	\| street \|\| char(255)
		+	\|-
		+	\| postcode \|\| char(255)
		+	\|-
		+	\| city \|\| char(255)
		+	\|-
		+	\| email \|\| char(255)
		+	\|-
		+	\| fax \|\| char(255)
		+	\|-
		+	\| country \|\| char(255)
	\|}		\|}

xfade: Add garage info

xfade — Wed, 27 May 2009 13:58:48 GMT

Add garage info

← Older revision		Revision as of 13:58, 27 May 2009
Line 1:		Line 1:
-	This page describes which data is needed for a local account in one of the services maemo.org hosts.	+	This page describes which data is needed for a local account in one of the services maemo.org hosts. This data is to be used to specify data fields in LDAP for central storage.

-	Services:	+	==Services==

	{\| class="wikitable sortable"		{\| class="wikitable sortable"
Line 25:		Line 25:
	! Datatype		! Datatype
	\|-		\|-
-	\| ~~username~~ \|\| text	+	\| user_id \|\| int
		+	\|-
		+	\| user_name \|\| text
		+	\|-
		+	\| email \|\| text
		+	\|-
		+	\| realname \|\| char(32)
		+	\|-
		+	\| jabber_address \|\| text
		+	\|-
		+	\| address \|\| text
		+	\|-
		+	\| phone \|\| text
		+	\|-
		+	\| fax \|\| text
		+	\|-
		+	\| title \|\| text
		+	\|-
		+	\| firstname \|\| text
		+	\|-
		+	\| lastname \|\| text
		+	\|-
		+	\| address2 \|\| text
		+	\|-
		+	\| ccode \|\| char(2)
	\|}		\|}

xfade: First draft, needs actual data ;)

xfade — Wed, 27 May 2009 13:48:04 GMT

First draft, needs actual data ;)

New page

This page describes which data is needed for a local account in one of the services maemo.org hosts.

Services:

{| class="wikitable sortable"
|-
! Service
! Framework
|-
| maemo.org || Midgard
|-
| garage.maemo.org || G-Forge
|-
| bugs.maemo.org || Bugzilla
|-
| talk.maemo.org || vBulletin
|-
| wiki.maemo.org || Mediawiki
|}

=== Garage ===
{| class="wikitable sortable"
|-
! Field
! Datatype
|-
| username || text
|}