Re: [Dbmail] Train Spamassassin

[Ryan Butler]

There's also a dbmail-export command isn't there to turn it into mbox files?


On Wed, Jan 4, 2017 at 5:21 PM, Reindl Harald 
wrote:

>
>
> Am 04.01.2017 um 22:32 schrieb Claas Kähler:
>
>> Okay this part is easy, but how could i extract samples from dbmail to
>> put them into a folder?
>>
>
> by IMAP - you are not supposed to directyl access email via mysql since
> you underestimate the complexity of the strcuture and must not rely on
> internal aka non-public API's
>
> Am 04.01.17 um 22:26 schrieb Reindl Harald:
>>
>>
>>>
>>> Am 04.01.2017 um 20:50 schrieb Claas Kähler:
>>>
 Hallo everybody,

 I have a serious Spam-Problem and I want to feed sa-learn with those
 Spam-mails to get rid of it.

 Has someone found a solution to train Spamassassin with data from
 DBMail?

>>>
>>> just put your samples in folders and use "sa-learn" with the correct user
>>>
>>>
>>> [root@mail-gw:~]$ bayes-stats.sh
>>> 0  81476SPAM
>>> 0  25659HAM
>>> 03227434TOKEN
>>>
>>> insgesamt 376M
>>>  24K -rw-r- 1 sa-milt sa-milt  24K 2017-01-04 16:29 bayes_seen
>>>  65M -rw-r- 1 sa-milt sa-milt  81M 2017-01-04 16:29 bayes_toks
>>> 312M -rw-r- 1 sa-milt sa-milt 312M 2017-01-04 16:29 wordlist.db
>>>
>>> BAYES_00 1682   58.99 %
>>> BAYES_05   842.94 %
>>> BAYES_20   812.84 %
>>> BAYES_40  1043.64 %
>>> BAYES_50  394   13.81 %
>>> BAYES_60   561.96 % 9.75 % (OF TOTAL BLOCKED)
>>> BAYES_80   602.10 %10.45 % (OF TOTAL BLOCKED)
>>> BAYES_95   381.33 % 6.62 % (OF TOTAL BLOCKED)
>>> BAYES_99  352   12.34 %61.32 % (OF TOTAL BLOCKED)
>>> BAYES_999 2859.99 %49.65 % (OF TOTAL BLOCKED)
>>>
>>> DELIVERED5104   91.91 %
>>> DNSWL4984   89.75 %
>>> SPF  4088   73.61 %
>>> SPF/DKIM WL  2250   40.51 %
>>> SHORTCIRCUIT 2690   48.44 %
>>>
>>> BLOCKED   574   10.33 %
>>> SPAMMY5069.11 %88.15 % (OF TOTAL BLOCKED)
>>>
>> ___
> DBmail mailing list
> DBmail@dbmail.org
> http://lists.nfg.nl/mailman/listinfo/dbmail
>
___
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail

Re: [Dbmail] imapd gobbling memory

[Ryan Butler]

On Fri, 2006-12-08 at 04:01 -0800, Michael Dean wrote:
 Ryan, which imapd are you running again?

Path: .
URL: https://svn.ic-s.nl/svn/dbmail/branches/dbmail_2_2_branch
Repository Root: https://svn.ic-s.nl/svn/dbmail
Repository UUID: 7b491191-dbf0-0310-aff6-d879d4d69008
Revision: 2361
Node Kind: directory
Schedule: normal
Last Changed Author: aaron
Last Changed Rev: 2361
Last Changed Date: 2006-11-08 03:45:19 -0600 (Wed, 08 Nov 2006)


Ryan

Re: [Dbmail] imapd gobbling memory

[Ryan Butler]

On Tue, 2006-12-05 at 21:47 +0100, Paul J Stevens wrote:
 Justin McAleer wrote:
  
  Per my other email in this thread, issue 462 was opened
  on 11/29/06 about this problem.
 
 Justin, please upload a loglevel 5 trace containing some FETCH commands.
 

Just as another datapoint, I've been seeing this since going to 2.2.x as
well.

Here is my largest process:

 9853 dbmail15   0  679m  46m  660 S  0.0  9.3   5:33.60
dbmail-imapd

679 meg!

There's only about 12 people who use this on a mail store of about 3 or
4 gig.  Most are running either thunderbird or evolution.  The process
was started sometime on the 6th so it's only a day old.  This is just
regular client traffic, no imapsync or large copy/moves.


Ryan

Re: [Dbmail] Problem converting 2.0.x to 2.1

[Ryan Butler]

I went ahead and filed it as a bug report as well so that it gets
properly tracked and is a reminder.

Ryan


On Thu, 2006-11-02 at 19:01 +0100, Paul J Stevens wrote:
 Ryan Butler wrote:
  On Wed, 2006-11-01 at 22:37 +0100, Paul J Stevens wrote:
  Repairing DBMAIL for cached envelopes...
  Ok. Found [120614] missing envelope values.
  GLib-ERROR **: gmem.c:172: failed to allocate 536870912 bytes
  aborting...
  Aborted
 
  Yeah. GLib is allocating way too much memory here. I'll fix this tomorrow.
 
 
 
  
  I'll try to watch WebSVN for when this gets changed, but if you could
  reply as well when you get it fixed that would be great.
 
 
 will do.
 
 

Re: [Dbmail] Problem converting 2.0.x to 2.1

[Ryan Butler]

On Wed, 2006-11-01 at 22:37 +0100, Paul J Stevens wrote:
  Repairing DBMAIL for cached envelopes...
  Ok. Found [120614] missing envelope values.
  GLib-ERROR **: gmem.c:172: failed to allocate 536870912 bytes
  aborting...
  Aborted
 
 
 Yeah. GLib is allocating way too much memory here. I'll fix this tomorrow.
 
 
 

I'll try to watch WebSVN for when this gets changed, but if you could
reply as well when you get it fixed that would be great.

Thanks

Ryan Butler

[Dbmail] Problem converting 2.0.x to 2.1

[Ryan Butler]

When running dbmail-util -by, during the envelope cache creation:

GLib-ERROR **: gmem.c:172: failed to allocate 536870912 bytes


top doesn't show the system especially low on swap at the time this
happens...

Repairing DBMAIL for cached envelopes...
Ok. Found [120614] missing envelope values.
GLib-ERROR **: gmem.c:172: failed to allocate 536870912 bytes
aborting...
Aborted


System has 512 meg of RAM and 1 gig of swap.

Suggestions?

Ryan Butler

Re: [Dbmail] Problem converting 2.0.x to 2.1

[Ryan Butler]

I should mention this is the latest 2.2? svn from this morning (the
trunk, no branch specified)

On Wed, 2006-11-01 at 15:03 -0600, Ryan Butler wrote:
 When running dbmail-util -by, during the envelope cache creation:
 
 GLib-ERROR **: gmem.c:172: failed to allocate 536870912 bytes
 
 
 top doesn't show the system especially low on swap at the time this
 happens...
 
 Repairing DBMAIL for cached envelopes...
 Ok. Found [120614] missing envelope values.
 GLib-ERROR **: gmem.c:172: failed to allocate 536870912 bytes
 aborting...
 Aborted
 
 
 System has 512 meg of RAM and 1 gig of swap.
 
 Suggestions?
 
 Ryan Butler
 
 
 ___
 DBmail mailing list
 DBmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail-dev] [EMAIL PROTECTED]: [DBMail 0000057]: direct mailforwarding with [EMAIL PROTECTED]

[Ryan Butler]

On Thu, 2004-08-12 at 03:09, Ilja Booij wrote:
 Possible Solutions:
 1. allow only INBOX to be created on the fly, by restricting 
 db_find_create_mailbox() to only create INBOX.
 - problem: dbmail-smtp user -m mailbox will not work with non-existing 
 mailboxes anymore.
 

No one seemed to propose this solution, it is a little bit of code bloat
but allows for the feature to stay and not break backwards
functionality, duplicated db_find_create_mailbox() to a different name,
restrict to only create INBOX and have the [EMAIL PROTECTED] use the
new function.  It is an option, but I like so many others prefer the
option chosen which was to back it out totally for the time being.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail-dev] Roadmap to 2.0 changes now in CVS

[Ryan Butler]

On Thu, 2004-07-22 at 01:12, Aaron Stone wrote:
 I've discussed this to death on the mailing lists. Full configurability is
 scheduled for 2.1, in the mean time, we ought to begin rolling out some kind
 of reasonable prefix.
 

This whole feature should be scheduled for 2.1, it's pretty late in the
release candidate stage to be asking everyone who's been tracking it
closely to screw up their interfaces now.

 Third party applications that directly interface with the dbmail tables will
 just have to be updated to the final 2.0 release specification. Those who've
 been following CVS and early release candidates know that changes have been
 made and should be expected until we hit a final stable release.
 

A large number of these changes should be in 2.1 and not 2.0, especially
after 6 or 7 release candidates...

Ryan

Re: [Dbmail-dev] IMAP APPEND fails

[Ryan Butler]

 It might also be a bug on our side. I've just asked this question on 
 comp.mail.imap
 
 Hopefully somebody on that newsgroup can shed some light on this.
 
 Ilja

You might also ask on imap@u.washington.edu as that's the official IMAP
protocol mailing list and Mark Crispin (principal author of the RFC)
answers diligently there.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

[Dbmail-dev] Sourceforge.net buglist

[Ryan Butler]

Anyone know anything further about the 2 bugs open on the sourceforge
page?  are they resolved?  If so I'll close them out.

Ryan

Re: [Dbmail] SMTP Auth

[Ryan Butler]

On Thu, 2004-05-06 at 08:50, Peter Darley wrote:
 Folks,
   I'm having a hard time find out how to set up smtp-auth with Postfix and
 DBMail.  Anyone got any pointers?
 Thanks,
 Peter Darley
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

Here's what you need

You need libsasl2

If you're using debian you need:

libsasl2
libsasl2-modules
libsasl2-modules-sql

You then need to put the following in a smtpd.conf file in
/etc/postfix/sasl (debian) or wherever your sasl config files go for
your operating system (other common places are /usr/lib/sasl2 and
/usr/local/lib/sasl2)

mech_list: PLAIN LOGIN ANONYMOUS
pwcheck_method: auxprop
sql_engine: mysql (or pgsql if you're using postgres)
sql_user: someuser
sql_passwd: somepasswd
sql_hostnames: x.x.x.x
sql_database: your_database
sql_select: select passwd from users where userid = '%u'


Then setup postfix to use sasl as is document readily elsewhere.

You may need to modify the sql_select if you aren't using plaintext
passwords, there's documentation with libsasl2 that tells you all the
different options and syntax.  Much easier to setup than the pam stuff.

Anyhow, these instructions are for debian unstable...  Anything else
should be similar, but with subtle differences.

Also, there was a large change between versions 2.1.15 and 2.1.18 of
libsasl2 on debian.  Version 2.1.15 had a libsasl2-modules-mysql and all
the config prefixes were mysql_* instead of sql_*.  They changed it to a
generic engine for 2.1.18 and it broke my setup and reading the
instructions and noticing the changes were what was needed (debian just
uninstalled libsasl2-modules-mysql instead of replacing it with
libsasl2-modules-sql).

Good luck.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] IRC channel

[Ryan Butler]

irc.freenode.net  /join #dbmail


On Thu, 2004-05-06 at 15:38, Mikael Syska wrote:
 Hey DBMail users,
 
 Like the subject says, IRC channel, is there a channel where the crew and
 other DBmail users hang out, if not, could it be an idea? Or aren't there
 enough there will be on the channel??
 
 How stable is DBmail release 2.0, or are we still advised to use 1.2.7b and
 later then upgrade???
 
 // ouT
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail-dev] rc4 serious bug in dbmail-smtp

[Ryan Butler]

On Tue, 2004-03-23 at 08:02, Ilja Booij wrote:

 
 Another thing: The shared folder stuff does NOT work with Evolution 1.4.
 I can see the mailbox in the folder listing, and even see the number of 
 unread messages (so STATUS also works), but I cannot select the mailbox.
 Why this is the case is unclear to me at the moment. I guess I'll need 
 to do some ngrep-ing
 


Also, rather than using ngrep, you can start mozilla from the command
line after executing:

export CAMEL_VERBOSE_DEBUG=1

and it will display ALL the pop/imap/smtp traffic in the terminal
window.  I pretty much always run my copy in this manner to look for
problems.

Also going back to a previous message, there is a mailing list for the
imap protocol that Mark Crispin reads regularly
(imap@u.washington.edu).  It might be best to go directly to the source
to see whether a NO, BAD, or OK without doing the action is appropriate
for a certain circumstance since RFC's can be at times, rather
ambiguous.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] Dbmail lmtp + Postfix + Amavis-new

[Ryan Butler]

Sure:

smtp-amavis   unix  -   -   y   -   10  lmtp
-o smtp_data_done_timeout=1200
-o disable_dns_lookups=yes
127.0.0.1:10025   inet  n   -   n   -   -   smtpd
-o content_filter=
-o local_recipient_maps=
-o smtpd_helo_restrictions=
-o smtpd_client_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks=127.0.0.0/8
dbmailunix  -   n   n   -   -   pipe
flags=R  user=dbmail:dbmail argv=/usr/local/sbin/dbmail-smtp -d
${recipient}



You'll need the content_filter and transport_maps lines in main.cf:

content_filter = smtp-amavis:[127.0.0.1]:10024

transport_maps = hash:/etc/postfix/transport


You could change the name to lmtp-amavis if you wanted, all that's
important is that lmtp is chosen as the service at the end of the line.


Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

On Tue, 2004-02-10 at 14:09, Jacques Beaudoin wrote:
 Can somebody show me a postfix master.cf file
  to have dbmail , amavis-new and postfix to work together
 
 Thanks
 Jacques
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: [Dbmail] trackrecord

[Ryan Butler]

On Wed, 2003-12-03 at 09:47, Eelco van Beek - ICS wrote:
 Hi all,
 
 We'd like to create a trackrecord of dbmail usage in all it forms and 
 shapes on www.dbmail.org.
 Please reply to this message with your configuration with as much 
 information as you're willing to share!
 
 Thanks,
 
 Eelco
 

1st installation:

3 servers:

smtp/pop3/imap:

PIII 800
Postfix 2.0.10
dbmail-1.1 + account_suspension patch
pop3s, imaps via stunnel
TLS/SASL support in postfix (SASL using pwcheckd method to lookup in
dbmail user table)

webmail:
PII 333
Horde/IMP webmail software (via imap)


sql:

Dual athlon 1.2 ghz
1gig of memory
36 gig of RAID5
MySQL 3.23.54


Approximately 1500 email accounts



2nd installation:

Athlon 1.4 ghz
MySQL 4.0.16
512 meg of ram

Approximately 20 real users, very heavy mailman traffic


