[Dbmail] Setup learn/unlearn spam for rspamd

2019-03-17 Thread Yevgeny Kosarzhevsky
Hello, does anyone have a working sieve script to setup with dbmail to allow learn/unlearn spam while moving/copying mail to/from junk folder? I've found how to make it for dovecot on https://workaround.org/ispmail/stretch/filtering-out-spam-with-rspamd but dovecot uses 'sieve_global_

Re: [Dbmail] testing please ignore

2019-03-05 Thread ballier
Am 05.03.2019 17:47, schrieb Paul J Stevens: test Paul, I can not ignore this email because I am so glad that you are interested in dbmail again. I sincerely hope that you get back in and care for and develop this wonderful mail program again. Cheers Ralph

[Dbmail] testing please ignore

2019-03-05 Thread Paul J Stevens
test -- Paul J Stevens pjstevns @ gmail, twitter, github, linkedin ___ DBmail mailing list DBmail@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail

Re: [Dbmail] mailing lists are moving and github organisation.

2019-02-25 Thread Thomas Raschbacher
ticed the website was already moved. I also intent to open up development so other stakeholders and active users can more easily contribute. For this I'm opening the 'dbmail' organisation on github. If you would like me to add you please send me your github handle and I wil

Re: [Dbmail] mailing lists are moving and github organisation.

2019-02-24 Thread Andrea Brancatelli
bsite was already moved. > > I also intent to open up development so other stakeholders and active > users can more easily contribute. > > For this I'm opening the 'dbmail' organisation on github. If you would > like me to add you please send me your g

Re: [Dbmail] mailing lists are moving and github organisation.

2019-02-24 Thread Casper Langemeijer
the website was already moved. > > I also intent to open up development so other stakeholders and active > users can more easily contribute. > > For this I'm opening the 'dbmail' organisation on github. If you would > like me to add you please send me your git

[Dbmail] mailing lists are moving and github organisation.

2019-02-24 Thread Paul J Stevens
ibute. For this I'm opening the 'dbmail' organisation on github. If you would like me to add you please send me your github handle and I will add you. https://github.com/dbmail -- Paul J Stevens pjstevns @ gm

Re: [Dbmail] will dbmail continue to be developed?

2019-02-21 Thread Andrea Brancatelli
If you go this way I have something to contribute too. Small stuff, mainly MySQL based. --- Andrea Brancatelli On 2019-02-21 11:01, Casper Langemeijer wrote: > Hi All, > The questions about the future of dbmail keeps popping up. As well as > question on this mailinglist, I&#x

Re: [Dbmail] will dbmail continue to be developed?

2019-02-21 Thread Casper Langemeijer
Hi All, The questions about the future of dbmail keeps popping up. As well as question on this mailinglist, I've tried to reach out to Paul a several times last year. I'm not getting any response, even though I've put in alot of hours in on making dbmail work with gmime3: htt

[Dbmail] DBMail & Horde Webmail unknown address, subject, date

2019-01-20 Thread Admin Beckspaced
27;m using latest dbmail version 3.2.3 is there some setting ... tuining ... I can apply so dbmail works together with horde and shows the details of the emails in the mailbox listing? thanks & greetings Becki _______ DBmail mailing list DBmail@d

Re: [Dbmail] will dbmail continue to be developed?

2019-01-16 Thread Sandino Araico Sánchez
On 11/01/19 4:13, Maxim wrote: This is the only server that works with DBMS to store all data. I think this is a very good decision. I have some performance improvements I would like to do but I have had no time. ___ DBmail mailing list DBmail

[Dbmail] will dbmail continue to be developed?

2019-01-11 Thread Maxim
This is the only server that works with DBMS to store all data. I think this is a very good decision. ___ DBmail mailing list DBmail@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail

Re: [Dbmail] MariaDB Migration

2018-10-17 Thread Reindl Harald
Am 17.10.18 um 14:04 schrieb Christian Reischl: > Dear Harald, > > thank you for the quick answer. > > Here are more details: > > OS: Debian 7 LTS (upgrade to 9 soon) > DBmail: 3.1.13-1 (from deprecated nfgd.net repo) > GMime: 2.6.10-1 > MariaDB: 10.1.26-0+deb

Re: [Dbmail] MariaDB Migration

