Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 4th August 2011, 09:40
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default Dovecot v2 with ISPConfig 3

Hi,
I am trying out dovecot instead of courier and was wondering if anyone has a working dovecot.conf file for v2 they could share or any other informations.

Everything works fine until ISPConfig 3 configures dovecot so I am presuming there is no support just yet.

Is anyone working on this or is it in the roadmap.

Thanks in advance.
Reply With Quote
Sponsored Links
  #2  
Old 4th August 2011, 09:48
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,964
Thanks: 825
Thanked 5,366 Times in 4,213 Posts
Default

Dovecot 2 is not supported yet. It is planned to add support for dovecot 2 with ISPConfig 3.0.4. There is noone working on that yet. Would be a big help if you could amke a dovecot.conf and dovecot-sql.conf file which we could use.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 4th August 2011, 11:51
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default

I can help to a limited extent - wish I had the knowledge base !!
I can only see what needs to be done and not know how to do it - very frustrating.

I can certainly try but will need help and confirmation.

Here are some of my questions:

1. If I run:
openssl x509 -in /etc/ssl/certs/dovecot.pem -noout -text

The correct cert has been written with the CN hostname details and so on. The only thing I would change is the email address which is root@mydomain.tld.
At the moment I can just add an alias in /etc/aliases for root: postmaster@mydomain.tld
and then run
newaliases
/etc/init.d/postfix reload

So the means by which certs can be recreated are not available in binary distributions unless I am missing something - I would have to go here:
http://wiki.dovecot.org/SSL/CertificateCreation
and download mkcert.sh and so on ...

Could you tell me the correct way to do this.

2. These are my dovecot packages (this is a testing system because I am looking at the dovecot-managesieved package in wheezy):
dovecot-common dovecot-imapd dovecot-managesieved dovecot-pop3d dovecot-sieve

The following NEW packages will be installed:
dovecot-common dovecot-imapd dovecot-managesieved dovecot-pop3d dovecot-sieve
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/3,476 kB of archives.
After this operation, 7,004 kB of additional disk space will be used.
Selecting previously deselected package dovecot-common.
(Reading database ... 29783 files and directories currently installed.)
Unpacking dovecot-common (from .../dovecot-common_1%3a2.0.13-1.1_amd64.deb) ...
Selecting previously deselected package dovecot-imapd.
Unpacking dovecot-imapd (from .../dovecot-imapd_1%3a2.0.13-1.1_amd64.deb) ...
Selecting previously deselected package dovecot-sieve.
Unpacking dovecot-sieve (from .../dovecot-sieve_1%3a2.0.13-1.1_amd64.deb) ...
Selecting previously deselected package dovecot-managesieved.
Unpacking dovecot-managesieved (from .../dovecot-managesieved_1%3a2.0.13-1.1_amd64.deb) ...
Selecting previously deselected package dovecot-pop3d.
Unpacking dovecot-pop3d (from .../dovecot-pop3d_1%3a2.0.13-1.1_amd64.deb) ...
Setting up dovecot-common (1:2.0.13-1.1) ...