Ryan Butler
[EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

[Ryan Butler]

On Wed, 2003-11-05 at 13:04, Chris Carter wrote:
 Hi,
 
 I would like to ask some questions which I have not been able to find
 answers for. I admit I have not installed DBMail but I did see the site
 and the README files in the source code.
 
 1. What are the differences between 1.x versions and the new 2.0 alpha1?
Check the archives, no sense hashing it all out again.

 2. I finally twigged that DBMail does not have an MTA of its own but
 uses external programs (eg: Postfix). True?

True, discussion on making dbmail act like a LMTP server is ongoing and
could be in 2.0.

 3. How does DBMail's IMAP support compare to other packages? Does
 M$Lookout work? Can I use Ximian Evolution? Or Kmail? I presume that POP
 works just fine (but I am interested in IMAP).

OE, Outlook, Evolution work with IMAP, haven't tested the others.

 4. Webmail support? Can I use things like Horde/IMP? How does IMAP
 perform in this situation?

Horde/IMP works fine.

 5. Where does one configure the TCP ports (is it in the database?).

In a configuration file.  Originally it was in the database, but that
made it hard to have separate configs for separate machines without
making some sort of config id the machine could bind to, which would
need to be in a file anyhow, so the configuration of the daemons was
moved to a file.

 6. Is there any documentation?

Some, search the archives, there is some url's listed with informal
documentation.

 7. Has anyone experienced something really awful with DBMail? (be honest
 now :)

Not really, couple bugs here and there, APOP didn't work to begin with,
there was a pop3 bug a while back where if someone logged in to get
their mail, then the session terminated abnormally, the next person to
connect to that daemon process would get the other person's mail.  All
those have been fixed and there is nothing keeping me from using it with
around 3000 email clients


 8. Is it secure to attacks? DoS, etc.?
 

Haven't stressed it to see, I'm sure it can be DoS'd, but so can
everything.

 Sorry for all the hard questions, your information is much appreciated.
 

They aren't hard, they're actually very well documented in the archives
and fairly easy to find.


 Cheers!
 Chris


Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] auth_login problem!

[Ryan Butler]

On Wed, 2003-10-15 at 09:26, [EMAIL PROTECTED] wrote:
 Hello all!
 I use Exim 4.24+Dbmail1.1+Mysql+Drweb!
 If my client use auth_plain - system work properly (all ok!)
 But if use auth_login - in maillog file i see:
 
 Oct 15 18:13:43 myserver exim[46663]: [1\2] 2003-10-15 18:13:43
 auth_login authenticator failed for (programmer) [212.5.102.96]: 435
 Unable to authenticate at present (set_id=myuser): lookup of SELECT
 iuser_idnr FROM users WHERE userid = 'myuser' AND passwd = 'mypassword'
  gave DEFER: MYSQL: query failed: Unknown column 'iuser_idnr' in 'field
 list'
 
 If who know - HELP me pls!!
 

That looks easy, remove the i from infront of user_idnr in the select
statement, it looks like it was added improperly.  DBmail's id colum is
user_idnr, not iuser_idnr by default.  

server_condition = ${lookup mysql{SELECT iuser_idnr FROM users \
  WHERE userid =  \  
   '${quote_mysql:${local_part:$1}}' \
  AND passwd = '${quote_mysql:$2}' \
}

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] DB vs FS [was: Newbie: DBMail for large user base]

[Ryan Butler]

On Tue, 2003-07-29 at 10:05, lou wrote:
  You're still storing it on a disk, so the reliability is the same, store
  your db on a raid5, or store flat files on a raid5 its the same
  thing, raid5 loses more than one disk at a time and you're hosed either
  way, so the only way to be sure is to have archived backups, or hot
  systems (replicated db's).
 
 In order to understand why you have to know what are the probabilities of 
 failure and etc.
 Talking in general having everything in one database (excluding the case of 
 this very
 database being replicated) you've got yourself a single point failure, since 
 with FS is
 bit different (I'm underling _FS_ rather than _disk_, because the database 
 itself is
 dependable on both of them excluding the cases when you run database in the 
 RAM disk or
 NAS), granulating the FS in different partitions gives you more redundancy 
 and in some
 cases more security (not only in point of view of being consistent, but in 
 general
 security issues ACLs and so).
 

Depends on the database, MySQL using InnoDB can split the database into
certain sized files located on many different filesystems.  Most other
databases have some sort of similar ability.

 What's wrong with mirroring RAID, having RAID 1 +0 and IMHO this will solve 
 your problems.
 there are tons of applications, distributed filesystems and so which you can 
 use to
 provide consistency and redundancy as well as one major thing _security_.
 

I don't have any problems, I have a RAID5 that works just fine.

You seem to be hinting that running a database is inherantly insecure,
which I'd consider to be false.  Its no less secure than a unix
machine.  A stock installed unix machine that isn't kept up to date, and
setup properly can lead to a root exploit, bypassing all fs acl's... 
So, if you setup a db to be as protected as your unix machine, the
security implementations are the same.

 ACL in database suck, you can put permissions on table, database, can you put 
 permissions
 per every record? I guess not in the every day database.
 

Every record isn't necessary, since the programs accessing the database
will need access to all of the records eventually anyhow in a mail
application.  What they may not need is access to every column in a
table, and MySQL does have column level acl's as well as table and
database level.  

  As for the access time, that's true, in part, but the second part of
  your statement is false.  file system mta's with large numbers of users
  will suffer tremendously compared to a db.  A db is an indexed,
  organized storage, flat files are sequential only.  So when you have
  large mailboxes, a database will win over flat file for access time
  since it doesn't have to seek the whole file to search a message in the
  middle. 
 
 Btrees, hash tables, used in FS as well.
Yes, for locating files, fs's don't index and maintain meta data of the
contents of a file.

 
  Of course, if you're only running pop3 and your clients are
  behaving appropriately (downloading all messages every time) a flat file
  might show a performance benefit (since it is a sequential read and all
  the other indexing isn't needed).  But some clients will skip messages
  they've already downloaded, requiring an expensive seek without an index
  as to where to look, and pop3 is becoming less popular as imap (as a
  direct protocol, or the backend of a webmail system) becomes more
  popular, which don't regularly do a sequential read.
 
 The main strength of the database I'd say is in the cache the way it's 
 handled and write
 ahead logs and so (that's where metadata comes in). Look at reiserfs it uses 
 Btrees also
 it has hash table, not to mention the metadata. Now look at reiserfs 4 :-). 
 even the
 metadata and data journaling gives you more secure storage than database.
 XFS, EXT3, REISERFS, JFS, NTFS all these are journals filesystems.
 
If that's a main strength of a database, then its the main strength of a
fs as well since most all of them contains what you just mentioned.   As
you say below, databases and filesystems share the same philosophy.  And
I don't see how an fs is any more secure than a db...

 One thing I know for sure that most of the features are derived  from 
 database designs.
 
 Let's be honest, what do you prefer, being consistent, secure and redundant 
 than speed?! 
 I'd not think so. Hardware is cheap, horse power is cheap.

I prefer both and both are achievable at the same time.

 Making a cluster of Distributed Filesystems is much more feasible than doing 
 it with
 Database, for 1 most of the database use the Lazy  Replication approach 
 rather than Eager,
 and all the updates are done _after_ the transaction was done, in Eager you 
 have
 synchronous replication where the transactions are spread across the whole 
 cluster,
 not to mention Eager partial replication, where different bits can reside on 
 different
 servers, but:
 

As you're so eager to point out, db's in 

Re: [Dbmail-dev] new developer at ICS, new features

[Ryan Butler]

On Thu, 2003-07-24 at 04:26, Ilja wrote:
 When the transition of the database code to C++ is complete, we'll be 
 looking at some other features that will have to included for dbmail 
 2.0:
 

Another thing to add to the todo list is the account suspension support,
where you can prohibit an account from sending or receiving mail or
restrict them to certain services (such as pop3, but no imap, etc).

Also, please check out the tools on
http://www.sourceforge.net/projects/dbmail as there are already a couple
of patches there, and the points outlined in your email would make great
wishlist items to keep track.

Also, if you could keep an irc client open in the background to
irc.freenode.net channel #dbmail, there are a few of us that gather and
discuss ideas and problems there regularly.

Thanks.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail-dev] db schema changes discussion

[Ryan Butler]

On Tue, 2003-07-08 at 08:54, Matthew T. O'Connor wrote:

 I have no idea, unfortunately, I don't really know how the imap clients
 really work.
  

 My real question is what queries are being done by the server.  When I
 use evolution and ask it to search the message body for a piece of text,
 does it send this request to the server? Or does it only search what is
 cached.
 

Here's a neat little evolution trick:

evolution =1.3

open a shell.
export CAMEL_VERBOSE_DEBUG=1
evolution-mail 
evolution 

evolution = 1.4

open a shell
export CAMEL_VERBOSE_DEBUG=1
evolution 

This will load evolution, and if you look in the terminal window you
will see all the imap traffic generated.  To answer your question, if
its not in its cache of searches (starts with no entries in the cache)
it sends it to the server to be searched.

 Also, IMAP clients are not all we care about.  We also have POP3 (less
 interesting) and direct clients that bypass the IMAP interface, querying
 the database themselves.  I know several web apps do this already. 
 Also, there is talk extending dbmail to include more exchange type
 functionality and implementing a SOAP interface, thus I think it's a bit
 foolish to optimize the design solely around IMAP.
 

Expanding exchange like features into dbmail in my opinion should be an
add on product that uses the soap interface, or a forked project.  I
work for an ISP and we have centered our whole mail system around
dbmail, and I really don't need the group functions of exchange for our
offering, and would prefer it not to be bloated up with them.  We chose
dbmail as an email solution.

That being said, a separate add on, fork, or configuration directives
disabling these functions would be good solutions.

 I think dbmail is great, and really has the potential to evolve into a
 killer groupware server.  The best part is it already works well for
 what it does, it's not some pie in the sky project that is trying to do
 everything all at once.
 
  /Magnus
  
 

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] dbmail and mailman and postfix

[Ryan Butler]

On Wed, 2003-07-02 at 11:55, Jacques Beaudoin wrote:
 Im trying to install mailman on a working setup of dbmail and postfix.
 
 Is there a special setup of mailman for dbmail.
 
 Thanks
 Jacques
 

Nope, works great in 3 setups of it here.

and its what this list runs.


Ryan Butler
[EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] High Load Average and dbmail-pop3d ?

[Ryan Butler]

If setting the maxconnect=1 does fix the problem, its quite possibly a
side affect of the patch I made an believe I sent to the list a while
back, and recently sent to Jason upon request for apop authentication.

APOP has no password associated with it, and the dbmail-pop3d has a
state machine that if there is not a valid username and password, it
will always fail the connection.  This was causing anyone using apop to
have problems for us, so my fix (search the archives for the patch) was
to set the session-password on an apop connection = the apop hash

This works for me, but I always have maxconnect=1 since the previous bug
about disconnecting in the middle of a session sent your mail to the
next person who connected to that process bug...


On Tue, 2003-05-20 at 09:51, Jesse Norell wrote:
 Hello,
 
   Right off, this looks quite suspect:
 
  May 19 18:57:27 vault dbmail/pop3d[25871]: pop3(): APOP auth, username
  [EMAIL PROTECTED], md5_hash [EMAIL PROTECTED]
 
 There are invalid characters in that md5 hash - the variable is
 probably getting walked on somewhere.  I'll see if I can find anything
 obvious from the code.  Is this a pretty busy server?  Can you look at
 the logs and try to determine if this only happenes when there are
 multiple users simultaneously authenticating?  Also, for testing, see
 if setting MAXCONNECTS to 1 in dbmail.conf makes the problem go away.
 
 
 
 --
 Jesse Norell
 jesse (at) kci.net
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail


signature.asc
Description: This is a digitally signed message part

Re: [Dbmail] Dbmail on FreeBSD 4.8 help - missing the developmentlibraries - compile error

[Ryan Butler]

On Fri, 2003-05-09 at 13:10, lou wrote:

 
 in any way the best thing will be to tell the linker what to do 
 -Wl,-L/new/lib.
 but AFAIK dbmail configure script doesn't check if -lmysqlclient actually 
 works?
 
 i can hack a quick configure patch for that?
 
 cheers
 

Yes, it does, that's this guys problem, he is getting an error from
configure stating that it cannot link to -lmysqlclient...  The
infrastructure on good guesses to make is there, but right now, it
doesn't check any of the guesses, just whether it can link to
-lmysqlclient or not.

A patch would be nice :)

 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail


signature.asc
Description: This is a digitally signed message part

RE: [Dbmail] Dbmail on FreeBSD 4.8 help - missing the developmentlibraries - compile error

[Ryan Butler]

On Thu, 2003-05-08 at 04:10, Filip Wuytack wrote:
 Ryan,
 
 I looked further for that ld.so.conf file, but couldn't find itany
 ideas where I should be looking?
 
 Filip

On FreeBSD it may be called something else, or may have a totally
different mechanism.  It would be easier probably to ask a FreeBSD guru
how ld looks for libraries.


Overall though, Jesse is right, autoconf needs to be made to try all the
different paths in mysqlibpaths if ld can't find it on its own.  I have
little free time right now, but I will put it on the list of things to
do, but Jesse will probably beat me to it.

Ryan



signature.asc
Description: This is a digitally signed message part

RE: [Dbmail] Dbmail on FreeBSD 4.8 help - missing the development libraries - compile error

[Ryan Butler]

On Wed, 2003-05-07 at 05:58, Filip Wuytack wrote:
 I've also tried, after installing automake  autoconf, to re-run the
 configure script , but still the same error...
 
 Libmysqlclient.so is in  /usr/local/lib/mysql
 
 ~ Filip
 

What does ldconfig -p | grep mysqlclient show?

All the configure script does here is make sure it can link that
library, and relies on ld to actually know where it is.

So its most likely that /usr/local/lib/mysql isn't in the ld.so.conf
which is the paths that ld checks, or that ldconfig hasn't been ran
since it was installed to tell ld to reload its config and index new
directories.


Ryan Butler

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
 Of Filip Wuytack
 Sent: 07 May 2003 11:30
 To: dbmail@dbmail.org
 Subject: [Dbmail] Dbmail on FreeBSD 4.8 help - missing the development
 libraries - compile error
 
 
 Hi,
 
 Can anyone point to me what I should adjust to get DBmail compiling
 correctly on a FreeBSD 4.8 system. MySQL 323 server port is installed
 and the MySQL++ libraries port, but still when I run ./configure with
 the -with-MySQL option it stops with an error at: Checking for
 mysql_real_connect in -lmysqlclient...no
 Configure: error:
 Unable to link against the mysqlclient. It appears you are missing the
 development lib
 
 Regards,
  
 Filip Wuytack
  
 
 PS the DBmail version I'm using is the latest cvs, tried it with
 snapshots of a couple of days ago and it gives me the same problem.
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] migrations issues and table contraints