2018-10-17 Thread Christian Reischl
Dear Harald, thank you for the quick answer. Here are more details: OS: Debian 7 LTS (upgrade to 9 soon) DBmail: 3.1.13-1 (from deprecated nfgd.net repo) GMime: 2.6.10-1 MariaDB: 10.1.26-0+deb9 (on separate Debian 9.5 host) Roundcube: 1.3.7 The best solution seems to be an upgrade of DBMail

Re: [Dbmail] MariaDB Migration

2018-10-17 Thread Reindl Harald
Am 17.10.18 um 12:19 schrieb Christian Reischl: > Hello, > > we just moved a DBMail installation from MySQL to MariaDB. > > Everything works well using Thunderbird, but web clients like Roundcube > and SOGo Groupware cannot display the message list. The folder list is >

[Dbmail] MariaDB Migration

2018-10-17 Thread Christian Reischl
Hello, we just moved a DBMail installation from MySQL to MariaDB. Everything works well using Thunderbird, but web clients like Roundcube and SOGo Groupware cannot display the message list. The folder list is shown, including the number of messages, but the message list remains empty. The

[Dbmail] Imapd dies

2018-10-11 Thread Pascal Longrais
Hello, I had dbmail working from years. I encounter several imapd dies per day since a week. The error message is "dbmail-imapd: dm_string.c:160: p_string_erase: Assertion `pos + len <= S->used' failed.". The only recent change I can correlate may be the increase

Re: [Dbmail] SQLException: Incorrect string value

2018-10-07 Thread Reindl Harald
Am 07.10.18 um 12:04 schrieb Maxim: > I use Posgres, now I switched to version 10, it works much faster. > dbmail-utils almost never use, sql scripts directly run faster and more > reliably. i doubt that you are faster and more relieable with sql-scripts instead "dbmail-util -y

Re: [Dbmail] SQLException: Incorrect string value

2018-10-07 Thread Maxim
I use Posgres, now I switched to version 10, it works much faster. dbmail-utils almost never use, sql scripts directly run faster and more reliably. sorry, but also thought about switching to dovecot. 05.10.18 22:30, Reindl Harald (mobile) пишет: MariaDB 10.2.18 but that issue exists

Re: [Dbmail] SQLException: Incorrect string value

2018-10-05 Thread Curtis Maurand
I used to use dbmail for my service. I thought it would be a no-brainer to set up with some sort of control panel app since, hey, it's SQL. However, I had t stop using it because it doesn't look like it's maintained any longer. There hasn't been an update since early la

Re: [Dbmail] SQLException: Incorrect string value

2018-10-05 Thread Reindl Harald (mobile)
MariaDB 10.2.18 but that issue exists virtually forever and predates MariaDB I don't get what is that hard to handle database input properly and no you can't reject non rfc conform messages on postfix side as long the server is not for personal use when dbmail-util is not able to cle

Re: [Dbmail] SQLException: Incorrect string value

2018-10-05 Thread Maxim
which DBMS do you use? 05.10.18 14:52, Reindl Harald пишет: that there is a invalid char in a header is one thing, but that dbmail produces non-recovery errors in that case sucks <147609553.1537264268556.JavaMail.ýkids2@oekids-server> "<75106708.5820290.1537266387...@mail.yaho

Re: [Dbmail] SQLException: Incorrect string value

