gmane.comp.horde.turba

Localsql not listed

2012-04-13T20:12:39

Do not laugh... :-)

I put personnel info but nothing serious.

You understand that these lines should not be there.

$cfgSources['localsql'] = array(
    // ENABLED by default
    'disabled' => false,
    'title' => _("My Address Book"),
    'type' => 'sql',
    'params' => array(
        // The default connection details are pulled from the Horde-wide 
SQL
        // connection configuration.
        // To use another DB connection, you must provide configuration
        // information here - for example,
        //'sql' => array(
        //    'persistent' => false,
        //    'username' => 'horde',
        //    'password' => 'secret',
        //    'socket' => '/var/run/mysqld/mysqld.sock',
        //    'protocol' => 'unix',
        //    'database' => 'horde',
        //    'charset' => 'utf-8',
        //    'ssl' => false,
        //    'splitread' => false,
        //    'phptype' => 'mysql'
        //),
        'table' => 'turba_objects'
    ),

Francine

Localsql not listed

2012-04-13T19:44:40

Finally, the problem is probably in this part of the code : 


I replaced the configuration of my "localsql" by that "backends.php.dist" 
file :

$cfgSources['localsql'] = array(
    'disabled' => false,
    'title' => _("Shared Address Books"),
    'type' => 'sql',
    'params' => array(
        // The default connection details are pulled from the Horde-wide 
SQL
        // connection configuration.
        // To use another DB connection, you must provide configuration
        // information here - for example,
        //'sql' => array(
        //    'persistent' => false,
        //    'username' => 'horde',
        //    'password' => 'secret',
        //    'socket' => '/var/run/mysqld/mysqld.sock',
        //    'protocol' => 'unix',
        //    'database' => 'horde',
        //    'charset' => 'utf-8',
        //    'ssl' => false,
        //    'splitread' => false,
        //    'phptype' => 'mysql'
        //),
        'sql' => array(
        'phptype' => 'pgsql',
        //'hostspec' => 'bdcsa8dev.csaffluents.qc.ca',
        'server' => 'bdcsa84dev.csaffluents.qc.ca',
        'username' => 'horde',
        'password' => 'c98f1706',
        'database' => 'horde',
        'charset' => 'utf-8'
        ),
        'table' => 'turba_objects'
    ),


and I removed " 'use_shares' => true " and the Address book work. 

Thanks

Francine

Localsql not listed

2012-04-11T13:01:14

synchronization with external devices:"),

Did you check the user preference like I suggested?

(no subject)

Rodrigo Abantes Antunes — 2012-04-05T11:25:11

Hi, when I try to import a lot of contacts it says that it was  
sucessfull but when i list the contacts they appear like this (with  
only the < at >):

Name Nickname E-mail
Ana   < at >

In the logs i see this:

2012-04-05T08:19:54-03:00 NOTICE: HORDE [turba] PHP ERROR: Trying to  
get property of non-object [pid 16446 on line 70 of  
"/var/www/horde4/turba/data.php"]

Turba doesn't allow localhost email addresses

Ralf Lang — 2012-04-02T06:39:59

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Turba's Email field doesn't allow localhost addresses or any addresses
which just have a top level domain but now lower level.

This is caused by the Horde_Form_Type::_isRfc3696ValidEmailAddress
parser, line 2002 (because these are not public internet addresses)

RFC 3696 doesn't say an email address must be on a public domain.
In fact, < at >localhost is a valid email address for local delivery.

Do you think we should remove that requirement?

- -- 
Ralf Lang
Linux Consultant / Developer
Tel.: +49-170-6381563
Mail: lang< at >b1-systems.de

B1 Systems GmbH
Osterfeldstraße 7 / 85088 Vohburg / http://www.b1-systems.de
GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.18 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk95Sb8ACgkQCs1dsHJ/X7Ax9ACg5NZRz33q8y6tbMQJ/nPp2EQ2
eYsAnRGVziapOqRKyaydI2d/Y3CBoafe
=3xIy
-----END PGP SIGNATURE-----

Totals for contacts in the address book?

Sebastian Arcus — 2012-04-01T19:55:47

I have Turba 3.0.12 installed and working fine. However, I can't seem to 
find anywhere the total number of contacts in any of my address books - 
either at the bottom of the list, or on the status bar at the top. After 
I imported my address book - I wanted to double check that all contacts 
were imported - so I looked for a total number of contacts. I couldn't 
spot this anywhere. I've also googled for it - but again, without any 
relevant results so far. I'm used to this feature from pretty much every 
address book software I've used - both on computers and phones. Are 
totals displayed somewhere and I've missed it somehow?

Thanks,

Sebastian

Localsql not listed

2012-03-30T15:31:49

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...
);

$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

No alphabetical categorisation for certain ldap backends

Mehmet Giritli — 2012-03-29T13:14:15

Hi list,


I have a number of ldap sources configured and currently working with a
minor problem. Some of my addressbooks are missing the alphabetical
listing feature that the other addressbooks have when you select them.
I'm talking about the bar at top of the listing which is like "(All) A B
C ....". When I select such an addressbook I don't see the bar at all
and I get a complete listing of the contents of the addressbook. What
might be the factors in the ldap configuration that is causing this?

I have two addressbooks from a ldap server pointing at different roots
and while one of them exhibit the problem, the other one doesn't.

When I change the root of the problematic addressbook to point the same
root as the working one, I get the alphabet bar. This must be something
with the ldap configuration, but I have no clues where to start...

Any tips would be highly appreciated.

Thanks.

deleting LDAP entries fails: "VFS not supported for thisobject."

Bernhard Erdmann — 2012-03-22T08:40:10

Hi,

trying to delete a turba (version 3.0.12) contact results in the  
message "VFS not supported for this object." and the object is not  
deleted. The backend is OpenLDAP.

Changing preferences in conf.php from a) to b) does not make a difference.

