Re: [Dbmail] Delete accounts

2006-07-19 Thread Jake Anderson
Paul J Stevens wrote: Niblett, David A wrote: Now I have to think about how to delete a user in the future. If I didn't want to use the dbmail-users program, is it valid for me to or did I miss a step? 1) select all the users mailboxes. 2) select all the physmessage_id's for that mailbox i

[Dbmail] sieve capabilities reporting error

2006-07-28 Thread Jake Anderson
hello all think i found a bug in the latest version of sieve if you telnet/nc to the sieve port (2000) you get a malformed response specifically "regex imap4flagssubaddressfileinto reject envelope vacation " it seems to be missing some spaces and thats stuffing up avelsieve just wanted to see if

Re: [Dbmail] sieve capabilities reporting error

2006-07-28 Thread Jake Anderson
( c->support.notify ? "notify ": "" ), NULL ); it looks like its missing the spaces after imap4flags and subaddress i installed from the debain repo btw into ubuntu. i am a noob wrt linux and C so i haven't worked out how to compile it with the cha

Re: [Dbmail] Postfix > amamvis > dbmail

2006-08-02 Thread Jake Anderson
try running "top" from the command line and see whats using the cpu? keep an eye on it during heavy load and it should be pretty apparent Simon wrote: Opps...! On 8/2/06, Matthew Smith <[EMAIL PROTECTED]> wrote: Quoth Simon at 08/02/06 10:41... > postfix > amamvis > spamas > clamav > dbmail >

Re: [Dbmail] DBmail / Postfix VMware Virtual Appliance - DBmail Virtualization Project?

2006-08-10 Thread Jake Anderson
i think what you want is a "toaster" install script, with a few nice config files you do your OS install then wget foo.sh ./foo come back in 20-40 minutes and you have a fully fledged full performance mail server. i see nothing paticularly difficult with that. checkout the qmail toaster inst

Re: [Dbmail] DBmail / Postfix VMware Virtual Appliance - DBmail Virtualization Project?

2006-08-11 Thread Jake Anderson
I know this is starting to border on off-topic so feel free to contact me directly if you'd like to continue this thread. Yes, maybe you can send me some getting started info on XEN if you have the time... Also can you go over how the whole toaster script thing works. How is this bette

Re: [Dbmail] sieve fileinto command

2006-08-15 Thread Jake Anderson
just a question. I downloaded the latest svn following the destructions from the website, but it didnt seem to have any ./configure or make files there. I copied it over the 2.1.7 version and ran configure and make from there and it all seemed to work but it doesn't seem like its the right way.

Re: [Dbmail] sieve fileinto command

2006-08-15 Thread Jake Anderson
ahh could that perhaps go into the docs somewhere? on the website perhaps? i didn't see anything in the install or readme about it. Jorge Bastos wrote: for svn use autoreconf -i configure make make install - Original Message - *From:* Jake Anderson <mailto:[EMAIL P

Re: [Dbmail] sieve capabilities reporting error

2006-08-16 Thread Jake Anderson
should install the fixed libsieve and the new dbmail should link against it (i think thats how it works) i don't know if you can just do libsieve, it may work (i cant rember but i dont think it did) but check the repo's first i think it has been fixed. Paul J Stevens wro

Re: [Dbmail] sieve fileinto command

2006-08-17 Thread Jake Anderson
Marc Dirix wrote: Wiki would be good, and I agree with your comment about the formal docs, but where I think it really needs to go is in the INSTALL file. Lots of people are used to configure && make && make install, they are not so familiar with having to do the autoreconf -i. Those

Re: [Dbmail] sieve fileinto command

2006-08-17 Thread Jake Anderson
page made http://www.dbmail.org/dokuwiki/doku.php?id=compile_svn let me know what you think? Jake Anderson wrote: Marc Dirix wrote: Wiki would be good, and I agree with your comment about the formal docs, but where I think it really needs to go is in the INSTALL file. Lots of people

Re: [Dbmail] sieve fileinto command

2006-08-17 Thread Jake Anderson
igure options. Good work! BTW, I added a wiki page yesterday that shows how to setup imap under xinet.d, take a look and see if I'm missing anything obvious. Matt Jake Anderson wrote: page made http://www.dbmail.org/dokuwiki/doku.php?id=compile_svn let me know what you think? J