2018-10-05 Thread Reindl Harald
that there is a invalid char in a header is one thing, but that dbmail produces non-recovery errors in that case sucks <147609553.1537264268556.JavaMail.ýkids2@oekids-server> "<75106708.5820290.1537266387...@mail.yahoo.com>")] Oct 05 13:36:09 mail.thelounge. dbmail-util[20

[Dbmail] SQLException: Incorrect string value

2018-10-05 Thread Reindl Harald
this sucks for years * why does this happen at all * why no output of database-id instead a dot * why no dbmail-util switch "kill messages you can't handle" * why spit lines with breaks into maillog confusing mailgraph -- Ok. Found [3] missing

Re: [Dbmail] Latest GIT?

2018-09-24 Thread Maxim
atest most current version of DBmail located? git.dbmail.eu doesn't seem to be working for me. The version that I'm running right now is the PJSTEVNS version at Github but that seems to be fairly old at this point sadly dbmail seems to be completly orphaned and it's really frust

Re: [Dbmail] dbmail + geo-replication

2018-09-24 Thread Andrea Brancatelli
While it's true that dbmail didn't receive any commit for new code later, emails are a pretty old and not moving target. In general there a couple of open points and a couple of bugs here and there that would need fixing, but frankly I don't feel worried about using it. Persona

Re: [Dbmail] dbmail + geo-replication

2018-09-22 Thread Ryan Beethe
have had a positive experience with the multi-master syncing. It sounds like a solid solution, and in my case a simple one because for now I won't even need IMAP from either server. The other thing that worries me is that dbmail is going to fall into a state of disrepair without any devel

[Dbmail] LDAP Authentication with Samba 4 Active Directories

2018-09-22 Thread Mauro Mozzarelli
Hello, Has anyone managed to setup successfully user authentication via Samba 4 AD LDAP? I have followed some threads I found with google, but unfortunately without success. If I leave bind_dn and bind_pw empty, dbmail-imapd starts, but the no user can get authenticated. Also dbmail-users

Re: [Dbmail] dbmail + geo-replication

2018-09-22 Thread Andrea Brancatelli
my best > option, where I have a primary server that is up most of the time and I > can use pacemaker to switch from one to the other for failovers. > > I think I could get away with not using a distributed file system if I > were to switch from dovecot to dbmail. I definitely

Re: [Dbmail] dbmail + geo-replication

2018-09-21 Thread Mauro Mozzarelli
Hello Ryan, The way I achieve this through dbmail is by using a replica mysql cluster as a back-end database In practical terms you set up the 2 sites each with a mysql DB and configure them for mutual replication. On top you have 1 dbmail instance deployed at each site that points to its

Re: [Dbmail] Latest GIT?

2018-09-20 Thread Andrea Brancatelli
https://github.com/pjstevns/dbmail --- Andrea Brancatelli On 2018-09-20 18:31, Peter Smith wrote: > Also, where is the latest most current version of DBmail located? > git.dbmail.eu doesn't seem to be working for me. The version that I'm > running right now is the

[Dbmail] dbmail + geo-replication

2018-09-20 Thread Ryan Beethe
away with not using a distributed file system if I were to switch from dovecot to dbmail. I definitely need the distributed database, so avoid also using a distributed file system seems like a way to keep my architecture as simple as possible (but please correct me if I am wrong). For doing geo-r

Re: [Dbmail] Latest GIT?

2018-09-20 Thread Reindl Harald
un - surely this is something your employer could > fund? > > On Fri, Sep 21, 2018 at 5:11 AM Reindl Harald <mailto:h.rei...@thelounge.net>> wrote: > > > > Am 20.09.18 um 18:31 schrieb Peter Smith: > > Also, where is the latest most current version of DBmail

Re: [Dbmail] Latest GIT?

2018-09-20 Thread Daniel Kasak
gt; Am 20.09.18 um 18:31 schrieb Peter Smith: > > Also, where is the latest most current version of DBmail located? > git.dbmail.eu doesn't seem to be working for me. The version that I'm > running right now is the PJSTEVNS version at Github but that seems to be > fairly old a

Re: [Dbmail] Latest GIT?

2018-09-20 Thread Reindl Harald
Am 20.09.18 um 18:31 schrieb Peter Smith: > Also, where is the latest most current version of DBmail located? > git.dbmail.eu doesn't seem to be working for me. The version that I'm > running right now is the PJSTEVNS version at Github but that seems to be > fairly ol

[Dbmail] Latest GIT?

2018-09-20 Thread Peter Smith
Also, where is the latest most current version of DBmail located? git.dbmail.eu doesn't seem to be working for me. The version that I'm running right now is the PJSTEVNS version at Github but that seems to be fairly old at this point. Thanks, Peter __

[Dbmail] Problem with NUL in message body, violates RFC2822

2018-09-20 Thread Peter Smith
Hey there; I've come across a situation wherein I have imapfilter attempting to store a message on my dbmail system that apparently contains a NUL character in the middle of a MIME block.. According to my logs it looks like this throws dbmail for a loop, making the IMAP conversation s

Re: [Dbmail] (imap) performance for list folders

2018-08-16 Thread Thomas Raschbacher
that) the table has an index on the name, so the DB query should be relatively fast - so it seems the delay is somewhere in dbmail-imapd? Regards ___ DBmail mailing list DBmail@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail signature.asc

Re: [Dbmail] Strange behaviour of deleted mails reappearing again

2018-07-12 Thread Thomas Raschbacher
commands sent to the server). Regards On 2018-07-06 20:11, Pascal Longrais wrote: Hello, I am using dbmail 3.2.3 since long time and never saw this trouble: In Thunderbird I select all mails in the Junk folder and apply Delete. All mails then disappear and the folder is empty. Going into the