[Ryan Butler]

On Wed, 2003-04-02 at 03:00, Paul Stevens wrote:
 Hi all,
 

 Being unable to move back to postgres I had to sweat it out. Not so much 
 it seemed: adding a sloth of indexes to the main tables solved all 
 performance issues I had. Using innodb I decided to add foreign key 
 contraints, and dbmail now feels very snappy indeed. Load now hovers 
 below 0.1 :-)
 

Do you have a alter table statement floating around that modifies the
stock table to use your indexes and constraints?

I'd like to try them out.

Thanks

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] autoconf update [PATCH]

[Ryan Butler]

On Tue, 2003-03-18 at 03:11, Blake wrote:
 I looked at the fact sheet for powermail, it looks interesting, but it 
 is missing what I think is the heart of dbmail; the IMAP server. I bet 
 it would only take a few tweaks to get dbmail-imapd to read messages 
 from files. I've got this sneaking suspicion it will be faster that way. 
 Of course, in the long term, I also want to add lots of headers into the 
 messages table, or a separate headers table, for indexing. Eventually I 
 see a client that bypasses IMAP and accesses the database directly, 
 maybe an XUL or web app. An MMMUA (Massively Multiplayer Mail User 
 Agent) if you will. :-)
 

Flat files on large mailboxes are terrible performers.  It might read
sequentially faster, but try removing a message from the middle of the
flat file...  

Not to mention how inflexible it is.  

There's patches to qpopper and uw-imapd that allow you to use a sql auth
system with them.  Maybe one of those would be better suited to what
yoour goal is.  (Its what I ran previous to switching to dbmail)

Re: Re[4]: [Dbmail] Multiple copies of every email

[Ryan Butler]

This is a bug in the 1.1 pop server.

Entourage will see the APOP stamp on the greeting and default to APOP
mode.  APOP will always yield an incomplete session error regardless if
the session was correct or not.

I tested it by explicitly setting Evolution to use APOP and it too gets
an error, even though all the commands sent and received are valid, and
the last command is a quit.


On Thu, 2003-03-06 at 18:50, Jason Burfield wrote:
 Unfortunately, Entourage has no logging facility that I can find anywhere.
 
 I should also mention that the account I am connecting to only had the one
 email message. (I keep sending one new message to it for testing purposes.)
 
 It's a very simple one line email with something like Hello, this is a
 test in it. I can't imagine that would choke Entourage somehow. At least I
 hope not!
 
 A pseudo fix (short term) was to set Entourage to leave all mail on the
 server and delete anything more than one day old. That kept the same email
 from being pulled from the server when I connected, UNTIL any new message
 showed up. Then the old ones came down with the new ones. (Same day)
 
 I'm not really sure if there is anything I can change server-side that will
 help this...
 
 Any additional thoughts are welcome!
 
 Thanks!
 
   --  Jason
 
 
 On 3/6/03 2:00 PM, Jeff Brenton [EMAIL PROTECTED] wrote:
 
  Hello Jason,
  
  JB No, Entourage shows no error at all.
  
  JB It performs as usual, pulling the email from the server and 
  disconnecting.
  JB No errors anywhere in the client.
  
  Try turning on logging, if Entourage has it; I couldn't find the
  problem with Outlook until I had it log all POP3 and SMTP
  transactions, which (after finding where it hid the damn log!) showed
  an overflow error retrieving a particular message.
 
  ---
 | Jason Burfield  | |
 | [EMAIL PROTECTED]  |   http://www.burfield.com   |
  ---
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: Re[4]: [Dbmail] Multiple copies of every email

[Ryan Butler]

On Mon, 2003-03-10 at 11:55, Ryan Butler wrote:
 This is a bug in the 1.1 pop server.
 
 Entourage will see the APOP stamp on the greeting and default to APOP
 mode.  APOP will always yield an incomplete session error regardless if
 the session was correct or not.
 
 I tested it by explicitly setting Evolution to use APOP and it too gets
 an error, even though all the commands sent and received are valid, and
 the last command is a quit.
 
 


Figured this out,

line 167 of pop3.c:
if (session.username != NULL  session.password != NULL)

On an APOP connection, password is NULL because a hash is substituted
instead of a password.

My temporary fix so far has been to set the password = to the hash.  The
false condition on this if is the uncompleted session error  and the
only time the pop server updates the read/deleted items is at the end of
a sucessful session.

When I decide on the best method to solve the problem, I'll submit a
patch.  But this does work to solve the problem.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] info functionality

[Ryan Butler]

On Sat, 2003-03-08 at 14:20, Nunno Luca wrote:
 Hi All,
 
 I'm decided to use dbmail in my web farm, but i need to filter my user for
 using IMAP or POP3 protocol. No all user can use IMAP (so bandwidth
 intensive), all can use POP3.
 If i change the code, you can insert it into CVS ??
 
 Thank's
 

I would recommend against merging this into cvs at this time as Jesse
and I are working on making the account_suspend stuff more robust and
including this functionality as well as more.

 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Local recipient lookup?

[Ryan Butler]

On Wed, 2003-03-05 at 17:03, Ketil Myhre Ring wrote:
 This has been covered repeatedly in the last week on the mailing list,
 please look at the archives for this month.
 
 Sorry, I didn't find anything. What are the subject of those posts?
 

Re: [Dbmail] Urgent - Relay e Unknow User

is one topic that was about it


 Bascially you need to either disable the local_recipient_maps definition
 in main.cf, or setup a sql lookup to point the local_recipient_maps
 function to the dbmail aliases table.
 
 local_recipient_maps!
 
 Thanks. Can't believe I missed that... :-\
 
 (Didn't know what to look for, really. :) )
 

no problem :)


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] How to resolve such a installation problem?!!!!!!!!!!!!!!!!!!!

[Ryan Butler]

On Wed, 2003-03-05 at 03:49, Aaron Stone wrote:
 It's likely that Solaris' make isn't happy. Try GNU make, which may
 already be installed as 'gmake' or you can get a fresh one from
 www.sunfreeware.com
 
 Also, gmake is fully make compatible, and is a better make tool overall.
 
 Aaron
 



And in addition you didn't specify either --with-mysql or --with-pgsql
on the configure command line, which should have generated an error, but
apprently that patch has still been dropped from inclusion.


 On Wed, 5 Mar 2003, yu quannian wrote:
 
  All.Now I encounter such a problem after I complish the  installation of My 
  SQL Database for Solaris 2.8  .
  After I unzip all DBMail file,I want to install DBMail Softwarre, I do like 
  this:
  (1)[/home/sd/dbmail-1.1]./configure
   then the output info like this:
 
  loading cache ./config.cache
  This is dbmail's GNU configure script.
  It's going to run a bunch of strange tests to hopefully
  make your compile work without much twiddling.
  checking for a BSD compatible install... buildtools/install-sh -c
  checking whether build environment is sane... yes
  checking whether make sets ${MAKE}... (cached) yes
  checking for working aclocal... missing
  checking for working autoconf... missing
  checking for working automake... missing
  checking for working autoheader... missing
  checking for working makeinfo... missing
  checking whether to enable maintainer-specific portions of Makefiles... no
  checking for ranlib... (cached) ranlib
  checking for gcc... (cached) gcc
  checking whether the C compiler (gcc  ) works... yes
  checking whether the C compiler (gcc  ) is a cross-compiler... no
  checking whether we are using GNU C... (cached) yes
  checking whether gcc accepts -g... (cached) yes
  checking for working const... (cached) yes
  checking for inline... (cached) inline
  creating ./config.status
  creating Makefile
  creating mysql/Makefile
  creating pgsql/Makefile
  (2),then I want to make the dbmail like this:
   [/home/sd/dbmail-1.1]make
   the Output  is:
   mksh: Fatal error in reader: = missing from replacement macro reference
   Current working directory /export/home/sd/dbmail-1.1
 
 
 
  All.I want to know what's the true reason.Could you give me a advice to 
  resolve such a phenomenon?
  I am waiting for your sincere reply.
  My Email Address is [EMAIL PROTECTED]
 
  Best Regards!
 
 
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

[Dbmail] PATCH: dbmail_configure_check_os.patch

[Ryan Butler]

Adds support for checking what OS you're using, and adding a -DLINUX if
its linux.  In the future it will also help for adding os specific
checks for other things.

Addresses Dave and Jesse's need for -DLINUX for right now.  This patch
also has the autoconf/automake reran, which updates the paths for the
sqlheader stuff, this came from today's cvs, so apply this one instead
of the previous patch about updating configure to match configure.in

If you know of something your particular os needs that the standard
configure doesn't show post a reply to this thread.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions
diff -ur dbmail/Makefile.am dbmail-work/Makefile.am
--- dbmail/Makefile.am	Fri Feb  7 13:54:10 2003
+++ dbmail-work/Makefile.am	Thu Feb 27 11:15:46 2003
@@ -2,6 +2,7 @@
 
 bin_PROGRAMS = dbmail-smtp dbmail-pop3d dbmail-imapd dbmail-maintenance dbmail-adduser dbmail-readvut raw-convertor dbmail-mini-injector
 bin_SCRIPTS = install-dbmail.sh
+AM_CFLAGS = @LINUX@ 
 
 dbmail_smtp_SOURCES = config.c list.c debug.c dbmd5.c md5.c mime.c main.c pipe.c bounce.c forward.c memblock.c
 dbmail_smtp_LDADD = @SQLALIB@
diff -ur dbmail/Makefile.in dbmail-work/Makefile.in
--- dbmail/Makefile.in	Fri Feb  7 13:54:10 2003
+++ dbmail-work/Makefile.in	Thu Feb 27 11:16:04 2003
@@ -58,6 +58,7 @@
 PRE_UNINSTALL = :
 POST_UNINSTALL = :
 CC = @CC@
+LINUX = @LINUX@
 MAINT = @MAINT@
 MAKEINFO = @MAKEINFO@
 MYSQLINC = @MYSQLINC@
@@ -72,6 +73,7 @@
 
 bin_PROGRAMS = dbmail-smtp dbmail-pop3d dbmail-imapd dbmail-maintenance dbmail-adduser dbmail-readvut raw-convertor dbmail-mini-injector
 bin_SCRIPTS = install-dbmail.sh
+AM_CFLAGS = @LINUX@ 
 
 dbmail_smtp_SOURCES = config.c list.c debug.c dbmd5.c md5.c mime.c main.c pipe.c bounce.c forward.c memblock.c
 dbmail_smtp_LDADD = @SQLALIB@
diff -ur dbmail/aclocal.m4 dbmail-work/aclocal.m4
--- dbmail/aclocal.m4	Fri Feb  7 13:54:10 2003
+++ dbmail-work/aclocal.m4	Thu Feb 27 11:04:41 2003
@@ -309,3 +309,15 @@
   fi
 fi
 ])
+
+AC_DEFUN(DBMAIL_CHECK_OS, [dnl
+
+AC_CACHE_CHECK(system type, dbmail_system_type, dbmail_system_type=`uname -s`)
+
+if test $dbmail_system_type == Linux
+  then
+   AC_MSG_RESULT(You're running Linux!  Excellent!)
+   LINUX=-DLINUX
+fi
+
+])
diff -ur dbmail/configure dbmail-work/configure
--- dbmail/configure	Fri Feb  7 13:54:10 2003
+++ dbmail-work/configure	Thu Feb 27 11:16:02 2003
@@ -842,19 +842,24 @@
 
 
 mysqllibpaths=/usr/lib /usr/local/lib /lib /usr/freeware/lib \
-   /usr/freeware/lib32 $HOME/lib $HOME/tcl/lib $HOME
+   /usr/freeware/lib32 $HOME/lib $HOME/mysql/lib \ 
+   /usr/lib/mysql /usr/local/lib/mysql $HOME/lib/mysql $HOME
+
 mysqlheaderpaths=/usr/include/mysql /usr/include /usr/local/include/mysql \
   /usr/local/include /usr/freeware/include/mysql \
   /usr/freeware/include $HOME/include $HOME/mysql/include \
   $HOME
 
 pgsqllibpaths=/usr/lib /usr/local/lib /lib /usr/freeware/lib \
-   /usr/freeware/lib32 $HOME/lib $HOME/tcl/lib $HOME
+   /usr/freeware/lib32 $HOME/lib $HOME/pgsql/lib \
+   /usr/lib/pgsql /usr/local/lib/pgsql /usr/lib/postgresql \
+   /usr/local/lib/postgresql $HOME/lib/pgsql $HOME/lib/postgresql \
+   $HOME/postgresql/lib $HOME
 
 pgsqlheaderpaths=/usr/include/pgsql /usr/include /usr/local/include/pgsql \
   /usr/local/include /usr/freeware/include/pgsql \
   /usr/freeware/include $HOME/include $HOME/pgsql/include \
-		  /usr/local/pgsql/include $HOME
+		  /usr/local/pgsql/include /usr/include/postgresql $HOME
 
 # Check whether --with-mysql or --without-mysql was given.
 if test ${with_mysql+set} = set; then
@@ -917,7 +922,7 @@
   if test $withval != yes
   then
 echo $ac_n checking for mysql.h (user supplied)... $ac_c 16
-echo configure:921: checking for mysql.h (user supplied) 5
+echo configure:926: checking for mysql.h (user supplied) 5
 if test -r $mysqlheadername/mysql.h
   then
   # found
@@ -935,7 +940,7 @@
   else
 # Lets look in our standard paths
 echo $ac_n checking for mysql.h... $ac_c 16
-echo configure:939: checking for mysql.h 5
+echo configure:944: checking for mysql.h 5
 for mysqlpaths in $mysqlheaderpaths
 do
   if test -r $mysqlpaths/mysql.h
@@ -962,7 +967,7 @@
   if test $withval != yes
   then
 echo $ac_n checking for libpq-fe.h (user supplied)... $ac_c 16
-echo configure:966: checking for libpq-fe.h (user supplied) 5
+echo configure:971: checking for libpq-fe.h (user supplied) 5
 if test -r $pgsqlheadername/libpq-fe.h
   then
   # found
@@ -980,7 +985,7 @@
   else
 # Lets look in our standard paths
 echo $ac_n checking for libpq-fe.h... $ac_c 16
-echo configure:984: checking for libpq-fe.h 5
+echo configure:989: checking for libpq-fe.h 5
 for pgsqlpaths in $pgsqlheaderpaths
 do
   if test -r $pgsqlpaths/libpq-fe.h
@@ -1004,7 +1009,7 @@
 if test

Re: [Dbmail] FreeBSD: unable to link mysqlclient [current cvs]

[Ryan Butler]

On Thu, 2003-02-20 at 01:03, [EMAIL PROTECTED] wrote:
   to add more paths to the library checking area.
  I'm using the current CVS.
  Just where is your libmysqlclient.so at?
  [EMAIL PROTECTED] /usr/local/lib/mysql]# ls libmysqlclient.so
  lrwxr-xr-x  1 root  wheel  20 Jan 30 19:46 libmysqlclient.so@ -
  libmysqlclient.so.10
 
 I have executed export LDFLAGS=-L/usr/local/lib/mysql, and now
 ./configure works.
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

