Userli migrated from swiftmailer-bundle to symfony/mailer. Remove environment
variable MAILER_URL
and replace it with MAILER_DSN
. See .env
file for the
syntax.
The new twofactor authentication (2FA) feature requires the database schema to be updated:
ALTER TABLE virtual_users
ADD totp_confirmed TINYINT(1) DEFAULT 0 NOT NULL,
ADD totp_secret VARCHAR(255) DEFAULT NULL;
ADD totp_backup_codes LONGTEXT NOT NULL;
The new OpenPGP WKD feature requires GnuPG (>=2.1.14) to be installed.
Database schema changed and needs to be updated:
CREATE TABLE virtual_openpgp_keys (
id INT AUTO_INCREMENT NOT NULL,
user_id INT DEFAULT NULL,
email VARCHAR(255) NOT NULL,
key_id LONGTEXT NOT NULL,
key_fingerprint LONGTEXT NOT NULL,
key_expire_time DATETIME DEFAULT NULL,
key_data LONGTEXT NOT NULL,
UNIQUE INDEX UNIQ_3DB259EAE7927C74 (email),
INDEX IDX_3DB259EAA76ED395 (user_id),
PRIMARY KEY(id))
DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB;
ALTER TABLE virtual_openpgp_keys
ADD CONSTRAINT FK_3DB259EAA76ED395 FOREIGN KEY (user_id) REFERENCES virtual_users (id);
The MAIL_CRYPT_*
Dotenv variables were merged into one variable:
MAIL_CRYPT=2
See the documentation for further information on supported values.
The DOMAIN
Dotenv variable is now obsolete. It is replaced
by the first created domain at the moment.
New optional Dotenv variable was added to link to webmail:
WEBMAIL_URL="roundcube.example.org"
Database schema changed and needs to be updated:
ALTER TABLE virtual_users
ADD recovery_secret_box LONGTEXT DEFAULT NULL,
ADD recovery_start_time DATETIME DEFAULT NULL,
ADD mail_crypt TINYINT(1) DEFAULT '0' NOT NULL,
ADD mail_crypt_secret_box LONGTEXT DEFAULT NULL,
ADD mail_crypt_public_key LONGTEXT DEFAULT NULL,
CHANGE creationTime creation_time DATETIME NOT NULL,
CHANGE updatedTime updated_time DATETIME NOT NULL,
CHANGE lastlogin last_login_time DATETIME DEFAULT NULL,
CHANGE passwordversion password_version INT NOT NULL;
ALTER TABLE virtual_aliases
CHANGE creationTime creation_time DATETIME NOT NULL,
CHANGE updatedTime updated_time DATETIME NOT NULL;
ALTER TABLE virtual_vouchers
CHANGE creationTime creation_time DATETIME NOT NULL,
CHANGE redeemedTime redeemed_time DATETIME DEFAULT NULL;
ALTER TABLE virtual_reserved_names
CHANGE creationTime creation_time DATETIME NOT NULL,
CHANGE updatedTime updated_time DATETIME NOT NULL;
ALTER TABLE virtual_domains
CHANGE creationTime creation_time DATETIME NOT NULL,
CHANGE updatedTime updated_time DATETIME NOT NULL;
Dotenv variable SEND_WELCOME_MAIL
was renamed to SEND_MAIL
:
sed -i -e 's/SEND_WELCOME_MAIL/SEND_MAIL/g' .env
New mandatory Dotenv variables were added (all related to MailCrypt):
MAIL_CRYPT_ENABLED=1
MAIL_CRYPT_AUTO=1
Trailing slashes have been removed from default URLs:
sed -e 's#^\(APP_URL=".*\)/"#\1#g' .env
sed -e 's#^\(PROJECT_URL=".*\)/"#\1#g' .env
Use 0/1 instead of false/true in .env
sed -i -e 's/="true"/=1/g' .env
sed -i -e 's/="false"/=0/g' .env