[horde] {Disarmed} Re: User preference pages gone after Upgrade to Horde Webmail 5.2.10

Jan Schneider jan at horde.org
Thu Aug 27 10:09:40 UTC 2015


Zitat von Christian Bierwirth <chris at cb-solutions.de>:

> Am 26.08.2015 um 16:01 schrieb Michael J Rubinsky:
>>
>> Quoting Christian Bierwirth <chris at cb-solutions.de>:
>>
>>> Am 26.08.2015 um 15:39 schrieb Michael J Rubinsky:
>>>>
>>>> Quoting Christian Bierwirth <chris at cb-solutions.de>:
>>>>
>>>>> Hi Michael,
>>>>>
>>>>> Am 25.08.2015 um 17:40 schrieb Michael J Rubinsky:
>>>>>>
>>>>>> Quoting Christian Bierwirth <chris at cb-solutions.de>:
>>>>>>
>>>>>>> Hi all,
>>>>>>>
>>>>>>> I got a serious problem after the upgrade to the current horde  
>>>>>>> webmail edition 5.2.10:
>>>>>>>
>>>>>>> Any of my users cannot access the user preferences pages of  
>>>>>>> the single applications anymore. The only thing shown under  
>>>>>>> /horde/services/prefs.php?app=horde (etc) is the top-menu of  
>>>>>>> the pages, the rest stays simply blank. All entries in the  
>>>>>>> horde_prefs table are still there. Cannot find any hint in the  
>>>>>>> horde.log or the webserver's logfiles. Maybe I screwed it up  
>>>>>>> by updating? All the rest seems to work fine though.
>>>>>>>
>>>>>>> Also I couldn't find a way (or a document telling me how to do  
>>>>>>> this) to purge the Installation and reinstall Horde with pear  
>>>>>>> using a backup of the existing confs and database.
>>>>>>>
>>>>>>> Any help would be greatly appreciated.
>>>>>>>
>>>>>>> Thanks in advance
>>>>>>>
>>>>>>> Chris
>>>>>>>
>>>>>>> -- 
>>>>>>> Diese Nachricht wurde auf Viren und andere gefährliche Inhalte  
>>>>>>> untersucht
>>>>>>> und ist nach aktuellem Kenntnisstand virenfrei.
>>>>>>>
>>>>>>> cb-solutions Antispam/Antivirus Service
>>>>>>
>>>>>> Look in the webserver error log for errors. Also, you don't say  
>>>>>> what version you upgraded from.
>>>>>
>>>>> I Upgraded from Horde Webmail - I think 5.2.4 (can I get this  
>>>>> anywhere from the files of the backup I made before upgrading?  
>>>>> I'd then verify and post it here because I don't know exactly  
>>>>> ATM). Here comes an extract of the Webserver log, taken when  
>>>>> accessing the prefs pages
>>>>>
>>>>> [Wed Aug 26 08:51:50 2015] [error] [client 192.168.x.y] PHP  
>>>>> Warning:  Unexpected character in input:  '\x1f' (ASCII=31)  
>>>>> state=0 in /usr/share/php/Horde/Template.php(285) : eval()'d  
>>>>> code on line 2, referer: https://.../horde/services/portal/
>>>>> [Wed Aug 26 08:51:50 2015] [error] [client 192.168.x.y] PHP  
>>>>> Parse error:  syntax error, unexpected 'hp' (T_STRING) in  
>>>>> /usr/share/php/Horde/Template.php(285) : eval()'d code on line  
>>>>> 2, referer: https://.../horde/services/portal/
>>>>> [Wed Aug 26 08:51:50 2015] [error] [client 192.168.x.y] PHP  
>>>>> Warning:  Unexpected character in input:  '\b' (ASCII=8) state=0  
>>>>> in /usr/share/php/Horde/Template.php(285) : eval()'d code on  
>>>>> line 1, referer: https://.../horde/services/portal/
>>>>> [Wed Aug 26 08:51:50 2015] [error] [client 192.168.x.y] PHP  
>>>>> Parse error:  syntax error, unexpected 'scalars' (T_STRING),  
>>>>> expecting ',' or ')' in /usr/share/php/Horde/Template.php(285) :  
>>>>> eval()'d code on line 1, referer:  
>>>>> https://.../horde/services/portal/
>>>>
>>>> Looks like some of your templates might have gotten corrupt  
>>>> somehow. If you can get a stack trace of the call you should be  
>>>> able to figure out which one.
>>>
>>> How can I get the stack trace and where can I get the default  
>>> templates to overwrite the corrupt ones? Is there any debug mode  
>>> in Horde like e.g. in Joomla or can i get that form the horde.log?
>>
>> You can set logging level to DEBUG via the Horde configuration in  
>> the administrative interface.
>>
>>
>>
>>
> Done that already and didn't find any hint there. Repeated it and  
> here is the debug-log, writte while accessing the userpref-page for  
> horde (horde/services/prefs.php?app=horde):
>
> 2015-08-26T14:15:15+00:00 DEBUG: HORDE Load config file (conf.php;  
> app: horde) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T14:15:15+00:00 DEBUG: HORDE [horde] Load config file  
> (nls.php; app: horde) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T14:15:15+00:00 DEBUG: HORDE [horde] Load config file  
> (prefs.php; app: horde) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T14:15:15+00:00 DEBUG: HORDE [gollem] Load config file  
> (conf.php; app: gollem) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T14:15:15+00:00 DEBUG: HORDE [imp] Load config file  
> (conf.php; app: imp) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T14:15:15+00:00 DEBUG: HORDE [imp] Load config file  
> (hooks.php; app: imp) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T14:15:15+00:00 DEBUG: HORDE [ingo] Load config file  
> (conf.php; app: ingo) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T14:15:15+00:00 DEBUG: HORDE [kronolith] Load config file  
> (conf.php; app: kronolith) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] Load config file  
> (conf.php; app: nag) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0002s)
>         SELECT * FROM nag_sharesng_users WHERE user_uid = '<USERNAME>' AND
>           (perm_2 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, hor
> de_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT DISTINCT * FROM nag_sharesng s WHERE (share_owner =
>           '<USERNAME>' OR perm_creator_2 = 1 OR perm_default_2 = 1) ORDER BY
>           attribute_name ASC [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng WHERE share_owner IS NULL [pid  
> 23621 on line 238 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng WHERE share_name =
>           'Yc16C4PyRyZOlo9ayMTj4QA' [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng_users WHERE user_uid = '<USERNAME>' AND
>           (perm_2 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, horde_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT DISTINCT * FROM nag_sharesng s WHERE (share_owner =
>           '<USERNAME>' OR perm_creator_2 = 1 OR perm_default_2 = 1) AND
>           share_owner = '<USERNAME>' ORDER BY attribute_name ASC  
> [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng WHERE share_owner IS NULL [pid  
> 23621 on line 238 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] Horde_Prefs: Storing  
> preference value (display_tasklists) [pid 23621 on line 990 of  
> "/var/www-ssl/horde/nag/lib/Nag.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng WHERE share_owner IS NULL [pid  
> 23621 on line 238 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng_users WHERE user_uid = '<USERNAME>' AND
>           (perm_2 = 1 OR perm_4 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, horde_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT DISTINCT * FROM nag_sharesng s WHERE (share_owner =
>           '<USERNAME>' OR perm_creator_2 = 1 OR perm_creator_4 = 1 OR
>           perm_default_2 = 1 OR perm_default_4 = 1) ORDER BY  
> attribute_name ASC [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:15+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng WHERE share_owner IS NULL [pid  
> 23621 on line 238 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [kronolith] Horde_Prefs:  
> Storing preference value (display_external_cals) [pid 23621 on line  
> 532 of "/var/www-ssl/horde/kronolith/lib/CalendarsManager.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [kronolith] SQL  (0,0001s)
>         SELECT * FROM kronolith_sharesng_users WHERE user_uid = '<USERNAME>'
>           AND (perm_2 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [kronolith] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, horde_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [kronolith] SQL  (0,0001s)
>         SELECT DISTINCT * FROM kronolith_sharesng s WHERE share_owner =
>           '<USERNAME>' OR perm_creator_2 = 1 OR perm_default_2 = 1 ORDER BY
>           attribute_name ASC [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [kronolith] SQL  (0,0001s)
>         SELECT * FROM kronolith_sharesng_users WHERE user_uid = '<USERNAME>'
>           AND (perm_2 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [kronolith] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, horde_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [kronolith] SQL  (0,0001s)
>         SELECT DISTINCT * FROM kronolith_sharesng s WHERE (share_owner =
>           '<USERNAME>' OR perm_creator_2 = 1 OR perm_default_2 = 1) AND
>           share_owner = '<USERNAME>' ORDER BY attribute_name ASC  
> [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [turba] Load config file  
> (conf.php; app: turba) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [turba] Load config file  
> (attributes.php; app: turba) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [turba] Load config file  
> (backends.php; app: turba) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [turba] SQL  (0,0001s)
>         SELECT * FROM turba_sharesng_users WHERE user_uid = '<USERNAME>' AND
>           (perm_4 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [turba] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, horde_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [turba] SQL  (0,0001s)
>         SELECT DISTINCT * FROM turba_sharesng s WHERE share_owner =
>           '<USERNAME>' OR perm_creator_4 = 1 OR perm_default_4 = 1 ORDER BY
>           share_id ASC [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng_users WHERE user_uid = '<USERNAME>' AND
>           (perm_2 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, horde_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT DISTINCT * FROM nag_sharesng s WHERE (share_owner =
>           '<USERNAME>' OR perm_creator_2 = 1 OR perm_default_2 = 1) AND
>           attribute_issmart = 0 ORDER BY attribute_name ASC [pid  
> 23621 on line 238 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [nag] SQL  (0,0001s)
>         SELECT * FROM nag_sharesng WHERE share_owner IS NULL [pid  
> 23621 on line 238 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [mnemo] Load config file  
> (conf.php; app: mnemo) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [mnemo] SQL  (0,0001s)
>         SELECT * FROM mnemo_sharesng_users WHERE user_uid = '<USERNAME>' AND
>           (perm_2 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [mnemo] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, horde_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [mnemo] SQL  (0,0001s)
>         SELECT DISTINCT * FROM mnemo_sharesng s WHERE share_owner =
>           '<USERNAME>' OR perm_creator_2 = 1 OR perm_default_2 = 1 ORDER BY
>           attribute_name ASC [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [mnemo] SQL  (0,0001s)
>         SELECT * FROM mnemo_sharesng_users WHERE user_uid = '<USERNAME>' AND
>           (perm_2 = 1) [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [mnemo] SQL  (0,0001s)
>         SELECT g.group_uid AS group_uid, g.group_name AS group_name FROM
>           horde_groups g, horde_groups_members m WHERE m.user_uid =
>           '<USERNAME>' AND g.group_uid = m.group_uid ORDER BY  
> g.group_name [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [mnemo] SQL  (0,0001s)
>         SELECT DISTINCT * FROM mnemo_sharesng s WHERE (share_owner =
>           '<USERNAME>' OR perm_creator_2 = 1 OR perm_default_2 = 1) AND
>           share_owner = '<USERNAME>' ORDER BY attribute_name ASC  
> [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [mnemo] Horde_Prefs: Storing  
> preference value (display_notepads) [pid 23621 on line 521 of  
> "/var/www-ssl/horde/mnemo/lib/Mnemo.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [trean] Load config file  
> (conf.php; app: trean) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [trean] SQL  (0,0001s)
>         SELECT user_id, user_name FROM `rampage_users` WHERE user_name IN
>           ('<USERNAME>') [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [wicked] Load config file  
> (conf.php; app: wicked) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [passwd] Load config file  
> (conf.php; app: passwd) [pid 23621 on line 109 of  
> "/usr/share/php/Horde/Registry/Loadconfig.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [horde] SQL  (0,0006s)
>         SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,
>           alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal
>           FROM horde_alarms WHERE alarm_dismissed = 0 AND  
> ((alarm_snooze IS NULL
>           AND alarm_start <= '2015-08-26 14:15:16') OR alarm_snooze <=
>           '2015-08-26 14:15:16') AND (alarm_end IS NULL OR alarm_end >=
>           '2015-08-26 14:15:16') AND (alarm_uid IS NULL OR alarm_uid = '' OR
>           alarm_uid = '<USERNAME>') ORDER BY alarm_start, alarm_end  
> [pid 23621 on line 238 of  
> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
> 2015-08-26T16:15:16+02:00 DEBUG: HORDE [horde] Max memory usage:  
> 17039360 bytes [pid 23621 on line 609 of  
> "/usr/share/php/Horde/Registry.php"]
>
> Any hint which template could go wrong here?

You can try installing xdebug and get a backtrace from there.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/



More information about the horde mailing list