#mysql #vsmtp #plugin

vsmtp-plugin-mysql

A plugin for vSMTP that enable support for mysql databases

1 release (0 unstable)

1.4.0-rc.10 Jan 3, 2023

#1669 in Database interfaces

GPL-3.0-only

340KB
4.5K SLoC


What is vSMTP ?

vSMTP is a next-gen Mail Transfer Agent (MTA), faster, safer and greener.

  • It is 100% built in Rust.
  • It is lighting fast.
  • It is modular and highly customizable.
  • It has a complete filtering system.
  • It is actively developed and maintained.

Faster, Safer, Greener

While optimizing IT resources becomes an increasing challenge, computer attacks remain a constant problem.

Every day, over 300 billion emails are sent and received in the world. Billions of attachments are processed, analyzed and delivered, contributing to the increase in greenhouse gas emissions.

To meet these challenges, viridIT is developing a new technology of email gateways, also called vSMTP.

Follow us on viridit.com

Filtering

vSMTP enable you to create complex set of rules to filter your emails using vSMTP's scripting language (vsl) based on Rhai. You can:

  • inspect / modify the content of incoming emails.
  • forward and deliver emails locally or remotely.
  • connect to databases.
  • run commands.
  • quarantine emails.

and much more.

// -- /etc/vsmtp/service/database.vsl

// vSMTP can be extended with plugins.
import "plugins/vsmtp_plugin_mysql" as mysql;

// Here we declare a service.
// Let's connect to a mysql database.
export const database = mysql::connect(#{
    // the url to connect to the database.
    url: "mysql://localhost/?user=greylist-manager&password=my-password"",
    timeout: "30s",
    connections: 4,
});
// -- /etc/vsmtp/filter.vsl
// Here we declare our rules for filtering.

import "service/database" as db;

#{
  // hook on the 'mail from' stage. (when the server receives the `MAIL FROM:` command)
  mail: [
    rule "greylist" || {
      let sender = ctx::mail_from();

      // is the user in our greylist ?
      if db::greylist.query(`SELECT * FROM greylist.sender WHERE address = '${sender}';`).is_empty() {
        // it does not, we add the address to the database, then deny the email.
        db::greylist.query(`
            INSERT INTO greylist.sender (user, domain, address)
            values ("${sender.local_part}", "${sender.domain}", "${sender}");
        `);
        // close the connection with a built in "451 - 4.7.1" error code.
        state::deny(code::c451_7_1())
      } else {
        // it is, we accept the email.
        state::accept()
      }
    }
  ],
}

Check out the api folder to get a view of what you can do with vsl.

Benchmarks

Comparison between Postfix 3.6.4 & vSMTP 1.0.1 performances, performed on a Ubuntu 22.04 LTS running with an AMD Ryzen 5 5600X 6-Core Processor.

Check out the benchmarks readme to get reproducible examples.

Documentation

In this repository, the "develop" branch is the branch that we work on every day to provide new features. If you want to check examples for the latest vSMTP versions, switch to the "main" branch, where our latest releases are delivered.

For documentation please consult the vBook, the online reference and user guide for vSMTP. Documentation for the "develop" branch is also available in the vBook at https://vsmtp.rs/next

To stay tuned, ask questions and get in-depth answers feel free to join our Discord server. You can also open GitHub discussions.

Roadmap

The next releases "1.4.x" focuses on plugin development for vSMTP. You can find more information about the project agenda in Milestones.

Check out updates history in Changelogs.

A guideline about contributing to vSMTP can be found in the contributing section.

Commercial

We can offer a wide range of services, from design to physical implementation, provide maintenance and develop specific features and dedicated APIs to meet your business needs.

For any question related to commercial, licensing, etc. you can contact us on our website or send a message to contact@viridit.com.

License

The standard version of vSMTP is free and under an Open Source license.

It is provided as usual without any warranty. Please refer to the license for further information.

Dependencies

~47–87MB
~1.5M SLoC