Re: [Dbmail-dev] Uidvalidity not changing

2006-09-19 Thread Paul J Stevens


Geo Carncross wrote:
 Now, I recommend that servers make FETCH+ENVELOPE fast, and client
 implementers should use:
 
 x FETCH 1:* ENVELOPE

*Very* cheap in dbmail atm.

-- 
  
  Paul Stevens  paul at nfg.nl
  NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
  The Netherlandshttp://www.nfg.nl


Re: [Dbmail-dev] dbmail-pop3d and order

2006-09-19 Thread Aaron Stone
Just kidding, I broke my subversion client's SSL linkage.
Will try to get this committed tomorrow.

On Mon, 2006-09-18 at 14:40 -0700, Aaron Stone wrote:
 Done.
 
 On Mon, 2006-09-18 at 16:14 -0400, Geo Carncross wrote:
 
  Put message_idnr ASC first. Don't order by status; Consider what happens
  if another client changes the status after UIDL but before TOP?
  
  If they exclusively use POP3 clients, they'll see it ordered by status
  anyway (because new messages will be at the bottom).
 
 
 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev



Re: [Dbmail-dev] building ubuntu packages

2006-09-19 Thread Lars Kneschke
Paul J Stevens [EMAIL PROTECTED] schrieb:
 
 
Lars Kneschke wrote: 
 Hello! 
  
 I like to have dbmail and libsieve packages for ubuntu. 
  
 Bulding dbmail packages itself is quite easy. It works out of the box. 
  
 But building libsieve is a little bit tricky. So far there exists no 
 working deb package. 
 
libsieve is now part of debian/unstable. It's called libsieve2-1 
Thanks! I have downloaded the source files and rebuild the packages under
ubuntu. 





[Dbmail-dev] Forwarding from Client

2006-09-19 Thread Nataraj S Narayan

Hi

I am using DBMail + postfix for the past one year. Have settled down to 
2.0.9 version for the past few months. The system is very much stable 
and hence and havent done any digging of late.


1. My boss wants me to implement a system where  all the mails are 
downloaded by one person and then forward it to the various 
users/departments. A facility is needed to mark a mail as 
'to-be-replied'  by a particular user, while forwarding. A report need 
to be generated with all the e-mails which was marked to-be-replied and 
that was not replied in 2 days.


2. The forwared mails should have the actual 'sender' in-tact, ie, the 
receiver should as if  receive it as if from the original sender, not 
the intermediate person.


The second one, I had successfully implemented  by modifying 'Phoenix 
Mail' email client.


But I need a more generic solution from the dbmail side.

Plz suggest ways to do these.

regards

Nataraj


Re: [Dbmail-dev] Forwarding from Client

2006-09-19 Thread Marc Dirix

You need some sort of ticket system?
I wouldn't use dbmail itself for this kind of sorting but some kind  
of script.


What do you mean with downloading? from a pop-source? If you use  
fetchmail, the original

sender stays intact.

For checking if the message is replied within 2 days you can check  
everyday if the imap replied flag has been set, And compare it with  
the message-date. You'd need to create a cron script for this.


/marc


[Dbmail-dev] Re dbmail bug report 405

2006-09-19 Thread Leif Jackson
Paul,

 even though these warning are harmless they should be fixed, this is
minor yes but still will save you and aaron and the list time not
answering this question again so I belive this is the best fix:


diff -urNb dbmail-svn-2.1.8-2270.orig/modules/dbmysql.c
dbmail-svn-2.1.8-2270/modules/dbmysql.c
--- dbmail-svn-2.1.8-2270.orig/modules/dbmysql.c2006-09-18
14:27:31.0 -0400
+++ dbmail-svn-2.1.8-2270/modules/dbmysql.c 2006-09-19
07:17:57.0 -0400
@@ -236,7 +236,7 @@
return NULL;
}

