[Dbmail] upgrade to 3.1.17 do i need to run fix_foreign_keys.mysql

2016-02-25 Thread Admin Beckspaced
hello, im upgrading from 3.0.2 to 3.1.17 i know that i have to run 3_0_2-3_1_0.mysql to update the database schema but do i also need to run fix_foreign_keys.mysql script? can't find any answer and hopefully someone here can perhaps give me a hint? thanks becki ___

Re: [Dbmail] upgrade from 3.1.6 to latest

2014-11-02 Thread Paul J Stevens
On 31-10-14 10:38, Thomas Raschbacher wrote: > Am 30.10.2014 um 21:11 schrieb Rogerio Pereira: >> Hi, >> >> I also need to deploy Dbmail 3.2. But I need to share the same PgSQL 9.3 >> DB with another Dbmail 3.1.17. >> >> Is it possible? >> >> There are 4 SQL updates needed to install Dbmail

Re: [Dbmail] upgrade from 3.1.6 to latest

2014-10-31 Thread Thomas Raschbacher
Am 30.10.2014 um 21:11 schrieb Rogerio Pereira: > Hi, > > I also need to deploy Dbmail 3.2. But I need to share the same PgSQL 9.3 > DB with another Dbmail 3.1.17. > > Is it possible? > > There are 4 SQL updates needed to install Dbmail 3.2, mostly index > changes and new columns to dbmail ta

[Dbmail] upgrade from 3.1.6 to latest

2014-10-30 Thread Rogerio Pereira
Hi, I also need to deploy Dbmail 3.2. But I need to share the same PgSQL 9.3 DB with another Dbmail 3.1.17. Is it possible? There are 4 SQL updates needed to install Dbmail 3.2, mostly index changes and new columns to dbmail tables. Regards. Rogerio___

Re: [Dbmail] Upgrade to 3.1.17

2014-10-12 Thread Jorge Bastos
bject: Re: [Dbmail] Upgrade to 3.1.17 > > 3.1 had exactly one scheme change to fix sorting of messages > > > Ursprüngliche Nachricht > Von: Jorge Bastos > Gesendet: 12. Oktober 2014 17:57:20 MESZ > An: 'DBMail mailinglist' > Betreff: [Dbmail]

Re: [Dbmail] Upgrade to 3.1.17

2014-10-12 Thread Reindl Harald (mobile)
3.1 had exactly one scheme change to fix sorting of messages Ursprüngliche Nachricht Von: Jorge Bastos Gesendet: 12. Oktober 2014 17:57:20 MESZ An: 'DBMail mailinglist' Betreff: [Dbmail] Upgrade to 3.1.17 Hi guys, I solved an issue I had with my database

[Dbmail] Upgrade to 3.1.17

2014-10-12 Thread Jorge Bastos
Hi guys, I solved an issue I had with my database this night, where I wasn't able to apply the last database query for this series (truncate dbmail_envelope; CREATE UNIQUE INDEX dbmail_envelope_1 ON dbmail_envelope(physmessage_id); then dbmail-util -by). For what I see, till 3.1.17 there's

[Dbmail] upgrade from 3.1.6 to latest

2014-09-29 Thread Marius Karthaus
Hi list, Can I upgrade from 3.1.6 to 3.2 without touching/upgrading the postgres DB? (the DB is a separate server) And will there be a problem if I run the new 3.2 on a test setup while keeping the current 3.1.6 online during test phase? Regards, Marius dbmail-util -V This is DBMail version

[Dbmail] Upgrade to Master

2013-12-05 Thread Harald Leithner
Hi, I accidentally upgraded to master instead of latest 3.1 ;-) anyway I got the following error: --- Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447dc16000] Notice:[server] server_run(+776): starting main service loop for [IMAP] Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447d

Re: [Dbmail] Upgrade procedure

2013-10-25 Thread Curtis Maurand
On 10/24/2013 9:28 AM, Paul J Stevens wrote: On 21-10-13 19:54, Curtis Maurand wrote: I see several upgrade scripts in the sql folder. I'm assuming that since I'm on 2.2.18 I'll need to run them in order starting with 2_2-3_0.mysql? I know assumptions are a bad thing, but the docs folder is sc

Re: [Dbmail] Upgrade procedure

2013-10-24 Thread Paul J Stevens
On 21-10-13 19:54, Curtis Maurand wrote: > I see several upgrade scripts in the sql folder. I'm assuming that > since I'm on 2.2.18 I'll need to run them in order starting with > 2_2-3_0.mysql? I know assumptions are a bad thing, but the docs folder > is scarce and the Wiki is equally scarce on u

Re: [Dbmail] Upgrade procedure