Re: [Dbmail] dbmail branched for 2.2 release

2006-10-26 Thread Jake Anderson
Jorge Bastos wrote: You need the asciidoc binary If you're on debian apt-get install asciidoc in ubuntu this is the list of stuff you need apt-get build-essiential autoconf automake1.9 libtool libglib2.0-0 libglib2.0-dev libgmime2.1-dev libgmime2.1 asciidoc xmlto libmysqlclient15-dev

Re: [Dbmail] imapd defunct processes

2006-10-26 Thread Jake Anderson
Dominic Amann wrote: After some minutes of operation, I have some 80 defunct process (out of 100) of dbmail-imapd. It does not seem happen when I connect my e-mail client (thunderbird), but it happens at some point soon after, possibly when the local LAN users begin to connect. What does this

Re: [Dbmail] Command Line Sendmail client for DbMail + Postfix

2006-11-03 Thread Jake Anderson
Nataraj S Narayan wrote: Hi I am having a Dbmail 2.0.9 + postfix setup. Want to write a cron script that tars a Mysql database and sends the tar as mail attachment to one particular user's mailbox. I have both Dbmail and the mysql database in the same machine. Plz help me with mail client pr

Re: [Dbmail] Donwloading DBMail

2006-11-05 Thread Jake Anderson
Maggie Vohs wrote: I have OLD dbmail (1.36) and it just crashed. I downloaded dbmail-2.0.10.tar.gz (04 Apr, 2006) to my desktop but when I tried to open it (or run it or something!) I received an error message saying MS Windows could

Re: [Dbmail] Scoreboard -- running out of threads

2006-11-19 Thread Jake Anderson
Tom Allison wrote: Message Scoreboard state: children [20/20], spares [2 (2 - 4)] Trolling through my folders and such opens a lot of threads. I don't know how many database connections I want to try and support - but is there some way I can help recycle these connections a little easier? __

Re: [Dbmail] Scoreboard -- running out of threads

2006-11-19 Thread Jake Anderson
Tom Allison wrote: Jake Anderson wrote: Tom Allison wrote: Message Scoreboard state: children [20/20], spares [2 (2 - 4)] Trolling through my folders and such opens a lot of threads. I don't know how many database connections I want to try and support - but is there some way I can

Re: [Dbmail] sieve

2006-11-20 Thread Jake Anderson
sieve is basically for sorting mail on the server (and other stuff) the sieved is a way of putting sieve "rules" into the db/mail system you can use avelsive addon for squirrel mail to do it for example. Tom Allison wrote: Just what does dbmail-timsieved "do"? I've never heard of it and my expo

Re: [Dbmail] imapd gobbling memory

2006-12-05 Thread Jake Anderson
jurgen wrote: > Hi, > > I've got dbmail 2.2.1 + mysql 4.1.21 running on a relatively > up-to-date Gentoo box. After some hours of use, dbmail-imapd starts > slowly gobbling more and more of my RAM. Eventually, this gets > completely out of control, we enter paging-hell for a few minutes, and > ulti

Re: [Dbmail] dbmail-imapd memory usage

2006-12-13 Thread Jake Anderson
Daniel Kasak wrote: > Hi all. I've noticed that the memory usage by dbmail-imapd steadily > increases over the period of a couple of days. For example, if I sort > my memory usage in 'top', I get: > The 'buffer' and 'cached' sizes are pretty much the same between the 2 > readings, but the free chi

Re: [Dbmail] Maybe interesting idea

2006-12-17 Thread Jake Anderson
Aaron Stone wrote: > I've been thinking about supporting the virustest/spamtest Sieve > extensions by way of linking to other popular open source virus and spam > testing libraries. It's a bit of a ways off, and it means tieing things > into Sieve rather than the MTA -> LMTP (...) -> DBMail-LMTP de

Re: [Dbmail] Maybe interesting idea

2006-12-17 Thread Jake Anderson
> Far from it. MTA's do a *lot* of work for us. There may be a time when > DBMail has matured to be ready to take over MTA functions, but I don't > think we're anywhere near there yet. The popular MTA's out these days > have 5-10-20 years of development behind them. DBMail is itself only a > littl

Re: [Dbmail] DBMail deleting mail folders without request?

