Re: [Dbmail] Performance Issues
Ok, I did the following, to get the Maildir Folder into the database (MySQL running on a P200, 64MB): foreach file in *;do cat $file|dbmail-smtp -u q; done There have been numerous complaints about the speed of IMAP in dbmail. I don't know if a definitive answer has ever been given but I remember somebody saying that the problems went away when they moved the database to a better box. Maybe p200 64MB is just not big enough to run dbmail especially if IMAP is needed. Can you do a top and tell us if your memory or CPU is overwhelmed? I remember somebody complaining about dbmail hogging the CPU once. :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/
Re: [Dbmail] Exchange compatibility
At 11:10 AM 2/7/2003 -0800, Dan Kuykendall wrote: Is anyone still looking to work on this? It has been a big goal of phpGroupWare to accomplish this using web services protocols and a replacement mapi.dll which will use SOAP or XML-RPC to make calls to the phpGW server. I have just recently learned about your project and am very happy it exists and excited about the potential. Im just going to start digging into the code and if you guys dont mind I am going to toss together an XML-RPC interface to your database. I will write it in PHP and will access the tables directly (no need for pop3/imap), and see how it works out. If I can get this initial piece working then I may be brave enough to start digging into the mapi.dll functions and see if I can build a small one that connects thru this XML-RPC interface. After that I can then use phpGW's other services to fill in the rest of the groupware tools. The feb issue of Linux Journal had a nice article on reverse engineering of exchange. IMAP was a part of it but there are other parts as well (as I am sure you are aware). If you have not read it yet you want to pick up an issue. :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/
Re: [Dbmail] DATETIME vs TIMESTAMP
At 09:29 AM 2/5/2003 +0100, you wrote: works on my postgresql.. I'm using 7.2.1; i tried the following in the psql program: It did not work on 7.3.1. Perhaps they changed it. :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/
Re: [Dbmail] HOW-TO?
At 09:22 PM 1/20/2003 +0100, =?iso-8859-2?Q?Jan_Pavl=EDk?= wrote: Can someone, who use qmail+dbmail with smtp after pop, send me step by step HOW-TO do it? Me problems continue, I try CVS version, but no change. Only one works: |/var/qmail/bin/dbmail-smtp -u ${RECIPIENT:7} this in .qmail-default, but it doesn't work aliases... And SMTP after POP the same - SMTP auth is not solution for me :(( What you are attempting will never work. The dbmail-smtp is not a mail server like qmail in that it does not listen on a socket and accept connections. The only way to use your dbmail aliases and domains is to configure your smtp server to use the dbmail database for lookups. I know that you can use postfix with mysql lookups (I also hear it's possible to use postgres but I have never found documentation to that effect) and you can also use exim to read from either mysql or postgres. I have no idea if qmail is able to read from a database. :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/
Re: [Dbmail] How scalable is it?
- complex usage reports and traffic details - postfix also uses DB, and again the virtuals are a view constructed based on other business rules. etc etc. In some sense, DBMail is the starting point for a much more usable and functional system of mail handling. You should not just focus on if it will be faster (although, making sure it won't be slower is important). What a great post. You should write a whitepaper!. I was thinking it might be possible to write triggers to manipulate the postfix text files but I did not know you could have postfix read the database directly that's great. Have you thought of using a non IMAP client for employees which taps into the database directly? I was thinking that might be good way to go internal employees and it would bypass whatever IMAP slowness there might be. :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/
Re: [Dbmail] Dbmail on freebsd.
You fail to mention how you are trying to build 1.0, with the old build system, with the build.sh script for 1.0 or the autoconf in 1.0? Sorry I was using build.sh :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/
Re: [Dbmail] Dbmail on freebsd.
I may be forgetting something, but I think all I had to do was create a symlink that pointed /usr/include/crypt.h to /usr/include/unistd.h. Then I ran the build.sh script and specified the correct paths to my MySQL libs and includes. Ok after a bit of fiddling and symlinking I was able to make dbmail with mysql (whoo hoo). I don't know much about mysql so I am hoping someone can shed some light on a strange problem I am having. I installed mysql and I can run it. I can also connect to it with mysql command line tool but I can't connect to it with mycc or mySqlFront from windows. Since webmin can connect to it as well I figure it's some weird problem but I probably don't need to worry about it yet. Is this a myodbc problem or what? Thanks. :wq Tim Uckun US Investigations Services/Due Diligence http://www.diligence.com/