[Dbmail] INTO missing from INSERT statement?

2004-09-19 Thread April Lorenzen
at, 18 Sep 2004 19:44:06 PDT Date: Sat, 18 Sep 2004 19:44:06 -070 0 (PDT) From: April Lorenzen <[EMAIL PROTECTED]> Subject: test 20 To: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii ', '621', '329')] : [ERROR: syntax error at or nea

[Dbmail] delivering mail into subfolders

2004-09-20 Thread April Lorenzen
es (sounds dreadful) Thanks for any insight! - April Lorenzen

Re: [Dbmail] delivering mail into subfolders

2004-10-09 Thread April Lorenzen
elivers to the Bulk folder under the user the message was addressed to - or to a system-wide Bulk folder. I need it to go to the individual addressee bulk folder. > April Lorenzen wrote: >> Using dbmail-pgsql, yesterday's debian pkg :) >> >> Sendmail inserts and anti-spam

[Dbmail] procmail and dbmail-smtp

2004-10-15 Thread April Lorenzen
a sendmail issue than dbmail. If the above doesn't > help you > should get support from a sendmail user, which I am not anymore. > > > > > > April Lorenzen wrote: >> So far I haven't gotten procmail to deliver into dbmail - I get an error >> about >> >

RE: [Dbmail] procmail and dbmail-smtp

2004-10-15 Thread April Lorenzen
nt this out if you continue to > use > this script direcly as the LDA in sendmail) > $line = ; > > open(PIPE, "|/path-to-dbmail"); > while () { > print PIPE $_; > } > close PIPE; > > > > Regards, > Mark > > > -Original Message-

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

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

[Dbmail] sql query by mailbox_idnr

2004-11-26 Thread April Lorenzen
I am using postgres. Using pgadmin III, looking at the table "mailboxes" - I can see the very unique name of a mailbox I just imported 1000 messages into - and its mailbox_idnr is 37. My query must be wrong because I get no records returned: SELECT messageblk,dbmail_messageblks.physmessag

[Dbmail] getting headers for a specific mailbox_idnr

2004-11-26 Thread April Lorenzen
I am using postgres. Using pgadmin III, looking at the table "mailboxes" - I can see the very unique name of a mailbox I just imported 1000 messages into - and its mailbox_idnr is 37. My query must be wrong because I get no records returned: SELECT messageblk,dbmail_messageblks.physmessag

[Dbmail] mass add of users to dbmail with postgresql

2005-01-03 Thread April Lorenzen
I need to add about 800 users to dbmail and I have an MS Access mdb with user, domain and password. I am expecting to just do an SQL insert to dbmail_users table in postgresql and then do an SQL insert to dbmail_aliases table, using the user_idnr from dbmail_users as the deliver_to column in dbmai

[Dbmail] dbmail administrator strange user password encryption type

2005-01-07 Thread April Lorenzen
When I create a new user in the dbmail administrator with password type "plain", the password type in the database table comes out as "on" (no quotes). ? I have been manually fixing it in the table, or just using dbmail-users to create users. But now I have customers who want to manage th

[Dbmail] aliases not added to delivery list

2005-01-13 Thread April Lorenzen
rs in question all get mail fine if sent to directly. Jan 13 11:20:46 crunch-a dbmail/smtp[18997]: dsn.c, dsnuser_resolve: added user [EMAIL PROTECTED] id [1472] to delivery list Thank you, - April Lorenzen

Re: [Dbmail] aliases not added to delivery list

2005-01-13 Thread April Lorenzen
Thanks for the suggestion. I was unclear - they are by user_idnr at this time. For fun I will try spelling out the address. My concern was that they may be automatically converted to the user_idnr - or that it would be taken as an external deliver-to if not by user_idnr. But definitely somethin

[Dbmail] alias bug: if user exists, auth_check_user is skipped

2005-01-13 Thread April Lorenzen
version 2.03 debian jan 12th 2005 pkg as well as 2.02 debian pkg postgresql version did the same for me: Ok I have pin-pointed the issue to the extent trace=5 will show I DELETED the alias [EMAIL PROTECTED] deliver to user 460 - [EMAIL PROTECTED] But dbmail still delivers to that user - becaus

[Dbmail] please comment on Aarons proposed revision to alias - user - delivery logic

2005-01-14 Thread April Lorenzen
I believe your proposed method is wise as it preserves the most options for the admin with the least bother AFAICT. Please comment quick so they can do a fix :) and I can tell my customers when it might be working :) - April

Re: [Dbmail] deliver-to forwards howto..

2005-01-21 Thread April Lorenzen
dbmail for this to work. There is a recent bug which was fixed, but not all versions of the past had the bug. http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000159 - April Lorenzen Simon Buchanan wrote: Hi There, I need to setup a deliver-to forward... so that an email t

[Dbmail] dbmail-imapd processes hang around forever

2005-08-08 Thread April Lorenzen
0:00 \_ /usr/sbin/dbmail-imapd dbmail4364 0.0 0.2 6300 2316 ?S10:29 0:00 \_ /usr/sbin/dbmail-imapd Thanks, - April Lorenzen http://ors.blogs4change.org http://adl.blogware.com

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

2005-08-08 Thread April Lorenzen
n into being kind of like a vacation reply - April On 8/8/05, Paul J Stevens <[EMAIL PROTECTED]> wrote: > > April Lorenzen wrote: > > Using squirrelmail with dbmail 2.0.4 - I have to restart dbmail every > > day and that now is not enough due to more people using IMAP

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

2005-08-08 Thread April Lorenzen
its a little hard to gauge different people's ideas of what is safe. Fixing this imap timeout issue I created myself will help a lot. - April On 8/8/05, Paul J Stevens <[EMAIL PROTECTED]> wrote: > April Lorenzen wrote: > > Thanks Paul. Not a bug - just a self-inflicted wound - I h

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

2005-08-09 Thread April Lorenzen
t;generic" > forward that is assigned to a user. The address that gets the forwarded > message is a script that gets the sender address, pulls the text from > the DB and kicks out the message. I have a feeling that's kinda how > it will get done in 2.1, but I haven't looked

[Dbmail] autoreplier.py

2005-08-10 Thread April Lorenzen
http://www.dbmail.org/dokuwiki/doku.php?id=autoresponder I have installed this work of Paul's and wonder how others are handling the need for the customer to be able to write their vacation message to a file? My customers do not have any kind of shell access. debian Thanks, April Lor

Re: [Dbmail] autoreplier.py

2005-08-11 Thread April Lorenzen
So you are going to do this ? :) I'm not python programmer unfortunately. On 8/11/05, Paul J Stevens <[EMAIL PROTECTED]> wrote: > > > Paul J Stevens wrote: > > > > April Lorenzen wrote: > > > >>http://www.dbmail.org/dokuwiki/doku.php?id=autor

Re: [Dbmail] autoreplier.py

2005-08-12 Thread April Lorenzen
That's awesome, thank you Paul. And I of course use postgresql :) Eventually either I or my pg / py guy could edit it for pg tho I'm sure. On 8/12/05, Paul J Stevens <[EMAIL PROTECTED]> wrote: > April, > > I've committed some python base-classes, and an updated autoreplier.py > to svn-trunk. It

[Dbmail] how to test autoreplier.py

2005-09-03 Thread April Lorenzen
-u [EMAIL PROTECTED] -a [EMAIL PROTECTED] (my userids are full email addresses) Thank you, April Lorenzen http://ors.blogs4change.org http://adl.blogware.com

[Dbmail] Re: how to test autoreplier.py

2005-09-03 Thread April Lorenzen
x27;t coming out of it. Well first let me look at permissions on the py files i guess. When you cat pipe a message to the autoreplier.py, the cursor just returns as if everything went normally. I haven't found relevant logs yet. Thank you, - April Lorenzen http://ors.blogs4change.org/ http:/

[Dbmail] Re: how to test autoreplier.py

2005-09-03 Thread April Lorenzen
Running ./dbmail.py alone - get this: Dbmail configuration error: missing key [STORAGE] for stanza [DBMAIL] On 9/3/05, April Lorenzen <[EMAIL PROTECTED]> wrote: > def _setPgsqlDictCursor(self): > import psycopg > conn = psycopg.connect("host=%s dbname=%s

[Dbmail] number of dbmail-imap processes after imapproxy

2005-09-12 Thread April Lorenzen
# if yes, the imap daemon resolves IP numbers to DNS names in the log IMAP_BEFORE_SMTP=yes MINSPARECHILDREN=4 MAXSPARECHILDREN=8 MAXCHILDREN=200 TRACE_LEVEL=0 - April Lorenzen http://ors.blogs4change.org http://adl.blogware.com

Re: [Dbmail] Webmail

2006-08-19 Thread April Lorenzen
I am anxious to try http://alphamail.uoosl.org/ which is in use for 10,000 users at a university (not with dbmail) - as an alternative to squirrel. Main reason: it was designed to address the performance flaws in imap webmail clients such as squirrel: "My Performance tests on IMAP servers were my