2006-12-20 Thread Jake Anderson
Aleksander wrote: > Hari Sekhon wrote: >> I have noticed just recently that it is marking folders in the >> dbmail_mailboxes table with deleted_flag=1. This was not intentional >> and seems to happen a lot. I have had to stop expunging from the >> database due to fear of losing company email. > > m

Re: [Dbmail] improving dbmail dbpgsql.c

2006-12-28 Thread jake anderson
Paul J Stevens wrote: Michael Monnerie wrote: I have this log: dbpgsql.c,db_query(+279): [SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('[EMAIL PROTECTED]') AND lower(alias) <> lower(deliver_to)] couldn't you write 'AND alias <> deliver_to'? I mean, skip the "lower

Re: [Dbmail] backup database, how often?

2007-01-28 Thread Jake Anderson
Paul J Stevens wrote: > tom wrote: > >> OK, I'll ask a dumb question. >> I thought PHP was for web pages and not for administrative back-office >> applications. >> >> But it's been a while since I used PHP... >> > > Well, I hear you. I started using php when it was still php/fi > (pre-2.0),

Re: [Dbmail] ANNOUNCE: DBMail 2.2.2 released

2007-02-02 Thread Jake Anderson
Aaron Stone wrote: > On Fri, Feb 2, 2007, Leander Koornneef <[EMAIL PROTECTED]> said: > > [snip] > >> Perhaps this would be a good time to call upon the dbmail constituency >> and let the users democratically decide what needs to be done next. >> > > For some incidental features, I would be

Re: [Dbmail] ANNOUNCE: DBMail 2.2.2 released

2007-02-05 Thread Jake Anderson
*caution* Long rambling post ahead best taken with an ice cold ginger beer. (and possibly some salt) > > >> The move to a truly threaded, scalable and HA architecture is a big >> change. I don't think its going to be a standard upgrade for most >> people. If people want true HA then the level of

Re: [Dbmail] Per user read status

2007-02-22 Thread Jake Anderson
Paul J Stevens wrote: > Andrea Mistrali wrote: > >> Everything works good, I've already set up a test system and it is >> working good even under stress. The problem I have is in using Public >> folders: >> if user A reads messages in folder #Public/Tech, then user B finds >> messages already re

Re: [Dbmail] 2.0.x support

2007-02-27 Thread Jake Anderson
Paul J Stevens wrote: > The 2.0 is not really supported anymore. > > If someone comes up with a patch that fixes some critical problem that > is not solved by upgrading to 2.2 we might do another release. But as > for me, the 2.2 series is the only supported stable series. > > [EMAIL PROTECTED] wro

Re: [Dbmail] DBMail and Ubuntu

2007-03-06 Thread Jake Anderson
Alan Garrison wrote: > I'm an Ubuntu guy and DBMail is looking great, but I noticed that the > 2.x series isn't in Ubuntu except for the upcoming Feisty release. If > I set up a Feisty box, could I be reasonably sure that from then on > DBMail will be fairly up to date in Ubuntu as opposed to keep

Re: [Dbmail] Upgraded to dbmail v2.2.4 killed mail server - Help!!!

2007-03-14 Thread Jake Anderson
Paul J Stevens wrote: > Stephen Loeckle wrote: > >> The init script has not worked for me on deb etch using the packages >> when shutting down or restarting services in versions 2.2.3 and 2.2.4. >> After 2.2.4 I modified the script with killalls without the 9 to do a >> reasonably safe shutdown

Re: [Dbmail] Upgraded to dbmail v2.2.4 killed mail server - Help!!!

2007-03-14 Thread Jake Anderson
Paul J Stevens wrote: > Aaron Stone wrote: > >> On Wed, 2007-03-14 at 19:02 +1100, Jake Anderson wrote: >> >> >>> I've had problems with it not creating the PID directory if it didn't >>> already exist in ubuntu. >>>

Re: [Dbmail] login id

2007-03-21 Thread Jake Anderson
Fred Zinsli wrote: > How can I make it so that when a user logs in they must use there entire > email address "[EMAIL PROTECTED]" to check emails. > > >From what I can gather the user needs to login with their login id without > the domain information "someone". > > I ask this because I have severa

Re: [Dbmail] MySQL Redundancy / MySQL Cluster

2007-03-25 Thread Jake Anderson
Rob Gil wrote: > Hey all, > > Its been a while since I posted on this list. I was recently laid off > and have had a good amount of time on my hands. In a recent interview > I was hammered with global load balancing and high availability > questions. The company was a content delivery based busines

