Dear all,
At first i installed qmail from LWQ on Debian.Then i installed
courier-imap courier-pop their core.
Then i installed vpopmail with mysql auth module.Even i tested it it
read write to mysql.
Now, When i use following command,i give error:
--
localhost:/home/mohsen# telnet 0 110
Trying 0.0.0.0...
Connected to 0.
Escape character is '^]'.
+OK Hello there.
user postmas...@mohsenjan
+OK Password required.
pass 123456
-ERR Login failed.
Connection closed by foreign host.
localhost:/home/mohsen# cd vpopmail-5.4.27
--
mohsenjan is my domain that i inserted to my db.
When i saw my /var/log/mail.log, i see follow line:
Feb 25 19:17:20 localhost authdaemond: SQL query: SELECT pw_name,
pw_passwd, pw_clear_passwd, pw_uid, pw_gid, pw_dir , , , , FROM
vpopmail WHERE pw_name = 'postmas...@mohsenjan'
Feb 25 19:17:20 localhost authdaemond: zero rows returned
Feb 25 19:17:20 localhost authdaemond: no password available to compare
Feb 25 19:17:20 localhost authdaemond: authmysql: REJECT - try next
module
Feb 25 19:17:20 localhost authdaemond: FAIL, all modules rejected
Feb 25 19:18:01 localhost pop3d: LOGOUT, ip=[:::127.0.0.1]
Feb 25 19:18:01 localhost pop3d: Disconnected, ip=[:::127.0.0.1]
---
My question:
How i tell to courier to pw_name is just is my username from email?.It
doesn't contain domain name
I have attached my /etc/courier/authmysqlrc file.
Yours,
Mohsen
!DSPAM:49a575d132681124118433!
##VERSION: $Id: authmysqlrc,v 1.20 2007/10/07 02:50:45 mrsam Exp $
#
# Copyright 2000-2007 Double Precision, Inc. See COPYING for
# distribution information.
#
# Do not alter lines that begin with ##, they are used when upgrading
# this configuration.
#
# authmysqlrc created from authmysqlrc.dist by sysconftool
#
# DO NOT INSTALL THIS FILE with world read permissions. This file
# might contain the MySQL admin password!
#
# Each line in this file must follow the following format:
#
# field[spaces|tabs]value
#
# That is, the name of the field, followed by spaces or tabs, followed by
# field value. Trailing spaces are prohibited.
##NAME: LOCATION:0
#
# The server name, userid, and password used to log in.
MYSQL_SERVERlocalhost
MYSQL_USERNAME vpopmailuser
MYSQL_PASSWORD vpoppasswd
##NAME: SSLINFO:0
#
# The SSL information.
#
# To use SSL-encrypted connections, define the following variables (available
# in MySQL 4.0, or higher):
#
#
# MYSQL_SSL_KEY/path/to/file
# MYSQL_SSL_CERT /path/to/file
# MYSQL_SSL_CACERT /path/to/file
# MYSQL_SSL_CAPATH /path/to/file
# MYSQL_SSL_CIPHERSALL:!DES
##NAME: MYSQL_SOCKET:0
#
# MYSQL_SOCKET can be used with MySQL version 3.22 or later, it specifies the
# filesystem pipe used for the connection
#
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
##NAME: MYSQL_PORT:0
#
# MYSQL_PORT can be used with MySQL version 3.22 or later to specify a port to
# connect to.
MYSQL_PORT 3306
##NAME: MYSQL_OPT:0
#
# Leave MYSQL_OPT as 0, unless you know what you're doing.
MYSQL_OPT 0
##NAME: MYSQL_DATABASE:0
#
# The name of the MySQL database we will open:
MYSQL_DATABASE vpopmail
#NAME: MYSQL_CHARACTER_SET:0
#
# This is optional. MYSQL_CHARACTER_SET installs a character set. This option
# can be used with MySQL version 4.1 or later. MySQL supports 70+ collations
# for 30+ character sets. See MySQL documentations for more detalis.
#
# MYSQL_CHARACTER_SET latin1
##NAME: MYSQL_USER_TABLE:0
#
# The name of the table containing your user data. See README.authmysqlrc
# for the required fields in this table.
MYSQL_USER_TABLEvpopmail
##NAME: MYSQL_CRYPT_PWFIELD:0
#
# Either MYSQL_CRYPT_PWFIELD or MYSQL_CLEAR_PWFIELD must be defined. Both
# are OK too. crypted passwords go into MYSQL_CRYPT_PWFIELD, cleartext
# passwords go into MYSQL_CLEAR_PWFIELD. Cleartext passwords allow
# CRAM-MD5 authentication to be implemented.
MYSQL_CRYPT_PWFIELD pw_passwd
##NAME: MYSQL_CLEAR_PWFIELD:0
#
#
MYSQL_CLEAR_PWFIELD pw_clear_passwd
##NAME: MYSQL_DEFAULT_DOMAIN:0
#
# If DEFAULT_DOMAIN is defined, and someone tries to log in as 'user',
# we will look up 'u...@default_domain' instead.
#
#
# DEFAULT_DOMAINexample.com
##NAME: MYSQL_UID_FIELD:0
#
# Other fields in the mysql table:
#
# MYSQL_UID_FIELD - contains the numerical userid of the account
#
MYSQL_UID_FIELD pw_uid
##NAME: MYSQL_GID_FIELD:0
#
# Numerical groupid of the account
MYSQL_GID_FIELD pw_gid
##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 pw_name
##NAME: MYSQL_HOME_FIELD:0
#
MYSQL_HOME_FIELD pw_dir
##NAME: MYSQL_NAME_FIELD:0
#
# The user's name (optional)
#MYSQL_NAME_FIELD pw_gecos