Hi Ronald, >The mysql-query-log would log each connect and query. The strange thing is that mysql.log is not showing any connection nor query from courier daemons.
Utilities authtest and authinfo that you mentioned seem not to be included in Debian packages. Is there a way to compile only those tools ? >If yes I'd start with commenting out MYSQL_SOCKET (libmysqlclient will provide the default) or even use tcp instead of a socket. I commented out, but it's the same. Thank you very much for your help, Adrian ========================== Adrian Caneva NEXT TECHNOLOGY SRL La Rioja 26 (T4000ISB) Tucuman Tel/Fax +54 381 4219105 [EMAIL PROTECTED] www.nexttech.com.ar ========================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Roland Schneider Sent: Martes, 12 de Febrero de 2002 03:52 p.m. To: [EMAIL PROTECTED] Subject: Re: [courier-users] courier+mysql problem --Adrian Caneva wrote on 12.02.2002 12:02 -0300: > Hi, > I'm trying to move courier authentication to a mysql backend database. I > installed Debian packages described forward, did the configuration and the > only log message I receive is at mail.log=LOGIN FAILED. mysql.log is empty > so I think authdaemon->authmysql is not even reaching the database. The mysql-query-log would log each connect and query. Check with autinfo (from the source) if authdaemon/authmysql is really compiled into your package. If yes I'd start with commenting out MYSQL_SOCKET (libmysqlclient will provide the default) or even use tcp instead of a socket. And do a `killall -v -m "authdaemond\..*"` between just in case `authdaemond stop` leaves some ghosts behind. If all fails recompile --without-authdaemon --with-mysql and strace authmysql: /usr/local/bin/strace -ffrTv -a 128 -s 128 ./authtest testuser The utility authtest will check if a user is found in the db, without need for a password, its even useful without strace. [...] > # Dumping data for table 'aliases' > > INSERT INTO aliases VALUES > ('testuser','test',101,102,'/var/spool/postfix/virtual/virtual_domain/testus > er/','/','test@virtual_domain'); $HOME of your testuser is set to /. This directory belongs to someone else and you really dont want to do that anyway. Roland _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
