[turba] Localsql not listed
Jan Schneider
jan at horde.org
Fri Mar 30 16:28:50 UTC 2012
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...
> );
"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...
> );
>
> $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...
> );
>
> 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
--
Jan Schneider
The Horde Project
http://www.horde.org/
More information about the turba
mailing list