[Dbmail] Strange behaviour of deleted mails reappearing again

2018-07-06 Thread Pascal Longrais
Hello, I am using dbmail 3.2.3 since long time and never saw this trouble: In Thunderbird I select all mails in the Junk folder and apply Delete. All mails then disappear and the folder is empty. Going into the Trash folder, I do see all deleted mails. But few time after, the Junk folder is

Re: [Dbmail] Database password encryption in dbmail.conf

2018-07-06 Thread Thomas Raschbacher
more complicated for someone who really wants to do it). Alternatively what would probably be easier would be to write a patch to load the database config from a different location, and make that file not readable by your admins (through whichever means) but only readable by root / the dbmail

Re: [Dbmail] Database password encryption in dbmail.conf

2018-07-04 Thread Reindl Harald
ns) but only readable by root / the dbmail process can't work - dbmail-util needs to read it too and so the user invoking dbmail-util is able to do the same either i am admin for a service or not. -BEGIN PGP SIGNATURE- iQGzBAEBCAAdFiEEnStGzbwUCjZ1OuTXMxdNWliSt7gFAls80aUACgkQMx

Re: [Dbmail] Database password encryption in dbmail.conf

2018-07-04 Thread Reindl Harald
with sudoers it will be tricky to allow edit/watch files but not a sepcific one with the credentials > On 02/07/18 06:15, Thomas Raschbacher wrote: >> Hi. >> >> If you used a symetric encryption you'd still have the decryption >> available within the dbmail binaries,

Re: [Dbmail] Database password encryption in dbmail.conf

2018-07-04 Thread Thomas Raschbacher
probably be easier would be to write a patch to load the database config from a different location, and make that file not readable by your admins (through whichever means) but only readable by root / the dbmail process That said .. do your mail admins have full root access on these systems? Do

Re: [Dbmail] Database password encryption in dbmail.conf

2018-07-04 Thread Mauro Mozzarelli
resolved the problem. One could introduce a variable encryption seed at installation time which is only valid for that deployment. On 02/07/18 06:15, Thomas Raschbacher wrote: Hi. If you used a symetric encryption you'd still have the decryption available within the dbmail binaries, and -

Re: [Dbmail] Database password encryption in dbmail.conf

2018-07-01 Thread Thomas Raschbacher
Hi. If you used a symetric encryption you'd still have the decryption available within the dbmail binaries, and - since it is open source - you'd be able to look at the algorithm and still somehow decrypt the key. Asymetric might be slightly better, but still the same applies in t

Re: [Dbmail] Database password encryption in dbmail.conf

2018-06-29 Thread Mauro Mozzarelli
Hello Reindl, Please see my follow-up below. I find dbmail has great potential. On 27/06/18 22:22, Reindl Harald wrote: Am 27.06.2018 um 20:46 schrieb Mauro Mozzarelli: That is correct. I was looking to secure DB access by encrypting the credentials in the configuration file. how do you

Re: [Dbmail] Database password encryption in dbmail.conf

2018-06-27 Thread Reindl Harald
Am 27.06.2018 um 20:46 schrieb Mauro Mozzarelli: > That is correct. I was looking to secure DB access by encrypting the > credentials in the configuration file. how do you imagine that to start with? dbmail needs to authenticate against the database and so it needs the credentials - f

Re: [Dbmail] Database password encryption in dbmail.conf

2018-06-27 Thread Mauro Mozzarelli
, Thomas Raschbacher wrote: Hi. I think Mauro meant if it is possible to have the Database credentials themselves encrypted in dbmail.conf. - To answer that: I don't think that is possible, but if you configure permissions properly (0600 or maybe 0660 then noone but the dbmail user and

Re: [Dbmail] Database password encryption in dbmail.conf

2018-06-26 Thread Thomas Raschbacher
Hi. I think Mauro meant if it is possible to have the Database credentials themselves encrypted in dbmail.conf. - To answer that: I don't think that is possible, but if you configure permissions properly (0600 or maybe 0660 then noone but the dbmail user and root should have access to it)

Re: [Dbmail] Database password encryption in dbmail.conf

2018-06-24 Thread Andrea Brancatelli
Password encryption is mostly transparent on the application side, you just have to choose an encryption method when you create an user with dbmail-users - the password will be encrypted on the db and DBMail will handle it transparently. --- Andrea Brancatelli On 2018-06-23 14:05, Mauro

