[Web-cyradm] Cyrus 2.2.3 virt domains + Web-cyradm 0.5.4 patch

[Bob Tito]

martynas at inet.lt wrote:
> Hello,
> 
> But there is no such option in standar cyrus-sasl like:
> 
> sasl_password_format: crypt

Nope.. that is why i referred to my other posting regarding the patch ;-)

I Saw Michael already reposted the link.

> 
> Have you applied some patch? And what patch then?
> Other question about sql and auxprop. Does cyrus-sasl make new connection to
> mysql for every sql select with auxprop? Or it keeps connection alive? I dont
> want get error from mysql "Too many connections;)

Is far as i can see here it's a keep-alive connection.

Regards, Bob

> 
> regards,
> Martynas
> 
> --- "Bob Tito" <lists at magicfingers.org> wrote:
> 
>>
>>Michael Hsu said:
>>
>>>Here's a much cleaner version of the patch, adds a new variable to the
>>
>>conf.php and you can use the DOMAIN_AS_PREFIX in conjunction with it as
>>opposed to my old patch.  I haven't tried out that patch that bob
>>mentioned, but I have already made a deb package of sasl2 with that
>>patch incorporated so I can test it later .  Thanks bob, that'll make
>>things perfect.
>>
>>For anyone interested in this patch, and getting away from PAM,
>>use the patch (not mine) from the previous post
>>
>>/etc/imapd.conf:
>>sasl_mech_list: PLAIN
>>sasl_pwcheck_method: auxprop
>>sasl_auxprop_plugin: sql
>>sasl_password_format: crypt
>>sasl_sql_user: mail
>>sasl_sql_passwd: mysecret
>>sasl_sql_hostnames: localhost
>>sasl_sql_database: mail
>>#sasl_sql_select: SELECT password FROM accountuser WHERE username = '%u'
>>AND domain_name = '%r'
>>sasl_sql_select: SELECT password FROM accountuser WHERE username = '%u'
>>
>>/usr/local/lib/smtp.conf
>>pwcheck_method: auxprop
>>auxprop_plugin: sql
>>allowanonymouslogin: no
>>allowplaintext: yes
>>mech_list: PLAIN LOGIN
>>password_format: crypt
>>sql_user: mail
>>sql_passwd: mysecret
>>sql_hostnames: localhost
>>sql_database: mail
>>sql_select: SELECT password FROM accountuser WHERE username = '%u'
>>#sql_select: SELECT password FROM accountuser WHERE username = '%u' AND
>>domain_name = '%r'
>>
>>The select statement depends on your needs, the active statement works for
>>the 'old style accounts' the other needs to be activated when
>>cyrus-imapd-2.2.x virtual domains are being used.
>>
>>regards, Bob
>>
>>-- 
>>Bob Tito
>>gpg key http://www.magicfingers.org/gpg
>>
>>Disclaimer: This message represents the official view of the voices in my
>>head.
>>
>>
>>
>>-- 
>>Bob Tito
>>gpg key http://www.magicfingers.org/gpg
>>
>>Disclaimer: This message represents the official view of the voices in my
>>head.
>>_______________________________________________
>>This mailing list is hosted and supported
>>by bit-heads GmbH | http://www.bit-heads.ch
>>
>>_______________________________________________
>>Web-cyradm mailing list
>>Web-cyradm at web-cyradm.org
>>http://www.web-cyradm.org/mailman/listinfo/web-cyradm
> 
> 


-- 
Bob Tito
gpg key http://btito.demon.nl/gpg

Disclaimer:
This message represents the official view of the voices in my head.