processone / ejabberd

Robust, Ubiquitous and Massively Scalable Messaging Platform (XMPP, MQTT, SIP Server)
https://www.process-one.net/en/ejabberd/
Other
6k stars 1.5k forks source link

Registration date not stored when using Mnesia #4173

Open Dunedan opened 4 months ago

Dunedan commented 4 months ago

Environment

Bug description

When using an SQL database backend, the users table contains a created_at column, containing the timestamp of the user registration. That doesn't seem to be the case when using Mnesia as database backend, as there isn't such a field in the passwd table. Having the registration date available when using Mnesia as well would be quite valuable.

Also with the current behavior, when using the export2sql command to migrate from Mnesia to an SQL database, this results in created_at being populated with the date of the migration, instead of the registration date or no date at all, leading to wrong registration dates after the migration.