Virtual Users And Domains With Postfix, Courier And MySQL.. Authentication Problem

Hi
I followed the above howto, however, I am having problems logging in via any mail client e.g. thunderbird or web client.

I can see from my file system that mail is being delivered okay in the user's mail box.

I have checked and double checked all my settings/files/db tables etc. and my user password is stored encrypted. As mail_admin I can log into the mail database in mysql with the appropriate privileges using the password I stipulate in the various property files.

Somewhere along the way authentication via the mail client is failing, but the only mail error I seem to be getting is 'imapd-ssl: LOGIN FAILED, the same with pop3-ssl.

Has anyone any ideas where I am going wrong?

thank you

 

What's the exact error message you get in your mail client? What's the exact error message in your mail log? What's the output of

Code:

netstat -tap

?

 

Hi
Thanks for getting back to me. I'll look and post the info when I get a chance.

regards

 

Server software?

What server are you running on? I've been fighting authentication on my newly setup Ubuntu 6.10 past hours. I'm trying Courier with TB and Squirrelmail with zero results. I'll dig some deeper, but if I can't find it, I'll share my piece.

 

Hi folks

'What server are you running on? I've been fighting authentication on my newly setup Ubuntu 6.10 past hours...'

It's a Debian sarge VDS


'What's the exact error message you get in your mail client?'

My mail client just says login to server failed after I accept the ssl certificate


'What's the exact error message in your mail log?'

I have a few rather large logs mail.warn includes:
postfix/master[24460]: warning: process /usr/lib/postfix/trivial-rewrite pid 17182 exit status 1
postfix/master[24460]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
postfix/pickup[31048]: warning: B3BC0D113C3: message has been queued for 1 days
postfix/pickup[31048]: warning: maildrop/15F97D113C1: Error writing message file
postfix/pickup[31048]: warning: B912AD113C3: message has been queued for 1 days
postfix/pickup[31048]: warning: maildrop/968DA6DDF5C: Error writing message file
postfix/cleanup[8212]: warning: B3BC0D113C3: virtual_alias_maps map lookup problem for root@
postfix/cleanup[8212]: warning: B912AD113C3: virtual_alias_maps map lookup problem for root@
postfix/proxymap[13557]: warning: connect to mysql server 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (111)

mail.err includes:
imaplogin: LOGIN FAILED
imaplogin: LOGIN FAILED
imaplogin: DISCONNECTED, time=12
postfix/trivial-rewrite[16422]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
postfix/trivial-rewrite[16700]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem

I have redone the setup twice and checked/double checked my settings but in view of the above do I need to do so again???? though I'm pretty sure.....
Don't know where the root is coming in as my user is set to mail_admin.

netstat -tap:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 :imaps *:* LISTEN -
tcp 0 0 op3s *:* LISTEN -
tcp 0 0 op3 *:* LISTEN -
tcp 0 0 imap2 *:* LISTEN -
tcp 0 0 -:www *:* LISTEN -
tcp 0 0 :10002 *:* LISTEN -
tcp 0 0 -:ssh *:* LISTEN -
tcp 0 0 :smtp *:* LISTEN -
tcp 0 0 :https *:* LISTEN -
tcp 1 0 :smtp CLOSE_WAIT -
tcp 38 0 :10002 CLOSE_WAIT -
tcp 0 0 -:ssh ESTABLISHED-

 

Hi

No, MySql was/is running okay and I have the following in my.cnf:

bind-address = 127.0.0.1 and there is no local .cnf file to override this as far as I can see.

regards

 

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
old_passwords = false # inserted by debconf
# We activated the above for connections from hosts running Debian Woody/Sarge!
#
# Prior to MySQL 5.0, user passwords were stored in a rather weak way. This
# has been improved with the drawback that client programs shipped with
# Debian Woody/Sarge (technically: linked against libmysqlclient.so.12 or
# earlier) cannot connect any more if either their account has either been
# created or their password has been modified using MySQL 5.0.
# See http://dev.mysql.com/doc/refman/5.0/en/old-client.html
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking you can now listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#skip-networking
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
#
# * Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 16777216
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * BerkeleyDB
#
# According to an MySQL employee the use of BerkeleyDB is now discouraged
# and support for it will probably cease in the next versions.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the ndbd storage daemons,
# not from the ndb_mgmd management daemon.
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1

thank you

 

What's the output of

Code:

/etc/init.d/mysql restart

,

Code:

ps aux|grep -i mysql

and

Code:

netstat -tap

?

 

mysql seems to be showing now:

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 :imaps *:* LISTEN -
tcp 0 0 op3s *:* LISTEN -
tcp 0 0 :mysql *:* LISTEN -
tcp 0 0 op3 *:* LISTEN -
tcp 0 0 :imap2 *:* LISTEN -
tcp 0 0 :www *:* LISTEN -
tcp 0 0 :10002 *:* LISTEN -
tcp 0 0 :ssh *:* LISTEN -
tcp 0 0 :smtp *:* LISTEN -
tcp 0 0 :https *:* LISTEN -
tcp 0 52 ssh ESTABLISHED-
tcp 38 0 :CLOSE_WAIT -

but still no joy.

regards

 

I am seeing mysql on localhost now:

tcp 0 0 :mysql localhost:37249 TIME_WAIT -
tcp 0 0 :mysql localhost:37250 TIME_WAIT -
tcp 0 0 localhost:37249 mysql TIME_WAIT -

still no luck though ho hum

 

Do you use 127.0.0.1 in your configuration files (as recommended by the tutorial) or localhost?

 

Hi
As far as I am aware I have used 127.0.0.1 throughout

 

Its a long shot but I had an authentication problem that was caused by putting squigles in my MySQL password. (not root the one SASL uses). Try only useing numbers and letters in you're password.

 

Hi
Unfortunately my password is only letters and numbers. I am going to have to rethink this one I feel.

regards

 

I think you should compare all your configuration files again with those of the tutorial. Also take care about their format (tabs, spaces, ...). Courier is very finicky about this.

 

I have done both many times, believe me.

Perhaps I'm just going to have to accept that I can't get it to work.

Thanks for all your help.

regards