[turba] Trouble upgrading from Turba 2.1.4 to 2.2.1

Chris Lafty clafty at stlawu.edu
Tue Jul 15 20:48:25 UTC 2008


My test system: RHEL 5, PHP 5 - 64 bit

I've upgrade all of my horde project to latest version (except for 
turba).  I'm having issues with individual contacts not being displayed 
("The contact you requested does not exist."), and some address book 
user prefs not being stored after editing.  Here's the scoop:

notes:
Previous tubra version 2.1.4 (worked perfectly)
Before upgrade: user --> clafty --> table: horde_prefs --> pref_name: 
addressbooks --> value: blank

Instructions for my upgrade:
1. extract turba-h3-2.2.1.tar.gz into horde directory
    versions:
    Address Book (turba)  H3 (2.2.1)
    Dynamic Mail Dynamic Mail (dimp) H3 (1.0)
    File Manager File Manager (gollem) H3 (1.0.3)
    Filters Filters (ingo) H3 (1.2)
    Mail Mail (imp) H3 (4.2)
    Mobile Mail Mobile Mail (mimp) H3 (1.1)
    SLU Webmail SLU Webmail (horde) 3.2.1
   
2. cd /var/www/html/horde/turba/config --> for f in *.dist; do cp $f 
`basename $f .dist`; done
3. chown -R root:apache ../config
4. chmod -R 770 ../config
5. add our ldap server to sources.php (at end of file)

if (Util::extensionExists('ldap')) {
/**
 * A local address book in an LDAP directory. This implements a public
 * (shared) address book.
 * To store freebusy information in the LDAP directory, you'll need the
 * rfc2739.schema from
 * http://www.whitemiceconsulting.com/node/42
 */G
$cfgSources['localldap'] = array(
    'title' => _("SLU Directory"),
    'type' => 'ldap',
    'params' => array(
        'server' => 'ldap.stlawu.edu',
        'port' => 389,
        'tls' => false,
        'root' => 'dc=stlawu,dc=edu',
        'bind_dn' => '',
        'bind_password' => '',
        'sizelimit' => 200,
        'dn' => array('cn'),
        'objectclass' => array('top',
                               'person',
                               'organizationalPerson',
                               'inetOrgPerson'),
        'scope' => 'one',
        'charset' => 'iso-8859-1',
        // Consult the LDAP schema to verify that all required 
attributes for
        // an entry are set and add them if needed.
        'checkrequired' => false,
        // Value used to fill in missing required attributes.
        'checkrequired_string' => ' ',
        // Check LDAP schema for valid syntax. If this is false an address
        // field is assumed to have postalAddress syntax; otherwise the 
schema
        // is consulted for the syntax to use.
        'checksyntax' => false,
        'version' => 3
    ),
    'map' => array(
        '__key' => 'dn',
        '__uid' => 'uid',
        'name' => 'cn',
        'email' => 'mail',
        'alias' => 'alias'
        //'workPhone' => '',
        //'cellPhone' => 'mobiletelephonenumber',
        //'homeAddress' => 'homepostaladdress',       
        // 'freebusyUrl' => 'calFBURL',
    ),
    'search' => array(
        'name',
        'email',
        'alias'
        //'homePhone',
        //'workPhone',
        //'cellPhone',
        //'homeAddress'
    ),
    'strict' => array(
        'dn',
    ),
    'export' => false,
    'browse' => false,
);
}

6. In Horde, generate new conf.php.  Use default settings:

<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: turba/config/conf.xml,v 1.6.2.5 2008/05/06 21:26:59 bklang Exp $
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array();
$conf['client']['addressbook'] = 'localsql';
$conf['shares']['source'] = 'localsql';
$conf['comments']['allow'] = true;
$conf['documents']['type'] = 'none';
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

7. run 2.1_to_2.2_sql_schema.php > outputforreal
    Interesting messages:
   
    Warning: strpos(): Empty delimiter. in 
/usr/share/pear/Mail/RFC822.php on line 622

    Some of:
    Call Stack:
        0.0013     197208   1. {main}() 
/var/www/html/horde/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php:0
       83.7402   21239832   2. getBareEmail() 
/var/www/html/horde/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php:222
       83.7402   21239832   3. Mail_RFC822->validateMailbox() 
/var/www/html/horde/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php:304
       83.7424   21240760   4. strpos() /usr/share/pear/Mail/RFC822.php:622

    Lots of:
    Notice: Trying to get property of non-object in 
