subject:"\[SOGo\] sogo\-tool restore"

[SOGo] sogo-tool restore with remove - sogo-tool remove single objects

2019-04-30 Thread Thomas Winterstein


Hello,

we've got a ticket where a user needs a restore of a few calendar 
objects because their client somehow threw data from multiple calendars 
together.


Obviously we could create a recent backup, remove the whole user 
account, restore all but the few faulty calendars and then restore them 
from an earlier backup date. But that's not a very elegant solution.


- first idea was a simple sogo-tool restore but that does not support 
the deletion of elements if I tested correctly


- next I tried to remove single calendars but sogo-tool also does not 
support that


What would be the best solution for the issue? I don't want to start 
deleting SQL tables and asking the issuer to delete the specific objects 
also isn't a viable way.


I haven't found any bug reports or feature requests to that matter either.

Regards
--
Thomas Winterstein ... http://www.rz.uni-augsburg.de/zebra
Universität Augsburg, Rechenzentrum . Tel. (0821) 598-2068
86135 Augsburg .. Fax. (0821) 598-2010
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool restore

2017-03-29 Thread Hubert Gilch

I tested it myself, sogo-tool restore just adds items that are not in 
sogo anymore and doesn't delete anything.


Mit freundlichem Gruß
i. A. Hubert Gilch

Systemadministrator

SEP Logistik AG
Ziegelstr. 2
83629 Weyarn
Tel.: +49 8020 905-214
Fax: +49 8020 905-100
E-Mail: h...@sepag.de 
Web: www.sepag.de 


Sitz der Gesellschaft: Weyarn Rechtsform: Aktiengesellschaft Amtsgericht 
München: HRB 119679
Vorstand: Professor Dr.-Ing. Franz Demmelmeier (Vorsitzender), 
Dipl.-Ing. Konrad Schneider, MBA, Dipl.-Ing. Markus Fischbacher

Aufsichtsratsvorsitzender Michael Pelzer

Am 28.03.2017 um 10:12 schrieb Hubert Gilch (h...@sepag.de):


Good morning,

when i restore a users data, will information entered after the backup 
was created deleted or just the information appended that is not in 
sogo anymore.


Background: A user has accidently deleted some addresses and i want to 
restore them from backup without deleting any new data.


Thank you.


--
Mit freundlichem Gruß
i. A. Hubert Gilch

Systemadministrator

SEP Logistik AG
Ziegelstr. 2
83629 Weyarn
Tel.: +49 8020 905-214
Fax: +49 8020 905-100
E-Mail: h...@sepag.de 
Web: www.sepag.de 


Sitz der Gesellschaft: Weyarn Rechtsform: Aktiengesellschaft 
Amtsgericht München: HRB 119679
Vorstand: Professor Dr.-Ing. Franz Demmelmeier (Vorsitzender), 
Dipl.-Ing. Konrad Schneider, MBA, Dipl.-Ing. Markus Fischbacher

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


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

[SOGo] sogo-tool restore

2017-03-28 Thread Hubert Gilch


Good morning,

when i restore a users data, will information entered after the backup 
was created deleted or just the information appended that is not in sogo 
anymore.


Background: A user has accidently deleted some addresses and i want to 
restore them from backup without deleting any new data.


Thank you.


--
Mit freundlichem Gruß
i. A. Hubert Gilch

Systemadministrator

SEP Logistik AG
Ziegelstr. 2
83629 Weyarn
Tel.: +49 8020 905-214
Fax: +49 8020 905-100
E-Mail: h...@sepag.de 
Web: www.sepag.de 


Sitz der Gesellschaft: Weyarn Rechtsform: Aktiengesellschaft Amtsgericht 
München: HRB 119679
Vorstand: Professor Dr.-Ing. Franz Demmelmeier (Vorsitzender), 
Dipl.-Ing. Konrad Schneider, MBA, Dipl.-Ing. Markus Fischbacher

Aufsichtsratsvorsitzender Michael Pelzer

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

[SOGo] sogo-tool restore core dumps

