[horde] trouble with prefs

[A. Schulze]

Am 13.10.21 um 14:14 schrieb Michael J Rubinsky:
Hello Micheal,

> You have to make sure you first upgrade all the applications on the  
> Horde 3 server to the last version of Horde 3, then you run attach  
> the database to your Horde 5.x installation and run the  
> horde-db-migrate tasks.

well, maybe my setup is unusual. I've horde3+imp3 only. If I read the  
config correct, there is no database at all:

$ egrep '(sql|ldap|prefs)' config/conf*php */config/conf*php
config/conf.php:$conf['sql']['phptype'] = false;
config/conf.php:$conf['auth']['params']['hostspec'] =  
'ldap://localhost ldaps://ldap.corp';
config/conf.php:$conf['auth']['driver'] = 'ldap';
config/conf.php:$conf['prefs']['maxsize'] = 65535;
config/conf.php:$conf['prefs']['params']['hostspec'] = 'ldaps://ldap.corp';
config/conf.php:$conf['prefs']['params']['port'] = 636;
config/conf.php:$conf['prefs']['params']['version'] = '3';
config/conf.php:$conf['prefs']['params']['basedn'] = 'dc=corp';
config/conf.php:$conf['prefs']['params']['fetchdn'] = true;
config/conf.php:$conf['prefs']['params']['uid'] = 'uid';
config/conf.php:$conf['prefs']['driver'] = 'ldap';
config/conf.php:$conf['hooks']['authldap'] = false;
config/conf.php:$conf['accounts']['driver'] = 'ldap';

With this configuration horde3 find the dn of a user (by uid) and  
read/write the attributes "hordePrefs" and "impPrefs" for every  
user-account.
(ldap://localhost is a readonly sync-replica of ldaps://ldap.corp)

My horde5 setup is based on Debian packages [1], include horde5, imp,  
turba, ingo and passwd.

root at horde:/etc/horde# egrep '(sql|ldap|prefs)' */conf*php
horde/conf.local.php:$conf['ldap']['hostspec'] =  
array('ldaps://ldap.corp:636/');
horde/conf.local.php:$conf['ldap']['timeout'] = 2;
horde/conf.local.php:$conf['ldap']['version'] = 3;
horde/conf.local.php:$conf['ldap']['binddn'] =  
'cn=horde,ou=serviceaccounts,dc=corp';
horde/conf.local.php:$conf['ldap']['bindpw'] = '***';
horde/conf.local.php:$conf['ldap']['user']['basedn'] = 'dc=corp';
horde/conf.local.php:$conf['ldap']['user']['uid'] = 'uid';
horde/conf.local.php:$conf['ldap']['user']['objectclass'] =  
array('hordePerson');
horde/conf.local.php:$conf['ldap']['user']['filter_type'] = 'objectclass';
horde/conf.local.php:$conf['ldap']['bindas'] = 'user';
horde/conf.local.php:$conf['ldap']['useldap'] = true;
horde/conf.local.php:$conf['prefs']['params']['basedn'] = 'dc=corp';
horde/conf.local.php:$conf['prefs']['params']['scope'] = 'sub';
horde/conf.local.php:$conf['prefs']['params']['uid'] = 'uid';
horde/conf.local.php:$conf['prefs']['params']['driverconfig'] = 'horde';
horde/conf.local.php:$conf['prefs']['driver'] = 'Ldap';
horde/conf.php:$conf['sql']['database'] = '/var/horde/sqlite3';
horde/conf.php:$conf['sql']['charset'] = 'utf-8';
horde/conf.php:$conf['sql']['logqueries'] = false;
horde/conf.php:$conf['sql']['phptype'] = 'sqlite';
horde/conf.php:$conf['nosql']['phptype'] = false;
horde/conf.php:$conf['ldap']['useldap'] = false;
horde/conf.php:$conf['prefs']['maxsize'] = 65535;
horde/conf.php:$conf['prefs']['params']['driverconfig'] = 'horde';
horde/conf.php:$conf['prefs']['driver'] = 'Sql';
horde/conf.php:$conf['menu']['links']['prefs'] = 'authenticated';
imp/conf.local.php:$conf['sentmail']['params']['phptype'] = 'sqlite';

You may note, I override the default pref/diver=sql from conf.php with  
prefs/driver=ldap in conf.local.php
The sqlitedb only have small amount of data. sqlite was chosen as  
there wasn't a database till now
and to avoid the burden of yet another database.

I may now run horde-db-migrate which only tell "everything up to date"

root at horde:~# horde-db-migrate
[  INFO  ] Migrating DB up.
[  INFO  ] Current imp schema version: 3
[  INFO  ] Ending imp schema version: 3
[  INFO  ] Current ingo schema version: 7
[  INFO  ] Ending ingo schema version: 7
[  INFO  ] Current turba schema version: 11
[  INFO  ] Ending turba schema version: 11
[  INFO  ] Current content schema version: 2
[  INFO  ] Ending content schema version: 2
[  INFO  ] Current Horde_Alarm schema version: 2
[  INFO  ] Ending Horde_Alarm schema version: 2
[  INFO  ] Current Horde_Auth schema version: 1
[  INFO  ] Ending Horde_Auth schema version: 1
[  INFO  ] Current Horde_Cache schema version: 2
[  INFO  ] Ending Horde_Cache schema version: 2
[  INFO  ] Current Horde_Core schema version: 1
[  INFO  ] Ending Horde_Core schema version: 1
[  INFO  ] Current Horde_Dav schema version: 2
[  INFO  ] Ending Horde_Dav schema version: 2
[  INFO  ] Current Horde_Group schema version: 3
[  INFO  ] Ending Horde_Group schema version: 3
[  INFO  ] Current Horde_History schema version: 6
[  INFO  ] Ending Horde_History schema version: 6
[  INFO  ] Current Horde_Imap_Client schema version: 2
[  INFO  ] Ending Horde_Imap_Client schema version: 2
[  INFO  ] Current Horde_Lock schema version: 3
[  INFO  ] Ending Horde_Lock schema version: 3
[  INFO  ] Current Horde_Perms schema version: 3
[  INFO  ] Ending Horde_Perms schema version: 3
[  INFO  ] Current Horde_Prefs schema version: 3
[  INFO  ] Ending Horde_Prefs schema version: 3
[  INFO  ] Current Horde_SessionHandler schema version: 2
[  INFO  ] Ending Horde_SessionHandler schema version: 2
[  INFO  ] Current Horde_Token schema version: 1
[  INFO  ] Ending Horde_Token schema version: 1
[  INFO  ] Current Horde_Vfs schema version: 4
[  INFO  ] Ending Horde_Vfs schema version: 4

I also found "imp-admin-upgrade" It end with this message very fast:
root at horde:~# time imp-admin-upgrade --task=backend_perms
[  INFO  ] Upgrading permissions.
[  INFO  ] DONE upgrading permissions.

real    0m0,065s
user    0m0,036s
sys     0m0,024s

So this also seem to not change the prefs of all users.


Andreas

[1]  
https://packages.debian.org/search?keywords=php-horde&searchon=names&suite=stable&section=all