DSN

8min
Description
The DSN is a connection string that contains all the necessary connection parameters in a single expression. In Passwork, parameters are used for this purpose:
A configuration line in Passwork that defines which way and through which provider to send mail. It specifies the type of transport, API key or authorization data, and additional parameters.
Specifies the email address that is used as the default notification sender in Passwork.
Setup
Edit the Passwork configuration file:
Linux — /var/www/init/config.env
Windows Server — C:\inetpub\wwwroot\passwork\init\config.env
Docker — /<passwork>/conf/keys/config.env
Basic DSN configuration example:
shell
MAILER_DSN=smtp://[email protected]:cdfe%20dynv%20pjxz%[email protected]:465
APP_SENDER_EMAIL=[email protected]
MAILER_DSN=smtp://username@passwork.com:cdfe%20dynv%20pjxz%20odob@smtp.passwork.com:465
APP_SENDER_EMAIL=username@passwork.com
﻿
smtp:// — protocol that is used to send emails
[email protected] — login for connection (user name)
cdfe%20dynv%20pjxz%20odob — password, spaces replaced by %20 (URL encoding)
smtp.passwork.com — the address of the server through which the e-mails will be sent
465 — port, used for secure SMTP connections (SSL)
Restart PHP:
DEB
RPM
systemctl restart php-fpm.service
systemctl restart php-fpm.service
﻿
Clear Passwork temporary cache:
DEB
RPM
Windows Server
cd "C:\inetpub\wwwroot\passwork"
php -d "memory_limit=-1" .\bin\console cache:clear
cd "C:\inetpub\wwwroot\passwork"
php -d "memory_limit=-1" .\bin\console cache:clear
﻿
Examples of DSN strings
Gmail with SSL (port 465):
shell
MAILER_DSN=smtp://[email protected]:[email protected]:465
MAILER_DSN=smtp://username@gmail.com:application_password@smtp.gmail.com:465
﻿
Gmail with TLS (port 587):
shell
MAILER_DSN=smtp://[email protected]:[email protected]:587?encryption=tls
MAILER_DSN=smtp://username@gmail.com:application_password@smtp.gmail.com:587?encryption=tls
﻿
Mailtrap with TLS:
shell
MAILER_DSN=smtp://username:[email protected]:2525?encryption=tls
MAILER_DSN=smtp://username:password@smtp.mailtrap.io:2525?encryption=tls
﻿
SMTP server without encryption:
shell
MAILER_DSN=smtp://username:[email protected]:25
MAILER_DSN=smtp://username:password@smtp.server:25
﻿
SMTP server with TLS encryption on port 587:
shell
MAILER_DSN=smtp://username:[email protected]:587?encryption=tls
MAILER_DSN=smtp://username:password@smtp.server:587?encryption=tls
﻿
SMTP server with SSL encryption on port 465:
shell
MAILER_DSN=smtp://username:[email protected]:465
MAILER_DSN=smtp://username:password@smtp.server:465
﻿
﻿
Mailer config
Postfix