On Wed, 15 Nov 2006 08:03:48 -0500 David Clymer <[EMAIL PROTECTED]> wrote:
> I'm trying to integrate courier-imap with my msyql based virtual > domain/user setup. > > The problem that I am having is that whenever I activate the > MYSQL_SELECT_CLAUSE, the database is not queried. A connection to the > database server is still established, but no query is made. When NOT > using the MYSQL_SELECT_CLAUSE, the database _is_ queried (I'm logging > all queries, so it shows up in the mysql query log), but not in the way > that I need. > > This is my authmysqlrc: > > > MYSQL_SERVER mysql.hrcsb.org > MYSQL_USERNAME mail > MYSQL_PASSWORD ******** > MYSQL_PORT 3306 > MYSQL_OPT 0 > MYSQL_DATABASE mail > MYSQL_SELECT_CLAUSE SELECT account.username,\ > account.crypt_password,\ > account.password,\ > account.uid,\ > account.gid,\ > CONCAT('/var/mail/', domain.name, '/'),\ > account.maildir,\ > account.quota,\ > '',\ > ''\ > FROM account \ > INNER JOIN domain ON account.domain_id = domain.name \ > WHERE account.username = '$(local_part)'\ > AND domain.name = '$(domain)' > > > I'm running debian sarge, and the debian package of courier-{imap, > authdaemon,authmysql}. The database is on a remote machine and is > running mysql 4.1 > > Any ideas/experience you might have would be very welcome. > > -davidc > Hi David, take a look in this howto http://workaround.org/articles/ispmail-sarge/ ive tested this howto on sarge, etch and sid - no problem so long -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]