[turba] Localsql not listed

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

Zitat von Francine.Bolduc at ti.csaffluents.qc.ca:

> Hi !
>
> I have 3 actives address book in /turba/config/backends.php.
>
> In Horde, I see "ldapEmpl" and "ldapEle" but not "localsql". Why ?
>
> backend.php :
>
> $cfgSources['localsql'] = array(
>     'disabled' => false,
>     'title' => "Mon carnet personnel",
>     'type' => 'sql',
>     'params' => array(
>         'sql' => array(
>         'phptype' => 'pgsql',
>         'hostspec' => 'localhost',
>         'username' => 'horde',
>         'password' => '<my_password>',
>         'database' => 'horde',
>         'charset' => 'utf-8'
>         ),
>         'table' => 'turba_objects'
>     ),
>         'map' => array(     .... etc...

Here is backends code....

        'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        '__uid' => 'object_uid',
        'name' => 'object_name',
        'email' => 'object_email',
        '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',
    ),
    'use_shares' => false,
    'browse' => true,
    'export' => true

> );



"etc" is actually the important point. If you use shares, "localsql" 
is not a valid address book name.

> $cfgSources['ldapEmpl'] = array(
>     'disabled' => false,
>     'title' => "Employe",
>     'type' => 'ldap',
>     'params' => array(
>         'server' => '<my_server>',
>         'port' => 389,
>         'tls' => false,
>         'root' => 'ou=EMPLOYES,ou=PERSONNES,o=MY_ORG',
>         'bind_dn' => '<my_bind_dn>',
>         'bind_password' => '<my_password>',
>         'sizelimit' => 200,
>         'dn' => array('cn'),
>         'objectclass' => array('person'),
>         'scope' => 'one',
>         'charset' => 'iso-8859-1',
>         'checkrequired' => false,
>         'checkrequired_string' => ' ',
>         'checksyntax' => false,
>         'version' => 3
>     ),
>     'map' => array(  .... etc...

Here is backends code....

 'map' => array(
        '__key' => 'dn',
        'name' => 'displayName',
        'email' => 'mail',
        'title' => 'title',
        'company' => 'l',
        'workAddress' => 'departmentNumber'
    ),
    'search' => array(
        'name',
        'email',
        'company',
        'workAddress'
    ),
    'strict' => array(
        'dn'
    ),
    'browse' => false,
    'export' => false


> );
>
> $cfgSources['ldapEle'] = array(
>     'disabled' => false,
>     'title' => "Eleve",
>     'type' => 'ldap',
>     'params' => array(
>         'server' => '<my_server>',
>         'port' => 389,
>         'root' => 'ou=ELEVES,ou=PERSONNES,o=MY_ORG',
>         'bind_dn' => '<my_bind_dn>',
>         'bind_password' => '<my_password>',
>         'sizelimit' => 200,
>         'dn' => array('cn'),
>         'objectclass' => array('person'),
>         'scope' => 'one',
>         'charset' => 'iso-8859-1',
>         'checkrequired' => false,
>         'checkrequired_string' => ' ',
>         'checksyntax' => false,
>         'version' => 3
>     ),
>     'map' => array(  ... etc...
 
Here is backends code....

   'map' => array(
        '__key' => 'dn',
        'name' => 'displayName',
        'email' => 'mail',
        'title' => 'title',
        'group' => 'businessCategory',
        'workAddress' => 'departmentNumber'
    ),
    'search' => array(
        'name',
        'email',
    ),
    'strict' => array(
        'dn'
    ),
    'browse' => false,
    'export' => false
> );
>
> localldap and  personal_ldap are disabled.
> prefs and favourites are enabled.
>
>
>
>
> prefs.php :
>
> $_prefs['addressbooks'] = array(
>     'value' => json_encode(array('localsql','ldapEmpl','ldapEle'))
> );
>
> $_prefs['columns'] = array(
>     'value' => "localsql\temail\nEmploye\temail\nEleve\temail"
> );
>
>
> Thanks
>
> Francine
>
>
> --
> turba mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org


And now, my prefs file :


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

$_prefs['sync_books'] = array(
    'value' => 'a:0:{}',
    'type' => 'multienum',
    'desc' => _("Select the address books that should be used for 
synchronization with external devices:"),
);

$_prefs['columnselect'] = array(
    'locked' => true,
    'type' => 'special'
);

$_prefs['columns'] = array(
    'value' => "localsql\temail\nEmploye\temail\nEleve\temail"
);

Can you find what's wrong ?

Thanks a lot.


Francine


-- 
Jan Schneider
The Horde Project
http://www.horde.org/


--