Re: [Dbmail] MySQL Redundancy / MySQL Cluster

2007-03-26 Thread Jake Anderson
ere is no performance benefit to the user being on the other server (its actually a performance hit) you do it simply for redundancy. But then I spose any increase in redundancy is going to cause a performance hit as you have another machine doing the same job when it could be doing a different one. Pl

Re: [Dbmail] user info

2007-03-29 Thread Jake Anderson
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 us

Re: [Dbmail] Configurations for performance

2007-03-29 Thread Jake Anderson
Marc Dirix wrote: > Actually we use SATA, in RAID5 with XFS. With just not 10K users. > Works like a charm. > However we're on Postgres, not mysql. Any bus you choose these days is that much faster than the drive theres no real point in getting SCSI or anything. The only reason to choose something

Re: [Dbmail] Configurations for performance

2007-03-29 Thread Jake Anderson
> When I first installed my test systems I had MySQL in master-master > replication which worked great, but my bubble was burst with the IMAP > ID not being guaranteed to be incrementing for each message. I found > that the traffic on the network using the built-in replication was > about 20% of t

Re: [Dbmail] Configurations for performance

2007-03-29 Thread Jake Anderson
> Perdition would solve the IMAP UID problem, but it doesn't help with the > plain old auto_increment collisions... > > Yeah thats what i was thinking, to me thats just part of multi master replication. Although... you wouldn't really need multi-master as each server really is the "real deal"

Re: [Dbmail] Configurations for performance

2007-03-29 Thread Jake Anderson
Aaron Stone wrote: > On Fri, 2007-03-30 at 13:44 +1000, Jake Anderson wrote: > >>> Perdition would solve the IMAP UID problem, but it doesn't help with the >>> plain old auto_increment collisions... >>> >>> >>> >> Yeah th

Re: [Dbmail] Configurations for performance

2007-03-30 Thread Jake Anderson
Change the query it uses (in a sql/ldap lookup), you can include the user in it as well. you can set the query in the config file. Aaron Stone wrote: > This doesn't yet help with a single huge domain, though. For that we need > to partition based on the localpart. > > On Fri, Mar 30, 2007, Curtis

Re: [Dbmail] Debian problem

2007-04-11 Thread Jake Anderson
Tom Allison wrote: > My apologies for not filing a bug report with Debian (I don't have > that much working on my machine just yet) > > But I was installing dbmail and ran into this problem that I would > like to (hopefully) pass on to the debian maintaners: > > Unpacking dbmail (from .../dbmail_2.

Re: [Dbmail] IMAP speed with Thunderbird

2007-04-16 Thread Jake Anderson
Robert Claeson wrote: > > On 16 Apr 2007, at 03:35, Josh Marshall wrote: > >> This is just preliminary findings, but if you set the number of IMAP >> connections to cache in Thunderbird to 0 (defaults to 5) the speed is >> much improved (in my case a hundredfold) and there's less likelihood >> for

Re: [Dbmail] smtp before pop3/imap

2007-04-24 Thread Jake Anderson
> > > It really isn't that complicated or difficult - unless you are > incompetent, incapable of expressing yourself, or afraid for your job > if you speak your mind. > And if as the person said he was at the small ISP level his job is on the line. The induhvidual luser can choose to have good pas

Re: [Dbmail] ANNOUNCE: dbmail-2.2.5rc3

2007-05-23 Thread Jake Anderson
Paul J Stevens wrote: > > It's here. Go get it. > > Changes since rc2: > > - Memory leakages in the imap daemon > - Outlook Office doesn't show new messages > - Synchronisation problems in several clients > > source: > > http://www.dbmail.org/download/2.2/dbmail-2.2.5rc3.tar.gz > > debs: > >

Re: [Dbmail] DBmail webmail app

2007-05-30 Thread Jake Anderson
Charles Marcus wrote: >> Other than naming, there are very few plans to expand into new tables. >> The cplog patch (for tracking movement of messages accross mailfolders) >> shows promise, so in general; new tables are likely during the 2.3 >> cycle. There is also some work in the pipeline to decou

Re: [Dbmail] DBmail webmail app

2007-05-30 Thread Jake Anderson
Josh Marshall wrote: > >> I have sometimes wondered about storing (large? say > n mbytes) >> attachments as files outside the DB. > If you use a multi-mailserver system (using a common SQL server) then > these files would then have to be accessible via nfs. It's easier in > my circumstance to have

Re: [Dbmail] DBmail webmail app

2007-05-31 Thread Jake Anderson
> Call me an optimist, but if those numbers are indeed correct, we may > have to reschedule (provided resources are available). It's not that > much work, and I know how to do it. And 80% or even 50% gain in storage > should be worth something significant even at current storage cost. > Would i

Re: [Dbmail] DBmail webmail app

2007-06-01 Thread Jake Anderson
Paul J Stevens wrote: > Jake Anderson wrote: > >> Would it be possible to create a query that we end users could run over >> our databases to find out about this? >> > > Alas, no. Currently, messages are chopped into 512k blocks. Nothing you > can deri

Re: [Dbmail] DBmail webmail app

2007-06-02 Thread Jake Anderson
> Definitely. We need an algorithm that will prevent collisions at all cost. > Such > checksums will only be calculated during insertion to ensure uniqueness of the > attachment so they will not affect the retrieval processes (pop/imap). > Just a thought on the mechanism for this, Might it be

Re: [Dbmail] DBmail webmail app

2007-06-02 Thread Jake Anderson
Paul J Stevens wrote: > Charles Marcus wrote: > >> There should obviously be a method for dealing with high-load >> conditions, where DBMail stores the message initially without doing the >> SIS work, but flags it for processing later when the load goes below a >> pre-configured level. >> >

Re: [Dbmail] DBmail webmail app

2007-06-04 Thread Jake Anderson
> > It should be even enough to take the first and last 512K of a message. > With intelligent hardware and zero-copy mechanisms, it could be > possible to directly pass the data stream into SQL, without copying it > around in memory. Then the checksum calculation can be a big > performance hit

Re: [Dbmail] DBmail webmail app

2007-06-04 Thread Jake Anderson
> To solve the problem of changing hash types, I suggest simply > self-labeling the contents: "{sha1}hashvalue" > and then down the road: "{sha4096}longerhashvalue" > with some limited future-proofing by picking a reasonable length. > > Aaron > That doesn't sound too "relational" perhaps an ex

Re: [Dbmail] DBmail webmail app

2007-06-04 Thread Jake Anderson
> > The proposed schema has some merit, but I would rather setup two new tables > (partslists and mimeparts) which would be functionally like Jonathan's two > tables. Main difference is I want to leave the current tables as they are: new > messages get inserted into the new setup, and old messages

Re: [Dbmail] DBmail webmail app

2007-06-04 Thread Jake Anderson
Aaron Stone wrote: > This would be a really interesting use case for folder annotations. > > Not sure what you mean by scanning two tables. Do you mean the > partslist / mimeparts tables? Because of the relational model, indexes > and the fact that many IMAP queries request individual IMAP parts ra

Re: [Dbmail] DBmail webmail app

2007-06-04 Thread Jake Anderson
[EMAIL PROTECTED] wrote: > Sounds migratory... > But it might be the best approach. > > I think at the current state of the art the following is reasonably true: > SHA1/MD5 is fast enough for the typically allowed file sizes in a mail > system (10MB) given the frequency with which they occur. > > I

Re: [Dbmail] DBmail webmail app

2007-06-06 Thread Jake Anderson
> > However and whatever is done, it shouldn't be based on a narrow set of > assumptions to the expense of others. > > I'm not saying it doesn't have merit to take 100MB email into > consideration. > But as you've mentioned before, the current practice you've seen is > not 100MB email delivery but

Re: [Dbmail] Dbmail and Imap proble

2007-06-07 Thread Jake Anderson
On Thu, 2007-06-07 at 11:21 -0300, Cristian Prediger wrote: > hi... > i have a big problem with my dbmail server... > i have a fedora core 6 and my dbmail server... > when i send a email to any user... > for example: > localhost# mail jhon > cc: > dasds > # > > and later i do, > #cat /var/spool/ma

Re: [Dbmail] compressing header info

2007-06-19 Thread Jake Anderson
Paul J Stevens wrote: Aaron Stone wrote: I'm not convinced that there's much point to having another bridge table for the headers. We're not talking about very much data, and I'd be concerned that we would be killing off some useful indexes for fast header retrievals. Wrong on both cou

Re: [Dbmail] compressing header info

2007-06-19 Thread Jake Anderson
Paul J Stevens wrote: Jake Anderson wrote: Wouldn't a client generally request all the header information in one hit though? You don't know in advance what headers are requested by a client. Squirrelmail fetches other headers than thunderbird which fetches other fields th

Re: Fw: [Dbmail] imap IDLE support

2007-06-19 Thread Jake Anderson
For 2.3, I want to add an other improvement that will make IDLE very cheap. Using triggers we can update the relevant mailbox row when ever a message row is added, updated or deleted. A simple mtime field in the mailboxes table that is updated by triggers will make it very cheap to poll for mail

Re: [Dbmail] new mails only with button send/receive

2007-06-28 Thread Jake Anderson
Is the IDLE also responsible for looking for new mails in all folders? This is also a functionality I miss... Regards, Uwe If you are using thunderbird you need to tell it to check for mail in all folders google thunderbird imap all folders ___

[Dbmail] postfix ish question.

2007-07-01 Thread Jake Anderson
I have been given a pop3 account on another server. I want to grab its emails and use that account through my shiny dbmail imap account. I can grab the email with fetchmail and put it into a local account of the same name, however when i try to send mail (though our local imap/smtp server) to o

Re: [Dbmail] MYSQL performance

2007-07-05 Thread Jake Anderson
Just to check. You are using imapproxy right? Even for home use it makes webmail/squirel mail way faster. James Greig wrote: Thanx for the response guys. On a side note I actually work for the same ISP as Jon Duggan who has been discussing other issues we've had mainly related to 579. The perf

Re: [Dbmail] Duplicate suppression, In CVS only?

2007-07-10 Thread Jake Anderson
Paul J Stevens wrote: It's not released yet, but I'll release 2.2.6-rc1 tomorrow. Does this have the nifty single storage setup? and is there a way to migrate existing messages to that other than another db and imapsync? ___ DBmail mailing list DBmai

Re: [Dbmail] announce: dbmail-2.2.6-rc1

2007-07-16 Thread Jake Anderson
Just to say its all working as a bonus the binary installed fine in ubuntu 7.04, no compiling needed. Paul J Stevens wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi all, I've uploaded v2.2.6-rc1 The main highlights: - - fixes an error in the imap code that was plaguing squirrelmail

Re: [Dbmail] SASL and GSSAPI

2007-07-20 Thread Jake Anderson
Aaron Stone wrote: We have some instructions on the wiki for setting up SASL - MySQL so that you can use DBMail's user database as a SASL provider, but we do not have any support for asking SASL for authentication from an outside provider. Patches are more than welcome for this, as we just haven

Re: [Dbmail] Converting from PostgreSQL to MySQL

2007-07-21 Thread Jake Anderson
David Leinbach wrote: Hi, I have been running DBMail against a PostgreSQL database for a few years now and have been pretty impressed. However, in an effort to simply things, I would like to switch to MySQL since I have to have MySQL for some of the other stuff I am running but DBMail is the on

Re: [Dbmail] dbmail IMAP 10x more traffic than cyrus IMAP?

2007-08-13 Thread Jake Anderson
Michael Monnerie wrote: On Dienstag, 14. August 2007 Aaron Stone wrote: Wait, wait, that bug is about load not data traffic. I think you just need to set a longer idle delay so that traffic is reduced back to an acceptable level for your mobile users. I have [IMAP] IDLE_TIMEOUT = 59 T

Re: [Dbmail] MySQL copying to tmp table

2007-08-15 Thread Jake Anderson
Jesse Norell wrote: But I think than 'copying to tmp table' requests make velocity too badly. This was discussed on the list not long ago .. iirc, the proposed solution was to have a config item for where your tmp directory is located; those who don't want it on a physical disk can simpl

Re: [Dbmail] stunnel4 and Debian

2007-10-07 Thread Jake Anderson
Tom Allison wrote: On Oct 7, 2007, at 3:09 PM, Tom Allison wrote: I'm trying to set up a new dbmail box which should only use stunnel4 for access. I'm running into a number of problems with this set up and I'm not getting any message back from various applications, which makes it kind of

Re: [Dbmail] stunnel4 and Debian

2007-10-08 Thread Jake Anderson
Paul J Stevens wrote: Jake Anderson wrote: I have had problems with the init scripts not creating /var/run/dbmail/ even though they expect it to exist. You must be on ubuntu then. This will be fixed by the next upload. Got it in one and thanks ;->. Also ubuntu gutsy (7.10 due

Re: [Dbmail] stunnel4 and Debian

2007-10-08 Thread Jake Anderson
Tom Allison wrote: On Oct 8, 2007, at 3:08 AM, Paul J Stevens wrote: stunnel references were removed from the dbmail init script quite some time ago. The reference still remaining in default/dbmail is defunct and should/will be removed. so SSL_TRUE and PEM_FILE are defunct? Removed them

Re: [Dbmail] Alive?

2007-10-22 Thread Jake Anderson
Jorge Bastos wrote: Test? ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail ACK ___ DBm

Re: [Dbmail] Mailling lists

2007-11-05 Thread Jake Anderson
Jorge Bastos wrote: Paul/Aaron, I need to setup a mailling list, how can I do that? Is this supported? Jorge mailing lists are not part of dbmail get majordomo or something. ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.

Re: [Dbmail] dbmail-imapd eating CPU

2007-11-22 Thread Jake Anderson
umask wrote: We're ignored... And waiting for mass DoS :( Perhaps put some $ towards a developer if it bothers you enough or submit a patch yourself. Winging and bad mouthing people who are giving you stuff for free isn't particularly nice, or likely to motivate people to help you. _

Re: [Dbmail] DBMail 2.3.0 released

2007-12-13 Thread Jake Anderson
Are you going to make this available in a debian repo? Paul J Stevens wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm very proud to announce the availability of DBMail 2.3.0, the first of the new development series. Please be advised that this is a technology preview only, a

Re: [Dbmail] Re: DBMail 2.3.0 released

2007-12-17 Thread Jake Anderson
I believe the files are MD5 hashed or similar, coupled with file length rather than name. Jorge Bastos wrote: I did some search, i actually i have some of then with the same size, same number of bytes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

Re: [Dbmail] enormous DB Traffic using imapsync

2007-12-26 Thread Jake Anderson
This issue has been discussed fully and debated to death several times. This is a good idea for uniqueness, but it won't work at all for IMAP due to protocol restrictions and client behavior. Please search the mailing list archives for dbmail and dbmail-dev to find discussion threads (there are

Re: [Dbmail] Re: DBMail 2.3.0 released

2007-12-31 Thread Jake Anderson
Paul J Stevens wrote: Matija Grabnar wrote: I re-iterate: regardless of which digest algorithm is chosen, the code MUST be able to detect and correctly handle collisions. Collisions WILL occur, regardless of the algorithm chosen. It is a mathematically provable fact. For those of you w

Re: [Dbmail] mail execute on server?

2008-01-21 Thread Jake Anderson
Sim Zacks wrote: Are there any server-side security possibilities involved in dbmail? For example, is it at all possible that a received email attachment will actually execute on the server? Or could a mail with specific headers cause the dbmail to execute shell commands or run an application?

Re: AW: [Dbmail] Can dbmail cope with 1.000 e-mails/s ?

2008-01-27 Thread Jake Anderson
James Greig wrote: Hey, Not sure if this is really relevant. We have dbmail 2.2.8 on a mail cluster receiving approximately 2 million connections every 24hours (according to stats). That's including rejections/insertions. Around 5000 customer mailboxes (we're a datacenter/virtual hosting c

Re: [Dbmail] mail encryption

2008-01-28 Thread Jake Anderson
Sim Zacks wrote: I've read a lot about password encryption with dbmail, but does (or can) dbmail support encrpytion of the actual messages? Our CEO and CFO are both very concerned with the idea of switching to IMAP because it would make it simple for the system administrators to read their emai

Re: AW: [Dbmail] dbmail @ ohloh

2008-05-28 Thread Jake Anderson
i bailed when it asked me to sign up Simon Lange wrote: Okay, but you may take a site which does not force registration. ;) Otherwise you wont get a result which reflects the real usage. Simon __ UseTorrent - der sich

Re: [Dbmail] dbmail postgresql

2008-06-06 Thread Jake Anderson
I have been looking at doing the same, I was trying however to do SQL > dbmail-lmtp rather than SQL > SQL That way the conversion can get the benefits of single instance storage etc. But there's no way to do it that will maintain flags that I know of. SQL > IMAP may work but the speed of imap ins

Re: [Dbmail] replication

2008-06-12 Thread Jake Anderson
You can use the multi-master replication as a performance booster. You just have to make sure that all traffic for a particular user (SMTP and IMAP) goes to one server (not necessarily the same one) for the duration of their session. The easiest way is to just assign a user to a server permanent

Re: [Dbmail] replication

2008-06-17 Thread Jake Anderson
multi master replication for multi site should work as it stands All you need to do is just have one central injection point for the email. Then it will filter out via mysql replication to the client sites where they can access it "locally". Disaster recovery is manual but speedy. Simon Gray

Re: [Dbmail] replication

2008-06-17 Thread Jake Anderson
Jesse Norell wrote: On Tue, 2008-06-17 at 21:02 +1000, Jake Anderson wrote: multi master replication for multi site should work as it stands All you need to do is just have one central injection point for the email. Then it will filter out via mysql replication to the client sites where

Re: [Dbmail] search capability

2008-06-18 Thread Jake Anderson
Idle is only an issue in the unstable branch if your running 2.2 you should be fine with idle Sim Zacks wrote: I would like my email client to always search locally for email and not use the IMAP for online search. This is because we download all of our email anyway, and searching is much faste

Re: [Dbmail] [imap] different behaveior between outlook and thunderbird

2008-06-27 Thread Jake Anderson
if its an issue install imapproxy Uwe Kiewel wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I can see different behaveior between thunderbird and outlook. Dbmail-imapd spans only one process per user and connection while using thunderbird, dbmail-imapd creates a new process every time

Re: AW: [Dbmail] need a link

2008-07-26 Thread Jake Anderson
put the cgi in the html directory and allow it to execute option exec-cgi or something David B. wrote: READ the message, I know how to set up CGI, that isn't the point. It's how to feed html in CGI that's the point. From everything I've read you can't feed html files out of a cgi-bin directory

Re: [Dbmail] Query to show mailbox folders running slow

2008-08-21 Thread Jake Anderson
                       paul at nfg.nl  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31  The Netherlandshttp://www.nfg.nl ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/li

Re: [Dbmail] Query to show mailbox folders running slow

2008-08-27 Thread Jake Anderson
DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Query to show mailbox folders running slow

2008-08-27 Thread Jake Anderson
), we see little to nothing for slow queries. However, when the server hits whatever the source of the bottleneck is, every query being run slows to a crawl. On Wed, Aug 27, 2008 at 8:00 PM, Jake Anderson <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: Have you tried turning

