[Dbmail-dev] testimap.py

2004-03-30 Thread Paul J Stevens


Ilja,

I'm sending you an updated version of the imap testsuite. I've implemented some 
more tests, and included stubs for all imap commands supported by pythons 
imaplib. Additional commands supported by dbmail will have to be implemented in 
the testsuite itself.


btw, I'm still getting the same dbase internal errors while calling list for a 
user who had a acl set by another user.


Also, this morning I found that connecting to a long running dbmail instance on 
a low memory machine with the testsuite resulted in 'illegal character on TAG 
line' results (iirc). Or, 'illegal character in mailbox name' when doing delete 
or create. Restarting dbmail-imapd made those disappear. So, a memory problem 
does sound like a possibility.




--
  
  Paul Stevens [EMAIL PROTECTED]
  NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
  The Netherlands___www.nfg.nl
#!/usr/bin/python

import unittest, imaplib, re
import traceback

unimplementedError = 'Dbmail testcase unimplemented'

class testDbmailImap(unittest.TestCase):

def setUp(self):
#self.o.debug = 4
self.o = imaplib.IMAP4('mail')
self.assertEquals(self.o.login('testuser1','test'),('OK',['LOGIN completed']))

def testAppend(self):
 test:
'append(mailbox, flags, date_time, message)'
 Append message to named mailbox.

#raise unimplementedError

def testCheck(self):
 test:
'check()'
Checkpoint mailbox on server.
 
self.o.select('INBOX')
self.assertEquals(self.o.check(),('OK', ['CHECK completed']))

def testClose(self):
 test:
'close()'
 Close currently selected mailbox. Deleted messages are removed from
writable mailbox. This is the recommended command before `LOGOUT'.

self.o.select('INBOX')
self.assertEquals(self.o.close(),('OK', ['CLOSE completed']))

def testCopy(self):
 test:
'copy(message_set, new_mailbox)'
Copy MESSAGE_SET messages onto end of NEW_MAILBOX.

#raise unimplementedError

def testCreate(self):
 test:
'create(mailbox)'
Create new mailbox named MAILBOX.

self.assertEquals(self.o.create('testbox'),('OK',['CREATE completed']))

def testDelete(self):
 test:
'delete(mailbox)'
Delete old mailbox named MAILBOX.

self.o.create('testdelete')
self.assertEquals(self.o.delete('testdelete'),('OK',['DELETE completed']))

def testExpunge(self):
 test:
expunge()'
Permanently remove deleted items from selected mailbox. Generates
an `EXPUNGE' response for each deleted message. Returned data
contains a list of `EXPUNGE' message numbers in order received.

self.o.select('INBOX')
self.assertEquals(self.o.expunge(),('OK', [None]))

def testFetch(self):
 test:
fetch(message_set, message_parts)'
Fetch (parts of) messages.  MESSAGE_PARTS should be a string of
message part names enclosed within parentheses, eg: `(UID
BODY[TEXT])'.  Returned data are tuples of message part envelope
and data.

#raise unimplementedError

def testGetacl(self):
 test:
`getacl(mailbox)'
Get the `ACL's for MAILBOX. 

self.assertEquals(self.o.getacl('INBOX'),('OK', ['INBOX testuser1 lrswipcda ']))

def getQuota(self):
 test:
getquota(root)
Get the `quota' ROOT's resource usage and limits.  This method is
part of the IMAP4 QUOTA extension defined in rfc2087.

#raise unimplementedError

def getQuotaroot(self):
 test:
getquotaroot(mailbox)
Get the list of `quota' `roots' for the named MAILBOX.  This
method is part of the IMAP4 QUOTA extension defined in rfc2087.

#raise unimplementedError

def testList(self):
 test:
