RE: [Dbmail] exim recipent verify

2004-10-21 Thread Bryan Ballard
Here is what I was able to come up with to solve the issue In the exim acl -> acl_check_rcpt: add these entries. Works great for wildcard domains and standard users. accept condition = ${lookup pgsql{SELECT count(alias) \ FROM aliases WHERE \ alias = '${quote_pg

[Dbmail] Webmail Patch

2004-10-21 Thread John Hansen
Hi, Now that 2.0.0 has been released, here is the revised patch for those using dbmail for webmail solutions. By adding two columns to the users table: webenabled, and popenabled, both boolean fields, you can control access to the mailbox. webenabled = false: no access to the mailbox at all. web

Re: [Dbmail] Webmail Patch

2004-10-21 Thread April Lorenzen
Hi John, I downloaded dbmail webmail and it seemed to be mysql specific. Has someone done a version for pg? Sorry to sound stupid but my background is CF so it was not immediately clear to me how to edit the php to work with pg. Thank you, - April Lorenzen > Hi, > > Now that 2.0.0 has been rele

Re: [Dbmail] Webmail Patch

2004-10-21 Thread John Hansen
> I downloaded dbmail webmail and it seemed to be mysql specific. Has > someone done a version for pg? Sorry to sound stupid but my background is > CF so it was not immediately clear to me how to edit the php to work with > pg. This was actually developed for PostgreSQL, what made you think otherw

Re: [Dbmail] Webmail Patch

2004-10-21 Thread April Lorenzen
from index.php: list.php01006440513307455607517011263 0ustar rootroot> I downloaded dbmail webmail and it seemed to be mysql specific. Has >> someone done a version for pg? Sorry to sound stupid but my background >> is >> CF so it was not immediately clear to me how to edit th

Re: [Dbmail] Webmail Patch

2004-10-21 Thread John Hansen
> list.php01006440513307455607517011263 0ustar rootroot session_start(); > mysql_connect("localhost", "dbmail", "DBmail"); > $query = "SELECT a.messageidnr as messageidnr, a.messageblk as > messageblk, b.messagesize as messagesize, c.maxmail_size FROM > messageblk a, me

[Dbmail] Webmail Patch #2

2004-10-21 Thread John Hansen
Hi again,... I seem to have forgotten to actually attach the patch, so here it is. ... John diff -ruN dbmail-2.0.0.orig/auth/authldap.c dbmail-2.0.0/auth/authldap.c --- dbmail-2.0.0.orig/auth/authldap.c 2004-08-18 19:48:23.0 +1000 +++ dbmail-2.0.0/auth/authldap.c 2004-10-21 10:30:29.

[Dbmail] In search of documentation

2004-10-21 Thread Jacques Dimanche
Hi there, New to DBmail, and was wondering if there is a place where I can find a complete set of documentation on all the various settings and administration usage? I've been searching through the main website, and the archives of this list and am unable to find any such thing. Thanks in ad

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread TWC|Mario Peschel
I tried to build packages for woody and I've got this error: dbmail-2.0.0 # dpkg-buildpackage -rfakeroot dpkg-buildpackage: source package is dbmail dpkg-buildpackage: source version is 2.0.0-1 dpkg-buildpackage: source maintainer is root <[EMAIL PROTECTED]> dpkg-buildpackage: host architecture i

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread Paul J Stevens
My guess: Your version of dpkg-source doesn't like the newlines at the end of the control file. I'll remove them in my package. You try the same. Please not however: building these packages for woody will be tricky. Woody doesn't have ucf and debconf will be broken. Also, glib version may be a

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread TWC|Mario Peschel
Yes it's working without the newlines. I already have backports of mysql-server, ucf and debconf. I'm using Woody's libc6: 2.2.5-11.5 It is working. I've running so much backports, Debian should release Sarge as Stable soon. :-) Mario Paul J Stevens wrote: My guess: Your version of dpkg-s

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread Paul J Stevens
TWC|Mario Peschel wrote: Yes it's working without the newlines. I already have backports of mysql-server, ucf and debconf. I'm using Woody's libc6: 2.2.5-11.5 It is working. Great. I've running so much backports, Debian should release Sarge as Stable soon. :-) Sarge/testing is bound

[Dbmail] DBMail 2.0 final

2004-10-21 Thread John Hansen
Weren't there going to be a cleanup tool to get rid of old messages no longer linked from any mailbox? I did some housekeeping, and still have 300.000+ messageblks, tho only 350 messages. Also,... Has anyone written a dbmail2mbox tool? Kind Regards, John

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread TWC|Mario Peschel
Yeah, In the meantime I have to many Backports and I already have problems with some of them. I'm upgrading my Woody to Sarge right now. ;-) Btw. on my machine it wasn't possible to install the dbmail 2.0 debian package when /etc/dbmail does not exist. May it be a bug? Mario Paul J Stevens w

Re: [Dbmail] DBMail 2.0 final

2004-10-21 Thread Doug Stanley
This worked for me! cat $USER.mbx | formail -e -f -s /opt/dbmail2/sbin/dbmail-smtp -u $USER Course you need to install formail. Doug p.s. those are the flags that I used to properly parse whatever weirdo format mailboxes SLmail uses. I beleive their mbx...You might need different flags...I'd s

RE: [Dbmail] DBMail 2.0 final

2004-10-21 Thread John Hansen
Heh, other way around Create mbox files from a dbmail account... ... John > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Doug Stanley > Sent: Thursday, October 21, 2004 11:11 PM > To: DBMail mailinglist > Subject: Re: [Dbmail] DBMail 2.0 fina

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread Paul J Stevens
TWC|Mario Peschel wrote: Btw. on my machine it wasn't possible to install the dbmail 2.0 debian package when /etc/dbmail does not exist. May it be a bug? I fixed this yesterday. When did you pick up the source files? If you build your own debs you can check the rules file for ... dh_install

Re: [Dbmail] DBMail 2.0 final

2004-10-21 Thread Paul J Stevens
John, orphaned messageblks is exactly the sort of stuff dbmail-util is supposed to look for. if dbmail-util -r doesn't clean out those blks, we have a bug. John Hansen wrote: Weren't there going to be a cleanup tool to get rid of old messages no longer linked from any mailbox? I did some

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread TWC|Mario Peschel
I fixed this yesterday. When did you pick up the source files? Today. I just downloaded the source deb again and the rule file contains only: "dh_installdirs -a" If you build your own debs you can check the rules file for ... dh_installdirs -A etc/debian var/run/dbmail ... which takes car

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread Paul J Stevens
bummer, I forgot to upload 2.0.0. Fixed now. TWC|Mario Peschel wrote: I fixed this yesterday. When did you pick up the source files? Today. I just downloaded the source deb again and the rule file contains only: "dh_installdirs -a" If you build your own debs you can check the rules file

Re: [Dbmail] Problems with DBMail 2.0 final

2004-10-21 Thread TWC|Mario Peschel
Paul J Stevens wrote: bummer, I forgot to upload 2.0.0. Fixed now. I've got now! Thanks! Mario

Re: [Dbmail] DBMail 2.0 final

2004-10-21 Thread Doug Stanley
oops...sorry...that's just me replying before my brain fully parsed your email :) Doug John Hansen wrote: Heh, other way around Create mbox files from a dbmail account... John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Stanley

RE: [Dbmail] Webmail Patch

2004-10-21 Thread Jesse Norell
> Useful for temporarily disabling a mailbox, so that mail is still > delivered to it, but the user has no access to it. Just a note, this reminds me of a discussion on #dbmail about 2 years back over exactly this issue - there was an ISP who prevented a user from downloading their mail while

RE: [Dbmail] DBMail 2.0 final