a)
$conf['documents']['type'] = 'horde';

b)
$conf['documents']['params']['vfsroot'] = '/var/lib/horde4';
$conf['documents']['type'] = 'File';

Questions on using HORDE address book . . .

Mark R. Spengler — 2012-03-08T17:26:46

1)      How does one add a tel. extension to a telephone number in the
address book?  What is the proper syntax?
2)      When I have Horde running and e-mails arrive, the sound
acknowledgement is not heard even though I can play it/test it and it is set
to play under "Global Options/Message Options/New Mail".  I use Furefox as
my default browser.
 
3)     Can I set e-mails in Horde to forward to my smart phone and at the
same time remain on Horde? If so, how?  
 
Thank you,
 
 
 
Mark R. Spengler
E-Mail:  <mailto:markrspengler< at >gmail.com> markrspengler< at >gmail.com

Error in address book

Romulo Pires Pinto — 2012-03-08T21:38:28

When I send email, recipients of outgoing messages be added  
automatically to the address book, but show the popup error: "Invalid  
contacts: localsql" (save_recipients=enable AND  
add_source=localsql)... im using Horde (horde) 4.0.13, (imp) 5.0.18  
and (turba) 3.0.11.

An people can help me?
------------------------------------------------------
     Esse e-mail foi enviado pelo WebMail da UFF
NTi - Núcleo de Tecnologia da Informação e Comunicação

Autocomplete does not work with 3.0.12

Mehmet Giritli — 2012-03-04T12:55:45

I am using a ldap backend addressbook and autocomplete with new message
composition's To field does not work. I can see that a query is made to
the ldap server, but no results are displayed by Turba.

I found bug http://bugs.horde.org/ticket/10961 which looked very similar
to my issue, except that I am using a ldap backend. I see that 3.0.12
included the fix for it, but I still have the problem. Could it be that
the problem is not entirely fixed?

Ticket 10557

Simon Brereton — 2012-03-02T16:32:14

Hi

According to http://bugs.horde.org/ticket/10557 this bug was resolved
74 days ago, and yet my Turba version (3.0.11) still has this issue.

Simon

Adding additional fields to Turba on Kolab 2.3.4

Greg Conway — 2012-02-07T20:21:22

Hi all,

 

