Using mysql

[mjac1521]

Hi,
thank again for all this awesome work.
I am trying to use mysql but as soon as I replace sql by mysql in the lines bellow and restart the smtp it does not start
[database."sql"]
[database."sql".lookup]

What I am trying to do is to verify the domains from a mysql DB but as soon as I use mysql as the driver the smtp service stop working.

[database."mysql"]
address = "mysql://user:password@localhost/DB"

[database."mysql".lookup]
domains = "SELECT EXISTS(SELECT 1 FROM domain WHERE name=? LIMIT 1)"

[list]
domains = "db/mysql/domains"

Sincerely Maykel

[mdecimus]

Hi,

Please set the logging level to debug and post the logs here. The documentation at https://stalw.art/smtp explains how to change the logging levels.

[mjac1521]

Hi,
This is the output when I restart the smtp server. Log is in debug mode.

2023-06-06T02:53:09.850197Z DEBUG stalwart_smtp: Received SIGINT. 2023-06-06T02:53:09.851078Z INFO stalwart_smtp: Shutting down Stalwart SMTP server v0.1.1... 2023-06-06T02:53:09.851227Z DEBUG listener{id="submission" bind.ip="0.0.0.0" bind.port=587 tls=false}: stalwart_smtp::inbound::spawn: Listener shutting down. event="shutdown" 2023-06-06T02:53:09.851528Z DEBUG stalwart_smtp::core::management: Management interface shutting down. event="shutdown" 2023-06-06T02:53:09.851604Z DEBUG listener{id="submissions" bind.ip="0.0.0.0" bind.port=465 tls=true}: stalwart_smtp::inbound::spawn: Listener shutting down. event="shutdown" 2023-06-06T02:53:09.851634Z DEBUG listener{id="smtp" bind.ip="0.0.0.0" bind.port=25 tls=false}: stalwart_smtp::inbound::spawn: Listener shutting down. event="shutdown"

[mdecimus]

This is strange. Could you try using a test SQLite database to see if this happens as well?

[mjac1521]

Hi,
Thank again for all the support I found the issue. When using mysql you must also setup mysql in the variable bellow or comment it even if you are not using it.
[sieve]
use-database = "sql"