[imp] login very slow after horde upgrade from 3.0.10 to 3.1+

Nick Salonen whatdoyouwant at gmail.com
Fri May 12 14:51:00 PDT 2006


Hi,
I haven't been able to figure out why login is so slow after upgrading horde
to 3.1+ from 3.0.10 .

There's a huge time difference when logging in between these two versions.
I use ldap authentication and imp uses hordeauth.
It doesn't matter what version of imp I use..
Any insight?

here are the pear debug logs from horde 3.1.1:

May 12 16:40:48 HORDED [notice] [horde] Login success for testguy
[ip-omitted] to Horde [on line 90 of "/path/to/horde/login.php"]
May 12 16:40:48 HORDED [debug] [] SQL Query by Prefs_sql::retrieve(): SELECT
pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = ? AND
(pref_scope = ? OR pref_scope = 'horde') ORDER BY pref_scope [on line 132 of
"/path/to/horde/lib/Horde/Prefs/sql.php"]
May 12 16:40:48 HORDED [debug] [] SQL Query by Prefs_sql::retrieve(): SELECT
pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = ? AND
(pref_scope = ? OR pref_scope = 'horde') ORDER BY pref_scope [on line 132 of
"/path/to/horde/lib/Horde/Prefs/sql.php"]
May 12 16:40:48 HORDED [debug] [horde] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = ?
AND (pref_scope = ? OR pref_scope = 'horde') ORDER BY pref_scope [on line
132 of "/path/to/horde/lib/Horde/Prefs/sql.php"]
May 12 16:40:52 HORDED [notice] [imp] Login success for testguy [ip-omitted]
to {imap.omitted:144} [on line 96 of "/path/to/horde/imp/lib/Auth/imp.php"]
May 12 16:40:52 HORDED [debug] [] SQL Query by Prefs_sql::retrieve(): SELECT
pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = ? AND
(pref_scope = ? OR pref_scope = 'horde') ORDER BY pref_scope [on line 132 of
"/path/to/horde/lib/Horde/Prefs/sql.php"]
May 12 16:40:52 HORDED [debug] [horde] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = ?
AND (pref_scope = ? OR pref_scope = 'horde') ORDER BY pref_scope [on line
132 of "/path/to/horde/lib/Horde/Prefs/sql.php"]
May 12 16:40:53 HORDED [debug] [horde] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = ?
AND (pref_scope = ? OR pref_scope = 'horde') ORDER BY pref_scope [on line
132 of "/path/to/horde/lib/Horde/Prefs/sql.php"]

It seems to me that some preferences are taking a long time to load or imp
loads slowly, but
if i go back to using 3.0.10, login is fast again, except I don't want to
revert versions as I'd really like to use newer versions of horde

thanks,
Nick


More information about the imp mailing list