Hi I've been able to easily and quickly search with an email client, and via an IMAP conversation (telnet localhost imap). This DBmail 3.0.2 release otherwise seems to work according to my current modest investigation.
I've been looking for a while now and haven't been able to figure out how to do it using *dbmail-export*. My goal is to search for all mail in user db1's Inbox (10,117 messages), having a Subject containing *some-string* . My attempts are generally of the form * dbmail-export *-u db1 -m Inbox -s '1:* *[some other stuff which is wrong]*' -b /tmp Every time I run a search command line candidate I end up with 10,117 messages exported into /tmp/db1/INBOX.mbox . Please publish a sample command line which searches for the string '*600' *(without quotes)* *in a message Subject. Here is sample command & output from my wrongly coded effort: *$ rm -rfv /tmp/db1; dbmail-export -u db1 -m Inbox -s '1:* HEADER SUBJECT 600' -b /tmp* removed `/tmp/db1/INBOX.mbox' removed directory: `/tmp/db1' Exporting [1] mailboxes for [db1] export mailbox INBOX -> /tmp/db1/INBOX.mbox [warn] event_del: event has no event_base set. [warn] event_del: event has no event_base set. *$ grep '^Subject:' /tmp/db1/INBOX.mbox | wc -l* 10117 *$ uname -a* Linux dbmail1.localdomain 2.6.32-358.18.1.el6.centos.plus.x86_64 #1 SMP Wed Aug 28 16:14:04 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux *$ cat /etc/centos-release* CentOS release 6.4 (Final) I've tried a lot of other permutations but of course they were all wrong. */etc/dbmail.conf* settings *[DBMAIL] * * driver = mysql* * authdriver = sql* * host = localhost* * sqlport = * * sqlsocket = * * user = dbmail * * pass = dbmail* * db = dbmail * * table_prefix = dbmail_ * * encoding = utf8* * default_msg_encoding = utf8* * sendmail = /usr/sbin/sendmail * * file_logging_levels = 7* * syslog_logging_levels = 31* * query_time_info = 10* * query_time_notice = 20* * query_time_warning = 30* * query_timeout = 300 * * effective_user = nobody* * effective_group = nobody* * bindip = 0.0.0.0 # IPv4 only - all IP's* * timeout = 300 * * login_timeout = 60* * resolve_ip = no* * authlog = no* * logfile = /var/log/dbmail.log * * errorlog = /var/log/dbmail.err * * pid_directory = /var/run* * tls_cafile =* * tls_cert =* * tls_key =* * tls_ciphers =* *[LMTP]* * port = 24 * *[POP]* * port = 110* * pop_before_smtp = no * *[HTTP]* * port = 41380* * bindip = 127.0.0.1* * admin = admin:secret* *[IMAP]* * port = 143 * * timeout = 4000 * * imap_before_smtp = no * *[SIEVE]* * port = 2000 * * tls_port =* *[LDAP]* * port = 389* * version = 3* * hostname = ldap* * base_dn = ou=People,dc=mydomain,dc=com* * bind_dn = * * bind_pw = * * scope = SubTree* * referrals = yes* * 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* * field_mail = mail* * field_quota = mailQuota* * field_fwdtarget = mailForwardingAddress* *[DELIVERY]* * SIEVE = yes * * SUBADDRESS = yes * * SIEVE_VACATION = yes * * SIEVE_NOTIFY = yes* * SIEVE_DEBUG = no * * AUTO_NOTIFY = no* * * * AUTO_REPLY = no* * suppress_duplicates = no*
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
