[sork] Re: passwd with sql

[Martin Lohmeier]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Doug Curtis wrote:
| Howdy all.
|
| Passwd is working fine as long as I specify the entire username.  I
| host a number of virtual domains with mysql and postfix.   The
| usernames are all in the format USER at DOMAIN  The passwd module (or
| maybe horde) seems to be striping off the @DOMAIN portion of the
| username in the prefilled username field.

I'm using passwd from CVS (4 days old) and it's working fine here. Users
(e.g user at domain.tld) and passwords are stored in mysql and I have no
problem changing the password - no hook is used.

Here is my backend, maybe it helps:

$backends['sql'] = array (
~    'name' => 'Horde Authentication',
~    'preferred' => '',
~    'password policy' => array(
~        'minLength' => 3,
~        'maxLength' => 80,
~        'maxSpace' => 0,
~        'minUpper' => 1,
~        'minLower' => 1,
~        'minNumeric' => 1,
~    ),
~    'driver' => 'sql',
~    'params' => array(
~        'phptype'    => 'mysql',
~        'hostspec'   => 'localhost',
~        'username'   => 'user',
~        'password'   => SECRET,
~        'encryption' => 'md5-hex',
~        'database'   => 'user',
~        'table'      => 'horde_users',
~        'user_col'   => 'user_uid',
~        'pass_col'   => 'user_pass',
~        'show_encryption' => false
~    )
);

My horde auth config:

$conf['sql']['phptype'] = 'mysql';
$conf['sql']['persistent'] = false;
$conf['sql']['protocol'] = 'unix';
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'user';
$conf['sql']['password'] = SECRET;
$conf['sql']['database'] = 'user';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['auth']['admins'] = array('root');
$conf['auth']['checkip'] = true;
$conf['auth']['params']['driverconfig'] = 'horde';
$conf['auth']['params']['encryption'] = 'md5-hex';
$conf['auth']['params']['show_encryption'] = false;
$conf['auth']['driver'] = 'sql';

by, Martin
- --

Powered by Debian GNU / Linux
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCO3FiGxxhbGlQyAkRAk7CAJ9i1E1l8GOUTMab0fSHWDsHlhPqTwCgrIcA
yZveq9ThTztYb3Ugdz9Y8Pg=
=XhEc
-----END PGP SIGNATURE-----