[Dbmail] strange lmtp error

2005-05-09 Thread A
Hello, I am using dbmail version 2.0.4. I have a problem: most of the incoming e-mail failes with the same error, but some of them arrive. Here I send a sample from the log. May 9 12:42:21 mail dbmail/lmtpd[16790]: dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_messageblks

Re: [Dbmail] strange lmtp error

2005-05-09 Thread A
Sorry, I use FC3 and PG8.0. Aron A wrote: I am using dbmail version 2.0.4.

Re: [Dbmail] strange lmtp error

2005-05-10 Thread A
Hi, The e-mails we get frequently/ /contains special characters like these: éáőúóűí. Will they work properly with SQL_ASCII? Aron Paul J Stevens wrote: I think you have to change the encoding on the dbmail database. Try SQL_ASCII instead.

[Dbmail] DBMA+ACL problem

2005-07-19 Thread A
Hello all, I'am using latest dbmail 2.0(2005.07.18. snapshot) and DBMA 2.3.5 and postgresql 8.0. I need to use shared folders, but when I try to set up a shared folder in DBMAs ACL menu I get this error: ERROR: current transaction is aborted, commands ignored until end of transaction

Re: [Dbmail] DBMA+ACL problem

2005-07-19 Thread A
M. J. [Mike] O'Brien wrote: Hi Aron: Hi! 2) The error code does not match the version. (?) Please download the latest version, try again, and report any problems at http://dbma.ca/ I've downloaded DBMA today again, this version works great! There is only one thing: I followed exactly the

Re: [Dbmail] DBMA+ACL problem

2005-07-20 Thread A
M. J. [Mike] O'Brien wrote: Hi Aron: Thunderbird works like a charm as a very IMAP_ACL-friendly MUA. Hello, In DBMA you need to give your intended users permission on #Public/folder, after you have created that folder, to allow them to at least lookup, read, see, write, insert and

Re: [Dbmail] DBMA+ACL problem

2005-07-22 Thread A
Hello Mike! user_id=(specified)dbmail_users.user_idnr, mailbox_id=(specified)dbmail_mailboxes.mailbox_idnr, lookup_flag=1, read_flag=1, seen_flag=1, write_flag=1, insert_flag=1, post_flag=1, create_flag=1, delete_flag=0, administer_flag=0 If there is a correct entry in dbmail_acl matching

[Dbmail] DBMail: undeliverable email is returned to body TO: field instead of envelope field

2007-08-03 Thread A rno
Hello, I'm using DBMail for more than a year right now and am very happy with it, but recently I've noticed that undeliverable email isn't returned to the 'envelope sender' but instead to the TO: field in the body. To me this is not desirable because it offers possibil

[Dbmail] Re: DBmail Digest, Vol 42, Issue 8

2007-08-04 Thread A rno
> > To subscribe or unsubscribe via the World Wide Web, > visit > https://mailman.fastxs.nl/mailman/listinfo/dbmail > or, via email, send a message with subject or body > 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at >

[Dbmail] undeliverable email is returned to body TO: field instead of envelope sender

2007-08-05 Thread A rno
Hi, I'm using dbmail 2.2.5. Arno Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webho

[Dbmail] undeliverable email is returned to body TO: field instead of envelope sender (A rno)

2007-08-07 Thread A rno
Kind regards, Arno > Ok, I'll read through the code a bit to see where > this might be coming > from. Also, could you provide level 5 logs for a > message that triggers > this behavior? Are you using dbmail-lmtpd or >

[Dbmail] New on dbmail

2002-12-08 Thread A C Mirand
Hi EveryOne, I just Download the dbmail, compil, follow the install instructions.. but.. I can't read the emails by imap or pop3d, the messages are stored in the db, 'cause i can check the headers on my mysql. I create a test user with this command line: dbmail-adduser a test clean

Re: [Dbmail] New on dbmail

2002-12-08 Thread A C Mirand
, A C Mirand wrote: Where I can Start checking? You need to start dbmail-pop3d (and dbmail-imapd) manually. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.B.N. 75

Re: [Dbmail] New on dbmail