2017-02-22 Thread Philip Jocks

Hej,

we're trying to migrate a sogo server and use sogo-tool backup … ALL to dump 
and then sogo-tool restore -p and -f to import those backups. With some 
backups, the sogo-tool restore dies without a usable reason. We tracked it to 
some corrupted entries, in one case a malformed address book entry.

Is there a way to further debug this? I can't share the particular user data on 
the mailing list, of course, but talking to the user, we could examine the dump 
together with a developer, maybe?

Cheers,

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

Re: [SOGo] sogo-tool restore not working: segmentation fault

2012-06-15 Thread Christian Mack

Hello Hartmut Raithel


On 2012-06-14 17:03, Hartmut Raithel wrote:
 
 I’m running SOGo version 1.3.16-1 on a Ubuntu 10.04.4 LTS System and
 sogo is running well, in general.
 
 The SW Versions (prebuild from Ubuntu repository)are:
 
 sogo@sh-sogodev01:~/backup/2012-06-14_1455$ dpkg -l |grep sogo

 sogo1.3.16-1  
 
 
 libsope-appserver4.9  4.9.r1664.20120601  SOPE application server 
 libraries
 libsope-core4.9   4.9.r1664.20120601  Core libraries of the 
 SOPE application serve
 libsope-gdl1-4.9  4.9.r1664.20120601  GNUstep database 
 libraries for SOPE
 libsope-ldap4.9   4.9.r1664.20120601  SOPE libraries for LDAP 
 access
 libsope-mime4.9   4.9.r1664.20120601  SOPE libraries for MIME 
 processing
 libsope-xml4.94.9.r1664.20120601  SOPE libraries for XML 
 processing
 sope4.9-gdl1-mysql4.9.r1664.20120601  MySQL connector for 
 SOPE's fork of the GNUst
 sope4.9-gdl1-postgresql   4.9.r1664.20120601  ̇̇̇PostgreSQL connector 
 for SOPE's fork of the 
 sope4.9-libxmlsaxdriver   4.9.r1664.20120601  XML Parser for SOPE's 
 SAX engine
 
 gnustep-base-common   1.19.3-1ubuntu1 GNUstep Base library - 
 common files
 gnustep-base-runtime  1.19.3-1ubuntu1 GNUstep Base library
 gnustep-common2.2.0-1 Common files for the 
 core GNUstep environmen
 gnustep-make  2.2.0-1 Basic GNUstep Makefiles
 libgnustep-base1.19   1.19.3-1ubuntu1 GNUstep Base library
 
 libsope-gdl1-4.9  4.9.r1664.20120601  GNUstep database 
 libraries for SOPE
 

I don't see package sogo-tool here.
Did you upgrade that as well?