For some reason the changes are in configure.in and not in configure,
perhaps autoconf and automake didn't get ran when I generated the patch,
anyhow, if you just type:

autoconf
automake

in the dbmail dir, configure should auto find your mysql lib without the
environment variable.  Patch forthcoming.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

[Dbmail] PATCH: update configure with configure.in

[Ryan Butler]

configure.in had the new search paths added, but configure was not
updated.

Here is the patch to accomplish that:


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions
diff -ur dbmail/configure dbmail.working/configure
--- dbmail/configure	Fri Feb  7 13:54:10 2003
+++ dbmail.working/configure	Thu Feb 20 10:23:21 2003
@@ -842,19 +842,24 @@
 
 
 mysqllibpaths=/usr/lib /usr/local/lib /lib /usr/freeware/lib \
-   /usr/freeware/lib32 $HOME/lib $HOME/tcl/lib $HOME
+   /usr/freeware/lib32 $HOME/lib $HOME/mysql/lib \ 
+   /usr/lib/mysql /usr/local/lib/mysql $HOME/lib/mysql $HOME
+
 mysqlheaderpaths=/usr/include/mysql /usr/include /usr/local/include/mysql \
   /usr/local/include /usr/freeware/include/mysql \
   /usr/freeware/include $HOME/include $HOME/mysql/include \
   $HOME
 
 pgsqllibpaths=/usr/lib /usr/local/lib /lib /usr/freeware/lib \
-   /usr/freeware/lib32 $HOME/lib $HOME/tcl/lib $HOME
+   /usr/freeware/lib32 $HOME/lib $HOME/pgsql/lib \
+   /usr/lib/pgsql /usr/local/lib/pgsql /usr/lib/postgresql \
+   /usr/local/lib/postgresql $HOME/lib/pgsql $HOME/lib/postgresql \
+   $HOME/postgresql/lib $HOME
 
 pgsqlheaderpaths=/usr/include/pgsql /usr/include /usr/local/include/pgsql \
   /usr/local/include /usr/freeware/include/pgsql \
   /usr/freeware/include $HOME/include $HOME/pgsql/include \
-		  /usr/local/pgsql/include $HOME
+		  /usr/local/pgsql/include /usr/include/postgresql $HOME
 
 # Check whether --with-mysql or --without-mysql was given.
 if test ${with_mysql+set} = set; then
@@ -917,7 +922,7 @@
   if test $withval != yes
   then
 echo $ac_n checking for mysql.h (user supplied)... $ac_c 16
-echo configure:921: checking for mysql.h (user supplied) 5
+echo configure:926: checking for mysql.h (user supplied) 5
 if test -r $mysqlheadername/mysql.h
   then
   # found
@@ -935,7 +940,7 @@
   else
 # Lets look in our standard paths
 echo $ac_n checking for mysql.h... $ac_c 16
-echo configure:939: checking for mysql.h 5
+echo configure:944: checking for mysql.h 5
 for mysqlpaths in $mysqlheaderpaths
 do
   if test -r $mysqlpaths/mysql.h
@@ -962,7 +967,7 @@
   if test $withval != yes
   then
 echo $ac_n checking for libpq-fe.h (user supplied)... $ac_c 16
-echo configure:966: checking for libpq-fe.h (user supplied) 5
+echo configure:971: checking for libpq-fe.h (user supplied) 5
 if test -r $pgsqlheadername/libpq-fe.h
   then
   # found
@@ -980,7 +985,7 @@
   else
 # Lets look in our standard paths
 echo $ac_n checking for libpq-fe.h... $ac_c 16
-echo configure:984: checking for libpq-fe.h 5
+echo configure:989: checking for libpq-fe.h 5
 for pgsqlpaths in $pgsqlheaderpaths
 do
   if test -r $pgsqlpaths/libpq-fe.h
@@ -1004,7 +1009,7 @@
 if test ! ${mysqlheadername-x} = x
 then
   echo $ac_n checking for mysql_real_connect in -lmysqlclient... $ac_c 16
-echo configure:1008: checking for mysql_real_connect in -lmysqlclient 5
+echo configure:1013: checking for mysql_real_connect in -lmysqlclient 5
 ac_lib_var=`echo mysqlclient'_'mysql_real_connect | sed 'y%./+-%__p_%'`
 if eval test \`echo '$''{'ac_cv_lib_$ac_lib_var'+set}'`\ = set; then
   echo $ac_n (cached) $ac_c 16
@@ -1012,7 +1017,7 @@
   ac_save_LIBS=$LIBS
 LIBS=-lmysqlclient  $LIBS
 cat  conftest.$ac_ext EOF