2002-12-08 Thread A C Mirand
111/tcpopensunrpc 143/tcpopenimap2 - Original Message - From: Philip Warner To: dbmail@dbmail.org ; dbmail@dbmail.org Sent: Sunday, December 08, 2002 2:37 AM Subject: Re: [Dbmail] New on dbmail At 02:33 AM 8/12/2002 -0300, A C Mirand wrote:

[Dbmail] dbmail make failed

2002-12-08 Thread David A. Bandel
;ve chosen the wrong files). Running Debian 3.0 unstable Hints, FMs to read, whatever, appreciated. TIA, David A. Bandel - -- Focus on the dream, not the competition. -- Nemesis Racing Team motto -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE

Re: [Dbmail] dbmail make failed

2002-12-08 Thread David A. Bandel
note the -lkrb5 above. Thanx, but, that's not it. And krb5.h is in /usr/include, not a subdir. Any other ideas? David A. Bandel -- Focus on the dream, not the competition. -- Nemesis Racing Team motto pgpejCbEF7JQL.pgp Description: PGP signature

Re: [Dbmail] New on dbmail

2002-12-08 Thread A C Mirand
my user.. If I connect trought imapd, i open the folers, but are without messages. I re-install, and the same problem. If I turn the transport of my postfix to local: the system run ok, but changing back to dbmail, I don't see any email. Is possible a mistake I made when I build

Re: [Dbmail] New on dbmail

2002-12-10 Thread A C Mirand
to make an imap login. To connect to the inbox, do > a select inbox > > Could you try this and mail any errors (log output) you encounter? Well, I didn't found any error, I re-check postfix, transport and dbmail* permissions.. At least I know dbmail is working, because postfix recives th

[Dbmail] make problems

2002-12-11 Thread David A. Bandel
ils w/ references to defines found in this file). Anyone else managed to build on Debian testing and/or seen/resolved these problems? Thanx, David A. Bandel - -- Focus on the dream, not the competition. -- Nemesis Racing Team motto -BEGIN PGP SIGNATURE- Version: Gnu

Re: [Dbmail] make problems

2002-12-11 Thread David A. Bandel
krb5_cc_close (krb5_context context, krb5_ccache cache); #define krb5_cc_close(context, cache) #krb5_x ((cache)->ops->close,(context, cache)) I've even tried adding: #include to some of the .c files, but it doesn't seem to help (or I've chose

Re: [Dbmail] make problems - SOLVED

2002-12-11 Thread David A. Bandel
k to point at the correct library and -- well, success (duh). Why do i feel like such a dummy when I make so obvious a boo-boo? Not like I haven't seen this before. Public floggin is in order. Thanx much for the prod, David A. Bandel - -- Focus on the dream, not the competition.

Re: [Dbmail] New on dbmail

2002-12-19 Thread A C Mirand
AM> At least I know dbmail is working, because postfix recives the email and AM> dbmail store-it, plus i can see the folders and see the sent-item with the AM> emails i try to send, and I can copy emails from my local folder and AM> dmbail-smtp store those emails, create folders, etc. The error is

Re: [Dbmail] SMTP problem - Qmail+DBMail

2003-01-19 Thread A C Mirand
On Sun, 2003-01-19 at 18:04, Jan Pavlík wrote: > Hi, Hi! > Vpopmail. I reinstall clean Qmail and try to install DBMail. > Compile and Install work fine. IMAP and POP3 great, but SMTP > doesn't work :( I use small howto from INSTALL. Do you read about the problem in dbmail.c ? You need tu repla

[Dbmail] Resume of errors..

