From owner-freebsd-questions@FreeBSD.ORG Fri May 14 02:15:56 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4880516A4CE for ; Fri, 14 May 2004 02:15:56 -0700 (PDT) Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9672E43D58 for ; Fri, 14 May 2004 02:15:55 -0700 (PDT) (envelope-from andyh@hhbb.co.uk) Received: from [10.0.0.25] (hedgie1.gotadsl.co.uk [82.133.95.107]) by smtp.nildram.co.uk (Postfix) with ESMTP id B57B525EE25 for ; Fri, 14 May 2004 10:14:21 +0100 (BST) Mime-Version: 1.0 (Apple Message framework v613) Content-Transfer-Encoding: 7bit Message-Id: <16573C69-A587-11D8-B3AA-000D93511A6A@hhbb.co.uk> Content-Type: text/plain; charset=US-ASCII; format=flowed To: freebsd-questions@freebsd.org From: Andy Holyer Date: Fri, 14 May 2004 10:14:22 +0100 X-Mailer: Apple Mail (2.613) Subject: Problems configuring Postfix/Cyrus/MySQL X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 14 May 2004 09:15:56 -0000 I'm trying to config our mail server (FreeBSD-CURRENT) to use the above combination, but I'm still getting problems (possibly unconnected): 1) In /var/log/messages I get this message repeatedly: May 14 10:04:54 tiggywinkle postfix/trivial-rewrite[90799]: fatal: mysql:/etc/postfix/mysql-virtual.cf: table lookup problem /etc/postfix/mysql-virtual.cf has the correct username and password, and the database "mail" and the table "virtual" do exist (I can use the mysql client to go in and look at it. The table's empty, though. I've got the cyrus imap and pop3 daemons to go (that is, I can telnet to their port and get a sensible prompt, however if I do cyradm --user cyrus localhost imap I get no response at all - the command just hangs. Any advice gratefully received. I have installed postfix and cyrus in the past, but that was last century, and without mysql involved. --- Andy Holyer, Technical stuff Hedgehog Broadband, 11 Marlborough Place Brighton BN1 1UB 08451 260895 x 241