Re: [courier-users] FW: authmysql $(service)

Hi,

Finally I managed to solved the problem with some help.

The following query works perfectly, with the smtp column containing 1 or 0,
depending on if you want the user to be able to use smtp through server or
not.

MYSQL_SELECT_CLAUSE select id as username, crypt as cryptpw, clear as
clearpw, uid, gid, home, if(strcmp('$(service)','courier'),maildir,''),
quota, name as fullname from users where id=3D'$(local_part)@$(domain)' and
((smtp=3D'1' and '$(service)'=3D'esmtp') or ('$(service)'!=3D'esmtp'))

The only that only email addresses are ok for login names, no single logins,
so user@something.com would work but simply user would not.

Thanks for the ones that helped again. Regards,

Peter

-----Original Message-----
From: courier-users-bounces@lists.sourceforge.net
[mailto:courier-users-bounces@lists.sourceforge.net] On Behalf Of K=F3cz=E1n
P=E9ter
Sent: Tuesday, July 25, 2006 9:58 AM
To: Martin Schuster
Cc: courier-users@lists.sourceforge.net
Subject: Re: [courier-users] FW: authmysql $(service)

Sorry, somehow I did not receive it. I turned it on meanwhile and I saw that
$(service) is not replaced by the service name, it is in the query as-is.
What could be the reason for this?

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> K=F3cz=E1n P=E9ter wrote:
>> Thanks, but as I see it does not log mysql query so I can't debug
>>
> Thanks for ignoring my mail :(
>
> Again:
> You can turn on logging for the mysqld, it will then log all queries =

> it gets.
> Put sth like
> log =3D /var/log/mysql.log
> in your my.cnf
>
> hth,
> - --
> Martin Schuster <Martin.Schuster@centerpoint.eu.com>
> CenterPoint http://www.centerpoint.eu.com/
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.3 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFExcrr8/HiHhT8phIRAoAoAKCANTYNJrGVLm5gQRTs4JgzhUTiTgCfawxI
> S1vi5ZOiZ+rJZ5M9xTZF0fo=3D
> =3DkwDx
> -----END PGP SIGNATURE-----
>



-------------------------------------------------------------------------
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?p...orge&CID=3DDE=
VDEV
_______________________________________________
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/.../courier-users


-------------------------------------------------------------------------
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?p...orge&CID=3DDE=
VDEV
_______________________________________________
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/.../courier-users