-#line 1016 configure
+#line 1021 configure
 #include confdefs.h
 /* Override any gcc2 internal prototype to avoid an error.  */
 /* We use char because int might match the return type of a gcc2
@@ -1023,7 +1028,7 @@
 mysql_real_connect()
 ; return 0; }
 EOF
-if { (eval echo configure:1027: \$ac_link\) 15; (eval $ac_link) 25; }  test -s conftest${ac_exeext}; then
+if { (eval echo configure:1032: \$ac_link\) 15; (eval $ac_link) 25; }  test -s conftest${ac_exeext}; then
   rm -rf conftest*
   eval ac_cv_lib_$ac_lib_var=yes
 else
@@ -1055,7 +1060,7 @@
   if test ! ${pgsqlheadername-x} = x
   then
 echo $ac_n checking for PQconnectdb in -lpq... $ac_c 16
-echo configure:1059: checking for PQconnectdb in -lpq 5
+echo configure:1064: checking for PQconnectdb in -lpq 5
 ac_lib_var=`echo pq'_'PQconnectdb | sed 'y%./+-%__p_%'`
 if eval test \`echo '$''{'ac_cv_lib_$ac_lib_var'+set}'`\ = set; then
   echo $ac_n (cached) $ac_c 16
@@ -1063,7 +1068,7 @@
   ac_save_LIBS=$LIBS
 LIBS=-lpq  $LIBS
 cat  conftest.$ac_ext EOF
-#line 1067 configure
+#line 1072 configure
 #include confdefs.h
 /* Override any gcc2 internal prototype to avoid an error.  */
 /* We use char because int might match the return type of a gcc2
@@ -1074,7 +1079,7 @@
 PQconnectdb()
 ; return 0; }
 EOF
-if { (eval echo configure:1078: \$ac_link\) 15; (eval $ac_link) 25; }  test -s conftest${ac_exeext}; then
+if { (eval echo configure:1083: \$ac_link\) 15; (eval $ac_link) 25; }  test -s conftest${ac_exeext}; then
   rm -rf conftest*
   eval ac_cv_lib_

Re: [Dbmail] dbmail 1.1

[Ryan Butler]

On Wed, 2003-02-19 at 16:20, shon wrote:
 i am assuming that the current cvs is 1.1? if not, where can i get it? and
 is the autoconf configure script working on rh7x?
 
 thanks,
 shon

If it isn't, I'd like to hear about it.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] FreeBSD: unable to link mysqlclient [current cvs]

[Ryan Butler]

What version of dbmail is this?  Patches were posted to update the 1.0
to add more paths to the library checking area.

These patches are in the cvs and will be in 1.1


On Tue, 2003-02-18 at 09:10, [EMAIL PROTECTED] wrote:
 how to fix the following problem?
 
 [EMAIL PROTECTED] ~/projects/dbmail]# ./configure --with-mysql
 loading cache ./config.cache
 
 This is dbmail's GNU configure script.
 It's going to run a bunch of strange tests to hopefully
 make your compile work without much twiddling.
 
 checking for a BSD compatible install... /usr/bin/install -c
 checking whether build environment is sane... yes
 checking whether make sets ${MAKE}... yes
 checking for working aclocal... missing
 checking for working autoconf... missing
 checking for working automake... missing
 checking for working autoheader... missing
 checking for working makeinfo... found
 checking whether to enable maintainer-specific portions of Makefiles... no
 checking for ranlib... ranlib
 checking for mysql.h... /usr/local/include/mysql/mysql.h
 checking for mysql_real_connect in -lmysqlclient... no
 configure: error:
   Unable to link against mysqlclient.  It appears you are missing the
   development libraries or they aren't in your linker's path
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] FreeBSD: unable to link mysqlclient [current cvs]

[Ryan Butler]

On Tue, 2003-02-18 at 09:29, [EMAIL PROTECTED] wrote:
  What version of dbmail is this?  Patches were posted to update the 1.0
  to add more paths to the library checking area.
 
 I'm using the current CVS.
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

Just where is your libmysqlclient.so at?

Thanks

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] dbmail 1.1 - autoconf issues

[Ryan Butler]

On Sat, 2003-02-08 at 06:56, Paul J Stevens wrote:
 Ryan Butler wrote:
 
 Here is another patch so that autoconf finds postgresql headers on
 debian machines.
 
 Shouldn't files like Makefile.in and configure and all the other files 
 that are generated by automake
 and autoconf be removed from cvs? Just an idea, since I know this is 
 common practice in some other
 os-projects.

Not really since they're part of the development process, and tracking
their changes in cvs is just as valid... Some of the files could be
removed from the releases (aclocal.m4, configure.in, Makefile.am, etc)
Makefile.in and configure need to stay as it would be a useless build
system without configure and configure reads Makefile.in to generate the
Makefiles.

So they must stay in cvs, and are optional for the releases.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] dbmail 1.1 - autoconf issues

[Ryan Butler]

On Fri, 2003-02-07 at 12:59, Roel Rozendaal - ICS wrote:
 Hi,
 
 we've decided to release dbmail 1.1 as soon as the autoconf is working. 
 I have applied some patches to cvs recently (last wednesday) but i 
 can't seem to get it working on our systems; seems like some 
 dependencies are failing (missing object files). Does anyone have a 
 patch to make the current cvs work with autoconf?
 
 regards roel
 
 

The patch was correct, but I didn't patch it after running automake to
update Makefile.am.

I made a new patch here that updates the autoconf version to 1.1, and
has all the post automake changes, this patch, applied to the current
CVS as I checked it out about 10 minutes ago compiles smoothly on mysql
and pgsql builds.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions
diff -ur dbmail/Makefile.am dbmail.working/Makefile.am
--- dbmail/Makefile.am	Wed Feb  5 04:25:29 2003
+++ dbmail.working/Makefile.am	Fri Feb  7 13:10:54 2003
@@ -1,6 +1,6 @@
 SUBDIRS = mysql pgsql .
 
-bin_PROGRAMS = dbmail-smtp dbmail-pop3d dbmail-imapd dbmail-maintenance dbmail-adduser dbmail-readvut raw-convertor dbmail-mini-injector mb2db
+bin_PROGRAMS = dbmail-smtp dbmail-pop3d dbmail-imapd dbmail-maintenance dbmail-adduser dbmail-readvut raw-convertor dbmail-mini-injector
 bin_SCRIPTS = install-dbmail.sh
 
 dbmail_smtp_SOURCES = config.c list.c debug.c dbmd5.c md5.c mime.c main.c pipe.c bounce.c forward.c memblock.c
diff -ur dbmail/Makefile.in dbmail.working/Makefile.in
--- dbmail/Makefile.in	Fri Jul 26 16:34:15 2002
+++ dbmail.working/Makefile.in	Fri Feb  7 13:15:48 2003
@@ -1,6 +1,6 @@
-# Makefile.in generated automatically by automake 1.4-p4 from Makefile.am
+# Makefile.in generated automatically by automake 1.4-p5 from Makefile.am
 
-# Copyright (C) 1994, 1995-8, 1999 Free Software Foundation, Inc.
+# Copyright (C) 1994, 1995-8, 1999, 2001 Free Software Foundation, Inc.
 # This Makefile.in is free software; the Free Software Foundation
 # gives unlimited permission to copy and/or distribute it,
 # with or without modifications, as long as this notice is preserved.
@@ -70,55 +70,51 @@
 
 SUBDIRS = mysql pgsql .
 
-bin_PROGRAMS = dbmail-smtp dbmail-pop3d dbmail-imapd dbmail-maintenance dbmail-config dbmail-adduser dbmail-readvut dbmail-smtp-injector uni-one-convertor raw-convertor dbmail-mini-injector 
+bin_PROGRAMS = dbmail-smtp dbmail-pop3d dbmail-imapd dbmail-maintenance dbmail-adduser dbmail-readvut raw-convertor dbmail-mini-injector
 bin_SCRIPTS = install-dbmail.sh
 
-dbmail_smtp_SOURCES = list.c debug.c dbmd5.c md5.c mime.c main.c pipe.c bounce.c forward.c memblock.c
+dbmail_smtp_SOURCES = config.c list.c debug.c dbmd5.c md5.c mime.c main.c pipe.c bounce.c forward.c memblock.c
 dbmail_smtp_LDADD = @SQLALIB@
 dbmail_smtp_LDFLAGS = @SQLLIB@
 
-dbmail_pop3d_SOURCES = pop3.c list.c debug.c dbmd5.c md5.c mime.c misc.c memblock.c pop3d.c
+dbmail_pop3d_SOURCES = config.c server.c serverchild.c pop3.c list.c debug.c dbmd5.c md5.c mime.c misc.c memblock.c pop3d.c
 dbmail_pop3d_LDADD = @SQLALIB@
 dbmail_pop3d_LDFLAGS = @SQLLIB@
 
-dbmail_imapd_SOURCES = imap4.c debug.c serverservice.c list.c dbmd5.c md5.c imaputil.c imapcommands.c mime.c misc.c memblock.c rfcmsg.c imapd.c
+dbmail_imapd_SOURCES = quota.c config.c server.c serverchild.c imap4.c debug.c list.c dbmd5.c md5.c imaputil.c imapcommands.c mime.c misc.c memblock.c rfcmsg.c imapd.c 1
 dbmail_imapd_LDADD = @SQLALIB@
 dbmail_imapd_LDFLAGS = @SQLLIB@
 
-dbmail_maintenance_SOURCES = debug.c list.c dbmd5.c md5.c mime.c memblock.c maintenance.c auth.h
+dbmail_maintenance_SOURCES = config.c debug.c list.c dbmd5.c md5.c mime.c memblock.c maintenance.c auth.h
 dbmail_maintenance_LDADD = @SQLALIB@
 dbmail_maintenance_LDFLAGS = @SQLLIB@
 
-dbmail_config_SOURCES = list.c md5.c debug.c dbmd5.c mime.c memblock.c settings.c
-dbmail_config_LDADD = @SQLALIB@
-dbmail_config_LDFLAGS = @SQLLIB@
-
-dbmail_adduser_SOURCES = debug.c list.c dbmd5.c md5.c mime.c memblock.c user.c
+dbmail_adduser_SOURCES = config.c debug.c list.c dbmd5.c md5.c mime.c memblock.c user.c
 dbmail_adduser_LDADD = @SQLALIB@
 dbmail_adduser_LDFLAGS = @SQLLIB@
 
-dbmail_readvut_SOURCES = debug.c list.c dbmd5.c md5.c mime.c vut2dbmail.c
+dbmail_readvut_SOURCES = config.c debug.c list.c dbmd5.c md5.c mime.c vut2dbmail.c
 dbmail_readvut_LDADD = @SQLALIB@
 dbmail_readvut_LDFLAGS = @SQLLIB@
 
-#dbmail_realsmtp_SOURCES = debug.c dbmd5.c md5.c list.c mime.c \
+#dbmail_realsmtp_SOURCES = config.c debug.c dbmd5.c md5.c list.c mime.c \
 #  serverservice.c misc.c memblock.c
 #dbmail_realsmtp_LDADD = @SQLALIB@
 #dbmail_realsmtp_LDFLAGS = @SQLLIB@
 
-dbmail_smtp_injector_SOURCES = list.c debug.c dbmd5.c md5.c mime.c injector.c
-dbmail_smtp_injector_LDADD = @SQLALIB@
-dbmail_smtp_injector_LDFLAGS = @SQLLIB@
-
-uni_one_convertor_SOURCES = list.c debug.c dbmd5.c md5.c mime.c uni-one-convert.c
-uni_one_convertor_LDADD = @SQLALIB@
-uni_one_convertor_LDFLAGS = @SQLLIB@
+#dbmail_smtp_injector_SOURCES = config.c

Re: [Dbmail] dbmail 1.1 - autoconf issues

[Ryan Butler]

Also caught that another patch was never applied, so I remade it for the
current cvs as well, this can be applied after the patch I just sent, it
makes it so you MUST specify either --with-mysql or --with-pgsql

The current cvs will happily let you just ./configure and not setup
either sql backend, which of course doesn't compile right

Please apply the previous patch and this one.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] dbmail 1.1 - autoconf issues

[Ryan Butler]

On Fri, 2003-02-07 at 13:41, Ryan Butler wrote:
 Also caught that another patch was never applied, so I remade it for the
 current cvs as well, this can be applied after the patch I just sent, it
 makes it so you MUST specify either --with-mysql or --with-pgsql
 
 The current cvs will happily let you just ./configure and not setup
 either sql backend, which of course doesn't compile right
 
 Please apply the previous patch and this one.

Would help if I sent the patch eh?

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions
diff -ur dbmail/aclocal.m4 dbmail.working/aclocal.m4
--- dbmail/aclocal.m4	Fri Jul 26 16:17:05 2002
+++ dbmail.working/aclocal.m4	Thu Nov 21 09:44:39 2002
@@ -155,6 +155,26 @@
 
 WARN=0
 # Make sure we only select one, mysql or pgsql
+if test ${mysqlheadername-x} = x
+then
+  if test ${pgsqlheadername-x} = x
+  then
+NEITHER=1
+mysqlheadername=
+MYSQLINC=
+PGSQLINC=
+  fi
+fi
+if test $NEITHER = 1
+  then
+ AC_MSG_ERROR([
+
+ You have to specify --with-mysql or --with-pgsql to build.
+])
+fi
+
+
+
 if test ! ${mysqlheadername-x} = x
 then
   if test ! ${pgsqlheadername-x} = x
diff -ur dbmail/configure dbmail.working/configure
--- dbmail/configure	Fri Sep 13 08:56:44 2002
+++ dbmail.working/configure	Thu Nov 21 09:44:41 2002
@@ -871,6 +871,26 @@
 
 WARN=0
 # Make sure we only select one, mysql or pgsql
+if test ${mysqlheadername-x} = x
+then
+  if test ${pgsqlheadername-x} = x
+  then
+NEITHER=1
+mysqlheadername=
+MYSQLINC=
+PGSQLINC=
+  fi
+fi
+if test $NEITHER = 1
+  then
+ { echo configure: error: 
+
+ You have to specify --with-mysql or --with-pgsql to build.
+ 12; exit 1; }
+fi
+
+
+
 if test ! ${mysqlheadername-x} = x
 then
   if test ! ${pgsqlheadername-x} = x
@@ -897,7 +917,7 @@
   if test $withval != yes
   then
 echo $ac_n checking for mysql.h (user supplied)... $ac_c 16
-echo configure:901: checking for mysql.h (user supplied) 5
+echo configure:921: checking for mysql.h (user supplied) 5
 if test -r $mysqlheadername/mysql.h
   then
   # found
@@ -915,7 +935,7 @@
   else
 # Lets look in our standard paths
 echo $ac_n checking for mysql.h... $ac_c 16
-echo configure:919: checking for mysql.h 5
+echo configure:939: checking for mysql.h 5
 for mysqlpaths in $mysqlheaderpaths
 do
   if test -r $mysqlpaths/mysql.h
@@ -942,7 +962,7 @@
   if test $withval != yes
   then
 echo $ac_n checking for libpq-fe.h (user supplied)... $ac_c 16
-echo configure:946: checking for libpq-fe.h (user supplied) 5
+echo configure:966: checking for libpq-fe.h (user supplied) 5
 if test -r $pgsqlheadername/libpq-fe.h
   then
   # found
@@ -960,7 +980,7 @@
   else
 # Lets look in our standard paths
 echo $ac_n checking for libpq-fe.h... $ac_c 16
-echo configure:964: checking for libpq-fe.h 5
+echo configure:984: checking for libpq-fe.h 5
 for pgsqlpaths in $pgsqlheaderpaths
 do
   if test -r $pgsqlpaths/libpq-fe.h
@@ -984,7 +1004,7 @@
 if test ! ${mysqlheadername-x} = x
 then
   echo $ac_n checking for mysql_real_connect in -lmysqlclient... $ac_c 16
-echo configure:988: checking for mysql_real_connect in -lmysqlclient 5
+echo configure:1008: checking for mysql_real_connect in -lmysqlclient 5
 ac_lib_var=`echo mysqlclient'_'mysql_real_connect | sed 'y%./+-%__p_%'`
 if eval test \`echo '$''{'ac_cv_lib_$ac_lib_var'+set}'`\ = set; then
   echo $ac_n (cached) $ac_c 16
@@ -992,7 +1012,7 @@
   ac_save_LIBS=$LIBS
 LIBS=-lmysqlclient  $LIBS
 cat  conftest.$ac_ext EOF
-#line 996 configure
+#line 1016 configure
 #include confdefs.h
 /* Override any gcc2 internal prototype to avoid an error.  */
 /* We use char because int might match the return type of a gcc2
@@ -1003,7 +1023,7 @@
 mysql_real_connect()
 ; return 0; }
 EOF
-if { (eval echo configure:1007: \$ac_link\) 15; (eval $ac_link) 25; }  test -s conftest${ac_exeext}; then
+if { (eval echo configure:1027: \$ac_link\) 15; (eval $ac_link) 25; }  test -s conftest${ac_exeext}; then
   rm -rf conftest*
   eval ac_cv_lib_$ac_lib_var=yes
 else
@@ -1035,7 +1055,7 @@
   if test ! ${pgsqlheadername-x} = x
   then
 echo $ac_n checking for PQconnectdb in -lpq... $ac_c 16
-echo configure:1039: checking for PQconnectdb in -lpq 5
+echo configure:1059: checking for PQconnectdb in -lpq 5
 ac_lib_var=`echo pq'_'PQconnectdb | sed 'y%./+-%__p_%'`
 if eval test \`echo '$''{'ac_cv_lib_$ac_lib_var'+set}'`\ = set; then
   echo $ac_n (cached) $ac_c 16
@@ -1043,7 +1063,7 @@
   ac_save_LIBS=$LIBS
 LIBS=-lpq  $LIBS
 cat  conftest.$ac_ext EOF
-#line 1047 configure
+#line 1067 configure
 #include confdefs.h
 /* Override any gcc2 internal prototype to avoid an error.  */
 /* We use char because int might match the return type of a gcc2
@@ -1054,7 +1074,7 @@
 PQconnectdb()
 ; return 0; }
 EOF
-if { (eval echo configure:1058: \$ac_link\) 15; (eval $ac_link) 25; }  test -s conftest${ac_exeext}; then
+if { (eval echo configure:1078: \$ac_link\) 15; (eval $ac_link) 25

Re: [Dbmail] dbmail 1.1 - autoconf issues

[Ryan Butler]

Here is another patch so that autoconf finds postgresql headers on
debian machines.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions
diff -ur dbmail/configure.in dbmail.working/configure.in
--- dbmail/configure.in	Fri Sep 13 08:56:44 2002
+++ dbmail.working/configure.in	Fri Feb  7 15:34:46 2003
@@ -19,7 +19,7 @@
 pgsqlheaderpaths=/usr/include/pgsql /usr/include /usr/local/include/pgsql \
   /usr/local/include /usr/freeware/include/pgsql \
   /usr/freeware/include $HOME/include $HOME/pgsql/include \
-		  /usr/local/pgsql/include $HOME
+		  /usr/local/pgsql/include /usr/include/postgresql $HOME
 
 DBMAIL_BOTH_SQL_CHECK
 DBMAIL_CHECK_SQL_LIBS

Re: [Dbmail] CVS compile problems on RH8

[Ryan Butler]

On Wed, 2003-02-05 at 19:52, Curtis Maurand wrote:

You have not provided enough details to accurately pinpoint your
problem.  What build mechanism did you use? ./configure?  build.sh?  It
looks like you're missing the config.c file in your compilation. 
Patches to the autoconf stuff to allow this were posted, but may not
have made it to cvs.  More information required to accurately solve your
problem

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

 same deal with gcc296 and 3.2.  Its almost like there's a file missing
 somewhere.
 
 Here is what I get:
 
 ock.c
 gcc296  -g -O2  -o dbmail-smtp -lmysqlclient list.o debug.o dbmd5.o md5.o
 mime.o main.o pipe.o bounce.o forward.o memblock.o mysql/libmysqldbmail.a
 main.o: In function `main':
 /root/dbmail/main.c:64: undefined reference to `ReadConfig'
 /root/dbmail/main.c:65: undefined reference to `ReadConfig'
 /root/dbmail/main.c:66: undefined reference to `SetTraceLevel'
 /root/dbmail/main.c:67: undefined reference to `GetDBParams'
 pipe.o: In function `insert_messages':
 pipe.o(.text+0xa5e): undefined reference to `GetConfigValue'
 pipe.o(.text+0xa8e): undefined reference to `GetConfigValue'
 pipe.o: In function `send_notification':
 pipe.o(.text+0xdc1): undefined reference to `GetConfigValue'
 pipe.o: In function `send_reply':
 pipe.o(.text+0xef6): undefined reference to `GetConfigValue'
 bounce.o: In function `bounce':
 /root/dbmail/bounce.c:30: undefined reference to `GetConfigValue'
 bounce.o:/root/dbmail/bounce.c:34: more undefined references to
 `GetConfigValue' follow
 collect2: ld returned 1 exit status
 make[1]: *** [dbmail-smtp] Error 1
 make[1]: Leaving directory `/root/dbmail'
 make: *** [all-recursive] Error 1
 [EMAIL PROTECTED] dbmail]#
 

Re: [Dbmail] Weird Problems

[Ryan Butler]

On Fri, 2003-01-24 at 16:47, Tim Jackson wrote:
 I just recently upgraded from rc3 - 1.0, I've had RC3 running stable for a 
 long time, but after upgrading I keep getting this really weird problem, some 
 messages wont ever clear themselves out of the postfix queue, these are 
 messages that I had put aliases into the aliases table that deliver to an 
 email address instead of an account. Should I change this? This causes things 
 like this:
 
 70A5BBB4C8 3441 Fri Jan 24 16:12:07  [EMAIL PROTECTED]
   (Command died with signal 11: /usr/local/sbin/dbmail-smtp)
  [EMAIL PROTECTED]
 
 to show up in the postfix log file. How should I change these aliases?

Covered recently, there's a bug in dbmail-smtp's bounc handling, its
supposed to be fixed in later 1.0 releases and in cvs, but the 1.0
release on the site still has the problem.  I worked around it
temporarily by setting up postfix's local_recipient_maps so it handles
the bouncing instead of dbmail.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Delever to wrong adresse

[Ryan Butler]

 FROM aliases WHERE  
  alias=\\\[EMAIL PROTECTED]
  erie.dk\\\]
  Jan 17 10:53:02 northzell dbmail/smtp[18835]: auth_check_user(): user
  [EMAIL PROTECTED] not in aliases table
  Jan 17 10:53:02 northzell dbmail/smtp[18835]: insert_messages(): user
  [EMAIL PROTECTED] found total of [0] aliases
  Jan 17 10:53:02 northzell dbmail/smtp[18835]: insert_messages(): no
  users found to deliver to. Checking for domain forwards
  Jan 17 10:53:02 northzell dbmail/smtp[18835]: insert_messages():
  checking for domain aliases. Domain = [EMAIL PROTECTED]
  Jan 17 10:53:02 northzell dbmail/smtp[18835]: auth_check_user():
  checking user [EMAIL PROTECTED] in alias table
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: auth_check_user():
  executing query, checks [-1]
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: __auth_query():
  executing query [SELECT deliver_to FROM aliases WHERE  
  alias=\\\@vinferie
  .dk\\\]
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: auth_check_user(): into
  checking loop
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: auth_check_user():
  checking user @vinferie.dk to 23
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: auth_check_user():
  checking user [23] in alias table
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: auth_check_user():
  executing query, checks [1]
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: __auth_query():
  executing query [SELECT deliver_to FROM aliases WHERE 
  alias=\\\23\\\]
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: auth_check_user():
  adding [23] to deliver_to address
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: insert_messages():
  domain [EMAIL PROTECTED] found total of [1] aliases
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: insert_messages(): alias
  deliver_to is [23]
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: db_query(): executing
  [SELECT mailbox_idnr FROM mailboxes WHERE name=\\\'INBOX\\\' AND owner
  _idnr=23]
  Jan 17 10:53:03 northzell dbmail/smtp[18835]: db_query(): executing
  [INSERT INTO messages(mailbox_idnr,messagesize,unique_id,interna
  l_date,recent_flag,status) VALUES (156, 0, \\, \\\2003-01-17
  10:53:03\\\, 1, \\\'005\\\')]
 
 
 
   Original Message 
  From: Roel Rozendaal - ICS dbmail@dbmail.org
  To: dbmail@dbmail.org
  Subject: Re: [Dbmail] Delever to wrong adresse
  Sent: Thu, 23 Jan 2003 09:23:56 +0100
 
  never heard of this problem before - could you check the aliases 
  table?
  To what address is the mail send, what is it\\\'s corresponding entry 
  in
  the aliases table, which entries does the wrong user (the one getting
  the mail) have in the aliases table, to which mailboxes are those 
  users
  connected etc.
 
  regards roel
 
 
  Kasper Haagensen heeft op donderdag, 23 jan 2003 om 08:36
  (Europe/Amsterdam) het volgende geschreven:
 
 
  Hei
 
  I have some problem, som of my email goes to the wrong user?
 
  When i check my log-file and MySQL-setup i can not find anything
  wrong!
 
  Has other, experience the same sort of problem and have anyone got an
  idea of, what is going wrong here?
 
  mvh
  kasper
  ___
  Dbmail mailing list
  Dbmail@dbmail.org
  https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
  Met vriendelijke groet,
 
 
  Roel Rozendaal
 
 
  _
  R.A. Rozendaal
  ICT Manager
  ICS
  T: +31 30 2322878
  F: +31 30 2322305
  www.ic-s.nl
 
  ___
  Dbmail mailing list
  Dbmail@dbmail.org
  https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
  -- End Original Message --
 
  ___
  Dbmail mailing list
  Dbmail@dbmail.org
  https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
  Met vriendelijke groet,
 
 
  Roel Rozendaal
 
 
  _
  R.A. Rozendaal
  ICT Manager
  ICS
  T: +31 30 2322878
  F: +31 30 2322305
  www.ic-s.nl
 
  ___
  Dbmail mailing list
  Dbmail@dbmail.org
  https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
  -- End Original Message --
 
  ___
  Dbmail mailing list
  Dbmail@dbmail.org
  https://mailman.fastxs.nl/mailman/listinfo/dbmail
 
 Met vriendelijke groet,
 
 
 Roel Rozendaal
 
 
 _
 R.A. Rozendaal
 ICT Manager
 ICS
 T: +31 30 2322878
 F: +31 30 2322305
 www.ic-s.nl
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Delever to wrong adresse

[Ryan Butler]

On Thu, 2003-01-23 at 12:17, Bret Baptist wrote:
 On Thursday 23 January 2003 9:40 am, Ryan Butler wrote:
  Also on the pop3 server sig 11'ing, there is a double free going on on
  an apop string, I commented out one of the my_free() 's and it quit
  segfaulting.
 
  The double my_free is in pop3_handle_client:
 
  /* memory cleanup */
  my_free(buffer);
  my_free(apop_stamp);
  buffer = NULL;
  my_free(apop_stamp);
  apop_stamp = NULL;
 
 
 Which one did you remove?  Or does it make a difference?
 

It doesn't make a difference but I removed the first
my_free(apop_stamp);

 By the way, the double free is still in CVS.  Though mine looks like this:
 /* memory cleanup */
   my_free(buffer);
   buffer = NULL;
   my_free(apop_stamp);
   apop_stamp = NULL;
 

That's not a double free, a double free occurs when you free a pointer,
then free it again, since you're freeing two separate pointers here,
that's fine.

The double free is calling my_free(apop_stamp);

then calling my_free(apop_stamp); again.


 Thanks.
-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: SV: [Dbmail] Delever to wrong adresse

[Ryan Butler]

On Thu, 2003-01-23 at 13:33, Kasper Haagensen wrote:
 I believe you lost me some how, what should I do to fixe this problem,
 so my user can have there own mail and nobody else.
 
 Kasper Haagensen
 

There is no permanent solution yet, roel is working on it.

The temporary workaround is:

in dbmail.conf, change:

MAXCONNECTS=1

to:

MAXCONNECTS=1

for the POP3 section


I've never seen it happen under imap, but if for some reason it does for
you, do the same for the IMAP section.

Don't forget to restart the pop3 server after making this change.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

[Dbmail] Problems continue with dbmail-smtp

[Ryan Butler]

Okay,

Just migrated our whole system (around 2000 email accounts) to dbmail. 
After starting up postfix it was obvious something was wrong, the queue
just kept growing and growing, but mail was slowly being delivered as
well.  

Well, upon further investigation, it was the good old dbmail-smtp signal
11'ing on bounces, and postfix requeuing the message...

This is with dbmail-smtp 1.0 downloaded a while back, but I also tried
it this morning when I realized what the problem was with a fresh
download off dbmail.org.

I did however find a solution around this problem.

I specified a local_recipients map on postfix mysql based that points to
the aliases table.

Now postfix will reject unknown users rather than dbmail.  So this stops
most of the bounces, the only ones left being over quota (quota disabled
for now until a fix is available) and suspended accounts.  (And yes, I
did not apply the account suspension patch to the fresh download from
this morning, and it was still doing it, so that eliminates the patch
from being the problem).

Its a production system, so I dunno how readily I'll be able to debug
it, but the problem still exists.  I'll try to setup a test machine to
reproduce the problem and debug from there.

Any help, please.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] smtp issues

[Ryan Butler]

On Thu, 2003-01-16 at 13:44, Ranger Fox wrote:
 My dbmail-smtp wasn't picking up messages, so I checked the log and found 
 this:
 
 Jan 16 14:41:48 team dbmail/smtp[30181]: ReadConfig(): could not open config 
 file [dbmail.conf]
 
 my dbmail.conf is in /etc/dbmail.conf like it's supposed to be (I also tried 
 putting it in the same directory as dbmail-smtp)...how can I tell it where to 
 find the config file?
 
 thanks
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

Edit dbmail's main.c and search for dbmail.conf, you'll notice the path
is hardcoded as dbmail.conf, not /etc/dbmail.conf, change it to
/etc/dbmail.conf and recompile.

Will work after that, beware of the two issues I just posted about
though.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Postfix, Majordomo, DBMail, Mysql....?

[Ryan Butler]

On Tue, 2003-01-07 at 11:39, Joby Walker wrote:
 Ryan Butler wrote:

 
 How is this done with Mailman?  Is the user the pipe to the external 
 program?
 
 jbw
 
 


In the aliases the alias if the list name, for example dbmail@dbmail.org
and the deliver to is the pipe command.  If you want archiving to work
you need to use ! instead of | for the pipe command though.

eg:

insert into aliases values('','dbmail@dbmail.org','!/home/mailman/bin/wrapper 
post dbmail','');


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Dbmail on freebsd.

[Ryan Butler]

On Fri, 2002-12-13 at 10:36, Tim Uckun wrote:
 At 07:12 AM 12/13/2002 -0800, Mike Jackson wrote:
   Has anybody compiled dbmail on freebsd before?
 
 I may be forgetting something, but I think all I had to do was create a
 symlink that pointed /usr/include/crypt.h to /usr/include/unistd.h. Then I
 ran the build.sh script and specified the correct paths to my MySQL libs and
 includes.
 
 I also did the symlink but I am trying to build with postgres.
 Include is set to /usr/local/include/
 lib is set to /usr/local/pgsql/lib/
 
 I get the following error message
 
 /usr/libexec/elf/ld: cannot find -lpq
 *** Error code 1
 
 Trying to compile 1.0
 
 
 

You fail to mention how you are trying to build 1.0, with the old build
system, with the build.sh script for 1.0 or the autoconf in 1.0?


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Make failed : Makefile problems

[Ryan Butler]

On Wed, 2002-12-11 at 02:02, Roel Rozendaal - ICS wrote:
 Hi Ryan,
 
 for which version were those patches written?
 
 regards roel
 

automake_cvs_to_1.0.patch  
Updates the automake system to the correct build rules for 1.0.
Built against version 1.0 release


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] problems with fetchmail

[Ryan Butler]

On Wed, 2002-12-11 at 08:39, Roel Rozendaal - ICS wrote:
 Well then it could be that the CAPA patch has an error - indeed the
 CVS version of dbmail-pop3d does not include support for CAPA. Could
 someone check the patch for errors?
 
 
 regards roel
 
 
 

The patch was tested with Ximian Evolution 1.2.0 and via telnet to
verify expected behaviour.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Make failed : Makefile problems

[Ryan Butler]

On Tue, 2002-12-10 at 07:37, Dusausoy Bruno wrote:
 I got it, the references to config.c (and the object file : config.o)
 are missing in the Makefile...
 
 How can i change that automatically ? (I don't want to edit all the
 Makefile manually)
 
 --
 Dusausoy Bruno
 

For the autoconf build (./configure)  there are patches that have been
submitted, but apparently not included yet.  You can find them on
http://dbmail.adiis.net

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Still waiting for bug resolutions

[Ryan Butler]

On Tue, 2002-12-10 at 04:24, Roel Rozendaal - ICS wrote:
 Hi andreas,
 
 Your first problem has been fixed - cvs has been updated, i'll update 
 the 1.0 release today. The 2nd and 3rd problem you describe are 
 currently being looked into but all the information you (or anyone else 
 on this list) can send is very welcome. For instance, could you be more 
 specific on which commands are failing? Thanks!
 
 regards roel
 
 


I hope that means a 1.0.1 or something will be coming out, its kinda of
chaotic to have 15 different 1.0.tar.gz's floating around all called the
same thing.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] DB replication patch

[Ryan Butler]

On Fri, 2002-12-06 at 03:31, Roel Rozendaal - ICS wrote:
 Hi Klas,
 

 Our plan for the moment is to have two databases: one used in 
 production and the other as hot spare. When the live machine is used, 
 the succesfull update/insert/delete queries are performed at the hot 
 spare as well (by means of some script running in the background). At 
 failure, all there is to do is change dbmail.conf and send a SIGHUP to 
 the daemons. This system has one major drawback: if the 
 update/insert/delete query fails on the hot spare but already has 
 succeeded on the production machine. We haven't figured this out 
 completely but then again: if the query fails probably something's 
 really wrong with the hot spare. What do you folks think about it?
 

Well, for innodb or bdb backed mysql and postgres, you could do it with
transactions theoretically, transaction the update/insert/delete
statements on the master, then do them on the hot spare, if it fails,
roll back, if not, commit.  Performance would be the question here.

For MyISAM users, another method would have to be devised.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] redundant smtp/pop3 with: dbmail + db [postgres] + postfix

[Ryan Butler]

On Thu, 2002-12-05 at 12:17, armin langhofer wrote:
 hi roel
 
 thanx for info; do you know if mysql4 supports what i want? i need the 
 mysql4 configured on 2 hosts with master-master databases. both dbs 
 should sync their data [replication] but it should be possible to write 
 in both dbs.
 
 armin.
 

I'm pretty sure it doesn't.  I thought I read on a roadmap on their site
somewhere that master - master replication was planned for the 4.2
series


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] dbmail/smtp could not open file dbmail.conf

[Ryan Butler]

On Wed, 2002-12-04 at 15:50, Jacques Beaudoin wrote:
 Messages from /var/log/maillog
 
 Any idea where to look
 
 Dec  4 16:41:13 mail1 dbmail/smtp[2267]: ReadConfig(): starting procedure
 Dec  4 16:41:13 mail1 dbmail/smtp[2267]: ReadConfig(): could not open 
 config file [dbmail.conf]  
 Dec  4 16:41:13 mail1 postfix/pipe[2253]: ADC6167CC7: 
 to=[EMAIL PROTECTED], relay=dbmail, delay=0, 
 status=deferred (temporary failure)
 
 
 Thanks
 
 ___

Covered earlier on the list, check the archives.

Edit main.c to have /etc/dbmail.conf instead of dbmail.conf

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] The Future

[Ryan Butler]

On Tue, 2002-12-03 at 14:05, Eelco van Beek - ICS wrote:

 Hi Ryan,
 
 We tried to incorporate autoconf in 1.0 but unfortunatly our autoconf 
 guy is on a 6 month leave and Roel and I are working on other stuff. To 
 fill in for the miss we incorporated a build script which should be 
 sufficient for now.
 It would have taken too long to fully incorporate it in the main source 
 tree before 1.0. We will however put it in 1.1.
 
 Best regards,
 
 Eelco
 


I guess I'm really confused.  I wasn't aware you had an autoconf guy,
which is why I submitted the autoconf stuff that is currently in 1.0 and
cvs  Since then I've submitted a couple of patches which would have
allowed dbmail to use either the old style build, or the autoconf build
interchangeably on the source
(http://dbmail.adiis.net/files/Makefile_includes.patch) and some fixups
for autoconf bugs
(http://dbmail.adiis.net/files/dbmail_must_choose_sql_backend.patch).  

Had these been applied dbmail could have used either build system
interchangeably.  Instead, the 1.0 tarball contains a mostly broken
without tinkering autoconf system that most people will probably try
because they see ./configure :)  If you have an autoconf guy who is
going to redo the work currently there, or if you weren't planning on
using my work, I don't understand why it was distributed with 1.0, and
if you are planning to use the current autoconf system, I don't
understand why the two non code invasive patches that would have put a
working autoconf system weren't applied.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions
http://dbmail.adiis.net - dbmail patches

Re: [Dbmail] Configure Bug, PGSQL

[Ryan Butler]

On Tue, 2002-11-26 at 09:44, WebWork Hostmaster wrote:
 Sorry to post this without checking the archives, but the mailing lists site
 seems to be down again.
 
 The source files in the pgsql directory have explicit paths to the
 PostgreSQL header files, so despite giving the correct local path to the
 configure command, compilation fails. The correct paths are being passed
 to the compiler, however, so it should simply be a matter of removing the
 path information from the .c files.
 

Patch submitted more than a week ago that fixes it.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Final release of dbmail 1.0

[Ryan Butler]

On Mon, 2002-12-02 at 12:53, Eelco van Beek - ICS wrote:
 Hi All,
 
 I'm sorry to inform you that we will release the final 1.0 version 
 tomorrow at 16:00 HT (Holland Time :) , GMT+1).
 This is due to the fact that the imap commandline scanner needs to be 
 rewritten to be compatible with squirrelmail (actually also to be fully 
 conform the RFC). Furthermore we need to finish up the dbmail website 
 and finish up the manuals.
 
 Sorry for the delay, but i promise we will release tomorrow at 16:00.
 
 Best regards,
 
 Eelco
 


Will the makefile and include patches I've submitted make it in before
1.0?  They fix problems iwth autoconf builds and make it more uniform
and can't impact stability.

-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Newbie: compile dbmail

[Ryan Butler]

