Re: [Dbmail] Dbmail] Dbmail imap speed (is it slower then uwimap)

2003-04-29 Thread WeDBmail User
<>

Re: [Dbmail] All my mails in 1979!!!

2003-04-29 Thread Thomas Sauer
Francisco Lozano wrote: My MTA is Postfix 1.1.11 as shipped with debian woody. My DB back-end is PostgreSQL 7.2.1, but I also have tried with a home-made-compilation of 7.3.2, getting the same problem. I'm using DBMail 1.1, and I followed the config params of the INSTALL file almost exactl

Re: [Dbmail] Dbmail imap speed (is it slower then uwimap)

2003-04-29 Thread Aaron Stone
Thanks, but no credit to me, I was just relaying the existence of this knowledge... there are some much better SQL dabblers here than me! Aaron On Mon, 28 Apr 2003, Jacques Beaudoin wrote: > Right on Aaron > > I just alter my dbmail tables and like you say: > > > Speed increases as dramat

Re: [Dbmail] Dbmail] Dbmail imap speed (is it slower then uwimap)

2003-04-29 Thread Jacques Beaudoin
What is this posting (A zip with no messages) I think it should be deleted from dbmail.org Nobody should open a zip file they dont expect receiving. Jacques WeDBmail User a écrit : > Name: zftank.zip >zftank.zipType: Zip Compressed Data (application/x-zip-compressed) >

[Dbmail] Re: unknown post (was Dbmail imap speed)

2003-04-29 Thread Dave Logan
"Sorry" about that. It came from our demo weDBmail machine. However, using the basic built in tracking, this is the info that I got out of the message: IPAddr 219.140.137.239. Sorry again for any inconvenience. It may have just been a real test, misdirected, or it may have been a deliberate attem

[Dbmail] schema dump

2003-04-29 Thread Robert L. Tom
Paul, Robert L. Tom wrote: > I applied these to my dbmail 1.1 mysql database.. > alter table messages add index (unique_id); <--Got an ERROR right here > alter table messages add index (status); <-- also here. > > But I got an error on the last two lines from mysql saying they > don't exi

Re: [Dbmail] schema dump

2003-04-29 Thread Aaron Stone
The command is mysqldump ;-) Aaron On Tue, 29 Apr 2003, Robert L. Tom wrote: > Paul, > > Robert L. Tom wrote: > > I applied these to my dbmail 1.1 mysql database.. > > > alter table messages add index (unique_id); <--Got an ERROR right here > > alter table messages add index (status); <-

Re: [Dbmail] schema dump

2003-04-29 Thread Paul Stevens
Aaron Stone wrote: The command is mysqldump ;-) mysqldump -d dbmail to be precise. I've attached clean table schema that do not contain any of the redundant indexes, and add the new indexes I published here earlier. Change all the TYPE=InnoDB into TYPE=myisam or simply remove all TYPE=In

[Dbmail] Script for user password changes

2003-04-29 Thread Ken
Hello, I am looking for a starting point for building or installing a script that will allow email users to change their passwords. Any ideas welcomed. - Ken __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com

Re: [Dbmail] schema dump

2003-04-29 Thread Jesse Norell
Hello, > CREATE TABLE users ( > user_idnr bigint(21) NOT NULL auto_increment, > userid varchar(100) NOT NULL default '', > passwd varchar(32) NOT NULL default '', > client_idnr bigint(21) NOT NULL default '0', > maxmail_size bigint(21) NOT NULL default '0', > encryption_type varchar(20

Re: [Dbmail] Re: unknown post (was Dbmail imap speed)

2003-04-29 Thread Blake Mitchell
In case anyone's worried about what's in the zip file: [EMAIL PROTECTED]:/tmp$ unzip zftank.zip Archive: zftank.zip inflating: zftank/setmap.exe creating: zftank/maps/ inflating: zftank/maps/1.zmp inflating: zftank/maps/2.zmp inflating: zftank/maps/3.zmp inflating:

Re: [Dbmail] schema dump

2003-04-29 Thread Paul Stevens
Jesse, You're right. I have no idea where that one came from. So I've rebuild the tables file. As it is, indexes probably could use some further improvements. Christopher had some ideas about that I think. I'll look into this myself sometime later this week. Also, there appears to be an is