1 Topic by kazix

  • kazix
  • Member
  • Offline
  • Registered: 2011-07-20
  • Posts: 30

Topic: MySql User and SSL

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version: Centos / Ubuntu / FreeBSD
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue:
====

Hello,

I have dedicated server for MariaDB (no local DB for iRedMail).
Is there any chance to set SSL option for MariaDB users (iredadmin, iredapd, etc.)?

kazix

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: MySql User and SSL

iRedAdmin uses web.py as SQL ORM, it uses python-MySQLdb module for MySQL connection, and psycopg module for PostgreSQL connection. So you can pass arguments used for ssl related connections to web.database(), like this one:
https://bitbucket.org/zhb/iredadmin-ose … core.py-14

3 Reply by kazix

  • kazix
  • Member
  • Offline
  • Registered: 2011-07-20
  • Posts: 30

Re: MySql User and SSL

ok, maybe iRedMail can work with MySQL SSL (with python files modification).
but there are roundcube, sogo, amavis - they dont have default support for SSL...
too many files to modification (i'm not a programmer)

Simple is better than complex.

so stay on localhost - maybe in next iRedMail version will be support for MySQL SSL smile

kazix

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: MySql User and SSL

kazix wrote:

maybe in next iRedMail version will be support for MySQL SSL

It's now on my todo list, but no promise when it will be implemented. sorry.