Thread: vpopmail change password

Finally, I'm able to change vpopmail password via Roundcube. I use password plugin embedded in Roundcube. This is my configuration (config.inc.php):

$rcmail_config['password_driver'] = 'sql';
$rcmail_config['password_db_dsn'] = 'mysql://vpopmail:your_vpopmail_password@localhost/vpopmail';
$rcmail_config['password_query'] ='update your_domain set pw_passwd=ENCRYPT(%p,concat(_utf8\'$1$\',right(md5 (rand()),,_utf8\'$\')),pw_clear_passwd=%p where pw_name=%l';

Hope this can be useful

Hi, I need a help.
I installed hmail and rouncdube 0.3 with passwor change plugin. Everything is OK. I use xampp (Apache/2.2.12 PHP/5.3.0 MySQL 1.37).
When I change password through webmail-roundcube I put for.ex. sarajevo in MySql - accountpassword get this encryption:
grmDbKqhMc+IQzgrOtHRvg==
and when change through hmail administration for pass. sarajevo I get this:
d2823cc8bd609e595d489997ec2f840fa4dfabdcf091a0322d
Problem is, when I change through roundcube, and logout, next login, I can not do because it not recognize password.
Sorry for my english.
Please is anybody who has solution for this.
Thanks in advance.

edit config.php as:

$rcmail_config['password_driver'] = 'sql';
$rcmail_config['password_db_dsn'] = 'mysql://__vpopmail_user__:__vpopmail_passwd__@localhost/vpopmail';

$rcmail_config['password_query'] = 'UPDATE my_company_com set pw_passwd=ENCRYPT(%p,concat("$1$",right(md5(rand() ), 8 ),"$")),pw_clear_passwd=%p where pw_name=%l';


you did something wrong, with the example above it WILL work.

and btw: and when change through hmail administration for pass. sarajevo I get this:
d2823cc8bd609e595d489997ec2f840fa4dfabdcf091a0322d :: USE password plugin not hmail_password

Hi,

I host multiple domains using also qmailtoaster.

My table names are slightly different:

domain.com -> table name is domain_com

As you can see %d doesn't work for me.

Any help?

zouklover, I think you need glasses::

$rcmail_config['password_query'] = 'UPDATE domain_com

if domain name is smart-guy.fr then :: $rcmail_config['password_query'] = 'UPDATE smart_guy_fr

Do you get the idee now ??

Originally Posted by ZoukLover

Hi,

I host multiple domains using also qmailtoaster.

My table names are slightly different:

domain.com -> table name is domain_com

As you can see %d doesn't work for me.

Any help?

ZoukLover,

add to /var/www/html/roundcube/plugins/password/config.inc.php:

$rcmail_config['password_driver'] = 'sql';
$rcmail_config['password_db_dsn'] = 'mysql://vpopmailuserassword@localhost/vpopmail';
$emailuser=$_SESSION['username'];
$domain = split("@",$emailuser);
$dom_table = str_replace(".","_",$domain[1]);
$rcmail_config['password_query'] = "UPDATE $dom_table SET pw_passwd=%c, pw_clear_passwd=%p WHERE pw_name=%l LIMIT 1";


and create user vpopmailuser:

mysql> GRANT ALL ON vpopmail.* TO vpopmailuser@localhost IDENTIFIED BY 'password';
mysql> FLUSH PRIVILEGES;


work for me on roundcube 0.5.1 stable

thanks ！！
it's very helpful for me!