[Dbmail] Dropping characters.

2002-09-24 Thread Micah Stevens
I know this isn't directly related to dbmail, but the people on the php-db mailing list aren't being too helpful and I was wondering if anyone here had any ideas. I've been having an issue where php will drop the first four characters from a POSTed form field when inserting/updating informatio

RE: [Dbmail] Dropping characters.

2002-09-24 Thread Michael Rose, Jr.
Michael Rose, Jr. Office: (206) 686-7600 Fax: (206) 374-8126 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Micah Stevens Sent: Monday, September 23, 2002 3:00 PM To: dbmail@dbmail.org Subject: [Dbmail] Dropping characters. I know thi

RE: [Dbmail] Dropping characters.

2002-09-24 Thread Michael Rose, Jr.
Use phpinfo(); to figure out if the missing four characters are being lost in PHP or when you're doing the INSERT or UPDATE into mysql. Also try doing the INSERT/UPDATE via the mysql command line. Michael -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [Dbmail] Dropping characters.

2002-09-24 Thread Micah Stevens
It's definitely something with the php interface. If I do anything at the command line, with MySQL, it works fine. I attached the phpinfo() output. I'm not sure how I'm supposed to directly use that to figure out if the characters are being lost by PHP. I did notice however, that after an att

RE: [Dbmail] Dropping characters.

2002-09-24 Thread Micah Stevens
Here's the attachment. At 03:20 PM 9/23/2002 -0700, you wrote: Use phpinfo(); to figure out if the missing four characters are being lost in PHP or when you're doing the INSERT or UPDATE into mysql. Also try doing the INSERT/UPDATE via the mysql command line. Michael -Original Message

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Hi, We have noticed that and make some tests with several Webmail and mail clients as Netscape, Outlook, vs courier-imap with the same mail clients. First conclusions the PHPs' webmails are very slow except Squirrelmail because it use its own imap libraries instead of PHP-IMAP. But it's true Cour

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Micah Stevens
Just a note, on your query comments, although I'm not arguing with your basic point, it's always been my understanding that SELECT statements that use '*' instead of stating field names are slower. If you don't specify the field names the database has to spend time figuring out what they are, bu

[Dbmail] Amavisd-new

2002-09-24 Thread Butch Evans
I am trying to find the mailing list for amavisd-new-20020630. Anyone know where I can find a list or contact for assistance getting this program running? -- Butch Evans 573-293-2638 BPS Networks PO BOX 550 114 W Main Bernie, MO 63822

RE: [Dbmail] Amavisd-new

2002-09-24 Thread Michael Rose, Jr.
Wouldn't it be part of the existing mailing list? http://lists.sourceforge.net/lists/listinfo/amavis-user Michael Rose, Jr. Office: (206) 686-7600 Fax: (206) 374-8126 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Butch Evans Sent: M

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread eric
On Mon, 23 Sep 2002 18:48:33 -0700 in message <[EMAIL PROTECTED]>, Micah Stevens <[EMAIL PROTECTED]> wrote: > Just a note, on your query comments, although I'm not arguing with your > basic point, it's always been my understanding that SELECT statements that > use '*' instead of stating field na

Re: [Dbmail] Amavisd-new

2002-09-24 Thread Bret Baptist
On Monday 23 September 2002 11:28 pm, Michael Rose, Jr. wrote: > Wouldn't it be part of the existing mailing list? > > http://lists.sourceforge.net/lists/listinfo/amavis-user This is correct. Bret. -- Bret Baptist Systems and Technical Support Specialist [EMAIL PROTECTED] Internet Exposure, In

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Micah Stevens ([EMAIL PROTECTED]) wrote: > >Just a note, on your query comments, although I'm not arguing with your >basic point, it's always been my understanding that SELECT statements that >use '*' instead of stating field names are slower. If you don't specify the >field names the database has

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Roel Rozendaal
Why use messageblks? Well, for one reason, mysql has a limit on the record size so a split-up is necessary anyway. The system was chosen to handle big messages in chunks. - Original Message - From: "Sam Przyswa" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 24, 2002 3:52 PM Subject: RE

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
eric ([EMAIL PROTECTED]) écrivait: > >On Mon, 23 Sep 2002 18:48:33 -0700 in message <[EMAIL PROTECTED]>, Micah Stevens <[EMAIL PROTECTED]> wrote: >> Just a note, on your query comments, although I'm not arguing with your >> basic point, it's always been my understanding that SELECT statements that

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Roel Rozendaal ([EMAIL PROTECTED]) écrivait: > >Why use messageblks? Well, for one reason, mysql has a limit on the record >size so a split-up is necessary anyway. The system was chosen to handle big >messages in chunks. > Ok, I guessed that there is a good reason to do that, but it's possible to

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Roel Rozendaal
The basic layout for dbmail was based upon pop3 but we are interested in better schemes for imap. One of the main goals right now is to have the fastest imap server around. Better table layouts would mean a great improvement; just don't know how much time will be involved in implementing those. Thi

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Roel Rozendaal ([EMAIL PROTECTED]) écrivait: > >The basic layout for dbmail was based upon pop3 but we are interested in >better schemes for imap. One of the main goals right now is to have the >fastest imap server around. Better table layouts would mean a great >improvement; just don't know how mu

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Ryan Butler
On Tue, 2002-09-24 at 10:48, Sam Przyswa wrote: > >Unless your program is getting back the rows as name value pairs and picking > through what gets sent back, you want to be specifying the columns and the > order > that they are to be sent back, not asking for everything and assuming that the > o

[Dbmail] dbmail and some possibilities?

2002-09-24 Thread Sing-On
Hello, community! I tried using dbmail (it`s the single thing in area loging emails), but I had some questions. 1. It`s very intresting for me to install dbmail on sendmail daemon. 2. It`s posible to put into DB not only input emails (for local users), but output email? 3. And it`s posible to o

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Roel Rozendaal
Honestly I don't think using "select " or "select *" is a big speed difference - it's more like the ultimate fine tuning. I think dramatic results can be achieved by developing a table layout/imap logic that minimizes the number of queries and the amount of parsing done by the imap server. On Tue

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Mike Watkins
Parsing is definitely the issue. I wrote a very simple Python application to parse headers in my dbmail inbox - a run against 50 messages takes about 4 seconds on a very fast box, using standard Python libraries. The question is, what's more important - message insertion or subsequent processi

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Mark Mackay
On 25/9/02 4:21 AM, "Roel Rozendaal" <[EMAIL PROTECTED]> wrote: > The basic layout for dbmail was based upon pop3 but we are interested in > better schemes for imap. One of the main goals right now is to have the > fastest imap server around. Better table layouts would mean a great > improvement;

[Dbmail] Additional wishlist

2002-09-24 Thread Mark Mackay
+ Purging deleted messages based on a time different: Currently status is set to 03 meaning deleted. This allows the dbmail-maintenance script to clear all deleted messages each night or whenever the script is run. If this field could be changed to a timestamp (or treated as a timestamp, where val

[Dbmail] Pop locks

2002-09-24 Thread Mark Mackay
Just checking so I can brief our helpdesk, I'm assuming dbmail does not lock the pop sessions to prohibit the same user from relogging in while another session is active. >From my tests, it looks like any destructive change (eg deleting a message Status: O is honoured immediately upon a client ex