Author Topic: vpopmail change password  (Read 7336 times)

Offline ba_tux

  • Jr. Member
  • **
  • Posts: 11
vpopmail change password
« 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

Offline ba_tux

  • Jr. Member
  • **
  • Posts: 11
vpopmail change password
« Reply #1 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
« Last Edit: February 11, 2010, 03:51:25 AM by ba_tux »

Offline imiralem

  • Newbie
  • *
  • Posts: 1
Password encryption problem
« Reply #2 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.

Offline fritz001

  • Jr. Member
  • **
  • Posts: 22
vpopmail change password
« Reply #3 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

Offline ZoukLover

  • Newbie
  • *
  • Posts: 2
table names different
« Reply #4 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?

Offline fritz001

  • Jr. Member
  • **
  • Posts: 22
vpopmail change password
« Reply #5 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 ??

Offline tmsam

  • Newbie
  • *
  • Posts: 1
vpopmail change password
« Reply #6 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.
« Last Edit: April 08, 2010, 04:12:57 AM by tmsam »

Offline raphael.bastos

  • Newbie
  • *
  • Posts: 1
vpopmail change password
« Reply #7 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
;)

Offline melocon

  • Newbie
  • *
  • Posts: 1
vpopmail change password
« Reply #8 on: November 07, 2011, 03:13:25 AM »
thanks !!
it's very helpful for me!