Change Virutal User Password in Roundcube

SQL user database

************************************************ UPDATE *****************************************************************

THIS POST IS IRRELEVANT TO A CERTAIN POINT — THE NEWEST VERSION OF ROUDCUBE HAS A PASSWORD PLUGIN THAT PERFORMS THIS SAME ACTION. YOU STILL NEED TO EDIT THE SQL STRING TO UPDATE YOUR USERS TABLE ACCORDINGLY. PLEASE REFERENCE THE PLUGIN API OR ROUNDCUBE FORUM IF YOU HAVE ANY FURTHER QUESTIONS OR CONCERNS!!!

*************************************************************************************************************************

I have had quite a struggle over the past few weeks trying to get a good webmail client working properly for my email domains. In times past I have used Roundcube, but that was only with a single domain and UNIX based user accounts. My new setup was configured for virtual domains and virtual users and unfortunately I was struggling to get Roundcube functioning for me in this context. After several long nights I finally got an instance of Roundcube to represent each of my virtual domains. My relief quickly turned to despair as I realized that Roundcube didn’t have a plugin that allowed my users to change their encrypted database password. I certainly did not want the responsibility of knowing all my users passwords and having them email me whenever they wanted to change their password. I came to the conclusion that this was a deal breaker for me — I either had to find a way to allow my users to change their passwords independent of me via Roundcube or I was going to go back to SquirrelMail. In all fairness SquirrelMail has an awesome array of plugins and functionality that Roundcube doesn’t even begin to offer — BUT SquirrelMail is still running on Web 1.0 (aka it looks like a 1990′s webmail client).

After a lot of google searching and A LOT of failed attempts at getting Roundcube to change the user’s passwords I finally came upon some code that I was able to piece together and make work. This code is not written or maintained by me — credit goes to Nemesis02 and xul from the Roundcube forums as well as credit goes to Jonny Grover who helped me find a few misplaced quotation marks. So without further adieu here it is:

Requirements:

Working email server (either POP/IMAP and SMTP)

Working installation of Roundcube (version 0.2-stable)

Write access to your database server

Database that contains user names, domains and passwords

Write access to your Roundcube files

Ok we are going to start editing a few files so be patient.

1. Open roundcube/index.php

==========================================================

Find [~ Line 188 ]


'settings' => array(
    'folders'       => 'manage_folders.inc',
    'create-folder' => 'manage_folders.inc',
    'rename-folder' => 'manage_folders.inc',
    'delete-folder' => 'manage_folders.inc',
    'subscribe'     => 'manage_folders.inc',
    'unsubscribe'   => 'manage_folders.inc',
    'add-identity'  => 'edit_identity.inc',
  )

==========================================================

Change it to say:


'settings' => array(
    'folders'       => 'manage_folders.inc',
    'create-folder' => 'manage_folders.inc',
    'rename-folder' => 'manage_folders.inc',
    'delete-folder' => 'manage_folders.inc',
    'subscribe'     => 'manage_folders.inc',
    'unsubscribe'   => 'manage_folders.inc',
    'add-identity'  => 'edit_identity.inc',
    'password'      => 'password.inc',
    'save-password' => 'password.inc',
  )

2. Open roundcube/program/js/app.js

==========================================================

Find [ ~ Line 238 ]


case 'settings':
        this.enable_command("preferences", "identities", "save", "folders", true);

==========================================================

edit it to say:


case 'settings':
        this.enable_command("preferences", "identities", "save", "folders", "password", true);

==========================================================

Find this line [ ~ Line 239 ]


if(this.env.action=="identities"||this.env.action=="edit-identity"||this.env.action=="add-identity"){
  this.enable_command("add",this.env.identities_level<2);
  this.enable_command("delete","edit",true);
        }

==========================================================

and then insert above it:


if (this.env.action=='password' || this.env.action=='save-password')
        {
          var input_current_password = rcube_find_object('_current_password');
          var input_new_password = rcube_find_object('_new_password');
          var input_repeat_password = rcube_find_object('_repeat_password');
          if (input_current_password && input_current_password.value=='')
              input_current_password.focus();
          else if (input_repeat_password)
              input_repeat_password.focus();

          this.enable_command('save-password', true);
        }

==========================================================

Find this line [ ~ Line 904]


      case 'delete-folder':
        this.delete_folder(props);
        break;

==========================================================

Insert after it the following:


      case 'password':
        this.goto_url('password');
        break;

      case 'save-password':
        var input_current_password = rcube_find_object('_current_password');
        var input_new_password = rcube_find_object('_new_password');
        var input_repeat_password = rcube_find_object('_repeat_password');
        if ((input_new_password && input_new_password.value=='') && (input_repeat_password && input_repeat_password.value=='')
                || (input_current_password && input_current_password.value==''))
            {
                alert(this.get_label('nopassword'));
                input_current_password.value='';
                input_new_password.value='';
                input_repeat_password.value='';
                input_current_password.focus();
            }
        else if ((input_new_password && input_repeat_password) && ( input_new_password.value != input_repeat_password.value))
            {
                alert(this.get_label('passwordinconsistency'));
                input_new_password.value='';
                input_repeat_password.value='';
                input_new_password.focus();
            }
        else
                this.gui_objects.editform.submit();
        break;

3. Open program/localization/en_US/labels.inc