Re: dbmail configuration
James Greig <[email protected]> Sun, 5 Apr 2020 22:32:19 +0000
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
--===============7917510409328421070== Content-Language: en-US Content-Type: multipart/alternative; boundary="_000_fe356b94f3334cc69c718fa819d92612hostitcouk_" --_000_fe356b94f3334cc69c718fa819d92612hostitcouk_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable It was good whilst it lasted, it fairs well for a small setup but that can = soon spiral into a large install so If it helps anyone moving to dovecot, a= few years back I produced a patch for dbmail-export to output into maildir= ++ format mbox's along with a subscriptions file (this works fine for dovec= ot 2.2 as opposed to 2.3 where the inbox namespace has changed slightly). = Unfortunately, the patch remains open and uncommitted on github but you're = welcome to use the rough code on export.c:- https://github.com/pjstevns/dbmail/pull/43/commits/4a0909a02b220f3e16fbc66e= fa03d7554ecde3a5?diff=3Dsplit&w=3D1 This helped us to eventually move several thousand mailboxes. Regards James Greig From: DBmail <[email protected]> On Behalf Of David in Denver Sent: 03 April 2020 20:22 To: [email protected] Subject: [Dbmail] dbmail configuration Installing 3.2.3 on debian 9, postgres 9.6.17 WHY WHY WHY! is the documentation STILL so incomplete? Why hasn't anyone p= ut a COMPLETE minimum working example of master.cf, main.cf, sql-recipients= .cf, sql-virtual_mailbox_domains.cf, sql-virtual_mailbox_maps.cf, and pg_hb= a.conf? I've looked and can't find anything for 3.2.3 -- oh, there's stuff= out there that is outdated by a decade, but nothing current that I can fin= d. Do you have to start the imapd or other services, or do they start on their= own? what's the difference if I use ldap vs. sql as a driver? if I use pg= sql as a hash to the postgres tables, does that mean I should use ldap as t= he hash instead? chroot default changed to yes from no, does that mean the= smtp line needs to be changed or the dbmail-lmtp line at the end of master= .cf? What's this 'compatability' line? set at 2? What does that mean, oh, look,= no documentation. If I'm using old config files from version 2, should it= be changed to something else? Why isn't there an install script that downloads installs and configures po= stfix, postgresql and dbmail (or other combinations)? Millions of man-hour= s to write awesome software, loads of documentation, and as nebulous and un= usable as ever. This is the reason people don't want to migrate away from = Microsuck operating systems. RE: 3.2.3/INSTALL, part 2. ..."Edit the dbmail.conf file and set everythin= g to your likings." What? what does that mean? Why not provide a MWE of w= hat dbmail.conf should look like and explain anything that shouldn't be lef= t default. In my case, I can't insert users using dbmail-users; and you don't have any= troubleshooting FAQs on your website or on the Install docs. Maybe, becau= se of my frustration over this, I've missed something, but I've spent 3 who= le days on this ONE issue. Someone (group) really needs to work on an inst= all script. I need to be put back on the mail server. --_000_fe356b94f3334cc69c718fa819d92612hostitcouk_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:= //www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"= > <meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman",serif;} a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;} p {mso-style-priority:99; margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman",serif;} p.msonormal0, li.msonormal0, div.msonormal0 {mso-style-name:msonormal; margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman",serif;} span.EmailStyle19 {mso-style-type:personal-reply; font-family:"Calibri",sans-serif; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> </head> <body lang=3D"EN-GB" link=3D"#0563C1" vlink=3D"#954F72"> <div class=3D"WordSection1"> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ar= ial",sans-serif;color:black;mso-fareast-language:EN-US">It was good wh= ilst it lasted, it fairs well for a small setup but that can soon spiral in= to a large install so If it helps anyone moving to dovecot, a few years back I produced a patch for dbmail-export to outpu= t into maildir++ format mbox’s along with a subscriptions fil= e (this works fine for dovecot 2.2 as opposed to 2.3 where the inbox namesp= ace has changed slightly). Unfortunately, the patch remains open and uncommitted on github but you’re welcome to u= se the rough code on export.c:-<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ar= ial",sans-serif;color:black;mso-fareast-language:EN-US"><o:p> </o= :p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ar= ial",sans-serif;color:black;mso-fareast-language:EN-US"><a href=3D"htt= ps://github.com/pjstevns/dbmail/pull/43/commits/4a0909a02b220f3e16fbc66efa0= 3d7554ecde3a5?diff=3Dsplit&w=3D1"><span style=3D"color:black">https://g= ithub.com/pjstevns/dbmail/pull/43/commits/4a0909a02b220f3e16fbc66efa03d7554= ecde3a5?diff=3Dsplit&w=3D1</span></a><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ar= ial",sans-serif;color:black;mso-fareast-language:EN-US"><o:p> </o= :p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ar= ial",sans-serif;color:black;mso-fareast-language:EN-US">This helped us= to eventually move several thousand mailboxes.<o:p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-= family:"Arial",sans-serif;color:black"><o:p> </o:p></span></= p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-= family:"Arial",sans-serif;color:black">Regards<o:p></o:p></span><= /p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-= family:"Arial",sans-serif;color:black"><o:p> </o:p></span></= p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-= family:"Arial",sans-serif;color:black">James Greig<o:p></o:p></sp= an></p> <div> <div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm = 0cm 0cm"> <p class=3D"MsoNormal"><b><span lang=3D"EN-US" style=3D"font-size:11.0pt;fo= nt-family:"Calibri",sans-serif">From:</span></b><span lang=3D"EN-= US" style=3D"font-size:11.0pt;font-family:"Calibri",sans-serif"> = DBmail <[email protected]> <b>On Behalf Of </b>David in Denver<br> <b>Sent:</b> 03 April 2020 20:22<br> <b>To:</b> [email protected]<br> <b>Subject:</b> [Dbmail] dbmail configuration<o:p></o:p></span></p> </div> </div> <p class=3D"MsoNormal"><o:p> </o:p></p> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black">Installing 3.2.3 on debian 9, postgres 9.6.17<o:p></o:p>= </span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black"><o:p> </o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black">WHY WHY WHY! is the documentation STILL so incomplete? &= nbsp;Why hasn't anyone put a COMPLETE minimum working example of master.cf,= main.cf, sql-recipients.cf, sql-virtual_mailbox_domains.cf, sql-virtual_mailbox_maps.cf, and pg_hba.conf? I've looked and can't = find anything for 3.2.3 -- oh, there's stuff out there that is outdated by = a decade, but nothing current that I can find.<o:p></o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black"><o:p> </o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black">Do you have to start the imapd or other services, or do = they start on their own? what's the difference if I use ldap vs. sql as a d= river? if I use pgsql as a hash to the postgres tables, does that mean I should use ldap as the hash instead? chroot= default changed to yes from no, does that mean the smtp line needs to be c= hanged or the dbmail-lmtp line at the end of master.cf?<o:p></o:p></span></= p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black"><o:p> </o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black">What's this 'compatability' line? set at 2? What d= oes that mean, oh, look, no documentation. If I'm using old config fi= les from version 2, should it be changed to something else?<o:p></o:p></spa= n></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black"><o:p> </o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black">Why isn't there an install script that downloads install= s and configures postfix, postgresql and dbmail (or other combinations)? &n= bsp;Millions of man-hours to write awesome software, loads of documentation, and as nebulous and unusable as ever. This i= s the reason people don't want to migrate away from Microsuck operating sys= tems.<o:p></o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black"><o:p> </o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black">RE: 3.2.3/INSTALL, part 2. ..."Edit the dbmai= l.conf file and set everything to your likings." What? what does= that mean? Why not provide a MWE of what dbmail.conf should look like and explain anything that shouldn't be left default.<o:p></o:p></span= ></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black"><o:p> </o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black">In my case, I can't insert users using dbmail-users; and= you don't have any troubleshooting FAQs on your website or on the Install = docs. Maybe, because of my frustration over this, I've missed something, but I've spent 3 whole days on this ONE issue. &nbs= p;Someone (group) really needs to work on an install script.<o:p></o:p></sp= an></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black"><o:p> </o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Calibri",sans-= serif;color:black">I need to be put back on the mail server.<o:p></o:p></sp= an></p> </div> </div> </body> </html> --_000_fe356b94f3334cc69c718fa819d92612hostitcouk_-- --===============7917510409328421070== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KREJtYWlsIG1h aWxpbmcgbGlzdApEQm1haWxAbGlzdHMubmZnLm5sCmh0dHBzOi8vbGlzdHMubmZnLm5sL2NnaS1i aW4vbWFpbG1hbi9saXN0aW5mby9kYm1haWwK --===============7917510409328421070==--