6.0.0-beta1
7/3/25

[#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 04/24/2011 (5184 days ago)
Due
Updated 04/27/2011 (5181 days ago)
Assigned 04/27/2011 (5181 days ago)
Resolved 04/27/2011 (5181 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
04/27/2011 04:09:45 PM Jan Schneider State ⇒ Resolved
 
04/27/2011 03:56:55 PM michael (at) bigmichi1 (dot) de Comment #4 Reply to this comment
that fix works for listing the users, thx
04/27/2011 12:32:03 PM Jan Schneider Comment #3
Assigned to Jan Schneider
State ⇒ Feedback
Reply to this comment
Try this?
04/27/2011 12:31:51 PM 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
04/24/2011 12:16:26 PM 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