 | Start a set with this search |
 | Include this search in one of my sets |
 | Exclude this search from one of my sets |
 | Permalink to these results Paste this link in email or IM: |
 | Atom feed for tracking future search results Paste this URL into your reader: |
5 messages in net.sourceforge.lists.courier-usersRE: [courier-users] courier+mysql pro...| From | Sent On | Attachments |
|---|---|---|
| Adrian Caneva | Feb 12, 2002 7:01 am | |
| Roland Schneider | Feb 12, 2002 11:02 am | |
| Adrian Caneva | Feb 12, 2002 11:57 am | |
| Roland Schneider | Feb 13, 2002 12:59 am | |
| Adrian Caneva | Feb 14, 2002 8:32 am |
| Permalink for this message Paste this link in email or IM: |
| Permalink for this thread Paste this link in email or IM: |
| Atom feed for this thread Paste this URL into your reader: |
| Subject: | RE: [courier-users] courier+mysql problem | Actions... |
|---|---|---|
| From: | Adrian Caneva (acan...@nexttech.com.ar) | |
| Date: | Feb 12, 2002 11:57:40 am | |
| List: | net.sourceforge.lists.courier-users | |
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 acan...@nexttech.com.ar www.nexttech.com.ar ==========================
-----Original Message----- From: cour...@lists.sourceforge.net [mailto:cour...@lists.sourceforge.net]On Behalf Of Roland Schneider Sent: Martes, 12 de Febrero de 2002 03:52 p.m. To: cour...@lists.sourceforge.net 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 cour...@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users