Mailing List Archive: DBMail: users

any dbmail test data out there?

Index | Next | Previous | View Threaded

loupicciano at comcast

Apr 30, 2010, 9:36 AM

Post #1 of 7 (726 views)
Permalink

any dbmail test data out there?

Hello dbmailers,

Does anyone have a 'create script' which will populate a dbmail sql repository with a body of test data?
We'd like to build a pre-rationalized testbed as a basis for our other experimentation. Having a set of a few hundred (thousand?) real-world messages, users, graphics, etc., would be useful as a starting point for out newbie ramblings...

Our focus is not on building the dbmail binaries, for the moment.

Many thanks in advance, Lou

paul at nfg

Apr 30, 2010, 1:42 PM

Post #2 of 7 (688 views)
Permalink

Re: any dbmail test data out there? [In reply to]

You could use a spam collection as a source. Not the typical data you'd
regularly want to face but it creates a lot of fuzzy inputs, incorrect
mime, lots of images, etc. Helps create confidence in the mime parser ;-)

To import such a mailbox you can simply do:

cat SPAM|formail -ds /usr/sbin/dbmail-deliver -u testuser

but there's also scripts in the tree to handle that like
test-scripts/testlmtp.py and contrib/mailbox2dbmail

Lou Picciano wrote:
> Hello dbmailers,
>
> Does anyone have a 'create script' which will populate a dbmail sql
> repository with a body of test data?
> We'd like to build a pre-rationalized testbed as a basis for our other
> experimentation. Having a set of a few hundred (thousand?) real-world
> messages, users, graphics, etc., would be useful as a starting point for
> out newbie ramblings...
>
> Our focus is not on building the dbmail binaries, for the moment.
>
> Many thanks in advance, Lou
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

loupicciano at comcast

Apr 30, 2010, 1:52 PM

Post #3 of 7 (683 views)
Permalink

Re: any dbmail test data out there? [In reply to]

Paul -

Thanks for your message - OK, I'll try that at some point. Problem is, we haven't yet been able to build dbmail, hence the question!
Just wanted to get started on some other aspects of our SQL work.

While we're at it, is there a 'grid' of which version of gmime can be used with which version of dbmail? Of course, I'd like to use the latest of each, but I understand this may not be possible - can you clarify? I have some notes on this somewhere, but...

For example, I undersatnd I should not be trying to use gmime 2.5.1 with dbmail-2.2.15; is this correct? which gmime?

Many thanks - Lou

----- Original Message -----
From: "Paul J Stevens" <paul [at] nfg>
To: "DBMail mailinglist" <dbmail [at] dbmail>
Sent: Friday, April 30, 2010 4:42:03 PM GMT -05:00 US/Canada Eastern
Subject: Re: [Dbmail] any dbmail test data out there?

You could use a spam collection as a source. Not the typical data you'd
regularly want to face but it creates a lot of fuzzy inputs, incorrect
mime, lots of images, etc. Helps create confidence in the mime parser ;-)

To import such a mailbox you can simply do:

cat SPAM|formail -ds /usr/sbin/dbmail-deliver -u testuser

but there's also scripts in the tree to handle that like
test-scripts/testlmtp.py and contrib/mailbox2dbmail

Lou Picciano wrote:
> Hello dbmailers,
>
> Does anyone have a 'create script' which will populate a dbmail sql
> repository with a body of test data?
> We'd like to build a pre-rationalized testbed as a basis for our other
> experimentation. Having a set of a few hundred (thousand?) real-world
> messages, users, graphics, etc., would be useful as a starting point for
> out newbie ramblings...
>
> Our focus is not on building the dbmail binaries, for the moment.
>
> Many thanks in advance, Lou
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

paul at nfg

Apr 30, 2010, 2:04 PM

Post #4 of 7 (689 views)
Permalink

Re: any dbmail test data out there? [In reply to]

Lou Picciano wrote:
> Paul -
>
> Thanks for your message - OK, I'll try that at some point. Problem is,
> we haven't yet been able to build dbmail, hence the question!
> Just wanted to get started on some other aspects of our SQL work.
>
> While we're at it, is there a 'grid' of which version of gmime can be
> used with which version of dbmail? Of course, I'd like to use the
> latest of each, but I understand this may not be possible - can you
> clarify? I have some notes on this somewhere, but...
>
> For example, I undersatnd I should not be trying to use gmime 2.5.1 with
> dbmail-2.2.15; is this correct? which gmime?

Check debian/control. It documents the tools required for building and
their versions.

gmime >= 2.4 is api and abi incompatible with gmime < 2.4

So for dbmail-2.2 you need the latest gmime 2.2

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

mysql.jorge at decimal

Apr 30, 2010, 2:05 PM

Post #5 of 7 (690 views)
Permalink

Re: any dbmail test data out there? [In reply to]

Hi Lou,

For example, I undersatnd I should not be trying to use gmime 2.5.1 with dbmail-2.2.15; is this correct? which gmime?

For DBMail 2.2.x it’s GMIME 2.2x also.

h.reindl at thelounge

Apr 30, 2010, 2:13 PM

Post #6 of 7 (689 views)
Permalink

Re: any dbmail test data out there? [In reply to]

On Fedora as example you have two packages and devel-packages
gmime-2.4.3-6.fc11.x86_64
gmime22-2.2.23-8.fc11.x86_64

for dbmail you need gmime22 and gmime22-devel

Am 30.04.2010 23:05, schrieb Jorge Bastos:
> Hi Lou,
>
>
>
> For example, I undersatnd I should not be trying to use gmime 2.5.1 with
> dbmail-2.2.15; is this correct? which gmime?
>
>
>
> For DBMail 2.2.x it’s GMIME 2.2x also.
>
>
>
>
>
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

--

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

Attachments:

signature.asc (0.25 KB)

loupicciano at comcast

Apr 30, 2010, 4:31 PM

Post #7 of 7 (684 views)
Permalink

Re: any dbmail test data out there? [In reply to]

Thanks, guys (Paul, Jorge, Reindl),

It's not a matter of Fedora or prebuilt packages - but that it were! All of this is scratch-built on Solaris SPARC (for the moment).
Never had to deal with asciidoc before, for example!

But thanks for the suggestions. Think I'm on the right track now... Lou

----- Original Message -----
From: "Reindl Harald" <h.reindl [at] thelounge>
To: dbmail [at] dbmail
Sent: Friday, April 30, 2010 5:13:19 PM GMT -05:00 US/Canada Eastern
Subject: Re: [Dbmail] any dbmail test data out there?

On Fedora as example you have two packages and devel-packages gmime-2.4.3-6..fc11.x86_64 gmime22-2.2.23-8.fc11.x86_64 for dbmail you need gmime22 and gmime22-devel Am 30.04.2010 23:05, schrieb Jorge Bastos: > Hi Lou, > > > > For example, I undersatnd I should not be trying to use gmime 2.5.1 with > dbmail-2.2.15; is this correct? which gmime? > > > > For DBMail 2.2.x it’s GMIME 2.2x also. > > > > > > _______________________________________________ > DBmail mailing list > DBmail [at] dbmail > http://mailman.fastxs..nl/cgi-bin/mailman/listinfo/dbmail -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/
_______________________________________________ DBmail mailing list DBmail [at] dbmail http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads