Re: [Dbmail] SQLException: Incorrect string value

2018-10-05 Thread Curtis Maurand
not sure SQL is the right technology for the store. hadoopor mongo or some such might actually work better. I know I had an extensive set of save queries. It was just too much to manage. I'm a purist, but I"m getting too old be working the command-line. --Curtis Maurand On Fri, Oct 5, 2018 at 3:

Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-04 Thread Curtis Maurand
On a 650 GB table, the OPTIMIZE is going to take quite a while. On Fri, Mar 4, 2016 at 3:57 AM, Andrea Brancatelli wrote: > Sorry I forgot you're on mysql 5.1. > > Maybe it will lock the table. Just run the update deep in the night... > --- > > > *Andrea Brancatelli >

Re: [Dbmail] dbmail-imapd: dm_string.c:161: p_string_erase: Assertion `pos + len <= S->used' failed.

2015-10-29 Thread Curtis Maurand
I had the same problem. It went away when I upgraded to 3.2.3 On Thu, Oct 29, 2015 at 8:46 PM, Reindl Harald wrote: > no idea - sometimes not for days, sometimes multiple times within a few > minutes resulting in dbmail-imapd crashing with 3.1.17 and it makes me >

Re: [Dbmail] dbmail 3.1.17: crash dbmail-imapd

2015-04-23 Thread Curtis Maurand
3.2.3 broke authentication. Not too happy these days. On Apr 23, 2015 1:11 AM, Paul J Stevens p...@nfg.nl wrote: Curtis, are you seeing this on 3.2.3 as well? Curtis Maurand cur...@maurand.com schreef op 23 april 2015 01:01:33 CEST: On 10/10/2014 11:11 AM, Maxim wrote: Hello, system

Re: [Dbmail] dbmail 3.1.17: crash dbmail-imapd

2015-04-23 Thread Curtis Maurand
this on 3.2.3 as well? Curtis Maurand cur...@maurand.com schreef op 23 april 2015 01:01:33 CEST: On 10/10/2014 11:11 AM, Maxim wrote: Hello, system: dbmail 3.1.17 Debian 7 with last updates the last two days dbmail-imapd frequently falls, and the error log for the following message

Re: [Dbmail] dbmail 3.1.17: crash dbmail-imapd

2015-04-22 Thread Curtis Maurand
optimizations at all. Anyone have any ideas? Could this be a database thing. It looks like it's happening when firefox tries to save a copy of a message to the sent folder. -- Curtis Maurand cur...@maurand.com mailto:cur...@maurand.com 207-252-7748 ___ DBmail

Re: [Dbmail] imap search query

2015-03-04 Thread Curtis Maurand
I've found that the imap search will always fail and timeout. It has never worked for me in any version. Whenever I've wanted to find a message, I've had to write my own query and search for it manually. --Curtis On Mar 4, 2015 8:14 AM, Andrea Brancatelli abrancate...@schema31.it wrote: We

Re: [Dbmail] Database restore

2015-02-05 Thread Curtis Maurand
I think the defaults. mysqldump -u root -ppassword --databases dbmail. I'll have to change that. On Feb 5, 2015 3:21 AM, Andrea Brancatelli abrancate...@schema31.it wrote: Il 04/02/15 18:57, Curtis Maurand ha scritto: I just had to drop the dbmail database and restore from a backup

Re: [Dbmail] Database restore

2015-02-05 Thread Curtis Maurand
/02/15 14:37, Curtis Maurand ha scritto: I think the defaults. mysqldump -u root -ppassword --databases dbmail. I'll have to change that. On Feb 5, 2015 3:21 AM, Andrea Brancatelli abrancate...@schema31.it wrote: Il 04/02/15 18:57, Curtis Maurand ha scritto: I just had to drop the dbmail

[Dbmail] Database restore

2015-02-04 Thread Curtis Maurand
the restore go faster? Thanks, Curtis -- Curtis Maurand cur...@maurand.com mailto:cur...@maurand.com 207-252-7748 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] lmtp problems

2014-04-05 Thread Curtis Maurand
Peter Milesson wrote: On 2014-04-05 13:54, Reindl Harald wrote: what i don't understand is why dbmail-lmtpd crashs once each day around the same time, even if i restart it at 3:00 AM, in case of imap/pop3 that could be a scheduled client always doing the same bad thing but hardly for LMTP

Re: [Dbmail] maybe serious - Re: lmtp problems + missing envelope values + un-cached physmessages

2014-04-05 Thread Curtis Maurand
Paul J Stevens wrote: It would be nice to have some backtraces for the problematic lmtpd process. @Curtis: if you see processes running at 100% cpu without any database load, please try running http://git.dbmail.eu/paul/dbmail/plain/test-scripts/dumpbt.sh against it with 'dbmail-lmtpd' as

[Dbmail] mailman question

2014-04-04 Thread Curtis Maurand
This might be a little off topic. I've set up mailman with the following settings as suggested by Paul Stevens. I'm running Ubuntu Server 12.04 LTS and dbmail 3.1.13 along with amavis, spamassassin, clamav. My point is that really you don't need any dbmail/mailman integration. in

Re: [Dbmail] mailman question

2014-04-04 Thread Curtis Maurand
further I'm getting a user unknown in local recipients table. I had all of this working prior to the meltdown the other day. I seem to be missing something. On 4/4/2014 10:03 AM, Curtis Maurand wrote: This might be a little off topic. I've set up mailman with the following settings

Re: [Dbmail] mailman question

2014-04-04 Thread Curtis Maurand
more info: currently the transport (which comes from a mysql lookup) is: lists.xyonet.commailman lists.delrc.org mailman On 4/4/2014 10:39 AM, Curtis Maurand wrote: further I'm getting a user unknown in local recipients table. I had all of this working prior

Re: [Dbmail] lmtp problems

2014-04-03 Thread Curtis Maurand
starting the virtual machine, I suggest you have a look at your virtualization environment. Issues there can be more than tricky to solve. Hope I can give you some input where to start looking... Regards, Peter On 2014-04-03 03:42, Curtis Maurand wrote: recompiled 3.1.13 and the dbmail

[Dbmail] lmtp problems

2014-04-02 Thread Curtis Maurand
virtual machine disappeared on me today. I've spent most of the day trying to get it going again. It's my main mail server and the big problem that I'm having is with lmtp. I'm running Ubuntu 12.04 LTS and I've tried dbamil 3.1.13 and 3.1.8 and both are giving me different errors. on 3.1.13,

Re: [Dbmail] lmtp problems

2014-04-02 Thread Curtis Maurand
I then went to install dbmail-smtp and lo and behold the executable is never built. I can't win. On Wed, Apr 2, 2014 at 7:45 PM, Reindl Harald h.rei...@thelounge.netwrote: Am 03.04.2014 01:19, schrieb Curtis Maurand: virtual machine disappeared on me today. I've spent most of the day

Re: [Dbmail] lmtp problems

2014-04-02 Thread Curtis Maurand
50 of them) all sleeping. On Wed, Apr 2, 2014 at 7:45 PM, Reindl Harald h.rei...@thelounge.netwrote: Am 03.04.2014 01:19, schrieb Curtis Maurand: virtual machine disappeared on me today. I've spent most of the day trying to get it going again. It's my main mail server and the big

Re: [Dbmail] lmtp problems

2014-04-02 Thread Curtis Maurand
h.rei...@thelounge.netwrote: Am 03.04.2014 01:19, schrieb Curtis Maurand: virtual machine disappeared on me today. I've spent most of the day trying to get it going again. It's my main mail server and the big problem that I'm having is with lmtp. I'm running Ubuntu 12.04 LTS and I've

Re: [Dbmail] email disappearing

2013-11-27 Thread Curtis Maurand
Do you have any recommendations for gui?  fewer mistakes made that way. Paul J Stevens wrote: On 26-11-13 17:55, Curtis Maurand wrote: returning to my little corner of the world a little red-faced. Glad to hear it was a user error, and not some unknown gremlin in the dbmail code

Re: [Dbmail] email disappearing

2013-11-26 Thread Curtis Maurand
Paul J Stevens wrote: On 25-11-13 19:28, Curtis Maurand wrote: I might add that I get hundreds of messages per day from varioius lists. I have sieve scripts that move many of them into various mailboxes., but I've lost all mail from Nov. 8 until today. That means everyone else has, too

Re: [Dbmail] email disappearing

2013-11-26 Thread Curtis Maurand
Paul J Stevens wrote: On 25-11-13 19:28, Curtis Maurand wrote: I might add that I get hundreds of messages per day from varioius lists. I have sieve scripts that move many of them into various mailboxes., but I've lost all mail from Nov. 8 until today. That means everyone else has, too

Re: [Dbmail] email disappearing

2013-11-26 Thread Curtis Maurand
with documentation - well, after that i called him some nice things and dedicated two months build up a Backend from scratch Ursprüngliche Nachricht Von: Curtis Maurand cur...@maurand.com Gesendet: Tue Nov 26 17:35:31 MEZ 2013 An: DBMail mailinglist dbmail@dbmail.org Betreff: Re

[Dbmail] email disappearing

2013-11-25 Thread Curtis Maurand
I never delete too much email, but since I've upgraded to the lastest 3.x version, I'm having trouble with email disappearing from my inbox. I'm not sure if it's from having multiple imap sessions going or not, but this problem did not exist in the 2.2 version. I have connections from K9 mail

Re: [Dbmail] email disappearing

2013-11-25 Thread Curtis Maurand
I might add that I get hundreds of messages per day from varioius lists. I have sieve scripts that move many of them into various mailboxes., but I've lost all mail from Nov. 8 until today. That means everyone else has, too. That's not good. On 11/25/2013 10:38 AM, Curtis Maurand wrote

Re: [Dbmail] hanging

2013-11-11 Thread Curtis Maurand
Ok, solved the downloading problem, but still getting lots of disconnected pieces in the database. --C On 11/10/2013 8:01 PM, Curtis Maurand wrote: Since upgrading over Friday night, my users are complaining about messages not downloading. When I run dbmail-util -ay I'm getting

Re: [Dbmail] Upgrade procedure

2013-10-25 Thread Curtis Maurand
On 10/24/2013 9:28 AM, Paul J Stevens wrote: On 21-10-13 19:54, Curtis Maurand wrote: I see several upgrade scripts in the sql folder. I'm assuming that since I'm on 2.2.18 I'll need to run them in order starting with 2_2-3_0.mysql? I know assumptions are a bad thing, but the docs folder

Re: [Dbmail] Upgrade procedure

2013-10-23 Thread Curtis Maurand
On 10/22/2013 2:42 AM, Thomas Raschbacher wrote: On 2013-10-21 19:54, Curtis Maurand wrote: I see several upgrade scripts in the sql folder. I'm assuming that since I'm on 2.2.18 I'll need to run them in order starting with 2_2-3_0.mysql? I know assumptions are a bad thing, but the docs

[Dbmail] so not having fun

2013-10-21 Thread Curtis Maurand
I'm in libzdb hell trying to get dbmail to either install or compile on Ubuntu 12.04 LTS. The current libzdb is 8. The current libmysqlclient is libmysqlclient18 while dbmail is looking for libzdb7 and libmysqlclient16. So now I'm going around in circles because if I install one, it breaks

Re: [Dbmail] so not having fun

2013-10-21 Thread Curtis Maurand
On 10/21/2013 10:26 AM, Pavlo Lavrenenko wrote: On 10/21/2013 05:01 PM, Curtis Maurand wrote: I'm in libzdb hell trying to get dbmail to either install or compile on Ubuntu 12.04 LTS. The current libzdb is 8. The current libmysqlclient is libmysqlclient18 while dbmail is looking for libzdb7

Re: [Dbmail] so not having fun [SOLVED]

2013-10-21 Thread Curtis Maurand
, Pavlo Lavrenenko wrote: On 10/21/2013 05:01 PM, Curtis Maurand wrote: I'm in libzdb hell trying to get dbmail to either install or compile on Ubuntu 12.04 LTS. The current libzdb is 8. The current libmysqlclient is libmysqlclient18 while dbmail is looking for libzdb7 and libmysqlclient16. So

[Dbmail] Upgrade procedure

2013-10-21 Thread Curtis Maurand
I see several upgrade scripts in the sql folder. I'm assuming that since I'm on 2.2.18 I'll need to run them in order starting with 2_2-3_0.mysql? I know assumptions are a bad thing, but the docs folder is scarce and the Wiki is equally scarce on upgrade procedures. building of the new

Re: [Dbmail] Upgrade from 2.2.1 to 3.0.2

2013-05-16 Thread Curtis Maurand
On 5/16/2013 4:44 AM, Thomas Raschbacher wrote: All I did when I upgrade from 2.2.x to 3.0 was run the 2_2-3_0 upgrade. all 2.3 release were developer releases therefor you have no reason to apply those. As always try this on another machine with a copy of the db first ;) Thank you. I will

Re: [Dbmail] Ubuntu 12.04

2013-05-15 Thread Curtis Maurand
Thank you. I'll install those. --Curtis On 5/15/2013 2:19 AM, Pavlo Lavrenenko wrote: On 05/14/2013 09:57 PM, Curtis Maurand wrote: Has anyone gotten dbmail to successfully build in Ubuntu 12.04. I keep getting stupid stuff like: And I'm still trying to get configure to finish. sudo

Re: [Dbmail] Ubuntu 12.04

2013-05-15 Thread Curtis Maurand
On 5/15/2013 2:19 AM, Pavlo Lavrenenko wrote: On 05/14/2013 09:57 PM, Curtis Maurand wrote: Has anyone gotten dbmail to successfully build in Ubuntu 12.04. I keep getting stupid stuff like: And I'm still trying to get configure to finish. sudo ./configure --prefix=/usr The following

[Dbmail] Upgrade from 2.2.1 to 3.0.2

2013-05-15 Thread Curtis Maurand
I'm working on an upgrade from 2.2.1 to 3.0.2 I know, I should have done this a while ago, but I've been running Ubuntu and have not been able to get it to compile, nor are there any version out there in a repository (at least not a repository that I know about.). Anyway, the wiki

[Dbmail] Ubuntu 12.04

2013-05-14 Thread Curtis Maurand
Has anyone gotten dbmail to successfully build in Ubuntu 12.04. I keep getting stupid stuff like: And I'm still trying to get configure to finish. sudo ./configure --prefix=/usr The following packages have unmet dependencies: libzdb-dev : Depends: libzdb7 (= 2.9-1) but it is not going to be

Re: [Dbmail] message filtering

2011-10-14 Thread Curtis Maurand
Paul J Stevens wrote: On 12-10-11 21:23, Curtis Maurand wrote: dbmail_aliases: alias| deliver_to -+ mya...@here.com | 123 mya...@here.com | mya...@there.com If I add sieve filters for these email accounts, will those filters

Re: [Dbmail] message filtering

2011-10-13 Thread Curtis Maurand
alias| deliver_to -+ mya...@here.com | 123 mya...@here.com | mya...@there.com Those are completely seperate delivery chains. External forwards do not pass through any dbmail filters (sieve or native). Internal deliveries do. got it.

[Dbmail] message filtering

2011-10-12 Thread Curtis Maurand
I have a domain that I'm filtering email for.  I use dbmail to set up the forwards.  these forwards handle email from contact forms on an ecomerce web site.  There are actual mailboxes for these users, but I've set the aliases for these mailboxes to forward to email accounts somewhere else.  If

Re: [Dbmail] Online Demo of DBMail admin panel is now available.

2011-10-12 Thread Curtis Maurand
Very cool.  It also need the ability to setup forwards, too. --Curtis Zhang Huangbin wrote: Dear all, Online Demo of our DBMail admin panel is now available, you can get URL and testing account on our website: http://dbmailadmin.org/ Installation guide will be available soon. Stay

[Dbmail] forward to multiple addresses

2011-07-29 Thread Curtis Maurand
Is it possible to forward to multiple addresses?  I have an alias sa...@foo.com that needs to go to sal...@bar.com, sal...@bar.com and sal...@bar.com. Thanks, Curtis ___ DBmail mailing list DBmail@dbmail.org

Re: [Dbmail] forward to multiple addresses

2011-07-29 Thread Curtis Maurand
thing/problem to distribute information between several persons, in my opinion it's better to have the sa...@bar.com configured in IMAP with a lot of space. It's my opinion. From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of Curtis Maurand Sent: sexta-feira, 29

[Dbmail] looking for query

2010-06-29 Thread Curtis Maurand
To remove all messages older than a certain date. I have users that have not been good about deleting mail messages, or have been going through gmail to get messages and don't have gmail set to delete messages from the server. Is there a set of queries I can use to purge old messages?

[Dbmail] Backups and replication

2010-05-18 Thread Curtis Maurand
In my adventures over the last few days, I've learned a few things the hard way.  When doing a complete dump and restore of the dbmail database (I'm running 2.2.15), never use --skip-opts  That's a bad thing.  It causes all kinds of problems.  I found that the following works quite nicely.  My

Re: [Dbmail] A set of queries or a method needed

2010-05-17 Thread Curtis Maurand
Paul J Stevens wrote: Trying to get a clear picture here... Curtis Maurand wrote: Hello, My hoster decided to host my routing between my two machines. dbmail runs on one machine while the database sits on a second. I managed to run a restore to a 2nd server for the database and bring

[Dbmail] A set of queries or a method needed

2010-05-14 Thread Curtis Maurand
Hello, My hoster decided to host my routing between my two machines. dbmail runs on one machine while the database sits on a second. I managed to run a restore to a 2nd server for the database and bring the mail server back up. Is there a way to grab all the mail posted after a certain

Re: [Dbmail] Dbmail Hybrid

2009-05-07 Thread Curtis Maurand
I find that on my moto-q talking to dbmail via imap, the outlook client (which can't seem to delete messages) takes care of the vagueries of attachment handling. It shows me that there are attachments, but doesn't download them unless I tell it to do so. This was sent from the moto-q. Pardon

Re: [Dbmail] /tmp full

2009-04-23 Thread Curtis Maurand
Change your tmp environment variable to point somewhere else, then restart whichever daemons need to be restarted so that their tmp paths are changed. then umount the folder and fsck it. then remount it and reverse your tmp environment variable changes and restart/reload your daemons

Re: [Dbmail] DBMA contact

2009-04-17 Thread Curtis Maurand
in your browser. Fred - Original Message - From: Curtis Maurand cur...@maurand.com To: DBMail mailinglist dbmail@dbmail.org Sent: Wednesday, April 15, 2009 9:09 AM Subject: Re: [Dbmail] DBMA contact Yes, well. I already knew about the move to dbma.ca and that's good

[Dbmail] DBMA contact

2009-04-15 Thread Curtis Maurand
Hello, would the owner of dbmailadministrator (DBMA.ca) contact me off list, please? The contact form on your website is broken and I have some information that would be helpful to you. Thanks in advance, Curtis Maurand ___ DBmail mailing list

Re: [Dbmail] DBMA contact

2009-04-15 Thread Curtis Maurand
is the final version? if that's the case, folks need to change line 2900 from: $encrypttype = ; To: $encrypttype = plaintext; otherwise plaintext passwords is broken. --C Alvar wrote: Curtis Maurand wrote: Hello, would the owner of dbmailadministrator (DBMA.ca) contact me off list

Re: [Dbmail] Are we alive or am I dead?

2009-03-26 Thread Curtis Maurand
Sometimes no news is good news. That means all of our (knocking on wood as I type this.) dbmail installation are happy puppies. :-) --Curtis Jorge Bastos wrote: Test :) -Original Message- From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of Michael

Re: [Dbmail] DBMail and SASL Authentication

2009-03-15 Thread Curtis Maurand
Isn't dbmail the imap server? That looks like a normal entry to me since dbmail is He user database provider. -Original Message- From: mediaslayer mediasla...@gmail.com To: dbmail@dbmail.org Sent: 3/15/2009 12:58 AM Subject: Re: [Dbmail] DBMail and SASL Authentication Well, I got a

Re: [Dbmail] dbmail on a VPS

2008-12-08 Thread Curtis Maurand
I have not been having good luck with this setup. I have to reset the entire mysql setup every 30 minutes due to high CPU utilization which appears to be related to mysql caching and the process of committed vs. shared memory. I'm also running a couple of websites and apache hangs, too.

RE: [Dbmail] dbmail on a VPS

2008-12-08 Thread Curtis Maurand
Message- From: dan [EMAIL PROTECTED] To: DBMail mailinglist dbmail@dbmail.org Sent: 12/8/2008 5:02 PM Subject: Re: [Dbmail] dbmail on a VPS On Mon, 08 Dec 2008 09:38:51 -0500, Curtis Maurand [EMAIL PROTECTED] wrote: I have not been having good luck with this setup. I have to reset the entire

Re: [Dbmail] minor bug

2008-10-31 Thread Curtis Maurand
, no dice. Paul Stevens wrote: Curtis Maurand wrote: I'm not a C programmer so I don't know how to fix this, but when compiling dbmail it ignores the --sysconfdir= directive during configure. Should write a script to compile it. I've compiled quite a few of these on multiple hosts since it first

[Dbmail] Re: which tables

2008-10-31 Thread Curtis Maurand
Hello, the migration is complete. I moved the following tables and everything worked out just fine. If I need to get the messages back in, I'll load up dbmail on a test server and use IMAPsync to transfer the messages. I've got a dump of the original database. To move structure only, move

[Dbmail] minor bug

2008-10-30 Thread Curtis Maurand
I'm not a C programmer so I don't know how to fix this, but when compiling dbmail it ignores the --sysconfdir= directive during configure. Should write a script to compile it. I've compiled quite a few of these on multiple hosts since it first came out, but usually I configure it this way.

Re: [Dbmail] Which tables

2008-10-28 Thread Curtis Maurand
) FROM dbmail_messages; +---+ | MAX(message_idnr) | +---+ |111252 | +---+ 1 row in set (0.00 sec) -Jon Paul J Stevens wrote: Curtis Maurand wrote: I'm trying to move user accounts and mailbox structure without moving the messages

[Dbmail] Which tables

2008-10-27 Thread Curtis Maurand
. Thanks, again, Curtis Maurand xyonet.com ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Which tables

2008-10-27 Thread Curtis Maurand
. Thanks, Curtis Paul J Stevens wrote: Curtis Maurand wrote: Hello all, I find this list to be incredibly helpful. Thank you all in advance of my question. I need to move my installation from the current server to another. That could be accomplished by simply doing a mysqldump -u user

Re: [Dbmail] Db growing size

2008-08-12 Thread Curtis Maurand
You're running into my major complaint about innodb. It never gives space back. the file continues to grow until it uses all available resources. I have heard about altering the storage engine to MyISAM and then changing it back to get your disk space back, but I've never tried it. running

Re: [Dbmail] Bug?

2008-07-14 Thread Curtis Maurand
Outlook won't download messages it thinks it already has. It stores message ID information. If there is some identifying information that's on the server such as message_id's, you'll need to change them. Then Outlook will think they're new messages and download them. Artem Bokhan wrote:

Re: [Dbmail] Problems with flags and status

2008-07-03 Thread Curtis Maurand
I think its on the Edit Menu. I have Outlook 2007. On 2007 its called Purge. One of the options is to purge when switching folders online. Curtis Jorge Bastos wrote: I think outlook has an option to expunge messages on exit, not sure. -Original Message- From: [EMAIL

Re: [Dbmail] Questions about initial DBmail setup

2008-06-25 Thread Curtis Maurand
I've been running it on Ubuntu for a couple of years. I've got 2.2 running on Ubuntu Server 6.10 LTS and it compiles from source perfectly. Curtis Josh Berkus wrote: Paul, Don't use it for anything other than testing. There are still some pretty fundamental issues to iron out. Thanks

Re: [Dbmail] Multiple domain handling

2008-06-19 Thread Curtis Maurand
Its not hard. I created all of my user accounts as their email address. username: [EMAIL PROTECTED] password: something password type: whatever form you choose alias: [EMAIL PROTECTED] in postfix main.cf transport_maps = /etc/postfix/transport in /etc/transport_map somedomain.com

Re: [Dbmail] Multiple domain handling

2008-06-19 Thread Curtis Maurand
Curtis Maurand wrote: Its not hard. I created all of my user accounts as their email address. username: [EMAIL PROTECTED] password: something password type: whatever form you choose alias: [EMAIL PROTECTED] Sorry alias should be the same as the email address, alias: [EMAIL PROTECTED

Re: [Dbmail] Problem with deleting emails via imap client

2008-06-09 Thread Curtis Maurand
Good to know. Thank you. Curtis Paul J Stevens wrote: Curtis Maurand wrote: In outlook, you need to expunge the messages from the folder. Its in the menus somewhere. I haven't been able to find anything like that in Thunderbird. Someone back in the netscape days decided to call

RE: [Dbmail] Problem with deleting emails via imap client

2008-06-08 Thread Curtis Maurand
In outlook, you need to expunge the messages from the folder. Its in the menus somewhere. I haven't been able to find anything like that in Thunderbird. If you know of a feature like that for thunderbird, let me know. Otherwise messages don't go away until you run the dbmail-util utility.

Re: [Dbmail] dbmail postgresql

2008-06-06 Thread Curtis Maurand
Is there an advantage in using PostgreSQL vs. MySQL (no flame wars please.)? I'm just looking for an relatively objective answer. I'm sure there are passions on both sides. I've been using MySQL for years without any difficulty except that the innodb file just gets larger and larger even

Re: [Dbmail] slight bug

2008-05-30 Thread Curtis Maurand
I did not install the debian packages. I compiled from source. hrmmm. Curtis Paul J Stevens wrote: Curtis Maurand wrote: Just installed 2.2.10. when I configured I ran ../configure --prefix=/usr --localstatedir=/var/run/dbmail --sysconfdir=/etc/dbmail --with-mysql --with-sieve

Re: [Dbmail] slight bug

2008-05-30 Thread Curtis Maurand
zamri wrote: On Fri, May 30, 2008 at 5:52 AM, Curtis Maurand [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Just installed 2.2.10. http://2.2.10. when I configured I ran ./configure --prefix=/usr --localstatedir=/var/run/dbmail --sysconfdir=/etc/dbmail --with-mysql

Re: AW: [Dbmail] dbmail @ ohloh

2008-05-28 Thread Curtis Maurand
I wouldn't either. Its just a way to get spam in front of me and to give up a little more privacy. I'm happy to complete a survey, but not one that takes exposes personally identifiable information. So therefore you won't get an accurate result. Jake Anderson wrote: i bailed when it

[Dbmail] upgrade failure

2008-05-22 Thread Curtis Maurand
OK, I did something wrong. from the server where the upgrade was to go. I did: mysqladmin -ppassword create dbmail mysqldump -ppassword -h old.server.com --database dbmail dbmail.dump mysql -ppassword dbmail dbmail.dump mysql -ppassword dbmail migrate_from_2.0_to_2.2.sql dbmail-util -ay (I think

[Dbmail] Re:

2008-05-22 Thread Curtis Maurand
more like: if header :contains [[SPAM]] { /* that might have to be [\[SPAM\]] */ fileinto INBOX/Spam, stop; } wrote: On Wed, 21 May 2008 at 17:56 -0400, [EMAIL PROTECTED] confabulated: OK, it sounds like something I'll be able to make happen once, I've completed my upgrade to version 2.2

Re: [Dbmail] Re:

2008-05-22 Thread Curtis Maurand
D Hill wrote: On Thu, 22 May 2008 at 09:41 -0400, [EMAIL PROTECTED] confabulated: more like: if header :contains [[SPAM]] { /* that might have to be [\[SPAM\]] */ fileinto INBOX/Spam, stop; } So '/' and '.' can be used interchangeably as a folder separator? This rule, is it assumed

[Dbmail] automatic filtering

2008-05-21 Thread Curtis Maurand
Curtis -- Curtis Maurand Head Honcho Xyonet Hosting Services Biddeford, ME 04005 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] automatic filtering

2008-05-21 Thread Curtis Maurand
the accounts in dbmail. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail -- Curtis Maurand Head Honcho Xyonet Hosting Services Biddeford, ME 04005 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED

Re: [Dbmail] SASL with saslauth rimap

2007-09-19 Thread Curtis Maurand
=userid passwdcolumn=passwd crypt=0 sqllog=0 I think it's just what's needed. --- On Donnerstag, 30. August 2007 Curtis Maurand wrote: Ok, lets see the configs. There's not a lot. /etc/sasl2/smtpd.conf: pwcheck_method: saslauthd mech_list: plain login Start saslauthd: saslauthd -a rimap -r

Re: [Dbmail] POP_BEFORE_SMTP

2007-08-30 Thread Curtis Maurand
___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail -- Curtis Maurand Head Honcho Xyonet Hosting Services Biddeford, ME 04005 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED

Re: [Dbmail] POP_BEFORE_SMTP

2007-08-30 Thread Curtis Maurand
, the packages that i have installed on my server are broken for *sql usage and i'm using sasldb mode until that is fixed. IF you want i can give my configurations - Original Message - From: Curtis Maurand To: DBMail mailinglist Sent: Thursday, August 30, 2007 3:32 PM Subject

Re: [Dbmail] POP_BEFORE_SMTP

2007-08-30 Thread Curtis Maurand
Ok, lets see the configs. Curtis Michael Monnerie wrote: On Donnerstag, 30. August 2007 Curtis Maurand wrote: I'd love to see working instructions for smtp auth. I'd rather use that and change my 40 or 50 users over to that. I use a very simple method: rimap with saslauthd saslauthd

Re: [Dbmail] POP_BEFORE_SMTP

2007-08-29 Thread Curtis Maurand
Its in the docs, but here is my setup. in main.cf mynetworks = 66.152.196.64/27,127.0.0.0/8,mysql:/etc/postfix/my_net.cf smtpd_client_restrictions = permit_mynetworks, reject /etc/postfix/mynet.cf user=username password=database password dbname=dbmaildatabasename hosts = database host

Re: [Dbmail] Deleting an account

2007-08-14 Thread Curtis Maurand
In the 2.0 series, dbma did not delete the mails correctly. I sent a couple of queries out to the list a 2 or 3 weeks ago that will delete mail in the 2.0 series not connected to anyone. I'm working on a conversion for my system to 2.2. It hasn't happened, yet. Curtis zamri wrote: On

Re: R: [Dbmail] Table dbmail_messages is full

2007-07-31 Thread Curtis Maurand
DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail -- Curtis Maurand Head Honcho Xyonet Hosting Services Biddeford, ME 04005 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ___ DBmail mailing list DBmail@dbmail.org https

Re: [Dbmail] problems

2007-07-25 Thread Curtis Maurand
On a fairly small server where dbmail-util gets run on a nightly basis. mysql SELECT count(id) FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages); +---+ | count(id) | +---+ | 30365 | +---+ 1 row in set (2.14 sec) mysql SELECT

[Dbmail] dbmail-util problem

2007-06-13 Thread Curtis Maurand
Ok, maybe I'm doing something wrong, but the help message isn't helping if I am. When I run dbmail-util against the database I get the following. Please note that I cannot purge the messages that have the DELETE status set. I need this to work as I'm preparing to upgrade to a more recent

[Dbmail] [SOLVED] dmail-util

2007-06-13 Thread Curtis Maurand
I solved it. kind of wierd having to run -dby in one run rather than -dy in one run and -py in the next. but dbmail-util -dpy worked. Curtis ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] user info

2007-03-30 Thread Curtis Maurand
Aleksander wrote: zamri wrote: I think to have more fields or tables for user information like name, address or anything would be nice. Then dbmail-users can be used to get the info from username with dbmail-users -l. What do u all think? If I'd want that, I would probably use LDAP.

Re: [Dbmail] Configurations for performance

2007-03-30 Thread Curtis Maurand
Can it? Point me to some docs and/or sample configs. If this can be made to work, then we really would have a single namespace horizontally scalable setup that we could recommend. look at the transport maps in postfix. In my configuration its transport_maps = hash:/etc/postfix/transports

Re: [Dbmail] Mailman integration in dbmail HOWTO

2007-03-29 Thread Curtis Maurand
To Paul and Aaron, Thank you, that worked. I had to go find the postfix-to-mailman.py script (separate download). Now it works pretty well, but is there a way to handle virtual domains this way? It would seem to me that its a mailman config that I'm missing, now. the mailman documentation

Re: [Dbmail] Mailman integration in dbmail HOWTO

2007-02-15 Thread Curtis Maurand
I just went to this link because I'm having trouble making mailman and dbmail work and the link is broken. The script on the wiki does not work. So if anyone could point me to a working example, that would be cool. Curtis Vital Gold wrote: Hi, I am new to dbmail and I missed a HOWTO for

Re: [Dbmail] Re: User administration of DBMail

2007-01-06 Thread Curtis Maurand
I'm interested. Bernard Johnson wrote: http://permalink.gmane.org/gmane.mail.imap.dbmail/6652 I only made modifications that work with MySQL though. Atet Sugiharto wrote: I have 3 domain in my DBMail and every domain have it's own administrator person. I would like each person could

Re: [Dbmail] database optimization

2006-11-16 Thread Curtis Maurand
Thank you. I was more concerned with performance than i was with database size. Disks are cheap. The larger a file is, the longer it takes to query. Curtis Leander Koornneef wrote: On 15-nov-2006, at 23:53, Curtis Maurand wrote: Leander Koornneef wrote: On 15-nov-2006, at 22:16, Curtis

[Dbmail] database optimization

2006-11-15 Thread Curtis Maurand
Hello, I ran dbmail-util -a on the database today. All ran OK. After that I ran mysqloptimize against the database and lo and behold, the innodb file was larger by 1 GB than it was before I started. Anyone have any idea what's going on?

Re: [Dbmail] database optimization

2006-11-15 Thread Curtis Maurand
Comment: InnoDB free: 6620160 kB innodb_data_file_path = ibdata1:10M:autoextend Curtis Leander Koornneef wrote: On 15-nov-2006, at 22:16, Curtis Maurand wrote: Hello, I ran dbmail-util -a on the database today. All ran OK. After that I ran mysqloptimize against the database and lo

RE: [Dbmail] Web Client for Multip Domins/Websites

2006-09-19 Thread Curtis Maurand
-- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Tue, 19 Sep 2006, Niblett, David A wrote: We use the old trusty SquirrelMail with the Nutsmail skins and the vlogin plugin for our 3 domains. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator

RE: [Dbmail] Postfix / Dbmailallow user to send emails outside mynetwork

2006-08-24 Thread Curtis Maurand
I've setup the pop before smtp and it works pretty nicely. I'd be interested in solution 3 and 3a -- the port 587 thing. I have sasl with mysql support and, of course, postfix with mysql support. Curtis Niblett, David A wrote: There are basically 3 ways to accomplish what you want, only 2

  1   2   >