6.0.0-RC7
6/30/26

[#9963] customsql auth driver lists no users
Summary customsql auth driver lists no users
Queue Horde Framework Packages
Queue Version Git master
Type Bug
State Resolved
Priority 1. Low
Owners jan (at) horde (dot) org
Requester michael (at) bigmichi1 (dot) de
Created 4/24/11 (5546 days ago)
Due
Updated 4/27/11 (5543 days ago)
Assigned 4/27/11 (5543 days ago)
Resolved 4/27/11 (5543 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
454 Jan Schneider State ⇒ Resolved
 
553 michael (at) bigmichi1 (dot) de Comment #4 Reply to this comment
that fix works for listing the users, thx
312 Jan Schneider Comment #3
Assigned to Jan Schneider
State ⇒ Feedback
Reply to this comment
Try this?
5112 Git Commit Comment #2 Reply to this comment
Changes have been made in Git for this ticket:

Simplify/fix returning user column (Bug #9963).

  2 files changed, 2 insertions(+), 10 deletions(-)
http://git.horde.org/horde-git/-/commit/222d61eee590bf35a976d10990e8bedd43d86745
2612 michael (at) bigmichi1 (dot) de Comment #1
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ customsql auth driver lists no users
Queue ⇒ Horde Framework Packages
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
when i use the customsql auth driver with these query for listing users

SELECT username FROM mailbox WHERE domain = SUBSTRING_INDEX(\L, '@', 
-1)  AND active = 1

i got these message in the log file

2011-04-24T14:06:43+02:00 NOTICE: HORDE [horde] PHP ERROR: Undefined 
offset: 0 [pid 7026 on line 242 of 
"/var/www/pear/php/Horde/Auth/Customsql.php"]

and no users are listed with the name in horde, only the entries are 
there but with no name

Saved Queries