Tickets :: Comment on [#8388] Kronolith webdav user@xy.de gets userxy.de

* Your Email Address
* Spam protection	Enter the letters below: ._.. .. ..___.__. \| \| \|\|\ \|[__ \| \| _\|_\|/\\|\| \\|[___\|__\|
Comment	>> 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'; > >
Attachment
Watch this ticket