Thread: [CSCMail-Users] Migration to cscmail-1.7.8

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi,

i downloaded the latest version and tried to migrate to it.  What
scripts do i need to run?  I couldn't find no information about it
in the "changelog".

Best regards,
Torsten.

Torsten Mohr was overheard mumbling something about this on 12 Sep 2000
05:38:41 CEST

> Hi,
>  
>  i downloaded the latest version and tried to migrate to it.	What
>  scripts do i need to run?  I couldn't find no information about it
>  in the "changelog".

The changelog details all the DB changes that need to be made in conjunction
with an upgrade... but it doesn't do so in ONE place... basically what you have
to do is read the ChangeLog from the date of 1.6.1 release onward, and apply
any changes you come accross.

The EASIEST upgrade path is to simply EXPORT all of your mail to MBOX in 1.6.1
.. wipe your database and delete your ~/.cscmail directory, and then install
1.7.x and re-import all of your mail... of course, this doesn't keep your
filters, accounts, addressbook, or folder settings .. so if you have a lot of
these things, it is better to read the changelog and apply the changes by
hand...  do not worry however, the WORST that can happen if you upgrade to
1.7.x without doing any DB migration stuff is that CSCMail can crash / give
errors when you try to do stuff (send a message, etc) and the good news is, it
will give an error that sort of explains what you missed, so you can then grep
for that in the ChangeLog to see what to do.. hehe (trial and error...) but
this will not cause loss of mail...

This, BTW, is why 1.7.x IS 1.7.x and not 1.8.0 ... I have been kinda lazy/busy
recently and haven't written the migration scripts yet....

-CZ

I recently upgrade my 1.6.1 to 1.7.8. The only thing that changed with the
data format was that CZ added the BCC field to the messages database. So you
have to add this filed manually.
If you use CSV-"Database" this is very easy, just add the column to the
messages file and complete the old messages with a comma at the end.
If you're using a real database you have to add it there. For example in
MySQL. (Actually I dont remember the command to do this, I found it somewhere
in the documentation of MySQL on the Web)

To make sure you dont lose data I would also export all the messages. Just
in case something goes wrong.

I hope this helps

Daniel

PS: CZ, please correct me if I'm wrong with the changes: I couldn't find
any other database changes than the BCC field and my 1.7.8 works really fine
now.

> Hi,
> 
> i downloaded the latest version and tried to migrate to it.  What
> scripts do i need to run?  I couldn't find no information about it
> in the "changelog".
> 
> 
> Best regards,
> Torsten.

-- 
Sent through GMX FreeMail - http://www.gmx.net

Daniel Schregenberger was overheard mumbling something about this on Tue, 12
Sep 2000 12:08:25 +0200 (MEST)

> I recently upgrade my 1.6.1 to 1.7.8. The only thing that changed with the
>  data format was that CZ added the BCC field to the messages database. So you
>  have to add this filed manually.
>  If you use CSV-"Database" this is very easy, just add the column to the
>  messages file and complete the old messages with a comma at the end.
>  If you're using a real database you have to add it there. For example in
>  MySQL. (Actually I dont remember the command to do this, I found it
>  somewhere
>  in the documentation of MySQL on the Web)
>  
>  To make sure you dont lose data I would also export all the messages. Just
>  in case something goes wrong.
>  
>  I hope this helps
>  
>  Daniel
>  
>  PS: CZ, please correct me if I'm wrong with the changes: I couldn't find
>  any other database changes than the BCC field and my 1.7.8 works really fine
>  now.

Also you need to add the mimetypes and lists tables...

create table mimetypes (id int4, mime text, command text, icon text);
create table lists (id int4, address text, description text);

Mimetypes is for the "view" mime association stuff, and lists is for the "reply
to list" feature (for those @gnome.org and other mailing lists that set
reply-to to the sender, not the list...)

Check through the mailing list archives and the changelog for details...

-CZ

Thread: [CSCMail-Users] Migration to cscmail-1.7.8

cscmail-users