[horde] {Disarmed} Re: User preference pages gone after Upgrade to Horde Webmail 5.2.10
Christian Bierwirth
chris at cb-solutions.de
Wed Aug 26 16:10:02 UTC 2015
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?
Thanks again
Chris
--
Diese Nachricht wurde auf Viren und andere gefährliche Inhalte untersucht
und ist nach aktuellem Kenntnisstand virenfrei.
cb-solutions Antispam/Antivirus Service
More information about the horde
mailing list