...
 In case of the user has deleted some appointments after the backup, the
 restore fails with segfault:
 
 sogo@sh-sogodev01:~/backup/2012-06-14_1455$ sogo-tool restore -f
 Calendar/personal . aaasys08
 
 Jun 14 15:12:46 sogo-tool [15238]: 0x0x82db948[SOGoCache] Cache
 cleanup interval set every 1.00 seconds
 
 Jun 14 15:12:46 sogo-tool [15238]: 0x0x82db948[SOGoCache] Using
 host(s) 'localhost' as server(s)
 
 2012-06-14 15:12:46.422 sogo-tool[15238] PostgreSQL72 connection
 established: 0x0x81baa58[PGConnection]:  connection=0x0x8369a50
 
 2012-06-14 15:12:46.422 sogo-tool[15238] PostgreSQL72 channel
 0x0x832d680 opened (connection=0x0x81baa58[PGConnection]: 
 connection=0x0x8369a50)
 
 2012-06-14 15:12:46.422 sogo-tool[15238] PG0x0x832d680 SQL: 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
 = 'aaasys08' AND c_path3 = 'Calendar' AND c_path4 = 'personal'
 
 2012-06-14 15:12:46.432 sogo-tool[15238] PG0x0x832d680 SQL: UPDATE
 sogo_folder_info SET c_foldername = 'Persönlicher Kalender' WHERE c_path
 = '/Users/aaasys08/Calendar/personal'
 
 2012-06-14 15:12:46.435 sogo-tool[15238] PG0x0x832d680 SQL: BEGIN
 TRANSACTION
 
 2012-06-14 15:12:46.435 sogo-tool[15238] PG0x0x832d680 SQL: DELETE FROM
 sogoaaasys08004000ea9ed_acl
 
 2012-06-14 15:12:46.436 sogo-tool[15238] PG0x0x832d680 SQL: COMMIT
 TRANSACTION
 
 2012-06-14 15:12:46.437 sogo-tool[15238] PG0x0x832d680 SQL: BEGIN
 TRANSACTION
 
 2012-06-14 15:12:46.437 sogo-tool[15238] PG0x0x832d680 SQL: INSERT INTO
 sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
 ('/aaasys08/Calendar/personal', 'sx', 'PublicViewer')
 
 2012-06-14 15:12:46.438 sogo-tool[15238] PG0x0x832d680 SQL: INSERT INTO
 sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
 ('/aaasys08/Calendar/personal', 'sx', 'ConfidentialDAndTViewer')
 
 2012-06-14 15:12:46.438 sogo-tool[15238] PG0x0x832d680 SQL: INSERT INTO
 sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
 ('/aaasys08/Calendar/personal', 'sx', 'ObjectCreator')
 
 2012-06-14 15:12:46.438 sogo-tool[15238] PG0x0x832d680 SQL: INSERT INTO
 sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
 ('/aaasys08/Calendar/personal', 'sx', 'ObjectEraser')
 
 2012-06-14 15:12:46.439 sogo-tool[15238] PG0x0x832d680 SQL: COMMIT
 TRANSACTION
 
 2012-06-14 15:12:46.440 sogo-tool[15238] PG0x0x832d680 SQL: SELECT
 c_name FROM sogoaaasys08004000ea9ed WHERE (c_deleted != 1 OR c_deleted
 IS NULL)
 
 2012-06-14 15:12:46.441 sogo-tool[15238] restoring record
 '4E7-4FD9DF00-13-4D8FFA80.ics'
 
 2012-06-14 15:12:46.442 sogo-tool[15238] PG0x0x832d680 SQL: SELECT
 c_version, c_deleted FROM sogoaaasys08004000ea9ed WHERE (c_name =
 '4E7-4FD9DF00-13-4D8FFA80.ics')
 
 2012-06-14 15:12:46.442 sogo-tool[15238] PG0x0x832d680 SQL: BEGIN
 TRANSACTION
 
 2012-06-14 15:12:46.443 sogo-tool[15238] PG0x0x832d680 SQL: DELETE FROM
 sogoaaasys08004000ea9ed WHERE c_name = '4E7-4FD9DF00-13-4D8FFA80.ics'
 
 2012-06-14 15:12:46.443 sogo-tool[15238] PG0x0x832d680 SQL: COMMIT
 TRANSACTION
 
 Speicherzugriffsfehler

Re: [SOGo] sogo-tool restore not working: segmentation fault

2012-06-15 Thread J. Echter