[Dbmail] Database password encryption in dbmail.conf

2018-06-23 Thread Mauro Mozzarelli
Hi All, I am new to this list, thus apologies if the question was asked before. How do I configure securely the database authentication credentials in dbmail.conf? Is there a way to encrypt the password? Thank you in advance, Mauro ___ DBmail

[Dbmail] can anyone confirm if sieve tls works for dbmail-3.2.3

2018-06-11 Thread cktmwe
hello everyone, I've tried recently to configure timsieved for dbmail-3.2.3, sieve works without tls encryption, as far as I enable tls_port (for example 4190), timsieved does not response at all. I can see timsieved reports it had already bind to SSL_PORT 4190, if I test it with sieve-co

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-24 Thread Thomas Raschbacher
, Casper Langemeijer wrote: > I've started working on porting dbmail to gmime3. My work is public, but not > finished. > > https://github.com/langemeijer/dbmail/tree/upgrade-to-gmime3 [1] > I am not a C developer by profession, and I lack experience. Most of the work >

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-23 Thread Casper Langemeijer
I've started working on porting dbmail to gmime3. My work is public, but not finished. https://github.com/langemeijer/dbmail/tree/upgrade-to-gmime3 (https://link.getmailspring.com/link/1524473037.local-204e8f4e-7406-v1.2.1-7e744...@getmailspring.com/0?redirect=https%3A%2F%2Fgithu

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-21 Thread Reindl Harald
well, and here we are back at the bad or non existing maintainance state of dbmail: configure: error: Unable to locate gmime development files [builduser@testserver:~]$ rpm -qa | grep gmime gmime-devel-3.0.5-1.fc27.20180421.rh.x86_64 gmime-3.0.5-1.fc27.20180421.rh.x86_64 Am 21.04.2018 um 12:35

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-21 Thread Reindl Harald
the header mangeling is gmime https://bugzilla.gnome.org/show_bug.cgi?id=776825 ftp://ftp.gnome.org/pub/GNOME/sources/gmime/3.0/ DKIM verifyication/scoring normally happens before dbmail-lmtpd and forwardings should also not touch the spilt/reconstruct code as far as i can see the GPG breakage

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-21 Thread Casper Langemeijer
I fired up my facebook account, and added a few email addresses to send mails to my accounts. I found that mails sent to my gmail account directly differ from the mails I receive with my dbmail server in one important way: The 'Content-Type; header has a different format. Sent (and received

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-20 Thread Casper Langemeijer
I'm not sure this is related, and I probably should investigate further before posting this here, but in my setup, dbmail seems to break DKIM signatures. I've seen that mails from booking.com and facebook.com have broken DKIM signatures according to google's gmail, when forwarded b

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-18 Thread Thomas Raschbacher
Hmm duno about that one, but i don't use SpamAssassin at the moment.. That aside - and without checking now - are there any test-emails with expected results, that would test that part of dbmail automatically? On 2018-04-18 17:48, Reindl Harald wrote: Am 18.04.2018 um 07:32 schrieb T

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-18 Thread Reindl Harald
Am 18.04.2018 um 07:32 schrieb Thomas Raschbacher: > hmm .. > > I have no such problems with dbmail 3.2.3 (and gmime 2.6.20 looking at all the urgent fixes after 3.0 as well as 3.1 where a ton of people pretended all is fine made me shy in case of dbmail updates especially when de

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-17 Thread Thomas Raschbacher
hmm .. I have no such problems with dbmail 3.2.3 (and gmime 2.6.20 On 2018-04-16 14:34, Reindl Harald wrote: moving from imap-sent folder to a local-folder don't break it see diff from the this way "saved" orginal sent and the broken one this is the source-tarball and

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-16 Thread Reindl Harald
moving from imap-sent folder to a local-folder don't break it see diff from the this way "saved" orginal sent and the broken one this is the source-tarball and one of the last important patches how dbmail is built here https://access.thelounge.net/harry/dbmail-sources.zip dbmai

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-16 Thread Reindl Harald
sorry for the mail-flood - but i will try to move it now to a local folder - i think the breakage to the sent message happens instantly but thunderbird before moveing it shows some caching where it is fine and not put through dbmail re-construct good question if this also happens when move it

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-16 Thread Reindl Harald
this message was broken too while the sent message was green until i moved it with drag&drop from sent to the dbmail folder with the intention to make a diff now for both copies enigmail says "wrong signature" Am 16.04.2018 um 14:09 schrieb Reindl Harald: > Am 16.04.2018 um 13:

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-16 Thread Reindl Harald
e back with broken signature in case i used GPG/Mime meaning "signature.asc" attached instead inline signing for me at that time it wasn't clear that it's my own mailserver running dbmail-1.3 and not the list servers which are breaking something but the diff you can see is the outb

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-16 Thread Thomas Raschbacher
do you have that problem vor every signed email, or just occasionally? cuz i haven't noticed problems on my part yet On 2018-04-01 13:14, Reindl Harald wrote: ping - see also attached as diff if someone is able to fix that for dbmail-3.1 i offer to pay the

Re: [Dbmail] dbmail breaks PGP/MIME mails

2018-04-01 Thread Reindl Harald
ping - see also attached as diff if someone is able to fix that for dbmail-3.1 i offer to pay the work 2874f497fb429ed139e94342ca1c84325b20b3f1 is the git with latest fixes for 3.1 before move to github - not sure if they ever made it to a offical release and we applied the patch from paul (also

Re: [Dbmail] (imap) performance for list folders

2018-03-16 Thread James Cloos
>>>>> "TR" == Thomas Raschbacher writes: TR> has anyone experience with users with lots of folders, where TR> retrieving the folder list takes 5-10 seconds (tested with just TR> a python interactive prompt, so it really only does that) Unfortunately dbmail w

[Dbmail] (imap) performance for list folders

2018-03-16 Thread Thomas Raschbacher
somewhere in dbmail-imapd? Regards signature.asc Description: OpenPGP digital signature ___ DBmail mailing list DBmail@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail

Re: [Dbmail] Slow LMTP Inserts

2018-03-02 Thread Andrea Brancatelli
8 > disable = no > socket_type = stream > protocol= tcp > wait= no > user = root > server = /usr/bin/timelimit > server_args = -t120 -T120 /usr/local/sbin/dbmail-lmtpd -n > > } > > but shortly after it starting up I get

Re: [Dbmail] Full Text Search

2018-03-01 Thread Daniel Kasak
could > probably have a look at postgresq, but i am definitely not going to set up > oracle ;)) > > Regards > > On 2018-02-27 18:49, Andrea Brancatelli wrote: > > Hello everybody, > > we recently kicked of an internal project to implement a Full Text Search > capabi

