HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Virtual Users And Domains With Postfix, Courier And MySQL.. Authentication Problem (http://www.howtoforge.com/forums/showthread.php?t=9037)

stickyplaster 12th December 2006 14:41

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

falko 13th December 2006 13:54

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
?

stickyplaster 13th December 2006 14:07

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

regards

martinfst 13th December 2006 14:20

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.

stickyplaster 14th December 2006 08:20

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 :pop3s *:* LISTEN -
tcp 0 0 :pop3 *:* 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-

till 14th December 2006 08:37

Either your mysql server is not running or it is not listening on 127.0.0.1 Please try to start the mysql server:

/etc/init.d/mysql start

stickyplaster 14th December 2006 09:03

Hi

Quote:

Originally Posted by till
Either your mysql server is not running or it is not listening on 127.0.0.1 Please try to start the mysql server:

/etc/init.d/mysql start

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

till 14th December 2006 09:06

But mysql is not listening to TCP sockets as you can see in your netstat output. Please post the content of your my.cnf file.

stickyplaster 14th December 2006 09:15

Quote:

Originally Posted by till
But mysql is not listening to TCP sockets as you can see in your netstat output. Please post the content of your my.cnf file.

#
# 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/se...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

falko 14th December 2006 20:18

What's the output of
Code:

/etc/init.d/mysql restart
,
Code:

ps aux|grep -i mysql
and
Code:

netstat -tap
?


All times are GMT +2. The time now is 04:57.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.