Am 15.06.2012 11:23, schrieb Christian Mack:
 Hello Hartmut Raithel


 On 2012-06-14 17:03, Hartmut Raithel wrote:
 I’m running SOGo version 1.3.16-1 on a Ubuntu 10.04.4 LTS System and
 sogo is running well, in general.

 The SW Versions (prebuild from Ubuntu repository)are:

 sogo@sh-sogodev01:~/backup/2012-06-14_1455$ dpkg -l |grep sogo

 sogo1.3.16-1 
  

 libsope-appserver4.9 4.9.r1664.20120601  SOPE application server 
 libraries
 libsope-core4.9  4.9.r1664.20120601  Core libraries of the 
 SOPE application serve
 libsope-gdl1-4.9 4.9.r1664.20120601  GNUstep database 
 libraries for SOPE
 libsope-ldap4.9  4.9.r1664.20120601  SOPE libraries for LDAP 
 access
 libsope-mime4.9  4.9.r1664.20120601  SOPE libraries for MIME 
 processing
 libsope-xml4.9   4.9.r1664.20120601  SOPE libraries for XML 
 processing
 sope4.9-gdl1-mysql   4.9.r1664.20120601  MySQL connector for 
 SOPE's fork of the GNUst
 sope4.9-gdl1-postgresql  4.9.r1664.20120601  ̇̇̇PostgreSQL connector 
 for SOPE's fork of the 
 sope4.9-libxmlsaxdriver  4.9.r1664.20120601  XML Parser for SOPE's 
 SAX engine

 gnustep-base-common  1.19.3-1ubuntu1 GNUstep Base library - 
 common files
 gnustep-base-runtime 1.19.3-1ubuntu1 GNUstep Base library
 gnustep-common   2.2.0-1 Common files for the 
 core GNUstep environmen
 gnustep-make 2.2.0-1 Basic GNUstep Makefiles
 libgnustep-base1.19  1.19.3-1ubuntu1 GNUstep Base library

 libsope-gdl1-4.9 4.9.r1664.20120601  GNUstep database 
 libraries for SOPE

 I don't see package sogo-tool here.
 Did you upgrade that as well?


 ...
 In case of the user has deleted some appointments after the backup, the
 restore fails with segfault:

 sogo@sh-sogodev01:~/backup/2012-06-14_1455$ sogo-tool restore -f
 Calendar/personal . aaasys08

 Jun 14 15:12:46 sogo-tool [15238]: 0x0x82db948[SOGoCache] Cache
 cleanup interval set every 1.00 seconds

 Jun 14 15:12:46 sogo-tool [15238]: 0x0x82db948[SOGoCache] Using
 host(s) 'localhost' as server(s)

 2012-06-14 15:12:46.422 sogo-tool[15238] PostgreSQL72 connection
 established: 0x0x81baa58[PGConnection]:  connection=0x0x8369a50

 2012-06-14 15:12:46.422 sogo-tool[15238] PostgreSQL72 channel
 0x0x832d680 opened (connection=0x0x81baa58[PGConnection]: 
 connection=0x0x8369a50)

 2012-06-14 15:12:46.422 sogo-tool[15238] PG0x0x832d680 SQL: 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
 = 'aaasys08' AND c_path3 = 'Calendar' AND c_path4 = 'personal'

 2012-06-14 15:12:46.432 sogo-tool[15238] PG0x0x832d680 SQL: UPDATE
 sogo_folder_info SET c_foldername = 'Persönlicher Kalender' WHERE c_path
 = '/Users/aaasys08/Calendar/personal'

 2012-06-14 15:12:46.435 sogo-tool[15238] PG0x0x832d680 SQL: BEGIN
 TRANSACTION

 2012-06-14 15:12:46.435 sogo-tool[15238] PG0x0x832d680 SQL: DELETE FROM
 sogoaaasys08004000ea9ed_acl

 2012-06-14 15:12:46.436 sogo-tool[15238] PG0x0x832d680 SQL: COMMIT
 TRANSACTION

 2012-06-14 15:12:46.437 sogo-tool[15238] PG0x0x832d680 SQL: BEGIN
 TRANSACTION

 2012-06-14 15:12:46.437 sogo-tool[15238] PG0x0x832d680 SQL: INSERT INTO
 sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
 ('/aaasys08/Calendar/personal', 'sx', 'PublicViewer')

 2012-06-14 15:12:46.438 sogo-tool[15238] PG0x0x832d680 SQL: INSERT INTO
 sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
 ('/aaasys08/Calendar/personal', 'sx', 'ConfidentialDAndTViewer')

 2012-06-14 15:12:46.438 sogo-tool[15238] PG0x0x832d680 SQL: INSERT INTO
 sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
 ('/aaasys08/Calendar/personal', 'sx', 'ObjectCreator')

 2012-06-14 15:12:46.438 sogo-tool[15238] PG0x0x832d680 SQL: INSERT INTO
 sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
 ('/aaasys08/Calendar/personal', 'sx', 'ObjectEraser')

 2012-06-14 15:12:46.439 sogo-tool[15238] PG0x0x832d680 SQL: COMMIT
 TRANSACTION

 2012-06-14 15:12:46.440 sogo-tool[15238] PG0x0x832d680 SQL: SELECT
 c_name FROM sogoaaasys08004000ea9ed WHERE (c_deleted != 1 OR c_deleted
 IS NULL)

 2012-06-14 15:12:46.441 sogo-tool[15238] restoring record
 '4E7-4FD9DF00-13-4D8FFA80.ics'

 2012-06-14 15:12:46.442 sogo-tool[15238] PG0x0x832d680 SQL: SELECT
 c_version, c_deleted FROM sogoaaasys08004000ea9ed WHERE (c_name =
 '4E7-4FD9DF00-13-4D8FFA80.ics')

 2012-06-14 15:12:46.442 sogo-tool[15238] PG0x0x832d680 SQL: BEGIN
 TRANSACTION

 2012-06-14 15:12:46.443 sogo-tool[15238] PG0x0x832d680 SQL: DELETE FROM
 sogoaaasys08004000ea9ed WHERE c_name = '4E7-4FD9DF00-13-4D8FFA80.ics'

 2012-06-14 15:12:46.443 sogo-tool[15238] PG0x0x832d680 SQL: COMMIT
 TRANSACTION

 Speicherzugriffsfehler