/var/www/html/horde/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php on 
line 305

    Call Stack:
        0.0013     197208   1. {main}() 
/var/www/html/horde/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php:0
       83.7402   21239832   2. getBareEmail() 
/var/www/html/horde/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php:222


    All SQL statements return [ OK ]
   
8.  After script user --> clafty --> table: horde_prefs --> pref_name: 
addressbooks --> value:

1bbaef3ac8577c7bd214d95d9ae67e23


9. If I click on an individual user in my address book, I get this message:

The contact you requested does not exist.

Jul 15 11:30:55 HORDE [debug] [horde] SQL Query by 
SessionHandler_mysql::_read(): query = "SELECT session_data FROM 
horde_sessionhandler WHERE session_id = 'v54b54bguc8hs73su5d8guhet1' AND 
session_lastmodified > 1216134415 FOR UPDATE" [pid 843 on line 144 of 
"/var/www/html/horde/lib/Horde/SessionHandler/mysql.php"]
Jul 15 11:30:55 HORDE [debug] [turba] Hook _horde_hook_share_init in 
application horde not called. [pid 843 on line 1629 of 
"/var/www/html/horde/lib/Horde.php"]
Jul 15 11:30:55 HORDE [debug] [turba] Hook 
_prefs_change_hook_addressbooks in application horde not called. [pid 
843 on line 1629 of "/var/www/html/horde/lib/Horde.php"]
Jul 15 11:30:55 HORDE [debug] [turba] SQL Query by Prefs_sql::store(): 
SELECT 1 FROM horde_prefs WHERE pref_uid = ? AND pref_name = ? AND 
pref_scope = ?, values: clafty, addressbooks, turba [pid 843 on line 210 
of "/var/www/html/horde/lib/Horde/Prefs/sql.php"]
Jul 15 11:30:55 HORDE [debug] [turba] SQL Query by Prefs_sql::store(): 
UPDATE horde_prefs SET pref_value = ? WHERE pref_uid = ? AND pref_name = 
? AND pref_scope = ?, values:
65128dbf9ed75063f27852331d5b921e
b5d8670d511ef3c649d807f4303ee9b5
261c9a5ae34aeb5ab9082232f49006d8
afc6cf3e0ddfbadcf1f155b0921c83e8
4064b2fa72b31323702cda59ce813e91
3cbcfda1c20eef782c779f53626cf667
f0280123c2921c38c59870497952d007
7cd8b295125c7c6c1b9fa0ef105fab67
f88338d727961227df88febc185f6b83
fa9790be5addbd3bc6253b74ac3cdc20
14ef455cc89c5a2f644305f0cbe447db
031d2dd792e71f7fa335e8f8bd8bb364
1e8efa1cc365c8b0ea0e9254dfee4539
47496a6cc7668b4d6188251882d1b84a
e6d01e7a64367c31eed861a86113031f
7ac64253eeabd097e1a53b3a5f9897dc
aa00f880bbfd7dc0c1b1a7a29827bec5
82b08ef79c66c93ec39cb91af3ecd2f3
c76ff1164f0831742f18390852c37080
75661fab92dfae14b9d7c9fe3ae92011
9c4a8566cd92c8378d3693f882d97c90
82c6fd7e976f47b3b493b66662f7d425
13d2ceeca255deecf132e071e0649cef
04e6bd5a944a620d8b95af0ff07170bf
b53413b2a7101015fdefddf6ccbfcc66
9b51b1cbf06ff794b7adce1ccd66351e
25d2d9fabb0502f076a893c338574c80
39d501c06a2c126748f5b3bcfd703e02
6d4ae6d7d34440fa017c5452073767f0
9d544414d5708a043802833297e55224
2d6edecb0e0cd3a0b7e0ee34d266c78e
d114967c3e7addc52081b1f638638ff6
b38eec668b546c92bcb0976c0211bfc4
88bde760bd30c4bb38d70f1c5022e747
b741f56fdce416779dd4f21beb03f0d2
641e7da219046f77456f5c4560b62424
b8a12353e96e98ee09433a7ba36dee32
59fc59979a3d761cff5581931d2c8274
f9bb8d7e200194eb006a9d92e3486949, clafty, addressbooks, turba [pid 843 
on line 244 of "/var/www/html/horde/lib/Horde/Prefs/sql.php"]
Jul 15 11:30:55 HORDE [debug] [horde] SQL Query by 
SessionHandler_mysql::_read(): query = "SELECT session_data FROM 
horde_sessionhandler WHERE session_id = 'v54b54bguc8hs73su5d8guhet1' AND 
session_lastmodified > 1216134415 FOR UPDATE" [pid 843 on line 144 of 
"/var/www/html/horde/lib/Horde/SessionHandler/mysql.php"]
Jul 15 11:30:55 HORDE [debug] [turba] Hook _horde_hook_share_init in 
application horde not called. [pid 843 on line 1629 of 
"/var/www/html/horde/lib/Horde.php"]
Jul 15 11:30:55 HORDE [debug] [turba] Hook 
_prefs_change_hook_addressbooks in application horde not called. [pid 
843 on line 1629 of "/var/www/html/horde/lib/Horde.php"]
Jul 15 11:30:55 HORDE [debug] [turba] SQL Query by Prefs_sql::store(): 
SELECT 1 FROM horde_prefs WHERE pref_uid = ? AND pref_name = ? AND 
pref_scope = ?, values: clafty, addressbooks, turba [pid 843 on line 210 
of "/var/www/html/horde/lib/Horde/Prefs/sql.php"]
Jul 15 11:30:55 HORDE [debug] [turba] SQL Query by Prefs_sql::store(): 
UPDATE horde_prefs SET pref_value = ? WHERE pref_uid = ? AND pref_name = 
? AND pref_scope = ?, values:
65128dbf9ed75063f27852331d5b921e
b5d8670d511ef3c649d807f4303ee9b5
261c9a5ae34aeb5ab9082232f49006d8
afc6cf3e0ddfbadcf1f155b0921c83e8
4064b2fa72b31323702cda59ce813e91
3cbcfda1c20eef782c779f53626cf667
f0280123c2921c38c59870497952d007
7cd8b295125c7c6c1b9fa0ef105fab67
f88338d727961227df88febc185f6b83
fa9790be5addbd3bc6253b74ac3cdc20
14ef455cc89c5a2f644305f0cbe447db
031d2dd792e71f7fa335e8f8bd8bb364
1e8efa1cc365c8b0ea0e9254dfee4539
47496a6cc7668b4d6188251882d1b84a
e6d01e7a64367c31eed861a86113031f
7ac64253eeabd097e1a53b3a5f9897dc
aa00f880bbfd7dc0c1b1a7a29827bec5
82b08ef79c66c93ec39cb91af3ecd2f3
c76ff1164f0831742f18390852c37080
75661fab92dfae14b9d7c9fe3ae92011
9c4a8566cd92c8378d3693f882d97c90
82c6fd7e976f47b3b493b66662f7d425
13d2ceeca255deecf132e071e0649cef
04e6bd5a944a620d8b95af0ff07170bf
b53413b2a7101015fdefddf6ccbfcc66
9b51b1cbf06ff794b7adce1ccd66351e
25d2d9fabb0502f076a893c338574c80
39d501c06a2c126748f5b3bcfd703e02
6d4ae6d7d34440fa017c5452073767f0
9d544414d5708a043802833297e55224
2d6edecb0e0cd3a0b7e0ee34d266c78e
d114967c3e7addc52081b1f638638ff6
b38eec668b546c92bcb0976c0211bfc4
88bde760bd30c4bb38d70f1c5022e747
b741f56fdce416779dd4f21beb03f0d2
641e7da219046f77456f5c4560b62424
b8a12353e96e98ee09433a7ba36dee32
59fc59979a3d761cff5581931d2c8274
f9bb8d7e200194eb006a9d92e3486949
9e1605cd5066bb5e61a6ada9c8802a86, clafty, addressbooks, turba [pid 843 
on line 244 of "/var/www/html/horde/lib/Horde/Prefs/sql.php"]

Some of our users have localldap and localsql in their addressbooks 
horde_prefs.  Others are blank.. I tried putting localsql and localldap 
manually in my horde_prefs, but no luck.  I have a feeling that this 
setting has to do with viewing individual user entries in my address 
book.  I can revert back to turba 2.1.4 and it works perfectly.  Also, 
if I try to add columns to my browse view, the settings never stick even 
though it reports they are being saved.  Let me know if you need any 
other info.

-Chris Lafty

-- 


---------------------------------------
Christopher Lafty
Systems Administrator - Windows and Linux
132 Madill Hall
St. Lawrence University
clafty at stlawu.edu

Telephone: 315-229-5953
Fax: 315-229-5539
---------------------------------------



More information about the turba mailing list