[Dbmail-dev] Keeping track of changes in sql tables

2006-07-06 Thread Marc Dirix
Hi, Since I run svn head most of the time, is there a way to keep track of changes in the sql tables. Recently I found my dbmail_replycache table lacking a column which did go into the sql schema templates but not in my db, because it was created before the change was made. If I know something

Re: [Dbmail-dev] Keeping track of changes in sql tables

2006-07-06 Thread Paul J Stevens
There's no native capability yet. I use: mysqladmin create dbmaila mysqladmin create dbmailb mysqldump -d dbmail|mysql dbmaila mysql dbmailb sql/mysql/create_tables.mysql mysqldump -d dbmaila dbmaila.sql mysqldump -d dbmailb dbmailb.sql diff dbmaila.sql dbmailb.sql this should provide you

Re: [Dbmail-dev] Keeping track of changes in sql tables

2006-07-06 Thread Marc Dirix
As I use postgresql, that won't work. Although the general idea does. Thanks for the tip! Op 6-jul-2006, om 16:28 heeft Paul J Stevens het volgende geschreven: There's no native capability yet. I use: mysqladmin create dbmaila mysqladmin create dbmailb mysqldump -d dbmail|mysql dbmaila

Re: [Dbmail-dev] Keeping track of changes in sql tables

2006-07-06 Thread Aaron Stone
Incidentally, I'll try to get this into SVN myself, but there's a BINARY specified on the name column of the dbmail_mailboxes table. That breaks the case-insensitive mailbox matching and has to be removed. Aaron On Thu, 2006-07-06 at 16:28 +0200, Paul J Stevens wrote: There's no native

[Dbmail] Best proxy for use with dbmail

2006-07-06 Thread Simon
Just wondering what other people are using as a POP and IMAP proxy for dbmail? What are the best options here? Any recommendations/suggestions are welcome. Thanks Simon

Re: Re: [Dbmail] Thunderbird can't see #Public, other MUAs can

2006-07-06 Thread jurgen
Hi, Thing is, I'm not looking for stuff I'm already subscribed to: that's working fine. No problems with LSUB. Thunderbird picks them up with its [lsub *]. The problem is with LIST. Thunderbird never asks the corresponding [list *]. I need to find the list of mailboxes that are *available* to

Re: [Dbmail] Thunderbird can't see #Public, other MUAs can

2006-07-06 Thread Paul J Stevens
What I see is this when I open the 'subscribe' pane in TB: COMMAND: [5 lsub *] COMMAND: [9 list #Users%] COMMAND: [10 list #Users%/%] COMMAND: [11 lsub #Public*] COMMAND: [12 list #Public%] COMMAND: [13 list #Public%/%] then I open the subtree for #Public and I see: COMMAND: [2 list

Re: [Dbmail] Best proxy for use with dbmail

2006-07-06 Thread Paul J Stevens
Simon wrote: Just wondering what other people are using as a POP and IMAP proxy for dbmail? What are the best options here? Any recommendations/suggestions are welcome. It depends on your purpose. For accelerating webmail clients using imap: imapproxy For redirecting connects to different

Re: [Dbmail] backup strategy

2006-07-06 Thread zamri
On 7/6/06, Brian Weaver [EMAIL PROTECTED] wrote: Speaking as someone who just had a server failure and is *still* trying to recover from it. Backup often and AUTOMATE it, and for the love of all that's holy... do a test restore from your backups on a semi regular basis! yes. we should have

Re: [Dbmail] Thunderbird can't see #Public, other MUAs can

2006-07-06 Thread Carl Taylor
I use SQL a reasonable ammount but I am by no means an expert. Having looked briefly at the relevent code and the various example imap queries mentioned previously including % in them I wonder if the problem may be that MySQL uses % as a wild card but it is not being escaped in any way by

AW: [Dbmail] Re: Build from SVN trunk 2188 with Debian Sarge

2006-07-06 Thread Jochen Entenmann
Hi Mark, I have set up a sepearte VMWare machine with Debian 3.1 to build the dbmail package. Kann you show me the sources.list for the build system? When i do apt-get build-dep dbmail i always get the error Cannot find sourcepacket for dbmail Can You help me? I need a actual build from 2.1.x

[Dbmail] 2.1 and the deleting of messages

2006-07-06 Thread Alex
Hi, Has anything changed since 2.0 for the dbmail_messages status column? The wiki has a wonderful thing called The DBMail Entity-Relationship-Model. A 2.1 version would be a blessing really. From there: * MESSAGE_STATUS_NEW = 0 * MESSAGE_STATUS_SEEN = 1 *

Re: [Dbmail] 2.1 and the deleting of messages

2006-07-06 Thread borvik
Hi Alex, I've also done a webmail and incorporated a undeleting so to speak. I used dbmail version 2.0.10. In order to accommodate this feature I added the column trash_flag to the messages table. While dbmail itself ignores it, my webmail uses it for putting the message into the trash can

Re: AW: [Dbmail] Re: Build from SVN trunk 2188 with Debian Sarge

2006-07-06 Thread Marc Dirix
Add these to your sources.list: deb http://debian.nfgd.net/debian unstable main deb-src http://debian.nfgd.net/debian unstable main After an update, build-dep should work as expected. I do not use the source itself however! I use svn-head when compiling. Kind regards, Marc Op