Hi @ll,
i tried to activate the MYSQL_SELECT_CLAUSE in the authmysqlrc, but it didnt
work. With the standard-parameters everthing works fine, but with the
cutom-select not. In the mysql.log i see, that courier get a connect, but no
query is sent afterwards.
At least for me, the sql-query looks correct, so please help me, what else
could be wrong?
--snip--
System: Debian stable,
tank:~# dpkg -l |grep courier
ii courier-authda 0.37.3-2.3 Courier Mail Server authentication daemon
ii courier-authmy 0.37.3-2.3 MySQL Authentication for Courier Mail
Server
ii courier-base 0.37.3-2.3 Courier Mail Server Base System
ii courier-imap 1.4.3-2.3 IMAP daemon with PAM and Maildir support
ii courier-imap-s 1.4.3-3.3 IMAP daemon with SSL, PAM and Maildir
suppor
ii courier-maildr 0.37.3-2.3 Mail delivery agent with filtering
abilities
ii courier-mta 0.37.3-2.3 Mail Transport Agent of the Courier Mail
Ser
ii courier-mta-ss 0.37.3-3.3 Courier Mail Transport Agent (SMTP over
SSL)
ii courier-pop 0.37.3-2.3 POP3 daemon with PAM and Maildir support
ii courier-pop-ss 0.37.3-3.3 POP3 daemon with SSL, PAM and Maildir
suppor
ii courier-ssl 0.37.3-3.3 Courier Mail Server SSL PackageCourier
0.37
--snip--
##VERSION: $Id: authmysqlrc,v 1.9 2002/01/08 05:01:22 mrsam Exp $
#
## standard-parameter ###
MYSQL_SERVER localhost
MYSQL_USERNAME courier
MYSQL_PASSWORD ********
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_PORT 3306
MYSQL_OPT 0
MYSQL_DATABASE mailuser
MYSQL_USER_TABLE user
MYSQL_CLEAR_PWFIELD passwd
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD id
MYSQL_HOME_FIELD home
MYSQL_QUOTA_FIELD quota_size
## custom select ##
MYSQL_SELECT_CLAUSE SELECT id,'',uid,gid,passwd,home,'',quota_size,''
from user where id = '$(local_part)'
the mysql.log:
--snip--
### with standard-parameters ##
031104 8:42:17 132 Connect [EMAIL PROTECTED] on
132 Init DB mailuser
132 Query SELECT id, "", passwd, uid, gid, home,
"", quota_size, "" FROM user WHERE id = "testman"
--snip--
### with custom-select ##
031104 8:44:17 134 Connect [EMAIL PROTECTED] on
134 Init DB mailuser
--snip--
Thanx in advance for all your help !!
Roman B�rkle
- LINUX - sooner or later, we emulate you !
-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive? Does it
help you create better code? SHARE THE LOVE, and help us help
YOU! Click Here: http://sourceforge.net/donate/
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
