[GH-ISSUE #1297] Remote SQL authentication #1045

New issue

Closed

opened 2026-02-27 11:14:56 +03:00 by kerem · 4 comments

kerem commented

2026-02-27 11:14:56 +03:00

Owner

Originally created by @arduino43 on GitHub (Nov 14, 2017).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/1297

Impacted versions

Modoboa: Latest
installer used: Yes
Webserver: Nginx

Steps to reproduce

Run installer with 'installer.cfg' the following options set:

engine = mysql
host = 1.1.1.1

Current behavior

When using a remote SQL server Modoboa fails. Some tables are not created for each database - spamassassin, amavis and modoboa. It appears that at some point during the installation script modoboa sets the SQL account to use 'modoboa@localhost', causing the remote SQL server to reject authentication attempts.

Does Modoboa support remote SQL server authentication?

Originally created by @arduino43 on GitHub (Nov 14, 2017). Original GitHub issue: https://github.com/modoboa/modoboa/issues/1297 # Impacted versions * Modoboa: Latest * installer used: Yes * Webserver: Nginx # Steps to reproduce Run installer with 'installer.cfg' the following options set: engine = mysql host = 1.1.1.1 # Current behavior When using a remote SQL server Modoboa fails. Some tables are not created for each database - spamassassin, amavis and modoboa. It appears that at some point during the installation script modoboa sets the SQL account to use 'modoboa@localhost', causing the remote SQL server to reject authentication attempts. Does Modoboa support remote SQL server authentication?

kerem

2026-02-27 11:14:56 +03:00

closed this issue
added the
bug

feedback-needed
labels

kerem commented

2026-02-27 11:14:56 +03:00

Author

Owner

@tonioo commented on GitHub (Mar 9, 2018):

@arduino43 The database users are creating using this method: https://github.com/modoboa/modoboa-installer/blob/master/modoboa_installer/database.py#L174. I'm not a mariadb/mysql expert but the installer does create a rule for @% which is supposed to allow connection from anywhere, right?

@tonioo commented on GitHub (Mar 9, 2018): @arduino43 The database users are creating using this method: https://github.com/modoboa/modoboa-installer/blob/master/modoboa_installer/database.py#L174. I'm not a mariadb/mysql expert but the installer does create a rule for @% which is supposed to allow connection from anywhere, right?

kerem commented

2026-02-27 11:14:56 +03:00

Author

Owner

@kryskool commented on GitHub (Mar 24, 2018):

ping @arduino43

@kryskool commented on GitHub (Mar 24, 2018): ping @arduino43

kerem commented

2026-02-27 11:14:56 +03:00

Author

Owner

@arduino43 commented on GitHub (Mar 31, 2018):

but is Modoboa using that account? I haven't checked in quite some time, but I vaguely remember that it did create the account, it just didn't use it after installation.

@arduino43 commented on GitHub (Mar 31, 2018): but is Modoboa using that account? I haven't checked in quite some time, but I vaguely remember that it did create the account, it just didn't use it after installation.

kerem commented

2026-02-27 11:14:56 +03:00

Author

Owner

@tonioo commented on GitHub (Apr 6, 2018):

Yes it is. And tables were missing in every database? That's very strange because I don't see why some tables would created... If it's an authentication issue, nothing should be created.

@tonioo commented on GitHub (Apr 6, 2018): Yes it is. And tables were missing in every database? That's very strange because I don't see why some tables would created... If it's an authentication issue, nothing should be created.