hi,
Resending post due not seen it coming out and no answers!
I'am doing DBMAIL + Ubuntu 14.04 LTS + apacheDS (LDAP)
installation and instruction to Ubuntu Help.
Those are notes how I got everything running, at moment
only problem's,... and no instruictions.
joni
-------- Forwarded Message --------
From: Joni-Pekka Kurronen <joni.kurro...@gmail.com>
To: dbmail@dbmail.org
Subject: Ubuntu 14.04 LTS + Mariadb + ApacheDS + Postfix +DBMAIL ,
configuration help needed !!
Date: Wed, 24 Sep 2014 21:48:21 +0300
hi,
Below you find ERROR's and LOG's. After that dmail.conf and ApacheDS
config.
root@mpi1:/mpi3/S4/dbmail/dbmail-3.1.17/doc# dbmail-users -a joonas2 -w
password
> Adding INBOX for new user... failed... removing user... done.
> Command failed.
> root@mpi1:/mpi3/S4/dbmail/dbmail-3.1.17/doc#
That I get,...
joni
===
> sendto(3, "\10\0\0\0\3COMMIT;", 12, 0, NULL, 0) = 12
> recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 16384, 0, NULL, NULL) = 11
> poll([{fd=3, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
> sendto(3, "\5\0\0\0\31\n\0\0\0", 9, 0, NULL, 0) = 9
> sendto(9, "<19>Sep 24 21:28:42 dbmail/user["..., 112, MSG_NOSIGNAL, NULL, 0)
> = 112
> write(1, "done.", 5) = 5
> write(1, "\n", 1) = 1
> sendto(7, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
> shutdown(7, SHUT_RDWR) = 0
> close(7) = 0
> sendto(6, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
> shutdown(6, SHUT_RDWR) = 0
> close(6) = 0
> sendto(5, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
> shutdown(5, SHUT_RDWR) = 0
> close(5) = 0
> sendto(4, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
> shutdown(4, SHUT_RDWR) = 0
> close(4) = 0
> sendto(3, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
> shutdown(3, SHUT_RDWR) = 0
> close(3) = 0
> futex(0x94b62c, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x94b628, {FUTEX_OP_SET, 0,
> FUTEX_OP_CMP_GT, 1}) = 1
> futex(0x7f66bb8779d0, FUTEX_WAIT, 21580, NULL) = -1 EAGAIN (Resource
> temporarily unavailable)
> write(2, "Command failed.\n", 16Command failed.
> ) = 16
> exit_group(-1) = ?
> +++ exited with 255 +++
> root@mpi1:/mpi3/S4/dbmail/dbmail-3.1.17/doc# dbmail-users -a joonas2 -w wibaa
> Adding INBOX for new user... failed... removing user... done.
> Command failed.
> root@mpi1:/mpi3/S4/dbmail/dbmail-3.1.17/doc#
>
===
logs
===mail.log
Sep 24 21:28:52 mpi1 dbmail/user[21581]: Error:[db]
user_idnr_is_delivery_user_idnr(+967): error looking up user_idnr for
__@!internal_delivery_user!@__
Sep 24 21:28:52 mpi1 dbmail/user[21581]: Error:[db] db_createmailbox(+2460):
unable to find or create sql shadow account for useridnr [10000]
Sep 24 21:28:53 mpi1 dbmail/user[21581]: Error:[auth] auth_delete_user(+1089):
sql shadow account deletion failed
===mail.err
Sep 24 21:28:52 mpi1 dbmail/user[21581]: Error:[db]
user_idnr_is_delivery_user_idnr(+967): error looking up user_idnr for
__@!internal_delivery_user!@__
Sep 24 21:28:52 mpi1 dbmail/user[21581]: Error:[db] db_createmailbox(+2460):
unable to find or create sql shadow account for useridnr [10000]
Sep 24 21:28:53 mpi1 dbmail/user[21581]: Error:[auth] auth_delete_user(+1089):
sql shadow account deletion failed
===dbmail.conf
# (c) 2000-2006 IC&S, The Netherlands
#
# Configuration file for DBMAIL
[DBMAIL]
#
# Database settings
#
# database connection URI
#dburi = sqlite:///var/tmp/dbmail.db
dburi =
mysql://localhost:3306/dbmail?user=dbmail&password=dbmail73
#
# Supported drivers are sql, ldap.
#
authdriver = ldap
#
#
# following fields are now DEPRECATED!
#driver =
#host =
#sqlport =
#sqlsocket =
#user =
#pass =
#db =
#
# Number of database connections per threaded daemon
# This also determines the size of the worker threadpool
#
# Do NOT increase this without proper consideration. A
# very large database/worker pool will not only increase
# the connection pressure on the database, but will more
# significantly cause unnecessary context-switching in
# your CPUs.
#
#max_db_connections = 10
#
# Table prefix. Defaults to "dbmail_" if not specified.
#
table_prefix = dbmail_
#
# encoding must match the database/table encoding.
# i.e. latin1, utf8
encoding = utf8
#
# messages with unknown encoding will be assumed to have
# default_msg_encoding
# i.e. iso8859-1, utf8
default_msg_encoding = utf8
#
# Postmaster's email address for use in bounce messages.
#
#postmaster = DBMAIL-MAILER
#
# Sendmail executable for forwards, replies, notifies, vacations.
# You may use pipes (|) in this command, for example:
# dos2unix|/usr/sbin/sendmail works well with Qmail.
# You may use quotes (") for executables with unusual names.
#
sendmail = /usr/sbin/sendmail
#
#
# The following items can be overridden in the service-specific
sections.
#
#
#
# Logging via stderr/log file and syslog
#
# Logging is broken up into 8 logging levels and each level can be
indivually turned on or off.
# The Stderr/log file logs all entries to stderr or the log file.
# Syslog logging uses the facility mail and the logging level of the
event for logging.
# Syslog can then be configured to log data according to the levels.
#
# Set the log level to the sum of the values next to the levels you want
to record.
# 1 = Emergency
# 2 = Alert
# 4 = Critical
# 8 = Error
# 16 = Warning
# 32 = Notice
# 64 = Info
# 128 = Debug
# 256 = Database -> Logs at debug level
#
# Examples: 0 = Nothing
# 31 = Emergency + Alert + Critical + Error + Warning
# 511 = Everything
#
file_logging_levels = 7
#
syslog_logging_levels = 31
#
# Generate a log entry for database queries for the log level at number
of seconds of query execution time.
#
query_time_info = 10
query_time_notice = 20
query_time_warning = 30
#
# Throw an exception is the query takes longer than query_timeout
seconds
query_timeout = 300
#
# Root privs are used to open a port, then privs
# are dropped down to the user/group specified here.
#
effective_user = nobody
effective_group = nogroup
#
# The IPv4 and/or IPv6 addresses the services will bind to.
# Use * for all local interfaces.
# Use 127.0.0.1 for localhost only.
# Separate multiple entries with spaces ( ) or commas (,).
#
#bindip = 0.0.0.0 # IPv4 only - all IP's
bindip = :: # IPv4 and IPv6 - all IP's (linux)
#bindip = :: # IPv6 only - all IP's (BSD)
#bindip = 0.0.0.0,:: # IPv4 and IPv6 - all IP's (BSD)
#
# The maximum length of the queue of pending connections. See
# listen(2) for more information
#
# backlog = 128
#
# Idle time allowed before a connection is shut off.
#
timeout = 300
#
# Idle time allowed before a connection is shut off if you have not
logged in yet.
#
login_timeout = 60
#
# If yes, resolves IP addresses to DNS names when logging.
#
resolve_ip = no
#
# If yes, keep statistics in the authlog table for connecting users
#
authlog = no
#
# logfile for stdout messages
#
logfile = /var/log/dbmail.log
#
# logfile for stderr messages
#
errorlog = /var/log/dbmail.err
#
# directory for storing PID files
#
pid_directory = /var/run
#
# directory for locating libraries (normally has a sane default
compiled-in)
#
library_directory = /usr/lib/dbmail
#
# SSL/TLS certificates
#
# A file containing a list of CAs in PEM format
tls_cafile = /etc/apache2/SSL/root.crt
# A file containing a PEM format certificate
tls_cert = /etc/apache2/SSL/kurrola.dy.fi.crt
# A file containing a PEM format RSA or DSA key
tls_key = /etc/apache2/SSL/kurrola.dy.fi.2014.insecure
# A cipher list string in the format given in ciphers(1)
tls_ciphers =
# hashing algorithm. You can select your favorite hash type
# for generating unique ids for message parts.
#
# for valid values check mhash(3) but minus the MHASH_ prefix.
#
# if you ever change this value run 'dbmail-util --rehash' to
# update the hash for all mimeparts.
#
# examples: MD5, SHA1, SHA256, SHA512, TIGER, WHIRLPOOL
#
# hash_algorithm = SHA1
# header_cache tuning
#
# set header_cache_readonly to 'yes' to prevent new
# unknown header-names from being cached.
#
# header_cache_readonly = yes
[LMTP]
port = 24
#tls_port =
[POP]
port = 110
#tls_port = 995
# You can set an alternate banner to display when connecting to the
service
# banner = DBMAIL pop3 server ready to rock
#
# If yes, allows SMTP access from the host IP connecting by POP3.
# This requires addition configuration of your MTA
#
pop_before_smtp = no
[HTTP]
port = 41380
#
# the httpd daemon provides full access to all users, mailboxes
# and messages. Be very careful with this one!
bindip = 192.168.0.20
admin = joonas:aptk#7315
[IMAP]
# You can set an alternate banner to display when connecting to the
service
# banner = imap 4r1 server (dbmail 2.3.x)
#
# Port to bind to.
#
port = 143
#tls_port = 993
#
# IMAP prefers a longer timeout than other services.
#
timeout = 4000
#
# If yes, allows SMTP access from the host IP connecting by IMAP.
# This requires addition configuration of your MTA
#
imap_before_smtp = no
#
# during IDLE, how many seconds between checking the mailbox
# status (default: 30)
#
# idle_timeout = 30
# during IDLE, how often should the server send an '* OK' still
# here message (default: 10)
#
# the time between such a message is idle_timeout * idle_interval
# seconds
#
# idle_interval = 10
#
# Provide a CAPABILITY to override the default
#
# capability = IMAP4 IMAP4rev1 AUTH=LOGIN ACL RIGHTS=texk NAMESPACE
CHILDREN SORT QUOTA THREAD=ORDEREDSUBJECT UNSELECT IDLE
# max message size. You can specify the maximum message size
# accepted by the IMAP daemon during APPEND commands.
#
# Supported formats:
# decimal: 1000000
# octal: 03777777
# hex: 0xfffff
#
# max_message_size =
[SIEVE]
#
# Port to bind to.
#
port = 2000
tls_port =
[LDAP]
port = 10389
version = 3
hostname = localhost
base_dn = ou=users,dc=security,dc=kurrola,dc=fi
#
# If your LDAP library supports ldap_initialize(), then you can use the
# alternative LDAP server DSN like following.
#
# URI = ldap://127.0.0.1:389
# URI = ldapi://%2fvar%2frun%2fopenldap%2fldapi/
#
# Leave blank for anonymous bind.
# example: cn=admin,dc=mydomain,dc=com
#
bind_dn = uid=admin,ou=users,dc=security,dc=kurrola,dc=fi
#
# Leave blank for anonymous bind.
#
bind_pw = adminpassword
scope = SubTree
# AD users may want to set this to 'no' to disable
# ldap referrals if you are seeing 'Operations errors'
# in your logs
#
referrals = no
user_objectclass = top,account,dbmailUser
forw_objectclass = top,account,dbmailForwardingAddress
cn_string = uid
field_passwd = userPassword
field_uid = uid
field_nid = uidNumber
min_nid = 10000
max_nid = 15000
field_cid = gidNumber
min_cid = 10000
max_cid = 15000
# a comma-separated list of attributes to match when searching
# for users or forwards that match a delivery address. A match
# on any of them is a hit.
field_mail = mail
# field that holds the mail-quota size for a user.
field_quota = mailQuota
# field that holds the forwarding address.
field_fwdtarget = mailForwardingAddress
# override the query string used to search for users
# or forwards with a delivery address.
# query_string = (mail=%s)
[DELIVERY]
#
# Run Sieve scripts as messages are delivered.
#
SIEVE = yes
#
# Use 'user+mailbox@domain' format to deliver to a mailbox.
#
SUBADDRESS = yes
#
# Turn on/off the Sieve Vacation extension.
#
SIEVE_VACATION = yes
#
# Turn on/off the Sieve Notify extension
#
SIEVE_NOTIFY = yes
#
# Turn on/off additional Sieve debugging.
#
SIEVE_DEBUG = no
# Use the auto_notify table to send email notifications.
#
AUTO_NOTIFY = no
#
# Use the auto_reply table to send away messages.
#
AUTO_REPLY = no
#
# Defaults to "NEW MAIL NOTIFICATION"
#
#AUTO_NOTIFY_SUBJECT =
#
# Defaults to POSTMASTER from the DBMAIL section.
#
#AUTO_NOTIFY_SENDER =
# If you set this to 'yes' dbmail will check for duplicate
# messages in the relevant mailbox during delivery using
# the Message-ID header
#
suppress_duplicates = no
#
# Soft or hard bounce on over-quota delivery
#
quota_failure = hard
# end of configuration file
==== LDAP
dn: ou=users,dc=security,dc=kurrola,dc=fi
objectClass: organizationalUnit
objectClass: top
ou: users
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
