[Dbmail] Deleting users with SQL

2011-06-27 Thread Oswaldo
that delete records when the user/alias are deleted. When are deleted from there? Are deleted by dbmail-util? Do i need to do anything more? Versions: Debian GNU/Linux 6.0 DBMail version 2.2.11 Postgresql 8.4 Thanks -- Oswaldo ___ DBmail mailing l

Re: [Dbmail] Deleting users with SQL

2011-06-27 Thread Oswaldo
El 27/06/2011 20:02, Paul J Stevens escribió: On 06/27/2011 06:52 PM, Oswaldo wrote: Is sufficient to remove the user delete it from dbmail_aliases and dbmail_users tables? Yes. Viewing the database model (<http://www.dbmail.org/dokuwiki/doku.php/er-model>) the table dbmail_physmessa

Re: [Dbmail] Webmail client: squirrelmail, roundcube, egroupware?

2012-01-17 Thread Oswaldo
El 17/01/2012 16:37, Gordan Bobic escribió: Thomas Raschbacher wrote: I know this has been asked before but which webmail client are people using with dbmail and why? Roundcube. Last time I tried various webmails it seemed to be the most polished one. +1 -- Oswaldo

[Dbmail] Clearing mailbox

2012-05-09 Thread Oswaldo
Hello, I'm trying to clear the inbox for an user. To do it i execute: #dbmail-export -u TheUserId -m INBOX -d -o /tmp/in.mbox #dbmail-util -dpy /tmp/in.mbox is created but the inbox is not cleared. ¿What is the correct way? I'm using dbmail 2.2.11 with PostgreSQL Thanks

Re: [Dbmail] Clearing mailbox

2012-05-09 Thread Oswaldo
El 09/05/2012 9:54, Paul J Stevens escribió: On 05/09/2012 09:44 AM, Oswaldo wrote: Hello, I'm trying to clear the inbox for an user. To do it i execute: #dbmail-export -u TheUserId -m INBOX -d -o /tmp/in.mbox #dbmail-util -dpy from dbmail-util(8) -p:: Purge messages with DELETE s

Re: [Dbmail] Clearing mailbox

2012-05-09 Thread Oswaldo
El 09/05/2012 9:54, Paul J Stevens escribió: On 05/09/2012 09:44 AM, Oswaldo wrote: Hello, I'm trying to clear the inbox for an user. To do it i execute: #dbmail-export -u TheUserId -m INBOX -d -o /tmp/in.mbox #dbmail-util -dpy Opss!! Checking the inbox with the client app (roun

[Dbmail] Migration questions

2010-09-14 Thread Oswaldo Hernández
accounts. I have configured exim4 to forward or send copies of mail to accounts saved in the dadabase. Can do dbmail these job? 7. I'm also planning to install mailman. Any problem? Sorry for the long message and for mi bad english. Thanks -- Oswaldo Hernández __

Re: [Dbmail] Migration questions

2010-09-30 Thread Oswaldo Hernández
El 14/09/2010 23:29, Jesse Norell escribió: > On Tue, 2010-09-14 at 21:15 +0200, Oswaldo Hernández wrote: >> Hello, >> >> I'm planning to migrate and old debian server to a new machine with >> debian 5 and dbmail/postgresql. >> >> Before makig the mig

[Dbmail] dbmail - exim4 configuration

2010-09-30 Thread Oswaldo Hernández
doing anything bad? Thanks -- Oswaldo Hernández ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] dbmail - exim4 configuration

2010-09-30 Thread Oswaldo Hernández
El 30/09/2010 18:31, Oswaldo Hernández escribió: > Hello, > > I install dbmail from debian 5 dist (version: 2.2.10-1+b1). > > I create the database (postgresql) and tables Ok, create one user and > load a mailbox using mbox2dbmail script OK, test as pop3 server with > thu

Re: [Dbmail] dbmail - exim4 configuration

2010-10-01 Thread Oswaldo Hernández
El 30/09/2010 21:39, Paul J Stevens escribió: > I dont use exim myself, but please update the wiki, for future reference. > Ok. I will do it when finish the server configuration and test it. Regards. -- Oswaldo Hernández ___ DBmail mailing list

[Dbmail] mbox2dbmail , slow load mailboxes

2010-10-11 Thread Oswaldo Hernández
Hello, I have 50 GB in about 200 mbox files In 20 hours mbox2dbmail imports 21 GB. Are there any other faster way? Thanks, -- Oswaldo Hernández ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] mbox2dbmail , slow load mailboxes

2010-10-11 Thread Oswaldo Hernández
ript to process an entire directory with mailboxes. The problem is that the load process is slow. Is there any document that describes table structure to try to insert the messages directly instead of using dbmail-smtp? Thanks. -- Oswaldo Hernández

Re: [Dbmail] mbox2dbmail , slow load mailboxes

2010-10-11 Thread Oswaldo Hernández
re marked as 'unread'. How can i mark it as 'readed'? Thanks, -- Oswaldo Hernández ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] mbox2dbmail , slow load mailboxes

2010-10-11 Thread Oswaldo Hernández
UPDATE dbmail_messages SET recent_flag=0, seen_flag=1 where message_idnr = 466779 AND status < 2 AND mailbox_idnr = 157 I will try to make a script that do it with readed messages. Thanks. -- Oswaldo Hernández ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] mbox2dbmail , slow load mailboxes

2010-10-11 Thread Oswaldo Hernández
El 11/10/2010 20:16, Reindl Harald escribió: > > > Am 11.10.2010 19:56, schrieb Oswaldo Hernández: >> El 11/10/2010 19:13, Reindl Harald escribió: >>> i would recommend "imapsync" to migrate from the old server to a new >>> Even on the same machine