Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: ba_tux on January 16, 2010, 02:51:40 AM

Title: vpopmail change password
Post by: ba_tux on January 16, 2010, 02:51:40 AM

Hi, I'm new user of Roundcube.
The default Roundcube(0.3.1) comes with password plugin. I confused how to apply it. I'm using qmail+vpopmail. I guess I should use sql driver for vpopmail since vpopmail uses mysql database for authentication. But I don't understand the parameters in sql driver like password_db_dsn, password_query,password_hash_algorithm, and password_hash_base64. Please help me

Title: vpopmail change password
Post by: ba_tux on February 09, 2010, 04:59:53 AM

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()),8),_utf8\'$\')),pw_clear_passwd=%p where pw_name=%l';

Hope this can be useful

Title: Password encryption problem
Post by: imiralem on March 03, 2010, 06:12:09 PM

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.

Title: vpopmail change password
Post by: fritz001 on March 03, 2010, 11:59:50 PM

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 :D :D

Title: table names different
Post by: ZoukLover on March 12, 2010, 01:30:04 AM

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?

Title: vpopmail change password
Post by: fritz001 on March 12, 2010, 01:48:12 PM

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 ??

Title: vpopmail change password
Post by: tmsam on April 08, 2010, 04:09:19 AM

Hi every body, I have install :
1. windows xp
2. wampserver 2.0
3. Hmail 5.3.2
4. Roucube mail 0.3.1

Now can send/Reicv with webmail, pop.. but cannot change password. I have try password plugin but now success. I think infomation data of user in hmail\database folder\hmailserver.sdf not in mysql (mysql.initial.sql) . Pls help me.

Title: vpopmail change password
Post by: raphael.bastos on March 14, 2011, 10:31:05 PM

Quote from: ZoukLover;26107

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://vpopmailuser:password@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
;)

Title: vpopmail change password
Post by: melocon on November 07, 2011, 03:13:25 AM

thanks ！！
it's very helpful for me!