[turba] Localsql not listed

[Michael J Rubinsky]

Quoting 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 ?

Did you check the user preference like I suggested?

-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6096 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.horde.org/archives/turba/attachments/20120330/a7d3953e/attachment-0001.bin>