Solved: [SOGo] sogo-tool restore not working: segmentation fault

2012-06-15 Thread Hartmut Raithel (Rechenzentrum)

Hello Christian,


Am Freitag, 15. Juni 2012 11:23 CEST, Christian Mack christian.m...@uni-konstanz.de schrieb:


	Hello Hartmut Raithel
	
	
	
	If you have the up to date sogo-tool, you should open a bug report at
	http://www.sogo.nu/bugs
	
	
	Kind regards,
	Christian Mack
	
	--
	Christian Mack
	Gruppe Informationsdienste
	Rechenzentrum Universitt Konstanz

As J.Echter has mentioned before, there is no separate sogo-tool package available in ubuntu repository. But because of your suggestions, i got it!
I had installed the System with sogo ver. 1.3.14 and have updated it afterwards with apt-get upgrade. It seems there was some inconsitencies in the ubuntu 10.04 sogo packages. There are two sogo-tool binaries on the System yet, one in /usr/bin and one in /usr/sbin:

sogo@sh-sogodev01:~/backup/2012-06-14_1455$ ls -l /usr/bin/sogo-tool /usr/sbin/sogo-tool
-rwxr-xr-x 1 root root 94132 2012-02-14 09:16 /usr/bin/sogo-tool*
-rwxr-xr-x 1 root root 95704 2012-06-07 19:32 /usr/sbin/sogo-tool*

Unfortunately /usr/bin/sogo-tool, which is in path of the user sogo, was not properly up-to date. When using the /usr/sbin/sogo-tool binary, the restore is workin correctly.
Maybe, in case of the authors of the ubuntu packages is reading this, they may take a look onto this missmatch, to avoid confusion of other users. ;-)

Many thanks for your help!

Kind regards
Hartmut


-- Hartmut Raithel
Hochschule Hof | University of Applied Sciences
Rechenzentrum | Data Center
Infrastructure Services

Alfons-Goppel-Platz 1

95028 Hof
Email: hartmut.rait...@hof-university.de
Fon: +49 9281 409-3634
Fax: +49 9281 409-553634

[SOGo] sogo-tool restore with remove - sogo-tool remove single objects

Re: [SOGo] sogo-tool restore

[SOGo] sogo-tool restore

[SOGo] sogo-tool restore core dumps

Re: [SOGo] sogo-tool restore not working: segmentation fault

Re: [SOGo] sogo-tool restore not working: segmentation fault

Solved: [SOGo] sogo-tool restore not working: segmentation fault

7 matches

Site Navigation

Mail list logo

Footer information