[horde] Fw: Horde + vpopmail/MySQL + Passwd Not working

[Suhag Desai]

In addition to below information pl find below my vpopmail SQL based 
information

mysql> select * from vpopmail;
+------------+-----------+------------------------------------+--------+--------+------------+--------------------------------------------+-
---------+-----------------+
| pw_name    | pw_domain | pw_passwd                          | pw_uid | 
pw_gid | pw_gecos   | pw_dir                                     |
pw_shell | pw_clear_passwd |
+------------+-----------+------------------------------------+--------+--------+------------+--------------------------------------------+-
---------+-----------------+
| mcp        | test.com  | $1$i.tV1Frh$ijV4mGel8QDmMxCrvgwjX/ |      0 | 
0 | mcp        | /home/vpopmail/domains/test.com/mcp        |
NOQUOTA  | mcp             |
| spd        | test.com  | $1$o5nVx1l5$DbNwHq.m44b0ypJnte4Xg0 |      0 | 
0 | spd        | /home/vpopmail/domains/test.com/spd        |
NOQUOTA  | spd             |
| postmaster | test.com  | $1$LRDL3sxz$pbI9YwMqsFS.3h1ztTiKD. |      0 | 
0 | Postmaster | /home/vpopmail/domains/test.com/postmaster |
NOQUOTA  | test            |
| bjv        | test.com  | $1$fK9MV17L$5aahA2UgZAItCjDmpTaei0 |      0 | 
0 | bjv        | /home/vpopmail/domains/test.com/bjv        |
NOQUOTA  | bjv             |
| postmaster | gnfc.com  | $1$50Ju0tun$FhWUa7spJvmQJ8jTimlhl1 |      0 | 
0 | Postmaster | /home/vpopmail/domains/gnfc.com/postmaster |
NOQUOTA  | gnfc            |
| gnfc1      | gnfc.com  | $1$AhJPe73q$l5QGSrvADwfyKmuEEUO10. |      0 | 
0 | gnfc1      | /home/vpopmail/domains/gnfc.com/gnfc1      |
NOQUOTA  | gnfc1           |
| djb        | test.com  | $1$mYYfnb61$lbxMakawVgosgr63o4wBD1 |      0 | 
0 | djb        | /home/vpopmail/domains/test.com/djb        |
NOQUOTA  | djb             |
| test       | test.com  | 098f6bcd4621d373cade4e832627b4f6   |      0 | 
0 | test       | /home/vpopmail/domains/test.com/test       |
NULL     | test            |


----- Original Message ----- 
From: "Suhag Desai" <spdesai at gnvfc.net>
To: <horde at lists.horde.org>
Sent: Saturday, May 05, 2007 9:59 AM
Subject: [horde] Horde + vpopmail/MySQL + Passwd Not working


> Dear All,
>
> My HORDE/IMP Working fine except passwd.
>
> Wheneve user try to change password the below error generated
>
> "Failure in changing password on Example Vpopmail Server: Incorrect 
> Password"
>
> I have searched lots of in archive and feel that as per general opinion 
> its due to encrption method mismatch between mysql and php. I have used 
> all the encryption method in backend.php and lib/Driver/vpopmail.php but 
> not solved.
>
> vpopmail.php
>
> $defaults = Horde::getDriverConfig('', 'sql');
> $this->_params['hostspec']   = isset($params['hostspec'])   ? 
> $params['hostspec'] : '192.168.10.71';
> $this->_params['protocol']   = isset($params['protocol'])   ? 
> $params['protocol'] : 'tcp';
> $this->_params['username']   = isset($params['username'])   ? 
> $params['username'] : 'root';
> $this->_params['password']   = isset($params['password'])   ? 
> $params['password'] : 'suhag1';
> $this->_params['database']   = isset($params['database'])   ? 
> $params['database'] : 'vpopmail';
> $this->_params['port']       = isset($params['port'])       ? 
> $params['port']     : '3306';
>
> /* Defaults to match Auth::sql default. */
> $this->_params['table']      = isset($params['table'])      ? 
> $params['table'] : 'vpopmail';
> $this->_params['encryption'] = isset($params['encryption']) ? 
> $params['encryption'] : 'crypt';
> $this->_params['name']       = isset($params['name'])       ? 
> $params['name'] : 'pw_name';
> $this->_params['domain']     = isset($params['domain'])     ? 
> $params['domain'] : 'pw_domain';
> $this->_params['passwd']     = isset($params['passwd'])     ? 
> $params['passwd'] : 'pw_passwd';
> $this->_params['clear_passwd'] = isset($params['clear_passwd'])     ? 
> $params['clear_passwd'] : 'pw_clear_passwd';
> $this->_params['use_clear_passwd'] = isset($params['use_clear_passwd']) 
> ? $params['use_clear_passwd'] : true;
> $this->_params['show_encryption'] = isset($params['show_encryption']) ? 
> $params['show_encryption'] : true;
>
> BACKEND.PHP
>
> $backends['vpopmail'] = array (
>    'name' => 'Example Vpopmail Server',
>    'preferred' => '',
>    'password policy' => array(
>        'minLength' => 3,
>        'maxLength' => 8,
>        'maxSpace' => 0,
>        'minUpper' => 0,
>        'minLower' => 0,
>        'minNumeric' => 0
>    ),
>    'driver' => 'vpopmail',
>    'params' => array(
>        'phptype'    => 'mysql',
>        'hostspec'   => '192.168.10.71',
>        'username'   => 'root',
>        'password'   => 'suhag1',
>        'encryption' => 'crypt',
>        'database'   => 'vpopmail',
>        'table'      => 'vpopmail',
>        'port'       => '3306',
>        'name'    => 'pw_name',
>        'domain'  => 'pw_domain',
>        'passwd' =>  'pw_passwd',
>        'clear_passwd' => 'pw_clear_passwd',
>        'use_clear_passwd' => true,
>        'show_encryption' => true,
>        'protocol' => 'tcp'
>    )
> );
>
> Thanks
>
> suhag
>
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>