On Mon, 2002-11-18 at 09:09, Jan Klaverstijn wrote:
 Hi all. This is my first encounter with dbmail and its community. I'm
 looking foward to working with both.
  
 I hope to be able to ulimately replace UW Imapd with dbmail. But first
 of all it should run. I downloaded the sources and now try to compile.
 I get some unresolved references I cannot explain. It looks like some
 scalars, defined in db.h, won't stick. The output from make is below.
 Can anyone get me going again? I work with Linux 2.4.19. Gcc is
 version 3.2. Mysql  Ver 11.18 Distrib 3.23.53a.
  
 Also I cannot quite place all instructions in the INSTALL file. They
 look as if they apply to an older version.
  
 Regards, Jan Klaverstijn
  
  

You didn't say whether you're using the old build system or the autoconf
system.  If you're using the autoconf system (which it looks like based
on the output)  then you need to specify --with-mysql on the configure
line.  Based on the output, you chose neither, so it created neither.


 Making all in mysql
 make[1]: Entering directory `/disk2/home/jan/rpms/dbmail/mysql'
 make[1]: Nothing to be done for `all'.
 make[1]: Leaving directory `/disk2/home/jan/rpms/dbmail/mysql'
 Making all in pgsql
 make[1]: Entering directory `/disk2/home/jan/rpms/dbmail/pgsql'
 make[1]: Nothing to be done for `all'.
 make[1]: Leaving directory `/disk2/home/jan/rpms/dbmail/pgsql'
 Making all in .
 make[1]: Entering directory `/disk2/home/jan/rpms/dbmail'
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c list.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c debug.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c dbmd5.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c md5.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c mime.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c main.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c pipe.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c bounce.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c forward.c
 gcc -DPACKAGE=\dbmail-smtp\ -DVERSION=\1.0\  -I. -I.  -g -O2
 -c memblock.c
 gcc  -g -O2  -o dbmail-smtp  list.o debug.o dbmd5.o md5.o mime.o
 main.o pipe.o bounce.o forward.o memblock.o  
 main.o: In function `main':
 /home/jan/rpms/dbmail/main.c:53: undefined reference to `db_connect'
 /home/jan/rpms/dbmail/main.c:56: undefined reference to `auth_connect'
 /home/jan/rpms/dbmail/main.c:192: undefined reference to
 `db_disconnect'
 /home/jan/rpms/dbmail/main.c:193: undefined reference to
 `auth_disconnect'
 /home/jan/rpms/dbmail/main.c:58: undefined reference to
 `db_disconnect'
 pipe.o: In function `insert_messages':
 /home/jan/rpms/dbmail/pipe.c:183: undefined reference to
 `auth_check_user'
 /home/jan/rpms/dbmail/pipe.c:355: undefined reference to
 `db_insert_message_block'
 /home/jan/rpms/dbmail/pipe.c:385: undefined reference to
 `db_update_message'
 /home/jan/rpms/dbmail/pipe.c:389: undefined reference to
 `db_check_sizelimit'
 /home/jan/rpms/dbmail/pipe.c:400: undefined reference to
 `auth_get_userid'
 /home/jan/rpms/dbmail/pipe.c:290: undefined reference to
 `db_insert_message'
 /home/jan/rpms/dbmail/pipe.c:299: undefined reference to
 `db_insert_message_block'
 /home/jan/rpms/dbmail/pipe.c:206: undefined reference to
 `auth_check_user'
 /home/jan/rpms/dbmail/pipe.c:224: undefined reference to
 `auth_user_exists'
 bounce.o: In function `bounce':
 /home/jan/rpms/dbmail/bounce.c:27: undefined reference to
 `db_get_config_item'
 /home/jan/rpms/dbmail/bounce.c:28: undefined reference to
 `db_get_config_item'
 /home/jan/rpms/dbmail/bounce.c:30: undefined reference to
 `db_get_config_item'
 forward.o: In function `pipe_forward':
 /home/jan/rpms/dbmail/forward.c:42: undefined reference to
 `db_get_config_item'
 /home/jan/rpms/dbmail/forward.c:167: undefined reference to
 `db_send_message_lines'
 /home/jan/rpms/dbmail/forward.c:214: undefined reference to
 `db_send_message_lines'
 collect2: ld returned 1 exit status
 make[1]: *** [dbmail-smtp] Error 1
 make[1]: Leaving directory `/disk2/home/jan/rpms/dbmail'
 make: *** [all-recursive] Error 1
-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions

Re: [Dbmail] Anon CVS access

[Ryan Butler]

On Wed, 2002-11-13 at 12:15, Joby Walker wrote:
 Is anonymous CVS access available for us to play with that version?
 
 jbw
 

Yes, and the instructions are available on www.dbmail.org

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

[Dbmail] PATCH: Makefile_includes.patch

[Ryan Butler]

Hello,

Attached is a patch that allows the autoconf system and the original
Makefiles to coexist easier.

Hardcoded path's have been removed fromt he mysql/*.c and pgsql/*.c
files and a Makefile directive has been included in Makefile.mysql and
Makefile.pgsql that defines the path.  The autoconf system automatically
generates the appropriate Makefiles with the paths.  This means if
you're using the old build system, rather than edit the path in the *.c
files, just change DBINCLUDE_PATH to the correct value and then compile.

No feature changes, so should be acceptable for 1.0

In addition all my pending patches can be found at: 
http://dbmail.adiis.net


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions
diff -ur dbmail/INSTALL dbmail.working/INSTALL
--- dbmail/INSTALL	Sat Oct 12 17:37:30 2002
+++ dbmail.working/INSTALL	Thu Nov  7 11:34:20 2002
@@ -39,7 +39,7 @@
 	with a user and password that can access the DBMAIL database. 
 
 	Do a find or a locate for mysql.h. Copy this path and set it in the 
-	dbmysql.h in the #include full path to mysql.h
+	Makefile under the DBINCLUDE_PATH directive.
 
 	If you want verbose debugging you can set the TRACE_LEVEL to 4 or 5. 
 	For normal messages the TRACE_LEVEL should be 2. If you experience any problems
diff -ur dbmail/Makefile.mysql dbmail.working/Makefile.mysql
--- dbmail/Makefile.mysql	Sat Jun  1 08:29:47 2002
+++ dbmail.working/Makefile.mysql	Thu Nov  7 11:31:49 2002
@@ -6,6 +6,8 @@
 DBASETYPE = mysql
 DBASE_AUTHTYPE = mysql
 
+DBINCLUDE_PATH = /usr/include/mysql
+
 AUTHOBJECT = $(DBASETYPE)/dbauth$(DBASE_AUTHTYPE).o
 MSGBUFOBJECT = $(DBASETYPE)/dbmsgbuf$(DBASETYPE).o
 SEARCHOBJECT = $(DBASETYPE)/dbsearch$(DBASETYPE).o
@@ -36,7 +38,7 @@
 # from compiler about vsyslog function 
 # Added the -D_SVID_SOURCE option because ipc.h asked me to.
 
-CFLAGS = -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE
+CFLAGS = -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -I $(DBINCLUDE_PATH)
 
 .PHONY: clean install
 
diff -ur dbmail/Makefile.pgsql dbmail.working/Makefile.pgsql
--- dbmail/Makefile.pgsql	Thu May 30 12:15:38 2002
+++ dbmail.working/Makefile.pgsql	Thu Nov  7 11:40:02 2002
@@ -6,6 +6,8 @@
 DBASETYPE = pgsql
 DBASE_AUTHTYPE = pgsql
 
+DBINCLUDE_PATH = /Library/PostgreSQL/include
+
 AUTHOBJECT = $(DBASETYPE)/dbauth$(DBASE_AUTHTYPE).o
 MSGBUFOBJECT = $(DBASETYPE)/dbmsgbuf$(DBASETYPE).o
 SEARCHOBJECT = $(DBASETYPE)/dbsearch$(DBASETYPE).o
@@ -37,7 +39,7 @@
 # from compiler about vsyslog function 
 # Added the -D_SVID_SOURCE option because ipc.h asked me to.
 
-CFLAGS = -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE
+CFLAGS = -Wall -O2 -D_BSD_SOURCE -D_SVID_SOURCE -I $(DBINCLUDE_PATH)
 
 .PHONY: clean install
 
diff -ur dbmail/mysql/dbauthmysql.c dbmail.working/mysql/dbauthmysql.c
--- dbmail/mysql/dbauthmysql.c	Tue Jun  4 11:04:53 2002
+++ dbmail.working/mysql/dbauthmysql.c	Thu Nov  7 11:32:21 2002
@@ -6,7 +6,7 @@
  */
 
 #include ../auth.h
-#include /usr/include/mysql/mysql.h
+#include mysql.h
 #include ../list.h
 #include ../debug.h
 #include stdlib.h
diff -ur dbmail/mysql/dbmsgbufmysql.c dbmail.working/mysql/dbmsgbufmysql.c
--- dbmail/mysql/dbmsgbufmysql.c	Mon Mar 25 10:17:21 2002
+++ dbmail.working/mysql/dbmsgbufmysql.c	Thu Nov  7 11:32:36 2002
@@ -7,7 +7,7 @@
 
 #include ../dbmsgbuf.h
 #include ../db.h
-#include /usr/include/mysql/mysql.h
+#include mysql.h
 #include stdlib.h
 #include string.h
 #include stdio.h
diff -ur dbmail/mysql/dbmysql.c dbmail.working/mysql/dbmysql.c
--- dbmail/mysql/dbmysql.c	Thu Nov  7 09:34:32 2002
+++ dbmail.working/mysql/dbmysql.c	Thu Nov  7 11:32:57 2002
@@ -5,7 +5,7 @@
  * Functions for connecting and talking to the Mysql database */
 
 #include ../db.h
-#include /usr/include/mysql/mysql.h
+#include mysql.h
 #include ../config.h
 #include ../pop3.h
 #include ../list.h
diff -ur dbmail/mysql/dbsearchmysql.c dbmail.working/mysql/dbsearchmysql.c
--- dbmail/mysql/dbsearchmysql.c	Mon Mar 25 10:17:21 2002
+++ dbmail.working/mysql/dbsearchmysql.c	Thu Nov  7 11:33:48 2002
@@ -6,7 +6,7 @@
 
 #include ../dbsearch.h
 #include ../db.h
-#include /usr/include/mysql/mysql.h
+#include mysql.h
 #include ../rfcmsg.h
 #include stdlib.h
 #include stdio.h
diff -ur dbmail/pgsql/dbauthpgsql.c dbmail.working/pgsql/dbauthpgsql.c
--- dbmail/pgsql/dbauthpgsql.c	Thu Nov  7 09:34:32 2002
+++ dbmail.working/pgsql/dbauthpgsql.c	Thu Nov  7 11:36:55 2002
@@ -7,9 +7,7 @@
  */
 
 #include ../auth.h
-/*#include /usr/local/pgsql/include/libpq-fe.h*/
-/*#include /usr/include/postgresql/libpq-fe.h*/
-#include /Library/PostgreSQL/include/libpq-fe.h
+#include libpq-fe.h
 
 #include ../list.h
 #include ../debug.h
diff -ur dbmail/pgsql/dbmsgbufpgsql.c dbmail.working/pgsql/dbmsgbufpgsql.c
--- dbmail/pgsql/dbmsgbufpgsql.c	Thu Nov  7 09:34:32 2002
+++ dbmail.working/pgsql/dbmsgbufpgsql.c	Thu Nov  7 11:37:04 2002
@@ -9,9 +9,7 @@
 
 #include ../dbmsgbuf.h
 #include ../db.h
-/*#include /usr/local/pgsql/include/libpq-fe.h*/
-/*#include /usr/include/postgresql/libpq-fe.h*/
-#include /Library/PostgreSQL

[Dbmail] PATCH: pop3_capa.patch

[Ryan Butler]

Included below is a patch to support RFC 2449, the POP3 CAPA command.


-- 
Ryan Butler [EMAIL PROTECTED]
ADI Internet Solutions
http://dbmail.adiis.net

diff -ur dbmail/pop3.c dbmail.working/pop3.c
--- dbmail/pop3.c	Wed Jun 19 05:39:48 2002
+++ dbmail.working/pop3.c	Tue Nov 12 11:09:02 2002
@@ -29,7 +29,7 @@
 const char *commands [] = 
 {
   quit, user, pass, stat, list, retr, dele, noop, last, rset,
-  uidl,apop,auth,top
+  uidl,apop,auth,top,capa
 };
 
 const char validchars[] = 
@@ -112,7 +112,7 @@
   /* commands that are allowed to have no arguments */
   if ((value==NULL)  (cmdtype!=POP3_QUIT)  (cmdtype!=POP3_LIST) 
   (cmdtype!=POP3_STAT)  (cmdtype!=POP3_RSET)  (cmdtype!=POP3_NOOP) 
-  (cmdtype!=POP3_LAST)  (cmdtype!=POP3_UIDL)  (cmdtype!=POP3_AUTH)) 
+  (cmdtype!=POP3_LAST)  (cmdtype!=POP3_UIDL)  (cmdtype!=POP3_AUTH)  (cmdtype!=POP3_CAPA)) 
 {
   return pop3_error(stream,-ERR your command does not compute\r\n);
 }
@@ -541,6 +541,11 @@
 	return 1;
   }
 
+case POP3_CAPA:
+  {
+fprintf ((FILE *)stream, +OK Capability list follows\r\nTOP\r\nUSER\r\nUIDL\r\n.\r\n);
+return 1;
+  }
 default : 
   {
 	return pop3_error(stream,-ERR command not understood, sir\r\n);
diff -ur dbmail/pop3.h dbmail.working/pop3.h
--- dbmail/pop3.h	Wed Mar 13 10:32:28 2002
+++ dbmail.working/pop3.h	Tue Nov 12 10:56:00 2002
@@ -60,7 +60,8 @@
 #define POP3_APOP 11
 #define POP3_AUTH 12
 #define POP3_TOP 13
-#define POP3_END 14
+#define POP3_CAPA 14
+#define POP3_END 15
 
 /* all virtual_ definitions are session specific
  * when a RSET occurs all will be set to the real values */

Re: [Dbmail] How to unsubscribe the maillist

[Ryan Butler]

On Fri, 2002-10-25 at 07:58, eddy wrote:
 I.m sorry to interrupt you. I can't find the way to unsubscribe the 
 dbmail mailist. I can't  connect to 
 https://mailman.fastxs.nl/mailman/listinfo/dbmail.
 
 Regards,
 Eddy
 
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

In addition to this little tag on the bottom, a quick examination of the
email headers reveals several List-* headers including:

List-Unsubscribe: https://mailman.fastxs.nl/mailman/listinfo/dbmail,
mailto:[EMAIL PROTECTED]

Which provides an alternative way to unsubscribing than just the
website.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] Bounce messages

[Ryan Butler]

On Fri, 2002-10-18 at 18:07, Fredrik wrote:
 After reading the dbmail manual i have a few suggestions.
 
 DBMail shouldn't actually bounce a message if it has lost the connection 
 with the database (such as during a reboot of the dbserver)..
 It should send an error code back to the MTA with a softerror so that 
 the MTA can put the message back in the queue and retry to contact 
 dbmail-smtp a little bit later.
 

