[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