I was reading a post on DBMail SPAM filtering. Sorry if this
doesn't end up in the thread.
Currently I have a patch that I wrote for DBMail-2.0.1 and I
just updated for DBMail-2.0.4. It's in the bug list for DBMail.
I added the feature to the lmtpd server to accept
[EMAIL PROTECTED]
With tha
What are you all using to cluster PostgreSQL? I looked at
the master/slave replication that comes with Postgres. It
seems fine if you want to replicate the data, but how do you
get dbmail to switch databases when there is a failure?
I'm currently using drbd to replicate the disk block device
tha
s the other mta...
>>
>>regards
>>
>>Simon
>>
>>
>>Simon Lange //Director
>>============
>>www.polynaturedesign.com
>>+49[0]4131 220121 PHONE
>>+49[0]4131 224730 FAX
>>+49[0]16090300077 CELL
>>
>>
&g
>> among others.
>>What it doesn't support is automatic failover.
>>
>>Simon Lange wrote:
>>
>>
>>
>>>pgsql does not support replication. thats why we do use mysql -
>>>clustering is announced for mysql5 :D
>>>
>>&
least
not in the syntax you use. Why not use a LIKE query here? Or even, why use
pattern matches at all here.
Niblett, David A wrote:
> I was reading a post on DBMail SPAM filtering. Sorry if this doesn't
> end up in the thread.
>
> Currently I have a patch that I wrote for D
hone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Paul J Stevens [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 4:19 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] How to Filter in dbmail
David,
Niblett, David A wrote:
&g
I really hope that I'm missing something here. How does
DBMail deal with virtual domains?
User: [EMAIL PROTECTED]
User: [EMAIL PROTECTED]
Right now, unfortunately, most all my users would log in
as 'xyz' with POP server of 'mail.domain1.com'.
Currently I have to run 3 IP addresses on a very old
also their email address, you can set
up multiple email addresses for each customer.
I'm using postfix/dbmail/amavisd-new/spamassassin/clamav The same
things that the barracuda networks gizmo uses (they don't use dbmail).
Curtis
Niblett, David A wrote:
>I really hope that I'
email address as a login, you may just be better off sticking with what
you have now.
Niblett, David A wrote:
> I understand the client_idnr field, but I don't understand how IMAP
> will determine when user 'xyz' from domain1 logs in and user 'xyz'
> from domain
not violate
anything.
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Niblett, David A
Sent: Wednesday, May 25, 2005 7:49 AM
To: 'DB
It means that you don't have reverse DNS for the IP address.
If you set "RESOLVE_IP=no" in your IMAP section of your
dbmail.conf it will no longer try to look up the hostname
from the IP.
You could also set up reverse DNS for that ip.
Either way it won't really affect anything other than if you
I have already finished v0.2 of the patch which includes
pop3d virtual domain support.
If any one is interested in hosting IP virtual domains, I
would greatly love any feedback on any issues you have. I
have not had any IMAP issues, and currently do not use
POP3 that much.
Patch available at:
ht
Just curious, what does everyone do about usernames that
are mixed case?
NiblettDA
niblettda
NiblettDa
Do you all treat them as the same user or different? I only
ask because DBMail seems to follow standard *nix convention
and match strictly on case. It could be that in PostgreSQL
I have
Virtual Hosting
David,
I will study your patch after the weekend.
Seems like a very nice feature.
Niblett, David A wrote:
> I have already finished v0.2 of the patch which includes pop3d virtual
> domain support.
>
> If any one is interested in hosting IP virtual domains, I would
>
I have an interesting situation and I wonder if any one else has
something like this and how you deal with it.
Basically we want to do a free Webmail service that has ad's on it.
For these users I want to only allow them to use the webmail interface
to view their email (ie. no POP or IMAP).
We al
at I could get PAM to deal with that.
--
David
-Original Message-
From: Mark J. Nernberg
To: DBMail mailinglist
Sent: 6/3/2005 2:55 PM
Subject: Re: [Dbmail] Restricting Access
> From: "Niblett, David A" <[EMAIL PROTECTED]>
> Reply-To: DBMail mailinglist
> Date:
aul J Stevens
To: DBMail mailinglist
Sent: 6/3/2005 4:56 PM
Subject: Re: [Dbmail] Restricting Access
Niblett, David A wrote:
> I have an interesting situation and I wonder if any one else has
> something like this and how you deal with it.
>
> Basically we want to do a free Webmail service
ROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Paul J Stevens [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 04, 2005 6:34 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Restricting Access
hone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Paul J Stevens [mailto:[EMAIL PROTECTED]
Sent: Monday, June 06, 2005 10:55 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Restricting Access
Niblett, David A wrote:
> - I&
ainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-----
From: Niblett, David A [mailto:[EMAIL PROTECTED]
Sent: Monday, June 06, 2005 8:21 AM
To: 'DBMail mailinglist'
Subject: RE: [Dbmail] Restricting Access
- I'll fix the case sensitive and put it back
Why don't you just forward the non-alias account and leave all the
aliases where they are. Example:
[EMAIL PROTECTED] <- user's real Email account.
[EMAIL PROTECTED] <- alias to [EMAIL PROTECTED]
[EMAIL PROTECTED] <- alias to [EMAIL PROTECTED]
[EMAIL PROTECTED] <- alias to a.com (sure it's insane
alias -> Real Account -> forward
Matt,
If I understand correctly you have:
alias | deliver_to
+---
abuse@ | 1
postmaster@ | 1
postmaster@ | msalerno@
try changing that to:
abuse@ | postmaster@
Matt Salerno wrote:
> On 6/10/05, Niblett, D
In my tests what happens now is that your inbound Email, hits
dbmail, the alias look up says that it has to invoke SMTP to
send the message, so it's back to your SMTP server, which then
turns around and sends it back to DBMail with the new address,
which then, once again, invokes the SMTP to send t
]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Matt Salerno [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 12:24 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] send mail to alias ->
onal Utilities | Web: http://www.gru.net/
-Original Message-
From: Paul J Stevens [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 15, 2005 3:16 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] send mail to alias -> Real Account -> forward
Niblett, David A wrote:
> In my tests wh
avid A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-
From: Niblett, David A [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 15, 2005 8:24 AM
To: 'DBMail mail
_2_0 branch in svn. I've added loop
detection in auth_check_user_ext. Or rather, reinstated the loop detection
there but unused.
Niblett, David A wrote:
> Ok, I just confirmed that the below situation is really, really bad.
>
> Technically I'm not sure this is a bug since i
ainesville Regional Utilities | Web: http://www.gru.net/
-Original Message-----
From: Niblett, David A [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 15, 2005 10:11 AM
To: 'DBMail mailinglist'
Subject: RE: [Dbmail] send mail to alias -> Real Account -> forward
Absolutely, I
Just a curious question here. Why in the IMAP CAPABILITY
#define isn't QUOTA listed when DBMail does support this?
--
David A. Niblett | email: [EMAIL PROTECTED]
Network Administrator | Phone: (352) 334-3400
Gainesville Regional Utilities | Web: http://www.gru.net/
se only support quotaroot="/"
Full quota support mostly would imply maintaining a size per mailbox in the
mailboxes table. Once that's done, the commands are pretty easy to add.
Niblett, David A wrote:
> Just a curious question here. Why in the IMAP CAPABILITY #define
> is
I've noticed that when I start dbmail-X there always
seem to be a large number of TIME_WAIT connections
reported by netstat. All of these connections are going
to my postgres database.
For example, I only have IMAP running, with the following:
NCHILDREN=5
MAXCHILDREN=20
MINSPARECHILDREN=2
MAXSP
Curtis,
You would need to compile your postfix with DB support
and sasl support. Then you can simply use the dbmail_users
table as the authentication for sasl.
I currently run mine that way, I can provide config files
if you like. Check out:
http://www.postfix.org/SASL_README.html
If you look
during client connections. The number of waiting
connections is equal to the amount of child processes, no?
-Micha
Niblett, David A wrote:
>I've noticed that when I start dbmail-X there always
>seem to be a large number of TIME_WAIT connections
>reported by netstat. All of the
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.
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
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
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
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
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
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
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
_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
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
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
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
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
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
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
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,
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
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
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
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
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
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
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
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
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,
>
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
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
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
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
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.
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
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
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
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
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
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
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
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.
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
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
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
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:
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
___
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
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
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
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
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
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
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
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
>
-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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1 - 100 of 133 matches
Mail list logo