According to RFC 1893, dbmail should signal the mta to generate a 4xx
error code, specifically a 430 error code.


3.4 Mail system status

   X.3.0   Other or undefined mail system status

  The destination system exists and normally accepts mail, but
  something about the system has caused the generation of this
  DSN.


However, I don't believe dbmail supports anything other than standard
exit codes (eg can't be an lmtp server to deliver extended status
attributes).  So it should just exit with the can't write to mailbox
temp fail exit code and be done with it.

 Maybe something similar should be implementet for the quota bounce.
 

Quota bounces are also defined in 1893.  It should return a 422 and be
done with it.

  X.2.2   Mailbox full

  The mailbox is full because the user has exceeded a
  per-mailbox administrative quota or physical capacity.  The
  general semantics implies that the recipient can delete
  messages to make more space available.  This code should be
  used as a persistent transient failure.


 One suggestion would be.
 1. New incomming email that will exceed the quota.
 2. Dbmail sends a softerror/retrylater to the MTA and puts a small 
 warning message in the inbox.
So we're gonna push them even farther over the quota by filling their
mailbox with another message every time they get a mail that goes over
their quota...  why not just deliver the message?


 3. It continues to do this until a configurable timeperiod has passed.
That's a lot more tracking for the system.

 4. After the timeperiod has passed it should return to bouncing the 
 messages.
 
It should bounce the message with 422 immediately according to the rfc

Re: [Dbmail] dbmail working with exim4.

[Ryan Butler]

On Sat, 2002-10-12 at 05:19, Eric Renfro wrote:
 Well, after hammering, and hammering away with dbmail, after 1.0rc4's 
 release, 
 I plucked it right into my exim configuration, and so far, all but a few 
 lacking custom extensions of my own, namely a domains table storing domain 
 types for local and relays linked to the client_idnr, and another custom 
 table, forwards, allowing users to setup forwards to other non-local email 
 addresses, I have a pretty solid-apearing dbmail setup.
 
 Getting it to work, in it's basics, was actually fairly easy too, after doing 
 some hunting around and re-remembering how to do a few tricks of mine. ;)
 
 

The forwards table isn't necessary, the aliases table can take non-local
addresses as arguments to the deliver_to field.

 Second.
 
 I wanted to know how would be a good routine for nightly maintenance with 
 dbmail-maintenance. What command-line options should I use, to perform a 
 nightly dbmail routine?
 I'm using my own program, pgmaint, to schedule nightly vacuum jobs, since my 
 PostgreSQL server is strictly auth based.
 
-dfp are the options I use for dbmail-maintenance

 And then some future goals/questions? 
 With the numbers on dbmail.org on the status of the project being 99% in just 
 about everything, I doubt some of these will be included in the final 1.0 
 release, but I wanted to ask about them:
 
Those #'s are really really old, like around RC-1 timeframe, so most of
them are probably gonna be in 1.0


 AUTH methods, such as CRAM-MD5 and DIGEST-MD5, will they be supported? 
 (preferably without SASL getting in the way? G)

Well, the latest draft of the IMAP rfc has wording REQUIRING some form
of encrypted auth mechanism, or plaintext auth over SSL, which was an
IETF requirement.  So I'd say that will be on the TODO list, but dunno
how soon.

Re: [Dbmail] GOOD NEWS!!! IM from dbmail , dbmail sucks no support for it

[Ryan Butler]

On Thu, 2002-10-03 at 09:49, Abdulla Damingo wrote:
 As I said I got fustrated ok , just because you got everything working
 well does'nt mean you can kick others from trying
 

But just because you're frustrated  Its perfectly okay for you to bash
a program that several people spend a LOT of time working on, and that a
lot of people thank them for and use on a daily basis.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] cvs access down?

[Ryan Butler]

On Thu, 2002-10-03 at 09:43, Guy Redwood wrote:
 I don't seem to be able to log into the cvs server. Is the problem at my
 end?
 
 Guy
 

Nope, I currently get the same

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] Outlook 2000 bug

[Ryan Butler]

On Thu, 2002-10-03 at 11:38, Sam Przyswa wrote:
 Hi,
 
 We have noticed a bug in Outlook 2000, corrected on the XP version, if a 
 mailbox
 is created in the root directory, as Folder instead of INBOX/Folder 
 Outlook
 2000 try to replace INBOX by something else and this crash Outlook 2000.
 
 I know it's not a DBmail bug but it will be good to patch it to append
 the INBOX/ prefix in case the IMAP client forget it.
 
 What do you think about ?
 
 Sam.

It seems to me that imapd should just return NO Replacing Inbox is not
valid if we want the server to reject that case.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] Imapd is slow as hell

[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
 order and number of the fields is what you think might be there.
 
 Sure it's easiest to SELECT named fields as SELECT * and use raw[x] to get the
 value. Our main goal it's to speed up DBmail and any suggestions are welcome !
 

That is not the easiest method, because unless you're getting it as an
associative array (name/val pairs, etc)  Then you have no idea if raw[4]
is really what you expect on every installation (someone may have added
a field they need to the table).  That is why the inserts and selects
only ask for the columns they need in the order they need.  So that the
underlying table can be changed and not botch the whole system.

Re: [Dbmail] dbmail mailing list software

[Ryan Butler]

On Tue, 2002-09-17 at 13:41, kerberus wrote:
 anything specific about setting up mailing list software with dbmail, or 
 maybe a specific packages users have installed for mailing lists with 
 dbmail ??? hints appreciated.
 
 ___
 Dbmail mailing list
 Dbmail@dbmail.org
 https://mailman.fastxs.nl/mailman/listinfo/dbmail

Mailman works (obviously).  There's a thread back in the mailing list
archives about how to make mailman work properly (for archiving) with
dbmail.  Basically rather than using the | command in the alias, you use
the ! command which adds the From header Mailman's archiver is expecting
for the archives to work properly.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]

Re: [Dbmail] TODO update 11/9/2002

[Ryan Butler]

On Wed, 2002-09-11 at 18:47, Philip Warner wrote:

 
 - Can deliver but not retrieve (ie. prevent embarrassment - the results of 
 disabling the email account is initially only experienced by the user).
 

From our point of view, this is unacceptable since they are currently
Status: O

past due on an account, and therefore would be given user benefits and
not paying for them.  But the way the patch is written, it would be easy
to add different levels  But I doubt that I personally will code it in
unless I get more free time.

Re: [Dbmail] TODO update 11/9/2002

[Ryan Butler]

Outstanding issues from me:


account suspension - Temporarily suspends an email account so it can't
be retrieved or delivered to (non paying customers) without deleting the
account fully -- Patch sent previously, no comment so far from devel


autoconf fixes - added a couple more paths to the lookup, patch
submitted

sql header fixes - fixes to make the sql headers more generalized so
they'll work without twiddling on autoconf builds  patch sent, would
break non autoconf builds


Makefile fixes - fixes to make the sql header fixes patch work for both
autoconf and non autoconf builds



These are the bulk of the outstanding issues from me.

[Dbmail] Autoconf patches

[Ryan Butler]

Here are two patches for the autoconf system.

Patch #1 is a request by jesse on the #dbmail irc channel to add a
couple more common paths to the list of paths to check as these are the
standard paths mysql installs to on the os he uses.


Patch #2 was sent by someone else previously to the list, it converts
the #include's for the sql headers to path independant ones.  This will
brake non-autoconf builds, so it may not be applied right away if you
aren't ready to make autoconf the standard build system.  People who do
use the autoconf system will need to apply this patch (most likely) for
your build to work.

Still working out a couple of autoconf issues people are having,
feedback, questions, comments to the list or myself.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]




diff -ur dbmail/configure dbmail.work/configure
--- dbmail/configure	Fri Jul 26 16:22:43 2002
+++ dbmail.work/configure	Tue Sep  3 16:32:21 2002
@@ -1,116 +1,33 @@
 #! /bin/sh
+
 # Guess values for system-dependent variables and create Makefiles.
-# Generated by Autoconf 2.50.
+# Generated automatically using autoconf version 2.13 
+# Copyright (C) 1992, 93, 94, 95, 96 Free Software Foundation, Inc.
 #
-# Copyright 1992, 1993, 1994, 1995, 1996, 1998, 1999, 2000, 2001
-# Free Software Foundation, Inc.
 # This configure script is free software; the Free Software Foundation
 # gives unlimited permission to copy, distribute and modify it.
 
-# Be Bourne compatible
-if test -n ${ZSH_VERSION+set}  (emulate sh) /dev/null 21; then
-  emulate sh
-  NULLCMD=:
-elif test -n ${BASH_VERSION+set}  (set -o posix) /dev/null 21; then
-  set -o posix
-fi
-
-# Name of the executable.
-as_me=`echo $0 |sed 's,.*[\\/],,'`
-
-if expr a : '\(a\)' /dev/null 21; then
-  as_expr=expr
-else
-  as_expr=false
-fi
-
-rm -f conf$$ conf$$.exe conf$$.file
-echo conf$$.file
-if ln -s conf$$.file conf$$ 2/dev/null; then
-  # We could just check for DJGPP; but this test a) works b) is more generic
-  # and c) will remain valid once DJGPP supports symlinks (DJGPP 2.04).
-  if test -f conf$$.exe; then
-# Don't use ln at all; we don't have any links
-as_ln_s='cp -p'
-  else
-as_ln_s='ln -s'
-  fi
-elif ln conf$$.file conf$$ 2/dev/null; then
-  as_ln_s=ln
-else
-  as_ln_s='cp -p'
-fi
-rm -f conf$$ conf$$.exe conf$$.file
-
-as_executable_p=test -f
-
-# Support unset when possible.
-if (FOO=FOO; unset FOO) /dev/null 21; then
-  as_unset=unset
-else
-  as_unset=false
-fi
-
-# NLS nuisances.
-$as_unset LANG || test ${LANG+set} != set || { LANG=C; export LANG; }
-$as_unset LC_ALL || test ${LC_ALL+set} != set || { LC_ALL=C; export LC_ALL; }
-$as_unset LC_TIME || test ${LC_TIME+set} != set || { LC_TIME=C; export LC_TIME; }
-$as_unset LC_CTYPE || test ${LC_CTYPE+set} != set || { LC_CTYPE=C; export LC_CTYPE; }
-$as_unset LANGUAGE || test ${LANGUAGE+set} != set || { LANGUAGE=C; export LANGUAGE; }
-$as_unset LC_COLLATE || test ${LC_COLLATE+set} != set || { LC_COLLATE=C; export LC_COLLATE; }
-$as_unset LC_NUMERIC || test ${LC_NUMERIC+set} != set || { LC_NUMERIC=C; export LC_NUMERIC; }
-$as_unset LC_MESSAGES || test ${LC_MESSAGES+set} != set || { LC_MESSAGES=C; export LC_MESSAGES; }
-
-# IFS
-# We need space, tab and new line, in precisely that order.
-as_nl='
-'
-IFS= 	$as_nl
-
-# CDPATH.
-$as_unset CDPATH || test ${CDPATH+set} != set || { CDPATH=:; export CDPATH; }
-
-# Name of the host.
-# hostname on some systems (SVR3.2, Linux) returns a bogus exit status,
-# so uname gets run too.
-ac_hostname=`(hostname || uname -n) 2/dev/null | sed 1q`
-
-exec 61
-
-#
-# Initializations.
-#
+# Defaults:
+ac_help=
 ac_default_prefix=/usr/local
-cross_compiling=no
-subdirs=
-MFLAGS= MAKEFLAGS=
-SHELL=${CONFIG_SHELL-/bin/sh}
-
-# Maximum number of lines to put in a shell here document.
-# This variable seems obsolete.  It should probably be removed, and
-# only ac_max_sed_lines should be used.
-: ${ac_max_here_lines=38}
-
-# Avoid depending upon Character Ranges.
-ac_cr_az='abcdefghijklmnopqrstuvwxyz'
-ac_cr_AZ='ABCDEFGHIJKLMNOPQRSTUVWXYZ'
-ac_cr_09='0123456789'
-ac_cr_alnum=$ac_cr_az$ac_cr_AZ$ac_cr_09
-
-# Sed expression to map a string onto a valid sh and CPP variable names.
-ac_tr_sh=sed y%*+%pp%;s%[^_$ac_cr_alnum]%_%g
-ac_tr_cpp=sed y%*$ac_cr_az%P$ac_cr_AZ%;s%[^_$ac_cr_alnum]%_%g
-
-ac_unique_file=main.c
+# Any additions from configure.in:
+ac_help=$ac_help
+  --enable-maintainer-mode enable make rules and dependencies not useful
+  (and sometimes confusing) to the casual installer
+ac_help=$ac_help
+  --with-mysql=PATH   full path to mysql header directory
+ac_help=$ac_help
+  --with-pgsql=PATH   full path to pgsql header directory
 
 # Initialize some variables set by options.
-ac_init_help=
-ac_init_version=false
 # The variables have the same names as the options, with
 # dashes changed to underlines.
-cache_file=/dev/null
+build=NONE
+cache_file=./config.cache
 exec_prefix=NONE
+host=NONE
 no_create=
+nonopt=NONE
 no_recursion=
 prefix=NONE

RE: [Dbmail] Compiling from CVS

[Ryan Butler]

On Fri, 2002-08-23 at 17:35, Butch Evans wrote:
  I need to look at this as well.  Ideally the functionality 
  should be changed to --with-mysql-headers and 
  --with-mysql-libs, one thing you can try is export 
  LD_LIBRARY_PATH=/usr/local/datadisk/mysql/lib/mysql
  
  Then rerun configure with the argument you supplied before 
  and see how it goes.
 
 Same results.  I tried configure with --with-mysql and
 --with-mysql=/complete/path/.  Thanks for the tip.  More ideas?
 

A copy of your config.log would be helpful, you can send it just to me
if you don't want to clutter the list.  What shell do you use?  export
probably won't have any affect on *csh like shells, they use setenv
instead.

Re: [Dbmail] dbmail on solaris 9

[Ryan Butler]

On Tue, 2002-08-13 at 02:05, Shane Kerr wrote:

 How interested are the dbmail folks in portability?  If you want, I can
 have a stab at autoconfiscating the distribution.  I've done it for a
 few projects in the past.
 
 -- 
 Shane
 Carpe Diem

The latest CVS has been autoconfiscated for a couple weeks now.  It
builds either postgres or mysql depending on the arguments to configure
allowing for non-standard locations of headers and libraries as well. 
But that's about as far as I've gotten so far.  I haven't written any
replacement functions, etc for portability yet, basically because I
don't have much except for Linux and IRIX to test on.  So contribute
those patches to add replacement functions for OS's that need them and
whatever else is needed to build on your particular OS.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]