phiilu / mailman

Mailman is a GUI to help you manage your email accounts stored in a MySQL/MariaDB database.
MIT License
70 stars 10 forks source link

Configurable db engine #36

Closed Shawn8901 closed 5 years ago

Shawn8901 commented 5 years ago

Hi, I used your frontend for my mailserver a long time. But for switching from mysql to postgres as installed database there were some modifications needed. As Knex is a generic SQL builder the frontend works like a charm with the following change(s).

The parameter change is done due a change in knex, which you already did on your improvements branch. Without the app looked for a database "mailman".

As i am not able to build & run your improvement branch i can just test it for the master. Feel free to include the change.

I refused to push pg as dependency, as you (and also the tutorial for the configuration) mainly supports mysql/mariadb

To use postgresql install pg as dependency, set MAILMAN_DB_ENGINE to pg and restart the service.

phiilu commented 5 years ago

Awesome nice work!