[turba] Accessing external source

[Andreas Dahlen]

Citerar Jan Schneider <jan at horde.org>:

> Zitat von Andreas Dahlen <andreas at dahlen.ws>:
>
>> When searching on firstname or lastname I gett the following in the
>> Horde log.
>> Nov 08 12:48:11 HORDE [debug] [turba] SQL query by
>> Turba_Driver_sql::_read(): SELECT ShortName, FirstName, LastName FROM
>> User WHERE ShortName IN (?) [on line 145 of
>> "/export/wwwdb/intern/webmail3/turba/lib/Driver/sql.php"]
>
> This can't be the corresponding configuration, because ShortName
> doesn't even exist there:

ShortName does exist; The first map-field is;

'__key' => 'ShortName'

Isn't that correct?

>
>> For my search I get 5 hits, and the browsed values are
>> Name : [No Value]
>> Email: Blank
>>
>> I've tried the following configuration;
>> $cfgSources['intrasql'] = array(
>>    'title' => "Sigma nBiT",
>>    'type' => 'sql',
>>    'params' => array(
>>        'phptype' => 'mysql',
>>        'hostspec' => 'localhost',
>>        'username' => 'xxxxx',
>>        'password' => 'xxxxx',
>>        'database' => 'intranet',
>>        'table' => 'User',
>>        'charset' => 'iso-8859-1'
>>    ),
>>    'map' => array(
>>        '__key' => 'ShortName',
>>        'name' => array('fields' => array('FirstName', 'LastName'),
>>                        'format' => '%s %s'),
>>        'email' => array('fields' => array('MailName'),
>>                        'format' => '%s at example.com'),
>>        'firstname' => 'FirstName',
>>        'lastname' => 'LastName'
>>        'homePhone' => 'HomePhone',
>>        'workPhone' => 'OfficePhone',
>>        'cellPhone' => 'Mobile'
>>    ),
>>    'search' => array(
>>        'firstname',
>>        'lastname',
>>        'name'
>> //      'alias'
>>    ),
>>    'strict' => array(
>> //        'alias'
>>    ),
>>    'public' => true,
>>    'readonly' => true,
>>    'admin' => array(),
>>    'export' => false
>> );
>>
>>
>> /Andreas
>
> Jan.

/Andreas



----------------------------------------------------------------
This message was sent using IMP (http://www.horde.org).
Running on PHP 4.3.11, Apache 2.0.53, FreeBSD 5.3.