6.0.0-git
2019-04-21

[#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 2013-07-25 (2096 days ago)
Due
Updated 2013-07-25 (2096 days ago)
Assigned
Resolved 2013-07-25 (2096 days ago)
Milestone
Patch No

History
2013-07-25 21:34:22 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().
2013-07-25 20:20:00 michael (at) johalla (dot) de Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
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