2013-10-23 Thread Thomas Raschbacher
On 2013-10-23 19:17, Curtis Maurand wrote: I read UPGRADING (didn't see it there, thank you) It still does not outline the database change procedure other than a couple of things that you have to do after running it. Then again, what do I know? I'm just a dumb admin. It would be helpful to hav

Re: [Dbmail] Upgrade procedure

2013-10-23 Thread Curtis Maurand
On 10/22/2013 2:42 AM, Thomas Raschbacher wrote: On 2013-10-21 19:54, Curtis Maurand wrote: I see several upgrade scripts in the sql folder. I'm assuming that since I'm on 2.2.18 I'll need to run them in order starting with 2_2-3_0.mysql? I know assumptions are a bad thing, but the docs folder

Re: [Dbmail] Upgrade procedure

2013-10-21 Thread Thomas Raschbacher
On 2013-10-21 19:54, Curtis Maurand wrote: I see several upgrade scripts in the sql folder. I'm assuming that since I'm on 2.2.18 I'll need to run them in order starting with 2_2-3_0.mysql? I know assumptions are a bad thing, but the docs folder is scarce and the Wiki is equally scarce on upgra

[Dbmail] Upgrade procedure

2013-10-21 Thread Curtis Maurand
I see several upgrade scripts in the sql folder. I'm assuming that since I'm on 2.2.18 I'll need to run them in order starting with 2_2-3_0.mysql? I know assumptions are a bad thing, but the docs folder is scarce and the Wiki is equally scarce on upgrade procedures. building of the new versi

Re: [Dbmail] Upgrade from 2.2.1 to 3.0.2

2013-05-23 Thread Paul J Stevens
On 05/16/2013 10:44 AM, Thomas Raschbacher wrote: > All I did when I upgrade from 2.2.x to 3.0 was run the 2_2-3_0 upgrade. There *is* an UPGRADING document in the root of the source tree. Read it! Really, it contains information that is not evident if you simply run the migration. The source tre

Re: [Dbmail] Upgrade from 2.2.1 to 3.0.2

2013-05-16 Thread Curtis Maurand
On 5/16/2013 4:44 AM, Thomas Raschbacher wrote: All I did when I upgrade from 2.2.x to 3.0 was run the 2_2-3_0 upgrade. all 2.3 release were developer releases therefor you have no reason to apply those. As always try this on another machine with a copy of the db first ;) Thank you. I will d

Re: [Dbmail] Upgrade from 2.2.1 to 3.0.2

2013-05-16 Thread Thomas Raschbacher
All I did when I upgrade from 2.2.x to 3.0 was run the 2_2-3_0 upgrade. all 2.3 release were developer releases therefor you have no reason to apply those. As always try this on another machine with a copy of the db first ;) On 2013-05-15 18:58, Curtis Maurand wrote: I'm working on an upgrad

[Dbmail] Upgrade from 2.2.1 to 3.0.2

2013-05-15 Thread Curtis Maurand
I'm working on an upgrade from 2.2.1 to 3.0.2 I know, I should have done this a while ago, but I've been running Ubuntu and have not been able to get it to compile, nor are there any version out there in a repository (at least not a repository that I know about.). Anyway, the wiki documentati

Re: [Dbmail] Upgrade from ver. 1.2.x to latest ver. 3.x.x

2012-12-31 Thread Paul J Stevens
On 12/28/2012 06:22 PM, Wisp Lists wrote: > Hi, > We have dbmail installed as a manager and no mta work. We use postfix, > dovecot, roundcube and MySQL for emailing on a Debian box. > We would to upgrade to the latest version if possible. We obviously > would not like to break the server during the

Re: [Dbmail] Upgrade from ver. 1.2.x to latest ver. 3.x.x

2012-12-31 Thread Jesse Norell
If you haven't run across it yet, be sure to read this thread: http://www.gossamer-threads.com/lists/dbmail/users/32033 On Fri, 2012-12-28 at 12:22 -0500, Wisp Lists wrote: > Hi, > We have dbmail installed as a manager and no mta work. We use postfix, > dovecot, roundcube and MySQL for emailing

[Dbmail] Upgrade from ver. 1.2.x to latest ver. 3.x.x

2012-12-28 Thread Wisp Lists
Hi, We have dbmail installed as a manager and no mta work. We use postfix, dovecot, roundcube and MySQL for emailing on a Debian box. We would to upgrade to the latest version if possible. We obviously would not like to break the server during the upgrade. That already happened, when we tried t

Re: [Dbmail] upgrade failure

2008-05-22 Thread Peter Rabbitson
Paul J Stevens wrote: Curtis, It is quite safe to delete and re-create all the cache tables as created by the 2.0_2.2 upgrade script, and re-run dbmail-util -by after that. No messages will be lost. the whole list of caching tables: | dbmail_ccfield| | dbmail_datefield |

Re: [Dbmail] upgrade failure

2008-05-22 Thread Paul J Stevens
Curtis, It is quite safe to delete and re-create all the cache tables as created by the 2.0_2.2 upgrade script, and re-run dbmail-util -by after that. No messages will be lost. the whole list of caching tables: | dbmail_ccfield| | dbmail_datefield | | dbmail_envelope

Re: [Dbmail] upgrade failure

2008-05-22 Thread Curtis Maurand
-ay covers ctubpds (note that "b" is in there, but I think the order of things clobbers the headers. At any rate, it looks like I lost any headers that might have been in there when the operation was performed, not that anyone besides me was using imap anyway. After the upgrade amavis tried fu

Re: [Dbmail] upgrade failure

2008-05-22 Thread Jesse Norell
On Thu, 2008-05-22 at 09:36 -0400, Curtis Maurand wrote: > OK, I did something wrong. > > from the server where the upgrade was to go. > I did: > mysqladmin -p create dbmail > mysqldump -p -h old.server.com --database dbmail >dbmail.dump > mysql -p dbmail mysql -p dbmail dbmail-util -ay (I think

RE: [Dbmail] upgrade failure

2008-05-22 Thread Jorge Bastos
You have to run: dbmail-util -by > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Curtis Maurand > Sent: quinta-feira, 22 de Maio de 2008 14:36 > To: dbmail@dbmail.org > Subject: [Dbmail] upgrade failure > > OK, I did so

[Dbmail] upgrade failure

2008-05-22 Thread Curtis Maurand
OK, I did something wrong. from the server where the upgrade was to go. I did: mysqladmin -p create dbmail mysqldump -p -h old.server.com --database dbmail >dbmail.dump mysql -p dbmail dbmail Now all headers when connecting with any imap client are blank (no from, no subject). Do I need to do

Re: [Dbmail] Upgrade led to mysql conflicts

2008-05-06 Thread dbmail
On Tue, 6 May 2008, Gordon Hay wrote: On Tue, 6 May 2008, Gordon Hay wrote: I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the end of the process. DBMAIL (2.2.10) continues to work as expected. But a subsequent "yum update" to catch all the post-FC8 updates threw up a

[Dbmail] Upgrade led to mysql conflicts

2008-05-06 Thread Gordon Hay
On Tue, 6 May 2008, Gordon Hay wrote: > > I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the > > end of the process. DBMAIL (2.2.10) continues to work as expected. But > > a subsequent "yum update" to catch all the post-FC8 updates threw up a > > number of errors like this: > >

Re: [Dbmail] Upgrade led to mysql conflicts

2008-05-06 Thread Aleksander Kamenik
Gordon Hay wrote: I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the end of the process. DBMAIL (2.2.10) continues to work as expected. But a subsequent "yum update" to catch all the post-FC8 updates threw up a number of errors like this: file /usr/bin/msql2m

Re: [Dbmail] Upgrade led to mysql conflicts (fwd)

2008-05-06 Thread dbmail
On Tue, 6 May 2008, Gordon Hay wrote: I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the end of the process. DBMAIL (2.2.10) continues to work as expected. But a subsequent "yum update" to catch all the post-FC8 updates threw up a number of errors like this:

[Dbmail] Upgrade led to mysql conflicts

2008-05-06 Thread Gordon Hay
I upgraded my server from Fedora FC6 to FC8, and all seemed OK at the end of the process. DBMAIL (2.2.10) continues to work as expected. But a subsequent "yum update" to catch all the post-FC8 updates threw up a number of errors like this: file /usr/bin/msql2mysql from install of

Re: [Dbmail] Upgrade from dbmail 1.2.12.1 to 2.2.9

2008-03-10 Thread Bret Baptist
OK, sounds good, I will go ahead and remove those messages. I am not looking to support this 1.2 install any longer than I have to, hence the migration work. :-) Thanks much Paul. Bret. On Saturday 08 March 2008 3:52:09 am Paul J Stevens wrote: > Remove all messages and physmessages with si

Re: [Dbmail] Upgrade from dbmail 1.2.12.1 to 2.2.9

2008-03-08 Thread Paul J Stevens
Remove all messages and physmessages with size=0 Those empty message are very likely a side effect of some bug in 1.2's insertion code. We've come a very long way since then. Noone is interested in supporting dbmail 1.2 anymore unless someone at IC&S has some compelling business case with one of

Re: [Dbmail] Upgrade from dbmail 1.2.12.1 to 2.2.9

2008-03-07 Thread Bret Baptist
Any ideas on this at all? Thanks, Bret. On Tuesday 26 February 2008 6:07:22 pm Bret Baptist wrote: > On Saturday 16 February 2008 2:09:13 am Paul J Stevens wrote: > > Bret Baptist wrote: > > > On Friday 15 February 2008 2:47:57 am Paul J Stevens wrote: > > >> Bret Baptist wrote: > > > > > > Wha

Re: [Dbmail] Upgrade from dbmail 1.2.12.1 to 2.2.9

2008-02-26 Thread Bret Baptist
On Saturday 16 February 2008 2:09:13 am Paul J Stevens wrote: > Bret Baptist wrote: > > On Friday 15 February 2008 2:47:57 am Paul J Stevens wrote: > >> Bret Baptist wrote: > > What does this message mean? Is there anything that > > I can check related to this message to see if there are any issue

Re: [Dbmail] Upgrade from dbmail 1.2.12.1 to 2.2.9

2008-02-16 Thread Paul J Stevens
Bret Baptist wrote: > On Friday 15 February 2008 2:47:57 am Paul J Stevens wrote: >> Bret Baptist wrote: >>> I am attempting to do an upgrade from 1.2.12.1 to the latest 2.2.9. I >>> was able to update the database schema with only a little bit of trouble. >> Define a little trouble. If you did a

Re: [Dbmail] Upgrade from dbmail 1.2.12.1 to 2.2.9

2008-02-15 Thread Bret Baptist
On Friday 15 February 2008 2:47:57 am Paul J Stevens wrote: > Bret Baptist wrote: > > I am attempting to do an upgrade from 1.2.12.1 to the latest 2.2.9. I > > was able to update the database schema with only a little bit of trouble. > > Define a little trouble. If you did a schema migration like

Re: [Dbmail] Upgrade from dbmail 1.2.12.1 to 2.2.9

2008-02-15 Thread Paul J Stevens
Bret Baptist wrote: > I am attempting to do an upgrade from 1.2.12.1 to the latest 2.2.9. I was > able to update the database schema with only a little bit of trouble. Define a little trouble. If you did a schema migration like 1.2.12.1->2.0.11->2.2.9 you shouldn't have had any problem at all.

[Dbmail] Upgrade from dbmail 1.2.12.1 to 2.2.9

2008-02-14 Thread Bret Baptist
I am attempting to do an upgrade from 1.2.12.1 to the latest 2.2.9. I was able to update the database schema with only a little bit of trouble. However during the "dbmail-util -by" run I am seeing messages like this: Feb 14 10:37:58 bedlam dbmail-util[20253]: Error:[message] dbmail-message.c,

Re: [Dbmail] Upgrade problem to dbmail_2.2.3-1_i386.deb

2007-04-29 Thread DTK
On 4/29/07, Guido Piazzi <[EMAIL PROTECTED]> wrote: Il giorno 29/apr/07, alle ore 04:39, DTK ha scritto: > dpkg: error processing /var/cache/apt/archives/dbmail_2.2.3-1_i386.deb > (--unpack): > trying to overwrite `/usr/lib/dbmail/libsort_sieve.so.0.0.0', which > is also in package dbmail-sieve

Re: [Dbmail] Upgrade problem to dbmail_2.2.3-1_i386.deb

2007-04-29 Thread Guido Piazzi
Il giorno 29/apr/07, alle ore 04:39, DTK ha scritto: dpkg: error processing /var/cache/apt/archives/dbmail_2.2.3-1_i386.deb (--unpack): trying to overwrite `/usr/lib/dbmail/libsort_sieve.so.0.0.0', which is also in package dbmail-sieve dpkg-deb: subprocess paste killed by signal (Broken pipe)

[Dbmail] Upgrade problem to dbmail_2.2.3-1_i386.deb

2007-04-28 Thread DTK
Preconfiguring packages ... (Reading database ... 65101 files and directories currently installed.) Preparing to replace dbmail 2.2.1-1 (using .../dbmail_2.2.3-1_i386.deb) ... Stopping dbmail servers: dbmail-imapd .dbmail-pop3d .dbmail-lmtpd .dbmail-timsieved .No dbmail-timsieved found running; no

RE: [Dbmail] Upgrade from 2.1.7 to 2.2.4

2007-03-17 Thread List Receiver
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Paul J Stevens > Sent: Saturday, March 17, 2007 1:26 AM > To: DBMail mailinglist > Subject: Re: [Dbmail] Upgrade from 2.1.7 to 2.2.4 > > List Receiver wrote: > > So, I

Re: [Dbmail] Upgrade from 2.1.7 to 2.2.4

2007-03-17 Thread Paul J Stevens
List Receiver wrote: > So, I know that I should be shot for not upgrading sooner, but I'm > planning to do an upgrade from 2.1.7 to 2.2.4 (or .5 if that comes out > in the next couple days). > > My only question is: Do I need to re-run the migrate script following > the upgrade? I had run the scr

[Dbmail] Upgrade from 2.1.7 to 2.2.4

2007-03-16 Thread List Receiver
So, I know that I should be shot for not upgrading sooner, but I'm planning to do an upgrade from 2.1.7 to 2.2.4 (or .5 if that comes out in the next couple days). My only question is: Do I need to re-run the migrate script following the upgrade? I had run the script when I upgraded to 2.1.7, but

Re: AW: [Dbmail] Upgrade?!

2007-01-15 Thread zamri
On 1/15/07, Aaron Stone <[EMAIL PROTECTED]> wrote: On Mon, 2007-01-15 at 12:14 +0800, zamri wrote: > I would like to use dbmail-timsieve with avelsieve plugin for > squirrelmail. Anyone experience with this setup? Is it ok? It works. Aaron Thanks Aaron. I actually have tested the plugin and

Re: AW: [Dbmail] Upgrade?!

2007-01-14 Thread Aaron Stone
On Mon, 2007-01-15 at 12:14 +0800, zamri wrote: > I would like to use dbmail-timsieve with avelsieve plugin for > squirrelmail. Anyone experience with this setup? Is it ok? It works. Aaron ___ DBmail mailing list DBmail@dbmail.org https://mailman.fast

Re: AW: [Dbmail] Upgrade?!

2007-01-14 Thread zamri
On 1/11/07, zamri <[EMAIL PROTECTED]> wrote: On 1/11/07, zamri <[EMAIL PROTECTED]> wrote: > On 1/11/07, zamri <[EMAIL PROTECTED]> wrote: > > Sorry. I need to mention that it is for old messages. For new messages > > I got it correct. I mean the From column is listed unknown and the > > Subject co

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread zamri
On 1/11/07, zamri <[EMAIL PROTECTED]> wrote: On 1/11/07, zamri <[EMAIL PROTECTED]> wrote: > Sorry. I need to mention that it is for old messages. For new messages > I got it correct. I mean the From column is listed unknown and the > Subject column is no subject in SquirrelMail for all old mails.

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread zamri
On 1/11/07, zamri <[EMAIL PROTECTED]> wrote: Sorry. I need to mention that it is for old messages. For new messages I got it correct. I mean the From column is listed unknown and the Subject column is no subject in SquirrelMail for all old mails. When I tried sending new mail to this server, I g

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread zamri
Sorry. I need to mention that it is for old messages. For new messages I got it correct. I mean the From column is listed unknown and the Subject column is no subject in SquirrelMail for all old mails. When I tried sending new mail to this server, I got it correct. I mean no problem for new mails

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread zamri
On 1/11/07, Paul J Stevens <[EMAIL PROTECTED]> wrote: trace_syslog=5 Hi Paul, There's nothing in my dbmail.log. When mail arrives, there are debug messages in /var/log/mail/info. Do u need that? I have chown dbmail.log to nobody and nogroup as stated in dbmail.conf. -- zamri Linux System Adm

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread Paul J Stevens
trace_syslog=5 zamri wrote: > On 1/11/07, Geir Voll Nielsen <[EMAIL PROTECTED]> wrote: >> zamri wrote: >> > Hi all, >> > >> > I upgrade it at last. >> > >> > make install >> > mysql -u dbmail -p dbmail < sql/migrate_from_2.0_to_2.2.mysql >> > cp dbmail.conf /etc/dbmail.conf >> > >> > After changin

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread zamri
On 1/11/07, Geir Voll Nielsen <[EMAIL PROTECTED]> wrote: zamri wrote: > Hi all, > > I upgrade it at last. > > make install > mysql -u dbmail -p dbmail < sql/migrate_from_2.0_to_2.2.mysql > cp dbmail.conf /etc/dbmail.conf > > After changing all the details in dbmail.conf, I restart dbmail-imapd >

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread Geir Voll Nielsen
zamri wrote: > Hi all, > > I upgrade it at last. > > make install > mysql -u dbmail -p dbmail < sql/migrate_from_2.0_to_2.2.mysql > cp dbmail.conf /etc/dbmail.conf > > After changing all the details in dbmail.conf, I restart dbmail-imapd > and dbmail-lmtpd. Loging in and all subject listed is (n

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread zamri
Hi all, I upgrade it at last. make install mysql -u dbmail -p dbmail < sql/migrate_from_2.0_to_2.2.mysql cp dbmail.conf /etc/dbmail.conf After changing all the details in dbmail.conf, I restart dbmail-imapd and dbmail-lmtpd. Loging in and all subject listed is (no subject) and the From column i

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread Aleksander
zamri wrote: u mean I need at least twice the current db size space? How do I check my db size? What I meant is if you load data into a empty db, you might get a innodb file the size of 10GB. When you run optimize etc on it, it might double the size of the file, although the amount of data in

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread zamri
On 1/11/07, Aleksander <[EMAIL PROTECTED]> wrote: zamri wrote: > I'm running Mandriva Linux > 2006 64 bit edition live mail system. There's a new thread on this list about Mandriva keeping the max file size at 16GB. I think it's ext3. Check it and see if you're affected. My system uses reiserfs

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread Aleksander
zamri wrote: I'm running Mandriva Linux 2006 64 bit edition live mail system. There's a new thread on this list about Mandriva keeping the max file size at 16GB. I think it's ext3. Check it and see if you're affected. Before running the migrate script stop imap/smtp/lmtp/www, so nobody can ch

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread Jorge Bastos
!! hehe Jorge - Original Message - From: "zamri" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Thursday, January 11, 2007 9:30 AM Subject: Re: AW: [Dbmail] Upgrade?! On 1/11/07, Jorge Bastos <[EMAIL PROTECTED]> wrote: I would advice the same. B

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread zamri
ail mailinglist" Sent: Thursday, January 11, 2007 8:32 AM Subject: Re: AW: [Dbmail] Upgrade?! >I would do a trial upgrade at a testserver if possible. > > Kind regards, > > Marc Dirix > > ___ > DBmail mai

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread Jorge Bastos
ot; Sent: Thursday, January 11, 2007 8:32 AM Subject: Re: AW: [Dbmail] Upgrade?! I would do a trial upgrade at a testserver if possible. Kind regards, Marc Dirix ___ DBmail mailing list DBmail@dbmail.org https://mailman.fa

Re: AW: [Dbmail] Upgrade?!

2007-01-11 Thread Marc Dirix
I would do a trial upgrade at a testserver if possible. Kind regards, Marc Dirix ___ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: AW: [Dbmail] Upgrade?!

2007-01-10 Thread zamri
Hi all, After too much coffee and hundreds of coin toss, I decide to upgrade my 2.0.9 to the latest 2.2.1. I just wanna know experience from other admins who had upgraded their systems from 2.0 to 2.2 before i take the plunge. Was it enough just to follow intructions from UPGRADING file? Was it a

Re: AW: [Dbmail] Upgrade?!

2006-11-18 Thread Paul J Stevens
[EMAIL PROTECTED] wrote: > no reply yet?! usually there are tons of replies to issues which are > even not that important. > upgrading and knowing what differences are between 2.0 and 2.2 ist > pretty important. > e.g. database model?! any changes?! do i have to change ANYTHING to the > database?!

AW: [Dbmail] Upgrade?!

2006-11-18 Thread sl
lto:[EMAIL PROTECTED] Im Auftrag von [EMAIL PROTECTED] Gesendet: Freitag, 17. November 2006 12:12 An: dbmail@dbmail.org Betreff: [Dbmail] Upgrade?! Wichtigkeit: Hoch Well, since 2.2 is considered stable and 2.0 ist "old stable" id like to know what is the upgrade process for live systems?! The

[Dbmail] Upgrade?!

2006-11-17 Thread sl
Well, since 2.2 is considered stable and 2.0 ist "old stable" id like to know what is the upgrade process for live systems?! The "documentation" has no sections about this. SO! what to do for upgrading from 2.0.10 to 2.2.0?! any risky cliffs?! maybe adding an upgrade instruction set to the read

Re: [Dbmail] dbmail upgrade and dbmail_sieve vs libsieve

2006-06-14 Thread Paul J Stevens
DK wrote: > On 6/13/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: >> DK wrote: >> > Hello, >> >> > When I do install dbmail 2.16 it removes dbmail2-mysql first. >> > So would this work: >> > 1) backup dbmail mysql database >> > 2) backup /etc/dbmail/ >> >> always a very good idea. >> >> 2a) stop yo

Re: [Dbmail] dbmail upgrade and dbmail_sieve vs libsieve

2006-06-13 Thread DK
On 6/13/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: DK wrote: > Hello, > When I do install dbmail 2.16 it removes dbmail2-mysql first. > So would this work: > 1) backup dbmail mysql database > 2) backup /etc/dbmail/ always a very good idea. 2a) stop your MTA (postfix?) to prevent mail from b

Re: [Dbmail] dbmail upgrade and dbmail_sieve vs libsieve

2006-06-13 Thread DK
On 6/13/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: DK wrote: > On 6/13/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: >> >> >> DK wrote: >> > Hello, >> > >> > I am not quite clear with all this: >> > My current version is dbmail 2.0.9-1 stable deb pkg >> >> that would be dbmail2-mysql then. >>

Re: [Dbmail] dbmail upgrade and dbmail_sieve vs libsieve

2006-06-13 Thread Paul J Stevens
DK wrote: > On 6/13/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: >> >> >> DK wrote: >> > Hello, >> > >> > I am not quite clear with all this: >> > My current version is dbmail 2.0.9-1 stable deb pkg >> >> that would be dbmail2-mysql then. >> >> > >> > I have filters in table dbmail_filters define

Re: [Dbmail] dbmail upgrade and dbmail_sieve vs libsieve

