External database authentication - Revision history

Demsley at 13:09, 12 October 2017

2017-10-12T13:09:20Z

← Older revision		Revision as of 13:09, 12 October 2017
Line 31:		Line 31:

	This runs every hour (adjust as required). It reads the entire table updating and creating local Moodle users.		This runs every hour (adjust as required). It reads the entire table updating and creating local Moodle users.

			NB when you run this you get the error "[AUTH DB] The sync users cron has been depricated. Please use the scheduled task instead."
			Information on scheduled tasks can be found here: [https://docs.moodle.org/34/en/Scheduled_tasks]

	If you have custom profile fields on your site, these can be synced with External database authentication (syncing custom profile fields from the external database to Moodle does not currently work, see [https://tracker.moodle.org/browse/MDL-56093]).		If you have custom profile fields on your site, these can be synced with External database authentication (syncing custom profile fields from the external database to Moodle does not currently work, see [https://tracker.moodle.org/browse/MDL-56093]).

Leonstr: /* Automatic Synchronisation */ Syncing custom profile fields from an external database does not work currently

2017-08-09T10:04:21Z

Automatic Synchronisation: Syncing custom profile fields from an external database does not work currently

← Older revision		Revision as of 10:04, 9 August 2017
Line 32:		Line 32:
	This runs every hour (adjust as required). It reads the entire table updating and creating local Moodle users.		This runs every hour (adjust as required). It reads the entire table updating and creating local Moodle users.

	If you have custom profile fields on your site, these can be synced with External database authentication.		If you have custom profile fields on your site, these can be synced with External database authentication (syncing custom profile fields from the external database to Moodle does not currently work, see [https://tracker.moodle.org/browse/MDL-56093]).

	==Additional Notes==		==Additional Notes==

Marycooch: copied from 3. 1 docs

2016-11-14T13:37:58Z

copied from 3. 1 docs

← Older revision		Revision as of 13:37, 14 November 2016
Line 44:		Line 44:

	* Some of the things that apply to [[Upload users]] apply to the External database, but not all of the fields in the [[Upload users]] are available for the External Database authentication. The only available fields are the fields listed in the data mapping section of the admin page for the External Database connection.		* Some of the things that apply to [[Upload users]] apply to the External database, but not all of the fields in the [[Upload users]] are available for the External Database authentication. The only available fields are the fields listed in the data mapping section of the admin page for the External Database connection.
			* Note that for MySQL databases moodle will store date custom profile fields in a bigint field (as a unix timestamp). Using a timestamp or datetime field will not work
	==See also==		==See also==
	*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=45444 Special and characters con tilde (accute accent) when connected to external database] forum discussion		*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=45444 Special and characters con tilde (accute accent) when connected to external database] forum discussion

Fox: French link

2016-02-10T08:41:02Z

French link

← Older revision		Revision as of 08:41, 10 February 2016
Line 52:		Line 52:

	[[de:Externe Datenbank]]		[[de:Externe Datenbank]]
	[[fr:~~Utiliser une~~ base de données externe]]		[[fr:Authentification par base de données externe]]
	[[ja:外部データベース認証]]		[[ja:外部データベース認証]]
	[[es:Autenticación con BasedeDatos externa]]		[[es:Autenticación con BasedeDatos externa]]

Johnok: Remove note about changeme for external database

2015-10-15T02:45:38Z

Remove note about changeme for external database

← Older revision		Revision as of 02:45, 15 October 2015
Line 43:		Line 43:
	* sha1/md5 hash comparisons are now enforced case insensitive (as underlying they are hexadecimal values)		* sha1/md5 hash comparisons are now enforced case insensitive (as underlying they are hexadecimal values)

	* Some of the things that apply to [[Upload users]] apply to the External database		* Some of the things that apply to [[Upload users]] apply to the External database, but not all of the fields in the [[Upload users]] are available for the External Database authentication. The only available fields are the fields listed in the data mapping section of the admin page for the External Database connection.
	** Set password to "changeme" to force password reset
	*** If you do this, ~~it is '''critical''' that you provide a URL to change the password!~~
	* Not all of the fields in the [[Upload users]] are available for the External Database authentication. The only available fields are the fields listed in the data mapping section of the admin page for the External Database connection.

	==See also==		==See also==

Tsala: removing new in 2.9 note

2015-10-13T14:25:03Z

removing new in 2.9 note

← Older revision		Revision as of 14:25, 13 October 2015
Line 32:		Line 32:
	This runs every hour (adjust as required). It reads the entire table updating and creating local Moodle users.		This runs every hour (adjust as required). It reads the entire table updating and creating local Moodle users.

	~~'''New in 2.9:'''~~ If you have custom profile fields on your site, these can ~~now~~ be synced with External database authentication.		If you have custom profile fields on your site, these can be synced with External database authentication.

	==Additional Notes==		==Additional Notes==

	~~'''New in 2.9:'''~~ It is now possible to use Salted Crypt passwords for the password format with external database authentication from the Password format setting:		It is now possible to use Salted Crypt passwords for the password format with external database authentication from the Password format setting:
	[[File:dbsaltedcrypt.png\|thumb\|300px\|center]]		[[File:dbsaltedcrypt.png\|thumb\|300px\|center]]


	* Plain text password matching is now always case sensitive		* Plain text password matching is now always case sensitive
	* sha1/md5 hash comparisons are now enforced case insensitive (as underlying they are ~~hexidecimal~~ values)		* sha1/md5 hash comparisons are now enforced case insensitive (as underlying they are hexadecimal values)

	* Some of the things that apply to [[Upload users]] apply to the External database		* Some of the things that apply to [[Upload users]] apply to the External database

Marycooch: /* Additional Notes */

2015-05-07T08:59:04Z

Additional Notes

← Older revision		Revision as of 08:59, 7 May 2015
Line 37:		Line 37:

	'''New in 2.9:''' It is now possible to use Salted Crypt passwords for the password format with external database authentication from the Password format setting:		'''New in 2.9:''' It is now possible to use Salted Crypt passwords for the password format with external database authentication from the Password format setting:
			[[File:dbsaltedcrypt.png\|thumb\|300px\|center]]

Marycooch: salted crypt

2015-05-07T08:58:03Z

salted crypt

← Older revision		Revision as of 08:58, 7 May 2015
Line 35:		Line 35:

	==Additional Notes==		==Additional Notes==

			'''New in 2.9:''' It is now possible to use Salted Crypt passwords for the password format with external database authentication from the Password format setting:


			* Plain text password matching is now always case sensitive
			* sha1/md5 hash comparisons are now enforced case insensitive (as underlying they are hexidecimal values)

	* Some of the things that apply to [[Upload users]] apply to the External database		* Some of the things that apply to [[Upload users]] apply to the External database
	** Set password to "changeme" to force password reset		** Set password to "changeme" to force password reset

Marycooch: custom profile fields

2015-05-05T12:42:25Z

custom profile fields

← Older revision		Revision as of 12:42, 5 May 2015
Line 1:		Line 1:
	{{Authentication}}		{{Authentication}}
	Location: ''~~Settings >~~ Site administration > Plugins > Authentication > External database''		Location: '' Site administration > Plugins > Authentication > External database''


Line 31:		Line 31:

	This runs every hour (adjust as required). It reads the entire table updating and creating local Moodle users.		This runs every hour (adjust as required). It reads the entire table updating and creating local Moodle users.

			'''New in 2.9:''' If you have custom profile fields on your site, these can now be synced with External database authentication.

	==Additional Notes==		==Additional Notes==

Questions: /* See also */

2014-09-12T18:15:41Z

← Older revision		Revision as of 18:15, 12 September 2014
Line 42:		Line 42:
	*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=75519 HELP!--User Authentication problem] forum discussion		*Using Moodle [http://moodle.org/mod/forum/discuss.php?d=75519 HELP!--User Authentication problem] forum discussion
	*[[External database enrolment]]		*[[External database enrolment]]
			*change password in external DB authentication plugin [https://moodle.org/mod/forum/discuss.php?d=269311#p1162046]

	[[de:Externe Datenbank]]		[[de:Externe Datenbank]]