Re: [SOGo] Migration from sogo 4.3.x to 5.x

[Odhiambo Washington]

On Wed, Apr 6, 2022 at 2:40 PM Albert Shih  wrote:

> Hi everyone
>
> Just like to know if it's safe to upgrade from Debian 9 + sogo 4 to Debian
> 11 + sogo 5 without problem ?
>
> Do I need to do some upgrade in the database schema ?
>
> That's mean of course migrating from pgsql 9.6 to 13.
>

There were no database changes between 4.x and 5.x.

https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_upgrading


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration from sogo 4.3.x to 5.x

[cedric.archamb...@solidairesfinancespubliques.org]

Hi Albert,

*Only on a database point of view* : From 4.* to 5.*, (almost) no sql 
modification, only a recent modification on table sogo_sessions_folder 
(https://github.com/inverse-inc/sogo/commit/3e11e0a62a454e8e9fbd2f867452e34e3513793a), 
but without script, rename or remove it and it's OK after sogo restart.


FYI, you can find history scripts here : 
https://github.com/inverse-inc/sogo/tree/master/Scripts (or locally in 
/usr/share/doc/sogo/ after upgrade).


Regards

Cédric Archambeau
Secrétariat National Solidaires Finances Publiques
Pôle Communication - Informatique

Le 06/04/2022 à 08:44, Albert Shih (albert.s...@obspm.fr) a écrit :

Hi everyone

Just like to know if it's safe to upgrade from Debian 9 + sogo 4 to Debian
11 + sogo 5 without problem ?

Do I need to do some upgrade in the database schema ?

That's mean of course migrating from pgsql 9.6 to 13.

Regards
--
Albert SHIH
Observatoire de Paris
France
Heure local/Local time:
mer. 06 avril 2022 08:40:48 CEST

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration to Mailcow, any experiences/tutorials/hints?

[Odhiambo Washington]

On Thu, Feb 10, 2022 at 3:47 PM Kai-Uwe Rommel - ARS  wrote:

> Hello,
>
>
>
> I’m currently running an old server on CentOS 6 with postfix/dovecot and
> SOGo 2.4 and MySQL DB as authentication source for the users.
>
> I need to do a complete overhaul to current software levels, obviously.
> After thinking over this for a while and looking around I found that it
> seems
>
> to make the most sense for me to move to a new Ubuntu VM and run a local
> Mailcow dockerized deployment.
>
> That seems to offer about the same moving parts (postfix, dovecot, SOGo,
> MariaDB), in a more integrated and easily upgradable way.
>
> Did anyone do such a migration from a conventional manual setup into a
> Mailcow setup, e.g. including user/data migration
>
> and could share the experience, hints, warnings etc.? Thanks.
>
> In particular, I’d like to know how to
>
>- move the user name/password table(s)
>- move the mail data of dovecot
>- move the calendar/contact data of SOGo
>
> I haven’t yet seen a tutorial or similar for such a migration.
>
>
>
> Kai-Uwe Rommel
>

Your question would be better answered in the Mailcow forums.

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration v3 to 4 new machine

[Christian Mack]

Am 18.10.19 um 11:00 schrieb Thierry Murgue
(thierry.mur...@univ-st-etienne.fr):
> Le 18/10/2019 à 10:13, Christian Mack (christian.m...@uni-konstanz.de) a
> écrit :
>> Am 17.10.19 um 23:36 schrieb Robert A Wooldridge
>> (bob.wooldri...@edm-inc.com):
>>> I would like to migrate my current sogo config which is version 3 to a
>>> new machine using v4.  Any suggestions on the best way to approach this?
>>>
>>
>> 1) setup empty V4
>> 2) get a complete Backup with sogo-tool on V3
>> 3) move backup data to V4 machine (rsync)
>> 4) restore with sogo-tool
>>
>> See also:
>> http://wiki.sogo.nu/backupRestore
>>
> 
> Should I do the same, if I just want to upgrade in-place a v3 install on
> same server like :
>  1) backup with sogo-tool
>  2) backup sogo.conf
>  3) delete v3 packages (purge SQL database)
>  4) install v4 packages (create empty database)
>  5) restore sogo.conf
>  6) restore with sogo-tool?
> 
> Is it the best way, the more secure one?
> 

You should always make a backup with sogo-tool before Upgrading a major
release.

But if you already were on 9 tables database layout in V3, and want to
keep it, I would just use the upgrade script provided in V4.
Else do it via sogo-tool restore.
That way is a little bit cleaner, but the script will be a lot faster.
With a little bit cleaner I mean, that it will store all recurring
events with exceptions in the new format.
The script will keep those the way they are, till you change them via
SOGo webinterface or calDAV [or ActiveSync].


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Migration v3 to 4 new machine

[Thierry Murgue]

Le 18/10/2019 à 10:13, Christian Mack (christian.m...@uni-konstanz.de) a 
écrit :

Am 17.10.19 um 23:36 schrieb Robert A Wooldridge
(bob.wooldri...@edm-inc.com):

I would like to migrate my current sogo config which is version 3 to a
new machine using v4.  Any suggestions on the best way to approach this?



1) setup empty V4
2) get a complete Backup with sogo-tool on V3
3) move backup data to V4 machine (rsync)
4) restore with sogo-tool

See also:
http://wiki.sogo.nu/backupRestore


Kind regards,
Christian Mack


Hi!

Should I do the same, if I just want to upgrade in-place a v3 install on 
same server like :

 1) backup with sogo-tool
 2) backup sogo.conf
 3) delete v3 packages (purge SQL database)
 4) install v4 packages (create empty database)
 5) restore sogo.conf
 6) restore with sogo-tool?

Is it the best way, the more secure one?

Thanks in advance,
Regards,
--
Thierry MURGUE.
__
Docteur en Informatique
Ingénieur d'études, Université Jean Monnet, DNum
Pôle Infrastructures et données
21, rue du docteur Paul Michelon
42023 Saint-Étienne, Cédex 2, France.
Tél. : +33.(0)4.69.66.31.22 Fax : +33.(0)4.77.48.50.69
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration v3 to 4 new machine

[Christian Mack]

Am 17.10.19 um 23:36 schrieb Robert A Wooldridge
(bob.wooldri...@edm-inc.com):
> I would like to migrate my current sogo config which is version 3 to a
> new machine using v4.  Any suggestions on the best way to approach this?
> 

1) setup empty V4
2) get a complete Backup with sogo-tool on V3
3) move backup data to V4 machine (rsync)
4) restore with sogo-tool

See also:
http://wiki.sogo.nu/backupRestore


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Migration from LDAP to AD

[idmi...@droidox.com]

Hello!

I have issue that emails forwarded from my phone not showing as 
forwarded on my computer.


Or i can said that: email forwarded with exchange protocol not showing 
as forwarded like forwarded with IMAP.


Have anyone advise? Thanks!


Regards,
Dmitry
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

That sounds great! I am on Debian 8.

Thanks in advance,
Adrian

Am 13.05.2016 um 17:18 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 12:14, Adrian Figueroa (adr...@figueroa.cc) wrote:


Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.


I think I've just found and fixed that issue.

Which distro are you using? I can generate an updated nightly build 
for you to test.


Thanks,

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists




smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Migration script problem

[Adrian Figueroa]

It works great! All data is back without issues. Thanks for your efforts.

Adrian

Am 13.05.2016 um 17:18 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 12:14, Adrian Figueroa (adr...@figueroa.cc) wrote:


Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.


I think I've just found and fixed that issue.

Which distro are you using? I can generate an updated nightly build 
for you to test.


Thanks,

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists




smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Migration script problem

[Ludovic Marcotte]

On 2016-05-08 12:14, Adrian Figueroa (adr...@figueroa.cc) wrote:


Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.


