On Viernes 24 Diciembre 2010 23:50:14 Sam Varshavchik escribió:
> Thomas Carrié writes:
> > Hello,
> >
> > My only auth active module is authmysql :
> >
> > $ grep ^authmodulelist= /etc/courier/authlib/authdaemonrc
> > authmodulelist="authmysql "
> >
> > I have 2 users in my DB
> >
> > mysql> select * from courier.users;
> > +---------+-------+-----+-----+--------------------+-----------------+---
> > ----+
> >
> > | id | clear | uid | gid | home | options |
> > | crypt |
> >
> > +---------+-------+-----+-----+--------------------+-----------------+---
> > ----+
> >
> > | tcarrie | some | 0 | 12 | /var/vmail/tcarrie | disableshared=0 |
> > | | mamibb | thing | 0 | 12 | /var/vmail/mamibb |
> > | disableshared=0 | |
> >
> > +---------+-------+-----+-----+--------------------+-----------------+---
> > ----+
> >
> > I can succesfully login into the IMAP server using tcarrie and mamibb
> >
> > $ grep mamibb /var/log/messages
> > Dec 24 16:05:56 localhost imapd: LOGIN, user=mamibb ....
> >
> > But authenumerate returns no rows !
> >
> > In what kind of situation authenumerate is supposed to return rows ?
>
> In the situation where MYSQL_ENUMERATE_CLAUSE is not set correctly in
> authmysqlrc.
I have just set the MYSQL_ENUMERATE_CLAUSE like so :
$ grep ^MYSQL_ENUMERATE_CLAUSE /etc/courier/authlib/authmysqlrc
MYSQL_ENUMERATE_CLAUSE select id,uid,gid,home,concat(home,'.maildir') as
maildir,options from users;
I still have no row from authenumerate. At my first try,
MYSQL_ENUMERATE_CLAUSE was commented and I had the same result
Now I am adding a new user
insert into users (id,home) values ('iii','ooo');
$ authenumerate
iii 8 12 ooo ooo.maildir
Why is it returning only this user ?
If I restart the courier auth service, it does'nt change anything (only have
iii user).
Now I am updating the iii user with an SQL statement, it does show any user
in the output of authenumerate :-(
--
Thomas Carrié
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Courier-imap mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap
