[Dbmail] I create a console user interface for dbmail

2003-03-12 Thread dbmail
Hi. DBMail rules. I create a nice console interface to manage DBMail in Solaris. It's basically a shell script that implements most DBMail functions using the linux dialog command. It uses the /etc/postfix/transport file as the basis to implement multi-domain control. Assumes you create

Re: [Dbmail] SQL QUERY TO LIST USERS IN A BASH SCRIPT

2003-03-18 Thread dbmail
Good advice. It will help to streamline my dbmail.sh dialog administration interface. > Last week i ask > > I would like to now de mysql command to put in > a bash script to list all the users in a dbmail database. > > I figure out the command just type: > > > mysql -

Re: [Dbmail] QUOTUM USED

2003-03-18 Thread dbmail
I agree with you. I recieve similar messages when I have just create the account, but no message has beem recieve. > I create a user jacques-beaudoin in dbmail > Then i execute > > dbmail-adduser s jacques-beaudoin > > I get a listing > > *** dbmail-adduser *** > Ope

[Dbmail] dbmail.sh - With MYSQL support

2003-03-21 Thread dbmail
Hi. Here it's my latest release of dbmail.sh. After the comment of Paul J Stevens about the advantages of the independece of the DBMail daemons and the MTA (postfix in my case), I made some tweaks to dbmail.sh. My script it's made from start to be domain aware, which I believe i

[Dbmail] Stopping dbmail-imapd and dbmail-pop3d

2003-05-29 Thread dbmail
I running dbmail under the user dbmail in my Solaris 9 x86 box. I have this this solution: you can use grep and awk to extract pid numbers and use a for loop to kill the processes that match. For example: pidlist=`ps -ef | grep dbmail | grep -v grep | awk '/root/ {print $2}'` for pid i

[Dbmail] Administration script

2003-05-29 Thread dbmail
mprovements: Add a new fuction to main menu: Backup. That allows to backup dbmail database to a file. The TERM=vt100 variable is a little hack to display properly in my dtterm emulator. Other unix/linux system may not need it. Bugs: Correct a bug in the userlist fuction. Script weren't se

Re: [Dbmail] Administration script

2003-05-29 Thread dbmail
Good advice. I don't relay messages to internal o external servers right now, only to dbmail transport. but I think somebody may need it. Thanks. Alejandro Marin > dso> My script is multidomain aware. To do so, I create an addition > table in dso> dbmail database for P

Re: [Dbmail] dbmail-pop3d hogging cpu - reproducable

2003-06-01 Thread dbmail
I agree about the signal implementation problem in Linux. I use DBMail 1.1 in Solaris x86/Sparc in 4 production servers. Since rc3 I never see a cpu hog problem. DBMail 1.1 repairs a small bug that stops dbmail-imapd to daemonize if running from console instead of a rc script, and since that runs

Re: [Dbmail] PHP interface to dbmail

2003-06-03 Thread dbmail
Hi, a couple of questions about this main.cf > /etc/postfix/main.cf: > > local_recipient_maps = mysql:/etc/postfix/mailboxes.cf > mydestination = mysql:/etc/postfix/transport.cf > transport_maps = mysql:/etc/postfix/transport.cf > mynetworks = 127.0.0.1, 216.240.150.150/29, mysql:/etc/postfix/pbsp

Re: [Dbmail] FreeBSD 5.1 & MySQL 4.10

2003-06-11 Thread dbmail
Hi. I higly recomend to use innodb tables instead of the MyISAM ones, because your email system will have problem when database grew up beyond 2 GB. I'm using Postfix 2.0.10, Mysql 4.0.12 in Solaris x86. No problem with database creation. mysql -p dbmail < create_tables_innoDB.mys

Re: [Dbmail] forwarded bounces

2003-06-12 Thread dbmail
I highly recomend you use postfix forwarding if you need to forward email to a server/domain outside of your dbmail server. You can use mysql tables to create the maps. > > Yes, that entry is: > dbmailunix - n n - - pipe > flags=R user=dbmail:dbma

Re: [Dbmail] forwarded bounces

2003-06-13 Thread dbmail
I agree with Micah. DBMail alias table it´s to resolved address that will be recieve by DBMail, not to forward it. > > Hello, > >> alright, I undertstand. Thanks for doing that research Jesse. > > Oh sure ... we're gonna need to fix that for our setup here too >

Re: [Dbmail] forwarded bounces

