[horde] login caseinsensitiv, database error

Anton Köstlbacher horde3 at dingsbums.org
Mon Nov 18 12:15:01 UTC 2013 

Am 16.11.2013 19:09, schrieb Anton Köstlbacher:
> Hi all,
>
> one of my clients just ran into a problem, resulting in the error
> message you find below. I can successfully reproduce the problem:
>
> 1) I created an account on the imap-server (horde authentication via
> imp, imap server is dovecot), for example: "abc at domain.tld"
>
> 2) Then try to login as "Abc at domain.tld"
>
> 3) Results in an existing session, you can change to imp, but for portal
> view horde gives an error message. See below.
>
> Horde Webmail is 5.1.3. Is there a configuration option for
> casesensitivity of horde usernames or is dovecot configured wrong or am
> I doing something else wrong?
>
> Thanks for your help!
>
> Best regards,
> Anton


Sorry, forgot the error message:

exception 'PDOException' with message 'SQLSTATE[23000]: Integrity 
constraint violation: 1062 Duplicate entry 'Abc at domain.tld' for key 
'rampage_users_user_name'' in 
/usr/share/php/Horde/Db/Adapter/Base.php:551 Stack trace: #0 
/usr/share/php/Horde/Db/Adapter/Base.php(551): PDO->query('INSERT INTO 
`ra...') #1 /usr/share/php/Horde/Db/Adapter/Base.php(584): 
Horde_Db_Adapter_Base->execute('INSERT INTO `ra...', NULL, NULL) #2 
/var/www/apache/web/hosting.tld/webmail/content/lib/Users/Manager.php(75): 
Horde_Db_Adapter_Base->insert('INSERT INTO `ra...') #3 
/var/www/apache/web/hosting.tld/webmail/trean/lib/Bookmarks.php(30): 
Content_Users_Manager->ensureUsers('Abc at domai...') #4 [internal 
function]: Trean_Bookmarks->__construct(Object(Content_Users_Manager)) 
#5 /usr/share/php/Horde/Injector/Binder/Implementation.php(86): 
ReflectionClass->newInstanceArgs(Array) #6 
/usr/share/php/Horde/Injector/Binder/Implementation.php(66): 
Horde_Injector_Binder_Implementation->_getInstance(Object(Horde_Injector), 
Object(ReflectionClass)) #7 
/usr/share/php/Horde/Injector/Binder/AnnotatedSetters.php(69): 
Horde_Injector_Binder_Implementation->create(Object(Horde_Injector)) #8 
/usr/share/php/Horde/Injector.php(213): 
Horde_Injector_Binder_AnnotatedSetters->create(Object(Horde_Injector)) 
#9 /usr/share/php/Horde/Injector.php(247): 
Horde_Injector->createInstance('Trean_Bookmarks') #10 
/var/www/apache/web/hosting.tld/webmail/trean/lib/Application.php(65): 
Horde_Injector->getInstance('Trean_Bookmarks') #11 
/usr/share/php/Horde/Registry/Application.php(105): 
Trean_Application->_init() #12 [internal function]: 
Horde_Registry_Application->init() #13 
/usr/share/php/Horde/Registry.php(1213): call_user_func_array(Array, 
Array) #14 /usr/share/php/Horde/Registry.php(1601): 
Horde_Registry->callAppMethod('trean', 'init') #15 
/usr/share/php/Horde/Registry.php(1961): 
Horde_Registry->pushApp('trean') #16 
/usr/share/php/Horde/Core/Block/Collection.php(43): 
Horde_Registry->getAppDrivers('trean', 'Block') #17 
/usr/share/php/Horde/Core/Factory/BlockCollection.php(61): 
Horde_Core_Block_Collection->__construct(Array, 'portal_layout') #18 
/var/www/apache/web/hosting.tld/webmail/services/portal/index.php(31): 
Horde_Core_Factory_BlockCollection->create() #19 {main} Next exception 
'Horde_Db_Exception' with message 'SQLSTATE[23000]: Integrity constraint 
violation: 1062 Duplicate entry 'Abc at domain.tld' for key 
'rampage_users_user_name'' in 
/usr/share/php/Horde/Db/Adapter/Base.php:555 Stack trace: #0 
/usr/share/php/Horde/Db/Adapter/Base.php(584): 
Horde_Db_Adapter_Base->execute('INSERT INTO `ra...', NULL, NULL) #1 
/var/www/apache/web/hosting.tld/webmail/content/lib/Users/Manager.php(75): 
Horde_Db_Adapter_Base->insert('INSERT INTO `ra...') #2 
/var/www/apache/web/hosting.tld/webmail/trean/lib/Bookmarks.php(30): 
Content_Users_Manager->ensureUsers('Abc at domai...') #3 [internal 
function]: Trean_Bookmarks->__construct(Object(Content_Users_Manager)) 
#4 /usr/share/php/Horde/Injector/Binder/Implementation.php(86): 
ReflectionClass->newInstanceArgs(Array) #5 
/usr/share/php/Horde/Injector/Binder/Implementation.php(66): 
Horde_Injector_Binder_Implementation->_getInstance(Object(Horde_Injector), 
Object(ReflectionClass)) #6 
/usr/share/php/Horde/Injector/Binder/AnnotatedSetters.php(69): 
Horde_Injector_Binder_Implementation->create(Object(Horde_Injector)) #7 
/usr/share/php/Horde/Injector.php(213): 
Horde_Injector_Binder_AnnotatedSetters->create(Object(Horde_Injector)) 
#8 /usr/share/php/Horde/Injector.php(247): 
Horde_Injector->createInstance('Trean_Bookmarks') #9 
/var/www/apache/web/hosting.tld/webmail/trean/lib/Application.php(65): 
Horde_Injector->getInstance('Trean_Bookmarks') #10 
/usr/share/php/Horde/Registry/Application.php(105): 
Trean_Application->_init() #11 [internal function]: 
Horde_Registry_Application->init() #12 
/usr/share/php/Horde/Registry.php(1213): call_user_func_array(Array, 
Array) #13 /usr/share/php/Horde/Registry.php(1601): 
Horde_Registry->callAppMethod('trean', 'init') #14 
/usr/share/php/Horde/Registry.php(1961): 
Horde_Registry->pushApp('trean') #15 
/usr/share/php/Horde/Core/Block/Collection.php(43): 
Horde_Registry->getAppDrivers('trean', 'Block') #16 
/usr/share/php/Horde/Core/Factory/BlockCollection.php(61): 
Horde_Core_Block_Collection->__construct(Array, 'portal_layout') #17 
/var/www/apache/web/hosting.tld/webmail/services/portal/index.php(31): 
Horde_Core_Factory_BlockCollection->create() #18 {main} Next exception 
'Content_Exception' with message 'SQLSTATE[23000]: Integrity constraint 
violation: 1062 Duplicate entry 'Abc at domain.tld' for key 
'rampage_users_user_name'' in 
/var/www/apache/web/hosting.tld/webmail/content/lib/Users/Manager.php:78 
Stack trace: #0 
/var/www/apache/web/hosting.tld/webmail/trean/lib/Bookmarks.php(30): 
Content_Users_Manager->ensureUsers('Abc at domai...') #1 [internal 
function]: Trean_Bookmarks->__construct(Object(Content_Users_Manager)) 
#2 /usr/share/php/Horde/Injector/Binder/Implementation.php(86): 
ReflectionClass->newInstanceArgs(Array) #3 
/usr/share/php/Horde/Injector/Binder/Implementation.php(66): 
Horde_Injector_Binder_Implementation->_getInstance(Object(Horde_Injector), 
Object(ReflectionClass)) #4 
/usr/share/php/Horde/Injector/Binder/AnnotatedSetters.php(69): 
Horde_Injector_Binder_Implementation->create(Object(Horde_Injector)) #5 
/usr/share/php/Horde/Injector.php(213): 
Horde_Injector_Binder_AnnotatedSetters->create(Object(Horde_Injector)) 
#6 /usr/share/php/Horde/Injector.php(247): 
Horde_Injector->createInstance('Trean_Bookmarks') #7 
/var/www/apache/web/hosting.tld/webmail/trean/lib/Application.php(65): 
Horde_Injector->getInstance('Trean_Bookmarks') #8 
/usr/share/php/Horde/Registry/Application.php(105): 
Trean_Application->_init() #9 [internal function]: 
Horde_Registry_Application->init() #10 
/usr/share/php/Horde/Registry.php(1213): call_user_func_array(Array, 
Array) #11 /usr/share/php/Horde/Registry.php(1601): 
Horde_Registry->callAppMethod('trean', 'init') #12 
/usr/share/php/Horde/Registry.php(1961): 
Horde_Registry->pushApp('trean') #13 
/usr/share/php/Horde/Core/Block/Collection.php(43): 
Horde_Registry->getAppDrivers('trean', 'Block') #14 
/usr/share/php/Horde/Core/Factory/BlockCollection.php(61): 
Horde_Core_Block_Collection->__construct(Array, 'portal_layout') #15 
/var/www/apache/web/hosting.tld/webmail/services/portal/index.php(31): 
Horde_Core_Factory_BlockCollection->create() #16 {main}

More information about the horde mailing list