2006-06-13 Thread DK
On 6/13/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: DK wrote: > Hello, > > I am not quite clear with all this: > My current version is dbmail 2.0.9-1 stable deb pkg that would be dbmail2-mysql then. > > I have filters in table dbmail_filters defined and they work fine. > My guess is dbmail

Re: [Dbmail] dbmail upgrade and dbmail_sieve vs libsieve

2006-06-13 Thread Paul J Stevens
DK wrote: > Hello, > > I am not quite clear with all this: > My current version is dbmail 2.0.9-1 stable deb pkg that would be dbmail2-mysql then. > > I have filters in table dbmail_filters defined and they work fine. > My guess is dbmail handles that without sieve?!? Yes. But only in the d

[Dbmail] dbmail upgrade and dbmail_sieve vs libsieve

2006-06-12 Thread DK
Hello, I am not quite clear with all this: My current version is dbmail 2.0.9-1 stable deb pkg I have filters in table dbmail_filters defined and they work fine. My guess is dbmail handles that without sieve?!? I have libsieve1 2.1.10-1 installed but not configured. I am considering to upgrad

Re: [Dbmail] Upgrade

2006-05-30 Thread Jacques Beaudoin
Hi Jonathan, I have script that does a upgrade from a dbmail-1.2.9 to dbamil-2.0.10, I could modify it for you to make it more readable. You have in that script all the steps to migrate from one server to a other. This script also migrate Horde-IMP webmail do you nead that... ? For 2,200 users

