[Tickets #8388] Re: Kronolith webdav user at xy.de gets userxy.de

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/8388
------------------------------------------------------------------------------
  Ticket             | 8388
  Updated By         | justheadaches at googlemail.com
  Summary            | Kronolith webdav user at xy.de gets userxy.de
  Queue              | Kronolith
  Version            | 2.3.1
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


justheadaches at googlemail.com (2009-07-20 11:54) wrote:

> What you write is very confusing. *How* did you set up  
> authentication in Horde?
Hello Jan thanks for your reply, im using virtual users in mysql

snip from horde/config/conf.php:
$conf['auth']['params']['query_auth'] = 'SELECT * FROM users WHERE  
email = \L AND password = ENCRYPT(\P,"aa")';
$conf['auth']['params']['query_add'] = 'INSERT INTO users (email,  
password, quota) VALUES (\L, ENCRYPT(\P,"aa"), 1048576000)';
$conf['auth']['params']['query_getpw'] = 'SELECT password FROM users  
WHERE email = \L';
$conf['auth']['params']['query_update'] = 'UPDATE users SET password =  
ENCRYPT(\P,"aa") WHERE email = \L';
$conf['auth']['params']['query_resetpassword'] = 'UPDATE users SET  
password = ENCRYPT(\P,"aa") WHERE email = \L';
$conf['auth']['params']['query_remove'] = 'DELETE FROM users WHERE  
email = \L limit 1';
$conf['auth']['params']['query_list'] = 'SELECT email FROM users';
$conf['auth']['params']['query_exists'] = 'SELECT 1 FROM users WHERE  
email = \L';