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='$(local_part)@$(domain)' and
((smtp='1' and '$(service)'='esmtp') or ('$(service)'!='esmtp'))
The only that only email addresses are ok for login names, no single logins,
so [EMAIL PROTECTED] would work but simply user would not.
Thanks for the ones that helped again. Regards,
Peter
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kóczán
Péter
Sent: Tuesday, July 25, 2006 9:58 AM
To: Martin Schuster
Cc: [email protected]
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óczán Péter 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 = /var/log/mysql.log
> in your my.cnf
>
> hth,
> - --
> Martin Schuster <[EMAIL PROTECTED]>
> 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=
> =kwDx
> -----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?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/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?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