2004-10-21 Thread John Hansen
> John, > > orphaned messageblks is exactly the sort of stuff dbmail-util > is supposed to look for. > > if dbmail-util -r doesn't clean out those blks, we have a bug. > It did not... :( Note however, that all these orphaned messages are from deleted mailboxes. ... john

RE: [Dbmail] Webmail Patch

2004-10-21 Thread John Hansen
> > > Useful for temporarily disabling a mailbox, so that mail is still > > delivered to it, but the user has no access to it. > > Just a note, this reminds me of a discussion on #dbmail > about 2 years back over exactly this issue - there was an ISP > who prevented a user from downloading t

[Dbmail] running as non-root?

2004-10-21 Thread Mikhail Ramendik
Hello, I am new to DbMail. I intend to use it as a local storage system for my mail, as I have large folders (tens of thousands of messages). As it's local storage only, I will use a non-standard port above 1024. So I don't need to run dbmail-imapd as root. I have set the EFFECTIVE_USER and EFFE

[Dbmail] sysV init script ?

2004-10-21 Thread Mikhail Ramendik
Hello, Is a SysV script for DbMail available somewhere? I understand it's trivial to write, but I would not want to repeat somebody else's work :) Yours, Mikhail Ramendik

Re: [Dbmail] sysV init script ?

2004-10-21 Thread Micah
I just added the ones I used to the Wiki.. http://www.dbmail.org/dokuwiki/doku.php?id=sysv -Micah On Thursday 21 October 2004 01:31 pm, Mikhail Ramendik wrote: > Hello, > > Is a SysV script for DbMail available somewhere? > > I understand it's trivial to write, but I would not want to repeat

Re: [Dbmail] Question on the max mailboxsize setting

2004-10-21 Thread Micah
I think this type of thing is addressed with LMTP, right? On Wednesday 20 October 2004 10:11 am, Jacques Dimanche Test wrote: > After setting up the dbmail to work with sendmail, I can receive email > messages just fine in pop3 and imap. Playing around with the user > settings, I wanted to cha

[Dbmail] Strange problem with mailbox2dbmail

2004-10-21 Thread Mikhail Ramendik
Hello, I tried to convert a BIG mbox into dbmail with mailbox2dbmail. It has failed with a "recursion depth exceeded" message. I have looked at the code - and this, in itself, should be expected. The strange part is: it has processed some hundreds of messages before failing. But I do not see tho

[Dbmail] Update: Strange problem with mailbox2dbmail

2004-10-21 Thread Mikhail Ramendik
I wrote: > The strange part is: it has processed some hundreds of messages before > failing. But I do not see those messages in dbmail's imap folder! The > folder itself got created but is empty. I have created a small test mbox, which was processed with no failure message. And again, the folder

[Dbmail] Sorry: Strange problem with mailbox2dbmail

2004-10-21 Thread Mikhail Ramendik
I wrote: > > The strange part is: it has processed some hundreds of messages before > > failing. But I do not see those messages in dbmail's imap folder! The > > folder itself got created but is empty. Strike all that. It was a Sylpheed glitch. Perhaps there are some SQL queries to check mail pr

Re: [Dbmail] Strange problem with mailbox2dbmail

2004-10-21 Thread Dan Stilts
Mikhail; I had the same error as you ("recursion depth exceeded") so I added this to the mailbox2dbmail script: sys.setrecursionlimit(6000) That I had added right under this line: version = "%s 1.2" %(sys.argv[0],) Hope this helps some...took me quite some time to figure that out. -Dan Mi

Re: [Dbmail] Strange problem with mailbox2dbmail

2004-10-21 Thread Mikhail Ramendik
Dan Stilts wrote: > I had the same error as you ("recursion depth exceeded") so I added this > to the mailbox2dbmail script: > > sys.setrecursionlimit(6000) Won't help because some of my mailboxes have over 100,000 messages. But never mind; I'll just change the script to be non-recursive. Your