6.0.0-beta1
7/7/25

[#12504] Upper case login name with active sync causes issues in trean
Summary Upper case login name with active sync causes issues in trean
Queue Components
Type Bug
State Not A Bug
Priority 1. Low
Owners
Requester michael (at) johalla (dot) de
Created 07/25/2013 (4365 days ago)
Due
Updated 07/25/2013 (4365 days ago)
Assigned
Resolved 07/25/2013 (4365 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
07/25/2013 09:34:22 PM Michael Rubinsky Comment #2
State ⇒ Not A Bug
Priority ⇒ 1. Low
Reply to this comment
This has nothing to do with AcitveSync or Trean. Your authentication 
backend (imap) is not case sensitive but the storage backend is. You 
should create an authUsername hook.

See horde/config/hooks.php authUsernameHook().
07/25/2013 08:20:00 PM michael (at) johalla (dot) de Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Upper case login name with active sync causes issues in trean
Queue ⇒ Components
Milestone ⇒
Patch ⇒ No
Reply to this comment
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

Saved Queries