[horde] SPAM-UTM Re: One user is unable to login to Horde/IMP.

Mon Jan 20 05:49:53 UTC 2014

  ----- Message from Ralf Lang <lang at b1-systems.de> ---------
   Date: Fri, 17 Jan 2014 14:07:09 +0100
   From: Ralf Lang <lang at b1-systems.de>
Subject: ***SPAM-UTM*** Re: [horde] One user is unable to login to
Horde/IMP.
     To: Horde List <horde at lists.horde.org>

> Your database seems inconsistent. Maybe you have a case insensitive user
> backend and your user has once logged in with uppercase characters. Or
> you have a data schema from pre-stable trean / content applications
>
> Suggestion:
>
> 1) backup your sql table (data only)
> mysqldump horde --skip-triggers --compact --no-create-info > hordedb.sql
>
> 2) stop user access to your horde instance
> 3) create a new clean database under a new name
> mysql > create database "horde5"; GRANT ALL on horde5.* to ...
> 4) edit horde config to use the new db
> 5) run horde-db-migrate
> 6) replay content of the tables from the old db into the new schema.
> Either use your hordedb.sql dump
>
> mysql -uFOO -pFOO -dhorde5 < hordedb.sql
>
> or use select statements to transfer table content from old db to new db.
>
> Watch out for errors and warnings. these may indicate invalid legacy
data.
>
> On 17.01.2014 11:08, ANANT S ATHAVALE wrote:
>> Dear List,
>>
>> One of our users is unable to login to Horde/IMP and logs contain the
>> following details.  Please suggest, how to resolve the issue.
>> horde-db-migrate had no errors when migrated.
>>
>> Just replaced the actual username with 'xxx'.
>>
>> Jan 17 2014 13:51:31 ERR: HORDE [trean] exception 'Horde_Db_Exception'
>> with
>> message 'QUERY FAILED: Duplicate entry 'xxx at isac.gov.in' for key
>> 'rampage_users_user_name'
>>
>> INSERT INTO `rampage_users` (user_name) VALUES ('xxx at isac.gov.in')' in
>> /usr/share/pear/Horde/Db/Adapter/Mysqli.php:315
>> Stack trace:
>> #0 /usr/share/pear/Horde/Db/Adapter/Mysqli.php(340):
>> Horde_Db_Adapter_Mysqli->execute('INSERT INTO `ra...', NULL, NULL)
>> #1 /var/www/horde/content/lib/Users/Manager.php(75):
>> Horde_Db_Adapter_Mysqli->insert('INSERT INTO `ra...')
>> #2 /var/www/horde/trean/lib/Bookmarks.php(30):
>> Content_Users_Manager->ensureUsers('xxx at isac.gov...')
>> #3 [internal function]:
>> Trean_Bookmarks->__construct(Object(Content_Users_Manager))
>> #4 /usr/share/pear/Horde/Injector/Binder/Implementation.php(86):
>> ReflectionClass->newInstanceArgs(Array)
>> #5 /usr/share/pear/Horde/Injector/Binder/Implementation.php(66):
>>
Horde_Injector_Binder_Implementation->_getInstance(Object(Horde_Injector),
>> Object(ReflectionClass))
>> #6 /usr/share/pear/Horde/Injector/Binder/AnnotatedSetters.php(69):
>> Horde_Injector_Binder_Implementation->create(Object(Horde_Injector))
>> #7 /usr/share/pear/Horde/Injector.php(213):
>> Horde_Injector_Binder_AnnotatedSetters->create(Object(Horde_Injector))
>> #8 /usr/share/pear/Horde/Injector.php(247):
>> Horde_Injector->createInstance('Trean_Bookmarks')
>> #9 /var/www/horde/trean/lib/Application.php(65):
>> Horde_Injector->getInstance('Trean_Bookmarks')
>> #10 /usr/share/pear/Horde/Registry/Application.php(105):
>> Trean_Application->_init()
>> #11 [internal function]: Horde_Registry_Application->init()
>> #12 /usr/share/pear/Horde/Registry.php(1213):
call_user_func_array(Array,
>> Array)
>> #13 /usr/share/pear/Horde/Registry.php(1601):
>> Horde_Registry->callAppMethod('trean', 'init')
>> #14 /usr/share/pear/Horde/Registry.php(1961):
>> Horde_Registry->pushApp('trean')
>> #15 /usr/share/pear/Horde/Core/Block/Collection.php(43):
>> Horde_Registry->getAppDrivers('trean', 'Block')
>> #16 /usr/share/pear/Horde/Core/Factory/BlockCollection.php(61):
>> Horde_Core_Block_Collection->__construct(Array, 'portal_layout')
>> #17 /var/www/horde/services/portal/index.php(31):
>> Horde_Core_Factory_BlockCollection->create()
>> #18 {main}
>>
>> Next exception 'Content_Exception' with message 'QUERY FAILED: Duplicate
>> entry 'xxx at isac.gov.in' for key 'rampage_users_user_name'
>>
>> INSERT INTO `rampage_users` (user_name) VALUES ('xxx at isac.gov.in')' in
>> /var/www/horde/content/lib/Users/Manager.php:78
>> Stack trace:
>> #0 /var/www/horde/trean/lib/Bookmarks.php(30):
>> Content_Users_Manager->ensureUsers('xxx at isac.gov...')
>> #1 [internal function]:
>> Trean_Bookmarks->__construct(Object(Content_Users_Manager))
>> #2 /usr/share/pear/Horde/Injector/Binder/Implementation.php(86):
>> ReflectionClass->newInstanceArgs(Array)
>> #3 /usr/share/pear/Horde/Injector/Binder/Implementation.php(66):
>>
Horde_Injector_Binder_Implementation->_getInstance(Object(Horde_Injector),
>> Object(ReflectionClass))
>> #4 /usr/share/pear/Horde/Injector/Binder/AnnotatedSetters.php(69):
>> Horde_Injector_Binder_Implementation->create(Object(Horde_Injector))
>> #5 /usr/share/pear/Horde/Injector.php(213):
>> Horde_Injector_Binder_AnnotatedSetters->create(Object(Horde_Injector))
>> #6 /usr/share/pear/Horde/Injector.php(247):
>> Horde_Injector->createInstance('Trean_Bookmarks')
>> #7 /var/www/horde/trean/lib/Application.php(65):
>> Horde_Injector->getInstance('Trean_Bookmarks')
>> #8 /usr/share/pear/Horde/Registry/Application.php(105):
>> Trean_Application->_init()
>> #9 [internal function]: Horde_Registry_Application->init()
>> #10 /usr/share/pear/Horde/Registry.php(1213):
call_user_func_array(Array,
>> Array)
>> #11 /usr/share/pear/Horde/Registry.php(1601):
>> Horde_Registry->callAppMethod('trean', 'init')
>> #12 /usr/share/pear/Horde/Registry.php(1961):
>> Horde_Registry->pushApp('trean')
>> #13 /usr/share/pear/Horde/Core/Block/Collection.php(43):
>> Horde_Registry->getAppDrivers('trean', 'Block')
>> #14 /usr/share/pear/Horde/Core/Factory/BlockCollection.php(61):
>> Horde_Core_Block_Collection->__construct(Array, 'portal_layout')
>> #15 /var/www/horde/services/portal/index.php(31):
>> Horde_Core_Factory_BlockCollection->create()
>> #16 {main} [pid 27706 on line 32 of
>> "/var/www/horde/trean/lib/Bookmarks.php"]
>> Jan 17 2014 13:51:31 ERR: HORDE [turba] No decode handler. [pid 32189 on
>> line 61 of "/var/www/horde/turba/config/hooks.local.php"]
>> Jan 17 2014 13:51:31 EMERG: HORDE [horde] exception 'Horde_Db_Exception'
>> with message 'QUERY FAILED: Duplicate entry 'xxx at isac.gov.in' for key
>> 'rampage_users_user_name'
>>
>> INSERT INTO `rampage_users` (user_name) VALUES ('xxx at isac.gov.in')' in
>> /usr/share/pear/Horde/Db/Adapter/Mysqli.php:315
>> Stack trace:
>> #0 /usr/share/pear/Horde/Db/Adapter/Mysqli.php(340):
>> Horde_Db_Adapter_Mysqli->execute('INSERT INTO `ra...', NULL, NULL)
>> #1 /var/www/horde/content/lib/Users/Manager.php(75):
>> Horde_Db_Adapter_Mysqli->insert('INSERT INTO `ra...')
>> #2 /var/www/horde/trean/lib/Bookmarks.php(30):
>> Content_Users_Manager->ensureUsers('xxx at isac.gov...')
>> #3 [internal function]:
>> Trean_Bookmarks->__construct(Object(Content_Users_Manager))
>> #4 /usr/share/pear/Horde/Injector/Binder/Implementation.php(86):
>> ReflectionClass->newInstanceArgs(Array)
>> #5 /usr/share/pear/Horde/Injector/Binder/Implementation.php(66):
>>
Horde_Injector_Binder_Implementation->_getInstance(Object(Horde_Injector),
>> Object(ReflectionClass))
>> #6 /usr/share/pear/Horde/Injector/Binder/AnnotatedSetters.php(69):
>> Horde_Injector_Binder_Implementation->create(Object(Horde_Injector))
>> #7 /usr/share/pear/Horde/Injector.php(213):
>> Horde_Injector_Binder_AnnotatedSetters->create(Object(Horde_Injector))
>> #8 /usr/share/pear/Horde/Injector.php(247):
>> Horde_Injector->createInstance('Trean_Bookmarks')
>> #9 /var/www/horde/trean/lib/Application.php(65):
>> Horde_Injector->getInstance('Trean_Bookmarks')
>> #10 /usr/share/pear/Horde/Registry/Application.php(105):
>> Trean_Application->_init()
>> #11 [internal function]: Horde_Registry_Application->init()
>> #12 /usr/share/pear/Horde/Registry.php(1213):
call_user_func_array(Array,
>> Array)
>> #13 /usr/share/pear/Horde/Registry.php(1601):
>> Horde_Registry->callAppMethod('trean', 'init')
>> #14 /usr/share/pear/Horde/Registry.php(1961):
>> Horde_Registry->pushApp('trean')
>> #15 /usr/share/pear/Horde/Core/Block/Collection.php(43):
>> Horde_Registry->getAppDrivers('trean', 'Block')
>> #16 /usr/share/pear/Horde/Core/Factory/BlockCollection.php(61):
>> Horde_Core_Block_Collection->__construct(Array, 'portal_layout')
>> #17 /var/www/horde/services/portal/index.php(31):
>> Horde_Core_Factory_BlockCollection->create()
>> #18 {main}
>>
>> Next exception 'Content_Exception' with message 'QUERY FAILED: Duplicate
>> entry 'xxx at isac.gov.in' for key 'rampage_users_user_name'
>>
>> INSERT INTO `rampage_users` (user_name) VALUES ('xxx at isac.gov.in')' in
>> /var/www/horde/content/lib/Users/Manager.php:78
>> Stack trace:
>> #0 /var/www/horde/trean/lib/Bookmarks.php(30):
>> Content_Users_Manager->ensureUsers('xxx at isac.gov...')
>> #1 [internal function]:
>> Trean_Bookmarks->__construct(Object(Content_Users_Manager))
>> #2 /usr/share/pear/Horde/Injector/Binder/Implementation.php(86):
>> ReflectionClass->newInstanceArgs(Array)
>> #3 /usr/share/pear/Horde/Injector/Binder/Implementation.php(66):
>>
Horde_Injector_Binder_Implementation->_getInstance(Object(Horde_Injector),
>> Object(ReflectionClass))
>> #4 /usr/share/pear/Horde/Injector/Binder/AnnotatedSetters.php(69):
>> Horde_Injector_Binder_Implementation->create(Object(Horde_Injector))
>> #5 /usr/share/pear/Horde/Injector.php(213):
>> Horde_Injector_Binder_AnnotatedSetters->create(Object(Horde_Injector))
>> #6 /usr/share/pear/Horde/Injector.php(247):
>> Horde_Injector->createInstance('Trean_Bookmarks')
>> #7 /var/www/horde/trean/lib/Application.php(65):
>> Horde_Injector->getInstance('Trean_Bookmarks')
>> #8 /usr/share/pear/Horde/Registry/Application.php(105):
>> Trean_Application->_init()
>> #9 [internal function]: Horde_Registry_Application->init()
>> #10 /usr/share/pear/Horde/Registry.php(1213):
call_user_func_array(Array,
>> Array)
>> #11 /usr/share/pear/Horde/Registry.php(1601):
>> Horde_Registry->callAppMethod('trean', 'init')
>> #12 /usr/share/pear/Horde/Registry.php(1961):
>> Horde_Registry->pushApp('trean')
>> #13 /usr/share/pear/Horde/Core/Block/Collection.php(43):
>> Horde_Registry->getAppDrivers('trean', 'Block')
>> #14 /usr/share/pear/Horde/Core/Factory/BlockCollection.php(61):
>> Horde_Core_Block_Collection->__construct(Array, 'portal_layout')
>> #15 /var/www/horde/services/portal/index.php(31):
>> Horde_Core_Factory_BlockCollection->create()
>> #16 {main} [pid 27706 on line 1645 of
>> "/usr/share/pear/Horde/Registry.php"]
>
> --
> Ralf Lang
> Linux Consultant / Developer
> Tel.: +49-170-6381563
> Mail: lang at b1-systems.de
> B1 Systems GmbH
> Osterfeldstraße 7 / 85088 Vohburg / http://www.b1-systems.deGF: Ralph
> Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537

----- End message from Ralf Lang <lang at b1-systems.de> -----

Thank you for your suggestion.  I could solve the problem by updating the
rampage_users table user_name value from Upper case to lowercase for that
specific user.
-- 
           Regards
            Anant
------------------------------------------------------------------------------
Confidentiality Notice: This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
------------------------------------------------------------------------------

[horde] ***SPAM-UTM*** Re: One user is unable to login to Horde/IMP.

[horde] SPAM-UTM Re: One user is unable to login to Horde/IMP.