On Sunday 01 June 2003 07:21 am, Andrew wrote:
Hi All,
I am trying to get authmysql going - but it's not working.... I
can't seem to find any way to turn on detailed logging and where to
look.... (I can't see any queries going into the mysql server...)
I had the same problem and ethereal is my sledgehammer of choice for these
problems. Mandrake 9.1 includes it, or try http://www.ethereal.com/.
My first problem came up as courier making an initial connection to the
database but no query being sent. As I was preparing a longwinded query to
this list, I noticed that a row name in the db didn't match what was in
authmysqlrc. Ooops.
Second problem clearly showed the query in ethereal -- ah, the user needed the
@whatever.tld appended in the db.
Also had a problem earlier on where I edited the authmysqlrc file AFTER
compilation. That's not terribly useful, but was fixed after re-R-ingTFM.
And another problem where there was a space before a required option in the
config file. But hey, it's all working now.
Anyhoo, ethereal is the bee's knees.
Where should I look to turn on detailed logging?? (I can't find it in
the docs)
You can pass in a debugging parameter when mysql is started -- I had to put
mine in the /etc/rc.d/init.d script. However, it either recorded nothing or
something ethereal had already told me. The line in question now looks like
$bindir/mysqld_safe --datadir=$datadir --pid-file=$pid_file --log 2>&1 |
logger -t mysqld_safe &
"--log" is the magic parameter. Look for the log file in /var/lib/mysql.
In a post slightly after this one, someone mentions a debugging parameter that
imapd uses -- I haven't used it.
Barry
3 messages in net.sourceforge.lists.courier-usersRe: [courier-users] debugging help! :)