This is my first post to the Turba list, so for starters. hello everybody! J

 

I have 2 x Kolab installations running on the whole very satisfactorily. On
both I am running Horde 3 (as included with the community edition of Kolab)
and I am using z-push to sync with mostly Apple iPhones/iPads running IOS5.

 

I have some issues with address book syncing, and after studying the z-push
logs, decided Horde was missing some fields that the iPhone users are using.


So I've worked out what fields to add, and how to add them - seemingly by
modifying attributes.php and sources.php.

 

I've put together my full list of modifications, and I've added them to my
first Kolab server - which is v2.2.4. Initially it didn't work, until I
worked out that inside sources I also need to add my new fields to the
"tabs" array. Following that, the additional fields appeared inside Turba.

 

However. I made *exactly* the same mods to my Kolab 2.3.4 server, but Turba
has not recognised the change.

 

My (rather long winded question) is this. what am I missing?! Is there
something extra I need to do to make this work (since Kolab 2.2.4)?

 

If it helps, I've included exactly the mods I am making (in my own
shorthand, if it makes no sense!), but like I say - these worked fine on my
2.2.4 server.

 

Many thanks for any help received!


Regards,

Greg Conway.

 

 

 

add to sources.php -

 

AFTER> 'cellPhone'         => 'mobile',

 

                    'pager'                              => 'pager',

 

AFTER> 'homeCountry'       => 'addr-home-country',

 

            'otherStreet'        => 'addr-other-street',

            'otherCity'          => 'addr-other-locality',

            'otherProvince'      => 'addr-other-region',

            'otherPostalCode'    => 'addr-other-postal-code',

            'otherCountry'       => 'addr-other-country',

 

AFTER> 'homeCountry',

 

            'otherStreet',

            'otherCity',

            'otherProvince',

            'otherPostalCode',

            'otherCountry',

 

AFTER> 'cellPhone',

 

            'pager',

 

Rewrite -

 

                    'workCountry'),

to 

                    'workCountry', 'otherStreet', 'otherCity',
'otherProvince', 'otherPostalCode', 'otherCountry'),

 

 

Rewrite -

 

                    'cellPhone', 'fax', 'instantMessenger'),

to

                    'cellPhone', 'pager', 'fax', 'instantMessenger'),

Fwd: Extend LDAP-example

Michael J Rubinsky — 2012-02-07T15:37:09


----- Forwarded message from Hanns Mattes <hanns< at >hannsmattes.de> -----
    Date: Tue, 07 Feb 2012 16:30:30 +0100
    From: Hanns Mattes <hanns< at >hannsmattes.de>
Subject: Re: [turba] Extend LDAP-example
      To: Michael J Rubinsky <mrubinsk< at >horde.org>

Am 07.02.2012 16:19, schrieb Michael J Rubinsky:

Yes, You're right:

'name' => array(
           'fields' => array('firstname', 'lastname'),
           'format' => '%s %s',
           'attribute' => 'cn'
              ),

is working.

Thank You.

Regards
Hanns

----- End forwarded message -----

turba, ldap and activesync

Hanns Mattes — 2012-01-31T14:55:28

Hi,

I've configured turba with a ldap-addressbook for the users to store
their contacts, which is working fine. I've used the example from
backends.php.

After synching the contacts with a Galaxy Nexus I see, that only parts
of the contact-data are transmitted, some address-data, the first name
etc. is missing. For a test, I've activated a locals sql-addressbook,
which synced perfectly.

I think, I have to modify/extend the ldap-Entry in backends.local.php.
Any advice (or a working example) appreciated.

Regards Hanns

Tons of PHP ERROR about indexes

LALOT Dominique — 2012-01-31T08:11:18

Hello,

I am trying to get rid of large quantities of such errors, and don't know
what to do. PHP which was logging such messages as NOTICE is logging as
ERROR.
The traces appear with autocompletion (which is working by the way)
Can we do something to avoid that?

Thanks

