[horde] Horde Webmail authentification methods

[Steve Devine]

Petar Kazakov wrote:
> I was missing the smtphost and smtpport, but ...
>
> I added them, same :-/
> Yes through telnet everything is working just fine :-)
>
> Which is quite strange :-/
>
> The other strange thing is 
>
> Apr 18 18:46:35 mail authdaemond: SQL query: SELECT id, pw_passwd, "",
> pw_uid, pw_gid, pw_dir, "", "", pw_gecos, "" FROM vpopmail WHERE id =
> "peter at example.com"
> Apr 18 18:46:35 mail authdaemond: mysql_query failed, reconnecting: Unknown
> column 'id' in 'field list'
> Apr 18 18:46:35 mail authdaemond: mysql_query failed second time, giving up:
> Unknown column 'id' in 'field list'
>
> The SQL query is not accurate, 
> The courier-imap is correctly setup (every field is correctly described in
> authmysqlrc) and obviously working ... but not with horde :-(
>
> Peter
>
> -----Original Message-----
> From: Steve Devine [mailto:sd at msu.edu] 
> Sent: Friday, April 18, 2008 6:22 PM
> To: Petar Kazakov
> Cc: horde at lists.horde.org
> Subject: Re: [horde] Horde Webmail authentification methods
>
> Petar Kazakov wrote:
>   
>> The IMAP is working just fine.
>> I have a squirrelmail that is currently working and also abut 50 clients
>> like MS outlook and thunderbird.
>>
>> #:> telnet localhost 143
>> Trying ::1...
>> Trying 127.0.0.1...
>> Connected to localhost.
>> Escape character is '^]'.
>> * OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE
>>     
> THREAD=ORDEREDSUBJECT
>   
>> THREAD=REFERENCES SORT QUOTA AUTH=CRAM-MD5 AUTH=CRAM-SHA1 AUTH=CRAM-SHA256
>> IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP ready. Copyright 1998-2005
>>     
> Double
>   
>> Precision, Inc.  See COPYING for distribution information.
>>
>> Pete
>>   
>>     
> Ok then whats your imp/config/servers.php have in it?
> Heres a sample:
> $servers['imap'] = array(
>         'name' => 'IMAP Server',
>         'server' => 'localhost',
>         'protocol' => 'imap/notls',
>         'port' => 143,
>         'smtphost' => 'localhost',
>         'smtpport' => 25,
>         'maildomain' => 'sample.com',
>         'realm' => '',
>         'preferred' => '',
>         'hordeauth' => false,
>
> );
>
> You also should be able to
> 'telnet  localhost  143'
> then after the banner
> 'a login username password'
> 'a examine inbox'
> 'a logout'
>
>
>
>   
Well are you putting users in the sql DB cause I don't think thats the 
route you want to take unless all your users are in the SQL DB.
IE:
 If you  were accessing your imap server  via Thunderbird or Outlook 
would the imap server find your users in a SQL DB? Or a passwd file? 

-- 
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