[horde] Horde Webmail authentification methods

[Steve Devine]

Petar Kazakov wrote:
> Petar Kazakov wrote:
>   
>> I change the 'hordeaut' to false.
>> Still the same
>> Still it's trying to do CRAM-MD5
>>
>> authdaemond: received auth request, service=imap, authtype=cram-md5
>> authdaemond: authvchkpw: trying this module
>> authdaemond: authvchkpw: REJECT - try next module
>> authdaemond: authpam: trying this module
>> authdaemond: authpam only handles authtype=login
>>
>> Peter
>>
>> -----Original Message-----
>> From: Steve Devine [mailto:sd at msu.edu] 
>> Sent: Thursday, April 17, 2008 1:15 PM
>> To: Petar Kazakov
>> Cc: horde at lists.horde.org
>> Subject: Re: [horde] Horde Webmail authentification methods
>>
>> Petar Kazakov wrote:
>>   
>>     
>>> Hi all,
>>> I'm a newbee in Horde :-)
>>>
>>> I'm trying to install it but it causing me some head aches.
>>>
>>> So my question is next, how I can set the auth method that I want to use.
>>>
>>> It seams that it select the best one out of CRAM-MD5, DIGEST-MD5, LOGIN,
>>> PLAIN, which appears to be CRAM-MD5 and my mail server is bitching about
>>> that
>>>
>>>  
>>>
>>> received auth request, service=imap, authtype=cram-md5
>>>
>>> authvchkpw: REJECT - try next module
>>>
>>> authpam only handles authtype=login
>>>
>>>  
>>>
>>> Is there a variable that I can setup in the config.php, something like
>>> user_method and it will be used instead of the best one?
>>>
>>> I found in the source that there is such variable and compares with it,
>>>     
>>>       
>> but
>>   
>>     
>>> so far I can't get how it needs to be entered in the conf.php and which
>>> config fail (Horde, IMP or Pear).
>>>
>>> And unfortunately I didn't sow anything in the docs, and I wasn't able to
>>> find something in the FAQs and old mails.
>>>
>>>  
>>>
>>> I'll be very grateful if some one point me in the right direction :-).
>>>
>>>  
>>>
>>> Thanks in advance
>>>
>>> Peter
>>>
>>>   
>>>     
>>>       
>> If you are using imp to auth to an existing imap server than follow the 
>> same rules you would use if configuring an imap client.
>> in horde/config/conf.php
>> $conf['auth']['params']['app'] = 'imp';
>> $conf['auth']['driver'] = 'application';
>>
>> then in imp/config/servers.php set the configs like a imap client
>> also make sure 'hordeauth' => false,'
>>
>> /sd
>>
>>   
>>     
> Please keep it on the list:
> Try http://yourserver/imp/test.php
> You should get e screen where you can log in and get some good feedback.
>
>
>   
Nothing
 >From imp/test.php

PHP Mail Server Support Test
Attempting to automatically determine the correct connection parameters for
your server:
Trying protocol imap/notls, Port 143:
ERROR - The server returned the following error message:
Unable to create TCP socket: Protocol not supportedCan not authenticate to
IMAP server: [CLOSED] IMAP connection broken
(authenticate)Trying protocol imap/ssl, Port 143:
ERROR - The server returned the following error message:
Unable to create TCP socket: Protocol not supportedTLS/SSL failure for
localhost: SSL negotiation failedTrying protocol imap/ssl/novalidate-cert,
Port 143:
ERROR - The server returned the following error message:
Unable to create TCP socket: Protocol not supportedTLS/SSL failure for
localhost: SSL negotiation failedTrying protocol imap/tls/novalidate-cert,
Port 143:
ERROR - The server returned the following error message:
Unable to create TCP socket: Protocol not supportedCan not authenticate to
IMAP server: [CLOSED] IMAP connection broken
(authenticate)Could not determine a successful connection protocol. Make
sure your mail server is running and you have specified the correct port.

Debug log:

Apr 18 15:38:45 mail imapd: Connection, ip=[127.0.0.1]
Apr 18 15:38:45 mail authdaemond: received auth request, service=imap,
authtype=cram-md5
Apr 18 15:38:45 mail authdaemond: authvchkpw: trying this module
Apr 18 15:38:45 mail authdaemond: authvchkpw: REJECT - try next module
Apr 18 15:38:45 mail authdaemond: authpam: trying this module
Apr 18 15:38:45 mail authdaemond: authpam only handles authtype=login
Apr 18 15:38:45 mail authdaemond: authpam: REJECT - try next module
Apr 18 15:38:45 mail authdaemond: authmysql: trying this module
Apr 18 15:38:45 mail authdaemond: cram:
challenge=PDFBNkFGQUMzNEMzQTEwNEM0Q0Q1OUY5NEUwQzFBMTgwQG1haWwuZG9icm9zb2Z0Lm
NvbT4=, response=cGV0YXIua2F6YWtvdkBkb2Jy
b3NvZnQuY29tIGEzYTY3MjFlYTYzZDZkZjlkZmZjYjhlMTc2OTA4YTRl
Apr 18 15:38:45 mail authdaemond: cram: decoded challenge/response, username
'petar.kazakov at dobrosoft.com'
Apr 18 15:38:45 mail authdaemond: SQL query: SELECT id, pw_passwd, "",
pw_uid, pw_gid, pw_dir, "", "", pw_gecos, "" FROM vpopmail WHERE id =
"petar.kazakov at d
obrosoft.com"
Apr 18 15:38:45 mail authdaemond: mysql_query failed, reconnecting: Unknown
column 'id' in 'field list'
Apr 18 15:38:45 mail authdaemond: mysql_query failed second time, giving up:
Unknown column 'id' in 'field list'
Apr 18 15:38:45 mail authdaemond: authmysql: TEMPFAIL - no more modules will
be tried


Looks to me like your Imap server is not working. Is this  working imap 
server?

try this :
"telnet 'yourimapserver' 143"
You should get an answer back like so (this will vary depending in 
server software:
*******************************************
 OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE 
THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION] 
Courier-IMAP ready. Copyright 1998-2005 Double Precision, Inc.  See 
COPYING for distribution information.
******************************************
If its ssl then run :
openssl s_client -connect yourimapserver:993

If these are not responding then your issue is not with Horde / Imp
/sd

-- 
Steve Devine
Email & Storage
Academic Technical Services
Michigan State University

313 Computer Center
East Lansing, MI 48824-1042
1-517-432-7327

Baseball is ninety percent mental; the other half is physical.
- Yogi Berra