Dom

Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Undefined index: fields
[pid 13478 on line 102 of "/var/www/horde/turba/lib/Object.php"]
Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Invalid argument supplied
for foreach() [pid 13478 on line 102 of
"/var/www/horde/turba/lib/Object.php"]
Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Undefined index: format
[pid 13478 on line 105 of "/var/www/horde/turba/lib/Object.php"]
Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Undefined index: fields
[pid 13478 on line 102 of "/var/www/horde/turba/lib/Object.php"]
Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Invalid argument supplied
for foreach() [pid 13478 on line 102 of
"/var/www/horde/turba/lib/Object.php"]
Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Undefined index: format
[pid 13478 on line 105 of "/var/www/horde/turba/lib/Object.php"]
Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Undefined index: fields
[pid 13478 on line 102 of "/var/www/horde/turba/lib/Object.php"]
Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Invalid argument supplied
for foreach() [pid 13478 on line 102 of
"/var/www/horde/turba/lib/Object.php"]
Jan 31 09:06:40 horde41 HORDE: [turba] PHP ERROR: Undefined index: format
[pid 13478 on line 105 of "/var/www/horde/turba/lib/Object.php"]

Turba H4 (3.0.11) (final)

Jan Schneider — 2012-01-17T12:22:37

The Horde Team is pleased to announce the final release of the Turba Contact
Manager version H4 (3.0.11).

Turba is the Horde contact management application. Leveraging the Horde
framework to provide seamless integration with IMP and other Horde
applications, it supports storing contacts in SQL, LDAP, Kolab, and IMSP
address books. For more information on Turba, visit
http://www.horde.org/apps/turba.

The major changes compared to the Turba version H4 (3.0.10) are:
     * Improved vCard compatibility.
     * Updated Japanese translation.

The full list of changes can be viewed here:

https://github.com/horde/horde/blob/b4899ea96975865a89e1ac45cb79be8f6d005bcf/turba/docs/CHANGES

Have fun!

The Horde Team.

Turba migration

Alexis Domjan — 2012-01-11T13:52:45

Dear all,

I've migrated our server and I then installed a new version of Horde, 
IMP and Turba. As I did not an upgrade of packages I had to perform the 
database modifications manually, which has been done.

So, now, a user can get the list of his contacts but when he clicks on a 
contact he's getting: "The contact you requested does not exist".

I tried to debug and the problems occures in the file turba/contact.php:

$vars = Variables::getDefaultVariables();
$source = $vars->get('source');
if (!isset($GLOBALS['cfgSources'][$source]))

And so, $GLOBALS['cfgSources'][$source] is not set and it doesn't go 
further.

Anyone would have any idea ?

Additionnaly I had to change the value of object_type column from 
'Object' to 'Group' so that the contacts can be accessible.

Any help will be really appreciated.
Kind regards

LDAP address book.

ANANT S ATHAVALE — 2011-12-09T10:30:15

Dear List,

I am testing Horde Groupware Webmail Edition 4.0.4 in Traditional View.

Under Horde Portal Contact Search option, everything works fine when  
LDAP map __key points to cn (default).  ie. after searching for  
contact from LDAP, if I click on view contact, it shows the details in  
Turba.

I had earlier reported one bug:  http://bugs.horde.org/ticket/8986 and  
I wanted to see, if that problem still exists.  So, Now, I have  
changed __key to mail.


      'map' => array(
          '__key' => 'mail',

Search works fine, but, if I click on the link provided to view  
contact, I get 'No results'.

Is this a bug? But, I have a feeling, my old bug 8986 might have been  
solved as search continues to work even when I change the key.

Please update me on this.

Choose which address books to use - locked preference.

ANANT S ATHAVALE — 2011-12-08T04:03:13

Dear List,

I have locked the preference, by writing the following lines in  
prefs.local.php

$_prefs['addressbooks']['locked'] = true;
$_prefs['addressbooks']['value'] = json_encode(array('localsql',  
'localldap','favourites'));
$_prefs['default_dir']['locked'] = true;
$_prefs['default_dir']['value'] = 'localsql';


But, even after that, If I open preferences option, I see the following in

Address Books
     Choose which address books to use.

Though, I am not allowed to change any settings. I just want to know,  
whether displaying itself is right or not (as options are locked).