[imp] Invalid address book : localsql

[Francine.Bolduc at ti.csaffluents.qc.ca]

Hi !

Horde 5 and IMP 6 work good but I have always a little problem. Impossible 
to save the sender's address in the personal address book. The message is 
: "Invalide address book : localsql".

If I go to the options of IMP and save the parameters of "Address book", 
there is not problem anymore


Here is a part of imp/prefs.local.php :

$_prefs['search_sources']['value'] = json_encode(array(
        'localsql',
        'ldapEmpl',
        'ldapEle',
        'csaSympa'));

$_prefs['search_fields']['value'] =  json_encode(array(
        'localsql' => array('name', 'firstname', 'email'),
        'ldapEmpl' => array('name', 'firstname', 'email'),
        'ldapEle' => array('name', 'firstname', 'email'),
        'csaSympa' => array('name', 'firstname', 'email')));

$_prefs['add_source']['value'] = 'localsql';


And a part of turba/backends.local.php

$cfgSources['localsql'] = array(
    'disabled' => false,
    'title' => _("Address Books"),
    'type' => 'sql',
    'params' => array(
        //'sql' => array(
        //    'username' => 'horde',
        //    'password' => ....,
        //    'database' => 'horde',
        //    'charset' => 'iso-8859-1',
        //    'phptype' => 'pgsql'
        //),
        'table' => 'turba_objects'
    ),
    'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        '__uid' => 'object_uid',
        'firstname' => 'object_firstname',
        'lastname' => 'object_lastname',
        'name' => array('fields' => array('firstname', 'lastname'),
                        'format' => '%s %s',
                        'parse' => array(
                            array('fields' => array('firstname', 
'lastname'),
                                  'format' => '%s %s'),
                            array('fields' => array('firstname', 
'lastname'),
                                  'format' => '%s %s'))),
        'birthday' => 'object_bday',
.....
 ),
    'tabs' => array(
        _("Personal") => array('firstname', 'lastname', 'email', 
'birthday', 'photo'),
        _("Location") => array('homeStreet', 'homeCity', 'homeProvince', 
'homePostalCode', 'homeCountry', 'homeAddress', 'workStreet',
                               'workCity', 'workProvince', 
'workPostalCode', 'workCountry', 'workAddress'),
        _("Communications") => array('homePhone', 'workPhone', 'homeFax', 
'cellPhone', 'fax'),
        _("Organization") => array('title', 'company', 'department', 
'logo'),
        _("Other") => array('category', 'notes', 'website'),
    ),
    'search' => array(
        'name',
        'email'
    ),
 ...
);

$cfgSources['ldapEmpl'] = array(
    'title' => 'Titre',
    'type' => 'ldap',
    'params' => array(
        'server' => 'info...',
....
    ),
    'map' => array(
        '__key' => 'dn',
        'name' => 'displayName',
        'firstname' => 'givenname',
        'email' => 'mail',
        'title' => 'title',
        'company' => 'l',
        'department' => 'departmentNumber'
    ),
    'search' => array(
        'name',
        'firstname',
        'email',
        'company',
        'department'
    ),
    'strict' => array(
        'dn'
    ),
    'browse' => false,
    'export' => false
);

$cfgSources['ldapEle'] = array(
    'title' => 'titre',
    'type' => 'ldap',
    'params' => array(
        'server' => '...',
....
    ),
    'map' => array(
        '__key' => 'dn',
        'name' => 'sn',
        'firstname' => 'givenname',
        'email' => 'mail',
        'school' => 'l',
        'group' => 'businesscategory'
    ),
    'search' => array(
        'name',
        'firstname',
        'email',
        'school',
        'group'
    ),
    'strict' => array(
        'dn'
    ),
....
);

$cfgSources['csaSympa'] = array(
    'title' => 'Sympa',
    'type' => 'ldap',
    'params' => array(
        'server' => '...',
....
    ),
    'map' => array(
'__key' => 'dn',
        'name' => 'cn',
        'email' => 'mail'
    ),
    'search' => array(
        'name',
        'email'
    ),
    'strict' => array(
        'dn'
    ),
....

Thanks