Topic: Integrating Mailman into Iredmail v0.8.7 / postgresql
==== Required information ====
- iRedMail version: v0.8.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Linux/BSD distribution name and version: Centos 6.5, Linux 3.14.4-x86_64-linode40 on x86_64
- Related log if you're reporting an issue: n/a
I found an old article in the wiki on how to integrate mailman into debian. figured it would be similar enough that i could follow it. Well, the first SQL command to insert necessary list data was:
INSERT INTO `vmail`.`domain` (`domain`, `description`, `disclaimer`, `aliases`, `mailboxes`, `maxquota`, `quota`, `transport`, `backupmx`, `defaultuserquota`, `defaultuseraliases`, `defaultpasswordscheme`, `minpasswordlength`, `maxpasswordlength`, `created`, `modified`, `expired`, `active`) VALUES ('lists.example.com', '', '', '0', '0', '0', '0', 'mailman:', '0', '1024', '', '', '0', '0', NOW(), '0000-00-00 00:00:00', '9999-12-31 00:00:00', '1');
First, how to translate this into PGSQL syntax (as it was written for MySQL) (I think I figured out already how to convert it so this is really a secondary concern)?
Second, This statement references tables that were removed as part of the v0.8.7 upgrade; so how do i adjust this to accommodate the recent changes?
Third, there are more SQL steps after this one and going forward to add new lists, etc.... Do you have an overall guide to cover this w/ v0.8.7 iredmail and mailman w/ postgresql? Thanks.
- Fabian S.