[turba] Missing address books in Turba 2.1.2

[fabricio bianco abreu]

Hi folks,

I am trying to migrate an old horde system instalation (Horde: 2.2.3, IMP:
3.2.1. Turba: 1.2, Kronolith: 1.1, Nag: 1.1) to a brand new server, runnig
current horde applications:

# Horde: 3.1.3
# Imp: H3 (4.1.3) (run Imp tests)
# Ingo: H3 (1.1.1) (run Ingo tests)
# Passwd: H3 (3.0) (run Passwd tests)
# Turba: H3 (2.1.2)

I am having troube to set up TURBA.

In the previous incarnation of Turba (1.2) I had a global address book on ldap
and personal address books on mysql. Each user could access (read) the global
address book and access/administrate his personal address book.

I had the old mysql database migrated ("mysql --user=root
--password=<MySQL-root-password> <db name> < 1.2_to_2.0.sql") and have set up
Horde 3.1.3 and Turba 2.1.2 accordingly. 

I'm affraid I missed something configuring Turba 2.1.2 because it is behaving
awkwardly.

Here is the list o difficulties I am facing:
1. No address book is offered to be displayed on "options->address book".
2. Both address books are availabe for search, but there is no "browse" button.
3. Whenever performing a search on a selected address book, users receive an
error message when trying to sort the resulting list upon clicking on the
column's title (something as "There is no address book that can be exhibited").

Can anybody give me a hint?
Thanks in advance.
Best regrards,

fabricio bianco abreu


Nasty details can be seen bellow.

I have configured "localsql" and "localldap" in turba/config/sources.php like this:
$cfgSources['localsql'] = array(
    'title' => _("My personal addressbook"),
    'type' => 'sql',
    'params' => array_merge($conf['sql'], array('table' => 'turba_objects')),
    'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        '__uid' => 'object_uid',
        'name' => 'object_name',
        'email' => 'object_email',
        'alias' => 'object_alias',
        'homeAddress' => 'object_homeaddress',
        'workAddress' => 'object_workaddress',
        'homePhone' => 'object_homephone',
        'workPhone' => 'object_workphone',
        'cellPhone' => 'object_cellphone',
        'fax' => 'object_fax',
        'title' => 'object_title',
        'company' => 'object_company',
        'notes' => 'object_notes',
        'pgpPublicKey' => 'object_pgppublickey',
        'smimePublicKey' => 'object_smimepublickey',
        'freebusyUrl' => 'object_freebusyurl'
    ),
    'search' => array(
        'name',
        'email'
    ),
    'strict' => array(
        'object_id',
        'owner_id',
        'object_type',
    ),
    'public' => true,
    'readonly' => false,
    'admin' => array(),
    'export' => true
);
$cfgSources['localldap'] = array(
    'title' => _("Global Address Book"),
    'type' => 'ldap',
    'params' => array(
        'server' => 'marte2.tcdf.net',
        'port' => 389,
        'tls' => false,
        'root' => 'ou=Users,dc=tcdf,dc=net',
        'bind_dn' => 'cn=*******,ou=DSA,dc=tcdf,dc=net',
        'bind_password' => '******',
        'sizelimit' => 1000,
        'dn' => array('cn'),
        'filter' => 'mail=*',
        'objectclass' => array('top',
                               'person',
                               'organizationalPerson','inetOrgPerson'),
        'scope' => 'one',
        'charset' => 'iso-8859-1',
        'checkrequired' => false,
        'checkrequired_string' => 'mail=',
        'version' => 3
    ),
    'map' => array(
        '__key' => 'dn',
        '__uid' => 'uid',
        'name' => 'gecos',
        'email' => 'mail',
    ),
    'search' => array(
        'name',
        'email'
    ),
    'strict' => array(
        'dn',
    ),
    'public' => true,
    'readonly' => true,
    'admin' => array(),
    'export' => true
);

Here is my turba/config/conf.php
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: turba/config/conf.xml,v 1.6.2.3 2006/05/09 15:58:10 jan Exp $
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array();
$conf['client']['addressbook'] = 'localsql';
$conf['comments']['allow'] = true;
$conf['documents']['params']['driverconfig'] = 'horde';
$conf['documents']['type'] = 'sql';
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */