[turba] How to configure remote postgres database

[Rodrigo S Wanderley]

Im trying to configure turba to use Postgresql database.  The database is located in a host called php4 in my network, here is how I edited sources.php:

$cfgSources['localsql'] = array(
    'title' => 'Lista de Enderecos',
    'type' => 'sql',
    'params' => array(
        'phptype' => 'pgsql',
        'hostspec' => 'sql4.digi.com.br',
        'username' => 'horde',
        'password' => 'the_pwd',
        'database' => 'horde',
        'table' => 'turba_objects'
    ),
    'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        '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'
    ),
    'search' => array(
        'name',
        'email'
    ),
    'strict' => array(
        'object_id'
    ),
    'public' => false,
    'readonly' => false,
    'admin' => array(),
    'export' => true
);

The database is called horde and I create the turba_objects table as defined at pgsql_create.sql file.

If anyone knows what Im doing wrong I would apreciate.

thx,
  Rodrigo
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.horde.org/archives/turba/attachments/20040908/3dcc65b5/attachment.bin