-   if ((row = db_num_rows()) || (field = db_num_fields())) {
+   if ((row  db_num_rows()) || (field  db_num_fields())) {
trace(TRACE_WARNING, %s, %s: 
  row = %u, field = %u, bigger than size of result set,
  __FILE__, __func__, row, field);
@@ -266,7 +266,7 @@

result = last_row[field];
if (result == NULL)
-   trace(TRACE_WARNING, %s,%s: result is null\n,
+   trace(TRACE_DEBUG, %s,%s: result is null\n,
  __FILE__, __func__);
return result;
 }


the first diff is because you get a erounous bigger than size of result
set for row == 0 and field == 0 which is not what I belive that warning
was ment for. and the second addresses report 405 and just makes it a
debuging message only if you and aaron don't want to remove that
completly.


as always just my 0.02 :)

Thanks,
Leif





Re: [Dbmail-dev] Forwarding from Client

2006-09-19 Thread Geo Carncross
Seems like shared folders are the way to go here; having one person have
access to everyone elses' INBOX directly. What's the status on shared
folders in DBMail?

The IMAP Followup flag is almost universally supported, so it can be
used for to-be-replied.

For tracking if messages have been replied to, well I would use a shim.
On Qmail this is very easy to do; simply put recordio in front of
qmail-smtpd and egrep for Message-ID|References|In-Reply-To. This log
could be used to determine if a message was replied to, and when it was
received, for the purposes of reporting. I'm sure it would be fairly
trivial to adapt this for postfix or dbmail's smtpd.

Awk and grep are a beautiful thing.

On Tue, 2006-09-19 at 16:45 +0530, Nataraj S Narayan wrote:
 Hi
 
 I am using DBMail + postfix for the past one year. Have settled down to 
 2.0.9 version for the past few months. The system is very much stable 
 and hence and havent done any digging of late.
 
 1. My boss wants me to implement a system where  all the mails are 
 downloaded by one person and then forward it to the various 
 users/departments. A facility is needed to mark a mail as 
 'to-be-replied'  by a particular user, while forwarding. A report need 
 to be generated with all the e-mails which was marked to-be-replied and 
 that was not replied in 2 days.
 
 2. The forwared mails should have the actual 'sender' in-tact, ie, the 
 receiver should as if  receive it as if from the original sender, not 
 the intermediate person.
 
 The second one, I had successfully implemented  by modifying 'Phoenix 
 Mail' email client.
 
 But I need a more generic solution from the dbmail side.
 
 Plz suggest ways to do these.
 
 regards
 
 Nataraj
 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev
-- 
Internet Connection High Quality Web Hosting
http://www.internetconnection.net/



Re: [Dbmail-dev] Re dbmail bug report 405

2006-09-19 Thread Paul J Stevens
fix applied (to dbpgsql.c as well).

thanks,

Leif Jackson wrote:
 Paul,
 
  even though these warning are harmless they should be fixed, this is
 minor yes but still will save you and aaron and the list time not
 answering this question again so I belive this is the best fix:
 
 
 diff -urNb dbmail-svn-2.1.8-2270.orig/modules/dbmysql.c
 dbmail-svn-2.1.8-2270/modules/dbmysql.c
 --- dbmail-svn-2.1.8-2270.orig/modules/dbmysql.c2006-09-18
 14:27:31.0 -0400
 +++ dbmail-svn-2.1.8-2270/modules/dbmysql.c 2006-09-19
 07:17:57.0 -0400
 @@ -236,7 +236,7 @@
 return NULL;
 }
 
 -   if ((row = db_num_rows()) || (field = db_num_fields())) {
 +   if ((row  db_num_rows()) || (field  db_num_fields())) {
 trace(TRACE_WARNING, %s, %s: 
   row = %u, field = %u, bigger than size of result set,
   __FILE__, __func__, row, field);
 @@ -266,7 +266,7 @@
 
 result = last_row[field];
 if (result == NULL)
 -   trace(TRACE_WARNING, %s,%s: result is null\n,
 +   trace(TRACE_DEBUG, %s,%s: result is null\n,
   __FILE__, __func__);
 return result;
  }
 
 
 the first diff is because you get a erounous bigger than size of result
 set for row == 0 and field == 0 which is not what I belive that warning
 was ment for. and the second addresses report 405 and just makes it a
 debuging message only if you and aaron don't want to remove that
 completly.
 
 
 as always just my 0.02 :)
 
 Thanks,
 Leif
 
 
 
 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev
 

-- 
  
  Paul Stevens  paul at nfg.nl
  NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
  The Netherlandshttp://www.nfg.nl


Re: [Dbmail-dev] Re dbmail bug report 405

2006-09-19 Thread Leif Jackson
can you please also get the row is NULL above the result is NULL I missed
that in my patch.

Thanks,
Leif


On Tue, September 19, 2006 9:23 am, Paul J Stevens wrote:
 fix applied (to dbpgsql.c as well).

 thanks,

 Leif Jackson wrote:

 Paul,


 even though these warning are harmless they should be fixed, this is
 minor yes but still will save you and aaron and the list time not
 answering this question again so I belive this is the best fix:


 diff -urNb dbmail-svn-2.1.8-2270.orig/modules/dbmysql.c
 dbmail-svn-2.1.8-2270/modules/dbmysql.c ---
 dbmail-svn-2.1.8-2270.orig/modules/dbmysql.c2006-09-18
 14:27:31.0 -0400
 +++ dbmail-svn-2.1.8-2270/modules/dbmysql.c 2006-09-19
 07:17:57.0 -0400
 @@ -236,7 +236,7 @@
 return NULL; }


 -   if ((row = db_num_rows()) || (field = db_num_fields())) {
 +   if ((row  db_num_rows()) || (field  db_num_fields())) {
 trace(TRACE_WARNING, %s, %s:  row = %u, field = %u, bigger than size
 of result set, __FILE__, __func__, row, field);
 @@ -266,7 +266,7 @@


 result = last_row[field]; if (result == NULL) -
 trace(TRACE_WARNING, %s,%s: result is null\n, +
 trace(TRACE_DEBUG, %s,%s: result is null\n, __FILE__, __func__);
 return result; }



 the first diff is because you get a erounous bigger than size of result
  set for row == 0 and field == 0 which is not what I belive that
 warning was ment for. and the second addresses report 405 and just makes
 it a debuging message only if you and aaron don't want to remove that
 completly.


 as always just my 0.02 :)

 Thanks,
 Leif




 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev



 --
 
 Paul Stevens  paul at nfg.nl
 NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
 The Netherlandshttp://www.nfg.nl
 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev






Re: [Dbmail-dev] Re dbmail bug report 405

2006-09-19 Thread Paul J Stevens
ok.

Leif Jackson wrote:
 can you please also get the row is NULL above the result is NULL I missed
 that in my patch.
 
 Thanks,
 Leif
 
 
 On Tue, September 19, 2006 9:23 am, Paul J Stevens wrote:
 fix applied (to dbpgsql.c as well).

 thanks,

 Leif Jackson wrote:

 Paul,


 even though these warning are harmless they should be fixed, this is
 minor yes but still will save you and aaron and the list time not
 answering this question again so I belive this is the best fix:


 diff -urNb dbmail-svn-2.1.8-2270.orig/modules/dbmysql.c
 dbmail-svn-2.1.8-2270/modules/dbmysql.c ---
 dbmail-svn-2.1.8-2270.orig/modules/dbmysql.c2006-09-18
 14:27:31.0 -0400
 +++ dbmail-svn-2.1.8-2270/modules/dbmysql.c 2006-09-19
 07:17:57.0 -0400
 @@ -236,7 +236,7 @@
 return NULL; }


 -   if ((row = db_num_rows()) || (field = db_num_fields())) {
 +   if ((row  db_num_rows()) || (field  db_num_fields())) {
 trace(TRACE_WARNING, %s, %s:  row = %u, field = %u, bigger than size
 of result set, __FILE__, __func__, row, field);
 @@ -266,7 +266,7 @@


 result = last_row[field]; if (result == NULL) -
 trace(TRACE_WARNING, %s,%s: result is null\n, +
 trace(TRACE_DEBUG, %s,%s: result is null\n, __FILE__, __func__);
 return result; }



 the first diff is because you get a erounous bigger than size of result
  set for row == 0 and field == 0 which is not what I belive that
 warning was ment for. and the second addresses report 405 and just makes
 it a debuging message only if you and aaron don't want to remove that
 completly.


 as always just my 0.02 :)

 Thanks,
 Leif




 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev


 --
 
 Paul Stevens  paul at nfg.nl
 NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
 The Netherlandshttp://www.nfg.nl
 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev


 
 
 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev
 


-- 
  
  Paul Stevens  paul at nfg.nl
  NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
  The Netherlandshttp://www.nfg.nl


Re: [Dbmail-dev] outlook/outlook express with sieve

2006-09-19 Thread Marc Dirix

Aaron,

I've missed your input about this sofar. Did you mis my last 2 emails?

/Marc

Op 10-sep-2006, om 5:13 heeft Aaron Stone het volgende geschreven:

I inserted your script in my testing database, sent myself an  
email, and

received the vacation reply. Looks great in Evolution.

Here's some information about Outlook:
http://trac.edgewall.org/ticket/1065

In particular, this comment looked useful:

This is a pure Outlook error. It can be solved by seetting an  
option in

MS Outlook. You can find the option here (don't know the exact english
phrases, I have a German Outlook):

Extras -- Options... -- Email format -- Fonts ... -- International
Fonts ...

Highlight Unicode in the language list, select Courier New as the
proportional font, and chose Unicode (UTF-8) as encoding.


Maybe that'll work for you? If every person who uses Outlook and
receives your messages has to make this settings change, it's not  
quite
so good as just having it work in the first place... but let me  
know if

this does resolve the issue.

Aaron


On Sun, 2006-09-10 at 00:36 +0200, Marc Dirix wrote:

Hi,

It took me some time, to find a free M$ computer, but attached are  
the

message files.

I did an select on the dbmail_sieve table, for the actual script I
inserted.
Als a select on dbmail_messageblks with the message being ready to be
popped by the outlook client.

The I saved the message after it being popped by outlook 2003,  
found the

message headers missing and saved the to a seperate file.

Hope this helps in any way,

best regards,

Marc Dirix
___
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev







Re: [Dbmail-dev] outlook/outlook express with sieve

2006-09-19 Thread Paul J Stevens
Marc Dirix wrote:

 MIME-Version: 1.0
 Content-Type: text/plain; charset=utf-8
 Content-Transfer-Encoding: 8bit

Have you tried setting up your encoding differently? 8bit messages I
have in my mailbox just contain:

Content-Type: text/plain
Content-Transfer-Encoding: 8bit

So perhaps leaving out the charset is enough.

Your mutt experiment seems to confirm this.

-- 
  
  Paul Stevens  paul at nfg.nl
  NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
  The Netherlandshttp://www.nfg.nl