Creating config file /etc/dovecot/dovecot.conf with new version
Creating config file /etc/dovecot/dovecot-db.conf.ext with new version
Creating config file /etc/dovecot/dovecot-dict-sql.conf.ext with new version
Creating config file /etc/dovecot/dovecot-sql.conf.ext with new version
Creating config file /etc/dovecot/conf.d/10-auth.conf with new version
Creating config file /etc/dovecot/conf.d/10-director.conf with new version
Creating config file /etc/dovecot/conf.d/10-logging.conf with new version
Creating config file /etc/dovecot/conf.d/10-mail.conf with new version
Creating config file /etc/dovecot/conf.d/10-master.conf with new version
Creating config file /etc/dovecot/conf.d/10-ssl.conf with new version
Creating config file /etc/dovecot/conf.d/15-lda.conf with new version
Creating config file /etc/dovecot/conf.d/90-acl.conf with new version
Creating config file /etc/dovecot/conf.d/90-plugin.conf with new version
Creating config file /etc/dovecot/conf.d/90-quota.conf with new version
Creating config file /etc/dovecot/conf.d/auth-deny.conf.ext with new version
Creating config file /etc/dovecot/conf.d/auth-master.conf.ext with new version
Creating config file /etc/dovecot/conf.d/auth-passwdfile.conf.ext with new version
Creating config file /etc/dovecot/conf.d/auth-static.conf.ext with new version
Creating config file /etc/dovecot/conf.d/auth-system.conf.ext with new version
Creating config file /etc/dovecot/conf.d/auth-vpopmail.conf.ext with new version
Creating generic self-signed certificate: /etc/ssl/certs/dovecot.pem
This certificate will expire in 10 years.
(replace with hand-crafted or authorized one if needed).
Starting IMAP/POP3 mail server: dovecot.
Setting up dovecot-imapd (1:2.0.13-1.1) ...
Creating config file /etc/dovecot/conf.d/20-imap.conf with new version
Restarting IMAP/POP3 mail server: dovecot.
Setting up dovecot-sieve (1:2.0.13-1.1) ...
Creating config file /etc/dovecot/conf.d/90-sieve.conf with new version
Restarting IMAP/POP3 mail server: dovecot.
Setting up dovecot-managesieved (1:2.0.13-1.1) ...
Creating config file /etc/dovecot/conf.d/20-managesieve.conf with new version
Restarting IMAP/POP3 mail server: dovecot.
Setting up dovecot-pop3d (1:2.0.13-1.1) ...
Creating config file /etc/dovecot/conf.d/20-pop3.conf with new version
Restarting IMAP/POP3 mail server: dovecot.