I think I've just found and fixed that issue.

Which distro are you using? I can generate an updated nightly build for 
you to test.


Thanks,

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

Is there a way to manually revert the table structure to the old one? I 
have unfortunately done this to data I actually need.. I know, I should 
not have.


Kind regards,
Adrian

Am 09.05.2016 um 15:09 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, I can now not even access the calendar page in the sogo web 
interface. It tells me "502 proxy error" in the browser


Sogo.log shows:

May 09 15:05:46 sogod [25995]: <0x0x7f0df4397eb0[GCSFolderManager]> 
folderAtPath: SELECT c_folder_id, c_path, c_location, 
c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info 
WHERE c_path1 = 'Users' AND c_path2 = 'adr...@figueroa.cc' AND c_path3 
= 'Calendar' AND c_path4 = 'personal'


May 09 15:05:46 sogod [25995]: <0x0x7f0df4397eb0[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 3; 
"c_folder_type" = Appointment; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Calendar/personal"; "c_quick_location" = 
""; }


May 09 15:05:46 sogod [25995]: <0x0x7f0df4397eb0[GCSFolderManager]> 
folderAtPath: SELECT c_folder_id, c_path, c_location, 
c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info 
WHERE c_path1 = 'Users' AND c_path2 = 'adr...@figueroa.cc' AND c_path3 
= 'Calendar' AND c_path4 = '5645-57308380-1-1E775DC0'
EXCEPTION:  
NAME:NSInvalidArgumentException REASON:[NSURL 
initWithString:relativeToURL:] bad string parameter INFO:(null)




Am 09.05.2016 um 13:23 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-09 07:15, Ludovic Marcotte (lmarco...@inverse.ca) wrote:
The scripts incorrectly drop the column c_location from 
sogo_folder_info.


Add it back to that table using the "VARCHAR(2048) NULL" data type.


Scratch that. If you create a NEW address book or calendar, can you 
create entries in it?


--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

Also, I can now not even access the calendar page in the sogo web 
interface. It tells me "502 proxy error" in the browser


Sogo.log shows:

May 09 15:05:46 sogod [25995]: <0x0x7f0df4397eb0[GCSFolderManager]> 
folderAtPath: SELECT c_folder_id, c_path, c_location, c_quick_location, 
c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 
'Users' AND c_path2 = 'adr...@figueroa.cc' AND c_path3 = 'Calendar' AND 
c_path4 = 'personal'


May 09 15:05:46 sogod [25995]: <0x0x7f0df4397eb0[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in 
record: {"c_acl_location" = ""; "c_folder_id" = 3; "c_folder_type" 
= Appointment; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Calendar/personal"; "c_quick_location" = 
""; }


May 09 15:05:46 sogod [25995]: <0x0x7f0df4397eb0[GCSFolderManager]> 
folderAtPath: SELECT c_folder_id, c_path, c_location, c_quick_location, 
c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 
'Users' AND c_path2 = 'adr...@figueroa.cc' AND c_path3 = 'Calendar' AND 
c_path4 = '5645-57308380-1-1E775DC0'
EXCEPTION:  NAME:NSInvalidArgumentException 
REASON:[NSURL initWithString:relativeToURL:] bad string parameter 
INFO:(null)




Am 09.05.2016 um 13:23 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-09 07:15, Ludovic Marcotte (lmarco...@inverse.ca) wrote:

The scripts incorrectly drop the column c_location from sogo_folder_info.

Add it back to that table using the "VARCHAR(2048) NULL" data type.


Scratch that. If you create a NEW address book or calendar, can you 
create entries in it?


--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

No, I cannot. It shows "Proxy error" if I create a new address book or calendar 
and also if I try to add a new entry to it.

The entry is then not added.


Von: Ludovic Marcotte 
Gesendet: 09.05.2016 1:23 nachm.
An: users@sogo.nu
Betreff: Re: [SOGo] Migration script problem 

On 2016-05-09 07:15, Ludovic Marcotte (lmarco...@inverse.ca) wrote:
>
> The scripts incorrectly drop the column c_location from sogo_folder_info.
>
> Add it back to that table using the "VARCHAR(2048) NULL" data type.


Scratch that. If you create a NEW address book or calendar, can you create 
entries in it?

-- 
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Migration script problem

[Ludovic Marcotte]

On 2016-05-09 07:15, Ludovic Marcotte (lmarco...@inverse.ca) wrote:

The scripts incorrectly drop the column c_location from sogo_folder_info.

Add it back to that table using the "VARCHAR(2048) NULL" data type.


Scratch that. If you create a NEW address book or calendar, can you 
create entries in it?


--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Ludovic Marcotte]

Hi,

The scripts incorrectly drop the column c_location from sogo_folder_info.

Add it back to that table using the "VARCHAR(2048) NULL" data type.

Thanks,

On 2016-05-09 02:56, Adrian Figueroa (adr...@figueroa.cc) wrote:


Here you go.. Those are links to a self-hosted pastebin variant. If 
you do not trust them, I can also paste the content here directly 
without formatting.


the mysql tables:

https://s.coda.pw/?21056c442d8a0152#wNXAkYdXlzRI+oUmf0XzxNaeZU9PYUZGjoIJsfDuBBY=

and the sogo.conf file:

https://s.coda.pw/?555f5172c8fe0033#riMq3KVu7M5DGCQl66SHL4sGLqOaaVT6MXg8sTiI99w=

Thanks in advance!
Adrian

Am 09.05.2016 um 01:44 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

Hi,

Show your full sogo.conf file and show us the list of your database 
tables.


Thanks,

On 2016-05-08 12:14, Adrian Figueroa (adr...@figueroa.cc) wrote:


Checking the SOGo log file with mysql logs enabled, it shows me 
this, when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.

Adrian

Am 08.05.2016 um 16:59 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, if I want to create a new contact in the SOGo web interface, 
it tells me


"Not Found"

up in the right corner and does not add the contact. Something is 
wrong in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the 
cachefolderurl. Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first 
place if you don't know what it does, you MUST run the nightly 
build of SOGo v3.

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists



--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists



--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

Here you go.. Those are links to a self-hosted pastebin variant. If you 
do not trust them, I can also paste the content here directly without 
formatting.


the mysql tables:

https://s.coda.pw/?21056c442d8a0152#wNXAkYdXlzRI+oUmf0XzxNaeZU9PYUZGjoIJsfDuBBY=

and the sogo.conf file:

https://s.coda.pw/?555f5172c8fe0033#riMq3KVu7M5DGCQl66SHL4sGLqOaaVT6MXg8sTiI99w=

Thanks in advance!
Adrian

Am 09.05.2016 um 01:44 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

Hi,

Show your full sogo.conf file and show us the list of your database 
tables.


Thanks,

On 2016-05-08 12:14, Adrian Figueroa (adr...@figueroa.cc) wrote:


Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.

Adrian

Am 08.05.2016 um 16:59 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, if I want to create a new contact in the SOGo web interface, 
it tells me


"Not Found"

up in the right corner and does not add the contact. Something is 
wrong in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place 
if you don't know what it does, you MUST run the nightly build of 
SOGo v3.

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists



--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Ludovic Marcotte]

Hi,

Show your full sogo.conf file and show us the list of your database tables.

Thanks,

On 2016-05-08 12:14, Adrian Figueroa (adr...@figueroa.cc) wrote:


Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.

Adrian

Am 08.05.2016 um 16:59 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is 
wrong in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place 
if you don't know what it does, you MUST run the nightly build of 
SOGo v3.

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists



--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

I looked inside *GCSFolderManager.m*

It is obvious, that an error is thrown in line 444-448:
if (location == nil) ...


Now, the migration script fills in "NULL" values at certain spots, which 
cause the GCSFolderManager to fail. What can I do? Sadly, I can not 
revert to the old structure.


