25 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Can't log in via ...| From | Sent On | Attachments |
|---|---|---|
| James Homuth | Mar 26, 2007 2:56 am | |
| Bernd Wurst | Mar 26, 2007 3:52 am | |
| Bernd Wurst | Mar 26, 2007 3:54 am | |
| James Homuth | Mar 26, 2007 3:57 am | |
| Bernd Wurst | Mar 26, 2007 4:02 am | |
| James Homuth | Mar 26, 2007 5:08 am | |
| Gordon Messmer | Mar 26, 2007 8:25 am | |
| James Homuth | Mar 26, 2007 8:48 am | |
| Gordon Messmer | Mar 26, 2007 9:34 am | |
| James Homuth | Mar 26, 2007 5:51 pm | |
| Gordon Messmer | Mar 26, 2007 9:57 pm | |
| Bernd Wurst | Mar 26, 2007 10:35 pm | |
| James Homuth | Mar 27, 2007 3:19 am | |
| Gordon Messmer | Mar 27, 2007 6:46 am | |
| James Homuth | Mar 27, 2007 8:52 am | |
| Bernd Wurst | Mar 27, 2007 10:29 am | |
| James Homuth | Mar 28, 2007 3:39 pm | |
| Bernd Wurst | Mar 28, 2007 10:42 pm | |
| James Homuth | Mar 31, 2007 4:21 am | |
| James Homuth | Mar 31, 2007 4:25 am | |
| Bernd Wurst | Mar 31, 2007 6:54 am | |
| James Homuth | Mar 31, 2007 7:32 am | |
| Bernd Wurst | Mar 31, 2007 7:42 am | |
| James Homuth | Mar 31, 2007 9:05 am | |
| James Homuth | Mar 31, 2007 9:12 am |
| Subject: | Re: [courier-users] Can't log in via courier-pop3 | |
|---|---|---|
| From: | James Homuth (jam...@the-jdh.com) | |
| Date: | Mar 26, 2007 5:08:48 am | |
| List: | net.sourceforge.lists.courier-users | |
At 07:03 AM 3/26/2007, you wrote:
Ok, trying to give some more helpful answer. :)
Am Montag, 26. März 2007 11:56 schrieb James Homuth:
# MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_PORT 0
Is there a particular reason you don't use the mysql-socket? If server and client (mysql and courier) are on the same machine, unix-sockets should be faster than TCP-sockets.
At the moment, I don't care which one I use. If I can get it to actually work, then I'll be concerned with the 0.9 seconds I save by using the unix socket.
However, if you use TCP, enter the correct port number here!
... Which I've done. Twice. See my original message for the result.
Running authtest wasn't overly helpful
What did it say?
Authentication failed.
I would bet you have one of these two errors:
1. you aren't using mysql at all (see authdaemon-config)
I configured authdaemon myself. Trust me, I'm using authmysql.
2. your database tables are not how they are supposed to be.
Again, I had the database instructions up in another window when I created the tables manually myself. They're right so far as I'm aware. See the below log snip and perhaps you can find something that I'm missing.
I would recommand to turn on logging (noch BINARY logging, but normal, query logging) in mysql-server and have a look at the logfile (mysql should really not be unter load while doing this!).
You should see if authdaemon connects to mysql at all and what exactly the SQL-query looks like. This should give you valuable information for further debugging.
I'm definitely connecting to mysql. See this query log snip: 7 Connect mail_admin@localhost on 7 Init DB mail 7 Query SELECT email, password, "", 5000, 5000, /home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", "", "" FROM users WHERE email = "my@test.email" 7 Quit
Email address was changed from the original.
James