[horde] One user is unable to login to Horde/IMP.

Fri Jan 17 13:07:09 UTC 2014

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.de
GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 263 bytes
Desc: OpenPGP digital signature
URL: <http://lists.horde.org/archives/horde/attachments/20140117/e2b8b070/attachment.bin>