Howto: Configure plugin password roundcube with ispconfig3 postfix

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

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

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 Read the rest of this entry »

Show a config file without comments

May 28th, 2010
~$ egrep -v "^$|^[[:space:]]*#" /your/path/file

or

~$ awk '!/^\ *#/&&(length > 0)' /your/path/file

Integration Postfix + Mailman + Ispconfig3 on ubuntu Lucid 10.04

May 18th, 2010

This guide explains how to setup Mailman mailing list software with the Apache web server and Postfix mail servers on Ubuntu with running ispconfig3. The intended audience is experienced linux users and system administrators.

Assumptions

  • It is assumed that you know how to run linux commands, edit files, and start and stop services in the linux system. It is also assumed that you have administrative access to an Ubuntu system, that you have internet connection and that you have configured /etc/apt/sources.list.
  • myhostname : masterpop3.domain.com
  • sign ‘~#’ is mean your console

1. Installation Mailman

~# aptitude install mailman
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
The following NEW packages will be installed:
mailman pwgen{a}
0 packages upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 9,665kB of archives. After unpacking 45.0MB will be used.
Do you want to continue? [Y/n/?] y
configuring-mailman

configuring-mailman1

configuring-mailman2

configuring-mailman2

Read the rest of this entry »

Mailman Postfix Recipient address rejected: User unknown in virtual mailbox table;

May 14th, 2010

May 14 15:29:15 apel postfix/smtpd[13425]: NOQUEUE: reject: RCPT from unknown[202.xxx.xxx.xxx]: 550 5.1.1 <milist@nixnux.or.id>: Recipient address rejected: User unknown in virtual mailbox table; from=<usera@nixnux.or.id> to=<milist@nixnux.or.id> proto=SMTP helo=<usera>

I see the error log /var/log/mail.log in my ubuntu lucid 10.04 with ispconfig 3.0.2.1, postfix and mailman.

error above cause of :

  • mailman hasn’t hash alias_maps or virtual_alias_maps
  • mallfunction section of integration postfix with mailman

please try my solution :

check config file /etc/postfix/main.cf , make sure you have :

.
.
alias_maps = hash:/etc/aliases,hash:/var/lib/mailman/data/aliases
alias_database = hash:/etc/aliases,hash:/var/lib/mailman/data/aliases
.
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf, hash:/var/lib/mailman/data/virtual-mailman
.
.

postfix build map and try reload postfix :

~# postmap /var/lib/mailman/data/aliases
~# postmap /var/lib/mailman/data/virtual-mailman

~# /etc/init.d/postfix restart

~~Good Luck~~
masterpop3

Mailman list admin password reset

May 14th, 2010

If you forget your admin list password for a mailman list in your linux ubuntu, type this at the console :

/usr/lib/mailman/bin/change_pw --listname=milist --domain=masterpop3.com --password=newpassword

where :

–listname=milist
Change the password only for the named list.  It is okay to give multiple -l options.

–domain=masterpop3.com
Change the password for all lists in the virtual domain `domain.com’.  It is okay to give multiple -d options.

–password=newpassword
Use the supplied plain text password `newpassword’ as the new password for any lists that are being changed (as specified by the -a, -d, and -l options).  If not given, lists will be assigned a randomly generated new password.

~Good luck ~

Integration Authentication User Cyberoam with LDAP

December 10th, 2009

This article describes how to integrate Cyberoam with LDAP (Lightweight Directory Protocol).

Cyberoam – LDAP integration feature allows Cyberoam to map the users and groups from LDAP for the purpose of authentication.

Cyberoam allows implementing LDAP integration in two ways:

  • Tight Integration – It provides an added layer of protection by authenticating user based on the group membership apart from authentication attribute. One needs to configure both Group Name attribute and authentication attribute for authentication. Group membership of each user and expiry date is as per defined in LDAP server. LDAP server uses Group and expiry date used for extracting the user information.
  • Loose Integration – It uses authentication attribute for authenticating users.

Read the rest of this entry »

OpenLDAP-SambaPDC-Ubuntu-Karmic-9.10

December 10th, 2009

I took some articles from here and here, and trying to fit into ubuntu server Karmic 9.10 – 64bit. If you have trouble reading this tutorial, please use google translate from bahasa Indonesia to English.

Thanks to ubuntu-community and howtoforge.net

Pendahuluan

Artikel ini menjelaskan cara mengatur Windows domain menggunakan Samba dengan OpenLDAP sebagai Domain Controler utama yang menyimpan informasi account Windows. Ini menyediakan otentikasi terpusat untuk Windows pengguna pada jaringan, sehingga menghindari kebutuhan untuk mengelola account pengguna lokal di setiap Windows PC. Ini dapat juga memungkinkan penggunaan profil roaming, di mana pengguna dapat masuk ke setiap Windows PC pada jaringan dan pengaturan pribadi yang sama di setiap sesi.

Dengan menggunakan LDAP sebagai database Samba bukan salah satu alternatif, meskipun, jauh lebih dapat dicapai. Database LDAP dapat juga mengadakan kelas-kelas lain informasi pada masing-masing pengguna yang dapat digunakan untuk sistem otentikasi lainnya, atau untuk informasi umum seperti dalam kasus e-mail dari daftar kontak. Dalam artikel ini, LDAP kelas ‘person’, ‘organizationalPerson’ dan ‘inetOrgPerson’ menyimpan informasi umum tentang pengguna, termasuk alamat e-mail, nomor telepon dan alamat fisik. Informasi ini dapat dimanfaatkan oleh klien e-mail seperti Evolution dan Thunderbird. Kelas LDAP ‘posixAccount’ menyimpan informasi account pengguna Linux. Sama seperti Windows PC, PC Linux dapat dikonfigurasi untuk menggunakan database OpenLDAP sebagai pusat titik otentikasi. Dengan demikian, kita memiliki sebuah server LDAP yang menyediakan otentikasi untuk Windows dan Linux PC. Selain itu, server LDAP dapat berpotensi digunakan untuk mengontrol akses ke sistem Web – silakan lihat artikel sangat membantu OpenLDAPServer.

Read the rest of this entry »

Connecting console Cable to cyberoam

September 10th, 2009