Posts Tagged ‘howto’

Howto: Configure plugin password roundcube with ispconfig3 postfix

Saturday, June 5th, 2010

Please refers to http://www.nixnux.or.id/2010/06/05/howto-configure-plugin-password-roundcube-with-vpopmailmysql-qmailtoaster/

If you want to install roundcube as your webmail interface, please goto http://www.nixnux.or.id/2010/06/05/howto-install-roundcubemail-from-svn-on-ubuntu-lucid-10-04/

This same step with my last article. go…

1. enable it (plugin password)

~]# cd /var/www/roundcube/config
~]# vim main.inc.php

[...]
$rcmail_config['plugins'] = array('password');
[...]

2. Configure it

~]# cd /var/www/roundcube/plugins/password
~]# cp config.inc.php.dist config.inc.php
~]# vim config.inc.php

[...]
$rcmail_config['password_driver'] = 'sql';
$rcmail_config['password_db_dsn'] = 'mysql://ispconfig:$PASSWORD@localhost/dbispconfig';
[...]
$rcmail_config['password_query'] = 'UPDATE mail_user SET password=%c WHERE email=%u LIMIT 1';
[...]

Good Luck.

Thanks to my lovely wife. I luv you. masterpop3

Howto: Configure plugin password roundcube with vpopmail(mysql) + qmailtoaster

Saturday, June 5th, 2010

This plugin very useful for your user account in roundcube, they can do self change their password. without this, you’ll be troubled with their request for change password…LOL.

Note. Plugin password in roundcube version 0.3.1 has been include in package installation. Just enable and configure it.

If you want to install roundcube as your webmail interface, please goto http://www.nixnux.or.id/2010/06/05/howto-install-roundcubemail-from-svn-on-ubuntu-lucid-10-04/

1. Edit main Configuration File Roundcube

Activation Plugin Password Roundcube.

~]# cd /var/www/roundcube/config
~]# vim main.inc.php

[...]
$rcmail_config['plugins'] = array('password');
[...]

2. Edit Plugin Password Configuration File

~]# cd /var/www/roundcube/plugins/password
~]# cp config.inc.php.dist config.inc.php
~]# vim config.inc.php

[...]
$rcmail_config['password_driver'] = 'sql';
$rcmail_config['password_db_dsn'] = 'mysql://vpopmail:$PASSWORD@localhost/vpopmail';
[...]
$rcmail_config['password_query'] = 'UPDATE your_domain_tld  SET pw_passwd=%c, pw_clear_passwd=%p WHERE pw_name=%l LIMIT 1';
[...]

3. Testing Change password

This is my screenshot.

Gotchaaaaa….trust me, It’s WORK.

HOWTO: Install Roundcubemail from SVN on Ubuntu Lucid 10.04

Saturday, June 5th, 2010

I decide to write this article for sharing my experience, while there is still spare time to write and my mood.  let’s begin…

Why What I choose to install from SVN not to install from downloading tar.gz ? that’s very simple to answer.  because :

  1. Install roundcube from SVN, for now always updated (that’s my opinion, and proved correct). I have to try install from tar.gz , and found some bugs and still not updated.
  2. and I have freer to updating anytime using svn.  (masterpop3 suggestion :D )

Server Requirements :

  • Apache, Lighttpd (>=1.4.13 for SSL), or Cherokee Web server
  • Directory on the Web server allowed to run scripts
  • If using Apache, .htaccess support or configuration to override DirectoryIndex
  • PHP version 5.2.1 or greater with
    • PCRE (Perl-Compatible Regular Expressions)
    • Session support
    • Socket support
    • MySQL, PostgreSQL, or SQLite database engine
    • iconv (recommended)
    • OpenSSL (recommended)
    • Mbstring (optional)
    • FileInfo (optional)
    • Mcrypt (optional)
  • php.ini options:
    • error_reporting E_ALL & ~E_NOTICE (or lower)
    • file_uploads on (for attachment upload features)
    • memory_limit (increase as suitable to support large attachments)
    • session.auto_start off
    • magic_quotes_gpc off
  • If using MySQL or PostgreSQL, a database server and database user with permission to create tables
    • If using MySQL 5.0.2 or later, disable STRICT_TRANS_TABLES and STRICT_ALL_TABLES
  • OpenSSL and Socket modules for PHP required to connect to secure IMAP or IMAPS, for secure SMTP and to use the spell checker
    • Additionally, the CURL module for PHP is required for spell checking with TinyMCE (HTML WYSIWYG Editor).
  • An IMAP server which supports IMAP 4 rev 1
  • An SMTP server (recommended) or PHP configured for mail delivery (more…)