list([directory[, pattern]])
List mailbox names in DIRECTORY matching PATTERN.  DIRECTORY
defaults to the top-level mail folder, and PATTERN defaults to
match anything.  Returned data contains a list of `LIST' responses.

dirlist=['dir1','dir1/sub1','dir2/sub2','dir2/sub 2a','dir3/sub 3/ssub1','dir3/sub 3/.ssub2']
for d in dirlist: self.o.create(d)
try:
self.assertEquals(self.o.list('dir1')[0],'OK')
except: 
traceback.print_exc()

try:
self.assertEquals(self.o.list('dir2')[0],'OK')
except:
traceback.print_exc()

try:

Re: [Dbmail-dev] dbmail md5 is not md5 from RFC 1321 ?

2004-03-30 Thread Jesse Norell

Hello,

  dbmail supports both md5 hash and digest.  For the digest, try using
a type of md5sum instead of md5.  The value in the database can
actually be in either format if encryption_type is md5 (it looks at
the first 3 chars and if it's $1$ it's an md5 hash), but if you tell
it to create with an md5 password format, you get the hash.  The
hash is of course much better for security if someone ever gets a copy
of your users table (it takes a tremendous amount more resources to
generate a dictionary table for md5 hashes than the digest, which has
a 1-1 ratio with the plaintext password).



 Original Message 
From: Thomas Mueller dbmail-dev@dbmail.org
To: DBMAIL Developers Mailinglist dbmail-dev@dbmail.org
Subject: Re: [Dbmail-dev] dbmail md5 is not md5 from RFC 1321 ?
Sent: Sat, 27 Mar 2004 12:25:46 +0100

 Hi Paul,
 
  The difference is between md5-digest, and md5-hash. I don't have any 
  detailed knowlegde of the algorithms involved, though.
 
 I searched around the net in case I've missed something in the past but
 I found nothing new.
 
 md5 = message digest 5, md5 is a hash algorithm. There are 3
 representations of the message digest:
 16 byte: raw output
 24 byte: base64 encoded
 32 byte: hex string
 
 This perl script shows all of them:
 -
 #!/usr/bin/perl
 use Digest::MD5  qw(md5 md5_hex md5_base64);
   
   
 my $string = test;
   
   
 print string:  . $string . \n;
 print md5: . md5($string) . \n;
 print md5_hex: . md5_hex($string) . \n;
 print md5_base64:  . md5_base64($string) . \n;
 -
 
 Every software I found uses the hex string, so dbmail should use that
 one too (that way I can use the dbmail account for SMTP Auth with p.e.
 exim).
 
  can someone explain the difference between the md5 algorithm dbmail uses
  and the one from RFC 1321? I only know md5s as 32 byte hex string.
 
 
 Thomas
 -- 
 http://www.tmueller.com for pgp key (95702B3B)
 ___
 Dbmail-dev mailing list
 Dbmail-dev@dbmail.org
 http://twister.fastxs.net/mailman/listinfo/dbmail-dev
 
-- End Original Message --


--
Jesse Norell

[EMAIL PROTECTED] is not my email address;
change administrator to my first name.
--



[Dbmail-dev] SORT patch for current CVS, just in case anyone wants the clean diff

2004-03-30 Thread Leif Jackson
I have attached the same version 2 patch for the sort command I sent the
list a few days ago, but this is against current cvs so it should apply
cleanly. Might be nice to sneek it into 2.0 for the people who use dbmail
for a webmail backend, but that is up to you guys :) It is usable I just
don't know if it is good enough to sneek in. At least it is obviously a
needed feature

Thanks,
Leif


dbmail-2.0cvs031804-ic_sort-v2.diff
Description: Binary data


Re: [Dbmail-dev] dbmail md5 is not md5 from RFC 1321 ?

2004-03-30 Thread Thomas Mueller
Hi Jesse,

   dbmail supports both md5 hash and digest.  For the digest, try using
 a type of md5sum instead of md5.  The value in the database can
 actually be in either format if encryption_type is md5 (it looks at
 the first 3 chars and if it's $1$ it's an md5 hash), but if you tell
 it to create with an md5 password format, you get the hash.  The
 hash is of course much better for security if someone ever gets a copy
 of your users table (it takes a tremendous amount more resources to
 generate a dictionary table for md5 hashes than the digest, which has
 a 1-1 ratio with the plaintext password).

Yes that works fine, I missed that in the man page, sorry.
Better security would be fine, but exim needs a md5 digest.


Thomas
-- 
http://www.tmueller.com for pgp key (95702B3B)


[Dbmail] Squirrelmail 1.4.2 integration problem w/ dbmail-imapd 1.2.2

2004-03-30 Thread Will Berry
I have posted this problem to the SquirrelMail list already, but I am 
starting to question my initial assumption that it is a SM configuration 
problem.  I am starting to wonder whether I am doing something wrong on 
the DBMail side.  I could not find anything like this in the archives.  
We are preparing to deploy SM for our customers and I've got an install 
on our test box.  All services are running on the same box (MySQL, 
Apache, Postfix/DBMail, etc.), and the browser is on the same box as well.


The basic problem is that when I correctly login to Squirrelmail I get 
an error message: You must be logged in to access this page.  This is 
not an HTTP authentication window; this is the resultant PHP document 
from logging in.  (When I login incorrectly, I get the expected bad 
password massage instead.)


I have turned the trace level up to 5 on the dbmail-imapd server.  
Unfortunately, it does not log the responses to client commands, only 
the commands themselves.  (Feature request?)  But here are the four 
commands I see from the client.  Does this look strange to anyone?


A001 LOGIN tld_domain__user password
A002 CAPABILITY
. LIST INBOX 
A003 LOGOUT

The IMAP server logs do not show any errors.  It can talk to MySQL just 
fine, etc.  (The POP3 daemon works fine, and I can use this mailbox via 
IMAP in Mozilla 1.6 without problems.)  I created the account with this 
command line:


$ dbmail-adduser a tld_domain__user {crypt:}password 0 0 [EMAIL PROTECTED]

I have made no changes to the user, mailboxes, or any other tables 
by hand.  All flags in the INBOX row for this account are set to 0 (the 
default for all), and 'permission' is 2 (the default).


Does anybody see any configuration error on my part with DBMail?  Has 
anyone seen this exact problem before?  Thanks for your attention; I 
promise to post the resolution when I reach it.


--
Will Berry
Co-founder, Second Brain website hosting
http://www.secondbrainhosting.com/


Re: [Dbmail] Squirrelmail 1.4.2 integration problem w/ dbmail-imapd 1.2.2

2004-03-30 Thread Micah


I'm running SM 1.4.2 with the dbmail 1.2.5 distro, and it's working great. I 
didn't have to do anything special to get it to work either, I did set the 
IMAP server to 'other' is all, everything else was standard. 

-Micah 

On Monday 29 March 2004 04:20 pm, James XMS wrote:
 I started seeing this issue with the release of 1.4.
 When i was using 1.2.x it was working fine. Maybe give 1.2.x a go to see if
 the same happenes to you?

 Cheers
 James

 On Mon, 29 Mar 2004 16:43 , Micah [EMAIL PROTECTED] sent:
 I'd say it's likely a php session issue.. IMAP errors will not cause this
 error. It's caused when you access a protected page with no session
 information. Check the normal session stuff, cookies, passed SID's stuff
  like that.
 
 hope that helps.
 
 -Micah
 
 On Monday 29 March 2004 03:14 pm, Will Berry wrote:
  I have posted this problem to the SquirrelMail list already, but I am
  starting to question my initial assumption that it is a SM configuration
  problem.  I am starting to wonder whether I am doing something wrong on
  the DBMail side.  I could not find anything like this in the archives.
  We are preparing to deploy SM for our customers and I've got an install
  on our test box.  All services are running on the same box (MySQL,
  Apache, Postfix/DBMail, etc.), and the browser is on the same box as
  well.
 
  The basic problem is that when I correctly login to Squirrelmail I get
  an error message: You must be logged in to access this page.  This is
  not an HTTP authentication window; this is the resultant PHP document
  from logging in.  (When I login incorrectly, I get the expected bad
  password massage instead.)
 
  I have turned the trace level up to 5 on the dbmail-imapd server.
  Unfortunately, it does not log the responses to client commands, only
  the commands themselves.  (Feature request?)  But here are the four
  commands I see from the client.  Does this look strange to anyone?
 
  A001 LOGIN tld_domain__user password
  A002 CAPABILITY
  . LIST INBOX 
  A003 LOGOUT
 
  The IMAP server logs do not show any errors.  It can talk to MySQL just
  fine, etc.  (The POP3 daemon works fine, and I can use this mailbox via
  IMAP in Mozilla 1.6 without problems.)  I created the account with this
  command line:
 
  $ dbmail-adduser a tld_domain__user {crypt:}password 0 0 [EMAIL PROTECTED]
 
  I have made no changes to the user, mailboxes, or any other tables
  by hand.  All flags in the INBOX row for this account are set to 0 (the
  default for all), and 'permission' is 2 (the default).
 
  Does anybody see any configuration error on my part with DBMail?  Has
  anyone seen this exact problem before?  Thanks for your attention; I
  promise to post the resolution when I reach it.
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

 --- Msg sent via @Mail - http://atmail.nl/
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail


Re: [Dbmail] HELP - folders disappearing!

2004-03-30 Thread Augusto Bott

Dear List,

I figure it out  what was happening - someone changed the 
$default_folder_prefix from . to /mail - that little change made 
squirrel not find any folders. That puzzled me - because accessing 
diretly the IMAP server, the messages where there.


Thanks everyone.
Augusto Bott


Augusto Bott wrote:


Dear All,

This time I've attached an 1000 line log with TRACE_LEVEL=5.
The rest of the original mail follows:

I've been using dbmail for the last few weeks on a testing site.
Last week, we thought it was good enough for production use, so, we 
transfered all our e-mail accounts to bdmail.


But this monday morning came with a (not so good) surprise: my folders 
aren't listed anymore!

They *are*  on the database, but the imap server can't find it!

I'm using dbmail 1.2.5 with squirrelmail - no configuration has been 
changed on squirrel during this weekend and the query I used to verify 
the folder names is:
select userid, mailbox_idnr , name, seen_flag, answered_flag, 
deleted_flag, flagged_flag, recent_flag, draft_flag, no_infer
n, is_subscribed from users, mailboxes where owner_idnr = user_idnr 
AND userid='jonas'


any help would be appreciated!!

[[]]s
Augusto Bott

P.S.: the log is attached







[Dbmail] FreeBSD 5.1 MySQL 4.10 - STILL NOT SOLVED

2004-03-30 Thread Luuk
Hi,

i yust tried to install dbmail,
it took me about two hours to find a message from june 2003, that dbmail is
not working with mysql 4.1
(see message below)

greetings,
Luuk

Okay guys, Ive backed out of MySQL 4.1 to MySQL 4.0 all works fine now,
so heads up avoid 4.12 until the database/scehama works for it

On Wed, 2003-06-11 at 03:34, Kerberus wrote:
 Nope same error... Arrrggghhgh

 On Tue, 2003-06-10 at 22:32, Aaron Stone wrote:
  Try changing the line so that the 0 is not '0'. Perhaps the lastest
MySQL
  is picky about seeing numbers inside of quotes?
 
  Aaron
 
 
  On 11 Jun 2003, Kerberus wrote:
 
   Thanks for the heads up, but it still doesnt like this line
  
   ns2# cd sql/mysql/
   ns2# mysqladmin create dbmail
   ns2# mysql dbmail  create_tables_innoDB.mysql
   ERROR 1067 at line 6: Invalid default value for 'alias_idnr'
  
  



Re: [Dbmail] Squirrelmail 1.4.2 integration problem w/ dbmail-imapd 1.2.2

2004-03-30 Thread Leif Jackson
Augusto  Micah,

  This issues has to do with the fact that until dbmail 2.1 (where they
will add my sort patch), dbmail lacks support for the server side sort.
I have a patch for the functinality required for squirrel mail for
2.0rc4 but it is only functional, not fully optimized due to some onther
internals we will be chaning for 2.1 devlopment cycle. Every time
squirrelmail connects to the imap server it must download all message
headers and then sort them in php and then return to your browser the 25
you want to see. This currently cannot be overcome with dbmail 1.x, and
only with my beta patch to 2.0rc4.

Thanks,
Leif Jackson.

 Micah,

 I'm running the very same configuration here - SM 1.4.2 and dbmail 1.2.5.
 Have you experienced perfomance problems?
 For benchmarking purposes, i created 30 folders and filled each one of
 them with 100 to 1500 messages (a total of 16000 messages) - it's
 extremeley slow - taking almost 40 seconds to show the folder list. I
 the other hand i took the messages from an uw-imap (again, 30 folders,
 16000 messages) - it took only 3 secs to show me the folder bar.

 Any tips on perfomance would be greatly appreciated.

 Augusto Bott


 Micah wrote:

I'm running SM 1.4.2 with the dbmail 1.2.5 distro, and it's working
 great. I
didn't have to do anything special to get it to work either, I did set
 the
IMAP server to 'other' is all, everything else was standard.

-Micah

On Monday 29 March 2004 04:20 pm, James XMS wrote:


I started seeing this issue with the release of 1.4.
When i was using 1.2.x it was working fine. Maybe give 1.2.x a go to see
 if
the same happenes to you?

Cheers
James

On Mon, 29 Mar 2004 16:43 , Micah [EMAIL PROTECTED] sent:


I'd say it's likely a php session issue.. IMAP errors will not cause
 this
error. It's caused when you access a protected page with no session
information. Check the normal session stuff, cookies, passed SID's
 stuff
like that.

hope that helps.

-Micah

On Monday 29 March 2004 03:14 pm, Will Berry wrote:


I have posted this problem to the SquirrelMail list already, but I am
starting to question my initial assumption that it is a SM
 configuration
problem.  I am starting to wonder whether I am doing something wrong
 on
the DBMail side.  I could not find anything like this in the archives.
We are preparing to deploy SM for our customers and I've got an
 install
on our test box.  All services are running on the same box (MySQL,
Apache, Postfix/DBMail, etc.), and the browser is on the same box as
well.

The basic problem is that when I correctly login to Squirrelmail I get
an error message: You must be logged in to access this page.  This
 is
not an HTTP authentication window; this is the resultant PHP document
from logging in.  (When I login incorrectly, I get the expected bad
password massage instead.)

I have turned the trace level up to 5 on the dbmail-imapd server.
Unfortunately, it does not log the responses to client commands, only
the commands themselves.  (Feature request?)  But here are the four
commands I see from the client.  Does this look strange to anyone?

A001 LOGIN tld_domain__user password
A002 CAPABILITY
. LIST INBOX 
A003 LOGOUT

The IMAP server logs do not show any errors.  It can talk to MySQL
 just
fine, etc.  (The POP3 daemon works fine, and I can use this mailbox
 via
IMAP in Mozilla 1.6 without problems.)  I created the account with
 this
command line:

$ dbmail-adduser a tld_domain__user {crypt:}password 0 0
 [EMAIL PROTECTED]

I have made no changes to the user, mailboxes, or any other tables
by hand.  All flags in the INBOX row for this account are set to 0
 (the
default for all), and 'permission' is 2 (the default).

Does anybody see any configuration error on my part with DBMail?  Has
anyone seen this exact problem before?  Thanks for your attention; I
promise to post the resolution when I reach it.


___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


--- Msg sent via @Mail - http://atmail.nl/
___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail



 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail




Re: [Dbmail] Squirrelmail 1.4.2 integration problem w/ dbmail-imapd 1.2.2

2004-03-30 Thread Micah
Augusto,

I would agree that with large mailboxes, such as your benchmarking example, 
it's not very fast. I had always assumed that this was due to the imap 
implimentation, as I know uw-imap does use some specialized commands which I 
believe allow it to sort on the server. 1.2.5 sorts using php which is much 
slower. 

-Micah 


On Tuesday 30 March 2004 05:10 am, Augusto Bott wrote:
 Micah,

 I'm running the very same configuration here - SM 1.4.2 and dbmail 1.2.5.
 Have you experienced perfomance problems?
 For benchmarking purposes, i created 30 folders and filled each one of
 them with 100 to 1500 messages (a total of 16000 messages) - it's
 extremeley slow - taking almost 40 seconds to show the folder list. I
 the other hand i took the messages from an uw-imap (again, 30 folders,
 16000 messages) - it took only 3 secs to show me the folder bar.

 Any tips on perfomance would be greatly appreciated.

 Augusto Bott

 Micah wrote:
 I'm running SM 1.4.2 with the dbmail 1.2.5 distro, and it's working great.
  I didn't have to do anything special to get it to work either, I did set
  the IMAP server to 'other' is all, everything else was standard.
 
 -Micah
 
 On Monday 29 March 2004 04:20 pm, James XMS wrote:
 I started seeing this issue with the release of 1.4.
 When i was using 1.2.x it was working fine. Maybe give 1.2.x a go to see
  if the same happenes to you?
 
 Cheers
 James
 
 On Mon, 29 Mar 2004 16:43 , Micah [EMAIL PROTECTED] sent:
 I'd say it's likely a php session issue.. IMAP errors will not cause
  this error. It's caused when you access a protected page with no
  session information. Check the normal session stuff, cookies, passed
  SID's stuff like that.
 
 hope that helps.
 
 -Micah
 
 On Monday 29 March 2004 03:14 pm, Will Berry wrote:
 I have posted this problem to the SquirrelMail list already, but I am
 starting to question my initial assumption that it is a SM
  configuration problem.  I am starting to wonder whether I am doing
  something wrong on the DBMail side.  I could not find anything like
  this in the archives. We are preparing to deploy SM for our customers
  and I've got an install on our test box.  All services are running on
  the same box (MySQL, Apache, Postfix/DBMail, etc.), and the browser is
  on the same box as well.
 
 The basic problem is that when I correctly login to Squirrelmail I get
 an error message: You must be logged in to access this page.  This is
 not an HTTP authentication window; this is the resultant PHP document
 from logging in.  (When I login incorrectly, I get the expected bad
 password massage instead.)
 
 I have turned the trace level up to 5 on the dbmail-imapd server.
 Unfortunately, it does not log the responses to client commands, only
 the commands themselves.  (Feature request?)  But here are the four
 commands I see from the client.  Does this look strange to anyone?
 
 A001 LOGIN tld_domain__user password
 A002 CAPABILITY
 . LIST INBOX 
 A003 LOGOUT
 
 The IMAP server logs do not show any errors.  It can talk to MySQL just
 fine, etc.  (The POP3 daemon works fine, and I can use this mailbox via
 IMAP in Mozilla 1.6 without problems.)  I created the account with this
 command line:
 
 $ dbmail-adduser a tld_domain__user {crypt:}password 0 0
  [EMAIL PROTECTED]
 
 I have made no changes to the user, mailboxes, or any other tables
 by hand.  All flags in the INBOX row for this account are set to 0 (the
 default for all), and 'permission' is 2 (the default).
 
 Does anybody see any configuration error on my part with DBMail?  Has
 anyone seen this exact problem before?  Thanks for your attention; I
 promise to post the resolution when I reach it.
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
 --- Msg sent via @Mail - http://atmail.nl/
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail


Re: [Dbmail] Squirrelmail 1.4.2 integration problem w/ dbmail-imapd 1.2.2

2004-03-30 Thread Micah

I should read before I post.. Thanks Lief, I'm looking forward to using the 
new release.. 

On Tuesday 30 March 2004 08:20 am, Leif Jackson wrote:
 Augusto  Micah,

   This issues has to do with the fact that until dbmail 2.1 (where they
 will add my sort patch), dbmail lacks support for the server side sort.
 I have a patch for the functinality required for squirrel mail for
 2.0rc4 but it is only functional, not fully optimized due to some onther
 internals we will be chaning for 2.1 devlopment cycle. Every time
 squirrelmail connects to the imap server it must download all message
 headers and then sort them in php and then return to your browser the 25
 you want to see. This currently cannot be overcome with dbmail 1.x, and
 only with my beta patch to 2.0rc4.

 Thanks,
 Leif Jackson.

  Micah,
 
  I'm running the very same configuration here - SM 1.4.2 and dbmail 1.2.5.
  Have you experienced perfomance problems?
  For benchmarking purposes, i created 30 folders and filled each one of
  them with 100 to 1500 messages (a total of 16000 messages) - it's
  extremeley slow - taking almost 40 seconds to show the folder list. I
  the other hand i took the messages from an uw-imap (again, 30 folders,
  16000 messages) - it took only 3 secs to show me the folder bar.
 
  Any tips on perfomance would be greatly appreciated.
 
  Augusto Bott
 
  Micah wrote:
 I'm running SM 1.4.2 with the dbmail 1.2.5 distro, and it's working
  great. I
 didn't have to do anything special to get it to work either, I did set
  the
 IMAP server to 'other' is all, everything else was standard.
 
 -Micah
 
 On Monday 29 March 2004 04:20 pm, James XMS wrote:
 I started seeing this issue with the release of 1.4.
 When i was using 1.2.x it was working fine. Maybe give 1.2.x a go to see
  if
 the same happenes to you?
 
 Cheers
 James
 
 On Mon, 29 Mar 2004 16:43 , Micah [EMAIL PROTECTED] sent:
 I'd say it's likely a php session issue.. IMAP errors will not cause
  this
 error. It's caused when you access a protected page with no session
 information. Check the normal session stuff, cookies, passed SID's
  stuff
 like that.
 
 hope that helps.
 
 -Micah
 
 On Monday 29 March 2004 03:14 pm, Will Berry wrote:
 I have posted this problem to the SquirrelMail list already, but I am
 starting to question my initial assumption that it is a SM
  configuration
 problem.  I am starting to wonder whether I am doing something wrong
  on
 the DBMail side.  I could not find anything like this in the archives.
 We are preparing to deploy SM for our customers and I've got an
  install
 on our test box.  All services are running on the same box (MySQL,
 Apache, Postfix/DBMail, etc.), and the browser is on the same box as
 well.
 
 The basic problem is that when I correctly login to Squirrelmail I get
 an error message: You must be logged in to access this page.  This
  is
 not an HTTP authentication window; this is the resultant PHP document
 from logging in.  (When I login incorrectly, I get the expected bad
 password massage instead.)
 
 I have turned the trace level up to 5 on the dbmail-imapd server.
 Unfortunately, it does not log the responses to client commands, only
 the commands themselves.  (Feature request?)  But here are the four
 commands I see from the client.  Does this look strange to anyone?
 
 A001 LOGIN tld_domain__user password
 A002 CAPABILITY
 . LIST INBOX 
 A003 LOGOUT
 
 The IMAP server logs do not show any errors.  It can talk to MySQL
  just
 fine, etc.  (The POP3 daemon works fine, and I can use this mailbox
  via
 IMAP in Mozilla 1.6 without problems.)  I created the account with
  this
 command line:
 
 $ dbmail-adduser a tld_domain__user {crypt:}password 0 0
  [EMAIL PROTECTED]
 
 I have made no changes to the user, mailboxes, or any other tables
 by hand.  All flags in the INBOX row for this account are set to 0
  (the
 default for all), and 'permission' is 2 (the default).
 
 Does anybody see any configuration error on my part with DBMail?  Has
 anyone seen this exact problem before?  Thanks for your attention; I
 promise to post the resolution when I reach it.
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
 --- Msg sent via @Mail - http://atmail.nl/
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
  ___
  Dbmail mailing list
  Dbmail@dbmail.org
  https://mailman.fastxs.nl/mailman/listinfo/dbmail

 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail


Re: [Dbmail] Squirrelmail 1.4.2 integration problem w/ dbmail-imapd 1.2.2

2004-03-30 Thread Augusto Bott

Leif,

I *really* need this speedup right now - I'm using dbmail with 
squirrelmail. I'm willing to migrate my dbmail 1.2.5 to the 2.0 RC4 if I 
can apply your speedup patch (server side search) - where can i get it?

Is it bundled in the 2.0 RC4 source?

Thanks in advance,
Augusto Bott

Leif Jackson wrote:


Augusto  Micah,

 This issues has to do with the fact that until dbmail 2.1 (where they
will add my sort patch), dbmail lacks support for the server side sort.
I have a patch for the functinality required for squirrel mail for
2.0rc4 but it is only functional, not fully optimized due to some onther
internals we will be chaning for 2.1 devlopment cycle. Every time
squirrelmail connects to the imap server it must download all message
headers and then sort them in php and then return to your browser the 25
you want to see. This currently cannot be overcome with dbmail 1.x, and
only with my beta patch to 2.0rc4.

Thanks,
Leif Jackson.

 


Micah,

I'm running the very same configuration here - SM 1.4.2 and dbmail 1.2.5.
Have you experienced perfomance problems?
For benchmarking purposes, i created 30 folders and filled each one of
them with 100 to 1500 messages (a total of 16000 messages) - it's
extremeley slow - taking almost 40 seconds to show the folder list. I
the other hand i took the messages from an uw-imap (again, 30 folders,
16000 messages) - it took only 3 secs to show me the folder bar.

Any tips on perfomance would be greatly appreciated.

Augusto Bott


Micah wrote:

   


I'm running SM 1.4.2 with the dbmail 1.2.5 distro, and it's working
great. I
didn't have to do anything special to get it to work either, I did set
the
IMAP server to 'other' is all, everything else was standard.

-Micah

On Monday 29 March 2004 04:20 pm, James XMS wrote:


 


I started seeing this issue with the release of 1.4.
When i was using 1.2.x it was working fine. Maybe give 1.2.x a go to see
if
the same happenes to you?

Cheers
James

On Mon, 29 Mar 2004 16:43 , Micah [EMAIL PROTECTED] sent:


   


I'd say it's likely a php session issue.. IMAP errors will not cause
this
error. It's caused when you access a protected page with no session
information. Check the normal session stuff, cookies, passed SID's
stuff
like that.

hope that helps.

-Micah

On Monday 29 March 2004 03:14 pm, Will Berry wrote:


 


I have posted this problem to the SquirrelMail list already, but I am
starting to question my initial assumption that it is a SM
configuration
problem.  I am starting to wonder whether I am doing something wrong
on
the DBMail side.  I could not find anything like this in the archives.
We are preparing to deploy SM for our customers and I've got an
install
on our test box.  All services are running on the same box (MySQL,
Apache, Postfix/DBMail, etc.), and the browser is on the same box as
well.

The basic problem is that when I correctly login to Squirrelmail I get
an error message: You must be logged in to access this page.  This
is
not an HTTP authentication window; this is the resultant PHP document
   


from logging in.  (When I login incorrectly, I get the expected bad
 


password massage instead.)

I have turned the trace level up to 5 on the dbmail-imapd server.
Unfortunately, it does not log the responses to client commands, only
the commands themselves.  (Feature request?)  But here are the four
commands I see from the client.  Does this look strange to anyone?

A001 LOGIN tld_domain__user password
A002 CAPABILITY
. LIST INBOX 
A003 LOGOUT

The IMAP server logs do not show any errors.  It can talk to MySQL
just
fine, etc.  (The POP3 daemon works fine, and I can use this mailbox
via
IMAP in Mozilla 1.6 without problems.)  I created the account with
this
command line:

$ dbmail-adduser a tld_domain__user {crypt:}password 0 0
[EMAIL PROTECTED]

I have made no changes to the user, mailboxes, or any other tables
by hand.  All flags in the INBOX row for this account are set to 0
(the
default for all), and 'permission' is 2 (the default).

Does anybody see any configuration error on my part with DBMail?  Has
anyone seen this exact problem before?  Thanks for your attention; I
promise to post the resolution when I reach it.


   


___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


 


--- Msg sent via @Mail - http://atmail.nl/
___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


   


___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


 


___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

   



___
Dbmail mailing list
Dbmail@dbmail.org

Re: [Dbmail] Squirrelmail 1.4.2 integration problem w/ dbmail-imapd 1.2.2

2004-03-30 Thread Leif Jackson
Augusto,

 It is not in the 2.0rc4 source, there are a few show stoppers in the rc4
source so you would need to use cvs version.  I will send you the patch
and all details offline.

Thanks,
Leif

 Leif,

 I *really* need this speedup right now - I'm using dbmail with
 squirrelmail. I'm willing to migrate my dbmail 1.2.5 to the 2.0 RC4 if I
 can apply your speedup patch (server side search) - where can i get it?
 Is it bundled in the 2.0 RC4 source?

 Thanks in advance,
 Augusto Bott

 Leif Jackson wrote:

Augusto  Micah,

  This issues has to do with the fact that until dbmail 2.1 (where they
will add my sort patch), dbmail lacks support for the server side sort.
I have a patch for the functinality required for squirrel mail for
2.0rc4 but it is only functional, not fully optimized due to some onther
internals we will be chaning for 2.1 devlopment cycle. Every time
squirrelmail connects to the imap server it must download all message
headers and then sort them in php and then return to your browser the 25
you want to see. This currently cannot be overcome with dbmail 1.x, and
only with my beta patch to 2.0rc4.

Thanks,
Leif Jackson.



Micah,

I'm running the very same configuration here - SM 1.4.2 and dbmail
 1.2.5.
Have you experienced perfomance problems?
For benchmarking purposes, i created 30 folders and filled each one of
them with 100 to 1500 messages (a total of 16000 messages) - it's
extremeley slow - taking almost 40 seconds to show the folder list. I
the other hand i took the messages from an uw-imap (again, 30 folders,
16000 messages) - it took only 3 secs to show me the folder bar.

Any tips on perfomance would be greatly appreciated.

Augusto Bott


Micah wrote:



I'm running SM 1.4.2 with the dbmail 1.2.5 distro, and it's working
great. I
didn't have to do anything special to get it to work either, I did set
the
IMAP server to 'other' is all, everything else was standard.

-Micah

On Monday 29 March 2004 04:20 pm, James XMS wrote:




I started seeing this issue with the release of 1.4.
When i was using 1.2.x it was working fine. Maybe give 1.2.x a go to
 see
if
the same happenes to you?

Cheers
James

On Mon, 29 Mar 2004 16:43 , Micah [EMAIL PROTECTED] sent:




I'd say it's likely a php session issue.. IMAP errors will not cause
this
error. It's caused when you access a protected page with no session
information. Check the normal session stuff, cookies, passed SID's
stuff
like that.

hope that helps.

-Micah

On Monday 29 March 2004 03:14 pm, Will Berry wrote:




I have posted this problem to the SquirrelMail list already, but I
 am
starting to question my initial assumption that it is a SM
configuration
problem.  I am starting to wonder whether I am doing something wrong
on
the DBMail side.  I could not find anything like this in the
 archives.
We are preparing to deploy SM for our customers and I've got an
install
on our test box.  All services are running on the same box (MySQL,
Apache, Postfix/DBMail, etc.), and the browser is on the same box as
well.

The basic problem is that when I correctly login to Squirrelmail I
 get
an error message: You must be logged in to access this page.  This
is
not an HTTP authentication window; this is the resultant PHP
 document


from logging in.  (When I login incorrectly, I get the expected bad


password massage instead.)

I have turned the trace level up to 5 on the dbmail-imapd server.
Unfortunately, it does not log the responses to client commands,
 only
the commands themselves.  (Feature request?)  But here are the four
commands I see from the client.  Does this look strange to anyone?

A001 LOGIN tld_domain__user password
A002 CAPABILITY
. LIST INBOX 
A003 LOGOUT

The IMAP server logs do not show any errors.  It can talk to MySQL
just
fine, etc.  (The POP3 daemon works fine, and I can use this mailbox
via
IMAP in Mozilla 1.6 without problems.)  I created the account with
this
command line:

$ dbmail-adduser a tld_domain__user {crypt:}password 0 0
[EMAIL PROTECTED]

I have made no changes to the user, mailboxes, or any other
 tables
by hand.  All flags in the INBOX row for this account are set to 0
(the
default for all), and 'permission' is 2 (the default).

Does anybody see any configuration error on my part with DBMail?
 Has
anyone seen this exact problem before?  Thanks for your attention; I
promise to post the resolution when I reach it.




___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail




--- Msg sent via @Mail - http://atmail.nl/
___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail




___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail




___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail





Re: [Dbmail] Squirrelmail 1.4.2 integration problem w/ dbmail-imapd 1.2.2

2004-03-30 Thread Will Berry
I have upgraded to dbmail 1.2.5 and rebuilt PHP and I'm still 
experiencing the problem.  I am now thinking that perhaps my PHP 
configuration is at fault.  I realize at this point it's a little 
off-topic, but does anyone see any problems with my configuration below?


PHP build:
$ ./configure --prefix --disable-rpath --enable-safe-mode 
--enable-force-cgi-redirect --enable-discard-path --enable-fastcgi 
--disable-path-info-check --with-mysql --with-openssl --with-imap-ssl 
--with-swf --with-zlib --with-png-dir --enable-mbstring --enable-mbregex 
--with-gettext


(It's version 4.3 so --enable-track-vars is forced on.)

Partial PHP configuration for my test system (the stuff that I think 
might matter):


[PHP]
asp_tags = On
register_globals = On
register_argc_argv = Off
output_buffering = Off
implicit_flush = Off
disable_functions =
expose_php = Off
error_reporting  =  E_ALL  ~E_NOTICE
display_errors = On
post_max_size = 8M
enable_dl = Off
safe_mode = On
safe_mode_gid = Off
safe_mode_include_dir =
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH,LIBPATH
file_uploads = On
upload_max_filesize = 2M

[SQL]
sql.safe_mode = Off

[Session]
session.save_handler = files
session.use_cookies = 1
session.use_only_cookies = 1
session.use_trans_id = 0


Micah wrote:

I'd say it's likely a php session issue.. IMAP errors will not cause this 
error. It's caused when you access a protected page with no session 
information. Check the normal session stuff, cookies, passed SID's stuff like 
that. 

hope that helps. 

-Micah 



On Monday 29 March 2004 03:14 pm, Will Berry wrote:
 


The basic problem is that when I correctly login to Squirrelmail I get
an error message: You must be logged in to access this page.



--
Will Berry
Co-founder, Second Brain website hosting
http://www.secondbrainhosting.com/