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 [EMAIL PROTECTED] 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 = "[EMAIL PROTECTED]"
7 Quit
>Email address was changed from the original.
James
-------------------------------------------------------------------------
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
