At 09:46 AM 3/27/2007, you wrote:
>James Homuth wrote:
> >>> 9 Query SELECT email, password, "",
> >>> 5000, 5000, /home/vmail/$(domain)/$(local_part), "", "", "", "" FROM
> >>> users WHERE email = "[EMAIL PROTECTED]"
>...
> > ... Actually, I was just going to append the last
> > part of the query with MYSQL_WHERE_CLAUSE. I
> > hadn't made any real modifications to the default
> > courier-authmysql query after my original
> > modification went south. So, the unquoted
> > /home/mail part of the query is Courier itself.
>
>That seems unlikely.
>
> >> All I'm basicly using is:
> >> SELECT email, password, "", $UID, $GID, /$HOME,
> >> "", "", "", "" FROM users WHERE email = "$LOGINID"
>
>Please post all of the "_CLAUSE" settings from authmysqlrc, rather than
>summarizing what you're "basically" doing. It will be much easier to
>help if we aren't forced to speculate.
Where clause has been modified only slightly as I'm not too
comfortable with messing around with that as yet. There is no
customised select clause yet so that part of the configuration file
has been left out. Everything that's here is exactly how I set it up.
I'll mention a couple things that aren't in the file snip just
because they were in the original snip I pasted in the message that
started the thread. The database setting (mail) and user setting
(mail_admin) are correct. It's connecting with no problems whatsoever
except the query it throws at the server isn't proving very
effective. Is there anything else you need that's not been included?
James
##NAME: MYSQL_UID_FIELD:0
#
# Other fields in the mysql table:
#
# MYSQL_UID_FIELD - contains the numerical userid of the account
#
MYSQL_UID_FIELD 5000
##NAME: MYSQL_GID_FIELD:0
#
# Numerical groupid of the account
MYSQL_GID_FIELD 5000
##NAME: MYSQL_LOGIN_FIELD:0
#
# The login id, default is id. Basically the query is:
#
# SELECT MYSQL_UID_FIELD, MYSQL_GID_FIELD, ... WHERE id='loginid'
#
MYSQL_LOGIN_FIELD email
##NAME: MYSQL_HOME_FIELD:0
#
MYSQL_HOME_FIELD /home/vmail
##NAME: MYSQL_NAME_FIELD:0
#
# The user's name (optional)
#MYSQL_NAME_FIELD name
##NAME: MYSQL_MAILDIR_FIELD:0
#
# This is an optional field, and can be used to specify an arbitrary
# location of the maildir for the account, which normally defaults to
# $HOME/Maildir (where $HOME is read from MYSQL_HOME_FIELD).
# You still need to provide a MYSQL_HOME_FIELD, even if you uncomment this
# out.
#
# MYSQL_MAILDIR_FIELD maildir
##NAME: MYSQL_DEFAULTDELIVERY:0
#
# Courier mail server only: optional field specifies custom mail delivery
# instructions for this account (if defined) -- essentially overrides
# DEFAULTDELIVERY from ${sysconfdir}/courierd
#
# MYSQL_DEFAULTDELIVERY defaultdelivery
##NAME: MYSQL_QUOTA_FIELD:0
#
# Define MYSQL_QUOTA_FIELD to be the name of the field that can optionally
# specify a maildir quota. See README.maildirquota for more information
#
MYSQL_QUOTA_FIELD quota
##NAME: MYSQL_AUXOPTIONS:0
#
# Auxiliary options. The MYSQL_AUXOPTIONS field should be a char field that
# contains a single string consisting of comma-separated "ATTRIBUTE=NAME"
# pairs. These names are additional attributes that define various per-account
# "options", as given in INSTALL's description of the "Account OPTIONS"
# setting.
#
# MYSQL_AUXOPTIONS_FIELD auxoptions
#
# You might want to try something like this, if you'd like to use a bunch
# of individual fields, instead of a single text blob:
#
#
MYSQL_AUXOPTIONS_FIELD
CONCAT("disableimap=",disableimap,",disablepop3=",disablepop3,",disablewebmail=",disablewebmail,",sharedgroup=",sharedgroup)
#
# This will let you define fields called "disableimap", etc, with the
end result
# being something that the OPTIONS parser understands.
##NAME: MYSQL_WHERE_CLAUSE:0
#
# This is optional, MYSQL_WHERE_CLAUSE can be basically set to an arbitrary
# fixed string that is appended to the WHERE clause of our query
#
# MYSQL_WHERE_CLAUSE email='$(local_part)@$(domain)'
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