2003-06-13 Thread dbmail
diferrent smtp server, perhaps in the militarized zone behind your firewall). And the enable/disable will allow you to implement a forward by demand. Last but not least, you can always add the fields to dbmail tables, but you will need to track down those changes when dbmail database schema changes

[Dbmail] Administration script improved

2003-06-15 Thread dbmail
aware. When you rename a user account, it change the default alias, so it's not longer necessary to change the alias manually. DBMAil.sh is domain wise, but requieres to create a table in the dbmail database to store the domains. You may have this table is you are using Mysql to resolve tran

Re: [Dbmail] Solaris 8 - dbmail 1.1

2003-06-16 Thread dbmail
> > Enter new libraries (preceed each by -l) or press RETURN to keep this > setting: > -lmysqlclient -lcrypto -lsec -lgen -lsocket -lnsl -ldl -lresolv > ./build.sh: [-f: command not found > > Creating makefile.. > > Done. You can now make dbmail by running 'make clea

[Dbmail] Configuring MTA Sendmail

2003-06-17 Thread dbmail
According to INSTALL file located in dbmail-1.1 distribution, we should configure our MTA. I dont know how to configure Sendmail, because I do not use Postfix. (My sendmail is now working well) Any reply is very appreciated ! _ This mail

Re: [Dbmail] Installation with MySQL 4.1

2003-06-17 Thread dbmail
Don´t worry with MySQL 4.1x yet. Some users reported problems with the tables schemas. 4.0.12 is working very good. > Hello, > > I am trying to install dbmail-1.1 with MySQL 4.1-alpha and ran into > problem > during the make.. I used the build.sh script and got he following

Re: [Dbmail] Documentation project for dbmail?

2003-06-17 Thread dbmail
I will like to participate in a project like that. I´m have some good papers for DBMail + Postfix + SASL + TSL that can easy create a great solution. > Hi all, > I've just started playing with dbmail, and noticed a lack of friendly > documentation. The man pages are pretty decent,

[Dbmail] Nice tool to clean unconnect alias

2003-06-18 Thread dbmail
aliases # aliaslist=`/opt/mysql/bin/mysql dbmail -s -e "SELECT alias_idnr FROM aliases LEFT JOIN users ON aliases.deliver_to = users.user_idnr WHERE users.user_idnr IS NULL" | grep -v alias_idnr` for alias in $aliaslist do mysql dbmail -s -e "DELETE FROM aliases WHERE ali

Re: [Dbmail] dbmail-adduser not cleaning up the tables

2003-06-19 Thread dbmail
The topic has been on air a cuple of days. For most of the work, you use dbmail-adduser d follow by a dbmail-maintenance -f. Only alias is there to clean up, and I have post a little script to do so a couple of days ago. Alejandro > Could dbmail-adduser be modified to clean up all the >

Re: [Dbmail] Whitelists

2003-07-16 Thread dbmail
Hi Bret. I'm using amavis-new to do virus checking and I want to use ther spamassassin component to check for spam. But I don't think is correct to modified dbmail database to provied support for this functions, because it will be a real nightmare when dbmail schemas changes. I think

[Dbmail] AUTO-Reply

2003-08-06 Thread dbmail
Auto-Reply gives me: send_reply(): reply could not be sent: sendmail error "Sendmail" is postfix, SENDMAIL=/usr/sbin/sendmail [EMAIL PROTECTED] [EMAIL PROTECTED] AUTO_NOTIFY=yes AUTO_REPLY=yes LOG lvl 5: Aug 6 21:13:31 mailhub dbmail/smtp[14311]: db_query(): executing [SELECT reply

[Dbmail] auto-reply part 2

2003-08-06 Thread dbmail
GOT IT!!! whyever (a command-line test didn't do that) dbmail seems to be confised about a "from" or anything with " in it, possible? i couldn't find anything in the source for that, but still... fprintf(mailpipe, "To: %s\n", replyto ? replyto : from); is ap

[Dbmail] (no subject)

2003-08-07 Thread dbmail
Hi. I like to install Mailman with my dbmail/postfix servers. I have it compile, but I like some examples of the main.cf / master.cf files, transport.cf to help me work it out. Regards, Alejandro Marin

[Dbmail] Storing domain Lists in SQL

2003-10-05 Thread dbmail
I'm a newbie to DBMail and had a question about setting up an MTA with multiple domain names. I'd like to be able to define the domain names that my mail server accepts mail from by a mysql database. I know some people have made perl scripts to download the domains from the database

Re: [Dbmail] Storing domain Lists in SQL

2003-10-06 Thread dbmail
It seems redundent to have both dbmail and the MTA check for the validity of the domain name and users. I can understand the problems with spam relays, but can't you just make an MTA that will not deliver mail outside of dbmail? An MTA that only delivers to dbmail would be smaller and qu

[Dbmail] Mac OS X Installation

2003-10-15 Thread dbmail
After installing MySQL in Mac OS X 10.2.8, I have attempted to install dbmail. At the "Run build.sh" step (Step 3 in the "Install" read me), things become unglued: > sudo ./build.sh > This is the dbmail build script > I will have to ask you some questions about your

Re: [Dbmail] Mac OS X Installation

2003-10-16 Thread dbmail
Thanks so much John! Sure enough it makes a big difference with the Developer Tools installed! Still got a "Make failed" error (see below). I think I figured out that I needed to change the default library directory on the dbmail build for MySQL from /usr/local/lib/mysql/ to /usr/l

Re: [Dbmail] Mac OS X Installation

2003-10-16 Thread dbmail
t; > You need the compress libraries, ie. libz. See if you can find > a package or something to load that. > > jn > > > Original Message > From: dbmail > To: > Subject: Re: [Dbmail] Mac OS X Installation > Sent: Wed, 15 Oct 2003 23:39:47 -0500 > &

Re: [Dbmail] Mac OS X Installation

2003-10-16 Thread dbmail
ell wrote: > >> >> Hello, >> >> You need the compress libraries, ie. libz. See if you can find >> a package or something to load that. >> >> jn >> >> >> ---- Original Message >> From: dbmail >> To: >> Subject:

Re: [Dbmail] Mac OS X Installation

2003-10-16 Thread dbmail
ach by -l) or press RETURN to keep this > setting: > -lmysqlclient -lcrypto -lz > > > As for that build.sh script, you can use the -n argument to echo (at > least on most systems) to suppress the newline character and thus make > it appear more like a prompt. > > - Ga

Re: [Dbmail] Mac OS X Installation

2003-10-16 Thread dbmail
Thanks for all the support. That did it! > In the directory where you have the dbmail source: > > sudo ./install-dbmail.sh > > or > > sudo sh ./install-dbmail.sh > > (if that doesn't maybe run sudo as a shell with the -s or -u flag, I dont > have my mac

[Dbmail] Webmin Management of Dbmail?

2003-10-17 Thread dbmail
Are there any modules available for management of dbmail by webmin or other browser management systems? The only reference I could find online or in the archives was Dbmail Admin: http://dbmailadmin.sourceforge.net/ ... but this project appears somewhat abandoned.

Re: [Dbmail] Webmin Management of Dbmail?

2003-10-17 Thread dbmail
Thanks for the response. Unfortunately I am not good at it (which is I guess why I was hoping I could manage dbmail this way, and end up delegating aspects of that management to others even less capable than myself, if that's possible). Just had a look at Joe Cooper's awesome onlin

[Dbmail] updating my dbmail

2003-10-23 Thread dbmail
Hey guys. I installed dbmail a few months ago (version 1.1) and it has been working great. I totally love it, no issues, no mucking around. But im now wanting to update to version 1.2 to take advantage of some of the bug fixes. Im not totally sure the best/safest way to update. I obviously dont

[Dbmail] auto_replies (please be kind)

2003-10-23 Thread dbmail
Heyas. Ok, after successfully updating to dbmail version 1.2 I have attempted to get the auto_reply feature to work. I am using dbmail 1.2 and postfix. Everything is working great. (except for auto_reply) I have searched through forums and docs and found much discussion on the topic of

Re: [Dbmail] auto_replies (please be kind)

2003-10-23 Thread dbmail
Ok, Thanks for that. I will have a look through your thread... And if i find any more info i'll pass it your way.. ;) cheers, Dan. - Original Message - From: "Butch Evans" <[EMAIL PROTECTED]> To: Sent: Thursday, October 23, 2003 4:50 PM Subject: Re: [Dbmail]

[Dbmail] Mac OS X 10.3 Panther

2003-10-26 Thread dbmail
I upgraded to Panther this weekend (nice!), and I'm having some problems installing DBMail, or maybe I'm having problems installing MySQL. I am following the same sequence as for OS X 10.2, but I am getting a "Make failed" error due to "No such file or directory".

Re: [Dbmail] Mac OS X 10.3 Panther

2003-10-27 Thread dbmail
Thanks for the response. Still failed the make. See the transcript of my build script below. Thanks. > Try /usr/local. > > -Micah > > > On Sun October 26 2003 9:17 am, dbmail wrote: >> I upgraded to Panther this weekend (nice!), and I'm having some problems &

Re: [Dbmail] Mac OS X 10.3 Panther

2003-10-27 Thread dbmail
: - As what user are the dbmail daemons going to run? [default: dbmail] As what group are the dbmail daemons going to run? [default: dbmail] Ok installing dbmail executables as dbmail:dbmail.. ./install-dbmail.sh: line 58: /bin/chown: No such file or directory ./install

Re: [Dbmail] Mac OS X 10.3 Panther

2003-10-27 Thread dbmail
Thanks for being patient with me here. Looking in the install-dbmail.sh file, I notice that targetexec=/usr/local/sbin/. Sure enough in that directory are the 5 dbmail commands, so I'm assuming the install-dbmail.sh script is challenged trying to change their ownership. I think the part o

[Dbmail] A little script to clean the Trash folders

2003-12-05 Thread dbmail
imple shell script that uses mysql client to generate a list of all the messages that are in Trash folders and where deleted_flag isn't set. Later, uses a little for loop to set those messages properties to delete status: deleted_flag='1' status='002' You only have to use

[Dbmail] dbmail 2.x with mysql 3.23

2004-01-21 Thread DBMail
Hi list, sorry if this question was mentioned in this list before, but i could not find any related stuff in my archive(mails). I'm currently running dbmail 1.1x (November 2003) and I'd like to upgrade to dbmail 2.x. Unfortunately I cannot change the database (currently running

[Dbmail] dbmail 2.0

2004-11-03 Thread dbmail
I have tested dbmail.(MTA postfix) on Suse 9.1 (for test on vmware) If using myisam tables check should be added like SELECT * FROM dbmail_messages LEFT JOIN dbmail_physmessage ON dbmail_messages.physmessage_id = dbmail_physmessage.id WHERE dbmail_physmessage.id IS NULL if there any records

[Dbmail] dbmail 2.0 NCHILDREN

2004-11-03 Thread dbmail
The NCHILDREN will result one more processes for example: NCHILDREN=2 root 4836 0.0 0.4 2364 796 ?S12:22 0:00 dbmail-imapd nobody4837 0.0 0.4 2364 820 ?S12:22 0:00 dbmail-imapd nobody4838 0.0 0.7 2496 1340 ?S12:22 0:00 dbmail-imapd

[Dbmail] Auto reply does not works..

2004-11-03 Thread dbmail
Auto Reply does not work by me: log: Nov 3 21:49:14 linux dbmail/lmtpd[11392]: dbmysql.c,db_query: executing query [ SELECT reply_body FROM dbmail_auto_replies WHERE user_idnr = 8] Nov 3 21:49:14 linux dbmail/lmtpd[11392]: db.c,db_get_reply_body: found reply_b ody [test reply^M test^M ] Nov

Re: [Dbmail] Auto reply does not works..

2004-11-04 Thread dbmail
unning as mail it will be mailed. It can be specified with -f option of sendmail (so the -f should be used. 2. the to: header is filled out by dbmail-lmtp but with unknown, it should be filled out or not filled out and use the -F option... I cannot program in C but I think I found the error in pi

[Dbmail] No alias mailbox specification

2005-03-20 Thread dbmail
Given two possible user specifications, for dbmail-smtp in dbmail 2.0.4 only using the primary account username directs mail to a particular box. Specifying an alias for the primary user fails when a particular delivery box is specified. The following form works. message | dbmail-smtp -d

Re: [Dbmail] server-side sorting bug

2005-07-21 Thread dbmail
commented out. If you un-comment these lines and recompile then it all works. I'm not quite sure it works correctly: sorting on sender/subject doesn't seem to work correctly, but at least squirrelmail works now again... Hope this helps, Stanley. > > > > > >

Re: [Dbmail] server-side sorting bug

2005-07-25 Thread dbmail
quite sure it works correctly: sorting on sender/subject doesn't >>seem to work correctly, but at least squirrelmail works now again... >> >>Hope this helps, >>Stanley. >> >> >> >> >> >>> >>> >>> >>> >> http-equiv=

RE: [Dbmail] server-side sorting bug

2005-07-26 Thread dbmail
er to a normal user. > > I tried recompiling with the us-ascii uncommented and I seem > to get the same results. Next will be shooting for the > dbmail-2.0.4 SVN tree. > > It seems that only SquirrelMail has this problem and not other > programs, but then again most don'

[Dbmail] UTF-8

2006-12-11 Thread dbmail
Hi, Is it possible to createdb with --encoding=UTF-8 for database dbmail 2.2.x on PostgreSQL? Any time ago I try this on dbmail 2.0.x. I did convert dbmail_messageblks from text to bytea. In POP3-received messages I had simbols \r as \012 and \t as \011. This is right for bytea type PG, but not

[Dbmail] (no subject)

2006-12-12 Thread dbmail
Hi all, I'm trying to install gmime 2.2.2 on my brand new 4.0 system (as an requirement for DBmail 2.2.1) When I try to compile, I get this; if /bin/sh ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H - I. -I. -I.. -I.. -I../util -DGMIME_VERSION= \&

Re: [Dbmail] (no subject)

2006-12-12 Thread dbmail
On 12-dec-2006, at 11:54, Leander Koornneef wrote: On 12-dec-2006, at 11:35, dbmail wrote: Hi all, I'm trying to install gmime 2.2.2 on my brand new 4.0 system (as an requirement for DBmail 2.2.1) When I try to compile, I get this; if /bin/sh ../libtool --tag=CC --mode=compil

[Dbmail] gmime on openbsd 4.0

2006-12-12 Thread dbmail
On 12-dec-2006, at 12:07, dbmail wrote: On 12-dec-2006, at 11:54, Leander Koornneef wrote: On 12-dec-2006, at 11:35, dbmail wrote: Hi all, I'm trying to install gmime 2.2.2 on my brand new 4.0 system (as an requirement for DBmail 2.2.1) When I try to compile, I get this; if /b

Re: [Dbmail] gmime on openbsd 4.0

2006-12-12 Thread dbmail
his ? As I understand it from above, it is plain impossible to install gmime and thus DBmail 2.2 on OpenBSD. Greetz, Daniel _______ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] gmime on openbsd 4.0

2006-12-12 Thread dbmail
On 12-dec-2006, at 14:46, Paul J Stevens wrote: dbmail wrote: On 12-dec-2006, at 13:55, Paul J Stevens wrote: A quick google search reveals that openbsd does not define ECANCELED in errno.h even though it's in the POSIX specs. Those are the messages I found as well. However, I am

Re: [Dbmail] gmime on openbsd 4.0

2006-12-12 Thread dbmail
On 12-dec-2006, at 18:43, Steffen Schuetz wrote: On Tuesday 12 December 2006 14:20, dbmail wrote: On 12-dec-2006, at 13:55, Paul J Stevens wrote: A quick google search reveals that openbsd does not define ECANCELED in errno.h even though it's in the POSIX specs. Those are the messa

Re: [Dbmail] gmime on openbsd 4.0

2006-12-12 Thread dbmail
On 12-dec-2006, at 16:40, Aaron Stone wrote: On Tue, 2006-12-12 at 15:17 +0100, dbmail wrote: On 12-dec-2006, at 14:46, Paul J Stevens wrote: My mistake. gmime-2.1.19 is in freebsd ports not openbsd. Thanks for the quick reply. Above information may be of interest for the wiki ? As

[Dbmail] problem

2002-08-12 Thread dbmail
dbmail crashed the mysql DB the 3rd time in some 2 weeks... always corrupt indices.. can it be that there's an issue with bigger mails or something? with dbmail, mysqlexport doesnt work (or, at least, i cannot reimport due tosyntax errors) mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu

Re: [Dbmail] ANNOUNCE: dbmail-2.1.3 released

2005-10-14 Thread dbmail
py to announce the release of dbmail-2.1.3, a major milestone on > the road to 2.2.0. > > Some noteworthy changes wrt 2.1.2 are: > > - added dbmail-export for dumping mailboxes into mbox files. > - removed the last of the old mime-code. This should make dbmail much > more robus

Re: [Dbmail] Re: Failed. Could not connect to database (check log)

2005-11-08 Thread dbmail
; > Nataraj > > > > Paul J Stevens wrote: > >>Your dbmail.conf states: >> >>/var/run/mysql.sock >> >>whereas your my.cnf states: >> >>/var/run/mysql/mysqld.sock >> >>ergo. >> >> >>Nataraj S Narayan wrote: >>

Re: [Dbmail] Can't fetch certain attachments ( inside forwarded files )

2005-11-08 Thread dbmail
, Stanley. > I'm assuming you're using 2.0.7 right? > > This is a known problem with 2.0's broken mime-parser. 2.1.x does not > have this problem afaict. > > Daniel Kasak wrote: >> Greetings. >> >> I've just installed DBMail onto my desktop, and

Re: [Dbmail] Can't fetch certain attachments ( inside forwarded files )

2005-11-08 Thread dbmail
but *not* in thunderbird. > TB cannot grok message/rfc822 attachments it has generated itself, even > though it shows message/rfc822 attachments generated by evolution just > fine. > >>>>For example, when I view a particular message with Thunde

Re: [Dbmail] Can't fetch certain attachments ( inside forwarded files )

2005-11-17 Thread dbmail
database, and it *is* being delivered by dbmail-imapd. Stanley. > > Hmmm, I'll look deeper into this this evening (if I don't forget); The > attached messages show up (in squirrelmail) with a size of 0 bytes. > > This looks pretty much like the previous problem where att

Re: [Dbmail] change password plugin for squirrelmail

2005-12-28 Thread dbmail
Hi, There is also a plugin "change_mysqlpass". I've been using this with dbmail for quite some time now, you need to modify a few lines in config.php: // The names of the user ID and password columns $mysql_userid_field = 'userid'; $mysql_passw

Re: [Dbmail] change password plugin for squirrelmail

2005-12-28 Thread dbmail
PROTECTED] <[EMAIL PROTECTED]> wrote: >> >> >> Hi, >> >> There is also a plugin "change_mysqlpass". >> >> I've been using this with dbmail for quite some time now, you need to >> modify a few lines in config.php: >&g

Re: [Dbmail] change password plugin for squirrelmail

2005-12-28 Thread dbmail
s from rejecting the command and is a really awful hack. (or as Paul J Stevens put it earlier: "Aarrgh, yuk. Serverside sorting is broken!, But you know that..." ;-) Probably best to stay away from server-side sorting for now. Stanley. > > Why do I get this error for some users? I

[Dbmail] Mail::Box compatibility ?

2006-01-16 Thread dbmail
Dear All, I'm trying to use the Perl Mail::Box modules to access my mailboxes. Does somebody has an experience with these modules ? It seems that the perl module receives unexpected strings from the server. When I try to open a connection, --- my $imap   = Mail::Box::IMAP4->new(us

Re: [Dbmail] Mail::Box compatibility ?

2006-01-18 Thread dbmail
On Mon January 16 2006 18:36, M. J. [Mike] OBrien wrote: > That's not DBMail but just bad Perl code. > The message itself explains the problem. > Try PerlDoc strict etc. > > best... > Mike > Not that simple. As I thought, there is an incompatibility between Mail::Bo

Re: [Dbmail] Mail::Box compatibility ? - last news

2006-01-26 Thread dbmail
It works, but insertions are so slow that it is not practically usable. This problem has been reported in the Mail::Box mailing list in Jun 2005. I haven't seen any follow-up yet. Does anyone know any other Perl module I could use to talk with dbmail-imapd or directly access the database ?

[Dbmail] Sending an email as an attachment from the command line

2006-05-25 Thread DBMAIL
nts are confused. If I were to figure out the encodeing for Outlook it would make it a .msg file. But this would confuse OE. I have found that Dbmail has the result that I am looking for. If I have a bounced messange from dbmail it will attach the original in its message, however the file type s

Re: [Dbmail] #Users and #Public shares not working

2006-06-13 Thread dbmail
d and friends. So if you login as each user one at a time you can subscribe as needed. Understand that if a user unsubscribes to any #User folders from the MUA you'll have to do it again since they won't see it to subscribe once more. I don't know if this is a dbmail issue or not.

Re: [Dbmail] Webmail

2006-08-21 Thread dbmail
quite a while, but in my mind it looks a bit >>dated. Roundcube looks nice, but I've never used it. >> >>Comments? What else are people using? >> >>Matt >>___ >>Dbmail mailing list >>Dbmail@dbmail.or

Re: [Dbmail] Webmail

2006-08-22 Thread dbmail
derbird does retrieve them correctly, >> so >> it must be a client issue. >> >> I am currently investigating FelamiMail (part of egroupware) as >> suggested >> on the list a couple of days ago, but this seems to exhibit the same >> behaviour as squirrelmail. >

[Dbmail] Sieve problem with 2.1.7 ???

2006-08-28 Thread dbmail
x, I also had to re-download and compile libsieve, which is now at 2.1.13. Could this be a libsieve problem, or should I file a dbmail bug? Regards, Stanley.

Re: [Dbmail] Activating Sieve

2006-09-05 Thread dbmail
causes squirrelmail to not display them; they are also deleted at the next dbmail-util run. Somehow FelamiMail does show them, but also with a really strange status... regards, Stanley. > Ya, i putted it to work. > Tks Paul, > > But now i have another question/problem. > I ma

[Dbmail] Local Recipient Verification

2008-04-28 Thread dbmail
Hi, I'm using dbmail with sendmail over lmtp, and from what I can tell, sendmail is effectively acting as a relay. It receives the mail into the local queue, and then tries to deliver it over lmtp. The problem with this is that sendmail will accept all mail restined for the local do

Re: [Dbmail] Local Recipient Verification

2008-04-28 Thread dbmail
I was hoping there is a more direct way. Since dbmail doesn't appear to have an integrated SMTP daemon. :-/ I suppose I could add an option to the Makefile to rebuild the access file from the DB. Or possibly just wrap the dbmail-users to dump the ACL whenever an address is added/removed.

Re: [Dbmail] Local Recipient Verification

2008-04-30 Thread dbmail
I decided to have a go at getting postfix to work with this instead of sendmail as per the suggestion that was made here, and I still have a few problems. This is probably more of a postfix question rather than dbmail, but I'm figuring that it would be a common setup with dbmail so someone

Re: [Dbmail] Local Recipient Verification

2008-04-30 Thread dbmail
On Wed, 30 Apr 2008, Marc Dirix wrote: If I set mytestdomain in mydestination, I can deliver to it. Otherwise I just get relaying denied. Is there a reasonably sane way to have mydestination set so that the list comes from the dbmail mysql backend while still including local host names

Re: [Dbmail] Local Recipient Verification

2008-04-30 Thread dbmail
what you want. You want a local_recipient_maps entry that checks both your dbmail database (which you apparently have working) and also checks the password file. The default value is: $ postconf -d local_recipient_maps local_recipient_maps = proxy:unix:passwd.byname $alias_maps So just add in

Re: [Dbmail] Local Recipient Verification

2008-04-30 Thread dbmail
On Wed, 30 Apr 2008, Jesse Norell wrote: local_recipient_maps = proxy:unix:passwd.byname $alias_maps \ mysql:/etc/postfix/sql-recipients.cf OK, that seems to work. However, now I'm not getting any deliveries to dbmail. dbmail user mail bounces after being accepted by postfi

Re: [Dbmail] Local Recipient Verification

2008-04-30 Thread dbmail
lmtp process is running chroot it may be using different hosts and resolv.conf files than normal system processes. It doesn't seem to be running chroot (note the 5th field is "n"): dbmail-lmtp unix - - n - - lmtp -o disable_dns_lookups

Re: [Dbmail] Upgrade led to mysql conflicts (fwd)

2008-05-06 Thread dbmail
On Tue, 6 May 2008, Gordon Hay wrote: I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the end of the process. DBMAIL (2.2.10) continues to work as expected. But a subsequent "yum update" to catch all the post-FC8 updates threw up a number of errors

Re: [Dbmail] Upgrade led to mysql conflicts

2008-05-06 Thread dbmail
On Tue, 6 May 2008, Gordon Hay wrote: On Tue, 6 May 2008, Gordon Hay wrote: I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the end of the process. DBMAIL (2.2.10) continues to work as expected. But a subsequent "yum update" to catch all the post-FC8 updates t

Re: [Dbmail] DBMAIL grinds to a craw in production

2008-05-13 Thread dbmail
On Tue, 13 May 2008, [EMAIL PROTECTED] wrote: We've been testing DBMail for a few months now and did a test launch yesterday. We have about 850 pop3/imap users accessing through the webmail, Outlook and mobile devices. Things were fine when we tested with a few users, but after we put

Re: [Dbmail] DBMAIL grinds to a craw in production

2008-05-13 Thread dbmail
On Tue, 13 May 2008, Michael Mayer wrote: [EMAIL PROTECTED] wrote: My question is: does the schema that comes with DBMail already have indexing defined in it or do I have to do my own indexing and optimization? Yes, there are indexes - I just checked it with my db (the structure works, so

Re: [Dbmail] DBMAIL grinds to a craw in production

2008-05-13 Thread dbmail
a cache is for sure not the worst idea one could come up with ;) Absolutely agreed. And for the sake of enabling a switch in my.cnf it's worth trying, if it's not enabled already. Gordan ___ DBmail mailing list DBmail@dbmail.org https://mailm

Re: [Dbmail] DBMAIL grinds to a craw in production

2008-05-13 Thread dbmail
l the other mail services (webmail, dbmail, etc.). Another thing that is worth doing is bypassing OS caching for table access because MySQL does it's own caching, and is much more efficient than the generic OS algorithm: innodb_flush_method=O_DIRECT Gordan ______

Re: [Dbmail] Re: messages table index brainstorming

2008-05-14 Thread dbmail
, an indexed search still comes out vastly ahead, in my experience. But if you can empirically demonstrate that over-indexing signifficantly slows down the typical (mostly read) workload of DBMail, I'd be most interested to see it. Gordan On Wed, 14 May 2008, Michael Mayer wrote: Mic

Re: [Dbmail] Re: messages table index brainstorming

2008-05-14 Thread dbmail
-column indices on frequently used fields will generally get you most of the way there in the first pass. Gordan _______ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] Re: messages table index brainstorming

2008-05-14 Thread dbmail
I wish this came up 3 weeks ago. Just before I migrated to dbmail, I purged all of my spam - all 2GB of it (100K-150K messages, IIRC). I figured there'd be no point in migrating it. It'd have made for a good test case. :( Gordan On Wed, 14 May 2008, Michael Mayer wrote: [EMAIL

Re: [Dbmail] connection reset causing lost mail?

2010-10-19 Thread dbmail
On 10/9/10 5:25 PM, Paul J Stevens wrote: > On 10/09/2010 05:14 PM, Reindl Harald wrote: >> I think this is a bug on dbmail-side >> >> lmtpd should send a 4xx-temorary-error instead a 5xx-hard-bounce >> So postfix would try later to deliver the message again >

[Dbmail] aborted transaction (duplicate key) causes dropped mail

2010-10-21 Thread dbmail
;t "simple" but it isn't super twisted - postfix (tumgreyspf policy) to dspam lmtp, dspam (w/ clamav) to dbmail lmtp. (Postfix normalizes the domain wildcards, etc down to u...@local.domain) Oct 21 04:19:31 mayhem dbmail/lmtpd[29968]: Error:[sql] dbpgsql.c,db_query(+2

Re: [Dbmail] not seen message in Thunderbird

2011-02-23 Thread dbmail
I found a post a while back that said to put in a custom CAPABILITIES line that doesn't advertise IDLE - that solved it for my thunderbird and webmail clients both.. On 2/23/11 10:38 AM, Olivier Desportes wrote: Do you have maintenance scripts scheduled ? My dbmail version came with

[Dbmail] Problem with sorting mail

2012-09-17 Thread dbmail
about 1 dublicate entries for physmessage_id. I tried to clear the tables envelope, headervalue, referencesfield and replytofield and rebuild those using dbmail-util. I do not have any dublicates is physmessage. Any ideas how to repair this. Stefan

[Dbmail] Long boundary in MIME header

2013-02-04 Thread dbmail
Hi, I have installed postfix, dbmail 2.2.11 and gmime 2.2.23. It looks like the boundary in MIME header can be a maximum 62 characters long. Then something (dbmail or gmime or anything else) cut the boundary to 2 lines, like this: MIME-Version: 1.0 Content-Type: multipart/alternative

[Dbmail] version 1.2.1 dbmail-pop3d & imapd 99% CPU usage !

2003-11-23 Thread dbmail beckspaced.com
hello, i recently installed the new release dbmail 1.2.1 ! since then from time to time a pop3d or an imapd seems to hang and needs 99% of the CPU ! this is really bad ;-( is there any patch or something available that tells me how to fix this issue ?!? any help would be really appreciated

[Dbmail] Postgresql connect error

2004-01-07 Thread flung+dbmail
I get the following error when I try to use dbmail-smtp: dbmail/smtp[28737]: dbconnect(): PQconnectdb failed: FATAL: no PostgreSQL username specified in startup packet dbmail/smtp[28737]: main(): database connection failed I try sending the email as user dbmail. Postgresql is working, as is

  1   2   >