headers
Ilja Booij | 1 Jun 2004 12:43
Picon

Re: Re: Convert spool files / mailbox2dbmail

There's a contrib folder in the sources for dbmail 2.0, if you download 
dbmail 2.0, you can find it there. The tool will also work with dbmail 1.2.x

Ilja

Angus Jordan wrote:

> Hi Dan,
> 
> Where exactly can I find this tool?  I don't see a contrib folder in the 
> dbmail sources....
> 
> Angus
> 
> 
>>Message: 4 
>>Date: Tue, 25 May 2004 15:21:59 -0400 
>>From: Dan Weber <dan <at> mirrorlynx.com> 
>>Subject: Re: [Dbmail] Convert spool files 
>>To: DBMail mailinglist <dbmail <at> dbmail.org> 
>>Message-ID: <40B39CD7.2050806 <at> mirrorlynx.com> 
>>Content-Type: text/plain; charset="iso-8859-1" 
>>
>>contrib/mailbox2dbmail is a tool I wrote.  It should work and 
>>documentation is provided. 
>>
>>Dan Weber 
>>
>>Angus Jordan wrote: 
>>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Larry Rosenman | 2 Jun 2004 13:14
Gravatar

Re: Filtering incoming mail.

On Sat, 29 May 2004, Leander Koornneef, IC&S wrote:

