[Dbmail] dbmail setup

2003-02-25 Thread Markus Welsch
Hi all, Today I tried installing dbMail v1.1. I've downloaded the MySQL-Max 3.55 binary (Linux libc) and extracted that to /usr/local/mysql, changed permissions, etc according to the INSTALL-BINARY instruction file. Afterwards I tried running the build.sh: This is the dbmail build script I will

Re: Re: [Dbmail] dbmail setup

2003-02-26 Thread Markus Welsch
Hi, > You might add > deb http://debian.nfgd.net/debian/ woody/ > to your sources.list and install dbmail-mysql. You'll find a late cvs > pre 1.1 version > there for now. 1.1 will follow rsn. > But then, why are you installing mysql-max instead of simply doing > apt-get install mysql-server ? T

[Dbmail] dbmail setup

2003-02-28 Thread Markus Welsch
Hi all, After reinstalling the mysql-packages I have been able to compile dbmail. box:/usr/src/dbmail-1.1# dpkg --list | grep mysql ii libdbd-mysql-p 1.2216-2 mySQL database interface for Perl ii libmysqlclient 3.23.51-1woody mysql database client library ii libmysqlclient 3.23.51-1wood

[Dbmail] pop before smtp ; postfix and mysql => problem

2003-02-28 Thread Markus Welsch
Hi all, Now since I'm able to use dbmail I'd like to implement POP-before-SMTP. I've created the table, configured dbmail to write it's information to it, the only problem is at the postfix side: Feb 28 13:36:36 box postfix/smtpd[2480]: warning: connect to mysql server localhost: Can't conne

[Dbmail] SMTP AUTH, POP/IMAP-before-SMTP

2003-02-28 Thread Markus Welsch
Hey, I came up with a working solution: # define mysql maps alias_maps = mysql:/etc/postfix/mysql/alias.cf mynetworks = 127.0.0.1/8, mysql:/etc/postfix/mysql/pop_imap_before_smtp.cf relocated_maps = mysql:/etc/postfix/mysql/relocated.cf transport_maps = mysql:/etc/postfix/mysql/transport.cf virt

[Dbmail] performance with pop3 daemon and attachments of x+ MB

2003-02-28 Thread Markus Welsch
Hi, Did anyone experience problems with attachments of a size like 8 MB and more ? The pop3 daemon gets pretty slow at this stage. The server I'm using for testing purposes isn't fast though so the real bottleneck could be that also ... but still, it taks ages ... CPU: 233 MHz

[Dbmail] dbmail-pop performance with attachments ; hardware suggestions required

2003-03-02 Thread Markus Welsch
Hi, I'm using the dbmail package found at http://debian.nfgd.net/debian/unstable/ I've set up a unstable testing box and did a performance check regarding attachments. Here is the load whilst processing a 8 MB attachment: Cpu(s): 99.3% user, 0.7% system, 0.0% nice, 0.0% idle Me

[Dbmail] pop before smtp ; postfix and mysql => problem

2003-03-02 Thread Markus Welsch
Hi, I should've checked if postfix is running chrooted and for that reason can't find the socket file since it's placed outside of the chroot tree. Well this was the case - postfix is running chrooted (which is nice btw). To solve the problem without loosing security you could bind mysqld to 127.

[Dbmail] Performance differences between MySQL and PostgreSQL in case of dbMail usage ?

2003-03-03 Thread Markus Welsch
Hi, Anybody did a performance test between those two databases and recognized a significant performance difference ? Interesting would be if there is a difference in case of attachments of multiple MB's - like 8+ MB. Kind regards, Markus

[Dbmail] announce mailing list

2003-03-11 Thread Markus Welsch
Hi, I'd like to have a seperate list just for announces. Like common for other mailing lists also - like the postfix-announce-list, etc. What do you think about that ? Kind Regards, Markus