Олег Давидович в 09:07, 5 февраля 2026

2026-02-05T09:07:51Z

← Предыдущая версия		Версия от 09:07, 5 февраля 2026
Строка 43:		Строка 43:
	*[[External database enrolment]]		*[[External database enrolment]]

	[[de:~~Externe Datenbank~~]]		[[Категория:Аутентификация]]
	[[fr:~~Authentification par base de données externe]]~~		[[Категория:Способы зачисления на курс]]
	~~[[ja:外部データベース認証]]~~
	~~[[es:Autenticación con BasedeDatos externa~~]]

Олег Давидович: 1 версия импортирована

2024-10-14T18:17:38Z

1 версия импортирована

← Предыдущая версия	Версия от 18:17, 14 октября 2024
(нет различий)

1>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)

Новая страница

{{Authentication}}
Location: '' Site administration > Plugins > Authentication > 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 ==

This is done by mapping fields at the bottom of the database authentication page. Each data field in the user profile has a text field next to it. Enter the name of the column in the external database that maps to the profile data field.

'''Update Local''' - Specifies that the external data will be entered into the local field in question
* On Creation - specifies that this will only happen on the original login when the account is created for the first time.
* On Every Login - specifies that changes in the external data will be updated on the local Moodle field in question the next time the user logs in again.

'''Update External''' - Specifies just the opposite, meaning changes in the local Moodle field in question will update the corresponding field in the external database
* Never - Specifies this is disabled
* On Update - Enables this to happen if a change is made locally (additional configuration is probably required)

'''Lock Value''' - Only determines whether the local user can make a change in the Moodle field and does not affect the two settings above.
* Unlocked - A user can make changes locally in the Moodle field (assumably even if it contradicts the external database the next login would change it again if Update Local is set
* Locked - A user can never make changes
* Unlocked if empty - A user can only make changes if the field is not populated already from the external database (this would seem to indicate a user could only enter something into this field once and could not change it after saving)

== 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, 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.

If you have custom profile fields on your site, these can also be synced with this scheduled task.

==Additional Notes==

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]]

* Plain text password matching is now always case sensitive
* 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, 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==

*[[External database enrolment]]

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

External database authentication - История изменений

Олег Давидович в 09:07, 5 февраля 2026

Олег Давидович: 1 версия импортирована

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