stfix/pipe[32280]: 875CAC14159:
to=<[EMAIL PROTECTED]>, relay=dbmail-smtp, delay=13, delays=13/0/0/0.05,
dsn=2.0.0, status=sent (delivered via dbmail-smtp service)
Aug 14 10:30:47 db1 postfix/qmgr[24856]: 875CAC14159: removed
As said before, this happens a couple of time, until
postfix gives up.
Well, I most likely made a newbie misstake, like maybe
I have to tell dbmail for which domains it should accept
emails instead of just creating an alias [EMAIL PROTECTED],
anyhow I hope you can give me a hand.
Kind regards,
Daniel Urstöger
___
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Hello Marc,
thanks for helping, well actually I somehow
broke the user within the database, so postfix
thought it was there but dbmail couldn´t deliver
it at all.
so that problem is fixed now, and since I had some
time with dbmail and postfix, I am putting together
a tutorial on kb.gosi.at :)
G
.
cheers,
Daniel Urstöger
Paul J Stevens schrieb:
Then why do I keep hearing noises on this list that JOINs are faster
than sub-SELECTS ??
Michael Monnerie wrote:
Hello, I found this message in my log, the query was run from
dbmail-util:
dbmail/maintenance[10985]: Warning:[db] dbmodule.c
Hello people,
I am currently developing a web interface for accessing emails
within dbmail directly through that web site, something like Horde or
Roundcube but specifically for dbmail.
Reading access is handled directly via SQL and changing stuff I mainly
handle via IMAP.
Two questions have came
Paul J Stevens schrieb:
> Daniel Urstöger wrote:
>> Hello people,
>>
>> I am currently developing a web interface for accessing emails
>> within dbmail directly through that web site, something like Horde or
>> Roundcube but specifically for dbmail.
>> Rea
Paul J Stevens schrieb:
> Daniel Urstöger wrote:
>
>> yes, I will have to update my script accordingly, it just gives me
>> quite an advantage accessing the data directly via SQL and not havening
>> IMAP as intermediate layer, performance wise.
>
> Misconception.
Aaron Stone schrieb:
> On Mon, 2007-10-01 at 16:58 +0200, Daniel Urstöger wrote:
>> Paul J Stevens schrieb:
>>> Daniel Urstöger wrote:
>
> [snip]
>> PHP offers a native module, I would have to test though if that is
>> faster then working with IMAP. Though the
Paul J Stevens schrieb:
> Daniel Urstöger wrote:
>
>>>>> That's correct. Forwarded is not a supported flag (yet).
>>>> Okay, so how does a mail client recognize this? via an IMAP command to?
>>> yep: the PERMANENTFLAGS line of the SELECT respons
Aaron Stone schrieb:
> On Mon, Oct 1, 2007, Daniel Urstï¿œger <[EMAIL PROTECTED]> said:
>
>> Aaron Stone schrieb:
>>> On Mon, 2007-10-01 at 16:58 +0200, Daniel Urstöger wrote:
Paul J Stevens schrieb:
> Daniel Urstöger wrote:
>
> [snip more]
> A typical IMAP call to retrieve such in
Hi Aaron,
yes I would like that kind of feature too, though I have implemented
it already in my web based client for dbmail: the maintenance scripts
that are running check the users current quota and sends them a
warning message as soon as they hit the 90% border.
It would be nice though if you k
Hi Paul,
this is great!
Thanks for your time. Around xmas now I have something to test
and play around with.
greetings,
Daniel
Paul J Stevens schrieb:
>
> Hi all,
>
> I'm very proud to announce the availability of DBMail 2.3.0, the first of the
> new development series.
_
Hi Jorge,
but all with the same file size? I wonder if the guys are implementing
some kind
of checksum too, then it won´t matter at all, I assume...
greetings,
Daniel
Jorge Bastos schrieb:
> It isn't impossible
> For images for example, i have many many images that have the name
> "logo.jpg"
Hello Simon,
one question: all your mysql servers are handling inserts?
or just the first master of your circle?
cheers,
Daniel
Simon Lange schrieb:
> Disagree. Mysql clustering and even the circle-replication method works like
> charme with dbmail. How does it sound to you if I tell that sever
Hello,
well, I just tried it and confirm this happens with v.2.2.8
(set everything to UTF8), for POP and IMAP login.
on POP this happens:
+OK DBMAIL pop3 server ready to rock
user XXX
+OK Password required for XXX
pass äqwert1
-ERR your command does not compute
quit
+OK see ya later
on IMAP:
Casper Langemeijer wrote:
Secondly, how are you going to spamfilter 1000 mails a second?
I was wondering the same. Not with amavis/clam/spamassassin for sure.
well it certainly is possible, but question is with what kind of
hardware. I got some figures here:
I have 2 servers from that poi
It would be nice if all new accounts created had this folder by default - is
this possible?
For that you prolly want to add a so called trigger to your database
scheme, so if a new user is created, automagically the mailbox of your
choosing will be added to the user too.
Maybe Paul has even
Paul J Stevens schrieb:
Michael Monnerie wrote:
Error:[sql] dbpgsql.c,db_query(+287): query failed [INSERT INTO
dbmail_headername (headername) VALUES
('x-valkarton-mailscanner-spamscore')] : [FEHLER: duplizierter
Schlüssel verletzt Unique-Constraint »dbmail_headername_1« ]
How could this h
It will abort the header-caching.
so not much of an issue, right?
And why do you store the headername and headervalue for an email in an
extra table? is that for better performance for the IMAP daemon when
just fetching a few flags or has that another purpose?
This was discussed at great l
Hi James,
well you can start with the tutorial I have written here:
http://kb.gosi.at/content/16/20/en/dbmail-mysql-postfix-smtp-auth-via-sasl2-debian-etch.html
but that one doesn´t cover LDAP, still it should give you working SASL
and proper postfix setup.
greetings,
Daniel
___
On Wed, 2008-05-14 at 13:32 +0200, Michael Mayer wrote:
But who could have such a large mailbox? Anyone here on this list?
Then,
you should think about creating an archive ;)
My Inbox has 36,881 messages right now. DBMail holds up quite well for
me. Personal stress test, eating my own dog f
Hi,
I just wanted to add that Mac Mail does open more then one connection
based on this behavior too. So if you browse around your IMAP folders
one could have around 5 or more connections at once ...
greetings,
Daniel
Am 28.06.2008 um 02:51 schrieb Jake Anderson:
if its an issue install imap
Hi Uwe,
that is the new DB library dbmail 2.3 is using:
http://www.tildeslash.com/libzdb/
Cheers,
Daniel
Am 19.08.2008 um 21:19 schrieb Uwe Kiewel:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I want to play with dbmail v2.3 but, what to the hell is ZDB?!
[EMAIL PROTECTED] dbmail-2.3
Hi there,
one question I couldn´t figure out myself:
is it possible to bind one of the daemons to localhost?
As I have lmtp, imap and pop running and of course I
wouldn´t want to have lmtp to be reachable from outside.
At the moment I have fixed this with iptables but it would
be nice if there w
Thanks Uwe, works like a charm!
greetings,
Daniel
Am 02.09.2008 um 17:42 schrieb Uwe Kiewel:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daniel Urstöger schrieb:
Hi there,
one question I couldn´t figure out myself:
is it possible to bind one of the daemons to localhost?
As I have lmtp
Hi there,
I have one more question:
the webmail system I wrote is almost done but at the moment I have
something that is not really working as I would like it too: checking
for
new messages. I do that by polling the database for it, but I suppose
you guys have a nice way to fix that via a tri
setup querries"? You
hacked the dbmail source code in a way so it does an extra
query on a message insertion?
greetings,
Daniel
Am 03.09.2008 um 14:36 schrieb Paul J Stevens:
Daniel Urstöger wrote:
Hi there,
I have one more question:
the webmail system I wrote is almost done but at the mom
well, good that dbmail is open source(d)!
For the webmail thing I only need to update
on new messages and the user doesn´t have
IMAP access so I think for me hacking the
dbmail-lmtp should be enough, rigth?
greetings,
Daniel
Am 03.09.2008 um 14:57 schrieb Paul J Stevens:
Daniel Urstöger
working with 2.2.
greetings,
Daniel
Am 03.09.2008 um 15:44 schrieb Paul J Stevens:
Daniel Urstöger wrote:
well, good that dbmail is open source(d)!
For the webmail thing I only need to update
on new messages and the user doesn´t have
IMAP access so I think for me hacking the
dbmail-lmtp should be
Yeah Sim, MySQL works great together with dbmail so far
and actually MySQL has grown up over the past few years
and putting it into the "amateurs corner" is just not correct ...
And for solving this I actually patched dbmail, as Peter
suggested and it works very well so far - yay for Open Source!
This is the explain:
++-++---
+-+-
+-+--+-+-+
| id | select_type | table | type |
possible_keys | key |
Am 24.10.2008 um 16:07 schrieb Giulio Ferro:
Daniel Urstöger wrote:
Here is the funny thing:
select messageblk_idnr from dbmail_messageblks where
physmessage_id=xxx order by messageblk_idnr;
==> takes about 0.05 sec
SELECT messageblk, is_header FROM dbmail_messageblks WH
Well, I read through monty´s blog post and yes it doesn´t seems to be adviseable using MySQL 5.1 at the moment.Nevertheless I did migrate one of our MySQL boxes to 5.1 and for now it seems to work fine:The box does run dbmail 2.2.10 and some other things and as you see it does around 15 to 17000que
Hello,
iirc this feature is very much proprietary to Microsoft Exchange and
is not included in any other mail server.
That is the feature you are talking about: http://office.microsoft.com/en-us/outlook/HA010917601033.aspx
right?
cheers,
Daniel
Am 04.12.2008 um 17:14 schrieb Michael Monne
On Sonntag 14 Dezember 2008 Paul J Stevens wrote:
relies on foreign keys to remove the dependent data, or a
subsequent run of dbmail-util to clean out the disconnected parts.
That's a totally reasonable expectation on both counts -- Paul
added foreign keys in the 2.2 schemas, and if they're missi
Hi there,
I assume you are using Blackberry Enterprise Server (BES) and this one
does have support for IMAP, which is something you get from dbmail.
Direct integration offered by RIM for Microsoft Exchange and Lotus
Notes is not available atm. Also IMAP support in BES is very basic and
fund
Mohd Rasfan:
I heard some push email opensource forgot the link at myoffice I
will post tomorrow any idea to replace this BES or BIS
Sent from 7crewz BlackBerry®
-Original Message-
From: Daniel Urstöger
Date: Fri, 2 Jan 2009 20:39:08
To: DBMail mailinglist
Subject: Re: [Dbmail] Push
I think your best bet is a script that creates the mailboxes that
you know
your users will need.
Aaron
I have to agree!
Been there last year and had exactly the same issue with Outlook. No
matter if you have 2003 or 2007, they are all the same.
Ended up pre-creating the folders so Outlo
use this for mysql:
DROP TRIGGER IF EXISTS dbmail_mailboxes_autocreate;
CREATE TRIGGER dbmail_mailboxes_autocreate AFTER INSERT ON
dbmail_users
FOR EACH ROW
insert into dbmail_mailboxes (owner_idnr,name) values
(NEW.user_idnr,'INBOX'),
And one more thing,
How did you get outlook to "accept" them as special folders? Most
luck I'm having with Sent Items, this I can find, where to
configure. But what about drafts? Deleted Items? What am I missing?
Cheers,
Matiss
That was quite easy to figure out: you just need to test wh
Jorge Bastos wrote:
And if in a later version, maybe 3.x, DBMail had an integration with
openchange?
Never!
:) was just an idea Paul, don't get mad at me :P
Well, I agree that Microsoft Outlook does great with emails and
calendar, but only with their own server implementation.
What
Talking about breaking the RFC, I wonder if I got this wrong or right:
the plan is to put another interface to the database via the dbmail
daemon,
that would offer that as additional functionality, right?
So actually inside the database the message will not get altered in
any way,
so I can see
> Daniel Urstöger wrote:
>> Talking about breaking the RFC, I wonder if I got this wrong or
>> right:
>> the plan is to put another interface to the database via the dbmail
>> daemon,
>> that would offer that as additional functionality, right?
>
> Well,
Hi Daniel,
as long as you do not run dbmail-util the messages are still in the
database.
I guess you can restore them by connecting them to a new/existing user,
but that will require fidling in the database directly.
afaik there is no undelete in dbmail, so, you have to do the "dirty"
work yo
Hi Daniel,
well, let´s take a look, do you know which user id the user had you
deleted?
mailbox_idnr would actually be even better, but I guess you have no
clue about that, right?
greetings,
Daniel
___
DBmail mailing list
DBmail@dbmail.org
http://ma
Hi Daniel,
well the mailboxes also got deleted, I guess, so you can look in the
table
messgages for entries with "deleted_flag" set to 1 and those should be
the messages.
greetings,
Daniel
___
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastx
Hi there,
well you create a new user, see what mailbox_idnr his INBOX has,
and then you connect the messages with deleted_flag to that mailbox.
After that you set the deleted_flag to 0 and well, there should be
your messages.
greetings,
Daniel
___
DBmai
- From capability:
QUOTA NAMESPACE AUTH=CRAM-MD5 AUTH=NTLM AUTH=DIGEST-MD5 IDLE UIDPLUS
IMAP4REV1
To capability:
QUOTA NAMESPACE IDLE THREAD=ORDEREDSUBJECT AUTH=LOGIN ACL UNSELECT
SORT CHILDREN IMAP4
IMAP4REV1
Hi Harald,
in /etc/dbmail.conf you find/could add:
capability = IMAP4 IMA
I tried this few days ago, but thsi did not work
"capability" was published to imapsync as written in config-file but
no success
I have stroed my passwords as cleartext for some other reasons
Hi there,
you are sure that your dbmail/dbmail-imap is giving out the correct
capabilities? I m
> Yes i'm sure, imapsync shows something like the following while
> connecting
> IMAP4rev1 SASL-IR SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL
> + IDLE CHILDREN
> NAMESPACE LOGIN-REFERRALS UIDPLUS LIST-EXTENDED I18NLEVEL=1 STARTTLS
> AUTH=LOGIN AUTH=PLAIN
> AUTH=CRAM-MD5 AUTH=DIGEST-M
I jump out of the window now
That isn´t a solution ^^
We patched the dbmail-source to allow mailadress with '@' or '%' as
password because this
f**g fallback is set by the most customers because problems with @-
char years ago
dovecot runs well BUT after debug on:
Aug 10 22:22:15 localho
> Not *that* simple, but I did it nonetheless. My GIT master tree now
> supports AUTH=CRAM-MD5.
>
> This will however *only* work for people using authsql and plaintext
> passwords.
Thanks very much Paul!
___
DBmail mailing list
DBmail@dbmail.org
http:/
just installed it ... everything fine so far!
Thanks Paul :)
Am 10.11.2009 um 11:42 schrieb Aleksander Kamenik:
> Paul J Stevens wrote:
>> I just uploaded 2.2.13.
>>
>> I won't have time today for formal announcements. debian/stable debs are
>> forthcoming though.
>>
>> FYI, this release main
Hi Peter,
I hope someone of the dev team can clear this up, I just remember this vaguely
from developing my webmail client:
quoting the wikipedia article about MIME:
"encoding can be either "Q" denoting Q-encoding that is similar to the
quoted-printable encoding, or "B" denoting base64 encodin
I do not want to add to this quite "hot" situation, but there are two things
worth mentioning:
> * I'd like to see impact-free daily backups for filesystem-based
> systems. With dbmail, just have a slave replica you can pause
> replication on to get a perfect snapshot, with no impact on the live
Never claimed it does ;)
Just saying that for bigger datasets it becomes more and more useless
but with Sphinx it remains blazing fast. So, for dbmail that would be
a nice to have feature ...
Am 11.12.2009 um 01:07 schrieb Michael Monnerie
:
> On Freitag, 11. Dezember 2009 Daniel Urstö
al copies. Then searches don't
> impact the servers :)
>
> On Fri, 2009-12-11 at 01:00 +0100, Daniel Urstöger wrote:
>> I do not want to add to this quite "hot" situation, but there are
>> two things worth mentioning:
>>
>>> * I'd like to see
My message was not quite finished, sadly there isnt an App for that ;)
> I have found that since linux kernel 2.6 series, LVM snapshots have
> caused system lockups. I used it happily in the 2.4 series. Besides
> that, I did mention *impact-free*. Adding a snapshot and reading
> from a
> snapsho
> Not quite. Having a separate slave database server to do the heavy
> work
> of backups has no impact on the master database during the backup
> period. Therefore the master database is always at "normal speed".
Well, one can also do that with a filesystem based storage, you just
need someth
Hi Simon,
I have switched to Percona patches quite a while ago, as comparing it to out of
stock MySQL gave me a performance gain of 5-15%, depending on the application.
For dbmail it was a bit more than 10% for a database size of round about 30GB.
To be honest though: I never looked back, so wh
> Any other Iphone user having simalar problems?
Well, actually not. I use dbmail 2.2.x with my iPhone at least since the 3G
iPhone.
But I don´t have that many sub folders on that account, about 10,
so I wouldn´t call myself a heavy user on that feature. Worked flawlessly
though ...
Kind regar
I wanted to add one of the solutions that work very well for me: ASSP
http://assp.sourceforge.net/
A open source anti spam tool written in perl, that includes a lot of ways to
fight spam.
You may choose yourself which ones you would like to use or not. It works as a
proxy in front of your MTA,
I think what you need to look into is SRS:
http://de.wikipedia.org/wiki/Sender_Rewriting_Scheme
Kind regards,
Daniel
Am 10.01.2011 um 05:20 schrieb Reindl Harald:
> Additional info:
>
> http://en.wikipedia.org/wiki/Email_forwarding
>
>> In the Sender Policy Framework (SPF), the domain-name in
>>
>>
> Do you know any tool that can copy the full IMAP folders & messages in a
> increment way to another account?
imapsync is able to do that.
___
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Well, you can change the tables live and add the key constraints, etc.
But I wonder if that doesn´t end up in desaster for some reason.
I would dump the database without the table structures, just the data.
Empty the database, create the tables with the scripts from dbmail tar ball.
Make sure they
> Anyone with an iPhone willing to help us test this?
Got every single iPhone model here as well as around 20 different Android
devices,
what exactly needs to be tested? IMAP access to latest dbmail 3?
Greetings,
Daniel
___
DBmail mailing list
DBmail@d
> "Daniel Urstöger" schreef:
>
>>> Anyone with an iPhone willing to help us test this?
>>
>> Got every single iPhone model here as well as around 20 different
>> Android devices,
>> what exactly needs to be tested? IMAP acces
Hi Daniel,
just came to my mind: did you run dbmail util on your orginal storage/version?
Maybe there is a problem in the dataset that might get fixed this way?
Otherwise I think you have to wait till Paul gets on this topic.
Greetings,
Daniel
Am 22.05.2012 um 15:02 schrieb Daniel Schütze:
> A
Hi Simon,
I can feel your pain. One of my customers runs roughly 25-30 Apple clients
(Macs, iPhones, iPads, etc.) against dbmail 2.x and I havent seen any problem
like the two you described.
I am sure Paul will give it a shot but you need to provide him with the proper
logs for him to be able
DBMA is old school software. It was developed long before version 3.0 was in
sight,
so the database scheme DBMA expects is from dbmail version 2.0, that is why it
fails on version 3.0.
So you basically cannot use dbmail 3.0 with DBMA, as long as DBMA doesn´t get
the update for that.
There are
69 matches
Mail list logo
