RoundCube Webmail Forum  

Go Back   RoundCube Webmail Forum > News and Announcements > General Discussion

For more information about the ads and why they're here, please see the FAQ

Reply
  #1  
Old 01-16-2010, 06:51 AM
Registered User
 
Join Date: Oct 2009
Posts: 11
Default vpopmail change password

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 02-09-2010, 08:59 AM
Registered User
 
Join Date: Oct 2009
Posts: 11
Default

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

Last edited by ba_tux; 02-11-2010 at 07:51 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 03-03-2010, 10:12 PM
Roundcube Newcomer
 
Join Date: Mar 2010
Posts: 1
Default Password encryption problem

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 03-04-2010, 03:59 AM
Registered User
 
Join Date: Mar 2008
Posts: 15
Default

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 03-12-2010, 05:30 AM
Roundcube Newcomer
 
Join Date: Oct 2008
Posts: 2
Default table names different

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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6  
Old 03-12-2010, 05:48 PM
Registered User
 
Join Date: Mar 2008
Posts: 15
Default

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 ??
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 03:15 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright © 2006-2008 RoundCube Webmail Community