From chris@ex-parrot.com Fri Apr 13 04:11:53 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 14nu01-0006SL-00 for tpop3d-discuss@lists.beasts.org; Fri, 13 Apr 2001 04:11:53 +0100 Received: from caesious.cold.local ([62.253.134.204]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA28923; Fri, 13 Apr 2001 04:03:55 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 14ntzz-0003f1-00; Fri, 13 Apr 2001 04:11:51 +0100 Date: Fri, 13 Apr 2001 04:11:51 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Message-ID: <20010413041151.A13468@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Mail-Author: me Subject: [tpop3d-discuss] tpop3d 1.2.4 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: tpop3d 1.2.4 is now the current version; this fixes a couple of minor problems and has cleaner signal handling (including a SIGHUP handler to re-exec the daemon). In addition, there is a debugging option to log stack context in the event of a crash; this is intended for use by a couple of people who have reported problems, and works only on Linux at present. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ Any design problem can be solved by adding a level of indirection, apart from having too many levels of indirection (Cargill) From mhl@pobox.com Fri Apr 13 20:29:25 2001 Received: from mail11.svr.pol.co.uk ([195.92.193.23]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 14o9G1-0002JD-00 for tpop3d-discuss@lists.beasts.org; Fri, 13 Apr 2001 20:29:25 +0100 Received: from modem-117.beagle.dialup.pol.co.uk ([62.25.68.117] helo=gin.house.local) by mail11.svr.pol.co.uk with esmtp (Exim 3.13 #0) id 14o9Fz-0002CZ-00; Fri, 13 Apr 2001 20:29:23 +0100 Received: from mark by gin.house.local with local (Exim 3.12 #1 (Debian)) id 14o9GA-0004z5-00; Fri, 13 Apr 2001 20:29:34 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <15063.21406.150942.619383@gin.house.local> Date: Fri, 13 Apr 2001 20:29:34 +0100 (BST) From: Mark Longair To: Chris Lightfoot Cc: tpop3d-discuss@lists.beasts.org X-Mailer: VM 6.72 under 21.1 (patch 10) "Capitol Reef" XEmacs Lucid X-Face: $d5`nE*gX!tu15'JQ'#.U=+_T8%xC^Ds_|1{AU'8FV|>kvm6h.29& Subject: [tpop3d-discuss] autoconf / automake support in CVS Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: This probably needs a few explanatory notes, since the one thing I haven't done is to document what I've done. : ) I moved the old Makefile to Makefile.original; I was intending to fold the documentation from there into a description of the equivalent options that you get from the configure script, but I'm getting a bit bored of this now. Basically, bootstrap regenerates the various files automake and autoconf need - you should run it initially to create the configure script, and again if you change Makefile.am or configure.in Anyway, it all Works For Me, though I haven't tried it on any non Debian systems yet - I'd be interested in the results. I tried to just duplicate everything from the old Makefile, which means that there are some anomalies - e.g. I'm not sure that the option --with-mysql-root is in the usual autoconf spirit. These are the new options (I'm guessing you may want to change the defaults): --enable and --with options recognized: --enable-electric-fence Enable Electric Fence support [default=no] --enable-flock-locking Enable flock(2) locking [default=no] --enable-fcntl-locking Enable fcntl(2) locking [default=yes] --enable-dotfile-locking Enable dotfile locking [default=yes] --enable-cclient-locking Enable C-Client locking [default=yes] --enable-backtrace Enable backtrace(3) reporting in the case of crashes. [default=no] --enable-ignore-cclient-metadata Ignore C-Client metadata [default=yes] --with-authentication=TYPE Set the type of authentication used. TYPE can be passwd, shadow, pam or mysql [default=pam] --disable-snide-comments Use less snide responses --with-mailspool-directory=DIR Set the mailspool directory. [default=/var/spool/mail] --with-mysql-root=DIR Set root of MySQL distribution. Should contain include/mysql/mysql.h and lib/mysql/libmysqlclient.so [default=/usr] The version number is now defined in Makefile.am... Also, I've tried to make sure that make dist produces tarballs which can be built in the normal way... Again, that could do with some testing. cheers mark -- `I hope you noticed that was very rock and roll. Someone's going to have to clear that up, you know.' -- Steve Malkmus, accidentally knocking over a bottle of water. From chris@ex-parrot.com Tue Apr 24 01:04:35 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 14rqJn-0001vO-00 for tpop3d-discuss@lists.beasts.org; Tue, 24 Apr 2001 01:04:35 +0100 Received: from caesious.cold.local ([62.253.134.204]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA19987; Tue, 24 Apr 2001 00:56:22 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 14rqJm-0003j9-00; Tue, 24 Apr 2001 01:04:34 +0100 Date: Tue, 24 Apr 2001 01:04:34 +0100 From: Chris Lightfoot To: Paul Makepeace , tpop3d-discuss@lists.beasts.org Message-ID: <20010424010434.A14075@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Mail-Author: me Subject: [tpop3d-discuss] tpop3d 1.3.0 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: I have uploaded tpop3d-1.3.0 (testing version) to http://www.ex-parrot.com/~chris/tpop3d/tpop3d-1.3.0.tar.gz This version incorporates Mark's autoconf stuff and Paul's maildir support, as well as support for a more flexible mailbox naming strategy (`/var/spool/mail/$(domain)/$(user)') and a new authenticator (auth_other) which talks to an external program to support authentication. I've written a perl module which simplifies writing external authenticators (you override two methods in an object to do APOP and USER/PASS authentication), but would welcome examples from other languages. (Ruby? Scheme? etc. There is also scripts/nasty, which is The World's Worst Shell Script; not fit for any purpose whatsoever, and its arse may catch fire in a low-speed collision. Whatever....) NB! I do not regard this version as `production quality' yet. Also, I may have screwed up some of the portability whilst integrating support for maildir and auth_other. Please send me bug reports, patches (as well as the customary adulation ;) ). -- Chris Lightfoot -- www.ex-parrot.com/~chris/ Gentlemen! You can't fight in here! This is the War Room! (from `Dr. Strangelove') From chris@ex-parrot.com Sun May 13 01:52:15 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 14yk7L-0003x9-00 for tpop3d-discuss@lists.beasts.org; Sun, 13 May 2001 01:52:15 +0100 Received: from caesious.cold.local ([62.253.134.204]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA10255; Sun, 13 May 2001 01:43:36 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 14yk7K-0002rh-00; Sun, 13 May 2001 01:52:14 +0100 Date: Sun, 13 May 2001 01:52:14 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Message-ID: <20010513015214.A10629@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Mail-Author: me Subject: [tpop3d-discuss] tpop3d 1.3.1 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: 1.3.1 is now the current version of tpop3d. This incorporates all of the recent changes, including maildir and autoconf support, and auth_perl and auth_other. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ Hey-ey that leg was fine/ You mean to tell me that this stuff happens all the time? (`He Got The Wrong Foot Amputated', `Weird' Al Yankovic) From chris@madingley.org Tue May 22 11:56:08 2001 Received: from daleth.esc.cam.ac.uk ([131.111.64.59] helo=beth.esc.cam.ac.uk) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 1529pf-0007NK-00; Tue, 22 May 2001 11:56:07 +0100 Received: from aquila.esc.cam.ac.uk (janus.esc.cam.ac.uk [131.111.64.94]) by beth.esc.cam.ac.uk (8.9.1a/8.9.1) with ESMTP id LAA12623; Tue, 22 May 2001 11:56:05 +0100 Received: (from chris@localhost) by aquila.esc.cam.ac.uk (8.9.3/8.9.1) id LAA28794; Tue, 22 May 2001 11:56:05 +0100 Date: Tue, 22 May 2001 11:56:05 +0100 From: Chris Lightfoot To: Marcin Pacyna Cc: vmail-discuss@lists.beasts.org, tpop3d-discuss@lists.beasts.org Message-ID: <20010522115605.A28568@aquila.esc.cam.ac.uk> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3us In-Reply-To: X-Mail-Author: me Subject: [tpop3d-discuss] Re: [Vmail-discuss] migrating MD5 hash used in /etc/shadow to vmail-sql Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, May 17, 2001 at 04:57:38PM -0400, Marcin Pacyna wrote: > I'm trying to migrate my 600+ users from a regular POP3 setup (1 unix system > account per POP3 mailbox) to vmail-sql (mysql + tpop3d + exim) setup. One > of the concerns I have is migrating the passwords which are currently stored > in /etc/shadow as (AFAIK) MD5 hashes: (this is a RedHat 6.2 box BTW): > > example entry from /etc/shadow: > > domainvm1:$1$dsBlPaKU$OQ45C8IlRjE2GBq1uK.Qi.:11439:0:99999:7:-1:-1:114550524 > > however if I put that password hash string > ($1$dsBlPaKU$OQ45C8IlRjE2GBq1uK.Qi.) into the popbox table - I can't > authenticate. If I generate the password using the sample VE-passwd script > then auth works fine. The hash strings in /etc/shadow all start with '$1$' > which I think is the salt but I'm not sure what to do with it. > > In short - does anyone know how can I migrate/convert all the hashes from > /etc/shadow to something that tpop3d understands? OK, there is now a new tpop3d, 1.3.2, which supports various different sorts of password hashes in the MySQL database. This is a not-quite-released version, but it has been tested. Get it from http://www.ex-parrot.com/~chris/tpop3d/tpop3d-1.3.2.tar.gz You will need to alter your vmail-sql table with a command like ALTER TABLE popbox MODIFY password_hash VARCHAR(255) to accomodate the longer password hash strings. Then you can use {crypt}... system crypt {crypt_md5}... crypt_md5 as in Linux PAM {md5}... MD5 password {plaintext}... plaintext password used for APOP ... old-style untagged MD5 password Vmail-sql itself does not yet support these -- but it will shortly. Thus, to migrate your existing passwords, you should be able to simply copy the second field from /etc/shadow into the database, prefixing it with `{crypt}' or `{crypt_md5}'. (The two are equivalent on Linux because the system crypt(3) function detects the special $1$...$ syntax of crypt_md5 passwords and uses the right version of the crypt function accordingly. But this is not the case on other systems, so both options are provided in tpop3d.) -- Chris Lightfoot -- www.ex-parrot.com/~chris/ All human actions are equivalent, and all are doomed to failure. (Sartre) From wanted@gnu.univ.gda.pl Tue Jun 05 18:20:42 2001 Received: from gnu.univ.gda.pl ([153.19.120.250] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157KVW-0003CT-00 for tpop3d-discuss@lists.beasts.org; Tue, 05 Jun 2001 18:20:42 +0100 Received: from wanted by gnu.univ.gda.pl with local (Exim 3.12 #1 (Debian)) id 157KVE-0007pl-00 for ; Tue, 05 Jun 2001 19:20:24 +0200 Date: Tue, 5 Jun 2001 19:20:24 +0200 From: Marcin Sochacki To: tpop3d-discuss@lists.beasts.org Message-ID: <20010605192024.A30082@gnu.univ.gda.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i Subject: [tpop3d-discuss] minor bugfix proposal Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: Hello, just a quick bugfix proposal: # telnet 10.0.0.1 110 Trying 10.0.0.1... Connected to 10.0.0.1. Escape character is '^]'. +OK user luser@klient1.pl +OK Tell me your password. pass haslo_lusera +OK Welcome aboard! You have 1 messages. quit +OK Done Connection closed by foreign host. With correct spelling it should be 'Welcome aboard! You have 1 message.' :) Bye bye, Wanted From chris@ex-parrot.com Tue Jun 05 20:46:02 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157MmA-0003oj-00 for tpop3d-discuss@lists.beasts.org; Tue, 05 Jun 2001 20:46:02 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA18713; Tue, 5 Jun 2001 20:36:50 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 157Mm9-0006Bp-00; Tue, 05 Jun 2001 20:46:01 +0100 Date: Tue, 5 Jun 2001 20:46:01 +0100 From: Chris Lightfoot To: Marcin Sochacki Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] minor bugfix proposal Message-ID: <20010605204601.A23791@caesious.cold.local> References: <20010605192024.A30082@gnu.univ.gda.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010605192024.A30082@gnu.univ.gda.pl>; from wanted@gnu.univ.gda.pl on Tue, Jun 05, 2001 at 07:20:24PM +0200 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Tue, Jun 05, 2001 at 07:20:24PM +0200, Marcin Sochacki wrote: > Hello, just a quick bugfix proposal: > [...] > +OK Welcome aboard! You have 1 messages. [...] > With correct spelling it should be 'Welcome aboard! You have 1 message.' :) Fair enough. This will be in version 1.3.2, which will be out Real Soon Now (it incorporates support for crypt, crypt_md5 and other things in vmail-sql, and a couple of bug fixes). -- Chris Lightfoot -- www.ex-parrot.com/~chris/ An Englishman thinks that 100 miles is a long way; an American thinks that 100 years is a long time. From wanted@gnu.univ.gda.pl Tue Jun 05 21:48:34 2001 Received: from gnu.univ.gda.pl ([153.19.120.250] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157Nkg-00042o-00 for tpop3d-discuss@lists.beasts.org; Tue, 05 Jun 2001 21:48:34 +0100 Received: from wanted by gnu.univ.gda.pl with local (Exim 3.12 #1 (Debian)) id 157Nkf-0000VU-00 for ; Tue, 05 Jun 2001 22:48:33 +0200 Date: Tue, 5 Jun 2001 22:48:33 +0200 From: Marcin Sochacki To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] minor bugfix proposal Message-ID: <20010605224833.B1663@gnu.univ.gda.pl> References: <20010605192024.A30082@gnu.univ.gda.pl> <20010605204601.A23791@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010605204601.A23791@caesious.cold.local>; from chris@ex-parrot.com on Tue, Jun 05, 2001 at 08:46:01PM +0100 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Tue, Jun 05, 2001 at 08:46:01PM +0100, Chris Lightfoot wrote: > On Tue, Jun 05, 2001 at 07:20:24PM +0200, Marcin Sochacki wrote: > Fair enough. This will be in version 1.3.2, which will be > out Real Soon Now (it incorporates support for crypt, > crypt_md5 and other things in vmail-sql, and a couple of > bug fixes). Well, I've already downloaded 1.3.2 (beta?) which was announced a few days ago. Didn't check that message there yet :) Wanted From chris@madingley.org Wed Jun 06 10:09:19 2001 Received: from daleth.esc.cam.ac.uk ([131.111.64.59] helo=beth.esc.cam.ac.uk) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157ZJX-0005yb-00 for tpop3d-discuss@lists.beasts.org; Wed, 06 Jun 2001 10:09:19 +0100 Received: from aquila.esc.cam.ac.uk (janus.esc.cam.ac.uk [131.111.64.94]) by beth.esc.cam.ac.uk (8.9.1a/8.9.1) with ESMTP id KAA05577; Wed, 6 Jun 2001 10:09:18 +0100 Received: (from chris@localhost) by aquila.esc.cam.ac.uk (8.9.3/8.9.1) id KAA06154; Wed, 6 Jun 2001 10:09:18 +0100 Date: Wed, 6 Jun 2001 10:09:18 +0100 From: Chris Lightfoot To: Marcin Sochacki Cc: tpop3d-discuss@lists.beasts.org Message-ID: <20010606100918.B5678@aquila.esc.cam.ac.uk> References: <20010605192024.A30082@gnu.univ.gda.pl> <20010605204601.A23791@caesious.cold.local> <20010605224833.B1663@gnu.univ.gda.pl> <20010605222012.A24053@caesious.cold.local> <20010605232808.A2811@gnu.univ.gda.pl> <20010606000646.A24361@caesious.cold.local> <20010606091834.A8375@gnu.univ.gda.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3us In-Reply-To: <20010606091834.A8375@gnu.univ.gda.pl> X-Mail-Author: me Subject: [tpop3d-discuss] Reply-To: munging Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Wed, Jun 06, 2001 at 09:18:34AM +0200, Marcin Sochacki wrote: > On Wed, Jun 06, 2001 at 12:06:46AM +0100, Chris Lightfoot wrote: > > On Tue, Jun 05, 2001 at 11:28:08PM +0200, Marcin Sochacki wrote: > > > Can we switch Mailman to automatically set Reply-To header? > > > It's very uncomfortable to remember about changing the address every time > > > I want to post something. > > > > I'll think about it, but, since you seem to be using mutt, > > why not just use `g' to group-reply? > > `g' does not always work for me, and even though Mailman author says it's bad, > most discussion lists set Reply-To. Hmm. I can't see why `g' doesn't work. IWFM. > The reasoning for not setting > Reply-To header is rather unclear to me. Well, the two articles usually quoted in this context are-- http://www.unicom.com/pw/reply-to-harmful.html reply-to munging considered harmful and http://marc.merlins.org/~merlin/perso/reply-to-useful.html reply-to munging considered useful The standard of argument in these two articles, especially the second, is fairly laughable, as you might expect. About the only decent points in them are: 1. replacing a proper reply-to with the list's address may hide the author's intentions, making it impossible to reply to an individual author; 2. not replacing the reply-to with the list's address may lead to a substantial waste of time and bandwidth as numerous addresses `snowball' into the recipients for each message; 3. inserting the name of the list in the reply-to header violates the `principle of least surprise', because people do not expect replies to go to the list unless they have specifically asked for this to happen by typing `g' or answering `yes' to `reply to all recipients'. A fourth argument which some people find convincing is-- 4. RFC822 says that you should munge the reply-to headers for `text-message teleconferencing'. This is just plain silly. The fact that the RFC says something doesn't mean that it is gospel truth, and it doesn't answer the point in (1) above. In my opinion, whatever the strength of the other arguments, (1) clinches it. So, on that basis, I don't anticipate changing the list to munge reply-to headers. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``You can't say that, because it's true.'' (unnamed Russian censor, to Malcom Muggeridge, 1933) From Paul.Makepeace@realprogrammers.com Wed Jun 06 20:33:57 2001 Received: from tantrix.realprogrammers.com ([216.228.5.63] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157j40-0000IZ-00 for tpop3d-discuss@lists.beasts.org; Wed, 06 Jun 2001 20:33:56 +0100 Received: from paulm by tantrix.realprogrammers.com with local (Exim 3.22 #1 (Debian)) id 157j3t-00053j-00 for tpop3d-discuss@lists.beasts.org; Wed, 06 Jun 2001 12:33:49 -0700 Date: Wed, 6 Jun 2001 12:33:49 -0700 To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] Reply-To: munging Message-ID: <20010606123349.A19124@tantrix.realprogrammers.com> Mail-Followup-To: tpop3d-discuss@lists.beasts.org References: <20010605192024.A30082@gnu.univ.gda.pl> <20010605204601.A23791@caesious.cold.local> <20010605224833.B1663@gnu.univ.gda.pl> <20010605222012.A24053@caesious.cold.local> <20010605232808.A2811@gnu.univ.gda.pl> <20010606000646.A24361@caesious.cold.local> <20010606091834.A8375@gnu.univ.gda.pl> <20010606100918.B5678@aquila.esc.cam.ac.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20010606100918.B5678@aquila.esc.cam.ac.uk> User-Agent: Mutt/1.3.18i From: Paul Makepeace Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Wed, Jun 06, 2001 at 10:09:18AM +0100, Chris Lightfoot wrote: > 1. replacing a proper reply-to with the list's address > may hide the author's intentions, making it > impossible to reply to an individual author; But it doesn't. It simply changes the reply-to which any halfway decent email client can override (for example, mutt prompts first the reply-to then the from). I.e. this point is scaremongery & FUD at best. Here's the funny bit: majordomo, which is probably still the most heavily used list mangler in the world *ignores users attempts to set reply-to* -- so, it is mangling reply-to *anyway*! Amusing when this argument comes up on a majordomo list (which I know this [yay!] isn't). > 2. not replacing the reply-to with the list's address > may lead to a substantial waste of time and > bandwidth as numerous addresses `snowball' into the > recipients for each message; This for me is the clincher. If you're on a community list that is encouraging discussion amongst all participants then having to constantly trim back To: and Cc: is a waste of time and irritating to get dupes. (Yes, I know there are some stunningly opaque procmail solutions using databases of message-ids but not all email clients set message-ids nor users should have the onerous task of using procmail in its more wizardly configurations.) > 3. inserting the name of the list in the reply-to > header violates the `principle of least surprise', At this point in time, it's not even slightly surprising so this rule is simply not applicable. > In my opinion, whatever the strength of the other > arguments, (1) clinches it. So, on that basis, I don't > anticipate changing the list to munge reply-to headers. I think it depends on the aim of the list, whether it's intended for community discussion or thing where the replies are most likely to go to the author. It's not black or white it depends on the situation. Incidently, mutt has a 'subscribe' directive which allows you to list reply with 'L'. On lists such as this it's very handy. Paul -- What would make this really successful? From chris@ex-parrot.com Wed Jun 06 20:49:26 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157jJ0-0000Ok-00 for tpop3d-discuss@lists.beasts.org; Wed, 06 Jun 2001 20:49:26 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA27378; Wed, 6 Jun 2001 20:40:11 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 157jIz-0007DF-00; Wed, 06 Jun 2001 20:49:25 +0100 Date: Wed, 6 Jun 2001 20:49:25 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] Reply-To: munging Message-ID: <20010606204925.A27718@caesious.cold.local> References: <20010605192024.A30082@gnu.univ.gda.pl> <20010605204601.A23791@caesious.cold.local> <20010605224833.B1663@gnu.univ.gda.pl> <20010605222012.A24053@caesious.cold.local> <20010605232808.A2811@gnu.univ.gda.pl> <20010606000646.A24361@caesious.cold.local> <20010606091834.A8375@gnu.univ.gda.pl> <20010606100918.B5678@aquila.esc.cam.ac.uk> <20010606123349.A19124@tantrix.realprogrammers.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010606123349.A19124@tantrix.realprogrammers.com>; from Paul.Makepeace@realprogrammers.com on Wed, Jun 06, 2001 at 12:33:49PM -0700 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: [Thinks: shouldn't have started this flamewar.] On Wed, Jun 06, 2001 at 12:33:49PM -0700, Paul Makepeace wrote: > On Wed, Jun 06, 2001 at 10:09:18AM +0100, Chris Lightfoot wrote: > > 1. replacing a proper reply-to with the list's address > > may hide the author's intentions, making it > > impossible to reply to an individual author; > > But it doesn't. It simply changes the reply-to which any halfway decent > email client can override (for example, mutt prompts first the reply-to > then the from). I.e. this point is scaremongery & FUD at best. I disagree. If I set a Reply-To:, I presumably have some good reason to do so; so, if the mailing list software goes and overwrites it with something else, my intentions will be lost. This sucks if you are forced to use a From: header which is not an address at which you can frequently read mail. > > 2. not replacing the reply-to with the list's address > > may lead to a substantial waste of time and > > bandwidth as numerous addresses `snowball' into the > > recipients for each message; > > This for me is the clincher. If you're on a community list that is > encouraging discussion amongst all participants then having to > constantly trim back To: and Cc: is a waste of time and irritating to > get dupes. (Yes, I know there are some stunningly opaque procmail > solutions using databases of message-ids but not all email clients set > message-ids nor users should have the onerous task of using procmail in > its more wizardly configurations.) It's rare indeed to find a message without a message-id nowadays. (Checks mailspool... OK, out of 6,573 messages I checked, a stunning 8 lacked a message-id, of which I suspect most were PINE metadata messages, which don't count.) The procmail incantation is... well, it's a procmail incantation, so one shouldn't expect to understand it. But as such things go, it's not too bad: # Discard duplicate mails :0 Wh: $HOME/.procmail/msgid.lock | formail -D 8192 $HOME/.procmail/msgid.cache > > In my opinion, whatever the strength of the other > > arguments, (1) clinches it. So, on that basis, I don't > > anticipate changing the list to munge reply-to headers. > > I think it depends on the aim of the list, whether it's intended for > community discussion or thing where the replies are most likely to go to > the author. It's not black or white it depends on the situation. > > Incidently, mutt has a 'subscribe' directive which allows you to list > reply with 'L'. On lists such as this it's very handy. Yes. Mutt rocks, etc. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ Never criticise somebody until you have walked a mile in their shoes. That way, they're a mile away, and you have their shoes. From pdw@ex-parrot.com Wed Jun 06 21:10:02 2001 Received: from mail12.svr.pol.co.uk ([195.92.193.215]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157jcw-0000Tx-00 for tpop3d-discuss@lists.beasts.org; Wed, 06 Jun 2001 21:10:02 +0100 Received: from [195.92.67.23] (helo=mail18.svr.pol.co.uk) by mail12.svr.pol.co.uk with esmtp (Exim 3.13 #0) id 157jaN-0000EU-00; Wed, 06 Jun 2001 21:07:23 +0100 Received: from modem-251.colorado.dialup.pol.co.uk ([62.137.57.251] helo=mythic-beasts.freeserve.co.uk) by mail18.svr.pol.co.uk with esmtp (Exim 3.13 #0) id 157jcu-0006ws-00; Wed, 06 Jun 2001 21:10:00 +0100 Received: from pdw by mythic-beasts.freeserve.co.uk with local (Exim 3.03 #1) id 157jcq-0000fC-00; Wed, 06 Jun 2001 21:09:56 +0100 Date: Wed, 6 Jun 2001 21:09:56 +0100 From: Paul Warren To: Chris Lightfoot Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] Reply-To: munging Message-ID: <20010606210956.D1169@cerberus.grovehouse.local> References: <20010605192024.A30082@gnu.univ.gda.pl> <20010605204601.A23791@caesious.cold.local> <20010605224833.B1663@gnu.univ.gda.pl> <20010605222012.A24053@caesious.cold.local> <20010605232808.A2811@gnu.univ.gda.pl> <20010606000646.A24361@caesious.cold.local> <20010606091834.A8375@gnu.univ.gda.pl> <20010606100918.B5678@aquila.esc.cam.ac.uk> <20010606123349.A19124@tantrix.realprogrammers.com> <20010606204925.A27718@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.2i In-Reply-To: <20010606204925.A27718@caesious.cold.local>; from chris@ex-parrot.com on Wed, Jun 06, 2001 at 08:49:25PM +0100 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Wed, Jun 06, 2001 at 08:49:25PM +0100, Chris Lightfoot wrote: > [Thinks: shouldn't have started this flamewar.] Oh it's fun. It's whole weeks since it came up on any of the other mailing lists I'm on, and I didn't get involved that time so I feel I ought to make up for lost time :-) > I disagree. If I set a Reply-To:, I presumably have some > good reason to do so; so, if the mailing list software > goes and overwrites it with something else, my intentions > will be lost. This sucks if you are forced to use a From: > header which is not an address at which you can frequently > read mail. Absolutely. > > This for me is the clincher. If you're on a community list that is > > encouraging discussion amongst all participants then having to > > constantly trim back To: and Cc: is a waste of time and irritating to > > get dupes. (Yes, I know there are some stunningly opaque procmail > > solutions using databases of message-ids but not all email clients set > > message-ids nor users should have the onerous task of using procmail in > > its more wizardly configurations.) I believe that mailman does, or can be made to, avoid sending dupes. Personally, I *like* appearing on the To: field. It means that my procmail filter pulls a copy into my inbox, rather than just into the list folder, and also, I can see the messages that are actually to me as the have a helpful little "T" next to them. I get enough spam each day to be fully aquainted with my "d" key, so dupes don't really bother me. > Yes. Mutt rocks, etc. No, I think that the author had it right - it just sucks less. Paul From chris@ex-parrot.com Wed Jun 06 21:20:57 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157jnV-0000XR-00 for tpop3d-discuss@lists.beasts.org; Wed, 06 Jun 2001 21:20:57 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA805; Wed, 6 Jun 2001 21:11:43 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 157jnU-0007GO-00; Wed, 06 Jun 2001 21:20:56 +0100 Date: Wed, 6 Jun 2001 21:20:56 +0100 From: Chris Lightfoot To: Paul Warren Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] Reply-To: munging Message-ID: <20010606212056.B27851@caesious.cold.local> References: <20010605204601.A23791@caesious.cold.local> <20010605224833.B1663@gnu.univ.gda.pl> <20010605222012.A24053@caesious.cold.local> <20010605232808.A2811@gnu.univ.gda.pl> <20010606000646.A24361@caesious.cold.local> <20010606091834.A8375@gnu.univ.gda.pl> <20010606100918.B5678@aquila.esc.cam.ac.uk> <20010606123349.A19124@tantrix.realprogrammers.com> <20010606204925.A27718@caesious.cold.local> <20010606210956.D1169@cerberus.grovehouse.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010606210956.D1169@cerberus.grovehouse.local>; from pdw@ex-parrot.com on Wed, Jun 06, 2001 at 09:09:56PM +0100 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Wed, Jun 06, 2001 at 09:09:56PM +0100, Paul Warren wrote: > On Wed, Jun 06, 2001 at 08:49:25PM +0100, Chris Lightfoot wrote: > > [Thinks: shouldn't have started this flamewar.] > > Oh it's fun. It's whole weeks since it came up on any of the other > mailing lists I'm on, and I didn't get involved that time so I feel I > ought to make up for lost time :-) Perhaps we should create reply-to-munging@lists.beasts.org? [duplicate mailings] > > > This for me is the clincher. If you're on a community list that is > > > encouraging discussion amongst all participants then having to > > > constantly trim back To: and Cc: is a waste of time and irritating to > > > get dupes. [...] > > I believe that mailman does, or can be made to, avoid sending dupes. Hmm. I'll have a look. [FX: Wanders in direction of mailman documentation, muttering darkly about the Principle of Least Surprise.] > Personally, I *like* appearing on the To: field. It means that my > procmail filter pulls a copy into my inbox, rather than just into the > list folder, and also, I can see the messages that are actually to me as > the have a helpful little "T" next to them. I get enough spam each day > to be fully aquainted with my "d" key, so dupes don't really bother me. This argument is also possessed of considerable merit. > > Yes. Mutt rocks, etc. > > No, I think that the author had it right - it just sucks less. Sucks less and rocks are about equivalent for software, I fear.... -- Chris Lightfoot -- www.ex-parrot.com/~chris/ language not worship must pink delirious sleep produce (fridge poetry) From Paul.Makepeace@realprogrammers.com Wed Jun 06 23:46:18 2001 Received: from tantrix.realprogrammers.com ([216.228.5.63] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 157m49-00013t-00 for tpop3d-discuss@lists.beasts.org; Wed, 06 Jun 2001 23:46:18 +0100 Received: from paulm by tantrix.realprogrammers.com with local (Exim 3.22 #1 (Debian)) id 157m48-0000TC-00 for tpop3d-discuss@lists.beasts.org; Wed, 06 Jun 2001 15:46:16 -0700 Date: Wed, 6 Jun 2001 15:46:16 -0700 To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] Reply-To: munging Message-ID: <20010606154616.T23307@tantrix.realprogrammers.com> Mail-Followup-To: tpop3d-discuss@lists.beasts.org References: <20010605192024.A30082@gnu.univ.gda.pl> <20010605204601.A23791@caesious.cold.local> <20010605224833.B1663@gnu.univ.gda.pl> <20010605222012.A24053@caesious.cold.local> <20010605232808.A2811@gnu.univ.gda.pl> <20010606000646.A24361@caesious.cold.local> <20010606091834.A8375@gnu.univ.gda.pl> <20010606100918.B5678@aquila.esc.cam.ac.uk> <20010606123349.A19124@tantrix.realprogrammers.com> <20010606204925.A27718@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20010606204925.A27718@caesious.cold.local> User-Agent: Mutt/1.3.18i From: Paul Makepeace Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Wed, Jun 06, 2001 at 08:49:25PM +0100, Chris Lightfoot wrote: > > But it doesn't. It simply changes the reply-to which any halfway decent > > email client can override (for example, mutt prompts first the reply-to > > then the from). I.e. this point is scaremongery & FUD at best. > > I disagree. If I set a Reply-To:, I presumably have some > good reason to do so; so, if the mailing list software > goes and overwrites it with something else, my intentions > will be lost. Right. What I was just saying was the irony that people configure majordomo to reply-to: and yet if said author attempts to set the reply-to in the manner you're describing it gets munged anyway. I've tried this and yup, I was SOL. > This sucks if you are forced to use a From: > header which is not an address at which you can frequently > read mail. In practice, I wonder what the %age of people this really applies to these days. A fun scripting challenge for a rainy day... I suspect in the sub-0.1% range anecdotally derived from never having seen anyone ever do it in the ten years I've been using email... > It's rare indeed to find a message without a message-id > nowadays. (Checks mailspool... OK, out of 6,573 messages I > checked, a stunning 8 lacked a message-id, of which I > suspect most were PINE metadata messages, which don't > count.) That's true. Fortunately that wasn't the nub of the argument :-) > The procmail incantation is... well, it's a procmail > incantation, so one shouldn't expect to understand it. But > as such things go, it's not too bad: > > # Discard duplicate mails > :0 Wh: $HOME/.procmail/msgid.lock > | formail -D 8192 $HOME/.procmail/msgid.cache Well, that's interesting. I've often wondered about that... Not that I use procmail (exim filtering seems good enough). Any scheme whose argument involves "well, you can use procmail to filter it out" would of course go to /dev/null by any reasonable standard. Paul, who'll argue either side depending on phase of moon :) -- Use cliches From chris@ex-parrot.com Sun Jun 10 23:47:38 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 159Dze-0000Ms-00 for tpop3d-discuss@lists.beasts.org; Sun, 10 Jun 2001 23:47:38 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA21703; Sun, 10 Jun 2001 23:38:19 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 159Dzd-0002nV-00; Sun, 10 Jun 2001 23:47:37 +0100 Date: Sun, 10 Jun 2001 23:47:37 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Message-ID: <20010610234737.A10516@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Mail-Author: me Subject: [tpop3d-discuss] tpop3d version 1.3.2 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: http://www.ex-parrot.com/~chris/tpop3d/tpop3d-1.3.2.tar.gz 1.3.2 Minor changes, and an update for auth_mysql to allow passwords in formats other than the default straight MD5 checksums. Different formats are denoted by a prefixed token enclosed in { }. Presently supported are: {crypt}... crypt(3) hash {crypt_md5}... crypt_md5 hash {plaintext}... plaintext password {md5} or no prefix old-style simple MD5 password This facility replaces the old apop_password field in the database; instead, APOP users should arrange for their passwords to be recorded in the plaintext format as above. The new vmail-sql will work in the same way, when it is released. In addition, there are a couple of fixes: a small memory leak was removed, and code was added to work around some bugs in old GNU libc versions. In view of the last paragraph, existing tpop3d installations should probably be upgraded. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``Do we really need two North Dakotas? I mean, we already have South Dakota as an emergency spare.'' (Scott Adams) From nancy@bigfishmail.com Thu Jun 21 22:19:03 2001 Received: from [209.85.110.105] (helo=mail1-mdr-R.bigfish.com) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DBqx-00062H-00 for tpop3d-discuss@lists.beasts.org; Thu, 21 Jun 2001 22:19:03 +0100 Received: from mail1-mdr.bigfish.com (localhost.localdomain [127.0.0.1]) by mail1-mdr-R.bigfish.com (Postfix) with ESMTP id 6F01257656 for ; Thu, 21 Jun 2001 21:18:36 +0000 (UCT) Received: from nancomp (unknown [207.155.18.194]) by mail1-mdr.bigfish.com (Postfix) with SMTP id 5508C55A3E for ; Thu, 21 Jun 2001 21:18:36 +0000 (UCT) From: "Nancy Pettigrew (work)" To: Date: Thu, 21 Jun 2001 14:18:21 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Subject: [tpop3d-discuss] quick question Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: Hi - I need to modify the auth_mysql.c to suit different authentication tables, so I've been perusing the auth_mysql_new_user_pass function in auth_mysql.c. Just curious about 1 line of code right now, line 446: query = (char*)malloc(l = (sizeof(user_pass_query_template) + strlen(user) * 2 + 1 + 34)); Just curious as to the origin of the * 2 + 1 + 34 in the malloc - why those numbers, specifically? Thanks. From chris@ex-parrot.com Thu Jun 21 23:50:16 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DDHE-0006LZ-00 for tpop3d-discuss@lists.beasts.org; Thu, 21 Jun 2001 23:50:16 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA13498; Thu, 21 Jun 2001 23:40:39 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15DDHC-0003Cb-00; Thu, 21 Jun 2001 23:50:14 +0100 Date: Thu, 21 Jun 2001 23:50:14 +0100 From: Chris Lightfoot To: "Nancy Pettigrew (work)" Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] quick question Message-ID: <20010621235014.A12303@caesious.cold.local> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from nancy@bigfishmail.com on Thu, Jun 21, 2001 at 02:18:21PM -0700 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, Jun 21, 2001 at 02:18:21PM -0700, Nancy Pettigrew (work) wrote: > Hi - > > I need to modify the auth_mysql.c to suit different authentication tables, > so I've been perusing the auth_mysql_new_user_pass function in auth_mysql.c. > Just curious about 1 line of code right now, line 446: > query = (char*)malloc(l = (sizeof(user_pass_query_template) + > strlen(user) * 2 + 1 + 34)); > Just curious as to the origin of the * 2 + 1 + 34 in the malloc - why those > numbers, specifically? char user_pass_query_template[] = "SELECT domain.path, popbox.mbox_name, popbox.password_hash, domain.unix_user " "FROM popbox, domain " "WHERE popbox.local_part = '%s' " "AND popbox.domain_name = '%s' " "AND popbox.domain_name = domain.domain_name"; authcontext auth_mysql_new_user_pass(const char *user, const char *pass) { /* ... */ query = (char*)malloc(l = (sizeof(user_pass_query_template) + strlen(user) * 2 + 1 + 34)); sizeof(user_pass_query_template) -- obvious; the fixed part of the query, plus the terminating \0; strlen(user) * 2 -- enough space for the username, if every character has to be escaped; 1 -- an extra byte (probably there in case I'd miscounted a terminating \0 ;) ) 34 -- an extra 34 bytes to make the computer feel good. In previous versions, the select statement was like SELECT ... WHERE local_part = '%s' AND password_hash = '%s' AND ... because the only sort of password hash supported was a straight MD5 hex hash; hence, another 32 byte + 2 * "'" was needed for this bit of the query. So, it wastes (but then frees) an extra 34 bytes for each query. Well spotted :) -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``Do we really need two North Dakotas? I mean, we already have South Dakota as an emergency spare.'' (Scott Adams) From chris@shagged.org Sat Jun 23 17:12:13 2001 Received: from rtfm.shagged.org ([195.11.8.226] helo=mail.shagged.org ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Dq17-0004wk-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 17:12:13 +0100 Received: from chris by mail.shagged.org with local (Exim 3.30 #1) id 15Dq14-000KAO-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 17:12:10 +0100 Date: Sat, 23 Jun 2001 17:12:10 +0100 From: Chris Elsworth To: tpop3d-discuss@lists.beasts.org Message-ID: <20010623171210.A77378@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i Subject: [tpop3d-discuss] Failure to compile out of the box Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: Hi all, Just trying to build tpop3d for the first time, on FreeBSD 4.3, with this configure: ./configure --enable-mbox-maildir And I get this: root@rtfm tpop3d-1.3.2> make make all-recursive Making all in init.d Making all in config gcc -Wall -g -o tpop3d -L/usr/lib/mysql auth_mysql.o auth_other.o auth_perl.o auth_pam.o auth_passwd.o authswitch.o cfgdirectives.o config.o connection.o errprintf.o list.o listener.o locks.o mailbox.o maildir.o mailspool.o main.o md5c.o pidfile.o pop3.o signals.o stringmap.o strtok_r.o substvars.o tokenise.o util.o vector.o -lpam main.o: In function `fork_child': /home/chris/tpop3d-1.3.2/main.c(.text+0x3f5): undefined reference to `muntrace' main.o: In function `main': /home/chris/tpop3d-1.3.2/main.c(.text+0xe49): undefined reference to `mtrace' *** Error code 1 Stop in /home/chris/tpop3d-1.3.2. *** Error code 1 Stop in /home/chris/tpop3d-1.3.2. *** Error code 1 Stop in /home/chris/tpop3d-1.3.2. root@rtfm tpop3d-1.3.2> Anyone have any ideas why that might be happening? I presume it's known to compile on FreeBSD since there's notes about it in the readme, but it doesn't appear to here :) Any suggestions welcome, cheers. -- Chris Elsworth - Software & Systems Developer / Systems Administrator girls = time x money (and time is money) . chrise@demon.net = money^2 (money is root of all evil) . . tel: 020 8371 1041 = _/(evil^2) = evil t h u s mob: 07968 324 693 From chris@ex-parrot.com Sat Jun 23 17:54:13 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Dqfl-00054f-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 17:54:13 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA15816; Sat, 23 Jun 2001 17:44:35 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15Dqfj-0004Z1-00; Sat, 23 Jun 2001 17:54:11 +0100 Date: Sat, 23 Jun 2001 17:54:11 +0100 From: Chris Lightfoot To: Chris Elsworth Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] Failure to compile out of the box Message-ID: <20010623175411.A17492@caesious.cold.local> References: <20010623171210.A77378@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010623171210.A77378@shagged.org>; from chris@shagged.org on Sat, Jun 23, 2001 at 05:12:10PM +0100 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sat, Jun 23, 2001 at 05:12:10PM +0100, Chris Elsworth wrote: > Hi all, > > Just trying to build tpop3d for the first time, on FreeBSD 4.3, with this > configure: > > ./configure --enable-mbox-maildir [...] > main.o: In function `fork_child': > /home/chris/tpop3d-1.3.2/main.c(.text+0x3f5): undefined reference to `muntrace' > main.o: In function `main': > /home/chris/tpop3d-1.3.2/main.c(.text+0xe49): undefined reference to `mtrace' > *** Error code 1 Ooh. Embarrassing. That one crept out the door with debugging code in :) mtrace/muntrace are GNU extensions for making the memory allocator generate diagnostic information. If you remove the two references to them (at lines 455 and 165 in main.c) everything should work correctly. I shall do a new release shortly to fix this. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ Q - What warning was given by you? A - Horn Q - What warning was given by the other party? A - Moo (insurance claim form) From root@shagged.org Sat Jun 23 17:59:36 2001 Received: from rtfm.shagged.org ([195.11.8.226] helo=mail.shagged.org ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Dqky-00059R-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 17:59:36 +0100 Received: from root by mail.shagged.org with local (Exim 3.30 #1) id 15Dqku-000KkS-00; Sat, 23 Jun 2001 17:59:32 +0100 Date: Sat, 23 Jun 2001 17:59:32 +0100 From: Charlie & To: Chris Lightfoot Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] Failure to compile out of the box Message-ID: <20010623175932.A79505@shagged.org> References: <20010623171210.A77378@shagged.org> <20010623175411.A17492@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010623175411.A17492@caesious.cold.local>; from chris@ex-parrot.com on Sat, Jun 23, 2001 at 05:54:11PM +0100 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sat, Jun 23, 2001 at 05:54:11PM +0100, Chris Lightfoot wrote: > On Sat, Jun 23, 2001 at 05:12:10PM +0100, Chris Elsworth wrote: > > Hi all, > > > > Just trying to build tpop3d for the first time, on FreeBSD 4.3, with this > > configure: > > > > ./configure --enable-mbox-maildir > [...] > > main.o: In function `fork_child': > > /home/chris/tpop3d-1.3.2/main.c(.text+0x3f5): undefined reference to `muntrace' > > main.o: In function `main': > > /home/chris/tpop3d-1.3.2/main.c(.text+0xe49): undefined reference to `mtrace' > > *** Error code 1 > > Ooh. Embarrassing. That one crept out the door with > debugging code in :) > > mtrace/muntrace are GNU extensions for making the memory > allocator generate diagnostic information. If you remove > the two references to them (at lines 455 and 165 in > main.c) everything should work correctly. I was beginning to wonder. I had a search of /usr/include, and all the src in tpop3d's tree, and couldn't find a single other reference to mtrace or muntrace. I found a couple of igmp_mtrace calls etc, but presumably completely unrelated. As predicted, works fine now :) > I shall do a new release shortly to fix this. :) -- Chris Elsworth - Software & Systems Developer / Systems Administrator girls = time x money (and time is money) . chrise@demon.net = money^2 (money is root of all evil) . . tel: 020 8371 1041 = _/(evil^2) = evil t h u s mob: 07968 324 693 From chris@shagged.org Sat Jun 23 18:55:52 2001 Received: from rtfm.shagged.org ([195.11.8.226] helo=mail.shagged.org ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DrdP-0005Ns-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 18:55:52 +0100 Received: from chris by mail.shagged.org with local (Exim 3.30 #1) id 15DrdM-000M3x-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 18:55:48 +0100 Date: Sat, 23 Jun 2001 18:55:48 +0100 From: Chris Elsworth To: tpop3d-discuss@lists.beasts.org Message-ID: <20010623185548.A82733@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i Subject: [tpop3d-discuss] MySQL Authentication Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: Hi. Me again. :) tpop3d has now compiled fine, and everything appears to work except MySQL authentication. Maildirs, mbox, and pam auth, are all fine. I'm not sure I 100% understand the data I have to return from MySQL to make it work, so first of all, could anyone here confirm that this is the right info: mysql> SELECT pop3_mbox.MailPath,pop3_mbox.UserName,pop3_mbox.Password,domain.UserID FROM pop3_mbox,domain WHERE pop3_mbox.UserName='mats' AND domain.DomainName='zakalwe.com' AND pop3_mbox.DomainID=domain.pop3_pwID; this returns one match: | MailPath | UserName | Password | UserID | | /var/mail/zakalwe.com/mats | mats | snip | 1025 | [where snip is an MD5 hash of a password, like $1$lJ$EN6ExaPgfp1d.T9w59/S4/ ] That's what I've put into auth_mysql.c : char user_pass_query_template[] = "SELECT pop3_mbox.UserName,pop3_mbox.Password,pop3_mbox.MailPath,domain.UserID " "FROM pop3_mbox,domain " "WHERE pop3_mbox.UserName = '%s' " "AND domain.DomainName = '%s' " "AND pop3_mbox.DomainID = domain.pop3_pwID"; (same for APOP, even though I'm not currently using it) But alas, I get: auth_mysql_new_user_pass: mats@zakalwe.com failed login with wrong passwordauth_ Am I doing the right thing, returning the right information? Thanks for any help (again, even though last time wasn't my fault) :) -- Chris Elsworth - Software & Systems Developer / Systems Administrator girls = time x money (and time is money) . chrise@demon.net = money^2 (money is root of all evil) . . tel: 020 8371 1041 = _/(evil^2) = evil t h u s mob: 07968 324 693 From chris@ex-parrot.com Sat Jun 23 18:56:29 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Dre1-0005PU-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 18:56:29 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA21995; Sat, 23 Jun 2001 18:46:51 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15Drdz-0004oI-00; Sat, 23 Jun 2001 18:56:27 +0100 Date: Sat, 23 Jun 2001 18:56:27 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Message-ID: <20010623185627.A18274@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Mail-Author: me Subject: [tpop3d-discuss] tpop3d version 1.3.3 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: http://www.ex-parrot.com/~chris/tpop3d/tpop3d-1.3.3.tar.gz This is a fix for a couple of portability bugs which crept in to version 1.3.2. Apologies for this SNAFU. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``[American] football combines the two worst features of American life: violence and committee meetings.'' (George Will) From chris@ex-parrot.com Sat Jun 23 19:05:02 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DrmI-0005Rf-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 19:05:02 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA23029; Sat, 23 Jun 2001 18:55:23 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15DrmG-0004pS-00; Sat, 23 Jun 2001 19:05:00 +0100 Date: Sat, 23 Jun 2001 19:05:00 +0100 From: Chris Lightfoot To: Chris Elsworth Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010623190500.A18499@caesious.cold.local> References: <20010623185548.A82733@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010623185548.A82733@shagged.org>; from chris@shagged.org on Sat, Jun 23, 2001 at 06:55:48PM +0100 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sat, Jun 23, 2001 at 06:55:48PM +0100, Chris Elsworth wrote: > Hi. Me again. :) > > tpop3d has now compiled fine, and everything appears to work except MySQL > authentication. Maildirs, mbox, and pam auth, are all fine. > > I'm not sure I 100% understand the data I have to return from MySQL to > make it work, so first of all, could anyone here confirm that this is the > right info: > > mysql> SELECT > pop3_mbox.MailPath,pop3_mbox.UserName,pop3_mbox.Password,domain.UserID > FROM pop3_mbox,domain WHERE pop3_mbox.UserName='mats' AND > domain.DomainName='zakalwe.com' AND pop3_mbox.DomainID=domain.pop3_pwID; > > this returns one match: > > | MailPath | UserName | Password | UserID | > | /var/mail/zakalwe.com/mats | mats | snip | 1025 | > > [where snip is an MD5 hash of a password, like $1$lJ$EN6ExaPgfp1d.T9w59/S4/ ] > > That's what I've put into auth_mysql.c : > > char user_pass_query_template[] = > "SELECT pop3_mbox.UserName,pop3_mbox.Password,pop3_mbox.MailPath,domain.UserID " > "FROM pop3_mbox,domain " > "WHERE pop3_mbox.UserName = '%s' " > "AND domain.DomainName = '%s' " > "AND pop3_mbox.DomainID = domain.pop3_pwID"; > > (same for APOP, even though I'm not currently using it) Errm. Have you altered the code which gets those values out of the row returned by MySQL? If not, they will be coming out in the wrong order. auth_mysql.c gets them in the order: path prefix for mailbox mailbox file name password hash unix user whereas you are, I think, retrieving username password hash path prefix unix user -- if you reorder things to look like SELECT pop3_mbox.MailPath, pop3_mbox.UserName, pop3_mbox.Password, domain.UserID [...] it should work (assuming that fred@example.com's mailspool is in MailPath/fred). > But alas, I get: > > auth_mysql_new_user_pass: mats@zakalwe.com failed login with wrong passwordauth_ > > Am I doing the right thing, returning the right information? Not quite, unless you've modified the authentication stuff separately. To use crypt_md5 as you appear to be doing, you need to insert {crypt_md5} before the password, like '{crypt_md5}$1$lJ$EN6ExaPgfp1d.T9w59/S4/' in the appropriate field. If this is already what you're doing, then something is wrong, but I'd need more information to diagnose it.... If you don't want to put {crypt_md5} in, you can make that password format the default, by altering lines 483--508 of auth_mysql.c -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``There's so much comedy on television. Does that cause comedy in the streets?'' (Dick Cavett) From chris@shagged.org Sat Jun 23 20:53:15 2001 Received: from rtfm.shagged.org ([195.11.8.226] helo=mail.shagged.org ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DtT1-0005dt-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 20:53:15 +0100 Received: from chris by mail.shagged.org with local (Exim 3.30 #1) id 15DtSx-000NE7-00; Sat, 23 Jun 2001 20:53:11 +0100 Date: Sat, 23 Jun 2001 20:53:11 +0100 From: Chris Elsworth To: Chris Lightfoot Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010623205311.A84822@shagged.org> References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010623190500.A18499@caesious.cold.local>; from chris@ex-parrot.com on Sat, Jun 23, 2001 at 07:05:00PM +0100 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sat, Jun 23, 2001 at 07:05:00PM +0100, Chris Lightfoot wrote: > > That's what I've put into auth_mysql.c : > > > > char user_pass_query_template[] = > > "SELECT pop3_mbox.UserName,pop3_mbox.Password,pop3_mbox.MailPath,domain.UserID " > > "FROM pop3_mbox,domain " > > "WHERE pop3_mbox.UserName = '%s' " > > "AND domain.DomainName = '%s' " > > "AND pop3_mbox.DomainID = domain.pop3_pwID"; > > > > (same for APOP, even though I'm not currently using it) > > Errm. Have you altered the code which gets those values > out of the row returned by MySQL? If not, they will be > coming out in the wrong order. auth_mysql.c gets them in > the order: Yeah, slight hiccup on my part that, I was originally getting them in the wrong order, and halfway through writing the mail noticed that, and fixed the order. Just didn't rewrite the mail properly, doh. That didn't fix it, however. > -- if you reorder things to look like > > SELECT pop3_mbox.MailPath, pop3_mbox.UserName, > pop3_mbox.Password, domain.UserID > [...] Yep, that's how it is now.. Shame I have to edit the source though - do you have any plans to make it a #define or something, and have it set from configure, or perhaps the config? It would make upgrading easier for people who like me, have to edit it - and I'm sure that means almost everyone not using the vmail-sql package. > it should work (assuming that fred@example.com's mailspool > is in MailPath/fred). > > > But alas, I get: > > > > auth_mysql_new_user_pass: mats@zakalwe.com failed login with wrong passwordauth_ > > > > Am I doing the right thing, returning the right information? > > Not quite, unless you've modified the authentication stuff > separately. To use crypt_md5 as you appear to be doing, > you need to insert {crypt_md5} before the password, like > > '{crypt_md5}$1$lJ$EN6ExaPgfp1d.T9w59/S4/' That worked. Is this documented anywhere except in the source? I couldn't find it. > If you don't want to put {crypt_md5} in, you can make that > password format the default, by altering lines 483--508 of > auth_mysql.c More source hackery - any chance of a auth_mysql_crypt_type option? :) Thanks for your help, it all works now :) -- Chris Elsworth - Software & Systems Developer / Systems Administrator girls = time x money (and time is money) . chrise@demon.net = money^2 (money is root of all evil) . . tel: 020 8371 1041 = _/(evil^2) = evil t h u s mob: 07968 324 693 From chris@shagged.org Sat Jun 23 22:11:00 2001 Received: from rtfm.shagged.org ([195.11.8.226] helo=mail.shagged.org ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DugF-0005lu-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 22:10:59 +0100 Received: from chris by mail.shagged.org with local (Exim 3.30 #1) id 15DugC-000NlR-00 for tpop3d-discuss@lists.beasts.org; Sat, 23 Jun 2001 22:10:56 +0100 Date: Sat, 23 Jun 2001 22:10:56 +0100 From: Chris Elsworth To: tpop3d-discuss@lists.beasts.org Message-ID: <20010623221056.A91265@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i Subject: [tpop3d-discuss] crypt.h on FreeBSD Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: Hi, One other thing worthy of mention - on all the FreeBSD systems I tried, crypt.h was not found by configure. I had to manually edit auth_mysql.c and replace #include with #include . That's the only version of crypt.h I appear to have: chris@rtfm tpop3d-1.3.2> find /usr/include -name crypt.h /usr/include/rpcsvc/crypt.h Worth adding to the configure script? -- Chris Elsworth - Software & Systems Developer / Systems Administrator girls = time x money (and time is money) . chrise@demon.net = money^2 (money is root of all evil) . . tel: 020 8371 1041 = _/(evil^2) = evil t h u s mob: 07968 324 693 From chris@ex-parrot.com Sun Jun 24 01:11:10 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DxUc-00068W-00 for tpop3d-discuss@lists.beasts.org; Sun, 24 Jun 2001 01:11:10 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA745; Sun, 24 Jun 2001 01:01:31 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15DxUa-0004yY-00; Sun, 24 Jun 2001 01:11:08 +0100 Date: Sun, 24 Jun 2001 01:11:08 +0100 From: Chris Lightfoot To: Chris Elsworth Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010624011108.A19074@caesious.cold.local> References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> <20010623205311.A84822@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010623205311.A84822@shagged.org>; from chris@shagged.org on Sat, Jun 23, 2001 at 08:53:11PM +0100 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sat, Jun 23, 2001 at 08:53:11PM +0100, Chris Elsworth wrote: > On Sat, Jun 23, 2001 at 07:05:00PM +0100, Chris Lightfoot wrote: > > > -- if you reorder things to look like > > > > SELECT pop3_mbox.MailPath, pop3_mbox.UserName, > > pop3_mbox.Password, domain.UserID > > [...] > > Yep, that's how it is now.. Shame I have to edit the source though - do > you have any plans to make it a #define or something, and have it set from > configure, or perhaps the config? It would make upgrading easier for > people who like me, have to edit it - and I'm sure that means almost > everyone not using the vmail-sql package. Hmm. I did think about this, but concluded that it wasn't worth doing, on the basis that to write a sensible way to configure this at runtime (or even at compile time) without editing source code would be a substantial undertaking. Including a perl interpreter (auth_perl) or allowing users to call into an external program (auth_other) seems to me a better and more general strategy. In particular, to allow people to choose a database query at runtime is subject to a number of subtleties and random design decisions; also, I don't wish to implement additional database drivers (auth_pgsql; auth_oracle; etc.), and I would be reluctant to include numerous such things into the source tree on the basis that it would make maintaining the program more difficult. The DBD::... drivers in perl are sufficient for this purpose, and I can't see any point in trying to replicate that work. > > it should work (assuming that fred@example.com's mailspool > > is in MailPath/fred). > > > > > But alas, I get: > > > > > > auth_mysql_new_user_pass: mats@zakalwe.com failed login with wrong passwordauth_ > > > > > > Am I doing the right thing, returning the right information? > > > > Not quite, unless you've modified the authentication stuff > > separately. To use crypt_md5 as you appear to be doing, > > you need to insert {crypt_md5} before the password, like > > > > '{crypt_md5}$1$lJ$EN6ExaPgfp1d.T9w59/S4/' > > That worked. Is this documented anywhere except in the source? I couldn't > find it. It's in the changelog (CHANGES file). It will be documented in the new vmail-sql release (Paul?). > > If you don't want to put {crypt_md5} in, you can make that > > password format the default, by altering lines 483--508 of > > auth_mysql.c > > More source hackery - any chance of a auth_mysql_crypt_type option? :) Probably not, for the reasons stated above, and because the only reason that there's support for password hashes without a keyword in {} is to remain backward-compatible with old vmail-sql installations. If it had been implemented this way from the start, there would be no `default password format'. > Thanks for your help, it all works now :) Excellent. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``We overbooked. But I can give you the co-pilot's seat if you know how to fly a 747.'' (Scott Adams, from `Dilbert') From chris@ex-parrot.com Sun Jun 24 01:14:20 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DxXg-00069m-00 for tpop3d-discuss@lists.beasts.org; Sun, 24 Jun 2001 01:14:20 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA1135; Sun, 24 Jun 2001 01:04:41 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15DxXe-0004z5-00; Sun, 24 Jun 2001 01:14:18 +0100 Date: Sun, 24 Jun 2001 01:14:18 +0100 From: Chris Lightfoot To: Chris Elsworth Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] crypt.h on FreeBSD Message-ID: <20010624011418.B19074@caesious.cold.local> References: <20010623221056.A91265@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010623221056.A91265@shagged.org>; from chris@shagged.org on Sat, Jun 23, 2001 at 10:10:56PM +0100 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sat, Jun 23, 2001 at 10:10:56PM +0100, Chris Elsworth wrote: > Hi, > > One other thing worthy of mention - on all the FreeBSD systems I tried, > crypt.h was not found by configure. I had to manually edit auth_mysql.c > and replace #include with #include . On some systems the crypt(3) function is in crypt.h; in others, it is in unistd.h. The configure script detects this (by setting the macro CRYPT_FUNCTION_IN_CRYPT_H) but auth_mysql.c did not take account of this. I have now fixed it -- thanks. rpcsvc/crypt.h is not the same thing -- I don't have it on this linux system, but I imagine it's associated with RPC, which is not used in tpop3d. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``The effect of a bisection will in effect create two separate monopolies.'' (Judge Jackson, Microsoft antitrust hearing) From chris@shagged.org Sun Jun 24 01:26:52 2001 Received: from rtfm.shagged.org ([195.11.8.226] helo=mail.shagged.org ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Dxjo-0006Ex-00 for tpop3d-discuss@lists.beasts.org; Sun, 24 Jun 2001 01:26:52 +0100 Received: from chris by mail.shagged.org with local (Exim 3.30 #1) id 15Dxjk-000Pae-00 for tpop3d-discuss@lists.beasts.org; Sun, 24 Jun 2001 01:26:48 +0100 Date: Sun, 24 Jun 2001 01:26:48 +0100 From: Chris Elsworth To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] crypt.h on FreeBSD Message-ID: <20010624012648.A96050@shagged.org> Mail-Followup-To: tpop3d-discuss@lists.beasts.org References: <20010623221056.A91265@shagged.org> <20010624011418.B19074@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010624011418.B19074@caesious.cold.local>; from chris@ex-parrot.com on Sun, Jun 24, 2001 at 01:14:18AM +0100 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sun, Jun 24, 2001 at 01:14:18AM +0100, Chris Lightfoot wrote: > On Sat, Jun 23, 2001 at 10:10:56PM +0100, Chris Elsworth wrote: > > Hi, > > > > One other thing worthy of mention - on all the FreeBSD systems I tried, > > crypt.h was not found by configure. I had to manually edit auth_mysql.c > > and replace #include with #include . > > On some systems the crypt(3) function is in crypt.h; in > others, it is in unistd.h. The configure script detects > this (by setting the macro CRYPT_FUNCTION_IN_CRYPT_H) but > auth_mysql.c did not take account of this. I have now > fixed it -- thanks. > > rpcsvc/crypt.h is not the same thing -- I don't have it on > this linux system, but I imagine it's associated with RPC, > which is not used in tpop3d. oops - my MySQL authentication appears to be working, nonetheless :) So correctly, I should have changed it to unistd.h ? I imagine I'm not using any of the functions referenced to it, or they happen to magically coincide, because it all seems to be working :) -- Chris Elsworth - Software & Systems Developer / Systems Administrator girls = time x money (and time is money) . chrise@demon.net = money^2 (money is root of all evil) . . tel: 020 8371 1041 = _/(evil^2) = evil t h u s mob: 07968 324 693 From chris@ex-parrot.com Sun Jun 24 01:32:38 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15DxpO-0006GS-00 for tpop3d-discuss@lists.beasts.org; Sun, 24 Jun 2001 01:32:38 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA2458; Sun, 24 Jun 2001 01:23:00 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15DxpN-00053a-00; Sun, 24 Jun 2001 01:32:37 +0100 Date: Sun, 24 Jun 2001 01:32:37 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] crypt.h on FreeBSD Message-ID: <20010624013237.A19438@caesious.cold.local> References: <20010623221056.A91265@shagged.org> <20010624011418.B19074@caesious.cold.local> <20010624012648.A96050@shagged.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010624012648.A96050@shagged.org>; from chris@shagged.org on Sun, Jun 24, 2001 at 01:26:48AM +0100 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sun, Jun 24, 2001 at 01:26:48AM +0100, Chris Elsworth wrote: > On Sun, Jun 24, 2001 at 01:14:18AM +0100, Chris Lightfoot wrote: > > On Sat, Jun 23, 2001 at 10:10:56PM +0100, Chris Elsworth wrote: > > > Hi, > > > > > > One other thing worthy of mention - on all the FreeBSD systems I tried, > > > crypt.h was not found by configure. I had to manually edit auth_mysql.c > > > and replace #include with #include . > > > > On some systems the crypt(3) function is in crypt.h; in > > others, it is in unistd.h. The configure script detects > > this (by setting the macro CRYPT_FUNCTION_IN_CRYPT_H) but > > auth_mysql.c did not take account of this. I have now > > fixed it -- thanks. > > > > rpcsvc/crypt.h is not the same thing -- I don't have it on > > this linux system, but I imagine it's associated with RPC, > > which is not used in tpop3d. > > oops - my MySQL authentication appears to be working, nonetheless :) So > correctly, I should have changed it to unistd.h ? I imagine I'm not using > any of the functions referenced to it, or they happen to magically > coincide, because it all seems to be working :) I don't know exactly how the system headers are confgigured on BSD systems, but presumably it turns out that one of the headers that file did include included the header which prototypes crypt(3). -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``The only reason [George W. Bush] gets lost in thought is because it is unfamiliar territory.'' (newspaper editorial) From pdw@ex-parrot.com Sun Jun 24 12:40:52 2001 Received: from mail5.svr.pol.co.uk ([195.92.193.20]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15E8G4-0007dh-00 for tpop3d-discuss@lists.beasts.org; Sun, 24 Jun 2001 12:40:52 +0100 Received: from modem-169.boron.dialup.pol.co.uk ([62.136.4.169] helo=mythic-beasts.freeserve.co.uk) by mail5.svr.pol.co.uk with esmtp (Exim 3.13 #0) id 15E8G4-0006oC-00; Sun, 24 Jun 2001 12:40:52 +0100 Received: from pdw by mythic-beasts.freeserve.co.uk with local (Exim 3.03 #1) id 15E8G3-0000IB-00; Sun, 24 Jun 2001 12:40:51 +0100 Date: Sun, 24 Jun 2001 12:40:51 +0100 From: Paul Warren To: Chris Lightfoot Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010624124051.A907@cerberus.grovehouse.local> References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> <20010623205311.A84822@shagged.org> <20010624011108.A19074@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.2i In-Reply-To: <20010624011108.A19074@caesious.cold.local>; from chris@ex-parrot.com on Sun, Jun 24, 2001 at 01:11:08AM +0100 Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sun, Jun 24, 2001 at 01:11:08AM +0100, Chris Lightfoot wrote: > > > Not quite, unless you've modified the authentication stuff > > > separately. To use crypt_md5 as you appear to be doing, > > > you need to insert {crypt_md5} before the password, like > > > > > > '{crypt_md5}$1$lJ$EN6ExaPgfp1d.T9w59/S4/' > > > > That worked. Is this documented anywhere except in the source? I couldn't > > find it. > > It's in the changelog (CHANGES file). It will be > documented in the new vmail-sql release (Paul?). Yes, it will be documented properly in the perpetually imminent next release of vmail :-) We should probably add a note to this effect in the tpop3d docs. Paul From chris@ex-parrot.com Sun Jun 24 14:30:47 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15E9yQ-0007v4-00 for tpop3d-discuss@lists.beasts.org; Sun, 24 Jun 2001 14:30:46 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA1488; Sun, 24 Jun 2001 14:21:07 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15E9yP-0007Cf-00; Sun, 24 Jun 2001 14:30:45 +0100 Date: Sun, 24 Jun 2001 14:30:45 +0100 From: Chris Lightfoot To: Paul Warren Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010624143045.A27685@caesious.cold.local> References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> <20010623205311.A84822@shagged.org> <20010624011108.A19074@caesious.cold.local> <20010624124051.A907@cerberus.grovehouse.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010624124051.A907@cerberus.grovehouse.local>; from pdw@ex-parrot.com on Sun, Jun 24, 2001 at 12:40:51PM +0100 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sun, Jun 24, 2001 at 12:40:51PM +0100, Paul Warren wrote: > On Sun, Jun 24, 2001 at 01:11:08AM +0100, Chris Lightfoot wrote: > > > > Not quite, unless you've modified the authentication stuff > > > > separately. To use crypt_md5 as you appear to be doing, > > > > you need to insert {crypt_md5} before the password, like > > > > > > > > '{crypt_md5}$1$lJ$EN6ExaPgfp1d.T9w59/S4/' > > > > > > That worked. Is this documented anywhere except in the source? I couldn't > > > find it. > > > > It's in the changelog (CHANGES file). It will be > > documented in the new vmail-sql release (Paul?). > > Yes, it will be documented properly in the perpetually imminent next > release of vmail :-) We should probably add a note to this effect in > the tpop3d docs. I think that such a note already exists. I have also written a discussion of how auth_mysql works, to distribute with tpop3d. I'll put this on the web, too. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``We are not without accomplishment. We have managed to distribute poverty equally.'' (Nguyen Co Thatch, Vietnamese Foreign Minister) From Paul.Makepeace@realprogrammers.com Tue Jun 26 00:20:41 2001 Received: from tantrix.realprogrammers.com ([216.228.5.63] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Efer-0006Oj-00 for tpop3d-discuss@lists.beasts.org; Tue, 26 Jun 2001 00:20:41 +0100 Received: from paulm by tantrix.realprogrammers.com with local (Exim 3.22 #1 (Debian)) id 15Efeo-0006eU-00 for tpop3d-discuss@lists.beasts.org; Mon, 25 Jun 2001 16:20:38 -0700 Date: Mon, 25 Jun 2001 16:20:38 -0700 To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010625162038.G25104@tantrix.realprogrammers.com> Mail-Followup-To: tpop3d-discuss@lists.beasts.org References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> <20010623205311.A84822@shagged.org> <20010624011108.A19074@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20010624011108.A19074@caesious.cold.local> User-Agent: Mutt/1.3.18i From: Paul Makepeace Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Sun, Jun 24, 2001 at 01:11:08AM +0100, Chris Lightfoot wrote: > Including a perl interpreter (auth_perl) or > allowing users to call into an external program > (auth_other) seems to me a better and more general > strategy. In particular, to allow people to choose a > database query at runtime is subject to a number of > subtleties and random design decisions; also, I don't wish > to implement additional database drivers (auth_pgsql; > auth_oracle; etc.), and I would be reluctant to include > numerous such things into the source tree on the basis > that it would make maintaining the program more difficult. > The DBD::... drivers in perl are sufficient for this > purpose, and I can't see any point in trying to replicate > that work. One thing worth noting here if only because it's intriguing and unexpected for most people is that for high performance database work perl is slow. The rate limiting factor in Oracle access using perl is, yup, perl. Funneling the data into perl structures and then retrieving them for use in the program, fast as this is compared to most scripting languages is still a dominant chunk of the time spent accessing data from an Oracle database. So if a stated aim of tpop3d is speed, this might be a consideration for some (that aim was one of my origin reasons for selecting it). Oracle is really, really fast. Some point in the reasonably near future I will do auth_oracle.c (or whatever) as well as an exim patch. I was hoping to do this 'n' months ago where 'n' is now 'embarrassing' :-) Paul From chris@ex-parrot.com Tue Jun 26 00:34:13 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Efrx-0006Rc-00 for tpop3d-discuss@lists.beasts.org; Tue, 26 Jun 2001 00:34:13 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA6251; Tue, 26 Jun 2001 00:24:32 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15Efrv-0000VY-00; Tue, 26 Jun 2001 00:34:11 +0100 Date: Tue, 26 Jun 2001 00:34:11 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010626003411.A1760@caesious.cold.local> References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> <20010623205311.A84822@shagged.org> <20010624011108.A19074@caesious.cold.local> <20010625162038.G25104@tantrix.realprogrammers.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010625162038.G25104@tantrix.realprogrammers.com>; from Paul.Makepeace@realprogrammers.com on Mon, Jun 25, 2001 at 04:20:38PM -0700 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Mon, Jun 25, 2001 at 04:20:38PM -0700, Paul Makepeace wrote: > On Sun, Jun 24, 2001 at 01:11:08AM +0100, Chris Lightfoot wrote: > > Including a perl interpreter (auth_perl) or > > allowing users to call into an external program > > (auth_other) seems to me a better and more general > > strategy. In particular, to allow people to choose a > > database query at runtime is subject to a number of > > subtleties and random design decisions; also, I don't wish > > to implement additional database drivers (auth_pgsql; > > auth_oracle; etc.), and I would be reluctant to include > > numerous such things into the source tree on the basis > > that it would make maintaining the program more difficult. > > The DBD::... drivers in perl are sufficient for this > > purpose, and I can't see any point in trying to replicate > > that work. > > One thing worth noting here if only because it's intriguing and > unexpected for most people is that for high performance database work > perl is slow. The rate limiting factor in Oracle access using perl is, > yup, perl. Funneling the data into perl structures and then retrieving > them for use in the program, fast as this is compared to most scripting > languages is still a dominant chunk of the time spent accessing data > from an Oracle database. OK, I wasn't aware of that (though it makes sense...). > So if a stated aim of tpop3d is speed, this > might be a consideration for some (that aim was one of my origin reasons > for selecting it). Yeah, that's one of the stated aims :) However, unless you have really large tables of users I suspect that the cost of forking for each incoming connection are going to be much larger than the database lookup times. I haven't got any metrics to back this up, yet ;) Certainly, the time taken to index mailspools is going to be far longer, even for maildir. > Oracle is really, really fast. > > Some point in the reasonably near future I will do auth_oracle.c (or > whatever) as well as an exim patch. I was hoping to do this 'n' months > ago where 'n' is now 'embarrassing' :-) OK. That seems fair, especially if it's going to be combined with appropriate exim support. ISTR your talking about a syntax for generalising database queries in the exim config file. Do you propose to carry this over to tpop3d, and if so what syntax are you thinking of? -- Chris Lightfoot -- www.ex-parrot.com/~chris/ A cynic is a man who, upon smelling flowers, looks around for a coffin. (Mencken) From Paul.Makepeace@realprogrammers.com Tue Jun 26 20:17:32 2001 Received: from tantrix.realprogrammers.com ([216.228.5.63] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15EyL6-0002AN-00 for tpop3d-discuss@lists.beasts.org; Tue, 26 Jun 2001 20:17:32 +0100 Received: from paulm by tantrix.realprogrammers.com with local (Exim 3.22 #1 (Debian)) id 15EyKz-0003s7-00 for tpop3d-discuss@lists.beasts.org; Tue, 26 Jun 2001 12:17:25 -0700 Date: Tue, 26 Jun 2001 12:17:25 -0700 To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010626121725.B13851@tantrix.realprogrammers.com> Mail-Followup-To: tpop3d-discuss@lists.beasts.org References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> <20010623205311.A84822@shagged.org> <20010624011108.A19074@caesious.cold.local> <20010625162038.G25104@tantrix.realprogrammers.com> <20010626003411.A1760@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20010626003411.A1760@caesious.cold.local> User-Agent: Mutt/1.3.18i From: Paul Makepeace Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Tue, Jun 26, 2001 at 12:34:11AM +0100, Chris Lightfoot wrote: > On Mon, Jun 25, 2001 at 04:20:38PM -0700, Paul Makepeace wrote: > > might be a consideration for some (that aim was one of my origin reasons > > for selecting it). > > Yeah, that's one of the stated aims :) > > Certainly, the time taken to index mailspools is going to > be far longer, even for maildir. That's true. I guess I sometimes forget applications might actually be doing something besides retrieving and committing information to a database :-) > ISTR your talking about a syntax for generalising database > queries in the exim config file. Do you propose to carry > this over to tpop3d, and if so what syntax are you > thinking of? Right now exim allows you to put arbitrary SQL inside the query string with its own peculiar brand of ${variable_interpolation}. This string is "expanded" (in the exim terminology, i.e. variables filled in) and passed off to the underlying database API. My only extension to this was to provide bound variables so that an SQL query could be prepared & cached, and then queried with different data. e.g. "select genus, species from menagerie where bird = ?" and then when the statement is executed, it's passed a variable which is bound to the "?" (Oracle's syntax is a bit different but most people are more familiar with the ? so I'd probably use that.) It seems that exim's had a feature freeze with v3.30 so that's either a good thing or a bad thing depending on how long v4.0 takes to ship. Oh well. Answering the actual question: I'm not sure yet. I thought I had something and then realized it broke one form of exim's string expansion. The v4.0 might be different altho' I'd need to check. Oh, and actually remember all this stuff... Paul From chris@ex-parrot.com Tue Jun 26 20:26:26 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15EyTi-0002CQ-00 for tpop3d-discuss@lists.beasts.org; Tue, 26 Jun 2001 20:26:26 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA10204; Tue, 26 Jun 2001 20:16:44 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15EyTg-0001iI-00; Tue, 26 Jun 2001 20:26:24 +0100 Date: Tue, 26 Jun 2001 20:26:24 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Cc: Paul Makepeace Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010626202624.A6584@caesious.cold.local> References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> <20010623205311.A84822@shagged.org> <20010624011108.A19074@caesious.cold.local> <20010625162038.G25104@tantrix.realprogrammers.com> <20010626003411.A1760@caesious.cold.local> <20010626121725.B13851@tantrix.realprogrammers.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010626121725.B13851@tantrix.realprogrammers.com>; from Paul.Makepeace@realprogrammers.com on Tue, Jun 26, 2001 at 12:17:25PM -0700 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Tue, Jun 26, 2001 at 12:17:25PM -0700, Paul Makepeace wrote: > On Tue, Jun 26, 2001 at 12:34:11AM +0100, Chris Lightfoot wrote: > > On Mon, Jun 25, 2001 at 04:20:38PM -0700, Paul Makepeace wrote: > > > might be a consideration for some (that aim was one of my origin reasons > > > for selecting it). > > > > Yeah, that's one of the stated aims :) > > > > Certainly, the time taken to index mailspools is going to > > be far longer, even for maildir. > > That's true. I guess I sometimes forget applications might actually be > doing something besides retrieving and committing information to a > database :-) Well... that _is_ all it's doing, in the everything's-a-database model of mailboxes. I note that there are people (for instance, those wacky folks at Ars Digita) who store mailboxes in relational databases. This would be a fairly simple hack to tpop3d, though I can't see much purpose for it. It would, perhaps, be more useful for an IMAP server, since you could then do virtual-domains webmail very readily. > > ISTR your talking about a syntax for generalising database > > queries in the exim config file. Do you propose to carry > > this over to tpop3d, and if so what syntax are you > > thinking of? > > Right now exim allows you to put arbitrary SQL inside the query string > with its own peculiar brand of ${variable_interpolation}. This string is [... bound variables with ? ...] Could you not do the prepare-bind stuff automatically; that is, when you first see SELECT foo FROM bar WHERE baz = ${quux} identify that you need to treat ${quux} as an insertion variable and prepare SELECT foo FROM bar WHERE baz = ? then save these, and use the right one when it comes up? This would mean that you don't need to explicitly prepare statements, which would be a Big Win. OOI, how expensive is setting up a connection to the Oracle client library? From what I understand of the Exim architecture, it re-execs itself at the drop of a hat, pretty much.... > It seems that exim's had a feature freeze with v3.30 so that's either a > good thing or a bad thing depending on how long v4.0 takes to ship. Oh > well. Interesting. I didn't know that.... I see also that Phil Hazel has written a book, which might be worth a look I guess. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ Blow your mind. Smoke gunpowder. From Paul.Makepeace@realprogrammers.com Wed Jun 27 04:00:56 2001 Received: from tantrix.realprogrammers.com ([216.228.5.63] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15F5ZX-0003T8-00 for tpop3d-discuss@lists.beasts.org; Wed, 27 Jun 2001 04:00:56 +0100 Received: from paulm by tantrix.realprogrammers.com with local (Exim 3.22 #1 (Debian)) id 15F5ZV-0006d2-00 for tpop3d-discuss@lists.beasts.org; Tue, 26 Jun 2001 20:00:53 -0700 Date: Tue, 26 Jun 2001 20:00:53 -0700 To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] MySQL Authentication Message-ID: <20010626200053.A25305@tantrix.realprogrammers.com> Mail-Followup-To: tpop3d-discuss@lists.beasts.org References: <20010623185548.A82733@shagged.org> <20010623190500.A18499@caesious.cold.local> <20010623205311.A84822@shagged.org> <20010624011108.A19074@caesious.cold.local> <20010625162038.G25104@tantrix.realprogrammers.com> <20010626003411.A1760@caesious.cold.local> <20010626121725.B13851@tantrix.realprogrammers.com> <20010626202624.A6584@caesious.cold.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20010626202624.A6584@caesious.cold.local> User-Agent: Mutt/1.3.18i From: Paul Makepeace Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Tue, Jun 26, 2001 at 08:26:24PM +0100, Chris Lightfoot wrote: > On Tue, Jun 26, 2001 at 12:17:25PM -0700, Paul Makepeace wrote: > Well... that _is_ all it's doing, in the > everything's-a-database model of mailboxes. I note that > there are people (for instance, those wacky folks at Ars > Digita) who store mailboxes in relational databases. This > would be a fairly simple hack to tpop3d, though I can't > see much purpose for it. Avoidance of locking issues, flexibility in retrieval, advanced statistical processing (e.g. for lists or billing), integration into existing backup/recovery schemes (i.e. if you're backing up a related system you get that "for free"). I wonder if it could return a list of messages more quickly than a directory scan `a la Maildir... Certainly it could be mapped to fulfill IMAP semantics more directly. (Not that relevant to a popd discussion admittedly :-) > Could you not do the prepare-bind stuff automatically; > that is, when you first see > > SELECT foo FROM bar WHERE baz = ${quux} > > identify that you need to treat ${quux} as an insertion > variable and prepare > > SELECT foo FROM bar WHERE baz = ? IIUYC, You'd have to have some knowledge of SQL. For example, how do you cope with, SELECT ${column} FROM ${table} WHERE ${sql_condition} Only variables in conditions can be bound so the ${column} and ${table} couldn't be bound (but you'd have to have an SQL parser to divine those particular variables) and further you'd have to recursively perform this parsing if ${sql_condition} expanded to "${table_abbrev}.${column} = ${some_value}". > then save these, and use the right one when it comes up? Also, (at least with exim) you have the query in the query string, e.g, domains = ${lookup mysql {"SELECT ..."}{$value}} so you'd still need (with auto-preparation/binding) some additional syntax to specify what the bound variable is to be set _to_. > OOI, how expensive is setting up a connection to the > Oracle client library? I don't know, but anecdotally I get the impression it would be a big part of a single query. (Which is part of the win with mod_perl and its retention of an open db handle.) > > It seems that exim's had a feature freeze with v3.30 so that's either a > > good thing or a bad thing depending on how long v4.0 takes to ship. Oh > > well. > > Interesting. I didn't know that.... http://www.exim.org/pipermail/exim-announce/2001q2/000036.html Paul -- Change nothing and continue consistently From cdearborn@home.com Thu Jun 28 04:06:24 2001 Received: from mail2.rdc2.ab.home.com ([24.64.2.49]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15FS8O-0001JD-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 04:06:24 +0100 Received: from home.com ([24.70.96.63]) by mail2.rdc2.ab.home.com (InterMail vM.4.01.03.20 201-229-121-120-20010223) with ESMTP id <20010628030617.VOOU6449.mail2.rdc2.ab.home.com@home.com> for ; Wed, 27 Jun 2001 20:06:17 -0700 Message-ID: <3B3A9FB7.7010906@home.com> Date: Wed, 27 Jun 2001 21:08:39 -0600 From: Colin User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:0.9.1) Gecko/20010607 X-Accept-Language: en-us MIME-Version: 1.0 To: tpop3d-discuss@lists.beasts.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: [tpop3d-discuss] --enable-mysql-auth configure failure. Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: I seem to be having touble to get mysql authentication to compile into tpop3d. I can successfully go through the configuration without the --enable-mysql-auth option, but when I add it, I error out with: checking for mysql_init... no configure: error: vmail-sql authentication enabled, but mysql_init doesn't seem to be available. I'm on a Mandrake 8.0 system. I've tried compiling it on a Mandrake 7.2 system, but get the same error. I've tried upgrading my MySQL package to version 3.23.39-1. I've downloaded and manually compiled the C++ and perl API's from mysql.com, but I seem to be stuck at this point. Any suggestions? From chris@ex-parrot.com Thu Jun 28 09:45:42 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15FXQj-00020A-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 09:45:41 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA19302; Thu, 28 Jun 2001 09:35:55 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15FXQg-00040r-00; Thu, 28 Jun 2001 09:45:38 +0100 Date: Thu, 28 Jun 2001 09:45:38 +0100 From: Chris Lightfoot To: Colin Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] --enable-mysql-auth configure failure. Message-ID: <20010628094538.A15423@caesious.cold.local> References: <3B3A9FB7.7010906@home.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3B3A9FB7.7010906@home.com>; from cdearborn@home.com on Wed, Jun 27, 2001 at 09:08:39PM -0600 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Wed, Jun 27, 2001 at 09:08:39PM -0600, Colin wrote: > I seem to be having touble to get mysql authentication to compile into > tpop3d. > I can successfully go through the configuration without the > --enable-mysql-auth option, but when I add it, I error out with: > > checking for mysql_init... no > configure: error: vmail-sql authentication enabled, but mysql_init > doesn't seem to be available. > > I'm on a Mandrake 8.0 system. I've tried compiling it on a Mandrake 7.2 > system, but get the same error. I've tried upgrading my MySQL package > to version 3.23.39-1. I've downloaded and manually compiled the C++ and > perl API's from mysql.com, but I seem to be stuck at this point. > Any suggestions? It sounds as if configure can't find your MySQL installation. You can tell it where it is with --with-mysql-root=/some/path; the path given should contain include/mysql/mysql.h and lib/mysql/libmysqlclient.a. I don't know where Mandrake puts these files, but you should be able to find them with `locate'. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``The jawbone of an ass is just as dangerous a weapon today as in Samson's time.'' (Richard Nixon) From chris@ex-parrot.com Thu Jun 28 10:21:22 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15FXzG-0002CR-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 10:21:22 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA23414; Thu, 28 Jun 2001 10:11:37 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15FXzE-0004Hm-00; Thu, 28 Jun 2001 10:21:20 +0100 Date: Thu, 28 Jun 2001 10:21:20 +0100 From: Chris Lightfoot To: Colin Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] --enable-mysql-auth configure failure. Message-ID: <20010628102120.A16474@caesious.cold.local> References: <3B3A9FB7.7010906@home.com> <20010628094538.A15423@caesious.cold.local> <3B3AF69E.9050301@home.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3B3AF69E.9050301@home.com>; from cdearborn@home.com on Thu, Jun 28, 2001 at 03:19:26AM -0600 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, Jun 28, 2001 at 03:19:26AM -0600, Colin wrote: > > On Wed, Jun 27, 2001 at 09:08:39PM -0600, Colin wrote: > > > >>I seem to be having touble to get mysql authentication to compile into > >>tpop3d. [...] > > > > It sounds as if configure can't find your MySQL > > installation. You can tell it where it is with > > --with-mysql-root=/some/path; the path given should > > contain include/mysql/mysql.h and lib/mysql/libmysqlclient.a. > > > > I don't know where Mandrake puts these files, but you > > should be able to find them with `locate'. > > > I've tried that too. > Mandrake stuffs Mysql under /usr (/usr/include/mysql) > > I get the same error when specifying --with-mysql-root=/usr > (which, I beleive is the default for the config) What does the relevant section of config.log say? Look for the string `mysql_init'. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``Mr. Mandelson said it was an historic day when the politicians took charge of their own affairs.'' (sic.) (News report) From chris@ex-parrot.com Thu Jun 28 10:31:07 2001 Received: from mail1-gui.server.ntli.net ([194.168.222.13]) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15FY8h-0002Fc-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 10:31:07 +0100 Received: from caesious.cold.local ([62.253.134.38]) by mail1-gui.server.ntli.net (Post.Office MTA v3.1 release PO203a ID# 0-33929U70000L2S50) with ESMTP id AAA24612; Thu, 28 Jun 2001 10:21:22 +0100 Received: from chris by caesious.cold.local with local (Exim 3.03 #4) id 15FY8f-0004JO-00; Thu, 28 Jun 2001 10:31:05 +0100 Date: Thu, 28 Jun 2001 10:31:05 +0100 From: Chris Lightfoot To: Colin Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] --enable-mysql-auth configure failure. Message-ID: <20010628103105.A16553@caesious.cold.local> References: <3B3A9FB7.7010906@home.com> <20010628094538.A15423@caesious.cold.local> <3B3AF69E.9050301@home.com> <20010628102120.A16474@caesious.cold.local> <3B3AF930.7010806@home.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3B3AF930.7010806@home.com>; from cdearborn@home.com on Thu, Jun 28, 2001 at 03:30:24AM -0600 X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, Jun 28, 2001 at 03:30:24AM -0600, Colin wrote: > > > Chris Lightfoot wrote: > > > On Thu, Jun 28, 2001 at 03:19:26AM -0600, Colin wrote: > > [...] > >>I get the same error when specifying --with-mysql-root=/usr > >>(which, I beleive is the default for the config) > >> > > > > What does the relevant section of config.log say? Look for > > the string `mysql_init'. > > > It has: > > configure:2984: checking for mysql_init > configure:3012: gcc -o conftest -O2 -I/usr/include/mysql > -L/usr/lib/mysql conftest.c -lmysqlclient -lpam -ldl 1>&5 > > and: > > #include "confdefs.h" > /* System header to define __stub macros and hopefully few prototypes, > which can conflict with char mysql_init(); below. */ > #include > /* Override any gcc2 internal prototype to avoid an error. */ > /* We use char because int might match the return type of a gcc2 > builtin and then its argument prototype would still apply. */ > char mysql_init(); > > int main() { > > /* The GNU C library defines this for functions which it implements > to always fail with ENOSYS. Some functions are actually named > something starting with __ and the normal name is an alias. */ > #if defined (__stub_mysql_init) || defined (__stub___mysql_init) > choke me > #else > mysql_init(); > #endif > > ; return 0; } Can you try writing that bit of code out to a file, and compiling it with the compiler command line show, and tell me what error messages you get? -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``If we let people see that kind of thing, there would never again be any war.'' (US spokesman, on footage of Iraqi soldiers killed by helicopter gunfire) From chris@madingley.org Thu Jun 28 11:43:49 2001 Received: from daleth.esc.cam.ac.uk ([131.111.64.59] helo=beth.esc.cam.ac.uk) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15FZH2-0002UT-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 11:43:48 +0100 Received: from aquila.esc.cam.ac.uk (janus.esc.cam.ac.uk [131.111.64.94]) by beth.esc.cam.ac.uk (8.9.1a/8.9.1) with ESMTP id LAA09141; Wed, 28 Jun 2000 11:45:51 +0100 Received: (from chris@localhost) by aquila.esc.cam.ac.uk (8.9.3/8.9.1) id LAA25459; Thu, 28 Jun 2001 11:43:47 +0100 Date: Thu, 28 Jun 2001 11:43:47 +0100 From: Chris Lightfoot To: Colin Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] --enable-mysql-auth configure failure. Message-ID: <20010628114347.A25452@aquila.esc.cam.ac.uk> References: <3B3A9FB7.7010906@home.com> <20010628094538.A15423@caesious.cold.local> <3B3AF69E.9050301@home.com> <20010628102120.A16474@caesious.cold.local> <3B3AF930.7010806@home.com> <20010628103105.A16553@caesious.cold.local> <3B3AFC51.5060404@home.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3us In-Reply-To: <3B3AFC51.5060404@home.com> X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, Jun 28, 2001 at 03:43:45AM -0600, Colin wrote: > would you like any compiler flags? just the ones given -- should be gcc -O2 -I/usr/include/mysql -L/usr/lib/mysql conftest.c -lmysqlclient -lpam -ldl test.c > In the tpop3d-1.3.3 directory I tried: > > # gcc test.c > /tmp/ccNken5r.o: In function `main': > /tmp/ccNken5r.o(.text+0x7): undefined reference to `mysql_init' > collect2: ld returned 1 exit status Was this with no flags at all? If so, that's the expected behaviour. If you did have flags indicating to link with libmysqlclient, then there's something more serious wrong. -- Chris Lightfoot -- www.ex-parrot.com/~chris/ ``The reason that the sun never set on the British Empire is that God wouldn't trust an Englishman in the dark.'' (Duncan Spaeth) From chris@madingley.org Thu Jun 28 12:01:24 2001 Received: from daleth.esc.cam.ac.uk ([131.111.64.59] helo=beth.esc.cam.ac.uk) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15FZY4-0002at-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 12:01:24 +0100 Received: from aquila.esc.cam.ac.uk (janus.esc.cam.ac.uk [131.111.64.94]) by beth.esc.cam.ac.uk (8.9.1a/8.9.1) with ESMTP id MAA09222; Wed, 28 Jun 2000 12:03:27 +0100 Received: (from chris@localhost) by aquila.esc.cam.ac.uk (8.9.3/8.9.1) id MAA26134; Thu, 28 Jun 2001 12:01:23 +0100 Date: Thu, 28 Jun 2001 12:01:23 +0100 From: Chris Lightfoot To: Colin Cc: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] --enable-mysql-auth configure failure. Message-ID: <20010628120123.A25981@aquila.esc.cam.ac.uk> References: <3B3A9FB7.7010906@home.com> <20010628094538.A15423@caesious.cold.local> <3B3AF69E.9050301@home.com> <20010628102120.A16474@caesious.cold.local> <3B3AF930.7010806@home.com> <20010628103105.A16553@caesious.cold.local> <3B3AFC51.5060404@home.com> <20010628114347.A25452@aquila.esc.cam.ac.uk> <3B3B0CA2.4090601@home.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3us In-Reply-To: <3B3B0CA2.4090601@home.com> X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, Jun 28, 2001 at 04:53:22AM -0600, Colin wrote: > Yes, the previous result I gave you was with no flags at all. > I couldn't find conftest.c anywhere so I'm assuming that it should be > test.c (unless it's supposed to be another file I haven't yet created.) > > So I ran: > gcc -O2 -I/usr/include/mysql -L/usr/lib/mysql test.c -lm ysqlclient > -lpam -ldl test.c > > /tmp/ccYjIhWx.o: In function `main': > /tmp/ccYjIhWx.o(.text+0x0): multiple definition of `main' > /tmp/cc823ApF.o(.text+0x0): first defined here > /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': > my_compress.o(.text+0xaa): undefined reference to `uncompress' > /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function > `my_compress_alloc': > my_compress.o(.text+0x13d): undefined reference to `compress' > collect2: ld returned 1 exit status > > But that looks like conftest.c is supposed to be something else... > (/tmp/ccYjIhWx.o(.text+0x0): multiple definition of `main') No, that's correct. (The way configure tests for the presence of a function, in this case mysql_init, is by having a go at compiling a test program and seeing whether it compiles and links correctly.) It appears that what's happened here is that libmysqlclient wants to use the functions compress and uncompress, which at a guess are the ones in libz (the GNU zip compression library). Presumably MySQL now allows communication between client and server to be compressed on the fly. I hadn't encountered this before; in the interim, could you try altering configure so that references to -lmysqlclient become -lmysqlclient -lz, for instance by doing sed 's/-lmysqlclient/-lmysqlclient -lz' < configure > c2 mv c2 configure chmod +x configure ... and then try re-running configure, and see whether it works? -- Chris Lightfoot -- www.ex-parrot.com/~chris/ The meek may inherit the earth - but not its mineral rights. (Getty) From wanted@gnu.univ.gda.pl Thu Jun 28 22:43:08 2001 Received: from gnu.univ.gda.pl ([153.19.120.250] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15FjZ5-0005iN-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 22:43:07 +0100 Received: from wanted by gnu.univ.gda.pl with local (Exim 3.12 #1 (Debian)) id 15FjYe-0004qP-00; Thu, 28 Jun 2001 23:42:40 +0200 Date: Thu, 28 Jun 2001 23:42:40 +0200 From: Marcin Sochacki To: Chris Lightfoot Cc: Colin , tpop3d-discuss@lists.beasts.org Message-ID: <20010628234240.A18485@gnu.univ.gda.pl> References: <3B3A9FB7.7010906@home.com> <20010628094538.A15423@caesious.cold.local> <3B3AF69E.9050301@home.com> <20010628102120.A16474@caesious.cold.local> <3B3AF930.7010806@home.com> <20010628103105.A16553@caesious.cold.local> <3B3AFC51.5060404@home.com> <20010628114347.A25452@aquila.esc.cam.ac.uk> <3B3B0CA2.4090601@home.com> <20010628120123.A25981@aquila.esc.cam.ac.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010628120123.A25981@aquila.esc.cam.ac.uk>; from chris@ex-parrot.com on Thu, Jun 28, 2001 at 12:01:23PM +0100 Subject: [tpop3d-discuss] OFFTOPIC: reply-to munging Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: Chris, The problem of reply-to munging comes back... In this thread we have a nice example how useful it could be. Colin seems to use a simple "Reply", but you also post your replies to the group. The result is, that others can see only half of the discussion, which is just annoying. I don't want to start another flame-war, but you must admit, that for educational purposes it would be nice to make the whole discussion public (also in the archives). Most users need to perform some magic for a "proper" list reply. A munged reply-to is really not that harmful, and also is quite intuitive for most users. Marcin From Paul.Makepeace@realprogrammers.com Thu Jun 28 23:51:27 2001 Received: from tantrix.realprogrammers.com ([216.228.5.63] ident=mail) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15FkdC-00060P-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 23:51:26 +0100 Received: from paulm by tantrix.realprogrammers.com with local (Exim 3.22 #1 (Debian)) id 15Fkd5-0004A9-00 for tpop3d-discuss@lists.beasts.org; Thu, 28 Jun 2001 15:51:19 -0700 Date: Thu, 28 Jun 2001 15:51:19 -0700 To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] --enable-mysql-auth configure failure. Message-ID: <20010628155119.K19080@tantrix.realprogrammers.com> Mail-Followup-To: tpop3d-discuss@lists.beasts.org References: <3B3A9FB7.7010906@home.com> <20010628094538.A15423@caesious.cold.local> <3B3AF69E.9050301@home.com> <20010628102120.A16474@caesious.cold.local> <3B3AF930.7010806@home.com> <20010628103105.A16553@caesious.cold.local> <3B3AFC51.5060404@home.com> <20010628114347.A25452@aquila.esc.cam.ac.uk> <3B3B0CA2.4090601@home.com> <20010628120123.A25981@aquila.esc.cam.ac.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20010628120123.A25981@aquila.esc.cam.ac.uk> User-Agent: Mutt/1.3.18i From: Paul Makepeace Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, Jun 28, 2001 at 12:01:23PM +0100, Chris Lightfoot wrote: > sed 's/-lmysqlclient/-lmysqlclient -lz' < configure > c2 > mv c2 configure > chmod +x configure Or, perl -pi~ -e 's/-lmysqlclient/$& -lz/g' configure Once you're sure that worked, rm configure~, the backup copy Perl's -i switch preserves permissions and saves a manual 'mv'. (The $& is simply "the bit that matched") This is Debian with libc 2.3, tantrix:~$ for i in z mysqlclient; do echo "*** $i:"; nm /usr/lib/lib$i.a | grep compress; done *** z: compress.o: 00000000 T compress 000000ac T compress2 00000000 T uncompress 0000192c t compress_block *** mysqlclient: U my_compress U my_uncompress my_compress.o: U compress 00000000 T my_compress 00000064 T my_compress_alloc 000000f0 T my_uncompress U uncompress tantrix:~$ So it's in libz too on Debian's latest release (woody). Paul -- Consult other sources -promising -unpromising From chris@madingley.org Fri Jun 29 00:02:41 2001 Received: from daleth.esc.cam.ac.uk ([131.111.64.59] helo=beth.esc.cam.ac.uk) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Fko5-00064b-00 for tpop3d-discuss@lists.beasts.org; Fri, 29 Jun 2001 00:02:41 +0100 Received: from aquila.esc.cam.ac.uk (janus.esc.cam.ac.uk [131.111.64.94]) by beth.esc.cam.ac.uk (8.9.1a/8.9.1) with ESMTP id AAA11698; Thu, 29 Jun 2000 00:04:51 +0100 Received: (from chris@localhost) by aquila.esc.cam.ac.uk (8.9.3/8.9.1) id AAA16099; Fri, 29 Jun 2001 00:02:40 +0100 Date: Fri, 29 Jun 2001 00:02:40 +0100 From: Chris Lightfoot To: tpop3d-discuss@lists.beasts.org Subject: Re: [tpop3d-discuss] --enable-mysql-auth configure failure. Message-ID: <20010629000240.A15978@aquila.esc.cam.ac.uk> References: <20010628094538.A15423@caesious.cold.local> <3B3AF69E.9050301@home.com> <20010628102120.A16474@caesious.cold.local> <3B3AF930.7010806@home.com> <20010628103105.A16553@caesious.cold.local> <3B3AFC51.5060404@home.com> <20010628114347.A25452@aquila.esc.cam.ac.uk> <3B3B0CA2.4090601@home.com> <20010628120123.A25981@aquila.esc.cam.ac.uk> <20010628155119.K19080@tantrix.realprogrammers.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3us In-Reply-To: <20010628155119.K19080@tantrix.realprogrammers.com> X-Mail-Author: me Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, Jun 28, 2001 at 03:51:19PM -0700, Paul Makepeace wrote: > On Thu, Jun 28, 2001 at 12:01:23PM +0100, Chris Lightfoot wrote: > > sed 's/-lmysqlclient/-lmysqlclient -lz' < configure > c2 > > mv c2 configure > > chmod +x configure > > Or, > > perl -pi~ -e 's/-lmysqlclient/$& -lz/g' configure Yes, but I like to use sed, because I like to have to remember fifteen different formats of regexps :) > This is Debian with libc 2.3, > > tantrix:~$ for i in z mysqlclient; do echo "*** $i:"; nm /usr/lib/lib$i.a | > grep compress; done > *** z: > compress.o: > 00000000 T compress > 000000ac T compress2 > 00000000 T uncompress > 0000192c t compress_block > *** mysqlclient: > U my_compress > U my_uncompress > my_compress.o: > U compress > 00000000 T my_compress > 00000064 T my_compress_alloc > 000000f0 T my_uncompress > U uncompress > tantrix:~$ > > So it's in libz too on Debian's latest release (woody). Hmm. I'm not sure what the `correct' way to deal with this is. I would hope it's possible to get by without an explicit `does -lmysqlclient require -lz?' test. Does the new MySQL come with a script like gnome-config or whatever which you can call to find out with which libraries you need to link? -- Chris Lightfoot -- www.ex-parrot.com/~chris/ One of the lessons of history is that nothing is often a good thing to do -- and always a clever thing to say (Will Durant) From chris@madingley.org Fri Jun 29 00:04:24 2001 Received: from daleth.esc.cam.ac.uk ([131.111.64.59] helo=beth.esc.cam.ac.uk) by sphinx.mythic-beasts.com with esmtp (Exim 3.13 #8) id 15Fkpk-00065f-00 for tpop3d-discuss@lists.beasts.org; Fri, 29 Jun 2001 00:04:24 +0100 Received: from aquila.esc.cam.ac.uk (janus.esc.cam.ac.uk [131.111.64.94]) by beth.esc.cam.ac.uk (8.9.1a/8.9.1) with ESMTP id AAA11714; Thu, 29 Jun 2000 00:06:30 +0100 Received: (from chris@localhost) by aquila.esc.cam.ac.uk (8.9.3/8.9.1) id AAA16154; Fri, 29 Jun 2001 00:04:19 +0100 Date: Fri, 29 Jun 2001 00:04:19 +0100 From: Chris Lightfoot To: Marcin Sochacki Cc: Colin , tpop3d-discuss@lists.beasts.org Message-ID: <20010629000419.A16105@aquila.esc.cam.ac.uk> References: <20010628094538.A15423@caesious.cold.local> <3B3AF69E.9050301@home.com> <20010628102120.A16474@caesious.cold.local> <3B3AF930.7010806@home.com> <20010628103105.A16553@caesious.cold.local> <3B3AFC51.5060404@home.com> <20010628114347.A25452@aquila.esc.cam.ac.uk> <3B3B0CA2.4090601@home.com> <20010628120123.A25981@aquila.esc.cam.ac.uk> <20010628234240.A18485@gnu.univ.gda.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3us In-Reply-To: <20010628234240.A18485@gnu.univ.gda.pl> X-Mail-Author: me Subject: [tpop3d-discuss] Re: OFFTOPIC: reply-to munging Sender: tpop3d-discuss-admin@lists.beasts.org Errors-To: tpop3d-discuss-admin@lists.beasts.org X-BeenThere: tpop3d-discuss@lists.beasts.org X-Mailman-Version: 2.0beta5 Precedence: bulk List-Id: On Thu, Jun 28, 2001 at 11:42:40PM +0200, Marcin Sochacki wrote: > > The problem of reply-to munging comes back... > In this thread we have a nice example how useful it could be. > Colin seems to use a simple "Reply", but you also post your replies > to the gro