PROLIN.PL

Roundcube (http://www.roundcube.net) is a popular webmail. As it uses AJAX and looks modern, my customers love it. I also use postfixadmin, but i don't like the idea of separate web panel for administering mail - I prefer when it's in the webmail, at least for the users.

So I wanted to find a solution, that allows my customers t change their passwords, vacation message, and alias editing (all that provides postfixadmin) from within webmail. For earlier versions of Roundcube, there was rcpfa - but now it's discontinued.

So I used the following sollutions:

1. For password changing I use password plugin, by setting password_db_dsn and password_query to UPDATE mailbox SET password=%c WHERE username=%u
2. For vacation, I've created my own script, based on hmail_autoresponder - in attachment
3. For aliases, I've created my own script, based on hmail_aliases - in attachment

WARNING!!!

I've slightly modified the vacation.pl script - I needed the functionality of sending vacation replies only for a period of time - from Start date to End date. So:

• In the Vacation table I've added 2 fields - Activefrom, Activeto
• I've modified 2 queries in vacation.pl script:

  my $query = qq{SELECT email FROM vacation WHERE email=? and
  active=$db_true and (activefrom is null or (activefrom<=curdate() and
  activeto>=curdate()))};
  
  

  
  $query = qq{SELECT email FROM vacation WHERE email=? and
  active=$db_true and (activefrom is null or (activefrom<=curdate() and
  activeto>=curdate()))}