[Dbmail] (Postgresql) SQL stuff to deal with folders & folder counts

2018-02-28 Thread Thomas Raschbacher
Hi. I had to do some optimizing of a user's mailboxes, so i wrote some useful SQL: https://blog.lordvan.com/blog/dbmail-quickly-get-mailbox-counts-including-deleted-emails-postgresql/ I assume that MySQL or oracle syntax would be a bit different (do they have FILTER ? no idea.. ) But

Re: [Dbmail] Full Text Search

2018-02-28 Thread Thomas Raschbacher
roject to implement a Full Text Search > capability into DBMAIL. > > It's basically centred about a few different things: > > * A dedicated dbmail_mimeparts_fts table with (native MySQL) full text > indexes where only a "clean" (read cleartext) version of

Re: [Dbmail] Slow LMTP Inserts

2018-02-28 Thread rich carroll
port = 9998 disable = no socket_type = stream protocol= tcp wait= no user= root server = /usr/bin/timelimit server_args = -t120 -T120 /usr/local/sbin/dbmail-lmtpd -n } but shortly after it s

[Dbmail] Full Text Search

2018-02-27 Thread Andrea Brancatelli
Hello everybody, we recently kicked of an internal project to implement a Full Text Search capability into DBMAIL. It's basically centred about a few different things: * A dedicated dbmail_mimeparts_fts table with (native MySQL) full text indexes where only a "clean"

Re: [Dbmail] Slow LMTP Inserts

2018-02-27 Thread Andrea Brancatelli
oot /usr/local/bin/timelimit timelimit -t120 -T120 /usr/local/sbin/dbmail-lmtpd -n And it works like a charm. It clearly doesn't fix the problem but at least it gives you a working situation. I can confirm that having multiple lmtpd dispatched by inetd is much faster than the daemon. Furtherm

[Dbmail] Slow LMTP Inserts