Re: [Dbmail] Query to show mailbox folders running slow

2008-08-27 Thread Jake Anderson
Its probably best to post them to the list. That way everybody can see them If they don't want them their delete button should work ;-P Josh Marshall wrote: Something else to try is the innotop program, it'll show any queries currently running and how many per second etc. I have 3800 users on a

[Dbmail] deb install for 2.3 series on ubuntu hardy

2008-10-22 Thread Jake Anderson
trying to do an install into an ubuntu hardy box. I'd like to use the 2.3 series if its possible, I have the line deb http://debian.nfgd.net/debian experimental main in my sources.list but its lacking the magic mojo dbmail: Depends: libgmime-2.0-2a but it is not installable Depends: li

Re: [Dbmail] mysql + slow queries

2008-10-24 Thread Jake Anderson
Giulio Ferro wrote: I'm having serious problems in a production environment with slow queries. S.o.: freebsd 7 stable amd64. DB: mysql5.1.28 compiled from source The query that slows the db is: SELECT messageblk, is_header FROM dbmail_messageblks WHERE physmessage_id = ORDER BY messageblk_i

Re: [Dbmail] mysql + slow queries

2008-10-24 Thread Jake Anderson
Giulio Ferro wrote: Paul J Stevens wrote: Giulio Ferro wrote: Also if you post your hardware configuration and the my.cnf here somebody might have a hint for you. No hardware specs? It's a intel dual proc quad core with 8GB RAM Then the only things I've significantly changed a

Re: [Dbmail] mysql + slow queries

2008-10-24 Thread Jake Anderson
l? Thanks ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail Oh perhaps a "fix" would be to upgrade to 2.3 series and then imap copy everything over. that might help things along a little -

  1   2   >