2003-01-27 Thread A C Mirand
Hi There, Anyone had a list of the problems with dbmail 1.0? There are at least. The problem with dbmail.conf - can be solved editing .c and put /etc/*.conf The problem with postgres, the size sudden start growing When move a mail using imap dbmail change the date, When I move with outlook

[Dbmail] dbmail/smtp "could not create mailbox"

2004-02-01 Thread A James Lewis
Hi, It's a while since I've used dbmail, but I'm building a new system and thought I'd use the change to go back to dbmail... 2.0rc1 is available, so I'm gonna try to go with that rather than install somthing that is about to be obsolited... Weird problems seem to p

[Dbmail] LMTP

2004-02-02 Thread A James Lewis
OK, I may be way off the mark, but LMTP seems to be a way to bypass dbmail-smtp and deliver stuff into DBMAIL from an MTA (Postfix). I've tried this, and the conversation between postfix and dbmail-lmtp didn't look encouraging! I get a "503 Message not received 0 FAIL." in

[Dbmail] 2.0rc1 dbmail-imap4d segfaults

2004-02-03 Thread A James Lewis
Well, Thanks to some previous posts about the include of time.h, and many thanks to Christian for the pointer about additions to the postgres schema, I now have a working postfix/dbmail implementation... Yay! However, although I can send and retreve mail using pop3, imap4 is playing hard to get

[Dbmail] 2.0rc1 dbmail-imap4d segfaults

2004-02-03 Thread A James Lewis
mailbox_idnr = '6'] Feb 3 19:51:22 dozer dbmail/imap4d[807]: ChildSighandler(): got signal [11] Ilja Booij wrote: This is caused by a nasty bug I fixed yesterday. You can get the fixed=20 version via CVS (go to the download page of www.dbmail.org for info on=20 how to get dbmail via CVS) or

[Dbmail] How to Filter in dbmail

2005-05-18 Thread Niblett, David A
I was reading a post on DBMail SPAM filtering. Sorry if this doesn't end up in the thread. Currently I have a patch that I wrote for DBMail-2.0.1 and I just updated for DBMail-2.0.4. It's in the bug list for DBMail. I added the feature to the lmtpd server to accept [EMAIL PROTEC

[Dbmail] DbMail in a ISP Cluster

2005-05-18 Thread Niblett, David A
What are you all using to cluster PostgreSQL? I looked at the master/slave replication that comes with Postgres. It seems fine if you want to replicate the data, but how do you get dbmail to switch databases when there is a failure? I'm currently using drbd to replicate the disk block d

RE: [Dbmail] DbMail in a ISP Cluster

2005-05-18 Thread Niblett, David A
Well I need psql because I have a large need of triggers, stored proceedures and views. At the time I implemented most all of that stuff was "coming soon" in mysql. I can work around replication with other devices, but I can't work around triggers. Thanks for the help, I

RE: [Dbmail] DbMail in a ISP Cluster

2005-05-18 Thread Niblett, David A
Don't really have a "how to", but I do have a sort of, grand scheme paper on how I did it. Latency on failover is about 30-45s. Machines are connected via a x-over gigE connection that is just used for replication of DRBD (though DRBD can only currently sync at 700Mb I believe).

RE: [Dbmail] How to Filter in dbmail

2005-05-19 Thread Niblett, David A
Good catch, I didn't think about mysql. The problem is that if my SPAM box is SPAM, but something is sent to it as [EMAIL PROTECTED] since the case doesn't match a new box may be created (provided it's in the allowed create list) or the email will be rejected. Like won't cut

RE: [Dbmail] How to Filter in dbmail

2005-05-19 Thread Niblett, David A
I didn't know about the db_findmailbox_regex, that would be a better way to go. I'll have to take a look at how that works. Yup, absolutely correct on the size of the folder, I'll fix that in my patch for sure. You must forgive me, last time I pounded out C code was many moons a

[Dbmail] Question about Virtual Domains

2005-05-23 Thread Niblett, David A
I really hope that I'm missing something here. How does DBMail deal with virtual domains? User: [EMAIL PROTECTED] User: [EMAIL PROTECTED] Right now, unfortunately, most all my users would log in as 'xyz' with POP server of 'mail.domain1.com'. Currently I have to run

RE: [Dbmail] Question about Virtual Domains

2005-05-24 Thread Niblett, David A
I understand the client_idnr field, but I don't understand how IMAP will determine when user 'xyz' from domain1 logs in and user 'xyz' from domain2 logs in. Right now I run a separate IP per domain, and unless I force all my users to connect with [EMAIL PROTECTED] (which

RE: [Dbmail] Question about Virtual Domains

2005-05-25 Thread Niblett, David A
nd "append" any domain that it needs to, to the username. Maybe I'll look at making a patch to the IMAP server such that you can define client_idnr to IP address. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gaines

RE: [Dbmail] Question about Virtual Domains

2005-05-27 Thread Niblett, David A
Well you know what they say about necessity being the mother of invention... I pounded out a patch that allows you to do IP virtual based domain hosting for dbmail v2.0.4. Currently the patch only supports IMAP, but I expect by the end of the day I'll have POP supported as well. The prem

RE: [Dbmail] Lookup failure

2005-05-27 Thread Niblett, David A
ng other than if you want your logs to show the hostname connecting rather than the IP address. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/ -Original Message-

[Dbmail] IP Based Virtual Hosting

2005-05-27 Thread Niblett, David A
: http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=209 -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/

[Dbmail] Case sensative usernames

2005-05-27 Thread Niblett, David A
not found any way to make the database case insensitive if that's even possible. I'm only asking, because I'm planning on adding to my virtual domains patch where I force the username to lowercase. I fully expect the password to be case sensative. -- David A. Niblett

RE: [Dbmail] IP Based Virtual Hosting

2005-05-27 Thread Niblett, David A
Thanks Paul. I have one last item that I plan on adding which is forcing the username to lowercase. Most all other POP/IMAP servers I've used don't care about case on the username. I sent a separate note to the mailing list about that, but was just curious if there was some fundamen

[Dbmail] Restricting Access

2005-06-03 Thread Niblett, David A
I have an interesting situation and I wonder if any one else has something like this and how you deal with it. Basically we want to do a free Webmail service that has ad's on it. For these users I want to only allow them to use the webmail interface to view their email (ie. no POP or IMAP)

RE: [Dbmail] Restricting Access

2005-06-03 Thread Niblett, David A
The authentication is from the dbmail_users table. Currently I've added a column to that and modified that authentication portion of imapcommands.c and pop3.c. How do you go about using dbmail with pam? I didn't even know that was an option. As for the webmail, I know what IP that

RE: [Dbmail] Restricting Access

2005-06-03 Thread Niblett, David A
Oh for the love of God. Thanks Paul. I fixed my own problem WITH a patch that *I* wrote, and I didn't even put it together. I have not heard back from you about that patch. Is there anything you would like me to fix? Did I break anything? -- David -Original Message- From: P

RE: [Dbmail] Restricting Access

2005-06-06 Thread Niblett, David A
just added the header to misc.h and used it. That's where I stole the idea from. - Yup, sorry, I don't do LDAP. I'd expect it to be pretty easy to add in there, but I have no way to test, so I'd rather not release a patch with my name on it that doesn't work. You are corr

RE: [Dbmail] Restricting Access

2005-06-06 Thread Niblett, David A
each. Each IP on a machine will be for domain1.com, second for domain2.com, etc. So it's nice using DBMail so that just in one place do I have to define the IP <-> suffix mapping. At this point like I said, I'm only working with 2.0.4, so I think you have it under control for 2.

RE: [Dbmail] Restricting Access

2005-06-06 Thread Niblett, David A
h the domains patch, then the folders patch, and you shouldn't get any errors, just warnings about fuzz. Or you can contact me for a master patch that I have for our company. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 G

RE: [Dbmail] send mail to alias -> Real Account -> forward

2005-06-10 Thread Niblett, David A
l] send mail to alias -> Real Account -> forward Or you could create a "master" alias. This is the approach I have taken. Now all my aliases for my various email addresses all point to another alias, which I can then send to as many different things as I want. Matt Salerno

RE: [Dbmail] send mail to alias -> Real Account -> forward

2005-06-14 Thread Niblett, David A
Paul, I have a similar situation like Matt. I have users that may have 10-15 aliases, and then they forward the non-alias account to another location. It almost makes me wonder if I shouldn't use the user_idnr in the deliver_to field and make policy to always use names. Would you e

RE: [Dbmail] send mail to alias -> Real Account -> forward

2005-06-14 Thread Niblett, David A
send the message to the forward location. If the user_idnr is used in the deliver_to then the message is immediately stored in the database making it much more efficient. The only problem I have with the dbmail_aliases table is that there is no DB reference to a user_idnr. I added a column (c

RE: [Dbmail] send mail to alias -> Real Account -> forward

2005-06-14 Thread Niblett, David A
That's one way of doing it yes. I do it slightly different. All my userid's in dbmail_users are fully qualified ([EMAIL PROTECTED]) Aliases in dbmail_aliases are only if a user requests an alias, like ([EMAIL PROTECTED] -> niblettda's user_idnr). Then a forward for the us

RE: [Dbmail] send mail to alias -> Real Account -> forward

2005-06-15 Thread Niblett, David A
I stand 100% corrected. That is a much better way. I was errored in my testing. Of course now I'm going to ask, what happens if you set up a circular alias (yes I know you should get what you deserve, but)? I've had a user do this to me before, it wasn't pleasant. [EMAIL PROTE

RE: [Dbmail] send mail to alias -> Real Account -> forward

2005-06-15 Thread Niblett, David A
Ok, I just confirmed that the below situation is really, really bad. Technically I'm not sure this is a bug since it's doing exactly what it's supposed to do, but it could cause some serious grief. Seems like there should be some loop protection in the routine. -- D

RE: [Dbmail] send mail to alias -> Real Account -> forward

2005-06-15 Thread Niblett, David A
Absolutely, I'll let you know. I was looking at the code and it seemed to me like there was something intended for lop detection, just never completed. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Reg

RE: [Dbmail] send mail to alias -> Real Account -> forward

2005-06-15 Thread Niblett, David A
ugh the loop on the second name. Eventually it did forward the message to [EMAIL PROTECTED], but it was really strange how it got around to it. Regardless, thanks for the help. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 G

[Dbmail] Quota Capabilites

2005-06-30 Thread Niblett, David A
Just a curious question here. Why in the IMAP CAPABILITY #define isn't QUOTA listed when DBMail does support this? -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/

RE: [Dbmail] Quota Capabilites

2005-07-01 Thread Niblett, David A
Well that makes sense. I'll just add this for people googling the list. I run SquirrelMail and I was trying to use the Quota plugin. It wouldn't work, and it took me a bit to find out that it checks the CAPABILITY line for QUOTA and if it's not there it doesn't do anything.

[Dbmail] TIME_WAIT processes

2005-07-01 Thread Niblett, David A
I've noticed that when I start dbmail-X there always seem to be a large number of TIME_WAIT connections reported by netstat. All of these connections are going to my postgres database. For example, I only have IMAP running, with the following: NCHILDREN=5 MAXCHILDREN=20 MINSPARECHILD

RE: [Dbmail] smtp authentication

2005-07-01 Thread Niblett, David A
lookup sql for sasl you should find all the options you need. You get to craft the select statement which allows you to use any table you like. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web

RE: [Dbmail] TIME_WAIT processes

2005-07-01 Thread Niblett, David A
I thought that too, but the TIME_WAIT ones are not persistent. They eventually die off after ~4m which I think is the standard, but new ones are constantly made. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville

RE: [Dbmail] TIME_WAIT processes

2005-07-01 Thread Niblett, David A
I'm setting up a new machine, the only service running on it is dbmail-imapd. When I start it, I get all the TIME_WAIT connections, when I stop it, they all go away. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gaines

RE: [Dbmail] smtp authentication

2005-07-01 Thread Niblett, David A
: sql_select: SELECT passwd FROM dbmail_users WHERE userid = '[EMAIL PROTECTED]' -- Your passwords are most likely going to have to be in plain text as sasl is going to encode it based on what the user selects. -- David A. Niblett | email: [EMAIL PROTECTE

[Dbmail] Database backup

2005-07-06 Thread Niblett, David A
Just curious out there how others do their database maintenance and backups. If I understand the docs correctly, it would be best to run dbmail-util -ar and then a dump of the database. I'm currently using 'pg_dump -Ft dbmail | bzip2 -9 > ' Anyone have any other suggestions o

[Dbmail] HELP - Lots of unconnected messages

2005-07-07 Thread Niblett, David A
. Is this normal? I found this because all of a sudden it seemed that I had a lot of user calls with no username, no date messages in their boxes. I'm thinking these two items are related. I'd sure like to figure out how to prevent them from even getting into the system rather than const

[Dbmail] HELP - POP/IMAP/LMTP keep dying

2005-07-07 Thread Niblett, David A
I'm sending this to keep it in a separate thread. The other problem I have with dbmail-svn-1816 seems to be that POP/IMAP/LMTP seem to die on a regular basis. I've turned on full logging, and I can't seem to figure out what/where there are any problems. It seems like at differ

[Dbmail] Forward and retain the message.

2005-07-10 Thread Niblett, David A
I have an issue that some users of mine used to do an option of forwarding their Email, and also retaining a copy in their mailbox. I'm wondering how to accomplish this in dbmail. Maybe it's really simple, but it's eluding me.

[Dbmail] DBMail + PostgreSQL Problem

2005-07-15 Thread Niblett, David A
Hello all, I'm in serious need of help here. I'm about at my whits end of dealing with dbmail and getting it to work. I've had a couple of database crashes now and found things like if I run dbmail-util my DB process load skyrockets and the server becomes unusable. I'm h

RE: [Dbmail] DBMail + PostgreSQL Problem

2005-07-16 Thread Niblett, David A
After speaking to someone who knows a lot more about Postgres than I, you all are very right. I didn't understand the sort memory option and will be lowering it. There seems to be some concern with the 1) DRBD which I was using to network replicate the database. 2) Running 7.4.7 3) Transac

RE: [Dbmail] DBMail + PostgreSQL Problem

2005-07-16 Thread Niblett, David A
Mike, I'm basically doing most all of what you suggest. I'm going to start over with a new build, go to 8.0.3 on postgres and probably 2.0.4-svn. We did find a duplex mis-match between the dbmail server and the database. So that could be part of the issue. I don't think the Xeo

RE: [Dbmail] DBmail IMAP issues

2005-07-19 Thread Niblett, David A
Abdullah, Check the users account for a zero size message. We found that if we shutdown LMTP without shutting down postfix first we would get messageblk entries with a completely empty (not null) messageblk field. That usually hosed up squirrelmail. Mozilla would show an empty message, and

RE: [Dbmail] RE: DBmail IMAP issues

2005-07-20 Thread Niblett, David A
Sorry, I didn't realize that they were two different errors. I have seen the other one seperately before, and if I recall correctly I think we found that the application that we wrote to add users to dbmail was creating the INBOX entry in dbmail_mailboxes with a permission of 1 and not 2.

RE: [Dbmail] DBmail IMAP issues

2005-07-20 Thread Niblett, David A
was written to use persistent DB connections for things like preferences and such. That's a killer to watch it constantly checking the preferences each time. At the same time, I certainly understand not caching DB connections because that adds a whole layer of overhead.

[Dbmail] DBMail+PostgreSQL+Trasnsations

2005-07-20 Thread Niblett, David A
I'm a bit confused right now. I thought for sure that LMTP wasn't using a transaction for PostgreSQL, but the logs don't lie. My issue is that when I stop dbmail-lmtpd without stopping postfix first, and there is an LMTP message in the pipe, I end up with an entry in dbmail_messa

RE: [Dbmail] server-side sorting bug

2005-07-25 Thread Niblett, David A
Are you all referring to the "us-ascii" portion that is commented out in the imaputil.c file? I'm having a strange issue with SquirrelMail and I'm not sure it's related. If a user has say 2 pages of Email, the first page displays correctly, but then if they go to pag

RE: [Dbmail] server-side sorting bug

2005-07-26 Thread Niblett, David A
After some major digging into the SM code I found the problem. Our support desk had asked me to allow them to see the size of the Emails in SM and sort by them. Putting in the size was not an issue, however, I added a sort patch outlined on one of the SM mailing lists. Oddly, that is what broke

[Dbmail] Build 2.0.4 glibc double free error

2005-07-28 Thread Niblett, David A
the SVN version, but so far I've been having good luck with the standard 2.0.4 release. I'm running Gentoo, latest patches and kernel. The server doesn't do anything other than dbmail and postfix. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator

[Dbmail] Folders Patch v0.5

2005-08-02 Thread Niblett, David A
I know others had been looking for a way to have direct folder delivery into DBMail via LMTP. I've just updated the patch that I wrote to fix a couple of problems and also added the feature that if a folder is created then the user is also subscribed to the folder. You can download the v0

RE: [Dbmail] dbmail-imapd processes hang around forever

2005-08-09 Thread Niblett, David A
ference is that it should be a quick open -> login -> retrieve -> logout -> close. As Abdullah says in a later message, you could use an imap proxy that will make the sessions persistent, but I think that you might have too many open connections unless you tune your DB to take it. I'

RE: [Dbmail] dbmail-imapd processes hang around forever

2005-08-09 Thread Niblett, David A
around forever It's nice to hear from Abdullah as a person with 162K users. I am pretty sure that less than 1000, maybe less than 500 of ours log into webmail presently. The dbmail-imap processes hanging around has continued :( I set the imap timeout in dbmail.conf to 300 down from 4000.

[Dbmail] Latest release of dbmail-folders patch

2005-08-17 Thread Niblett, David A
uot; Paul will find something else that I missed. :) -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/

[Dbmail] dbmail virtual IP domain hosting in v2.0.5

2005-08-17 Thread Niblett, David A
The bug is closed that I originally opened that provides IP based virtual domain hosting for the dbmail 2.0 tree. I have a new version of the patch that I believe works much better than before. Fixed some minor cases of possibly freeing some memory that was not allocated, and move the force

RE: [Dbmail] Inline Spam Filter ...

2005-08-21 Thread Niblett, David A
) -> amavis -> MTA (tcp/26) -> dbmail-lmtp delivery. This way if lmtpd has a problem, the MTA can queue up delivery. Not quite sure how amavis would handle that. I wrote a patch to dbmail that allows the use of folders. We use amavisd-new to do the filtering, virus checking, etc. Then amavis

RE: [Dbmail] Bind ip

2005-09-16 Thread Niblett, David A
Can't do that currently. I wanted it too for a patch I wrote, but in my understanding of the code you can't. -- David -Original Message- From: Alan Glait To: dbmail@dbmail.org Sent: 9/16/2005 9:50 AM Subject: [Dbmail] Bind ip Hi ! I want BINDIP to have 2 values ... How c

[Dbmail] 2.0.6+ DB Keepalive

2005-09-19 Thread Niblett, David A
Paul, I believe you mentioned that in 2.0.6 and above, dbmail now opens a new connection to the database every second to make sure that it's alive rather than using the pgstatus function. (for PostgreSQL) I was wondering what the reason for that change is? I've noticed that now if I

RE: [Dbmail] 2.0.6+ DB Keepalive

2005-09-19 Thread Niblett, David A
Ok, so now it's using Pgstatus, interesting. Any thoughts on why I see so many TIME_WAIT connections to my database? I have usually around 150-170 at all times. My timeout is the Linux default of 4 min. Am I just the lucky one, or do others see this? I'm using 2.0.6 on a Linux

[Dbmail] Size, vacuum, performance, etc

2005-11-17 Thread Niblett, David A
I'm hoping that someone on the list can help me sort out what I hope I'm doing wrong. Our group seems to be devoting a lot of time and heartache to running dbmail for our user base. Granted a lot seems to be database related. So if there is anyone on the list that is using dbmai

RE: [Dbmail] Size, vacuum, performance, etc

2005-11-17 Thread Niblett, David A
Very interesting, then I'll probe some more... Our database system is on a Dual 3GHz Hyperthreaded Compaq G3 (P4 Xeon) system with 1GB of RAM with Ultra320 drives configured in a SCSI RAID 0+1 (4 36G drives, 2 stripe sets, mirrored) I have set my shared memory space at 512M, I would like to

RE: [Dbmail] Size, vacuum, performance, etc

2005-11-17 Thread Niblett, David A
shared RAM. Am I crazy here? I set my shared_buffers to 4 which should be ~327M of shared memory available. Is this a mistake? I wanted to let PostgreSQL use all the RAM it could get it's hands on for performance. My max_fsm_pages is 20 and relations are 1. I'm guessing tha

RE: [Dbmail] Size, vacuum, performance, etc

2005-11-18 Thread Niblett, David A
Interesting, I guess I didn't understand the concept of what dbmail-util was for. I assumed you should run the -a (all) feature. So for the sake of an upcoming consolidation of all this information into hopefully a wiki or at least my own documentation... I've changed my dbmail-util s

RE: [Dbmail] 2 MTA 1 DB

2005-12-14 Thread Niblett, David A
Works just fine. I've got 4 MTA's running postfix all storing Email to 1 DB, and POP and IMAP running on all 4 servers as well. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities |

RE: [Dbmail] Mail filtering to IMAP folders

2005-12-29 Thread Niblett, David A
deliver to a specific mailbox. The other option is if you are using something like Amavis to filter Spam it can add the folder portion to the email address like [EMAIL PROTECTED] In this case I wrote a patch that will allow IMAP to deal with the folder portion and deliver it. You can find my patch at

RE: [Dbmail] Postfix & DBMail (Plus Reject messages)

2005-12-29 Thread Niblett, David A
That was all I needed to get everything to work and reject messages. I HIGHLY suggest you use a 550 to reject the Email. By using a 450 you are telling the other end that it's a soft error and to try again later. 550 tells the sender, it doesn't exist, and to not try again. By doing

RE: [Dbmail] Mail filtering to IMAP folders

2005-12-29 Thread Niblett, David A
Andrea, Actually there is a method like you mentioned already done by someone. He was using a table to hold the filtering rules. http://mailman.fastxs.net/pipermail/dbmail-dev/2003-April/002382.html Check this thread, it might be what you are looking for. My main goal was to have my Amavis add

RE: [Dbmail] dbmail-lmtpd

2006-01-09 Thread Niblett, David A
My ears were burning so I'm here to answer questions about my patch or add enhancements if you got 'em. I think sieve is the way to go in the future, but if you need it now, then I can help. This week I'm hoping to get my patch updated for the latest version of 2.0 since

RE: [Dbmail] Postfix & DBMail (Plus Reject messages)

2006-01-09 Thread Niblett, David A
= pgsql:/etc/postfix/pgsql-domains.cf virtual_mailbox_maps = pgsql:/etc/postfix/pgsql-users.cf virtual_maps = pgsql:/etc/postfix/pgsql-virtual.cf transport_maps = hash:/etc/postfix/transport transport_destination_recipient_limit = 1 I believe you can make the transport maps as a pgsql select to grab only

RE: [Dbmail] Postfix & DBMail (Plus Reject messages)

2006-01-09 Thread Niblett, David A
That is correct, I was trying to indicate that the code to provide a db:file method is the same as for virtual_domains as relay_domains per the documentation. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional

RE: [Dbmail] SPAM folder

2006-01-12 Thread Niblett, David A
You might want to look at my patch for DBMail. I added the feature of [EMAIL PROTECTED] You can use dspam to add the folder portion to the email address. http://dbmail.org/mantis/view.php?id=57 -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator

RE: [Dbmail] Postfix & DBMail (Plus Reject messages)

2006-01-18 Thread Niblett, David A
Here you go, first set are what I use in production with the relay_domains method. I should note that I wrote my own PlPgSQL function to check if a user is valid. I check the users table, then the alias table, plus I added a column that lists a user as "active" such that if they don&#

RE: [Dbmail] execute external program after mail insert

2006-03-13 Thread Niblett, David A
Christian, Are you using MySQL or PostgreSQL? I'm not positive of MySQL, but with Postgres you could set up a trigger on the dbmail_messages table to fire on insert. There is an option to execute an external program in postgres from a function. This way you would be guarenteed that you

  1   2   >