2018-02-25 Thread rich carroll
Howdy folks, I'm running dbmail 3.2.3 on a postgresql db and am having slow inserts. About 2 seconds each. This is not really ok and it tends to get behind during peak usage or when someone emails every mailbox. I read that 2 seconds a message is not abnormal, can anyone confirm this

Re: [Dbmail] Problems creating Mailboxes

2018-02-01 Thread Peter Smith
cket traces for the LDAP query and response and did not see "sAMAccountName" in the response, curiously enough, but did see "uid". I've verified that it is working for me now. Thanks, Peter -Original Message- From: Peter Smith Sent: Thursday, February 01, 2018 10:16 AM

Re: [Dbmail] Problems creating Mailboxes

2018-02-01 Thread Peter Smith
Thank you for the response. I am using PostGreSQL, the auth is LDAP, and I'm running at maximum logging level. The error is isolated, however here's some entries around the error: Feb 01 10:08:23 linux dbmail-imapd[19484]: [0xeb55e0] Debug:[db] db_imap_split_mailbox(+2387): Prepari

Re: [Dbmail] Problems creating Mailboxes

2018-01-31 Thread Thomas Raschbacher
lders on my DBMAIL back-end. As of right now, however, I am not > able to make new mailboxes. > > Should I create a Bugreport? > > Ultimately I'm getting the following in dbmail.err . > > Jan 30 16:06:27 linux dbmail-imapd[8144]: [0x21c0450] Error:[db] > db_create

[Dbmail] Problems creating Mailboxes

2018-01-30 Thread Peter Smith
It has been quite a while but I'm fairly certain that I used to be able to create folders on my DBMAIL back-end. As of right now, however, I am not able to make new mailboxes. Should I create a Bugreport? Ultimately I'm getting the following in dbmail.err . Jan 30 16:06:27 linux db

Re: [Dbmail] Not Deleting Mail

2018-01-29 Thread Andrea Brancatelli
out its because of the dbmail_messages table is really slow. > It took 5 minutes to delete 300 rows. My dbmail_messages table has 7628586 > rows. Is that alot? Our old server with dbmail 2.2 and postgres 8 seemed to > run alot better. I used the 2.2 and postgresql performance guide but I

Re: [Dbmail] Not Deleting Mail

2018-01-28 Thread rich carroll
rows. Is that alot? Our old server with dbmail 2.2 and postgres 8 seemed to > run alot better. I used the 2.2 and postgresql performance guide but I am > not sure how much of that is relevent to 3.2.3 and postgresql 9.5. Is there > a newer guide or can you give me some suggestions to speed

Re: [Dbmail] Not Deleting Mail

2018-01-25 Thread rich carroll
? Our old server with dbmail 2.2 and postgres 8 seemed to run alot better. I used the 2.2 and postgresql performance guide but I am not sure how much of that is relevent to 3.2.3 and postgresql 9.5. Is there a newer guide or can you give me some suggestions to speed it up? I run dbmail-util -ay every

Re: [Dbmail] Not Deleting Mail

2018-01-25 Thread Andrea Brancatelli
Do this: SELECT user_idnr FROM dbmail_users WHERE userid = "YOUR EMAIL ADDRESS" Write down the corresponding ID SELECT mailbox_idnr, name FROM dbmail_mailboxes WHERE owner_idnr = Find the ID of your mailbox. DELETE FROM dbmail_messages WHERE mailbox_idnr = Done. dbmai

Re: [Dbmail] Not Deleting Mail

2018-01-24 Thread rich carroll
If I do a: dbmail-export -D -d -u It seems to empty the mailbox. On Wed, Jan 24, 2018 at 9:47 AM, rich carroll wrote: > Howdy Folks, > > I have a mailbox that I used for testing. It has about 300,000 messages in > it. I can not open it in webmail. I am trying to empty it out. &g

[Dbmail] Not Deleting Mail

2018-01-24 Thread rich carroll
Howdy Folks, I have a mailbox that I used for testing. It has about 300,000 messages in it. I can not open it in webmail. I am trying to empty it out. I have ran: dbmail-users -e -y It looks like its doing something for a bit but nothing gets removed from the box. I am currently trying to

Re: [Dbmail] Future of DBMail ?

2018-01-09 Thread Alan Hicks
On 09/01/2018 06:21, Thomas Raschbacher wrote: On 2018-01-08 18:01, Alan Hicks wrote: Plans, or at least ideas, yes. dbmail would benefit from ability to handle multiple requests per session. There is an outstanding task to fix the MySQL 5.7 (showstopper) bug. Nice to hear. I was going to

