Re: [Dovecot] SSL fields as variables for SQL statements ...

2008-09-11 Thread XhE
Timo Sirainen wrote: On Wed, 2008-09-03 at 01:54 +0200, XhE wrote: Hi, I was wondering if there is any possibility to access the status if a user has provided a certificate, that has been accepted or not via variables. And further if there is any way to get the value of SSL certificate

[Dovecot] SSL fields as variables for SQL statements ...

2008-09-02 Thread XhE
Hi, I was wondering if there is any possibility to access the status if a user has provided a certificate, that has been accepted or not via variables. And further if there is any way to get the value of SSL certificate fields by use variables. I'd like to use those variables in sql statement

Re: [Dovecot] authentication with mysql - problem with table name escaping

2007-08-26 Thread XhE
ng, but it doesn't affect the problem ... :( XhE Luuk wrote: should u not do this; user_query = "SELECT CONCAT('/home/vmail/', domain.name, '/', address.local, '/.maildir/') AS home, 1101 AS uid, 1101 AS gid FROM user, `#user_address`, address,

Re: [Dovecot] authentication with mysql - problem with table name escaping

2007-08-26 Thread XhE
dress.local, '@', domain.name) = MID('%u', LOCATE("@",'%u')+1) If I change the table's name to one, which doesn't need backtick escaping the upper query works. Dovecot somehow doesn't get along with the backtick Regards, XhE Luuk w

[Dovecot] authentication with mysql - problem with table name escaping

2007-08-25 Thread XhE
like ' oder " are not recognized. But dovecot somehow doesn't allow me to do that. After switchting auth_verbose to true I get entries in /var/log/messages stating: Password query failed: Incorrect table name ' ' Regards, XhE