[horde] Horde groupware 5.2.2 upgrade...

[Michael Robinson]

On Wed, 2014-09-10 at 09:28 -0700, Michael Robinson wrote:
> ...broke IMP.  I think the backend database was broken too.  
> I use postgresql-9.x.  I noticed that there were errors 
> concerning horde_prefs table in the database log and possibly
> horde_users as well.  
> 
> horde=# SELECT * FROM
> horde_prefs;                                                                                                                                                                                
>  pref_name | pref_uid | pref_scope | pref_value 
> -----------+----------+------------+------------
> (0 rows)
> 
> horde=# select column_name,data_type from information_schema.columns
> where table_name =
> 'horde_prefs';                                                                                                            
>  column_name |     data_type     
> -------------+-------------------
>  pref_name   | character varying
>  pref_uid    | character varying
>  pref_scope  | character varying
>  pref_value  | bytea
> (4 rows)
> 
> Note that I changed character to character varying in horde_prefs and
> left bytea alone.
> 
> I use dovecot 2.x for imap server and have a cram-md5 password file.
> Maybe I need to bite the bullet and implement transport layer security.
> 
> I can log in to horde framework okay, maybe horde_users is fine...
> 
> When I try to connect to IMP though no matter what credentials I try:
> 
> Error connecting to mail server.
> 
> I don't think IMP is even trying to do an IMAP connection...  there is
> nothing in the mail logs on my mail server suggesting otherwise.
> 
> My backends.local.php file under horde/imp/config is very simple:
> 
> [root at web ~]#
> cat /var/www/robinson-west.com/horde/imp/config/backends.local.php 
> <?php
>       $servers['imap']['secure'] = false;
> ?>
> [root at web ~]# 
> 
> Another thing I've noticed, when I first log into the horde framework
> there is no arrow pointing down next to Mail until I click Mail...
> 
> Thank you for your insights.
> 
>      --  Michael Robinson

Sep 10 09:20:26 web HORDE: [horde] Login success for michael to horde
(192.168.5.89) [pid 22505 on line 164 of
"/var/www/robinson-west.com/horde/login.php"]
Sep 10 09:20:31 web HORDE: User is not authorized for imp [pid 22508 on
line 324 of "/usr/share/pear/Horde/Registry.php"]
Sep 10 09:20:42 web HORDE: [imp] [login] Error connecting to mail
server. [pid 22504 on line 726 of
"/var/www/robinson-west.com/horde/imp/lib/Imap.php"]
Sep 10 09:20:42 web HORDE: [horde] FAILED LOGIN for michael to imp
(192.168.5.89) [pid 22504 on line 199 of
"/var/www/robinson-west.com/horde/login.php"]
Sep 10 09:41:41 web HORDE: [passwd] No backend configured for this host
[pid 23045 on line 200 of
"/var/www/robinson-west.com/horde/passwd/lib/Factory/Driver.php"]
Sep 10 09:41:49 web HORDE: [horde] User michael logged out of Horde
(192.168.5.89) [pid 22504 on line 107 of
"/var/www/robinson-west.com/horde/login.php"]

Look at the above log entries in /var/log/messages on
web.robinson-west.com...  What is passwd and what 
backend do I use with it?