Re: [Dbmail] Future of DBMail ?

2018-01-09 Thread Andrea Brancatelli
On 2018-01-08 18:01, Alan Hicks wrote: >> I was going to check git.dbmail.eu, but it seems it is not working anymore? >> the only thing i found was paul's dbmail repo on github, which i assume to >> be the current up2date one. > There is a fork at https://github.com/al

Re: [Dbmail] Future of DBMail ?

2018-01-08 Thread Thomas Raschbacher
On 2018-01-08 18:01, Alan Hicks wrote: Plans, or at least ideas, yes. dbmail would benefit from ability to handle multiple requests per session. There is an outstanding task to fix the MySQL 5.7 (showstopper) bug. Nice to hear. I was going to check git.dbmail.eu, but it seems it is not

Re: [Dbmail] Future of DBMail ?

2018-01-08 Thread Alan Hicks
Hi, On 08/01/2018 15:52, Thomas Raschbacher wrote: Hi all & especially Paul ;) Hope you all are having a good start into the new year. I just thought it would be nice to know if there are any plans for DBMail's future (or lack thereof?) Plans, or at least ideas, yes. dbmail woul

[Dbmail] Future of DBMail ?

2018-01-08 Thread Thomas Raschbacher
found was paul's dbmail repo on github, which i assume to be the current up2date one. Is DBmail going to be maintained/"supported"/developed further at all, or do we need to consider it to be in need of a new Maintainer / dev(group) ? -- not trying to offend anyone here, so if

Re: [Dbmail] changing mailboxes in DB?

2018-01-08 Thread Andrea Brancatelli
721 folders (which i am > trying to get down to a reasonable amount since all webmail clients go either > really slow, or time out) > > Regards > _______ > DBmail mailing list > DBmail@dbmail.org > http://lists.nfg.nl/mailman/listinfo/dbmail

[Dbmail] changing mailboxes in DB?

2018-01-06 Thread Thomas Raschbacher
it through imap which is slower, but doable since it is only one user and a total of 3721 folders (which i am trying to get down to a reasonable amount since all webmail clients go either really slow, or time out) Regards _______ DBmail mailing l

Re: [Dbmail] dbmail-messageblks missing in dbmail 3.1.17

2017-10-19 Thread Sandino Araico Sánchez
On 18/10/17 05:02, Ralph Ballier wrote: > > Hello Sandino, > > thanks für your hints, to use sys dbmail 3.2 rather than dbmail 3.1. > But do you had read about problems with dbmail 3.2 and mysql 5.7? > Every INSERT does not work. I myself have tried it. > I have not tried dbma

Re: [Dbmail] dbmail-messageblks missing in dbmail 3.1.17

2017-10-18 Thread Ralph Ballier
- Nachricht von Sandino Araico Sánchez -   Datum: Mon, 16 Oct 2017 15:50:36 -0500     Von: Sandino Araico Sánchez Betreff: Re: [Dbmail] dbmail-messageblks missing in dbmail 3.1.17      An: DBMail mailinglist , Ralph Ballier On 16/10/17 08:56, Ralph Ballier wrote

Re: [Dbmail] dbmail-messageblks missing in dbmail 3.1.17

2017-10-16 Thread Sandino Araico Sánchez
On 16/10/17 08:56, Ralph Ballier wrote: > > Hello, > > I had tried to install dbmail 3.1.17 but there are problems. I looked > at the database and have found: there is not table named > "dbmail-messageblks". > > The reason is, that in "dbmail-3.1.17/sql/m

Re: [Dbmail] dbmail-messageblks missing in dbmail 3.1.17

2017-10-16 Thread Reindl Harald
Am 16.10.2017 um 15:56 schrieb Ralph Ballier: Hello, I had tried to install dbmail 3.1.17 but there are problems. I looked at the database and have found: there is not table named "dbmail-messageblks". The reason is, that in "dbmail-3.1.17/sql/mysql/create_tables.mysq

[Dbmail] dbmail-messageblks missing in dbmail 3.1.17

2017-10-16 Thread Ralph Ballier
Hello, I had tried to install dbmail 3.1.17 but there are problems. I looked at the database and have found: there is not table named "dbmail-messageblks". The reason is, that in "dbmail-3.1.17/sql/mysql/create_tables.mysql" the command "CREATE dbmail-messagesb

  1   2   3   4   5   6   7   8   9   10   >