[Dbmail] Upgrade

2006-05-30 Thread Jonathan Lindsey
Currently my two mail servers are running dbmail version 1.9something. I had hardware failures on my mysql servers and have rebuilt one of them with a new version of mysql. The old was running 3, the new is running mysql 4. I all of my other daemons work except for dbmail when I convert over

Re: [Dbmail] Upgrade

2006-05-17 Thread Paul J Stevens
Humberto Valiente wrote: > Sorry Paul, > > The version im running is 2.0.4. > The procedure to upgrade to the version 2.0.10 is the same? You should be able to upgrade without *any* problem then. If there have been any changes at all, they will have been tiny. # added ON UPDATE CASCADE to create

Re: [Dbmail] Upgrade

2006-05-17 Thread Humberto Valiente
Sorry Paul, The version im running is 2.0.4. The procedure to upgrade to the version 2.0.10 is the same? Regards, Humberto On 5/16/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: Humberto Valiente wrote: > We are actually running and "very" but "very old version" of dbmail > More specifically,

Re: [Dbmail] Upgrade

2006-05-16 Thread Paul J Stevens
Humberto Valiente wrote: > We are actually running and "very" but "very old version" of dbmail > More specifically, we are running version 1.105.2.3 > 2004/12/27 21:41:07 paul Exp $ That looks like a CVS version, and I know I never worked on the 1.2 series (unless you're runni

[Dbmail] Upgrade

2006-05-16 Thread Humberto Valiente
We are actually running and "very" but "very old version" of dbmail More specifically, we are running version 1.105.2.3 2004/12/27 21:41:07 paul Exp $ It is working perfectly but we want to change it to the latest stable version 2.0.10 Could be problems doing the upgrade? or the precedure is

Re: [Dbmail] Upgrade sql scripts

2006-03-31 Thread Paul J Stevens
Jorge Bastos wrote: > Paul, > > Is it possible to update the SQL scripts for mysql, to use ENGINE > instead of TYPE ? Of course, mysql-5 users will need that. Will do. -- Paul Stevens p

[Dbmail] Upgrade sql scripts

2006-03-31 Thread Jorge Bastos
Paul, Is it possible to update the SQL scripts for mysql, to use ENGINE instead of TYPE ? Jorge Bastos

Re: [Dbmail] Upgrade

2006-02-18 Thread Jorge Bastos
ok paul, i'll take your advice, Jorge - Original Message - From: "Paul J Stevens" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Friday, February 17, 2006 10:43 PM Subject: Re: [Dbmail] Upgrade Jorge Bastos wrote: Hum.. ok no problem, wha

Re: [Dbmail] Upgrade

2006-02-17 Thread Paul J Stevens
han 2.0, but if you need predictable results, and don't really need the new features, stick to 2.0 for now. > > Jorge > > - Original Message - From: "Paul J Stevens" <[EMAIL PROTECTED]> > To: "DBMail mailinglist" > Sent: Thursday, February 16,

Re: [Dbmail] Upgrade

2006-02-16 Thread Jorge Bastos
ebruary 16, 2006 7:58 PM Subject: Re: [Dbmail] Upgrade Jorge Bastos wrote: Sorry me again, After i've looked another time, i saw this: TEST_3 Request: SEARCH CHARSET "iso-8859-1" ALL * Response: NO specified charset is not supported TEST_4

Re: [Dbmail] Upgrade

2006-02-16 Thread Paul J Stevens
Jorge Bastos wrote: > Sorry me again, > After i've looked another time, i saw this: > TEST_3 > > Request: > SEARCH CHARSET "iso-8859-1" ALL * > Response: > NO specified charset is not supported > TEST_4 > > Request: > THREAD REFERENCES iso-8859-1 ALL >

Re: [Dbmail] Upgrade

2006-02-16 Thread Jorge Bastos
essage - From: "Paul J Stevens" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Thursday, February 16, 2006 6:36 PM Subject: Re: [Dbmail] Upgrade Jorge, If you're already running a recent 2.0 release (2.0.7 right?), it won't hurt to upgrade. Perhaps yo

Re: [Dbmail] Upgrade

2006-02-16 Thread Jorge Bastos
Jorge - Original Message - From: "Paul J Stevens" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Thursday, February 16, 2006 6:36 PM Subject: Re: [Dbmail] Upgrade Jorge, If you're already running a recent 2.0 release (2.0.7 right?), it won't hurt to

Re: [Dbmail] Upgrade

2006-02-16 Thread Paul J Stevens
Jorge, If you're already running a recent 2.0 release (2.0.7 right?), it won't hurt to upgrade. Perhaps you can tell us if bug 293 was relevant to sm users. Jorge Bastos wrote: > Sorry beeing repeating myself, i think i already made this question, but > i don't remember. > Should i upgrade to 2.

[Dbmail] Upgrade

2006-02-16 Thread Jorge Bastos
DecimalSorry beeing repeating myself, i think i already made this question, but i don't remember. Should i upgrade to 2.0.9? Does the "fix incorrect processing of LIST command (closes: #293)" has anything to the problem with squirrelmail? Jorge

Re: [Dbmail] Upgrade path from 1.x to 2.x?

2005-11-04 Thread Paul J Stevens
Alan, there are well tested scripts like migrate_from_1.x_to_2.0_innodb.mysql in the 2.0 distribution. Make sure you test them before committing your main data to them though. If you're an oldtime 1.x user, chances are the migrate script will have to be tweaked especially when it comes to the dro

Re: [Dbmail] Upgrade path from 1.x to 2.x?

2005-11-04 Thread Jesse Norell
There's an upgrade script to update from 1.2 (not 1.0) to 2.0 .. should be included in the 2.0 source. You'll want/need to make a copy of your database run that script against it, fixing anything that breaks, till you figure out exactly what's needed. I think there may have been minor database ch

[Dbmail] Upgrade path from 1.x to 2.x?

2005-11-04 Thread Alan Lew
Hello all. I'm running a pretty large mail database under DBMail 1.0. I'm noticing very annoying speed issues and would like to upgrade to 2.0. Is there a migration path from 1.0 to 2.0? For example, are there scripts to migrate the database structure, etc? Thanks! -- Alan Lew, B.Sc. Internet So

Re: [Dbmail] Upgrade issues

2005-01-12 Thread Paul J Stevens
Dominic Amann wrote: I am currently running dbmail-mysql version 1.2.11-1, with dbmail-imapd and postfix on a production server. I am debating whether to upgrade to 2.0.3, and I would need a few questions answered to make this decision: 1. Is 2.0.3 stable (compared to 1.2.11)? I should blood

Re: [Dbmail] Upgrade issues

2005-01-12 Thread Tim
Quoth Dominic Amann: > I am currently running dbmail-mysql version 1.2.11-1, with dbmail-imapd > and postfix on a production server. I am debating whether to upgrade to > 2.0.3, and I would need a few questions answered to make this decision: > > 1. Is 2.0.3 stable (compared to 1.2.11)? in my e

[Dbmail] Upgrade issues

2005-01-12 Thread Dominic Amann
I am currently running dbmail-mysql version 1.2.11-1, with dbmail-imapd and postfix on a production server. I am debating whether to upgrade to 2.0.3, and I would need a few questions answered to make this decision: 1. Is 2.0.3 stable (compared to 1.2.11)? 2. Is migration straightforward (on de

Re: [Dbmail] DBMAIL upgrade 1.2.2 to 1.2.9

2004-06-11 Thread Paul J Stevens
Becki, Better do it so you know for sure, period. So use diff: - #!/bin/sh mysqladmin create dbmailtmp mysql dbmailtmp < .../sql/mysql/create_tables_innoDB.mysql mysqldump -d dbmail > dbmail-1.2.2.mysql mysqldump -d dbmailtmp > dbmail-1.2.9.mysql diff dbmail-1.2.2.mysql dbmail-1.2.9.mysql --

[Dbmail] DBMAIL upgrade 1.2.2 to 1.2.9

2004-06-11 Thread becki
hello ilja, thanks again a lot for your reply - you are very helpful ;-) so ... a 1.2.2 version with passwd field of varchar(32) sounds a bit strange .. well that's what i got on my runing system ! anyway ... will send you a dump of the mysql database structure. hopefully you can tell me if th

  1   2   >