I second that, though now I just got a bunch of work to do over the Christmas
break.
--
David A. Niblett | email: niblet...@gru.com
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: db
Message-
From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of
larrytek7
Sent: Tuesday, September 21, 2010 2:29 PM
To: dbmail@dbmail.org
Subject: Re: [Dbmail] Database Size (messageblks)
Niblett, David A wrote:
>
> The only way you can usually get a Postg
The only way you can usually get a Postgres DB table to go down to the actual
size of the data is to dump and restore. That's the point of a database, it
allocates space, marks unused space and overwrites that old space with new
data. This keeps the database from having to constantly add and r
I can only speak for myself, and I have not had any performance
hits, or at least anything that I would consider negative.
Let's face it, there is no free lunch, no matter what you do.
I just like the fact that I don't have to do a giant pg_dump
every night, and even then I have no "backup" unti
Dan,
I know you are using mysql, but if ever you were to move to
Postgres, I'm using the Point in Time Recovery (PITR) setup.
This has been great for making backups when your database
is large (mine is around 52G).
Restore could take you longer, but my opinion is, if I'm to
the point that I have
Hey Larry, I see you are still lurking on the list. Since
you brought this up, I haven't really been able to figure out
what exactly the difference is on the 8.1 and 8.2 versions.
They are both being actively developed so I don't see which
is the best "new" version?
In Gentoo world they only have
2007 5:17 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dreaded TEXT to BYTEA conversion (2.0 -> 2.2)
Niblett, David A wrote:
> Like many I want to upgrade to dbmail-2.2 from a 2.0 install. However
> I have 37G DB and really am worried about the time it's going to take
> to
Like many I want to upgrade to dbmail-2.2 from a 2.0 install. However I have
37G DB and
really am worried about the time it's going to take to do the bytea conversion
on dbmail_messageblks.
I'd like to know if there is a way that I could dump the database, then restore
it so the new
tables cr
Yes I use DBMail in production, have for 1.5 years now.
I use PHP, because I like it better than Perl. What do you
want me to write a script in that will open a database, read
out some records, munge them into mbox format (headers, the
stupid > From line issue, etc) and then barf it up to a file
ent: Thu 1/25/2007 7:46 PM
To: DBMail mailinglist
Subject: RE: [Dbmail] backup database, how often?
On Thu, Jan 25, 2007, "Niblett, David A" <[EMAIL PROTECTED]> said:
> My eventual goal is that I'll be using something like dbmail-export,
> dump out users email into mbo
I do a nightly backup, and I see an almost minimal hit
on performance. Sure the machine load goes from 0.5 to 2 for a
couple hours, but the database is still plenty responsive to
me.
I'm with Marc on this one. The Postgresql feature of PITR is
awesome. With PITR you can go to a weekly backup an
I'm in the same boat Rod, but I'm also going to upgrade my postgres. Don't
know if it
much matters, but my plan is to stop mail services, do a dump of the database,
alter
the dump so the new table will be created with bytea, then do a restore. My
calculations
are that will take 4.5 hours total
Me too, as I have 32G I need to do, and expect a high
pain and suffering rate.
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PR
TECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Niblett, David A
Sent: Thursday, November 09, 2006 4:54 PM
To: DBMail mailinglist
Subject: RE: [Dbmail] DBMail 2.20rc1 and SquirrelMail
I think I'm beginning to see the problem now. My dbmail_messageblks
table has the messageblk column as type
twork Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Niblett, David A
Sent: Thursday, November 09, 2006 4:41 PM
To: DBMail mailinglist
Subject: RE: [D
e Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul J Stevens
Sent: Thursday, November 09, 2006 4:35 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] DBMail 2.20rc1 and SquirrelMail
David,
What encoding is s
[EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Niblett, David A
Sent: Thursday, November 09, 2006 3:53 PM
To: DBMail ma
I took the plunge and converted my personal server to 2.2.0rc1
to start testing. I have an interesting error, and I'm hoping
that it's something very simple.
I followed the conversion process from 2.0 to 2.2 and all my
existing messages are great. The problem seems to be when I
get new mail and
Well if you want to get really technical, POP3 does not have any concept
of
a "folder". You could probably configure a POP3 server to check any ONE
folder, but by convention it's the INBOX folder.
However, it is correct that a POP3 daemon should only check, download,
delete, etc. from any ONE fol
| Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul J Stevens
Sent: Monday, October 23, 2006 3:08 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] subdomains in the alias table
Niblett,
-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul J Stevens
Sent: Monday, October 23, 2006 11:00 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] subdomains in the alias table
Niblett,
Just to be clear, I'm totally in agreement with Paul in that
this is a very slippery slope. I made my changes with the
full knowledge that later I expect someone to point, laugh and
it to become a Vonage ad.
If you refuse to modify Postfix and let dbmail-lmtpd dictate if
the account exists you wi
First the bad news which is pretty obvious. If you have
[EMAIL PROTECTED] and postfix accepting [EMAIL PROTECTED]
then any mail to [EMAIL PROTECTED] will be delivered as
well.
That being said, the only way I could find to deal with a similar
situation is to modify the select query inside DBMail d
Anne,
Depending on how you implement delivery in Postfix, this can
be very easy. I use relay_recipient_maps (since I relay everything
via LMTP). I have a SQL query that is actually a stored proceedure
(aka function) in the dbmail database.
The function checks the username and aliases table to s
OTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Aleksander
Sent: Tuesday, September 26, 2006 11:37 AM
To: DBMail mailinglist
Subject: Re: [D
Interesting idea, but it seemed like it should be simpler
than that.
Like an idiot I forgot that you can use SQL for any kind of
access_map, so I just used "check_recipient_access" and
made an SQL query to find users that were "close" to being
over quota.
This works for me, since we set the quota
I know this is more a Postfix question, but it involves
really something that happens with dbmail-lmtpd local
delivery. So I'm hoping that someone else has already
explored how to fix this issue.
Currently I use Postfix relay_domains and maps to determine
if I should accept email for a user. I'm
We use the old trusty SquirrelMail with the Nutsmail skins
and the vlogin plugin for our 3 domains.
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message
Used it 1 year.
Like Matthew, did I mention Postfix?
4212 mailboxes, taking up about 25GB of storage in a PostgreSQL
database.
Moving several 1000's of messages daily, delivering several 100's.
I have 4 SMTP/POP/IMAP front ends with single database backend.
Would like to replicate the DB, but sl
There are basically 3 ways to accomplish what you want, only
2 are probably desirable.
1) Relay anything on your mail server, bad in so many ways.
2) Pop before SMTP. That is a feature in dbmail where when a
user pop's their email first, their IP is placed in a table
dbmail_pbsp for a "period of
esses.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Tue, 22 Aug 2006, Niblett, David A wrote:
> Don't know what version you are using, if 2.1, like Paul said, it's in
> there.
>
> If you are using 2.0, then I have a patch that I wrote
> f
We use Nutsmail. If you find SM dated, I suggest you
look at Nutsmail. It's basically some skins for SquirrelMail.
Which is nice since it updates the look and feel, but all
the plugins still work and exist.
God help you if you need to modify the skins (I did). Their
coding and commenting is abs
Don't know what version you are using, if 2.1, like Paul
said, it's in there.
If you are using 2.0, then I have a patch that I wrote
for our dbmail to manage domains.
It's in the bugs list or you can pick it up here
http://www.niblett.org/code/index.php
The 2.0.9 patch works for 2.0.10 as well.
m: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul J Stevens
Sent: Tuesday, July 18, 2006 4:31 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] Delete accounts
Niblett, David A wrote:
> Well I completed my delete and all went well, though I'm expecting a
> call about u
bmail_physmessage WHERE id IN (SELECT id FROM tmp); DROP
> TABLE tmp;
>
> This will delete all physmessages that do not have a message
> associated with them, taking with them all related messageblks if you
> have the constraints setup correctly.
>
>
>
> Niblett, Da
ete all physmessages that do not have a message associated
>> with them, taking with them all related messageblks if you have the
>> constraints setup correctly.
>>
>>
>>
>> Niblett, David A wrote:
>>> So before I do something monumentally s
ith them all related messageblks if you have the
> constraints setup correctly.
>
>
>
> Niblett, David A wrote:
>> So before I do something monumentally stupid. Paul can you
>> tell me if this is correct for finding my unconnected physmessages.
>>
>> SELECT dbmail
On
Behalf Of Paul J Stevens
Sent: Tuesday, July 11, 2006 3:37 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Delete accounts
Niblett, David A wrote:
> Sorry, I didn't remember, that I did create a foreign key constraint
> on a new column in dbmail_aliases connecting it back to user
Of Paul J Stevens
Sent: Tuesday, July 11, 2006 3:37 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Delete accounts
Niblett, David A wrote:
> Sorry, I didn't remember, that I did create a foreign key constraint
> on a new column in dbmail_aliases connecting it back to user_idnr
tilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul J Stevens
Sent: Monday, July 10, 2006 2:48 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] Delete accounts
Niblett, David A wrote:
> I just did a quick search and it
Monday, July 10, 2006 12:34 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] Delete accounts
On 7/10/06, Niblett, David A <[EMAIL PROTECTED]> wrote:
> I'm guessing that your are using MySQL and cascade delete
> is not an option?
>
> With mine, I just delete from the dbmail_user
I'm guessing that your are using MySQL and cascade delete
is not an option?
With mine, I just delete from the dbmail_user table and
everything else goes with it. One simple query.
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
My plan on backup's are taken directly from Paul. I wrote
a PHP application that I can dump a users messages completely
or based on time. The beauty of this idea is if I need to
restore a single user, I don't have to restore the entire
database backup.
So the idea would be, Sunday dump all Emai
Ok I'm lost here. Maybe this is a philosophical discussion
that I missed earlier.
If you want one DB per user why not go use mbox, or maildir
format and store the mail on disk since you are really just
adding the overhead of SQL to an individual mailbox.
Relational SQL databases are designed to
Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul J Stevens
Sent: Wednesday, May 31, 2006 1:26 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] Backup and Restore
Niblett, David A wrote:
> Paul,
>
> I have a PHP vers
ackup and Restore
Niblett, David A wrote:
> Gee, and I was just working on extracting the relevant queries from
> the 2.1 code so that I might just do that very thing. :)
>
> I'm looking at a php script right now to do this right now. So since
> it's in your head I'l
Lars,
Unless it's been changed in 2.1 I believe all Email addresses are case
sensitive.
At least when I implemented, I had to change my SQL code to do a lower first on
the name to make sure that it was not .
If you are using the + folder patch that I created for the 2.0 train, then it
should
I am thinking specifically of PostgreSQL where I can write
a function (aka stored proceedure) that I could do:
SELECT sieve_cmd();
The sieve_cmd function could check the sieve tables just like
the normal select would, and if nothing came back for the user_idnr,
it could find their client_idnr (or
>
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Niblett, David A
Sent: Wednesday, May 24, 2006 7:13 AM
To: DBMail mailinglist
Subject: RE: [Dbmail] chaging banner
Jorge,
I believe you need that portion if you are going to do anything like
APOP, as
t
Jorge,
I believe you need that portion if you are going to do anything like APOP, as
that is part of the authentication process. By taking that away you may upset
users POP clients.
--
David
From: [EMAIL PROTECTED] on behalf of Jorge Bastos
Sent: Wed 5/24/200
Why not just use a conditional union or function (not sure
about MySQL here). We do this now for our Spam rules from
Amavis. We just use a function that selects the specific
users rules, or the groups rules, or the default rules.
I don't see why the sieve select couldn't work the same
way if you
ional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Andrea Fino
Sent: Thursday, May 18, 2006 12:42 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] quota
Niblett, David A wrote:
>We run a script that looks th
We run a script that looks through the database each night
and if a user is >=95% of their quota we send them an Email
letting them know.
We also use it as a placeholder to see if they haven't read
it in 30 days time, at which point we do nothing currently,
just statistic gathering. Eventually we
Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul J Stevens
Sent: Tuesday, May 16, 2006 3:59 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] B
u.net/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul J Stevens
Sent: Monday, May 15, 2006 5:24 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] Backup and Restore
Niblett, David A wrote:
> Just a curious question for other out there. How are y
Just a curious question for other out there. How are you
all handling backup's (I assume a standard DB dump and
store it somewhere)?
The next obvious item is restoring one users mailbox for
some reason or another. Anyone have a slick way of doing
this rather than restore the entire DB, pick out
We use Postgres and a stored proceedure (function) and a
trigger. When there is an update to the dbmail table, we
catch it before it happens, make the same update to the
users table and then to dbmail.
I believe MySQL 5 has functions, but I don't know about
triggers. Another feature we have to u
I believe the dbmail_filters is an optional add-on like my patch to do folder
delivery in the address. It may be that Debian includes that by default.
Though you are correct, it could have something to do with dbmail-smtp,
I don't use that, only lmtp delivery.
Good luck,
David
___
Mike,
All we use is Postgres, not a single issue going from
2.0.4 -> 2.0.6 -> 2.0.6-svn -> 2.0.9.
If there were database changes I never saw them. I even have
several of my own columns and stored procedures in the
database to add features.
--
David
From:
Simon,
Don't know exactly about the apt-get, but I just compiled
and went from 2.0.6 to 2.0.9 without any issue. There is
no database change required and nothing different with the
configs, it's a maintenance release only.
You may want to go to 2.0.10, but I can say that 2.0.9 resolved
my only n
Hi all,
This may belong in the developers section and will move it
based on the outcome. Users might want to be aware of the
potential issue.
We are stuck with mailbox names that have a single quote in
the name ('), and in version 2.0.6 I've been using that without
issue. In version 2.0.9 I get
Christian,
Are you using MySQL or PostgreSQL? I'm not positive of
MySQL, but with Postgres you could set up a trigger on the
dbmail_messages table to fire on insert. There is an
option to execute an external program in postgres from a
function.
This way you would be guarenteed that you have all
uch appreciated your help so far.
Kind Regards,
Andy Savage
On Mon, 9 Jan 2006 15:42:40 -0500, "Niblett, David A"
<[EMAIL PROTECTED]> wrote:
> Sorry for that late reply, holiday madness around here.
>
> I had to go digging to find the setup I had with Virtual Domains.
You might want to look at my patch for DBMail. I added the
feature of [EMAIL PROTECTED] You can use dspam to add
the folder portion to the email address.
http://dbmail.org/mantis/view.php?id=57
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone
tell your mail server how to reject other
domains
from relaying email through your mail server. This it completely
different
than virtual_domains, which helps describe domains for which the email
server
will accept mail for.
-Micah
On Monday 09 January 2006 12:42 pm, Niblett, David A w
it makes it much easier
having everything in the database.
Also, can I ask, what is the difference between relay_domains and
virtual_domains?
Kind Regards,
Andy Savage
Niblett, David A wrote:
> Andy,
>
> I was on the same path as you. Since you are going to use
> dbmail lmtp for
My ears were burning so I'm here to answer questions about
my patch or add enhancements if you got 'em.
I think sieve is the way to go in the future, but if you need
it now, then I can help.
This week I'm hoping to get my patch updated for the latest
version of 2.0 since I a bit behind.
--
David
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrea
Brancatelli
Sent: Thursday, December 29, 2005 8:09 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Mail filtering to IMAP folders
Alle 13:45, giovedì 29 dicembre 2005, Niblett, David A ha scritto:
I read somewhere of someone having a PHP
Andy,
I was on the same path as you. Since you are going to use
dbmail lmtp for delivery I found you need to use relay_domains.
This is what I do:
relay_domains = domain.com
relay_recipient_maps = proxy:pgsql:/sql-configs/postfix-relay-pgsql.cf
relay_transport = dbmail-lmtp:[127.0.0.1]:24
Th
Andrea,
You are correct, the sieve implementation is not fully
functional currently.
There are two possible ways to deal with what you have.
If you want to use something like procmail I believe you
should be able to make the final procmail delivery be to
the dbmail-smtp command and have it delive
Works just fine. I've got 4 MTA's running postfix all
storing Email to 1 DB, and POP and IMAP running on all
4 servers as well.
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.
om: Paul J Stevens [mailto:[EMAIL PROTECTED]
Sent: Friday, November 18, 2005 3:08 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Size, vacuum, performance, etc
Niblett, David A wrote:
> As for the dbmail-util, I would love not to run that part each night,
> but I thought that was rec
Jesse, I'm like you, there are only two of us here and we are
learning PostgreSQL seat-of-pants style.
Wow, then I'm completely lost looking at your numbers.
I set my shmall and shmmax to 805306368, so that the DB (which
is the only thing using memory on the box) could have 800M of
shared RAM. A
Very interesting, then I'll probe some more...
Our database system is on a Dual 3GHz Hyperthreaded Compaq
G3 (P4 Xeon) system with 1GB of RAM with Ultra320 drives
configured in a SCSI RAID 0+1 (4 36G drives, 2 stripe sets, mirrored)
I have set my shared memory space at 512M, I would like to
go to
I'm hoping that someone on the list can help me sort out
what I hope I'm doing wrong. Our group seems to be devoting
a lot of time and heartache to running dbmail for our user
base. Granted a lot seems to be database related.
So if there is anyone on the list that is using dbmail 2.0
with Postgr
hone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Paul J Stevens [mailto:[EMAIL PROTECTED]
Sent: Monday, September 19, 2005 7:52 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] 2.0.6+ DB Keepalive
Niblett, David A wrote:
> Paul,
>
Paul,
I believe you mentioned that in 2.0.6 and above, dbmail now
opens a new connection to the database every second to make
sure that it's alive rather than using the pgstatus function.
(for PostgreSQL)
I was wondering what the reason for that change is? I've
noticed that now if I look at a ne
Can't do that currently. I wanted it too for a patch I wrote, but
in my understanding of the code you can't.
--
David
-Original Message-
From: Alan Glait
To: dbmail@dbmail.org
Sent: 9/16/2005 9:50 AM
Subject: [Dbmail] Bind ip
Hi !
I want BINDIP to have 2 values ...
How can I do it ??
r
Eric,
Currently there is no method of calling an external program
that I have seen in my poking around in the code. So
you will probably have to do something like.
MTA -> amavis -> dbmail-lmtp delivery. Though usually in
practice I've always seen it done as below.
MTA (tcp/25) -> amavis -> MTA
The bug is closed that I originally opened that provides
IP based virtual domain hosting for the dbmail 2.0 tree.
I have a new version of the patch that I believe works
much better than before. Fixed some minor cases of
possibly freeing some memory that was not allocated, and
move the force lower
I've made some fixes to my dbmail-folders patch. Mostly
minor fixes, but one fairly major fix. In most cases this
would not have cause anyone signifigant problems.
The latest patch is for v2.0.5 of dbmail and can be found
at: http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=057
all the Mailman features and just lets my customer control their
own vacation message for their domain. Presently they give it to me
although they can turn it on and off via aliases - they generally
don't comprehend that part and I do it for them and they don't like
that much.
- April
April,
The plug-in you refer to about the saving the compose, doesn't work
for the HTML RTF Compose plug-in in our experience. So you might
want to test that in case you offer it.
As for the timeout, I think you are running into the Apache session
timeout which is 15min by default I believe. Li
I know others had been looking for a way to have direct folder
delivery into DBMail via LMTP. I've just updated the patch
that I wrote to fix a couple of problems and also added the
feature that if a folder is created then the user is also
subscribed to the folder.
You can download the v0.5 of th
I've been getting these strange glibc double free errors
on only my machines that run dbmail. I've never gotten
one of these before and I just had one of my dbmail machine
lock up and it appears that it ran out of memory.
Anyone else seen this before? I'm thinking about going to
the SVN version,
lines from there not just the us-ascii line. And I had to add
an additional line for my "iso-8859-2" setting :) (I know, i had to add
this single line but who knows...)
Viktor
Niblett, David A írta:
>Are you all referring to the "us-ascii" portion that is commented out
Are you all referring to the "us-ascii" portion that is
commented out in the imaputil.c file?
I'm having a strange issue with SquirrelMail and I'm not
sure it's related. If a user has say 2 pages of Email,
the first page displays correctly, but then if they go to
page 2, the messages come up with
I'm a bit confused right now. I thought for sure that LMTP
wasn't using a transaction for PostgreSQL, but the logs don't
lie.
My issue is that when I stop dbmail-lmtpd without stopping
postfix first, and there is an LMTP message in the pipe, I
end up with an entry in dbmail_messageblks that has a
lt;http://lists.pitt.edu/pipermail/imapproxy-info/2004-February/000211.html>
Thank you,
-Abullah
"Niblett, David A" <[EMAIL PROTECTED]> wrote:
Sorry, I didn't realize that they were two different errors.
I have seen the other one seperately before, and if I recall
correctly
h
"Niblett, David A" <[EMAIL PROTECTED]> wrote:
Abdullah,
Check the users account for a zero size message. We found
that if we shutdown LMTP without shutting down postfix first
we would get messageblk entries with a completely empty
(not null) messageblk field.
That usually hose
Abdullah,
Check the users account for a zero size message. We found
that if we shutdown LMTP without shutting down postfix first
we would get messageblk entries with a completely empty
(not null) messageblk field.
That usually hosed up squirrelmail. Mozilla would show an
empty message, and no
_unique_id_idx
dbmail_pbsp_pkey
dbmail_physmessage_pkey
dbmail_subscription_pkey
dbmail_users_name_idx
dbmail_users_pkey
Sequences:
dbmail_alias_idnr_seq
dbmail_mailbox_idnr_seq
dbmail_message_idnr_seq
dbmail_messageblk_idnr_seq
dbmail_physmessage_id_seq
dbmail_seq_pbsp_id
dbmail_user_idnr_seq
Hop
July 16, 2005 12:40 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] DBMail + PostgreSQL Problem
Niblett, David A wrote:
>I'm in serious need of help here. I'm about at my whits
>end of dealing with dbmail and getting it to work. I've
>had a couple of database crashes now
Hello all,
I'm in serious need of help here. I'm about at my whits
end of dealing with dbmail and getting it to work. I've
had a couple of database crashes now and found things like
if I run dbmail-util my DB process load skyrockets and
the server becomes unusable.
I'm hoping that maybe I'm jus
I have an issue that some users of mine used to do an option of
forwarding their Email, and also retaining a copy in their mailbox.
I'm wondering how to accomplish this in dbmail. Maybe it's really
simple, but it's eluding me.
dbmail_aliases
+---++
| alias
I'm sending this to keep it in a separate thread. The other
problem I have with dbmail-svn-1816 seems to be that
POP/IMAP/LMTP seem to die on a regular basis.
I've turned on full logging, and I can't seem to figure out
what/where there are any problems. It seems like at different
points, and dif
Recently we moved all of our customers from our legacy
email system to our dbmail setup. This resulted in about
16G of email being inserted into dbmail.
Everything seems to be going fine, however I'm very confused
as to why I keep seeing NULL physmessages when I run the
dbmail-util checks.
Is th
Just curious out there how others do their database maintenance
and backups.
If I understand the docs correctly, it would be best to
run dbmail-util -ar and then a dump of the database. I'm
currently using 'pg_dump -Ft dbmail | bzip2 -9 > '
Anyone have any other suggestions or ideas?
--
David A
or all the questions. The postfix config look pretty straight
forward, but looking at your configs might be more helpful.
Curtis
Niblett, David A wrote:
>Curtis,
>
>You would need to compile your postfix with DB support
>and sasl support. Then you can simply use the dbmail_users t
mailer.
David
- Original Message -
From: "Niblett, David A" <[EMAIL PROTECTED]>
To: "'DBMail mailinglist'"
Sent: Friday, July 01, 2005 9:02 AM
Subject: RE: [Dbmail] TIME_WAIT processes
>I thought that too, but the TIME_WAIT ones are not persistent.
1 - 100 of 133 matches
Mail list logo