> Hi Larry,
>
> this is already possible with current versions of dbmail, although it is not 
> a native dbmail thing....
>
> Create an alias in the aliases table:
>
> 	"INSERT INTO aliases VALUES ('', 'me <at> mydomain.org', 
> '|/usr/bin/procmail /path/to/procmail.rc', '<client-id>');"
>
> or use dbmail-adduser :-)
>
> In your procmail.rc file, you can insert the message back into dbmail after 
> filtering with the dbmail-smtp command:
>
> 	| dbmail-smtp -m <mailbox> -u <username>
>
Hrm.  What about the "default"?   (I.E. currently things fall through
procmail to /var/mail/ler, and with this setup I'd like them to 
fall through to INBOX.

Also, is there a convienient way to rename a whole bunch of folders and create
new ones?

I.E.  I archive my entire set of folders every month by year/month/name
and start fresh.
Permalink | Reply | 1 comment |
headers
Paul J Stevens | 2 Jun 2004 13:50
Picon
Favicon
Gravatar

Re: Filtering incoming mail.


> Hrm.  What about the "default"?   (I.E. currently things fall through
> procmail to /var/mail/ler, and with this setup I'd like them to fall 
> through to INBOX.

So? Add a catch-all rule for INBOX to your procmailrc. Won't that do it for you?

> Also, is there a convienient way to rename a whole bunch of folders and 
> create
> new ones?

Use raw SQL to rename your current folderset:

something along the lines of:

update mailboxes mb, users u set mb.name = 
concat("archive/",date_format(now(),"%Y%m%d"),"/",mb.name) where mb.owner_idnr = 
u.user_idnr and u.userid = 'someuser';

which is probably a mysql-ism.

> I.E.  I archive my entire set of folders every month by year/month/name
> and start fresh.

Having moved your folders out of the way, dbmail2 will happily recreate folders 
as required.

--

-- 
   ________________________________________________________________
   Paul Stevens                                         paul <at> nfg.nl
(Continue reading)

Permalink | Reply | 0 comments |
headers
Larry Rosenman | 2 Jun 2004 19:51
Gravatar

DBMail on UnixWare

Is the DBMail developers interested in NON-GCC compiles on 
UnixWare?

I had to change all __FUNCTION__ to __func__ (which is the way
C99 spells it), as well as comment out the __attribute__ lines.

I also needed to add -L/usr/ucblib -lucb to a lot of links for
the setlinebuf() function.

We should probably make both of these AutoConf changes...

Oh, I also needed to remove the -fomit-frame-pointer option
as it's not valid on UnixWare.

I can supply an account for y'all if you'd like one.

I have postgreSQL as the DB.

Seems(!) to work in some quickie tests.

Thanks!

LER

--

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler <at> lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
Permalink | Reply | 4 comments |
headers
Ilja Booij | 3 Jun 2004 09:56
Picon

Re: DBMail on UnixWare

Hi,

NB: I've posted this on dbmail-dev also, as it seems to be more 
appropriate there.

Larry Rosenman wrote:
> Is the DBMail developers interested in NON-GCC compiles on 
> UnixWare?

I like to be as portable as possible.
> 
> I had to change all __FUNCTION__ to __func__ (which is the way
> C99 spells it), as well as comment out the __attribute__ lines.

I just checked, and __func__ also works on gcc. If __func__ is standard 
in C99, and works in gcc, we might as well replace all instances of
__FUNCTION__ with __func__

The __attribute__ lines are GCC dependent and should be surrounded by 
preprocessor guards. This is done correctly in dbmail.h (example below), 
but not in all places.

#ifdef __GNUC__
#define UNUSED __attribute__((__unused__))
#else
#define UNUSED
#endif
> 
> I also needed to add -L/usr/ucblib -lucb to a lot of links for
> the setlinebuf() function.
(Continue reading)

Permalink | Reply | 2 comments |
headers
Larry Rosenman | 3 Jun 2004 11:14
Gravatar

Re: DBMail on UnixWare

On Thu, 3 Jun 2004, Ilja Booij wrote:

> Hi,
>
> NB: I've posted this on dbmail-dev also, as it seems to be more appropriate 
> there.
>
> Larry Rosenman wrote:
>> Is the DBMail developers interested in NON-GCC compiles on UnixWare?
>
> I like to be as portable as possible.
>> 
>> I had to change all __FUNCTION__ to __func__ (which is the way
>> C99 spells it), as well as comment out the __attribute__ lines.
>
> I just checked, and __func__ also works on gcc. If __func__ is standard in 
> C99, and works in gcc, we might as well replace all instances of
> __FUNCTION__ with __func__

Yes, I believe that it should be __func__ if GCC supports it.  (I use
the native compiler on UnixWare).

>
> The __attribute__ lines are GCC dependent and should be surrounded by 
> preprocessor guards. This is done correctly in dbmail.h (example below), but 
> not in all places.
>
> #ifdef __GNUC__
> #define UNUSED __attribute__((__unused__))
> #else
(Continue reading)

Permalink | Reply | 0 comments |
headers
Ilja Booij | 4 Jun 2004 11:34
Picon

DBMail 1.2.8

DBMail 1.2.8 has arrived! Changes in this release are:

     * build.sh now uses pg_config or mysql_config to find include and 
library directories.
     * Authentication code now properly escapes usernames before putting 
them in queries, thereby avoiding the risk of SQL-injection.
     * The create tables-scripts for MySQL have been changed, so they 
will now work on MySQL 4.1.x

As ever, you can get this release from the download page
Permalink | Reply | 0 comments |
headers
Carl Fearby | 7 Jun 2004 15:08

problem with installation

Hi im having a problem installing on SME server from mitel i get the following errror
 
 
cc      -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -DHAVE_ENDIAN_H -DHAVE_CRYPT_H main.c -o dbmail-smtp list.o debug.o pipe.o mime.o mysql/dbmysql.o dbmd5.o md5.o bounce.o forward.o memblock.o mysql/dbauthmysql.o config.o misc.o -L/usr/lib/mysql -I/usr/include/mysql -I. -lmysqlclient -lz -lcrypt -lnsl -lm
/usr/bin/ld: cannot find -lz
collect2: ld returned 1 exit status
make: *** [smtp] Error 1
Sorry, Make failed.
Please report any problems to the mailing list: dbmail <at> dbmail.org
You can find more information (including how to subscribe to the mailinglist) on www.dbmail.org
 
can anyone help me out on this
 
regards
 
Carl Fearby
_______________________________________________
Dbmail mailing list
Dbmail <at> dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Permalink | Reply | 3 comments |
headers
Ilja Booij | 7 Jun 2004 15:17
Picon

Re: problem with installation

You probably don't have zlib development libraries installed. I don't 
know what type of distribution SME is, but zlib development libraries 
are probably in a package named zlib-dev (or something similar).

Ilja

Carl Fearby wrote:

> 
> Hi im having a problem installing on SME server from mitel i get the 
> following errror
>  
>  
> cc      -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -DHAVE_ENDIAN_H 
> -DHAVE_CRYPT_H main.c -o dbmail-smtp list.o debug.o pipe.o mime.o 
> mysql/dbmysql.o dbmd5.o md5.o bounce.o forward.o memblock.o 
> mysql/dbauthmysql.o config.o misc.o -L/usr/lib/mysql 
> -I/usr/include/mysql -I. -lmysqlclient -lz -lcrypt -lnsl -lm
> /usr/bin/ld: cannot find -lz
> collect2: ld returned 1 exit status
> make: *** [smtp] Error 1
> Sorry, Make failed.
> Please report any problems to the mailing list: dbmail <at> dbmail.org 
> <mailto:dbmail <at> dbmail.org>
> You can find more information (including how to subscribe to the 
> mailinglist) on www.dbmail.org <http://www.dbmail.org>
>  
> can anyone help me out on this
>  
> regards
>  
> Carl Fearby
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Dbmail mailing list
> Dbmail <at> dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
Permalink | Reply | 2 comments |
headers
Carl Fearby | 7 Jun 2004 15:29

RE: problem with installation

Yeah I have fixed it now. Thanks !

-----Original Message-----
From: dbmail-bounces <at> dbmail.org [mailto:dbmail-bounces <at> dbmail.org] On Behalf
Of Ilja Booij
Sent: 07 June 2004 14:18
To: DBMail mailinglist
Subject: Re: [Dbmail] problem with installation

You probably don't have zlib development libraries installed. I don't 
know what type of distribution SME is, but zlib development libraries 
are probably in a package named zlib-dev (or something similar).

Ilja

Carl Fearby wrote:

> 
> Hi im having a problem installing on SME server from mitel i get the
> following errror
>  
>  
> cc      -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -DHAVE_ENDIAN_H 
> -DHAVE_CRYPT_H main.c -o dbmail-smtp list.o debug.o pipe.o mime.o
> mysql/dbmysql.o dbmd5.o md5.o bounce.o forward.o memblock.o 
> mysql/dbauthmysql.o config.o misc.o -L/usr/lib/mysql 
> -I/usr/include/mysql -I. -lmysqlclient -lz -lcrypt -lnsl -lm
> /usr/bin/ld: cannot find -lz
> collect2: ld returned 1 exit status
> make: *** [smtp] Error 1
> Sorry, Make failed.
> Please report any problems to the mailing list: dbmail <at> dbmail.org 
> <mailto:dbmail <at> dbmail.org>
> You can find more information (including how to subscribe to the 
> mailinglist) on www.dbmail.org <http://www.dbmail.org>
>  
> can anyone help me out on this
>  
> regards
>  
> Carl Fearby
> 
> 
> ----------------------------------------------------------------------
> --
> 
> _______________________________________________
> Dbmail mailing list
> Dbmail <at> dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmail <at> dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Permalink | Reply | 0 comments |

Gmane