Re: [SOGo] users transfer from one server to another

2012-09-24 Thread Jean-Michel OLTRA

Bonjour,


Le lundi 24 septembre 2012, Christian Mack a écrit...


> Could you please open a bug report for this at
> http://www.sogo.nu/bugs

> With that it could be fixed for all of us admins.

Done.

-- 
jm

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


Re: [SOGo] users transfer from one server to another

2012-09-24 Thread Christian Mack
Hello Jean-Michel OLTRA


On 2012-09-23 12:49, Jean-Michel OLTRA wrote:
> 
> Le samedi 22 septembre 2012, Jean-Michel OLTRA a écrit...
>>
>> I tried with sogo-tool restore (from a backup) : restore -f ALL
>> 
>> No way! SOGo creates new tables and new rows in the sogo_folder_info
>> tables when the user connects, and the requests for Agendas and Contacts
>> are failing.
>> 
>> Other ideas?
> 
> Solved!!
> 
> There is a lack of error message in the `-f ALL` option.
> 
> I began by restoring preferences, with 
> `sogo-tool restore -p  `
> So far, so good! I did not believe it!
> 
> Then I tried `sogo-tool restore -l  `, which gave
> me the list of folders.
> 
> I began by Contacts/personal, and had an error for user g.fremery
> 
> no user table '/Users/g.fremery/Contacts/personal' found
> 
> Having the error, I was able to fix the  problem: in the backup file the
> table names were /Users/g.frem...@imereos.fr/Contacts/personal, for this
> folder. I had to delete the @imereos part of the folder name, and could
> restore the backup.
> 
> I already had a problem concerning the backup file name: it was
> something like au...@imereos.fr, and I had to rename it shortly as aUser
> to be able to load it (error message saying the backup file could not be
> loaded).
> 
> It's a pity that the `restore -f ALL` did not send me an error upon the
> table name, as the `-f ` did.
> 

Could you please open a bug report for this at
http://www.sogo.nu/bugs

With that it could be fixed for all of us admins.


Thanks and kind regards,
Christian Mack

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


Re: [SOGo] users transfer from one server to another

2012-09-23 Thread Jean-Michel OLTRA

Bonjour,


Le samedi 22 septembre 2012, Jean-Michel OLTRA a écrit...


> I tried with sogo-tool restore (from a backup) : restore -f ALL

> No way! SOGo creates new tables and new rows in the sogo_folder_info
> tables when the user connects, and the requests for Agendas and Contacts
> are failing.

> Other ideas?

Solved!!

There is a lack of error message in the `-f ALL` option.

I began by restoring preferences, with 
`sogo-tool restore -p  `
So far, so good! I did not believe it!

Then I tried `sogo-tool restore -l  `, which gave
me the list of folders.

I began by Contacts/personal, and had an error for user g.fremery

no user table '/Users/g.fremery/Contacts/personal' found

Having the error, I was able to fix the  problem: in the backup file the
table names were /Users/g.frem...@imereos.fr/Contacts/personal, for this
folder. I had to delete the @imereos part of the folder name, and could
restore the backup.

I already had a problem concerning the backup file name: it was
something like au...@imereos.fr, and I had to rename it shortly as aUser
to be able to load it (error message saying the backup file could not be
loaded).

It's a pity that the `restore -f ALL` did not send me an error upon the
table name, as the `-f ` did.

Have a nice Sunday!

-- 
jm

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


[SOGo] users transfer from one server to another

2012-09-22 Thread Jean-Michel OLTRA

Bonjour,


Is there a way to restore users datas from one server to another? No
problems for mails, with rsync between folders. But I have not been able
to restore neither agendas, nor contacts.

I tried with mysqldump, inserting rows in the sogo_folder_info tables,
and creating new tables from the dump.

I tried with sogo-tool restore (from a backup) : restore -f ALL

No way! SOGo creates new tables and new rows in the sogo_folder_info
tables when the user connects, and the requests for Agendas and Contacts
are failing.

The only way we found by now is with export/import functions.

Other ideas?

Thanks.

-- 
jm

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