On Montag 20 Juli 2009 Jonathan Feally wrote:
> Perhaps we should have a status column on dbmail_users like we have
> on messages.
>
> 0 = disabled
> 1 = enabled
> 2 = deleted
> 3 = purge ok
>
>
> Then on the dbmail-util run it will moved deleted to purge - then
> really delete the purge like we d
Paul J Stevens wrote:
>
> Ok, now the real work:
>
> find all unconnected physmessages that may have belonged to the deleted
> user.
>
> - select id from dbmail_physmessage p left join dbmail_messages m on
> p.id=m.physmessage_id where m.physmessage_id is null;
>
> - for each physmessage.id f
> On 7/20/2009 5:40 PM, Jonathan Feally wrote:
> > Perhaps we should have a status column on dbmail_users like we have
> on
> > messages.
> >
> > 0 = disabled
> > 1 = enabled
> > 2 = deleted
> > 3 = purge ok
> >
> >
> > Then on the dbmail-util run it will moved deleted to purge - then
> > really d
On 7/20/2009 5:40 PM, Jonathan Feally wrote:
> Perhaps we should have a status column on dbmail_users like we have on
> messages.
>
> 0 = disabled
> 1 = enabled
> 2 = deleted
> 3 = purge ok
>
>
> Then on the dbmail-util run it will moved deleted to purge - then
> really delete the purge like we do
Perhaps we should have a status column on dbmail_users like we have on
messages.
0 = disabled
1 = enabled
2 = deleted
3 = purge ok
Then on the dbmail-util run it will moved deleted to purge - then
really delete the purge like we do with messages.
-Jon
--
Scanned for viruses and dangerous c
Daniel Mejia wrote:
> Hi all,
>
> I have a VERY HUGE problem.. I have accidentally deleted a user with the
> command
>
> # dbmail-users -d x...@xxx.xxx
>
> Is there any way to restore the user back with all his emails? Please help,
> I am in big trouble if this is an irreversible action!
Oops.
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
OK, I've found 400+ messages with status = 1. How do I link these messages to
a new mailbox?
Your help is greatly appreciated.
Thanx a million!
Sincerely,
Daniel
Daniel Urstöger wrote:
>
> Hi Daniel,
>
> well the mailboxes also got deleted, I guess, so you can look in the
> table
> messgag
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
That is where I got stuck actually. After some tiring search, I got to know
the user_idnr. But the mysql query:
"select * from dbmail_mailboxes where owner_idnr = 'xx';"
returns "Empty set (0.00 sec)" which leads me to think that the mailbox has
been deleted?
By guessing the mailbox_idnr of the
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!!
Thank you for the reply. Thank God there IS a way to restore the user's
emails! ;))
I am running DBMail 2.2.10, and yes, I can fiddle with the database
directly.
Would you please help me by guiding how to do the "dirty" work of connecting
the messages to a new user? Your help is a li
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 all,
I have a VERY HUGE problem.. I have accidentally deleted a user with the
command
# dbmail-users -d x...@xxx.xxx
Is there any way to restore the user back with all his emails? Please help,
I am in big trouble if this is an irreversible action!
Thanx a million to all for your help!!
Si
Anne wrote:
> Hi,
>
> I just reported a bug concerning empty messages with 2.2
> Can I easily go back from 2.2 to 2.0?
> Need to know asap.
As you already discovered, the tables for 2.2 are backward compatible
for mysql users. The postgresql tables contain a non-compatible change
(the bytea conve
> Hi,
>
> I just reported a bug concerning empty messages with 2.2
> Can I easily go back from 2.2 to 2.0?
> Need to know asap.
>
> thanks,
> Anne
ok, I tried. Seems to work...
Anne
___
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/ma
Hi,
I just reported a bug concerning empty messages with 2.2
Can I easily go back from 2.2 to 2.0?
Need to know asap.
thanks,
Anne
___
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
I've put it here for you: http://www.ic-s.nl/dbmail_2_0rc6.tar.gz
I hope it is still in time!
regards,
Leander
On 1-jul-04, at 18:58, James XMS wrote:
Basically, something is screwy with the dbmail site at the moment and
i need a
copy of 2.0rc6. Sourceforge only has rc5, so does anybody know
Basically, something is screwy with the dbmail site at the moment and i need a
copy of 2.0rc6. Sourceforge only has rc5, so does anybody know a mirror i can
use.
Sorry to be abrupt, but basically i need it within the next 10 minutes, or don't
worry about replying.
Cheers
James
--- Msg sent v
MFK> I PRESUME THIS MAIL WILL NOT BE A SURPRISE TO YOU.
MFK> I AM AN ACCOUNTANT WITH THE MINISTRY OF MINERAL
MFK> RESOURCES AND ENERGY IN SOUTH AFRICA AND ALSO A MEMBER
MFK> OF CONTRACTS AWARDING COMMITTEE OF THIS MINISTRY UNDER
MFK> SOUTH AFRICA GOVERNMENT.
Hmmm... I thought someone said e
ATTN:
I PRESUME THIS MAIL WILL NOT BE A SURPRISE TO YOU.
I AM AN ACCOUNTANT WITH THE MINISTRY OF MINERAL
RESOURCES AND ENERGY IN SOUTH AFRICA AND ALSO A MEMBER
OF CONTRACTS AWARDING COMMITTEE OF THIS MINISTRY UNDER
SOUTH AFRICA GOVERNMENT.
MANY YEARS AGO, SOUTH AFRICA GOVERNMENT AS
On Wed, 26 Feb 2003 17:00:03 -0300
"Nataniel Klug" <[EMAIL PROTECTED]> wrote:
I've got postfix-1.1.1 compiled from source on Linux Mandrake 8.1
Before I started use MySQL tables for transport, I used hash tables.
And it worked just fine:
/etc/postfix/transport:
trado.nnov.ru dbmail:
deep.nnov.
0 PM
Subject: Re: [Dbmail] Urgent - Relay e Unknow User
:
: Hello Nataniel,
:
: Probably keep following Jeff's instructions on getting postfix
: to talk directly to your database, as you end up with a much more
: flexible/powerful setup, but you can use postfix+dbmail without
: any databa
olved quickly - try commenting out the
local_recipients_map and see if it works (dbmail will then bounce
unknown users, with the bounce-relay caveat Jeff mentioned).
Original Message
From: Nataniel Klug
To:
Subject: Re: [Dbmail] Urgent - Relay e Unknow User
Sent: Wed, 26 Feb 2003 16:
Jeff,
: Unfortunately, I have yet to see a distribution of postfix that has
: MySQL or Postgres support pre-built. You must compile from source. And
: that means making sure you have all the OTHER required development
: libraries installed, such as Berkley DBM.
:
: In the mean time, you CAN use th
Hello Nataniel,
NK> fatal: unsupported dictionary type: mysql
Unfortunately, I have yet to see a distribution of postfix that has
MySQL or Postgres support pre-built. You must compile from source. And
that means making sure you have all the OTHER required development
libraries installed, such as
Jeff,
As I was afraid:
Feb 26 16:44:39 ns2 postfix/pickup[16705]: fatal: unsupported dictionary
type: mysql
Feb 26 16:44:39 ns2 postfix/qmgr[16706]: fatal: unsupported dictionary type:
mysql
Nataniel Klug
Hello Nataniel,
Oh, I forgot... To make postfix use dbmail's aliases table for local
addresses, add to main.cf:
local_recipient_maps = mysql:/etc/postfix/mailbox.cf
where mailbox.cf contains the parameters for checking an address
against the dbmail aliases table, such as:
user = postfix
passwor
Hello Jeff,
: The problem is that Postfix doesn't know it is the final destination
: for the new domain. Just having a transport for it doesn't do it. And,
: to be honest, I didn't have any luck with the officially-sanctioned
: (by postfix.org) way of doing it... So, I modified what Eelco directed
Hello Nataniel,
NK> Then I put another domain in transport (marilon.com.br and
NK> .marilon.com.br) table... Done postmap and configured accounts in
NK> DBMail. Result: the only account that receive email is
NK> [EMAIL PROTECTED] the others that I created just return a
NK> message like this:
The
: What are the pertinent lines from main.cf? The "User unknown in
: local recipient table" message doesn't sound familiar to me offhand;
: are you using a local_recipient_maps entry? If so, I assume it's set
: to a file with database parameters for dbmail's aliases table?
: (Forward that file c
table?
(Forward that file contents sans-password too, if so.) And what are
the pertinent entries in dbmail's aliases table?
Original Message
From: Nataniel Klug
To:
Subject: [Dbmail] Urgent - Relay e Unknow User
Sent: Wed, 26 Feb 2003 16:11:04 -0300
> Guys,
>
>
Guys,
I am with a big problem. I created a linux box with DBMail and RedHat
Linux then I put just 1 domain in transport table (clickdanoite.com.br and
.clickdanoite.com.br). This works fine with three created accounts
([EMAIL PROTECTED], [EMAIL PROTECTED] and
[EMAIL PROTECTED]). Its workin
33 matches
Mail list logo
