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?

Re: (no subject)

Jan Schneider — 2012-04-05T13:19:57

Zitat von Rodrigo Abantes Antunes <rodrigoantunes< at >pelotas.ifsul.edu.br>:


There is no property access in that line in any recent Turba version.

(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"]

Re: Turba doesn't allow localhost email addresses

Jan Schneider — 2012-04-02T22:13:58

Zitat von Ralf Lang <lang< at >b1-systems.de>:


I think we should leave it. PHP's FILTER_VALIDATE_EMAIL doesn't allow  
them either, and I can see us using that instead of a userland PHP  
validator.

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

Re: Localsql not listed

Patrick Boutilier — 2012-03-31T12:55:14

Do you mean using

'use_shares' => true,

with

$cfgSources['localsql'] = array(

?


If so, that is what is in the example in backends.php . Should the 
source be called something other than localsql ?





<snip>

Re: Localsql not listed

Michael J Rubinsky — 2012-03-30T20:38:22

Quoting Francine.Bolduc< at >ti.csaffluents.qc.ca:


Did you check the user preference like I suggested?

Re: Localsql not listed

2012-03-30T20:02:18

Zitat von Francine.Bolduc< at >ti.csaffluents.qc.ca:


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.


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


 
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


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 ?

Thanks a lot.


Francine

Re: No alphabetical categorisation for certain ldap backends

Mehmet Giritli — 2012-03-30T16:50:06

Okay, this solved it. Didn't know that contacts per page affected pager
visibility. Thanks a lot.

When you mentioned size before, I thought you meant that if it is too
big, pager won't be shown. Apparently, you meant completely the other
way around...Sorry about that.

Re: No alphabetical categorisation for certain ldap backends

Jan Schneider — 2012-03-30T16:38:46

Zitat von Mehmet Giritli <mgiritli< at >giritli.eu>:


And which of those is showing which behavior?

I checked again, and the pager is indeed only hidden if the size of  
the address book is smaller than the contacts-per-page preference.
If this doesn't align with the *actual* sizes of your address books,  
then the determination of your address book sizes is broken.

Re: Localsql not listed

Jan Schneider — 2012-03-30T16:28:50

Zitat von Francine.Bolduc< at >ti.csaffluents.qc.ca:


"etc" is actually the important point. If you use shares, "localsql"  
is not a valid address book name.

Re: No alphabetical categorisation for certain ldap backends

Mehmet Giritli — 2012-03-30T16:08:15

Okay. I have two address books, lets say A and B. They are pointing to
the different root levels in the same ldap server. For example root for
A is "dc=host,dc=example,dc=com" and root for B is
"dc=organisation,dc=host,dc=example,dc=com". The scope of A is "sub". So
basically A strictly contains B: It contains B plus some other records
that are only in the root level of A and not inside B.

So, the size of address book A is bigger than B.



I just checked and the html tag is closed. I also compared the two pages
with the address book that works and the one that doesn't. The complete
div block is missing. (In the source it is named "turbaPager"). It is
not generated at all...

Re: Localsql not listed

Michael J Rubinsky — 2012-03-30T15:59:19

Quoting Francine.Bolduc< at >ti.csaffluents.qc.ca:


Check your address book prefs. Make sure that the address book that is  
missing is included in the 'address books' pref.

Re: No alphabetical categorisation for certain ldap backends

Jan Schneider — 2012-03-30T15:47:36

Zitat von Mehmet Giritli <mgiritli< at >giritli.eu>:


You did. :) I lost you completely. Can you provide some examples instead?


No. Though you should check if maybe the bar only disappears because  
the page output stops, due to a fatal PHP error. Is the page source  
correctly closed?

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

Re: No alphabetical categorisation for certain ldap backends

Mehmet Giritli — 2012-03-30T15:20:17

The address book which is working is the parent of the one which is not
working in the ldap hierarchy. Thus, size can not possibly be the
problem. In other words, I can see all the contacts from the address
book which is not working inside the one which is working and there are
some more contacts which only belong to the address book which is
working. The one which is working is strictly bigger that the one which
is not. I hope I didn't make it more complicated than it sounds...

Anyway, any other tips? There must be something else which can possibly
cause the disappearance of the alphabet bar...

By the way, could this log entry be related?

WARN: HORDE [turba] PHP ERROR: htmlspecialchars() expects parameter 1 to
be string, array given [pid 2585 on line 83 of
"/var/www/horde4/turba/templates/browse/row.inc"]

Re: No alphabetical categorisation for certain ldap backends

Jan Schneider — 2012-03-29T13:40:29

Zitat von Mehmet Giritli <mgiritli< at >giritli.eu>:


The size of the address book.

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.