External database authentication - Revision history

Leonstr: /* Automatic Synchronisation */ auth/db/cli/sync_users.php has been deprecated since Moodle 3.3 (MDL-57913)

2021-03-12T13:11:04Z

Automatic Synchronisation: auth/db/cli/sync_users.php has been deprecated since Moodle 3.3 (MDL-57913)

← Older revision		Revision as of 13:11, 12 March 2021
Line 24:		Line 24:
	== Automatic Synchronisation ==		== Automatic Synchronisation ==

	The above method adds new users only when they log in. If you want user accounts to be created in Moodle independent of actual logins, the ~~db authentication plugin offers a script you can run regularly via~~ '~~cron~~'. ~~A typical cron entry will be as follows..~~.		The above method adds new users only when they log in. If you want user accounts to be created in Moodle independent of actual logins, you must enable the auth_db ''Synchronise users task'' (\auth_db\task\sync_users) on the [[Scheduled tasks]] page. By default this runs once a day, adjust the schedule to run this more frequently if required.

	~~<pre>~~		If you have custom profile fields on your site, these can also be synced with this scheduled task.
	~~0 * * * * /usr/bin/php /path/to/moodle/auth/db/cli/sync_users.php >dev/null~~
	~~</pre>~~

	~~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/310/en/Scheduled_tasks]~~

	If you have custom profile fields on your site, these can be synced with ~~External database authentication~~.

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

Leonstr: /* Automatic Synchronisation */ MDL-56093 was resolved in 3.5.2

2019-03-09T15:07:59Z

Automatic Synchronisation: MDL-56093 was resolved in 3.5.2

← Older revision		Revision as of 15:07, 9 March 2019
Line 35:		Line 35:
	Information on scheduled tasks can be found here: [https://docs.moodle.org/310/en/Scheduled_tasks]		Information on scheduled tasks can be found here: [https://docs.moodle.org/310/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.

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

Cescobedo at 21:20, 15 January 2019

2019-01-15T21:20:36Z

← Older revision		Revision as of 21:20, 15 January 2019
Line 3:		Line 3:


	This method uses an external database table to check whether a given username and password is valid. If the user does not currently exist in Moodle a new account will be created and their information copied from the external database.		This method uses an external database table to check whether a given username (which must be varchar) and password is valid. If the user does not currently exist in Moodle a new account will be created and their information copied from the external database.

	== Field mappings ==		== Field mappings ==

Tsala: /* See also */ removing very old forum discussion links

2018-10-25T06:29:42Z

See also: removing very old forum discussion links

← Older revision		Revision as of 06:29, 25 October 2018
Line 49:		Line 49:
	* 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		* 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=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]]

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/310/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