netstat -tap
tcp 0 0 *:smtp *:* LISTEN 1290/master
tcp 0 0 *:sieve *:* LISTEN 4629/dovecot
tcp 0 0 *:imaps *:* LISTEN 4629/dovecot
tcp 0 0 *op3s *:* LISTEN 4629/dovecot
tcp 0 0 localhost.localdo:10024 *:* LISTEN 513/amavisd (master
tcp 0 0 localhost.localdo:10025 *:* LISTEN 1290/master
tcp 0 0 localhost.localdo:mysql *:* LISTEN 1091/mysqld
tcp 0 0 *op3 *:* LISTEN 4629/dovecot
tcp 0 0 *:imap2 *:* LISTEN 4629/dovecot
tcp 0 0 localhost.localdo:spamd *:* LISTEN 849/spamd.pid
tcp 0 0 *:ssh *:* LISTEN 843/sshd
tcp6 0 0 [::]:sieve [::]:* LISTEN 4629/dovecot
tcp6 0 0 [::]:imaps [::]:* LISTEN 4629/dovecot
tcp6 0 0 [::]op3s [::]:* LISTEN 4629/dovecot
tcp6 0 0 [::]op3 [::]:* LISTEN 4629/dovecot
tcp6 0 0 [::]:imap2 [::]:* LISTEN 4629/dovecot
tcp6 0 0 [::]:www [::]:* LISTEN 525/apache2
tcp6 0 0 [::]:ssh [::]:* LISTEN 843/sshd

So here is /etc/dovecot.conf (uncommented only) before ISPConfig.

!include_try /usr/share/dovecot/protocols.d/*.protocol
dict {
#quota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
#expire = sqlite:/etc/dovecot/dovecot-dict-sql.conf.ext
}
!include_try local.conf


So the configurations are in /etc/dovecot/conf.d/
10-auth.conf 10-mail.conf 15-lda.conf 20-pop3.conf 90-quota.conf auth-master.conf.ext auth-system.conf.ext
10-director.conf 10-master.conf 20-imap.conf 90-acl.conf 90-sieve.conf auth-passwdfile.conf.ext auth-vpopmail.conf.ext
10-logging.conf 10-ssl.conf 20-managesieve.conf 90-plugin.conf auth-deny.conf.ext auth-static.conf.ext


Which of these need to be modified by the ISPConfig installer?

Further info:
At the moment when I install ISPConfig 3 the following is appended to the dovecot.conf:

driver = mysql
connect = host=localhost dbname=mydatabasename user=ispconfig password=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
default_pass_scheme = CRYPT

password_query = SELECT password FROM mail_user WHERE mymailname = '%u' AND disable%Ls = 'n'
user_query = SELECT (mymailname) as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('maildir:storage=', floor(quota/1024)) AS quota, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE mymailname = '%u' AND disable%Ls = 'n'

Then the following errors are thrown off from the ISPConfig 3 installer:

Configuring Dovecot
PHP Warning: chmod(): No such file or directory in /tmp/ispconfig3_install/install/lib/installer_base.lib.php on line 750
PHP Stack trace:
PHP 1. {main}() /tmp/ispconfig3_install/install/install.php:0
PHP 2. installer_base->configure_dovecot() /tmp/ispconfig3_install/install/install.php:337
PHP 3. chmod() /tmp/ispconfig3_install/install/lib/installer_base.lib.php:750

Configuring Spamassassin
Configuring Amavisd


What is the path to the sql file used currently?

Other errors are:
Stopping amavisd: amavisd-new.
defined(%hash) is deprecated at /usr/share/perl5/Mail/SpamAssassin/Dns.pm line 757.
(Maybe you should just omit the defined()?)
Starting amavisd: amavisd-new.

And the main ones are:

Configuring Getmail
Stopping Postfix Mail Transport Agent: postfix.
Starting Postfix Mail Transport Agent: postfix.
Stopping SASL Authentication Daemon: saslauthd.
Starting SASL Authentication Daemon: saslauthd.


Stopping amavisd: amavisd-new.
defined(%hash) is deprecated at /usr/share/perl5/Mail/SpamAssassin/Dns.pm line 757.
(Maybe you should just omit the defined()?)
Starting amavisd: amavisd-new.
Stopping ClamAV daemon: clamd.
Starting ClamAV daemon: clamd Bytecode: Security mode set to "TrustSigned".
.
doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:24: 'imaps' protocol is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:24: 'pop3s' protocol is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:529: mail_executable has been replaced by service { executable }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:587: mail_executable has been replaced by service { executable }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:664: protocol managesieve {} has been replaced by protocol sieve { }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:681: sieve has been moved into plugin {} section
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:686: sieve_storage has been moved into plugin { sieve_dir }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:813: add auth_ prefix to all settings inside auth {} and remove the auth {} section completely
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:924: passdb sql {} has been replaced by passdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:985: userdb sql {} has been replaced by userdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:1014: auth_user has been replaced by service auth { user }
doveconf: Fatal: Error in configuration file /etc/dovecot/dovecot.conf: mail_plugin_dir: access(/usr/lib/dovecot/modules/lda) failed: No such file or directory
doveconf: Error: managesieve-login: dump-capability process returned 89
doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:24: 'imaps' protocol is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:24: 'pop3s' protocol is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:529: mail_executable has been replaced by service { executable }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:587: mail_executable has been replaced by service { executable }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:664: protocol managesieve {} has been replaced by protocol sieve { }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:681: sieve has been moved into plugin {} section
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:686: sieve_storage has been moved into plugin { sieve_dir }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:813: add auth_ prefix to all settings inside auth {} and remove the auth {} section completely
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:924: passdb sql {} has been replaced by passdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:985: userdb sql {} has been replaced by userdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:1014: auth_user has been replaced by service auth { user }
doveconf: Error: ssl enabled, but ssl_cert not set
doveconf: Error: ssl enabled, but ssl_cert not set
doveconf: Fatal: Error in configuration file /etc/dovecot/dovecot.conf: ssl enabled, but ssl_cert not set
doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:24: 'imaps' protocol is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:24: 'pop3s' protocol is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:529: mail_executable has been replaced by service { executable }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:587: mail_executable has been replaced by service { executable }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:664: protocol managesieve {} has been replaced by protocol sieve { }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:681: sieve has been moved into plugin {} section
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:686: sieve_storage has been moved into plugin { sieve_dir }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:813: add auth_ prefix to all settings inside auth {} and remove the auth {} section completely
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:924: passdb sql {} has been replaced by passdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:985: userdb sql {} has been replaced by userdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:1014: auth_user has been replaced by service auth { user }
doveconf: Fatal: Error in configuration file /etc/dovecot/dovecot.conf: mail_plugin_dir: access(/usr/lib/dovecot/modules/lda) failed: No such file or directory
doveconf: Error: managesieve-login: dump-capability process returned 89
doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:24: 'imaps' protocol is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:24: 'pop3s' protocol is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:529: mail_executable has been replaced by service { executable }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:587: mail_executable has been replaced by service { executable }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:664: protocol managesieve {} has been replaced by protocol sieve { }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:681: sieve has been moved into plugin {} section
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:686: sieve_storage has been moved into plugin { sieve_dir }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:813: add auth_ prefix to all settings inside auth {} and remove the auth {} section completely
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:924: passdb sql {} has been replaced by passdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:985: userdb sql {} has been replaced by userdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:1014: auth_user has been replaced by service auth { user }
doveconf: Fatal: Error in configuration file /etc/dovecot/dovecot.conf: ssl enabled, but ssl_cert not set

Restarting IMAP/POP3 mail server: dovecot failed!
Configure Jailkit (y,n) [y]:


This error relates to "<" in:

ssl_cert = </etc/ssl/certs/dovecot.pem
ssl_key = </etc/ssl/private/dovecot.pem

Fatal: Error in configuration file /etc/dovecot/dovecot.conf: ssl enabled, but ssl_cert not set
and it goes away when the correct path is set.

I don't mind trying to write a new sql file but there are people better able to do that here than me with my limited knowhow.

I am still very keen to help in any way so can post the outputs of anything else needed and can also set up testing systems in either Lenny or Squeeze with very little trouble.
Reply With Quote
  #4  
Old 9th August 2011, 16:33
xabbu xabbu is offline
Junior Member
 
Join Date: Dec 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello all,

I've already written a way to integrate dovecot2 into ispconfig3.

Here my post:

http://www.howtoforge.de/forum/entwi...e-11-3-a-3848/

at the moment german only but if you are interested, I'll translate.

Regards,
xabbu
Reply With Quote
  #5  
Old 9th August 2011, 16:55
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Thumbs up

Hi xabbu,
Thanks very much.

I am having a look at it now and will let you know how I go.
Reply With Quote
  #6  
Old 9th August 2011, 17:52
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default

Thank you for the dovecot.conf.

I am not completely understanding step 7:

Step 7.
I edit

/usr/local/ispconfig/interface/web/mail/mail_user_edit.php

and change which part?

This is what I have in line 261 ish.

$sql = "UPDATE mail_user SET disableimap = '$disableimap', disablepop3 = '$disablepop3', disablesmtp = '$disablesmtp', disabledeliver = '$disabledeliver' WHERE mailuser_id = ".$this->id;
$app->db->query($sql);


Is this the part you mean and how should I change that?

Thanks
Reply With Quote
  #7  
Old 8th October 2011, 15:50
yaw yaw is offline
Junior Member
 
Join Date: Jul 2007
Posts: 18
Thanks: 2
Thanked 0 Times in 0 Posts
Default Update?

Did you have any success with this? I find myself in the same boat. I cannot upgrade to ispconfig 3 unless I can get dovecot 2 working.
Reply With Quote
  #8  
Old 12th November 2011, 04:05
dgonzalezh dgonzalezh is offline
Junior Member
 
Join Date: Oct 2011
Posts: 4
Thanks: 0
Thanked 3 Times in 1 Post
Default I managed to get Dovecot 2 running smooth with ISPC 3.0.4

Hi,

After some research and tweaking and struggling with errors and errors I finally got it working fine with this sample config:

Here it is.

Code:
# 2.0.15 (0cf3215cdf2d): /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-5-xen-amd64 x86_64 Debian 6.0.3 fuse.glusterfs
auth_anonymous_username = anonymous
auth_cache_negative_ttl = 1 hours
auth_cache_size = 0
auth_cache_ttl = 1 hours
auth_debug = no
auth_debug_passwords = no
auth_default_realm =
auth_failure_delay = 2 secs
auth_first_valid_uid = 500
auth_gssapi_hostname =
auth_krb5_keytab =
auth_last_valid_uid = 0
auth_master_user_separator =
auth_mechanisms = plain login
auth_realms =
auth_socket_path = auth-userdb
auth_ssl_require_client_cert = no
auth_ssl_username_from_cert = no
auth_use_winbind = no
auth_username_chars = abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_@
auth_username_format =
auth_username_translation =
auth_verbose = yes
auth_verbose_passwords = no
auth_winbind_helper_path = /usr/bin/ntlm_auth
auth_worker_max_count = 30
base_dir = /var/run/dovecot
config_cache_size = 1 M
debug_log_path =
default_client_limit = 1000
default_idle_kill = 60
default_internal_user = dovecot
default_login_user = dovenull
default_process_limit = 100
default_vsz_limit = 256 M
deliver_log_format = msgid=%m: %$
dict_db_config =
director_doveadm_port = 0
director_mail_servers =
director_servers =
director_user_expire = 15 mins
disable_plaintext_auth = no
dotlock_use_excl = yes
doveadm_allowed_commands =
doveadm_password =
doveadm_proxy_port = 0
doveadm_socket_path = doveadm-server
doveadm_worker_count = 0
first_valid_gid = 5000
first_valid_uid = 5000
hostname =
imap_capability =
imap_client_workarounds =
imap_id_log =
imap_id_send =
imap_idle_notify_interval = 2 mins
imap_logout_format = bytes=%i/%o
imap_max_line_length = 64 k
import_environment = TZ
info_log_path =
last_valid_gid = 5000
last_valid_uid = 5000
lda_mailbox_autocreate = yes
lda_mailbox_autosubscribe = yes
lda_original_recipient_header =
libexec_dir = /usr/lib/dovecot
listen = *, ::
lmtp_proxy = no
lmtp_save_to_detail_mailbox = no
lock_method = fcntl
log_path = syslog
log_timestamp = "%b %d %H:%M:%S "
login_access_sockets =
login_greeting = DGHVoIP Server ready.
login_log_format = %$: %s
login_log_format_elements = user=<%u> method=%m rip=%r lip=%l mpid=%e %c
login_trusted_networks =
mail_access_groups =
mail_attachment_dir = /tmp
mail_attachment_fs = sis posix
mail_attachment_hash = %{sha1}
mail_attachment_min_size = 128 k
mail_cache_fields = flags
mail_cache_min_mail_count = 0
mail_chroot =
mail_debug = yes
mail_fsync = optimized
mail_full_filesystem_access = no
mail_gid = 5000
mail_home =
mail_location = maildir:/var/vmail/%d/%n/Maildir
mail_log_prefix = "%s(%u): "
mail_max_keyword_length = 50
mail_max_lock_timeout = 0
mail_max_userip_connections = 10
mail_never_cache_fields = imap.envelope
mail_nfs_index = no
mail_nfs_storage = no
mail_plugin_dir = /usr/lib/dovecot/modules
mail_plugins = sieve quota
mail_privileged_group = mail
mail_save_crlf = no
mail_temp_dir = /tmp
mail_uid = 5000
mailbox_idle_check_interval = 30 secs
mailbox_list_index_disable = no
maildir_copy_with_hardlinks = yes
maildir_stat_dirs = no
maildir_very_dirty_syncs = no
master_user_separator =
mbox_dirty_syncs = yes
mbox_dotlock_change_timeout = 2 mins
mbox_lazy_writes = yes
mbox_lock_timeout = 5 mins
mbox_min_index_size = 0
mbox_read_locks = fcntl
mbox_very_dirty_syncs = no
mbox_write_locks = dotlock fcntl
mdbox_preallocate_space = no
mdbox_rotate_interval = 0
mdbox_rotate_size = 2 M
mmap_disable = no
passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  deny = no
  driver = sql
  master = no
  pass = no
}
plugin {
  quota = dict:user::file:/var/vmail/%d/%n/.quotausage
  quota_warning = storage=95%% quota-warning 95 %u
  quota_warning2 = storage=80%% quota-warning 80 %u
  sieve = ~/.dovecot.sieve
  sieve_dir = ~/sieve
}
pop3_client_workarounds =
pop3_enable_last = no
pop3_fast_size_lookups = no
pop3_lock_session = no
pop3_logout_format = top=%t/%p, retr=%r/%b, del=%d/%m, size=%s
pop3_no_flag_updates = no
pop3_reuse_xuidl = no
pop3_save_uidl = no
pop3_uidl_format = %08Xu%08Xv
postmaster_address = postmaster@dghvoip.com
protocols = " imap pop3"
quota_full_tempfail = no
recipient_delimiter = +
rejection_reason = Your message to <%t> was automatically rejected:%n%r
rejection_subject = Rejected: %s
sendmail_path = /usr/sbin/sendmail
service anvil {
  chroot = empty
  client_limit = 0
  drop_priv_before_exec = no
  executable = anvil
  extra_groups =
  group =
  idle_kill = 4294967295 secs
  privileged_group =
  process_limit = 1
  process_min_avail = 1
  protocol =
  service_count = 0
  type = anvil
  unix_listener anvil-auth-penalty {
    group =
    mode = 0600
    user =
  }
  unix_listener anvil {
    group =
    mode = 0600
    user =
  }
  user = $default_internal_user
  vsz_limit = 18446744073709551615 B
}
service auth-worker {
  chroot =
  client_limit = 1
  drop_priv_before_exec = no
  executable = auth -w
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol =
  service_count = 1
  type =
  unix_listener auth-worker {
    group =
    mode = 0600
    user = $default_internal_user
  }
  user =
  vsz_limit = 18446744073709551615 B
}
service auth {
  chroot =
  client_limit = 4096
  drop_priv_before_exec = no
  executable = auth
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 1
  process_min_avail = 0
  protocol =
  service_count = 0
  type =
#  unix_listener auth-client {
  unix_listener /var/spool/postfix/private/auth {
    group = postfix
    mode = 0600
    user = postfix
  }
  unix_listener auth-login {
    group =
    mode = 0600
    user = $default_internal_user
  }
  unix_listener auth-master {
    group =
    mode = 0600
    user = postfix
  }
  unix_listener auth-userdb {
    group =
    mode = 0600
    user =
  }
  unix_listener login/login {
    group =
    mode = 0666
    user =
  }
  user = root
  vsz_limit = 18446744073709551615 B
}
service config {
  chroot =
  client_limit = 0
  drop_priv_before_exec = no
  executable = config
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol =
  service_count = 0
  type = config
  unix_listener config {
    group =
    mode = 0600
    user =
  }
  user =
  vsz_limit = 18446744073709551615 B
}
service dict {
  chroot =
  client_limit = 1
  drop_priv_before_exec = no
  executable = dict
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol =
  service_count = 0
  type =
  unix_listener dict {
    group =
    mode = 0600
    user =
  }
  user = $default_internal_user
  vsz_limit = 18446744073709551615 B
}
service director {
  chroot =
  client_limit = 0
  drop_priv_before_exec = no
  executable = director
  extra_groups =
  fifo_listener login/proxy-notify {
    group =
    mode = 00
    user =
  }
  group =
  idle_kill = 4294967295 secs
  inet_listener {
    address =
    port = 0
    ssl = no
  }
  privileged_group =
  process_limit = 1
  process_min_avail = 0
  protocol =
  service_count = 0
  type =
  unix_listener director-admin {
    group =
    mode = 0600
    user =
  }
  unix_listener director-userdb {
    group =
    mode = 0600
    user =
  }
  unix_listener login/director {
    group =
    mode = 00
    user =
  }
  user = $default_internal_user
  vsz_limit = 18446744073709551615 B
}
service dns_client {
  chroot =
  client_limit = 1
  drop_priv_before_exec = no
  executable = dns-client
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol =
  service_count = 0
  type =
  unix_listener dns-client {
    group =
    mode = 0666
    user =
  }
  unix_listener login/dns-client {
    group =
    mode = 0666
    user =
  }
  user = $default_internal_user
  vsz_limit = 18446744073709551615 B
}
service doveadm {
  chroot =
  client_limit = 1
  drop_priv_before_exec = no
  executable = doveadm-server
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol =
  service_count = 1
  type =
  unix_listener doveadm-server {
    group =
    mode = 0600
    user =
  }
  user =
  vsz_limit = 18446744073709551615 B
}
service imap-login {
  chroot = login
  client_limit = 0
  drop_priv_before_exec = no
  executable = imap-login
  extra_groups =
  group =
  idle_kill = 0
  inet_listener imap {
    address =
    port = 143
    ssl = no
  }
  inet_listener imaps {
    address =
    port = 993
    ssl = yes
  }
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol = imap
  service_count = 1
  type = login
  user = $default_login_user
  vsz_limit = 64 M
}
service imap {
  chroot =
  client_limit = 1
  drop_priv_before_exec = no
  executable = imap
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 1024
  process_min_avail = 0
  protocol = imap
  service_count = 1
  type =
  unix_listener login/imap {
    group =
    mode = 0666
    user =
  }
  user =
  vsz_limit = 18446744073709551615 B
}
service ipc {
  chroot = empty
  client_limit = 0
  drop_priv_before_exec = no
  executable = ipc
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 1
  process_min_avail = 0
  protocol =
  service_count = 0
  type =
  unix_listener ipc {
    group =
    mode = 0600
    user =
  }
  unix_listener login/ipc-proxy {
    group =
    mode = 0600
    user = $default_login_user
  }
  user = $default_internal_user
  vsz_limit = 18446744073709551615 B
}
service lmtp {
  chroot =
  client_limit = 1
  drop_priv_before_exec = no
  executable = lmtp
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol = lmtp
  service_count = 0
  type =
  unix_listener lmtp {
    group =
    mode = 0666
    user =
  }
  user =
  vsz_limit = 0
}
service log {
  chroot =
  client_limit = 0
  drop_priv_before_exec = no
  executable = log
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 1
  process_min_avail = 0
  protocol =
  service_count = 0
  type = log
  user =
  vsz_limit = 18446744073709551615 B
}
service pop3-login {
  chroot = login
  client_limit = 0
  drop_priv_before_exec = no
  executable = pop3-login
  extra_groups =
  group =
  idle_kill = 0
  inet_listener pop3 {
    address =
    port = 110
    ssl = no
  }
  inet_listener pop3s {
    address =
    port = 995
    ssl = yes
  }
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol = pop3
  service_count = 1
  type = login
  user = $default_login_user
  vsz_limit = 64 M
}
service pop3 {
  chroot =
  client_limit = 1
  drop_priv_before_exec = no
  executable = pop3
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 1024
  process_min_avail = 0
  protocol = pop3
  service_count = 1
  type =
  unix_listener login/pop3 {
    group =
    mode = 0666
    user =
  }
  user =
  vsz_limit = 18446744073709551615 B
}
service ssl-params {
  chroot =
  client_limit = 0
  drop_priv_before_exec = no
  executable = ssl-params
  extra_groups =
  group =
  idle_kill = 0
  privileged_group =
  process_limit = 0
  process_min_avail = 0
  protocol =
  service_count = 0
  type = startup
  unix_listener login/ssl-params {
    group =
    mode = 0666
    user =
  }
  user =
  vsz_limit = 18446744073709551615 B
}
shutdown_clients = yes
ssl = yes
ssl_ca =
ssl_cert = </etc/ssl/certs/dovecot.pem
ssl_cert_username_field = commonName
ssl_cipher_list = ALL:!LOW:!SSLv2:!EXP:!aNULL
ssl_key = </etc/ssl/private/dovecot.pem
ssl_key_password =
ssl_parameters_regenerate = 168
ssl_verify_client_cert = no
submission_host =
syslog_facility = mail
userdb {
  args =
  driver = prefetch
}
userdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
valid_chroot_dirs =
verbose_auth = no
verbose_proctitle = no
verbose_ssl = no
version_ignore = no
protocol imap {
  mail_plugins = quota imap_quota
}

protocol pop3 {
  mail_plugin_dir = /usr/lib64/dovecot/modules/pop3
  mail_plugin_dir = /usr/lib64/dovecot/modules
  mail_plugins = quota
  pop3_uidl_format = %08Xu%08Xv
}

protocol lda {
  auth_socket_path = /var/run/dovecot/auth-master
  mail_plugin_dir = /usr/lib64/dovecot/modules
  mail_plugins = sieve quota
  postmaster_address = postmaster@example.com
}
long but works fine at least for me.
Reply With Quote
The Following 3 Users Say Thank You to dgonzalezh For This Useful Post:
CSsab (13th November 2011), falko (12th November 2011), till (13th November 2011)
  #9  
Old 13th November 2011, 16:21
CSsab CSsab is offline
Senior Member
 
Join Date: Apr 2010
Posts: 174
Thanks: 19
Thanked 32 Times in 27 Posts
Default

Hi .. I have mine working with a different dovecot.conf and sql but yours looks better researched so I'd like to try it.

What is your "/etc/dovecot/dovecot-sql.conf.ext" please.

Thanks in advance.
Reply With Quote
  #10  
Old 13th November 2011, 19:43
dgonzalezh dgonzalezh is offline
Junior Member
 
Join Date: Oct 2011
Posts: 4
Thanks: 0
Thanked 3 Times in 1 Post
 
Default

Quote:
Originally Posted by CSsab View Post
Hi .. I have mine working with a different dovecot.conf and sql but yours looks better researched so I'd like to try it.

What is your "/etc/dovecot/dovecot-sql.conf.ext" please.

Thanks in advance.
Well, dovecot-sql.conf, is basicallly the same as with 1.2, I just added it and it worked like a charm, check it out.

Code:
# If you wish to avoid two SQL lookups (passdb + userdb), you can use
# userdb prefetch instead of userdb sql in dovecot.conf. In that case you'll
# also have to return userdb fields in password_query prefixed with "userdb_"
# string. For example:
#password_query = SELECT userid as user, password, home as userdb_home, uid as userdb_uid, gid as userdb_gid FROM users WHERE userid = '%u'

driver = mysql
connect = host=db.dghvoip.com dbname=dbispconfig user=ispconfig password=xxxxxxxxxxxxxxxx
default_pass_scheme = CRYPT

password_query = SELECT password FROM mail_user WHERE login = '%u' AND disable%Ls = 'n'
# user_query = SELECT email AS user, maildir AS home, CONCAT('*:storage=', quota , 'B') AS quota_rule FROM mail_user WHERE login = '%u' AND disable%Ls = 'n'
user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
It's the same as the one Dovecot creates; though I haven't been able to diagnose a problem in which postfix or dovecot reports that it can't find auth, though for school stuff I can't dig much into it now but I'' keep y'all posted.

Thanks for your reply.
Reply With Quote
Reply

Bookmarks

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SOS,Can not receive mail! jason.cn Installation/Configuration 1 4th May 2011 17:38
SquirrelMail login not working glenneh Installation/Configuration 13 9th April 2011 20:01
Perfect server... ISPConfig trashing dovecot config krissie HOWTO-Related Questions 2 30th June 2010 10:38
ISPConfig installation into multiple OpenVZ containers letezo Installation/Configuration 11 3rd March 2009 22:47
ISPconfig Dovecot problem dolmax General 2 15th March 2008 13:17


All times are GMT +2. The time now is 07:12.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.