Kind regards,
Adrian

Am 08.05.2016 um 18:14 schrieb Adrian Figueroa (adr...@figueroa.cc):


Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.

Adrian

Am 08.05.2016 um 16:59 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is 
wrong in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place 
if you don't know what it does, you MUST run the nightly build of 
SOGo v3.

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in 
record: {"c_acl_location" = ""; "c_folder_id" = 4; "c_folder_type" 
= Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.

Adrian

Am 08.05.2016 um 16:59 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is 
wrong in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place 
if you don't know what it does, you MUST run the nightly build of 
SOGo v3.

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

Yes, you are right about the nightly version. I agree that I should not 
have used the script.


I upgraded back to the nightly version but I have no contacts/calendar 
entries yet. Is there something else that I could be missing?


This is the mysql table structure inside "sogo":

+-+
| Tables_in_sogo  |
+-+
| sogo_acl|
| sogo_alarms_folder  |
| sogo_cache_folder   |
| sogo_cache_folder_XX

.

| sogo_folder_info|
| sogo_quick_appointment  |
| sogo_quick_contact  |
| sogo_sessions_folder|
| sogo_store  |
| sogo_user_profile   |
+-+
20 rows in set (0.00 sec)

I can also look let mysql display all the data in sogo_store as user 
sogo (which is a lot).


My sogo.conf now contains:

OCSCacheFolderURL   = 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_cache_folder";
OCSStoreURL = 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_store";
OCSAclURL   = 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_acl";
SOGoProfileURL  = 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_user_profile";
OCSFolderInfoURL= 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL= 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_sessions_folder";


Thank you for your help so far!

Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place if 
you don't know what it does, you MUST run the nightly build of SOGo v3.

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is wrong 
in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place if 
you don't know what it does, you MUST run the nightly build of SOGo v3.

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Ludovic Marcotte]

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place if 
you don't know what it does, you MUST run the nightly build of SOGo v3.


--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Adrian Figueroa]

The upgrade told me to check the mysql migration script folder, so I 
thought that I had to run the latest one.


Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.


Am 08.05.2016 um 14:34 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:26, Adrian Figueroa (adr...@figueroa.cc) wrote:
I ran the migration script "sql-update-3.0.0-to-combined-mysql.sh" on 
SOGo 3.0.2 and now all contact and calendar data is gone. I am 
afraid, I forgot to do a backup before. The script ran without issues 
and told me, it merged tables. 

Why running this script in the first place?

Define:

  OCSCacheFolderURL = 
"mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_cache_folder";
  OCSStoreURL = 
"mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_store";

  OOCSAclURL = "mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_acl";

and restart sogod.

--
Ludovic Marcotte
lmarco...@inverse.ca   ::  +1.514.755.3630  ::http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

[Ludovic Marcotte]

On 2016-05-08 08:26, Adrian Figueroa (adr...@figueroa.cc) wrote:
I ran the migration script "sql-update-3.0.0-to-combined-mysql.sh" on 
SOGo 3.0.2 and now all contact and calendar data is gone. I am afraid, 
I forgot to do a backup before. The script ran without issues and told 
me, it merged tables. 

Why running this script in the first place?

Define:

  OCSCacheFolderURL = 
"mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_cache_folder";

  OCSStoreURL = "mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_store";
  OOCSAclURL = "mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_acl";

and restart sogod.

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration Sogo1 --> Sogo2

[André Schild]

Hello Julian,

Am 23.12.2015 um 18:48 schrieb Julian Thomé:

Dear André,

thank you very much for your reply. Unfortunately, the sogo1 version we are 
using is very old and the sogo-tool has not been there yet. Is there an 
alternative to the sogo-tool ?


In that case, upgrade from your 1.x to 2.x step by step, until sogo-tool 
exists.
There have sometimes been sql script to execute in upgrades to make 
modifications to the database.


André
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration Sogo1 --> Sogo2

[Julian Thomé]

Dear André,

thank you very much for your reply. Unfortunately, the sogo1 version we are 
using is very old and the sogo-tool has not been there yet. Is there an 
alternative to the sogo-tool ?

Thanks a lot for your help and kind regards
  Julian

> On 23 Dec 2015, at 18:37, André Schild  wrote:
> 
> Am 23.12.2015 um 16:07 schrieb frosti...@yahoo.de:
>> Hello List,
>> 
>> we would like to migrate all the address books and schedules from a sogo1
>> server (pretty old installation with postgres backend an a CentOS 5 server) 
>> to
>> a sogo2 ubuntu server with a mysql backend. We cannot create a database dump
>> from the first installation due to a different database, and I suppose that
>> also the underlying schema changed between sogo1 and sogo2.
>> 
>> Do you have any suggestions how we could migrate the sogo1 data to our new
>> server ?
>> 
>> Thank you very much for you help in advance
>>   Julian
> Have you looked for the sogo-tool ?
> 
> Usually they are intended for export/import of user data
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists



signature.asc
Description: Message signed with OpenPGP using GPGMail

Re: [SOGo] Migration Sogo1 --> Sogo2

[Sven Schwedas]

On 2015-12-23 16:07, frosti...@yahoo.de wrote:
> Hello List,
> 
> we would like to migrate all the address books and schedules from a sogo1
> server (pretty old installation with postgres backend an a CentOS 5 server) to
> a sogo2 ubuntu server with a mysql backend. We cannot create a database dump
> from the first installation due to a different database, and I suppose that
> also the underlying schema changed between sogo1 and sogo2.
> 
> Do you have any suggestions how we could migrate the sogo1 data to our new
> server ?
> 
> Thank you very much for you help in advance
>   Julian
> 

pg_dump can create standard conforming SQL dump that are importable into
MySQL (--column-inserts); the SOGo installation manual has step-by-step
instructions on how to update the schema to the current version after
importing it into mysql (section "upgrading", work your way up on that
list starting from your old version).

-- 
Mit freundlichen Grüßen, / Best Regards,
Sven Schwedas
Systemadministrator
TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz
Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167
http://software.tao.at



signature.asc
Description: OpenPGP digital signature

Re: [SOGo] Migration Sogo1 --> Sogo2

[André Schild]

Am 23.12.2015 um 16:07 schrieb frosti...@yahoo.de:

Hello List,

we would like to migrate all the address books and schedules from a sogo1
server (pretty old installation with postgres backend an a CentOS 5 server) to
a sogo2 ubuntu server with a mysql backend. We cannot create a database dump
from the first installation due to a different database, and I suppose that
also the underlying schema changed between sogo1 and sogo2.

Do you have any suggestions how we could migrate the sogo1 data to our new
server ?

Thank you very much for you help in advance
   Julian

Have you looked for the sogo-tool ?

Usually they are intended for export/import of user data
--
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] Migration

[Benito Chamberlain]

Thanks for your help!

