Re: dbmail configuration
Thomas Raschbacher <[email protected]> Mon, 06 Apr 2020 08:06:37 +0200
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
--===============0967457979886301130== Content-Type: multipart/alternative; boundary="=_459737a44932ead74c179523e4b5353e" --=_459737a44932ead74c179523e4b5353e Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII Yeah I know what you mean .. I am still running 2 dbamil servers.. but on one i have the problem that some users have a lot of folders .. and the code to fetch the folder list on DBmail is horribly inefficient (should really be done as stored procedures or soemthing ) Unfortunately I am lacking the time to fix/imporve it .. With a server move imminent I am really not sure if i should/can keep using dbmail or rather give up (For now at least) and use courier-imap or dovecot as well .. :( On 2020-04-06 00:32, James Greig wrote: > 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 dovecot 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/4a0909a02b220f3e16fbc66efa03d7554ecde3a5?diff=split&w=1 [1] > > 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 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. > > 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 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 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 postfix, postgresql and dbmail (or other combinations)? Millions of man-hours to write awesome software, loads of documentation, and as nebulous and unusable 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 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. > > 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. Someone (group) really needs to work on an install script. > > I need to be put back on the mail server. > _______________________________________________ > DBmail mailing list > [email protected] > https://lists.nfg.nl/cgi-bin/mailman/listinfo/dbmail Links: ------ [1] https://github.com/pjstevns/dbmail/pull/43/commits/4a0909a02b220f3e16fbc66efa03d7554ecde3a5?diff=split&w=1 --=_459737a44932ead74c179523e4b5353e Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=UTF-8 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset= =3DUTF-8" /></head><body style=3D'font-size: 10pt; font-family: Verdana,Gen= eva,sans-serif'> <p>Yeah I know what you mean .. I am still running 2 dbamil servers.. but o= n one i have the problem that some users have a lot of folders .. and the c= ode to fetch the folder list on DBmail is horribly inefficient (should real= ly be done as stored procedures or soemthing )</p> <p>Unfortunately I am lacking the time to fix/imporve it ..</p> <p>With a server move imminent I am really not sure if i should/can keep us= ing dbmail or rather give up (For now at least) and use courier-imap or dov= ecot as well .. :(</p> <p>On 2020-04-06 00:32, James Greig wrote:</p> <blockquote type=3D"cite" style=3D"padding: 0 0.4em; border-left: #1010ff 2= px solid; margin: 0"><!-- html ignored --> <!-- head ignored --><!-- meta i= gnored --> <!-- meta ignored --> <div class=3D"WordSection1"> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black; mso-fareast-language: EN-US;">It was good whil= st 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&r= squo;s along with a subscriptions file (this works fine for dovecot 2.2 as = opposed to 2.3 where the inbox namespace has changed slightly). Unfor= tunately, the patch remains open and uncommitted on github but you’re= welcome to use the rough code on export.c:-<!-- o ignored --></span></p> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black; mso-fareast-language: EN-US;"><!-- o ignored -= -> </span></p> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black; mso-fareast-language: EN-US;"><a href=3D"https= ://github.com/pjstevns/dbmail/pull/43/commits/4a0909a02b220f3e16fbc66efa03d= 7554ecde3a5?diff=3Dsplit&w=3D1" target=3D"_blank" rel=3D"noopener noref= errer"><span style=3D"color: black;">https://github.com/pjstevns/dbmail/pul= l/43/commits/4a0909a02b220f3e16fbc66efa03d7554ecde3a5?diff=3Dsplit&w=3D= 1</span></a><!-- o ignored --></span></p> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black; mso-fareast-language: EN-US;"><!-- o ignored -= -> </span></p> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black; mso-fareast-language: EN-US;">This helped us t= o eventually move several thousand mailboxes.<!-- o ignored --></span></p> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black;"><!-- o ignored --> </span></p> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black;">Regards<!-- o ignored --></span></p> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black;"><!-- o ignored --> </span></p> <p class=3D"MsoNormal"><span style=3D"font-size: 11.0pt; font-family: 'Aria= l',sans-serif; color: black;">James Greig<!-- o ignored --></span></p> <div> <div style=3D"border: none; border-top: solid #E1E1E1 1.0pt; padding: 3.0pt= 0cm 0cm 0cm;"> <p class=3D"MsoNormal"><strong><span style=3D"font-size: 11.0pt; font-famil= y: 'Calibri',sans-serif;">From:</span></strong><span style=3D"font-size: 11= =2E0pt; font-family: 'Calibri',sans-serif;"> DBmail <dbmail-bounces@list= s.nfg.nl> <strong>On Behalf Of </strong>David in Denver<br /> <strong>Se= nt:</strong> 03 April 2020 20:22<br /> <strong>To:</strong> dbmail@dbmail= =2Eorg<br /> <strong>Subject:</strong> [Dbmail] dbmail configuration<!-- o = ignored --></span></p> </div> </div> <p class=3D"MsoNormal"><!-- o ignored --> </p> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;">Installing 3.2.3 on debian 9, postgres 9.6.17<!-- o ignored --= ></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;"><!-- o ignored --> </span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;">WHY WHY WHY! is the documentation STILL so incomplete? W= hy hasn't anyone put a COMPLETE minimum working example of master.cf, main= =2Ecf, sql-recipients.cf, sql-virtual_mailbox_domains.cf, sql-virtual_mailb= ox_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 noth= ing current that I can find.<!-- o ignored --></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;"><!-- o ignored --> </span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;">Do you have to start the imapd or other services, or do they s= tart on their own? what's the difference if I use ldap vs. sql as a driver?= if I use pgsql as a hash to the postgres tables, does that mean I sh= ould use ldap as the hash instead? chroot default changed to yes from= no, does that mean the smtp line needs to be changed or the dbmail-lmtp li= ne at the end of master.cf?<!-- o ignored --></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;"><!-- o ignored --> </span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;">What's this 'compatability' line? set at 2? What does th= at mean, oh, look, no documentation. If I'm using old config files fr= om version 2, should it be changed to something else?<!-- o ignored --></sp= an></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;"><!-- o ignored --> </span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;">Why isn't there an install script that downloads installs and = configures postfix, postgresql and dbmail (or other combinations)? Mi= llions of man-hours to write awesome software, loads of documentation,= and as nebulous and unusable as ever. This is the reason people don'= t want to migrate away from Microsuck operating systems.<!-- o ignored --><= /span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;"><!-- o ignored --> </span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;">RE: 3.2.3/INSTALL, part 2. ..."Edit the dbmail.conf file= and set everything to your likings." What? what does that mean? &nbs= p;Why not provide a MWE of what dbmail.conf should look like and explain an= ything that shouldn't be left default.<!-- o ignored --></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;"><!-- o ignored --> </span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;">In my case, I can't insert users using dbmail-users; and you d= on't have any troubleshooting FAQs on your website or on the Install docs= =2E Maybe, because of my frustration over this, I've missed something= , but I've spent 3 whole days on this ONE issue. Someone (group) real= ly needs to work on an install script.<!-- o ignored --></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;"><!-- o ignored --> </span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-family: 'Calibri',sans-serif; co= lor: black;">I need to be put back on the mail server.<!-- o ignored --></s= pan></p> </div> </div> <!-- html ignored --><br /> <div class=3D"pre" style=3D"margin: 0; padding: 0; font-family: monospace">= _______________________________________________<br /> DBmail mailing list<b= r /> <a href=3D"mailto:[email protected]">[email protected]</a><br /> <= a href=3D"https://lists.nfg.nl/cgi-bin/mailman/listinfo/dbmail" target=3D"_= blank" rel=3D"noopener noreferrer">https://lists.nfg.nl/cgi-bin/mailman/lis= tinfo/dbmail</a></div> </blockquote> <p><br /></p> </body></html> --=_459737a44932ead74c179523e4b5353e-- --===============0967457979886301130== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KREJtYWlsIG1h aWxpbmcgbGlzdApEQm1haWxAbGlzdHMubmZnLm5sCmh0dHBzOi8vbGlzdHMubmZnLm5sL2NnaS1i aW4vbWFpbG1hbi9saXN0aW5mby9kYm1haWwK --===============0967457979886301130==--