Cannot log into cyrus using IMAP

[Ken Murchison]

Eric B. wrote:

>>Aha!  Okay, am advancing SLOWLY in this world.   FINALLY got the
> 
> cyrus-sasl
> 
>>pkg compiled (I think) properly with mysql support (no warnings in the
>>config.log, but how can I check to make sure?  Which library should be
>>linked to libmysqlclient?).  Thanks to Nels Lindquist who pointed out that
>>the libmysqlclient.a library is linked with zlib, and need an extra
> 
> compile
> 
>>time switch -lz in the configure script whever it
> 
> references -lmysqlclient.
> 
>>(ie: -lmysqlclient -lz)
>>
>>I installed the newly compiled version, but am _STILL_ getting the
> 
> following
> 
>>error msgs in auth.log when I start cyrus-master.
>>May 11 16:25:31 linuxmail saslauthd[5716]: ipc_init        : listening on
>>socket: /var/run/saslauthd/mux
>>May 11 16:25:32 linuxmail pop3[5730]: sql_select option missing
>>May 11 16:25:32 linuxmail lmtpunix[5732]: sql_select option missing
>>May 11 16:25:32 linuxmail imap[5728]: sql_select option missing
>>May 11 16:25:32 linuxmail pop3[5730]: auxpropfunc error no mechanism
>>available
>>May 11 16:25:32 linuxmail pop3s[5731]: sql_select option missing
>>May 11 16:25:32 linuxmail lmtpunix[5732]: auxpropfunc error no mechanism
>>available
>>May 11 16:25:32 linuxmail imap[5728]: auxpropfunc error no mechanism
>>available
>>May 11 16:25:32 linuxmail pop3[5730]: _sasl_plugin_load failed on
>>sasl_auxprop_plug_init for plugin: sql
>>May 11 16:25:32 linuxmail pop3s[5731]: auxpropfunc error no mechanism
>>available
>>May 11 16:25:32 linuxmail imaps[5729]: sql_select option missing
>>May 11 16:25:32 linuxmail lmtpunix[5732]: _sasl_plugin_load failed on
>>sasl_auxprop_plug_init for plugin: sql
>>May 11 16:25:32 linuxmail imap[5728]: _sasl_plugin_load failed on
>>sasl_auxprop_plug_init for plugin: sql
>>
>>
>>Did I forget something in a config file somewhere?  Do I have a missing
>>library or something?  I'm getting extremely frustrated here - I can't
>>imagine why I'm having so much trouble installing / building this!
> 
> 
> 
> Problem resolved.  My mistake.  When I reinstalled my newly compiled
> binaries, I accidentally overwrote my /etc/imapd.conf file.  I appended the
> file with the following, and it _seems_ to be accepted:
> /etc/imapd.conf:
> sasl_pwcheck_method: saslauthd
> sasl_mech_list: plain
> sasl_sql_engine: mysql
> sasl_sql_hostnames: localhost
> sasl_sql_user: mail
> sasl_sql_passwd: secret
> sasl_sql_database: mail
> sasl_sql_select: select password from accountuser where username = '%u'
> 
> 
> So it seemingly works.  This is now the output in my
> /var/log/auth.log:
> May 11 17:18:27 linuxmail saslauthd[10272]: ipc_init        : listening on
> socket: /var/run/saslauthd/mux
> May 11 17:18:27 linuxmail imap[10284]: sql auxprop plugin using mysql engine
> May 11 17:18:27 linuxmail imaps[10285]: sql auxprop plugin using mysql
> engine
> May 11 17:18:27 linuxmail lmtpunix[10288]: sql auxprop plugin using mysql
> engine
> May 11 17:18:27 linuxmail pop3s[10287]: sql auxprop plugin using mysql
> engine
> May 11 17:18:27 linuxmail pop3[10286]: sql auxprop plugin using mysql engine
> May 11 17:18:27 linuxmail imap[10289]: sql auxprop plugin using mysql engine
> May 11 17:18:27 linuxmail pop3[10290]: sql auxprop plugin using mysql engine
> May 11 17:18:29 linuxmail imap[10291]: sql auxprop plugin using mysql engine
> May 11 17:18:29 linuxmail pop3[10294]: sql auxprop plugin using mysql engine
> May 11 17:18:30 linuxmail imap[10292]: sql auxprop plugin using mysql engine
> May 11 17:18:30 linuxmail imap[10293]: sql auxprop plugin using mysql engine
> 
> 
> Thanks again to Nels Lindquist!  I'd still be tearing my hair out if I
> didn't know to include "-lz" flag in the configure options.
> 
> Can someone just please explain what this zlib's purpose is for?

zlib is used for compressing the the line protocol used by MySQL


-- 
Kenneth Murchison     Oceana Matrix Ltd.
Software Engineer     21 Princeton Place
716-662-8973 x26      Orchard Park, NY 14127
--PGP Public Key--    http://www.oceana.com/~ken/ksm.pgp

---
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html