> Date: Wed, 26 Jun 2013 16:54:32 +0200
> From: giova...@bigio.snb.it
> To: users@sogo.nu
> Subject: Re: [SOGo] Migration
> 
> On 06/19/13 15:15, Benito Chamberlain wrote:
> > Hi there
> > 
> > We want to migrate MS exchange server to Sogo . What is the best way to go 
> > about this ,?
> > My knowledge of MS Exchange is limited , as I don't work with Microsoft .
> > 
> > Our goal is to migrate as quickly and painlessly as possible , with the 
> > minimum down time.
> > 
> I recently migrate from Exchange/Outlook to SOGo/Thunderbird and I used the 
> following software to migrate data:
> - offlineimap for mail folders
> - outlook2ical (http://outlook2ical.sourceforge.net/) for calendars
> - a macro 
> (http://www.outlook-answers.com/microsoft/Outlook/36234758/esportare-rubrica-outlook-2003-in-vcf.aspx)
>  to export contacts in vcf format, then I was able to import the vcf in SOGo 
> web gui
> 
> The Exchange server was a backend server so I was able to migrate one account 
> (I have few) at a time with little downtime.
>  Cheers
>   Giovanni
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists
  -- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration

[Giovanni Bechis]

On 06/19/13 15:15, Benito Chamberlain wrote:
> Hi there
> 
> We want to migrate MS exchange server to Sogo . What is the best way to go 
> about this ,?
> My knowledge of MS Exchange is limited , as I don't work with Microsoft .
> 
> Our goal is to migrate as quickly and painlessly as possible , with the 
> minimum down time.
> 
I recently migrate from Exchange/Outlook to SOGo/Thunderbird and I used the 
following software to migrate data:
- offlineimap for mail folders
- outlook2ical (http://outlook2ical.sourceforge.net/) for calendars
- a macro 
(http://www.outlook-answers.com/microsoft/Outlook/36234758/esportare-rubrica-outlook-2003-in-vcf.aspx)
 to export contacts in vcf format, then I was able to import the vcf in SOGo 
web gui

The Exchange server was a backend server so I was able to migrate one account 
(I have few) at a time with little downtime.
 Cheers
  Giovanni

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration horde to sogo

[gerard breiner]

Le Lundi 8 Octobre 2012 10:34 CEST, Christian Mack 
 a écrit:

> On 2012-10-05 19:49, gerard breiner wrote:
> > Hello,
> >
> > First of all many thanks at the SOGo team for this great work that is sogo. 
> > So far we used Horde with kronolith and turba.
> > I installed Sogo 2-2.0.0 under Debian Squeeze via apt-get. Now I downloaded 
> > the scripts Migration/Horde and configure config.py.
> > I run ./turba.py gbreiner
> > It works  (no error) but  I don't know where are my three vcard .
> > So I modified TurbaConverter so that it show the put.response["status"] and 
> > the url  of my vcard.
> >
> > I run again ./turba.py gbreiner and I get :
> >
> > Converting addressbook of 'gbreiner'
> >   prepared 3 cards
> > /SOGo/dav/gbreiner/Contacts/personal/b4fd46282634d0750075b49cf5714971.vcf
> > 302
> >   successes: 1; failures: 0 
> > /SOGo/dav/gbreiner/Contacts/personal/772361c72f938164ac3e3c0e5db68bee.vcf
> > 302
> >   successes: 2; failures: 0 
> > /SOGo/dav/gbreiner/Contacts/personal/6e7e576eb0f43908ffce5501cd484e70.vcf
> > 302
> >   successes: 3; failures: 0
> >
> > Done
> >
> > So It seems all is correct but how can I get my three contacts... ?
> >
> > Any help would be appreciated.
> >
>
> Did you log in to SOGo as user gbreiner before importing old data?
> The "personal" calendar and address book are created on first log in, so
> I don't think importing will work before that.
>
> Try looking under "Address Book" --> "Personal address book" when
> logging in as user gbreiner into the SOGo webinterface.
>
>
> Kind regards,
> Christian Mack
>
> --
> Christian Mack
> Gruppe Informationsdienste
> Rechenzentrum Universität Konstanz
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists


 Hello,

For remind, I'am already logged in at least hundred times... Tables mysql has 
been created...

In order to track the "bug", I added in TurbaConverter.py the line :
print put.response["body"].

Here is what this line show up for one contact :

successes: 2; failures: 0 

302 Found

Found
The document has moved https://sogo.ias.u 
psud.fr/SOGo/dav/gbreiner/Contacts/personal/6e7e576eb0f43908ffce5501cd484e70.vcf">here.


I added too the line print put.response["headers"].  I get :

{'content-length': '283', 'vary': 'Accept-Encoding', 'server': 'Apache/2.2.16 
(Debian) DAV/2 PHP/5.3.3-7+squeeze14 with Suhosin-Patch mod_ssl/2.2.16 
OpenSSL/0.9.8o', 'location': 
'https://sogo.ias.u-psud.fr/SOGo/dav/gbreiner/Contacts/personal/772361c72f938164ac3e3c0e5db68bee.vcf',
 'date': 'Wed, 17 Oct 2012 09:32:47 GMT', 'content-type': 'text/html; 
charset=iso-8859-1'}
  successes: 2; failures: 0

I' m wondering about the charset. It seems to me that Sogo wants UTF-8 and not 
iso-8859-1,  isn't it ?

Best regards.

Gérard Breiner





-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration horde to sogo

[gerard breiner]

Le Mardi 9 Octobre 2012 14:18 CEST, "gerard breiner" 
 a écrit:

>
> Le Lundi 8 Octobre 2012 17:42 CEST, "gerard breiner" 
>  a écrit:
>
> >
> > Le Lundi 8 Octobre 2012 10:34 CEST, Christian Mack 
> >  a écrit:
> >
> > > On 2012-10-05 19:49, gerard breiner wrote:
> > > > Hello,
> > > >
> > > > First of all many thanks at the SOGo team for this great work that is 
> > > > sogo. So far we used Horde with kronolith and turba.
> > > > I installed Sogo 2-2.0.0 under Debian Squeeze via apt-get. Now I 
> > > > downloaded the scripts Migration/Horde and configure config.py.
> > > > I run ./turba.py gbreiner
> > > > It works  (no error) but  I don't know where are my three vcard .
> > > > So I modified TurbaConverter so that it show the put.response["status"] 
> > > > and the url  of my vcard.
> > > >
> > > > I run again ./turba.py gbreiner and I get :
> > > >
> > > > Converting addressbook of 'gbreiner'
> > > >   prepared 3 cards
> > > > /SOGo/dav/gbreiner/Contacts/personal/b4fd46282634d0750075b49cf5714971.vcf
> > > > 302
> > > >   successes: 1; failures: 0 
> > > > /SOGo/dav/gbreiner/Contacts/personal/772361c72f938164ac3e3c0e5db68bee.vcf
> > > > 302
> > > >   successes: 2; failures: 0 
> > > > /SOGo/dav/gbreiner/Contacts/personal/6e7e576eb0f43908ffce5501cd484e70.vcf
> > > > 302
> > > >   successes: 3; failures: 0
> > > >
> > > > Done
> > > >
> > > > So It seems all is correct but how can I get my three contacts... ?> >
> > > > Any help would be appreciated.
> > > >
> > >
> > > Did you log in to SOGo as user gbreiner before importing old data?
> >
> > Yes.
> >
> > > The "personal" calendar and address book are created on first log in, so
> > > I don't think importing will work before that.
> > >
> > > Try looking under "Address Book" --> "Personal address book" when
> > > logging in as user gbreiner into the SOGo webinterface.
> >
> > Already done... In "Address Book" --> "Personal address book" I have the 
> > contacts that comes from  my Personal Computer by synchronisation with 
> > syncml client funambol.  I expected my horde contacts at this place but no 
> > data has been added.
> >
> > I have three tables in mysql related to gbreiner's contacts.
> >
> > sogogbreiner00269f70e2c
> > sogogbreiner00269f70e2c_acl
> > sogogbreiner00269f70e2c_quick
> >
> > If I did understood, horde contacts for gbreiner should be in theses tables 
> > after having ran turba.py, should'nt be ?
> >
> > >
> > >
> > > Kind regards,
> > > Christian Mack
> > >
> > > --
> > > Christian Mack
> > > Gruppe Informationsdienste
> > > Rechenzentrum Universität Konstanz
> > > --
> > > users@sogo.nu
> > > https://inverse.ca/sogo/lists
> >
> >
> > Others informations, users sogo are authentified by ldap.
> > Sogo has been installed by using apt-get as recommended in the Installation 
> > Guide.
> >
> > I looked at the mysql log but there is only the request to the horde tables 
> > :
> >
> > tail -300 mysql.log
> > 121008 17:34:15   538 Connect   sogo@localhost on horde
> >   538 Query set autocommit=0
> >   538 Query SELECT user_uid, datatree_name FROM 
> > horde_datatree WHERE user_uid = 'gbreiner'
> >   538 Query SELECT * FROM turba_objects WHERE owner_id = 
> > 'gbreiner' or owner_id = 'imp.gbreiner.<431d5ec5.7070...@ias.u-psud.fr>' or 
> > owner_id = 'turba' or owner_id = 'kronolith' or owner_id = 'gbreiner' or 
> > owner_id = 'a1f4fd6d3a9a165663de621ae941e5ca' or owner_id = 
> > '09949fee02914b900a833af3f6097a46' or owner_id = 'gollem' or owner_id = 
> > 'backends' or owner_id = 'gbreiner' or owner_id = 
> > 'b8660d241df40665a73e97c76ff33d27' or owner_id = 
> > '60df89056de50ee9bf04941bd4432419'
> >   538 Quit
> >
> > Many thanks Christian for your friendly answer.
> >
> > Best regards.
> >
> > Gérard Breiner
> >
> >
> >
> >
> >
> > --
> > users@sogo.nu
> > https://inverse.ca/sogo/lists
>
>
>
> Humm... Am I alone to have this problem ?
> Yet I 'm already log in a first time so the mysql tables for contacts have 
> been created but when I run the script turba.py I do not get my contacts from 
> horde in my Personal address book.
> Does anyone has an idea of what happens after the "PUT" of TurbaConverter.py 
> script ?
>
> Any help would be greatly appreciated.
>
> Best regards.
>
> Gérard Breiner
> Institut d'Astrophysique Spatiale
> FR-91405 Campus Orsay-Ville
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists


 Hello,

I"m still working on this issue... I want to migrate contacts from horde to 
sogo for all users. So I use the script TurbaConverter.py. I added a line for 
tracing the response headers: print put.response["headers"].

Here is the result after having ran the command turba.py gbreiner :

Converting addressbook of 'gbreiner'
  prepared 3 cards
{'content-length': '283', 'vary': 'Accept-Encoding', 'server': 'Apache/2.2.16 
(Debian) DAV/2 PHP/5.3.3-7+squeeze14 with Suhosin-Patch mod_ssl/2.2.16 
OpenSSL/0.9.8o', 'location': 
'https://sogo.ias.u-psud.fr/SOGo/dav/gb

Re: [SOGo] Migration horde to sogo

[gerard breiner]

Le Lundi 8 Octobre 2012 10:34 CEST, Christian Mack 
 a écrit:

> On 2012-10-05 19:49, gerard breiner wrote:
> > Hello,
> >
> > First of all many thanks at the SOGo team for this great work that is sogo. 
> > So far we used Horde with kronolith and turba.
> > I installed Sogo 2-2.0.0 under Debian Squeeze via apt-get. Now I downloaded 
> > the scripts Migration/Horde and configure config.py.
> > I run ./turba.py gbreiner
> > It works  (no error) but  I don't know where are my three vcard .
> > So I modified TurbaConverter so that it show the put.response["status"] and 
> > the url  of my vcard.
> >
> > I run again ./turba.py gbreiner and I get :
> >
> > Converting addressbook of 'gbreiner'
> >   prepared 3 cards
> > /SOGo/dav/gbreiner/Contacts/personal/b4fd46282634d0750075b49cf5714971.vcf
> > 302
> >   successes: 1; failures: 0 
> > /SOGo/dav/gbreiner/Contacts/personal/772361c72f938164ac3e3c0e5db68bee.vcf
> > 302
> >   successes: 2; failures: 0 
> > /SOGo/dav/gbreiner/Contacts/personal/6e7e576eb0f43908ffce5501cd484e70.vcf
> > 302
> >   successes: 3; failures: 0
> >
> > Done
> >
> > So It seems all is correct but how can I get my three contacts... ?
> >
> > Any help would be appreciated.
> >
>
> Did you log in to SOGo as user gbreiner before importing old data?
> The "personal" calendar and address book are created on first log in, so
> I don't think importing will work before that.
>
> Try looking under "Address Book" --> "Personal address book" when
> logging in as user gbreiner into the SOGo webinterface.
>
>
> Kind regards,
> Christian Mack
>
> --
> Christian Mack
> Gruppe Informationsdienste
> Rechenzentrum Universität Konstanz
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists


Hello,

I'm the feeling that there is a bug in the webdavlib library. I think the PUT 
is not successfull even thougth the script TurbaConverter say that all is ok.  
The put.response["status"]  give the code 302 which is a common way of 
performing a redirection. Which redirection and where? I know that the if I 
make a "print url"  in the script I get :
/SOGo/dav/gbreiner/Contacts/personal/b4fd46282634d0750075b49cf5714971.vcf
but in the web interface sogo this contact doesn't appear.

Thanks in advance.

Gérard Breiner




-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration horde to sogo

[gerard breiner]

Le Lundi 8 Octobre 2012 17:42 CEST, "gerard breiner" 
 a écrit:

>
> Le Lundi 8 Octobre 2012 10:34 CEST, Christian Mack 
>  a écrit:
>
> > On 2012-10-05 19:49, gerard breiner wrote:
> > > Hello,
> > >
> > > First of all many thanks at the SOGo team for this great work that is 
> > > sogo. So far we used Horde with kronolith and turba.
> > > I installed Sogo 2-2.0.0 under Debian Squeeze via apt-get. Now I 
> > > downloaded the scripts Migration/Horde and configure config.py.
> > > I run ./turba.py gbreiner
> > > It works  (no error) but  I don't know where are my three vcard .
> > > So I modified TurbaConverter so that it show the put.response["status"] 
> > > and the url  of my vcard.
> > >
> > > I run again ./turba.py gbreiner and I get :
> > >
> > > Converting addressbook of 'gbreiner'
> > >   prepared 3 cards
> > > /SOGo/dav/gbreiner/Contacts/personal/b4fd46282634d0750075b49cf5714971.vcf
> > > 302
> > >   successes: 1; failures: 0 
> > > /SOGo/dav/gbreiner/Contacts/personal/772361c72f938164ac3e3c0e5db68bee.vcf
> > > 302
> > >   successes: 2; failures: 0 
> > > /SOGo/dav/gbreiner/Contacts/personal/6e7e576eb0f43908ffce5501cd484e70.vcf
> > > 302
> > >   successes: 3; failures: 0
> > >
> > > Done
> > >
> > > So It seems all is correct but how can I get my three contacts... ?> >
> > > Any help would be appreciated.
> > >
> >
> > Did you log in to SOGo as user gbreiner before importing old data?
>
> Yes.
>
> > The "personal" calendar and address book are created on first log in, so
> > I don't think importing will work before that.
> >
> > Try looking under "Address Book" --> "Personal address book" when
> > logging in as user gbreiner into the SOGo webinterface.
>
> Already done... In "Address Book" --> "Personal address book" I have the 
> contacts that comes from  my Personal Computer by synchronisation with syncml 
> client funambol.  I expected my horde contacts at this place but no data has 
> been added.
>
> I have three tables in mysql related to gbreiner's contacts.
>
> sogogbreiner00269f70e2c
> sogogbreiner00269f70e2c_acl
> sogogbreiner00269f70e2c_quick
>
> If I did understood, horde contacts for gbreiner should be in theses tables 
> after having ran turba.py, should'nt be ?
>
> >
> >
> > Kind regards,
> > Christian Mack
> >
> > --
> > Christian Mack
> > Gruppe Informationsdienste
> > Rechenzentrum Universität Konstanz
> > --
> > users@sogo.nu
> > https://inverse.ca/sogo/lists
>
>
> Others informations, users sogo are authentified by ldap.
> Sogo has been installed by using apt-get as recommended in the Installation 
> Guide.
>
> I looked at the mysql log but there is only the request to the horde tables :
>
> tail -300 mysql.log
> 121008 17:34:15 538 Connect   sogo@localhost on horde
> 538 Query set autocommit=0
> 538 Query SELECT user_uid, datatree_name FROM 
> horde_datatree WHERE user_uid = 'gbreiner'
> 538 Query SELECT * FROM turba_objects WHERE owner_id = 
> 'gbreiner' or owner_id = 'imp.gbreiner.<431d5ec5.7070...@ias.u-psud.fr>' or 
> owner_id = 'turba' or owner_id = 'kronolith' or owner_id = 'gbreiner' or 
> owner_id = 'a1f4fd6d3a9a165663de621ae941e5ca' or owner_id = 
> '09949fee02914b900a833af3f6097a46' or owner_id = 'gollem' or owner_id = 
> 'backends' or owner_id = 'gbreiner' or owner_id = 
> 'b8660d241df40665a73e97c76ff33d27' or owner_id = 
> '60df89056de50ee9bf04941bd4432419'
> 538 Quit
>
> Many thanks Christian for your friendly answer.
>
> Best regards.
>
> Gérard Breiner
>
>
>
>
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists



Humm... Am I alone to have this problem ?
Yet I 'm already log in a first time so the mysql tables for contacts have been 
created but when I run the script turba.py I do not get my contacts from horde 
in my Personal address book.
Does anyone has an idea of what happens after the "PUT" of TurbaConverter.py 
script ?

Any help would be greatly appreciated.

Best regards.

Gérard Breiner
Institut d'Astrophysique Spatiale
FR-91405 Campus Orsay-Ville
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration horde to sogo

[gerard breiner]

Le Lundi 8 Octobre 2012 10:34 CEST, Christian Mack 
 a écrit:

> On 2012-10-05 19:49, gerard breiner wrote:
> > Hello,
> >
> > First of all many thanks at the SOGo team for this great work that is sogo. 
> > So far we used Horde with kronolith and turba.
> > I installed Sogo 2-2.0.0 under Debian Squeeze via apt-get. Now I downloaded 
> > the scripts Migration/Horde and configure config.py.
> > I run ./turba.py gbreiner
> > It works  (no error) but  I don't know where are my three vcard .
> > So I modified TurbaConverter so that it show the put.response["status"] and 
> > the url  of my vcard.
> >
> > I run again ./turba.py gbreiner and I get :
> >
> > Converting addressbook of 'gbreiner'
> >   prepared 3 cards
> > /SOGo/dav/gbreiner/Contacts/personal/b4fd46282634d0750075b49cf5714971.vcf
> > 302
> >   successes: 1; failures: 0 
> > /SOGo/dav/gbreiner/Contacts/personal/772361c72f938164ac3e3c0e5db68bee.vcf
> > 302
> >   successes: 2; failures: 0 
> > /SOGo/dav/gbreiner/Contacts/personal/6e7e576eb0f43908ffce5501cd484e70.vcf
> > 302
> >   successes: 3; failures: 0
> >
> > Done
> >
> > So It seems all is correct but how can I get my three contacts... ?> >
> > Any help would be appreciated.
> >
>
> Did you log in to SOGo as user gbreiner before importing old data?

Yes.

> The "personal" calendar and address book are created on first log in, so
> I don't think importing will work before that.
>
> Try looking under "Address Book" --> "Personal address book" when
> logging in as user gbreiner into the SOGo webinterface.

Already done... In "Address Book" --> "Personal address book" I have the 
contacts that comes from  my Personal Computer by synchronisation with syncml 
client funambol.  I expected my horde contacts at this place but no data has 
been added.

I have three tables in mysql related to gbreiner's contacts.

sogogbreiner00269f70e2c
sogogbreiner00269f70e2c_acl
sogogbreiner00269f70e2c_quick

If I did understood, horde contacts for gbreiner should be in theses tables 
after having ran turba.py, should'nt be ?

>
>
> Kind regards,
> Christian Mack
>
> --
> Christian Mack
> Gruppe Informationsdienste
> Rechenzentrum Universität Konstanz
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists


Others informations, users sogo are authentified by ldap.
Sogo has been installed by using apt-get as recommended in the Installation 
Guide.

I looked at the mysql log but there is only the request to the horde tables :

tail -300 mysql.log
121008 17:34:15   538 Connect   sogo@localhost on horde
  538 Query set autocommit=0
  538 Query SELECT user_uid, datatree_name FROM 
horde_datatree WHERE user_uid = 'gbreiner'
  538 Query SELECT * FROM turba_objects WHERE owner_id = 
'gbreiner' or owner_id = 'imp.gbreiner.<431d5ec5.7070...@ias.u-psud.fr>' or 
owner_id = 'turba' or owner_id = 'kronolith' or owner_id = 'gbreiner' or 
owner_id = 'a1f4fd6d3a9a165663de621ae941e5ca' or owner_id = 
'09949fee02914b900a833af3f6097a46' or owner_id = 'gollem' or owner_id = 
'backends' or owner_id = 'gbreiner' or owner_id = 
'b8660d241df40665a73e97c76ff33d27' or owner_id = 
'60df89056de50ee9bf04941bd4432419'
  538 Quit

Many thanks Christian for your friendly answer.

Best regards.

Gérard Breiner





-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration horde to sogo

[Christian Mack]

On 2012-10-05 19:49, gerard breiner wrote:
> Hello,
> 
> First of all many thanks at the SOGo team for this great work that is sogo. 
> So far we used Horde with kronolith and turba.
> I installed Sogo 2-2.0.0 under Debian Squeeze via apt-get. Now I downloaded 
> the scripts Migration/Horde and configure config.py.
> I run ./turba.py gbreiner
> It works  (no error) but  I don't know where are my three vcard .
> So I modified TurbaConverter so that it show the put.response["status"] and 
> the url  of my vcard.
> 
> I run again ./turba.py gbreiner and I get :
> 
> Converting addressbook of 'gbreiner'
>   prepared 3 cards
> /SOGo/dav/gbreiner/Contacts/personal/b4fd46282634d0750075b49cf5714971.vcf
> 302
>   successes: 1; failures: 0 
> /SOGo/dav/gbreiner/Contacts/personal/772361c72f938164ac3e3c0e5db68bee.vcf
> 302
>   successes: 2; failures: 0 
> /SOGo/dav/gbreiner/Contacts/personal/6e7e576eb0f43908ffce5501cd484e70.vcf
> 302
>   successes: 3; failures: 0
> 
> Done
> 
> So It seems all is correct but how can I get my three contacts... ?
> 
> Any help would be appreciated.
> 

Did you log in to SOGo as user gbreiner before importing old data?
The "personal" calendar and address book are created on first log in, so
I don't think importing will work before that.

Try looking under "Address Book" --> "Personal address book" when
logging in as user gbreiner into the SOGo webinterface.


Kind regards,
Christian Mack

-- 
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration from an existent PostFix + OpenLdap directory

[Patrick Ben Koetter]

* Carlos Paz :
> let me describe it a bit more:
> 
> 1. I want to migrate 1000 mailboxes (around 40 Gb) from an old Postfix
> server to a new server with Sogo 1.3, is there any tool or procedure to
> acomplish that?

Postfix (SMTP) means transporting and storing mail on a server. How do you
deliver it to clients? IMAP? POP?

If you have IMAP, then IMAP is the way to go.

> 2. The 1000 mailboxes are binded to LDAP, so I think I will need to migrate
> them from the old Openldap directory to Sogo. Also I'm looking for a tool
> or any procedure to complish that.

Assuming you have IMAP on the old server:

1. Setup your new LDAP/SOGO server including its IMAP component.
2. Use imapsync  to copy messages
   including their state (unread/read and other tags) to the new machine.
   If you use dovecot on both sides, consider using dsync to sync mailboxes.

If you run imapsync/dsync regularly you can conduct a soft migration without
anyone noticing. Just let the sync process run regularly. It will copy over
everything the first time and only fetch the delta in successive runs.

p@rick

> Thanks in advance for any help.
> 
> On Sat, Feb 4, 2012 at 2:33 PM, Patrick Ben Koetter 
> wrote:
> 
> > * Carlos Paz :
> > > I cant find instructions how to:
> > >
> > > 1. migrate around 1000 email accounts from postfix
> > > 2. migrate the open Ldap database, also 1000 entries
> >
> > Can you be more specific?
> >
> > p@rick
> >
> > --
> > state of mind ()
> >
> > http://www.state-of-mind.de
> >
> > Franziskanerstraße 15  Telefon +49 89 3090 4664
> > 81669 München  Telefax +49 89 3090 4666
> >
> > Amtsgericht MünchenPartnerschaftsregister PR 563
> >
> > --
> > users@sogo.nu
> > https://inverse.ca/sogo/lists
> >
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

-- 
state of mind ()

http://www.state-of-mind.de

Franziskanerstraße 15  Telefon +49 89 3090 4664
81669 München  Telefax +49 89 3090 4666

Amtsgericht MünchenPartnerschaftsregister PR 563

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration from an existent PostFix + OpenLdap directory

[Martin Rabl]

Carlos,

there is no need to migrate - SOGo uses the given infrastructur. LDAP is 
used for Auth, Postfix for smtp. Instal SOGo and configure LDAP as 
usersource, see "SOGo - Installation and Configuration Guide" 
http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf beginning 
on page 16 "Authentication using LDAP".



Greetings,
Martin

Am 04.02.12 19:39, schrieb Carlos Paz:

let me describe it a bit more:

1. I want to migrate 1000 mailboxes (around 40 Gb) from an old Postfix
server to a new server with Sogo 1.3, is there any tool or procedure to
acomplish that?

2. The 1000 mailboxes are binded to LDAP, so I think I will need to
migrate them from the old Openldap directory to Sogo. Also I'm looking
for a tool or any procedure to complish that.

Thanks in advance for any help.

On Sat, Feb 4, 2012 at 2:33 PM, Patrick Ben Koetter mailto:p...@state-of-mind.de>> wrote:

* Carlos Paz mailto:users@sogo.nu>>:
 > I cant find instructions how to:
 >
 > 1. migrate around 1000 email accounts from postfix
 > 2. migrate the open Ldap database, also 1000 entries

Can you be more specific?

p@rick

--
state of mind ()

http://www.state-of-mind.de

Franziskanerstraße 15  Telefon +49 89 3090 4664

81669 München  Telefax +49 89 3090 4666


Amtsgericht MünchenPartnerschaftsregister PR 563

--
users@sogo.nu 
https://inverse.ca/sogo/lists




--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration from an existent PostFix + OpenLdap directory

[Carlos Paz]

let me describe it a bit more:

1. I want to migrate 1000 mailboxes (around 40 Gb) from an old Postfix
server to a new server with Sogo 1.3, is there any tool or procedure to
acomplish that?

2. The 1000 mailboxes are binded to LDAP, so I think I will need to migrate
them from the old Openldap directory to Sogo. Also I'm looking for a tool
or any procedure to complish that.

Thanks in advance for any help.

On Sat, Feb 4, 2012 at 2:33 PM, Patrick Ben Koetter 
wrote:

> * Carlos Paz :
> > I cant find instructions how to:
> >
> > 1. migrate around 1000 email accounts from postfix
> > 2. migrate the open Ldap database, also 1000 entries
>
> Can you be more specific?
>
> p@rick
>
> --
> state of mind ()
>
> http://www.state-of-mind.de
>
> Franziskanerstraße 15  Telefon +49 89 3090 4664
> 81669 München  Telefax +49 89 3090 4666
>
> Amtsgericht MünchenPartnerschaftsregister PR 563
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration from an existent PostFix + OpenLdap directory

[Patrick Ben Koetter]

* Carlos Paz :
> I cant find instructions how to:
> 
> 1. migrate around 1000 email accounts from postfix
> 2. migrate the open Ldap database, also 1000 entries

Can you be more specific?

p@rick

-- 
state of mind ()

http://www.state-of-mind.de

Franziskanerstraße 15  Telefon +49 89 3090 4664
81669 München  Telefax +49 89 3090 4666

Amtsgericht MünchenPartnerschaftsregister PR 563

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration Question

[Robert Fantini]

check this:
http://wiki2.dovecot.org/Migration/MailFormat


On Mon, Jun 27, 2011 at 8:05 PM, Robert Fantini  wrote:
> check this
> http://www.linuxmail.info/mbox-maildir-mail-storage-formats/
> and
> http://batleth.sapienti-sat.org/projects/mb2md/
>
> I did not keep notes, but I think we used the mb2md method.
>
> Try searching  'mbox convert maildir ' for more choices.
>
> On Mon, Jun 27, 2011 at 7:40 PM, CF  wrote:
>> Le 28/06/2011 00:17, Robert Fantini a écrit :
>>
>> On Mon, Jun 27, 2011 at 12:50 PM,   wrote:
>>
>> Hello everyone
>> We have been using  a Centos/Postfix/Dovecot server for many years and now
>> are
>> looking to migrate to SoGo. I have set up a test box and have succefully
>> configured everything but having a small issue that I cannot figure out. On
>> our
>> existing server we are using mbox for storing mail and what not and have
>> some
>> archives and user mailboxes that are greater than 2gb. However with the test
>> box any users inbox that is greater than 2gb cannot get mail. I have looked
>> at
>> the postfix settings and made sure that the
>> mailbox_size_limit = 0
>> virtual_mailbox_limit=0
>> WHich should allow for whatever size possible. What I dont understand is how
>> I
>> can get mail on existing server but my test bed will not allow it. Both
>> report
>> i686 on the arch command. The only difference is working server is a RAID
>> and
>> test bed is an LVM. Both are formatted with ext3. Any ideas? Both are also
>> running Centos 5.6.
>> Thanks for any input.
>> Bo
>> --
>> users@sogo.nu
>> https://inverse.ca/sogo/lists
>>
>> consider switching to maildir instead of mbox .
>>
>> google the differences..
>>
>> we switched a few years ago and had  a much more stable mail system after
>> that.
>>
>> the 2-gb limit may be a per file max allowed by the operating / file
>> system?  if that is the case then as you probably know maildir would
>> solve the problem.
>>
>> I was envisaging switching from mbox to maildir, but unfortunatly i was not
>> able to keep existing mbox. Perhaps someone have a tip for later migration
>> (around 200 mbox with up to 3GBs each) ?
>>
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration Question

[Robert Fantini]

check this
http://www.linuxmail.info/mbox-maildir-mail-storage-formats/
and
http://batleth.sapienti-sat.org/projects/mb2md/

I did not keep notes, but I think we used the mb2md method.

Try searching  'mbox convert maildir ' for more choices.

On Mon, Jun 27, 2011 at 7:40 PM, CF  wrote:
> Le 28/06/2011 00:17, Robert Fantini a écrit :
>
> On Mon, Jun 27, 2011 at 12:50 PM,   wrote:
>
> Hello everyone
> We have been using  a Centos/Postfix/Dovecot server for many years and now
> are
> looking to migrate to SoGo. I have set up a test box and have succefully
> configured everything but having a small issue that I cannot figure out. On
> our
> existing server we are using mbox for storing mail and what not and have
> some
> archives and user mailboxes that are greater than 2gb. However with the test
> box any users inbox that is greater than 2gb cannot get mail. I have looked
> at
> the postfix settings and made sure that the
> mailbox_size_limit = 0
> virtual_mailbox_limit=0
> WHich should allow for whatever size possible. What I dont understand is how
> I
> can get mail on existing server but my test bed will not allow it. Both
> report
> i686 on the arch command. The only difference is working server is a RAID
> and
> test bed is an LVM. Both are formatted with ext3. Any ideas? Both are also
> running Centos 5.6.
> Thanks for any input.
> Bo
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
> consider switching to maildir instead of mbox .
>
> google the differences..
>
> we switched a few years ago and had  a much more stable mail system after
> that.
>
> the 2-gb limit may be a per file max allowed by the operating / file
> system?  if that is the case then as you probably know maildir would
> solve the problem.
>
> I was envisaging switching from mbox to maildir, but unfortunatly i was not
> able to keep existing mbox. Perhaps someone have a tip for later migration
> (around 200 mbox with up to 3GBs each) ?
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration Question

[CF]

Le 28/06/2011 00:17, Robert Fantini a écrit :

On Mon, Jun 27, 2011 at 12:50 PM,  wrote:

Hello everyone
We have been using  a Centos/Postfix/Dovecot server for many years and now are
looking to migrate to SoGo. I have set up a test box and have succefully
configured everything but having a small issue that I cannot figure out. On our
existing server we are using mbox for storing mail and what not and have some
archives and user mailboxes that are greater than 2gb. However with the test
box any users inbox that is greater than 2gb cannot get mail. I have looked at
the postfix settings and made sure that the
mailbox_size_limit = 0
virtual_mailbox_limit=0
WHich should allow for whatever size possible. What I dont understand is how I
can get mail on existing server but my test bed will not allow it. Both report
i686 on the arch command. The only difference is working server is a RAID and
test bed is an LVM. Both are formatted with ext3. Any ideas? Both are also
running Centos 5.6.
Thanks for any input.
Bo
--
users@sogo.nu
https://inverse.ca/sogo/lists


consider switching to maildir instead of mbox .

google the differences..

we switched a few years ago and had  a much more stable mail system after that.

the 2-gb limit may be a per file max allowed by the operating / file
system?  if that is the case then as you probably know maildir would
solve the problem.


I was envisaging switching from mbox to maildir, but unfortunatly i was 
not able to keep existing mbox. Perhaps someone have a tip for later 
migration  (around 200 mbox with up to 3GBs each) ?

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration Question

[Robert Fantini]

On Mon, Jun 27, 2011 at 12:50 PM,   wrote:
> Hello everyone
> We have been using  a Centos/Postfix/Dovecot server for many years and now are
> looking to migrate to SoGo. I have set up a test box and have succefully
> configured everything but having a small issue that I cannot figure out. On 
> our
> existing server we are using mbox for storing mail and what not and have some
> archives and user mailboxes that are greater than 2gb. However with the test
> box any users inbox that is greater than 2gb cannot get mail. I have looked at
> the postfix settings and made sure that the
> mailbox_size_limit = 0
> virtual_mailbox_limit=0
> WHich should allow for whatever size possible. What I dont understand is how I
> can get mail on existing server but my test bed will not allow it. Both report
> i686 on the arch command. The only difference is working server is a RAID and
> test bed is an LVM. Both are formatted with ext3. Any ideas? Both are also
> running Centos 5.6.
> Thanks for any input.
> Bo
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>

consider switching to maildir instead of mbox .

google the differences..

we switched a few years ago and had  a much more stable mail system after that.

the 2-gb limit may be a per file max allowed by the operating / file
system?  if that is the case then as you probably know maildir would
solve the problem.
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration from SOGo 1.2.0 to 1.2.2 whit PostgreSQL

[Ludovic Marcotte]

Joaquin Llano wrote:


Thanks,

 

We are using inverse.ca repository deb http://inverse.ca/debian lenny 
lenny.


 

Had we to use   sql-update-20070822.sh or sql-update-1.2.2_to_1.3.0.sh 
directly?



The latter.


If we migrate database, our SOGo 1.2.0 continue working or we had to 
migrate the production system? We use same database for test and 
production.



It should continue to work as normal.


We have translated some messages that wasn't translated into Spanish. 
If you want we can send that translation for include in future versions.



Sure, make sure they are still valid with the nightly builds.

Regards,

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] Migration from SOGo 1.2.0 to 1.2.2 whit PostgreSQL

[Joaquin Llano]

Thanks,

 

We are using inverse.ca repository deb http://inverse.ca/debian lenny
lenny.

 

Had we to use   sql-update-20070822.sh or sql-update-1.2.2_to_1.3.0.sh
directly?

 

If we migrate database, our SOGo 1.2.0 continue working or we had to
migrate the production system? We use same database for test and
production.

 

We have translated some messages that wasn't translated into Spanish. If
you want we can send that translation for include in future versions.

 

Thanks again.

 

De: Ludovic Marcotte [mailto:lmarco...@inverse.ca] 
Enviado el: lunes, 19 de julio de 2010 13:43
Para: users@sogo.nu
Asunto: Re: [SOGo] Migration from SOGo 1.2.0 to 1.2.2 whit PostgreSQL

 

Joaquin Llano wrote: 

Hi, we have SOGo 1.2.0 running good on Debian Lenny with PostgreSQL.

 

We are trying SOGo 1.2.2 but Calendars Tasks aren't show.

 

See the update scripts:

http://mtn.inverse.ca/revision/browse/1d776c3766bf2049490ce720a4ffc09f3e
604e5c/Scripts

If you're updating to a nightly build, you have to run the
sql-update-1.2.2_to_1.3.0.sh script.

Regards,



-- 
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration from SOGo 1.2.0 to 1.2.2 whit PostgreSQL

[Ludovic Marcotte]

Joaquin Llano wrote:


Hi, we have SOGo 1.2.0 running good on Debian Lenny with PostgreSQL.

 


We are trying SOGo 1.2.2 but Calendars Tasks aren't show.

 


See the update scripts:

http://mtn.inverse.ca/revision/browse/1d776c3766bf2049490ce720a4ffc09f3e604e5c/Scripts

If you're updating to a nightly build, you have to run the 
sql-update-1.2.2_to_1.3.0.sh script.


Regards,

--
Ludovic Marcotte
lmarco...@inverse.ca  ::  +1.514.755.3630  ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration problems

[Edouard LEIB]

Hi Wolfgang,

Thanks for your reactivity.

May be we have some old libraries. What type of library do you want I
search ?
Do you have names of specific libraries ?

Regards,

Wolfgang Sourdeau a écrit :
Edouard
LEIB wrote:
  
  Hello all,


We have some troubles with migration from 1.0.2 version to 1.2.2
version.


  
  
Checks that you don't have old versions of the libraries lying around
on your filesystem...
  
  


-- 



  

  
  
  
  
  
  
  
  Edouard Leib - el...@perax.fr
  Administrateur Réseaux/Systèmes/Téléphonie
  Tél. +33 (0)5 62 75 95 71
 / Automates de
télégestion - 
   w w w . p e r
a x . f r
  
   Avant d'imprimer, ayez une pensée
pour notre environnement
  

  




-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration problems

[Wolfgang Sourdeau]

Edouard LEIB wrote:

Hello all,

We have some troubles with migration from 1.0.2 version to 1.2.2 version.



Checks that you don't have old versions of the libraries lying around on 
your filesystem...


--
Wolfgang Sourdeau  ::  +1 (514) 447-4918 ext. 125  ::  wsourd...@inverse.ca
Inverse inc. Leaders behind SOGo (sogo.nu) and PacketFence 
(www.packetfence.org)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists