[Tickets #12504] Upper case login name with active sync causes issues in trean

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12504
------------------------------------------------------------------------------
  Ticket             | 12504
  Created By         | michael at johalla.de
  Summary            | Upper case login name with active sync causes issues
                     | in trean
  Queue              | Components
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


michael at johalla.de (2013-07-25 20:20) wrote:

Hi,

I'm using Horde 5.1.1 wich activesync, imapd for authentification and  
have also trean installed.

One of my user has entered his username with an uppercase first letter  
in the configuration of active sync on this mobile device. It seems to  
be that the authentifications via imapd is passing with the upper  
letter user name. But now at least the trean application has a problem  
because the user name is different to the one stored in the database  
but then trying to create a new user it fails:

HORDE: [trean] exception 'PDOException' with message 'SQLSTATE[23000]:  
Integrity constraint violation: 1062 Duplicate entry 'Adam' for key  
'rampage_users_user_name'' in  
/usr/share/php/Horde/Db/Adapter/Base.php:551#012Stack trace:#012#0  
/usr/share/php/Horde/Db/Adapter/Base.php(551): PDO->query('INSERT INTO  
`ra...')#012#1 /usr/share/php/Horde/Db/Adapter/Base.php(584):  
Horde_Db_Adapter_Base->execute('INSERT INTO `ra...', NULL, NULL)#012#2  
/var/www/ssl/content/lib/Users/Manager.php(75):  
Horde_Db_Adapter_Base->insert('INSERT INTO `ra...')#012#3  
/var/www/trean/lib/Bookmarks.php(30):  
Content_Users_Manager->ensureUsers('Adam')#012#4 [internal function]:  
Trean_Bookmarks->__construct(Object(Content_Users_Manager))#012#5  
/usr/share/php/Horde/Injector/Binder/Implementation.php(86):  
ReflectionClass->newInstanceArgs(Array)#012#6  
/usr/share/php/Horde/Injector/Binder/Implementation.php(66):  
horde_Injector_Binder_Implementation->_getInstance(Object(Horde_Injector),  
Object(ReflectionClass))#012#7  
/usr/share/php/Horde/Injector/Binder/AnnotatedSetters.php(69):  
Horde_Injector_Binder_Implementation->create(Object(Horde_Injector))#012#8  
/usr/share/php/Horde/Injector.php(213):  
Horde_Injector_Binder_AnnotatedSetters->create(Object(Horde_Injector))#012#9  
/usr/share/php/Horde/Injector.php(247):  
Horde_Injector->createInstance('Trean_Bookmarks')#012#10  
/var/www/ssl/trean/lib/Application.php(65):  
Horde_Injector->getInstance('Trean_Bookmarks')#012#11
/usr/share/php/Horde/Registry/Application.php(105):  
Trean_Application->_init()#012#12 [internal function]:  
Horde_Registry_Application->init()#012#13  
/usr/share/php/Horde/Registry.php(1174): call_user_func_array(Array,  
Array)#012#14 /usr/share/php/Horde/Registry.php(1561):  
Horde_Registry->callAppMethod('trean', 'init')#012#15  
/usr/share/php/Horde/Registry.php(1171):  
Horde_Registry->pushApp('trean', Array)#012#16  
/usr/share/php/Horde/Registry.php(2059):  
Horde_Registry->callAppMethod('trean', 'logout')#012#17  
/usr/share/php/Horde/Core/Active

Thanks,
Michael