Thread: [Postfixadmin-devel] Roundcube password plugin w/ postfixadmin

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hello,

Does anyone here have any experience with a roundcube plugin that would
let users change their postfixadmin passwords from within roundcube?

Il 25/03/2016 05:15, Gabriel Filion ha scritto:
> Hello,
>
> Does anyone here have any experience with a roundcube plugin that would
> let users change their postfixadmin passwords from within roundcube?
There is a "password" plugin.

It can update a password via an SQL query. If you are using:

$CONF['encrypt'] = 'md5crypt';

you can put:

$config['password_db_dsn'] = 
'mysql://postfixadmin:longandverycomplexpassword@localhost/postfixadmin';
$config['password_query'] = 'UPDATE mailbox SET password=%c WHERE 
username=%u LIMIT 1';

in plugins/password/config.inc.php

it worked at least with the debian postfixadmin package and the last 
roundcube version.

Simone
-- 
Simone Piccardi                                 Truelite Srl
pic...@tr... (email/jabber)             Via Monferrato, 6
Tel. +39-347-1032433                            50142 Firenze
http://www.truelite.it  Tel. +39-055-7879597    Fax. +39-055-7333336

I have it working on Centos.

On 03/25/2016 07:04 AM, Simone Piccardi wrote:
> Il 25/03/2016 05:15, Gabriel Filion ha scritto:
>> Hello,
>>
>> Does anyone here have any experience with a roundcube plugin that would
>> let users change their postfixadmin passwords from within roundcube?
> There is a "password" plugin.
>
> It can update a password via an SQL query. If you are using:
>
> $CONF['encrypt'] = 'md5crypt';
>
> you can put:
>
> $config['password_db_dsn'] =
> 'mysql://postfixadmin:longandverycomplexpassword@localhost/postfixadmin';
> $config['password_query'] = 'UPDATE mailbox SET password=%c WHERE
> username=%u LIMIT 1';
>
> in plugins/password/config.inc.php
>
> it worked at least with the debian postfixadmin package and the last
> roundcube version.
>
> Simone

Simone Piccardi:
> Il 25/03/2016 05:15, Gabriel Filion ha scritto:
>> Hello,
>>
>> Does anyone here have any experience with a roundcube plugin that would
>> let users change their postfixadmin passwords from within roundcube?
> There is a "password" plugin.
> 
> It can update a password via an SQL query. If you are using:
> 
> $CONF['encrypt'] = 'md5crypt';
> 
> you can put:
> 
> $config['password_db_dsn'] = 
> 'mysql://postfixadmin:longandverycomplexpassword@localhost/postfixadmin';
> $config['password_query'] = 'UPDATE mailbox SET password=%c WHERE 
> username=%u LIMIT 1';
> 
> in plugins/password/config.inc.php
> 
> it worked at least with the debian postfixadmin package and the last 
> roundcube version.

wow great, thanks for the really clear example. I'll test this out! :)

On 25/03/16 07:04 AM, Simone Piccardi wrote:
> Il 25/03/2016 05:15, Gabriel Filion ha scritto:
>> Does anyone here have any experience with a roundcube plugin that would
>> let users change their postfixadmin passwords from within roundcube?
> There is a "password" plugin.
> 
> It can update a password via an SQL query. If you are using:
> 
> $CONF['encrypt'] = 'md5crypt';
> 
> you can put:
> 
> $config['password_db_dsn'] = 
> 'mysql://postfixadmin:longandverycomplexpassword@localhost/postfixadmin';
> $config['password_query'] = 'UPDATE mailbox SET password=%c WHERE 
> username=%u LIMIT 1';
> 
> in plugins/password/config.inc.php

wow, it took me way too much time to get to test this :S

I just tried the instructions you gave me and they seem to be working
great :) I'll ask some more users to test this out to confirm my results.

Just for info: I'm still using postfixadmin 2.3.5 and roundcube 0.9.5
(stuck with wheezy for now.. but hope to upgrade some time this year)

thanks a bunch for the instructions!

Thread: [Postfixadmin-devel] Roundcube password plugin w/ postfixadmin

postfixadmin-devel