Re: [SOGo] sogo-tool

[Christian Mack]

Hello Benjamin Pierrot


On 2012-04-05 13:39, Benjamin Pierrot wrote:
> 
> Someone could you assist me?
> I will wish to add via a script type sogo-tool a webcalendar as a url. I
> have not managed to do so by sending a json parameter to sogo-tool.
> I wish to know if this feature exists and in case if it is not supported
> if you plan to do or if I have to act directly in the database.
> 

Sorry, but it is not clear to me, what you want to achieve.
Please elaborate a bit more.


Kind regards,
Christian Mack

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

Re: [SOGo] sogo-tool

[Benjamin Pierrot]

Hello,
Sorry for my bad explanation and thank you for your interest in my problem.
I want to add an external calendar example 
"http://www.education.gouv.fr/download.php?file=http://media.education.gouv.fr/ics/Calendrier_Scolaire_Zones_A_B_C.ics"; 
in sogoof a certain number of my users.
So this is a webcalendar! (in database : 
({"Calendar":{"WebCalendars":{"vacances:Calendar\/VAC":"http:\\//www.education.gouv.fr\/download.php?file=http:\/\/media.education.gouv.fr\/ics\/Calendrier_Scolaire_Zones_A_B_C.ics 
"}}}).


My wish would be toscript this with sogo-tool. As for other functions 
such as filters sieves

example :
sogo-tool user-preferences set defaults patrick admin:qwerty 
SOGoSieveFilters '{"SOGoSieveFilters": [{"active": true, "actions": 
[{"method": "fileinto", "argument": "myfolder"}], "rules": [{"operator": 
"contains", "field": "subject", "value": "bar"}], "match": "any", 
"name":"foo"}]}')


cordially

--
***
Benjamin PIERROT
DSI : Pôle Production TICE et Services
Université Jean Monnet Saint-Etienne
Tél : 04 69 66 31 09


Le 05/04/2012 15:20, Christian Mack a écrit :

Sorry, but it is not clear to me, what you want to achieve.
Please elaborate a bit more.

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

Re: [SOGo] sogo-tool

[Christian Mack]

Hello Benjamin Pierrot


On 2012-04-05 17:12, Benjamin Pierrot wrote:
> Hello,
> Sorry for my bad explanation and thank you for your interest in my problem.
> I want to add an external calendar example
> "http://www.education.gouv.fr/download.php?file=http://media.education.gouv.fr/ics/Calendrier_Scolaire_Zones_A_B_C.ics";
>   in
> sogoof a certain number of my users.
> So this is a webcalendar! (in database :
> ({"Calendar":{"WebCalendars":{"vacances:Calendar\/VAC":"http:\\//www.education.gouv.fr\/download.php?file=http:\/\/media.education.gouv.fr\/ics\/Calendrier_Scolaire_Zones_A_B_C.ics
> "}}}).
> 
> My wish would be toscript this with sogo-tool. As for other functions
> such as filters sieves
> example :
> sogo-tool user-preferences set defaults patrick admin:qwerty
> SOGoSieveFilters '{"SOGoSieveFilters": [{"active": true, "actions":
> [{"method": "fileinto", "argument": "myfolder"}], "rules": [{"operator":
> "contains", "field": "subject", "value": "bar"}], "match": "any",
> "name":"foo"}]}')
> 

I never tried to create a calendar with sogo-tool, but it should work.

Calendar definitions are not defaults, but settings.
So in your script you have to look at the existing calendar settings with:
sogo-tool user-preferences get settings ${USERNAME} Calendar

Then enhance it with your chosen WebCalendar settings and store this
with "set".


But be aware that you _never_ should use duplicate UUIDs. So your script
has to check this first, before inserting your new web calendar entry.
I don't know how to do that, without querying the database itself.


Kind regards,
Christian Mack

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

Re: [SOGo] sogo-tool

[Pierrot Benjamin]

Thank you very much for your answer... This is exactly what I was looking for.

Best regards
--
--
***
Benjamin PIERROT
DSI : Pôle Production TICE et Services
Université Jean Monnet Saint-Etienne


Le Jeudi 5 Avril 2012 17:49 CEST, Christian Mack 
 a écrit:

> Hello Benjamin Pierrot
>
>
> On 2012-04-05 17:12, Benjamin Pierrot wrote:
> > Hello,
> > Sorry for my bad explanation and thank you for your interest in my problem.
> > I want to add an external calendar example
> > "http://www.education.gouv.fr/download.php?file=http://media.education.gouv.fr/ics/Calendrier_Scolaire_Zones_A_B_C.ics";
> >   in
> > sogoof a certain number of my users.
> > So this is a webcalendar! (in database :
> > ({"Calendar":{"WebCalendars":{"vacances:Calendar\/VAC":"http:\\//www.education.gouv.fr\/download.php?file=http:\/\/media.education.gouv.fr\/ics\/Calendrier_Scolaire_Zones_A_B_C.ics
> > "}}}).
> >
> > My wish would be toscript this with sogo-tool. As for other functions
> > such as filters sieves
> > example :
> > sogo-tool user-preferences set defaults patrick admin:qwerty
> > SOGoSieveFilters '{"SOGoSieveFilters": [{"active": true, "actions":
> > [{"method": "fileinto", "argument": "myfolder"}], "rules": [{"operator":
> > "contains", "field": "subject", "value": "bar"}], "match": "any",
> > "name":"foo"}]}')
> >
>
> I never tried to create a calendar with sogo-tool, but it should work.
>
> Calendar definitions are not defaults, but settings.
> So in your script you have to look at the existing calendar settings with:
> sogo-tool user-preferences get settings ${USERNAME} Calendar
>
> Then enhance it with your chosen WebCalendar settings and store this
> with "set".
>
>
> But be aware that you _never_ should use duplicate UUIDs. So your script
> has to check this first, before inserting your new web calendar entry.
> I don't know how to do that, without querying the database itself.
>
>
> Kind regards,
> Christian Mack
>
> --
> Christian Mack
> Gruppe Informationsdienste
> Rechenzentrum Universität Konstanz
>



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

Re: [SOGo] sogo-tool

[Jérôme]

Hi Benjamin,

Have you succeeded ?
Has someone else done this work ?

In fact, i've tried to realize it with sogo 2, the webcalendar link appears in
user-preferences (cf sogo-tool), but it doesn't appear on web interface.

It seems that one entry in sogo_folder_info is missing and i don't want to
perfome sql requests.

Someone can help me ?

Pierrot Benjamin  writes:


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

Re: [SOGo] sogo-tool

[Jakob Lenfers]

On 15.02.2011 14:50, Jakob Lenfers wrote:

> <0x0x9a4ea50[SOGoCache]> an error occurred when caching value for key
> 'Domain Computers@localhost+attributes': "CLIENT ERROR"
> 
> 
> 
> <0x0xa013ab8[GSCBufferString]> json parser: Object key string expected
> <0x0xa013ab8[GSCBufferString]> original string is: {
> Calendar = {
> };
> }
> 
> 
> Do I need to worry? Or is all the data backed up now?

Besides that, the migration seems to have solved our problems with
thunderbird. We will do some testing next week and hopefully move the
SOGo server to the Ubuntu box.

But input on those errors is still appreciated. :)

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

Re: [SOGo] sogo-tool

[Jakob Lenfers]

On 15.02.2011 14:50, Jakob Lenfers wrote:

> [... sogo-tool]
> This generally works, but throws occasionally errors like those two:
> 
> <0x0x9a4ea50[SOGoCache]> an error occurred when caching value for key
> 'Domain Computers@localhost+attributes': "CLIENT ERROR"
> 
> 
> 
> <0x0xa013ab8[GSCBufferString]> json parser: Object key string expected
> <0x0xa013ab8[GSCBufferString]> original string is: {
> Calendar = {
> };
> }
> 
> 
> Do I need to worry? Or is all the data backed up now?

Doesn't anyone have a clue? I'm a bit afraid to migrate all our user
data this way, I'm not sure everything would get copied. :-/

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

Re: [SOGo] sogo-tool

[Mohit Chawla]

On Mon, Feb 21, 2011 at 1:58 PM, Jakob Lenfers wrote:

> Doesn't anyone have a clue? I'm a bit afraid to migrate all our user
> data this way, I'm not sure everything would get copied. :-/
>

While taking a backup of 8000 users ( not much data though ) , I saw a
similar error ( the first one ) only for a single user. Didn't investigate
it further, but  other users' data was ok.
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGO-Tool

[Patrick Ben Koetter]

* Dominique :
> Hi,
> 
> I must be tired, but I can seen to have the sogo-tool working. I
> have simple setup my cyrus and mysql on Ubuntu server 10.04 x64. All
> works fine. I just want to be able to do a backup of all config and
> users files. I read sogo-tool  was the way. OK.
> 
> But where is it? and what are the parameters because I can't seen to
> find anything tonight.
> 
> If I try sogo-tool backup /ALL, I get:
> 2011-02-27 22:24:16.055 sogo-tool[6222] No LDAP source is configured
> in the SOGo configuration of this account. Please make sure to use
> this tool under the same username as SOGo.
> which does not surprise me since I have no LDAP configured... But
> where do I configure SOGO-tool?

Was a bug. Fixed now. Will be released in v1.3.6.

p@rick


-- 
state of mind
Digitale Kommunikation

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] SOGO-Tool

[Alessio Fattorini]

Il 27/02/2011 22:26, Dominique ha scritto:

Hi,

I must be tired, but I can seen to have the sogo-tool working. I have simple 
setup my cyrus and
mysql on Ubuntu server 10.04 x64. All works fine. I just want to be able to do 
a backup of all
config and users files. I read sogo-tool was the way. OK.


you should execute "su sogo" before

--
Alessio Fattorini (alessio.fattor...@nethesis.it)

nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - i...@nethesis.it
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool

[Jakob Lenfers]

Am 21.02.2011 09:46, schrieb Mohit Chawla:
> On Mon, Feb 21, 2011 at 1:58 PM, Jakob Lenfers 
> wrote:

>> Doesn't anyone have a clue? I'm a bit afraid to migrate all our user
>> data this way, I'm not sure everything would get copied. :-/
> While taking a backup of 8000 users ( not much data though ) , I saw a
> similar error ( the first one ) only for a single user. Didn't investigate
> it further, but  other users' data was ok.

Didn't feel good about it, but I migrated with sogo-tool 2 weeks ago and
so far nobody complained about anything missing. Maybe it is safe to
ignore those messages...

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

Re: [SOGo] sogo-tool

[Ludovic Marcotte]

On 19/12/11 11:50, Dominique wrote:
I've been looking for some sogo-tool documentation because the 'help' 
info is kind of scarce.
I have sogo install through apt-get (Ubuntu) and did not use sogo-tool 
so far, but simply typing sogo-tool in the console returns an error:


<0x0xa5e8c0[SOGoStartupLogger]> No configuration found. SOGo will not 
work properly.
2011-12-19 17:48:06.930 sogo-tool[4503] ERROR(+[GCSFolderManager 
defaultFolderManager]): default 'OCSFolderInfoURL' is not configured.


Since it is the result of an automated install I have no clue where to 
look for a config file specific for sogo-tool. The one for sogo is at 
its usual place and sogo works well. 

Run it as the sogo user, not root.

--
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] sogo-tool expire

[Donny Brooks]

On Friday, March 16, 2012 04:22 PM CDT, "Donny Brooks"  wrote:


	Ever since the 1.3.12a/b/c updates I had been having issues with my sieve not able to connect to my mail server to update the sieve scripts. I fixed that today by specifying the IP of the server in the defaults file. However now when sogo-tool runs via cron to expire vacation messages I get the following error:
	
	2012-03-16 16:00:04.054 sogo-tool[7623] failure. Attempting with a renewed password (no authname supported)
	2012-03-16 16:00:04.056 sogo-tool[7623] Could not login 'gwill' on Sieve server: <0x0x1f0377b8[NGSieveClient]: socket= connectedTo=<0x0x1f0401e8[NGInternetSocketAddress]: host=10.8.2.3 port=2000>>>: (null)
	2012-03-16 16:00:04.119 sogo-tool[7623] An error occured while removing auto-reply of user gwill
	
	
	Before today I only received this error when it tried to update:
	
	2012-03-16 05:00:02.306 sogo-tool[9022] Sieve connection failed on mail.mdah.state.ms.us:2000
	2012-03-16 05:00:02.372 sogo-tool[9022] An error occured while removing auto-reply of user gwill
	
	So I thought fixing sieve would fix that but it looks like it made it worse. My mail filters are able to be edited in the web interface again though. Any ideas?
	
	--
	Donny B.

Anyone? I am at a loss. Nothing has changed on the mail server so I figure it is a missed setting in SOGo somewhere, just not sure where.


--
Donny B.

Re: [SOGo] sogo-tool fix?

[Ludovic Marcotte]

On 11-02-16 3:59 AM, Patrick Ben Koetter wrote:

Good morning,

any idea when "416: sogo-tool backup does not work in multi domain
environment "  will be fixed?

I flagged it for v1.3.6.

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] sogo-tool fix?

[Patrick Ben Koetter]

* Ludovic Marcotte :
> >any idea when "416: sogo-tool backup does not work in multi domain
> >environment "  will be fixed?
> I flagged it for v1.3.6.

Thank you Ludovic!

p@rick

-- 
state of mind
Digitale Kommunikation

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] sogo-tool script

[Philipp v. Strobl-Albeg]

Hi,

me again. There is a little bug in the script. It says "mdir" which 
should be "mkdir".
I have to point out, that this script has no to be run in the folder 
"/home/sogo/Backup", but the store of the files is there. Also there is 
no cleaning up yet. So the store will be filled until disk is full.


The script on the ftp-server is updated an the corrected code is in this 
mail.

Sorry for that.

Best Regards
Philipp

--
#! /bin/sh
## Created by PILARKTO.NET - PvSA
## PvSA, 19.4.10
## PvSA, 28.3.2011
## PvSA, 9.6.2011: for all
## PvSA, 6.7.2011: su und Debug-Info

## DEBUG
#set -x

DATE="`date +'%Y%m%d_%H%M%S'`"
#STOOL="/usr/GNUstep/System/Tools/Admin/sogo-tool"
# Changed after upgrade to 1.3.9
STOOL="/usr/sbin/sogo-tool"

mkdir -p /home/sogo/Backup
cd /home/sogo/Backup

mkdir tmp_$DATE
chown sogo:sogo tmp_$DATE
chmod -R 770 tmp_$DATE
cd tmp_$DATE

if [ `whoami` = "sogo" ]; then
if [ "$1" = "-i" ]; then
$STOOL -v backup ./ ALL
else
$STOOL backup ./ ALL >> output 2>&1
fi
else
if [ "$1" = "-i" ]; then
su sogo -c "$STOOL -v backup ./ ALL"
else
su sogo -c "$STOOL backup ./ ALL" >> output 2>&1
fi

fi


#su sogo -c "sogo-tool backup ./ ALL" > /dev/null 2>&1
#echo "Exit-Code: $?"
#exit 1

if [ "$?" != "0" ];then
echo "!"
echo "Error: Backing up with sogo-tool failed"
echo ""
cat output
else
mkdir -p ../STORE/$DATE
chmod -R 770 ../STORE/$DATE
mv * ../STORE/$DATE/
fi

cd ..
rm -rf tmp_$DATE
---

Am 25.11.2011 10:52, schrieb Philipp v. Strobl-Albeg:

Hi,

as i reading the posts of sogo-tool, it reminds me to share my 
sogo-tool (cron) script with you.

Probably this helps someone to clear his questions also.

I paste the code here and a link to download it directly.

ftp://ftp.pilarkto.net/pub/sogo-backup

The important thing is, that the script is expecting a "root-Folder": 
/home/sogo/Backup, which is automaticly created.


I hope you enjoy.

Best Regards
Philipp
- PILARKTO.NET -
---
#! /bin/sh
## Created by PILARKTO.NET - PvSA
## PvSA, 19.4.10
## PvSA, 28.3.2011
## PvSA, 9.6.2011: for all
## PvSA, 6.7.2011: su und Debug-Info

## DEBUG
#set -x

DATE="`date +'%Y%m%d_%H%M%S'`"
#STOOL="/usr/GNUstep/System/Tools/Admin/sogo-tool"
# Changed after upgrade to 1.3.9
STOOL="/usr/sbin/sogo-tool"

mdir -p /home/sogo/Backup
cd /home/sogo/Backup

mkdir tmp_$DATE
chown sogo:sogo tmp_$DATE
chmod -R 770 tmp_$DATE
cd tmp_$DATE

if [ `whoami` = "sogo" ]; then
if [ "$1" = "-i" ]; then
$STOOL -v backup ./ ALL
else
$STOOL backup ./ ALL >> output 2>&1
fi
else
if [ "$1" = "-i" ]; then
su sogo -c "$STOOL -v backup ./ ALL"
else
su sogo -c "$STOOL backup ./ ALL" >> output 2>&1
fi

fi


#su sogo -c "sogo-tool backup ./ ALL" > /dev/null 2>&1
#echo "Exit-Code: $?"
#exit 1

if [ "$?" != "0" ];then
echo "!"
echo "Error: Backing up with sogo-tool failed"
echo ""
cat output
else
mkdir -p ../STORE/$DATE
chmod -R 770 ../STORE/$DATE
mv * ../STORE/$DATE/
fi

cd ..
rm -rf tmp_$DATE
--


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

Re: [SOGo] sogo-tool script

[Julian Robbins]

On 25/11/11 17:57, Philipp v. Strobl-Albeg wrote:

Hi,

me again. There is a little bug in the script. It says "mdir" which 
should be "mkdir".
I have to point out, that this script has no to be run in the folder 
"/home/sogo/Backup", but the store of the files is there. Also there 
is no cleaning up yet. So the store will be filled until disk is full.

Hello Philipp

Could you explain what the script actually does please ? It appears to 
be related to backing up data


Julian




The script on the ftp-server is updated an the corrected code is in 
this mail.

Sorry for that.

Best Regards
Philipp

--
#! /bin/sh
## Created by PILARKTO.NET - PvSA
## PvSA, 19.4.10
## PvSA, 28.3.2011
## PvSA, 9.6.2011: for all
## PvSA, 6.7.2011: su und Debug-Info

## DEBUG
#set -x

DATE="`date +'%Y%m%d_%H%M%S'`"
#STOOL="/usr/GNUstep/System/Tools/Admin/sogo-tool"
# Changed after upgrade to 1.3.9
STOOL="/usr/sbin/sogo-tool"

mkdir -p /home/sogo/Backup
cd /home/sogo/Backup

mkdir tmp_$DATE
chown sogo:sogo tmp_$DATE
chmod -R 770 tmp_$DATE
cd tmp_$DATE

if [ `whoami` = "sogo" ]; then
if [ "$1" = "-i" ]; then
$STOOL -v backup ./ ALL
else
$STOOL backup ./ ALL >> output 2>&1
fi
else
if [ "$1" = "-i" ]; then
su sogo -c "$STOOL -v backup ./ ALL"
else
su sogo -c "$STOOL backup ./ ALL" >> output 2>&1
fi

fi


#su sogo -c "sogo-tool backup ./ ALL" > /dev/null 2>&1
#echo "Exit-Code: $?"
#exit 1

if [ "$?" != "0" ];then
echo "!"
echo "Error: Backing up with sogo-tool failed"
echo ""
cat output
else
mkdir -p ../STORE/$DATE
chmod -R 770 ../STORE/$DATE
mv * ../STORE/$DATE/
fi

cd ..
rm -rf tmp_$DATE
---

Am 25.11.2011 10:52, schrieb Philipp v. Strobl-Albeg:

Hi,

as i reading the posts of sogo-tool, it reminds me to share my 
sogo-tool (cron) script with you.

Probably this helps someone to clear his questions also.

I paste the code here and a link to download it directly.

ftp://ftp.pilarkto.net/pub/sogo-backup

The important thing is, that the script is expecting a "root-Folder": 
/home/sogo/Backup, which is automaticly created.


I hope you enjoy.

Best Regards
Philipp
- PILARKTO.NET -
---
#! /bin/sh
## Created by PILARKTO.NET - PvSA
## PvSA, 19.4.10
## PvSA, 28.3.2011
## PvSA, 9.6.2011: for all
## PvSA, 6.7.2011: su und Debug-Info

## DEBUG
#set -x

DATE="`date +'%Y%m%d_%H%M%S'`"
#STOOL="/usr/GNUstep/System/Tools/Admin/sogo-tool"
# Changed after upgrade to 1.3.9
STOOL="/usr/sbin/sogo-tool"

mdir -p /home/sogo/Backup
cd /home/sogo/Backup

mkdir tmp_$DATE
chown sogo:sogo tmp_$DATE
chmod -R 770 tmp_$DATE
cd tmp_$DATE

if [ `whoami` = "sogo" ]; then
if [ "$1" = "-i" ]; then
$STOOL -v backup ./ ALL
else
$STOOL backup ./ ALL >> output 2>&1
fi
else
if [ "$1" = "-i" ]; then
su sogo -c "$STOOL -v backup ./ ALL"
else
su sogo -c "$STOOL backup ./ ALL" >> output 2>&1
fi

fi


#su sogo -c "sogo-tool backup ./ ALL" > /dev/null 2>&1
#echo "Exit-Code: $?"
#exit 1

if [ "$?" != "0" ];then
echo "!"
echo "Error: Backing up with sogo-tool failed"
echo ""
cat output
else
mkdir -p ../STORE/$DATE
chmod -R 770 ../STORE/$DATE
mv * ../STORE/$DATE/
fi

cd ..
rm -rf tmp_$DATE
--





--
Kind Regards,

Julian Robbins
Web Marketing and IT Manager

Q-par Angus Ltd, Barons Cross Laboratories, Leominster, Herefordshire, HR6 8RS, 
United Kingdom

Telephone +44 (0) 1568 612138, Fax +44 (0) 1568 616373, Web www.q-par.com

IDEAS ENGINEERED - SPECIALISTS IN MICROWAVE and RF ENGINEERING

(Registered office)
Incorporated in England No 1826221



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

Re: [SOGo] sogo-tool script

[Philipp Strobl]

Hi,

Yes you are right. The Script backups all Users data in the Database, but of 
curse not the mail.

It has a quite modus for using with cron And a Interactive mode with the 
Parameter ("-i"), which Shows what is actually done. You can also uncomment the 
"set -x" for debug.

If the cron backup fails it tells you by mail within the cron mail what isn't 
working, so you can check And fix it.

Best regards
Philipp

Ps: sorry for spelling

Am 25.11.2011 um 19:27 schrieb Julian Robbins :

> On 25/11/11 17:57, Philipp v. Strobl-Albeg wrote:
>> Hi,
>> 
>> me again. There is a little bug in the script. It says "mdir" which should 
>> be "mkdir".
>> I have to point out, that this script has no to be run in the folder 
>> "/home/sogo/Backup", but the store of the files is there. Also there is no 
>> cleaning up yet. So the store will be filled until disk is full.
> Hello Philipp
> 
> Could you explain what the script actually does please ? It appears to be 
> related to backing up data
> 
> Julian
> 
> 
>> 
>> The script on the ftp-server is updated an the corrected code is in this 
>> mail.
>> Sorry for that.
>> 
>> Best Regards
>> Philipp
>> 
>> --
>> #! /bin/sh
>> ## Created by PILARKTO.NET - PvSA
>> ## PvSA, 19.4.10
>> ## PvSA, 28.3.2011
>> ## PvSA, 9.6.2011: for all
>> ## PvSA, 6.7.2011: su und Debug-Info
>> 
>> ## DEBUG
>> #set -x
>> 
>> DATE="`date +'%Y%m%d_%H%M%S'`"
>> #STOOL="/usr/GNUstep/System/Tools/Admin/sogo-tool"
>> # Changed after upgrade to 1.3.9
>> STOOL="/usr/sbin/sogo-tool"
>> 
>> mkdir -p /home/sogo/Backup
>> cd /home/sogo/Backup
>> 
>> mkdir tmp_$DATE
>> chown sogo:sogo tmp_$DATE
>> chmod -R 770 tmp_$DATE
>> cd tmp_$DATE
>> 
>> if [ `whoami` = "sogo" ]; then
>>if [ "$1" = "-i" ]; then
>>$STOOL -v backup ./ ALL
>>else
>>$STOOL backup ./ ALL >> output 2>&1
>>fi
>> else
>>if [ "$1" = "-i" ]; then
>>su sogo -c "$STOOL -v backup ./ ALL"
>>else
>>su sogo -c "$STOOL backup ./ ALL" >> output 2>&1
>>fi
>> 
>>fi
>> 
>> 
>> #su sogo -c "sogo-tool backup ./ ALL" > /dev/null 2>&1
>> #echo "Exit-Code: $?"
>> #exit 1
>> 
>> if [ "$?" != "0" ];then
>>echo "!"
>>echo "Error: Backing up with sogo-tool failed"
>>echo ""
>>cat output
>> else
>>mkdir -p ../STORE/$DATE
>>chmod -R 770 ../STORE/$DATE
>>mv * ../STORE/$DATE/
>> fi
>> 
>> cd ..
>> rm -rf tmp_$DATE
>> ---
>> 
>> Am 25.11.2011 10:52, schrieb Philipp v. Strobl-Albeg:
>>> Hi,
>>> 
>>> as i reading the posts of sogo-tool, it reminds me to share my sogo-tool 
>>> (cron) script with you.
>>> Probably this helps someone to clear his questions also.
>>> 
>>> I paste the code here and a link to download it directly.
>>> 
>>> ftp://ftp.pilarkto.net/pub/sogo-backup
>>> 
>>> The important thing is, that the script is expecting a "root-Folder": 
>>> /home/sogo/Backup, which is automaticly created.
>>> 
>>> I hope you enjoy.
>>> 
>>> Best Regards
>>> Philipp
>>> - PILARKTO.NET -
>>> ---
>>> #! /bin/sh
>>> ## Created by PILARKTO.NET - PvSA
>>> ## PvSA, 19.4.10
>>> ## PvSA, 28.3.2011
>>> ## PvSA, 9.6.2011: for all
>>> ## PvSA, 6.7.2011: su und Debug-Info
>>> 
>>> ## DEBUG
>>> #set -x
>>> 
>>> DATE="`date +'%Y%m%d_%H%M%S'`"
>>> #STOOL="/usr/GNUstep/System/Tools/Admin/sogo-tool"
>>> # Changed after upgrade to 1.3.9
>>> STOOL="/usr/sbin/sogo-tool"
>>> 
>>> mdir -p /home/sogo/Backup
>>> cd /home/sogo/Backup
>>> 
>>> mkdir tmp_$DATE
>>> chown sogo:sogo tmp_$DATE
>>> chmod -R 770 tmp_$DATE
>>> cd tmp_$DATE
>>> 
>>> if [ `whoami` = "sogo" ]; then
>>>if [ "$1" = "-i" ]; then
>>>$STOOL -v backup ./ ALL
>>>else
>>>$STOOL backup ./ ALL >> output 2>&1
>>>fi
>>> else
>>>if [ "$1" = "-i" ]; then
>>>su sogo -c "$STOOL -v backup ./ ALL"
>>>else
>>>su sogo -c "$STOOL backup ./ ALL" >> output 2>&1
>>>fi
>>> 
>>>fi
>>> 
>>> 
>>> #su sogo -c "sogo-tool backup ./ ALL" > /dev/null 2>&1
>>> #echo "Exit-Code: $?"
>>> #exit 1
>>> 
>>> if [ "$?" != "0" ];then
>>>echo "!"
>>>echo "Error: Backing up with sogo-tool failed"
>>>echo ""
>>>cat output
>>> else
>>>mkdir -p ../STORE/$DATE
>>>chmod -R 770 ../STORE/$DATE
>>>mv * ../STORE/$DATE/
>>> fi
>>> 
>>> cd ..
>>> rm -rf tmp_$DATE
>>> --
>> 
> 
> 
> -- 
> Kind Regards,
> 
> Julian Robbins
> Web Marketing and IT Manager
> 
> Q-par Angus Ltd, Barons Cross Laboratories, Leominster, Herefordshire, HR6 
> 8RS, United Kingdom
> 
> Telephone +44 (0) 1568 612138, Fax +44 (0) 1568 616373, Web www.q-par.com
> 
> IDEAS ENGINEERED - SPECIALISTS IN MICROWAVE and RF ENGINEERING
> 
> (Registered office)
> Incorporated in England No 1826221
> 
> 
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool restore

[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

Re: [SOGo] sogo-tool rename

[Ludovic Marcotte]

On 2017-04-11 8:28 AM, Paul van der Vlis (p...@vandervlis.nl) wrote:


I try to rename a user with something like:
sogo-tool -v rename-user adegraaf avandermeer

I get an output like this:
<0x0x8616ac0[SOGoCache]> Cache cleanup interval set every 300.00 seconds
<0x0x8616ac0[SOGoCache]> Using host(s) 'localhost' as server(s)

But when I login as the new user I don't see an calendar or adress-book.

What will be wrong?
If you logged in with that user just before renaming it, cached data 
will be in memcached. In your case, you can wait up to 300 seconds for 
the cached data to expire.


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

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

Re: [SOGo] sogo-tool remove-doubles

[Christian Mack]

Hello Donny Brooks


On 2012-03-22 19:38, Donny Brooks wrote:
> I am trying to remove some duplicate entries in my address book by using
> sogo-tool. However this is what I get when I try to do so:
> 
> -bash-3.2$ /usr/sbin/sogo-tool remove-doubles dbrooks personal
> Mar 22 13:36:43 sogo-tool [16656]: [ERROR] <0x0x808fa98[GCSFolder]>
> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot
> execute quick-fetch SQL 'SELECT
> b.c_name,a.c_givenname,a.c_cn,a.c_sn,a.c_screenname,a.c_l,a.c_mail,a.c_o,a.c_ou,b.c_telephoneNumber,b.c_content,b.c_version,b.c_creationdate,b.c_lastmodified
> FROM sogodbrooks0022dd33700_quick a, sogodbrooks0022dd33700 b WHERE
> (c_component = 'vcard') AND a.c_name = b.c_name AND (c_deleted != 1 OR
> c_deleted IS NULL)':  NAME:ExecutionFailed
> REASON:Unknown column 'b.c_telephoneNumber' in 'field list'
> Unable to fetch required fields from folder.
> 
> I am running it as the sogo user but that looks like a mysql error to
> me. What can I do to fix this?
> 

Seems there is a column c_telephoneNumber missing in your table
sogodbrooks0022dd33700.

Did you execute all database upgrade scripts on upgrading SOGo?

(We use postgres so I can't check if this is a bug or not myself.)


Kind regards,
Christian Mack

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

Re: [SOGo] sogo-tool sessions cleanup

[Jean Raby]

On 12-05-15 2:58 AM, Christian Rößner wrote:

Hi,

I have uncommented the cron line that makes session cleanups. I get these error 
messages:

2012-05-15 07:20:01.242 sogo-tool[8335] EOAdaptor: cannot find adaptor bundle: 
'postgres'
Aborted

The SOGo server is not running on the same machine as PostgreSQL. Is there some 
package or library that needs to be installed? Running on Ubuntu 10.04

To use postgresql, the sope4.9-gdl1-postgresql package needs to be 
installed.
But I guess it is... if it wasn't, your sogo installation would not work 
very well.


Can you show your config? (OCSSessionsFolderURL parameter)


Thanks in advance

-Christian Rößner

---
Roessner-Network-Solutions
Bachelor of Science Informatik
Nahrungsberg 81, 35390 Gießen
F: +49 641 5879091, M: +49 176 93118939
USt-IdNr.: DE225643613
http://www.roessner-network-solutions.com




--
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  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] sogo-tool sessions cleanup

[Christian Rößner]

>> To use postgresql, the sope4.9-gdl1-postgresql package needs to be installed.
> But I guess it is... if it wasn't, your sogo installation would not work very 
> well.
> 
Yes, SOGo itself is running and the sope-* package is installed :)

> Can you show your config? (OCSSessionsFolderURL parameter)
> 
sogo@sogo:~$ defaults read sogod OCSSessionsFolderURL
sogod OCSSessionsFolderURL 
postgres://sogo:hidden*@***hidden***:5432/sogo/sogo_sessions_folder

-Christian Rößner

---
Roessner-Network-Solutions
Bachelor of Science Informatik
Nahrungsberg 81, 35390 Gießen
F: +49 641 5879091, M: +49 176 93118939
USt-IdNr.: DE225643613
http://www.roessner-network-solutions.com



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] sogo-tool sessions cleanup

[Jean Raby]

On 12-05-15 10:22 AM, Christian Rößner wrote:

To use postgresql, the sope4.9-gdl1-postgresql package needs to be installed.

But I guess it is... if it wasn't, your sogo installation would not work very 
well.


Yes, SOGo itself is running and the sope-* package is installed :)


Can you show your config? (OCSSessionsFolderURL parameter)


sogo@sogo:~$ defaults read sogod OCSSessionsFolderURL
sogod OCSSessionsFolderURL 
postgres://sogo:hidden*@***hidden***:5432/sogo/sogo_sessions_folder

 
unless I'm mistaken, this should be 'postgresql'.



-Christian Rößner

---
Roessner-Network-Solutions
Bachelor of Science Informatik
Nahrungsberg 81, 35390 Gießen
F: +49 641 5879091, M: +49 176 93118939
USt-IdNr.: DE225643613
http://www.roessner-network-solutions.com




--
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  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] sogo-tool - not avilable

[mourik jan heupink]

doesn't yum install sogo-tool work?

On 03/03/2011 10:41 AM, Anil Thapa wrote:

in my installation i don't find sogo-tool. I installed from yum on my
centos. and sogo version 1.3.5. Where can i download this tool ? isn't
this included in sogo code installation ?

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

Re: [SOGo] sogo-tool - not avilable

[Anil Thapa]

On 03/03/2011 09:43 AM, mourik jan heupink wrote:

doesn't yum install sogo-tool work?

On 03/03/2011 10:41 AM, Anil Thapa wrote:

in my installation i don't find sogo-tool. I installed from yum on my
centos. and sogo version 1.3.5. Where can i download this tool ? isn't
this included in sogo code installation ?

Thanks - yes that did.
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool: LDAPSource -dealloc

[Ludovic Marcotte]

On 18/04/11 17:43, Patrick Ben Koetter wrote:

I can't restore my Calendar. The command ouput reports:

sogo@mail:~/2011-04-18$ /usr/sbin/sogo-tool -v restore -f Calendar/personal 
.p...@state-of-mind.de
Apr 18 23:39:25 sogo-tool [4770]:<0x0x1237900[SOGoCache]>  Cache cleanup 
interval set every 300.00 seconds
Apr 18 23:39:25 sogo-tool [4770]:<0x0x1237900[SOGoCache]>  Using host(s) 
'localhost' as server(s)
2011-04-18 23:39:25.634 sogo-tool[4770] LDAPSource: -dealloc

What can I do to fix that?
-v doesn't exist as a parameter. You can safely ignore the "LDAPSource: 
-dealloc" line, it's just a useless log message. You might want to show 
the content of the p...@state-of-mind.de file.


--
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] sogo-tool: LDAPSource -dealloc

[Patrick Ben Koetter]

* Ludovic Marcotte :
> On 18/04/11 17:43, Patrick Ben Koetter wrote:
> >I can't restore my Calendar. The command ouput reports:
> >
> >sogo@mail:~/2011-04-18$ /usr/sbin/sogo-tool -v restore -f Calendar/personal 
> >.p...@state-of-mind.de
> >Apr 18 23:39:25 sogo-tool [4770]:<0x0x1237900[SOGoCache]>  Cache cleanup 
> >interval set every 300.00 seconds
> >Apr 18 23:39:25 sogo-tool [4770]:<0x0x1237900[SOGoCache]>  Using host(s) 
> >'localhost' as server(s)
> >2011-04-18 23:39:25.634 sogo-tool[4770] LDAPSource: -dealloc
> >
> >What can I do to fix that?
> -v doesn't exist as a parameter. You can safely ignore the

It does, at least in the output of sogo-tool:

sogo@mail:~/2011-04-18$ sogo-tool
2011-04-19 07:31:01.768 sogo-tool[20165] sogo-tool [-v|--verbose] [-h|--help] 
command [argument1] ...
  -v, --verbose enable verbose mode


> "LDAPSource: -dealloc" line, it's just a useless log message. You
> might want to show the content of the p...@state-of-mind.de file.

Sent to you in private.

p@rick

-- 
state of mind
Digitale Kommunikation

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] sogo-tool list users

[Ludovic Marcotte]

On 23/09/2015 13:57, Márcio Merlone wrote:
Is there how to list all users currently on database, something like 
'sogo-tool list users' or alike?

sogo-tool doesn't have this feature.

Doing the following SQL request will tell you:

select distinct(c_path2) from sogo_folder_info;

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] sogo-tool list users

[Steve Ankeny]

On 09/23/2015 01:57 PM, Márcio Merlone wrote:

Greetings!

Is there how to list all users currently on database, something like 
'sogo-tool list users' or alike?


Regards,

--
*Marcio Merlone*


IF you're using Samba, you can use 'samba-tool' --

'sudo samba-tool user list'


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

Re: [SOGo] sogo-tool list users

[Márcio Merlone]

Em 23-09-2015 17:35, Steve Ankeny escreveu:

On 09/23/2015 01:57 PM, Márcio Merlone wrote:
Is there how to list all users currently on database, something like 
'sogo-tool list users' or alike?

IF you're using Samba, you can use 'samba-tool' --
'sudo samba-tool user list'


Hi,

My goal is to 'sogo-tool remove' old users from sogo database by 
comparing it with my samba/ldap base, I need to know who is on sogo 
regardless anything else.


Regards.

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

Re: [SOGo] sogo-tool hangs forever

[Christian Mack]

Am 08.10.2015 um 11:00 schrieb Khapare Joshi:
> when removing users with sogo-tool it hangs for ever.
> 
> sogo-tool remove khapare
> 
> nothing happens
> 
> here are the sogo version I have in my server
> sogo-2.2.16-1.centos6.x86_64
> sogo-tool-2.2.16-1.centos6.x86_64
> 
> sope49-xml-4.9-20150212_1664.el6.1.x86_64
> sope49-sbjson-2.3.1-20150212_1664.el6.1.x86_64
> sope49-cards-2.2.16-1.centos6.x86_64
> sope49-appserver-4.9-20150212_1664.el6.1.x86_64
> sope49-ldap-4.9-20150212_1664.el6.1.x86_64
> sope49-gdl1-4.9-20150212_1664.el6.1.x86_64
> sope49-debuginfo-4.9-20150212_1664.el6.1.x86_64
> sope49-gdl1-contentstore-2.2.16-1.centos6.x86_64
> sope49-gdl1-postgresql-4.9-20150212_1664.el6.1.x86_64
> sope49-core-4.9-20150212_1664.el6.1.x86_64
> sope49-mime-4.9-20150212_1664.el6.1.x86_64
> 

Do you execute this command as user sogo?


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] sogo-tool hangs forever

[Khapare Joshi]

On 10/08/2015 11:23 AM, Christian Mack wrote:

Am 08.10.2015 um 11:00 schrieb Khapare Joshi:

when removing users with sogo-tool it hangs for ever.

sogo-tool remove khapare

nothing happens

here are the sogo version I have in my server
sogo-2.2.16-1.centos6.x86_64
sogo-tool-2.2.16-1.centos6.x86_64

sope49-xml-4.9-20150212_1664.el6.1.x86_64
sope49-sbjson-2.3.1-20150212_1664.el6.1.x86_64
sope49-cards-2.2.16-1.centos6.x86_64
sope49-appserver-4.9-20150212_1664.el6.1.x86_64
sope49-ldap-4.9-20150212_1664.el6.1.x86_64
sope49-gdl1-4.9-20150212_1664.el6.1.x86_64
sope49-debuginfo-4.9-20150212_1664.el6.1.x86_64
sope49-gdl1-contentstore-2.2.16-1.centos6.x86_64
sope49-gdl1-postgresql-4.9-20150212_1664.el6.1.x86_64
sope49-core-4.9-20150212_1664.el6.1.x86_64
sope49-mime-4.9-20150212_1664.el6.1.x86_64


Do you execute this command as user sogo?

yes I execute this as a sogo user




Kind regards,
Christian Mack



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

Re: [SOGo] sogo-tool hangs forever

[Christian Mack]

Am 08.10.2015 um 15:09 schrieb Khapare Joshi:
> 
> 
> On 10/08/2015 11:23 AM, Christian Mack wrote:
>> Am 08.10.2015 um 11:00 schrieb Khapare Joshi:
>>> when removing users with sogo-tool it hangs for ever.
>>>
>>> sogo-tool remove khapare
>>>
>>> nothing happens
>>>
>>> here are the sogo version I have in my server
>>> sogo-2.2.16-1.centos6.x86_64
>>> sogo-tool-2.2.16-1.centos6.x86_64
>>>
>>> sope49-xml-4.9-20150212_1664.el6.1.x86_64
>>> sope49-sbjson-2.3.1-20150212_1664.el6.1.x86_64
>>> sope49-cards-2.2.16-1.centos6.x86_64
>>> sope49-appserver-4.9-20150212_1664.el6.1.x86_64
>>> sope49-ldap-4.9-20150212_1664.el6.1.x86_64
>>> sope49-gdl1-4.9-20150212_1664.el6.1.x86_64
>>> sope49-debuginfo-4.9-20150212_1664.el6.1.x86_64
>>> sope49-gdl1-contentstore-2.2.16-1.centos6.x86_64
>>> sope49-gdl1-postgresql-4.9-20150212_1664.el6.1.x86_64
>>> sope49-core-4.9-20150212_1664.el6.1.x86_64
>>> sope49-mime-4.9-20150212_1664.el6.1.x86_64
>>>
>> Do you execute this command as user sogo?
> yes I execute this as a sogo user
> 

Good.

Does the user you want to remove (khapare) exist in your authentication
source (AD or LDAP or auth-DB)?


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] sogo-tool hangs forever

[Khapare Joshi]

users are deleted from the LDAP therefore I don't have users in our LDAP
server, is there a way to tell sogo forcefully remove from the sogo
database ? or

On Thu, Oct 8, 2015 at 2:05 PM, Christian Mack <
christian.m...@uni-konstanz.de> wrote:

> Am 08.10.2015 um 15:09 schrieb Khapare Joshi:
> >
> >
> > On 10/08/2015 11:23 AM, Christian Mack wrote:
> >> Am 08.10.2015 um 11:00 schrieb Khapare Joshi:
> >>> when removing users with sogo-tool it hangs for ever.
> >>>
> >>> sogo-tool remove khapare
> >>>
> >>> nothing happens
> >>>
> >>> here are the sogo version I have in my server
> >>> sogo-2.2.16-1.centos6.x86_64
> >>> sogo-tool-2.2.16-1.centos6.x86_64
> >>>
> >>> sope49-xml-4.9-20150212_1664.el6.1.x86_64
> >>> sope49-sbjson-2.3.1-20150212_1664.el6.1.x86_64
> >>> sope49-cards-2.2.16-1.centos6.x86_64
> >>> sope49-appserver-4.9-20150212_1664.el6.1.x86_64
> >>> sope49-ldap-4.9-20150212_1664.el6.1.x86_64
> >>> sope49-gdl1-4.9-20150212_1664.el6.1.x86_64
> >>> sope49-debuginfo-4.9-20150212_1664.el6.1.x86_64
> >>> sope49-gdl1-contentstore-2.2.16-1.centos6.x86_64
> >>> sope49-gdl1-postgresql-4.9-20150212_1664.el6.1.x86_64
> >>> sope49-core-4.9-20150212_1664.el6.1.x86_64
> >>> sope49-mime-4.9-20150212_1664.el6.1.x86_64
> >>>
> >> Do you execute this command as user sogo?
> > yes I execute this as a sogo user
> >
>
> Good.
>
> Does the user you want to remove (khapare) exist in your authentication
> source (AD or LDAP or auth-DB)?
>
>
> Kind regards,
> Christian Mack
>
> --
> Christian Mack
> Universität Konstanz
> Kommunikations-, Informations-, Medienzentrum (KIM)
> Abteilung Basisdienste
> 78457 Konstanz
> +49 7531 88-4416
>
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool hangs forever

[Khapare Joshi]

hi Christian,

When I issue sogo-tool remove user and do the strace it hangs like this 
for ever


mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) 
= 0x7fa4e7544000

read(5, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1925
close(5)= 0
munmap(0x7fa4e7544000, 4096)= 0
socket(PF_NETLINK, SOCK_RAW, 0) = 5
bind(5, {sa_family=AF_NETLINK, pid=0, groups=}, 12) = 0
getsockname(5, {sa_family=AF_NETLINK, pid=28668, groups=}, [12]) = 0
sendto(5, "\24\0\0\0\26\0\1\3\302s\26V\0\0\0\0\0\0\0\0", 20, 0, 
{sa_family=AF_NETLINK, pid=0, groups=}, 12) = 20
recvmsg(5, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=}, 
msg_iov(1)=[{"0\0\0\0\24\0\2\0\302s\26V\374o\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 
4096}], msg_controllen=0, msg_flags=0}, 0) = 108
recvmsg(5, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=}, 
msg_iov(1)=[{"\24\0\0\0\3\0\2\0\302s\26V\374o\0\0\0\0\0\0\1\0\0\0\10\0\1\0\177\0\0\1"..., 
4096}], msg_controllen=0, msg_flags=0}, 0) = 20

close(5)= 0
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 5
setsockopt(5, SOL_TCP, TCP_NODELAY, [1], 4) = 0
fcntl(5, F_SETFL, O_RDONLY|O_NONBLOCK)  = 0
fcntl(5, F_SETFD, FD_CLOEXEC)   = 0
setsockopt(5, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
connect(5, {sa_family=AF_INET, sin_port=htons(5432), 
sin_addr=inet_addr("127.0.0.1")}, 16) = -1 EINPROGRESS (Operation now in 
progress)
poll([{fd=5, events=POLLOUT|POLLERR}], 1, -1) = 1 ([{fd=5, 
revents=POLLOUT}])

getsockopt(5, SOL_SOCKET, SO_ERROR, [0], [4]) = 0
getsockname(5, {sa_family=AF_INET, sin_port=htons(35154), 
sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
poll([{fd=5, events=POLLOUT|POLLERR}], 1, -1) = 1 ([{fd=5, 
revents=POLLOUT}])

sendto(5, "\0\0\0\10\4\322\26/", 8, MSG_NOSIGNAL, NULL, 0) = 8
poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "N", 16384, 0, NULL, NULL)  = 1
poll([{fd=5, events=POLLOUT|POLLERR}], 1, -1) = 1 ([{fd=5, 
revents=POLLOUT}])
sendto(5, "\0\0\0!\0\3\0\0user\0sogo\0database\0sogo\0"..., 33, 
MSG_NOSIGNAL, NULL, 0) = 33

poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "R\0\0\0\f\0\0\0\5x\367f\246", 16384, 0, NULL, NULL) = 13
sendto(5, "p\0\0\0(md54a1100f9f79c83dec42e783e"..., 41, MSG_NOSIGNAL, 
NULL, 0) = 41

poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "R\0\0\0\10\0\0\0\0S\0\0\0\26application_name\0\0"..., 
16384, 0, NULL, NULL) = 320
sendto(5, "Q\0\0\0,SET standard_conforming_str"..., 45, MSG_NOSIGNAL, 
NULL, 0) = 45

poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "S\0\0\0#standard_conforming_strings"..., 16384, 0, NULL, 
NULL) = 51
sendto(5, "Q\0\0\0\"set client_encoding to 'UTF"..., 35, MSG_NOSIGNAL, 
NULL, 0) = 35

poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "S\0\0\0\31client_encoding\0UTF8\0C\0\0\0\10S"..., 16384, 0, 
NULL, NULL) = 41
sendto(5, "Q\0\0\0NULL, 0) = 61

poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, 
"T\0\0\0\37\0\1c_path\0\0\5A\271\0\2\0\0\4\23\377\377\0\0\1\3\0\0"..., 
16384, 0, NULL, NULL) = 126
sendto(5, "Q\0\0\0\316SELECT c_folder_id, c_path,"..., 207, 
MSG_NOSIGNAL, NULL, 0) = 207

poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, 
"T\0\0\0\276\0\6c_folder_id\0\0\5A\271\0\1\0\0\0\27\0\4\377"..., 16384, 
0, NULL, NULL) = 471

sendto(5, "Q\0\0\0\26BEGIN TRANSACTION\0", 23, MSG_NOSIGNAL, NULL, 0) = 23
poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "C\0\0\0\nBEGIN\0Z\0\0\0\5T", 16384, 0, NULL, NULL) = 17
sendto(5, "Q\0\0\0}DELETE FROM sogo_folder_inf"..., 126, MSG_NOSIGNAL, 
NULL, 0) = 126

poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "C\0\0\0\rDELETE 1\0Z\0\0\0\5T", 16384, 0, NULL, NULL) = 20
sendto(5, "Q\0\0\0\27COMMIT TRANSACTION\0", 24, MSG_NOSIGNAL, NULL, 0) = 24
poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "C\0\0\0\vCOMMIT\0Z\0\0\0\5I", 16384, 0, NULL, NULL) = 18
sendto(5, "Q\0\0\0\26BEGIN TRANSACTION\0", 23, MSG_NOSIGNAL, NULL, 0) = 23
poll([{fd=5, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
recvfrom(5, "C\0\0\0\nBEGIN\0Z\0\0\0\5T", 16384, 0, NULL, NULL) = 17
sendto(5, "Q\0\0\0 DROP TABLE sogos0066600c017"..., 33, MSG_NOSIGNAL, 
NULL, 0) = 33

poll([{fd=5, events=POLLIN|POLLERR}], 1, -1



On 10/08/2015 11:23 AM, Christian Mack wrote:

Am 08.10.2015 um 11:00 schrieb Khapare Joshi:

when removing users with sogo-tool it hangs for ever.

sogo-tool remove khapare

nothing happens

here are the sogo version I have in my server
sogo-2.2.16-1.centos6.x86_64
sogo-tool-2.2.16-1.centos6.x86_64

sope49-xml-4.9-20150212_1664.el6.1.x86_64
sope49-sbjson-2.3.1-20150212_1664.el6.1.x86_64
sope49-cards-2

Re: [SOGo] sogo-tool remove-doubles

[Christian Mack]

Am 20.01.2016 um 18:49 schrieb Louis-Philippe:
> Hi,
> 
> In the documentation, sogo-tool remove-doubles is for contacts only. There
> is a way with sogo-tool to delete duplicate events ?
> 
> A Blackberry push a lot of existing events many times (up to 1800 times
> (copies) for one event !)
> The events have the same c_startdate  and same c_enddate but not the same
> title (encoding problem with accented letter)
> 

No, there is no such feature in SOGo.


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] sogo-tool expire-autoreply script

[Florian GRUEL]

Look at this page, it's where I found the answer last week !

http://wiki.dovecot.org/Authentication/MasterUsers


Le 06/02/2013 11:28, mich...@los-pollos.co a écrit :

ly the sogo-tool expire-autoreply script.

The script appears to require a username:password but I am struggling to
understand what that user and password should be. Some documentation says it
should be sieve-admin yet only cyrus imap allows the definition of a
sieve_admin in its conf file, dovecot sieve config doesn’t appear to have
this. I have also read somewhere that a dovecot master user should be setup and
this should be used, which I have tried by entering u%*master:[password]  but
when running manually via /usr/sbin/sogo-tool expire-autoreply
%u*master:[password] I just get errors:


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

Re: [SOGo] sogo-tool expire-autoreply script

[Jean Raby]

Hi,

On 13-02-06 3:40 AM, mich...@los-pollos.co wrote:

Hi all, successfully got a dovecot/postfix/LDAP/sogo2.04 server up and
running on Ubuntu 12.04 but having some problems getting the cron jobs
setup. Specifically the sogo-tool expire-autoreply script.

The script appears to require a username:password but I am struggling to
understand what that user and password should be. Some documentation
says it should be sieve-admin yet only cyrus imap allows the definition
of a sieve_admin in its conf file, dovecot sieve config doesn’t appear
to have this. I have also read somewhere that a dovecot master user
should be setup and this should be used, which I have tried by entering
u%*master:[password]  but when running manually via /usr/sbin/sogo-tool
expire-autoreply %u*master:[password] I just get errors:

failure. Attempting with a renewed password (no authname supported)

Could not login 'u...@example.com' on Sieve server:
<0x0x9758288[NGSieveClient]: socket=
connectedTo=<0x0x975a6e0[NGInternetSocketAddress]: host=127.0.0.1
port=4190>>>: (null)

An error occured while removing auto-reply of user u...@example.com


Entering an individual’s username and password works but obviously then
the script will only work for that particular user.

I am using virtual users located in an ldap directory.

Any help is greatly appreciated!
You need to create a master users password file and configure it as such 
in dovecot configuration file.


For example:
  passdb {
  driver = passwd-file
  args = /etc/dovecot/master-users
  master = yes
  pass = yes
  }

Then create the file and add a user:

  htpasswd  -c -s /etc/dovecot/master-users dovmaster

You should then be able to get sogo-tool expire-autoreply to work using 
user 'dovmaster'.


See http://wiki2.dovecot.org/Authentication/MasterUsers for more details.



Regards, Michael.




--
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  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] sogo-tool expire-autoreply script

[michael]

Hi, thanks for clearing this up for me. I was missing the pass = yes.

Regards, Michael. 

-Original Message-
From: Jean Raby [mailto:jr...@inverse.ca] 
Sent: Thursday, 7 February 2013 12:36 AM
To: users@sogo.nu
Subject: Re: [SOGo] sogo-tool expire-autoreply script

Hi,

On 13-02-06 3:40 AM, mich...@los-pollos.co wrote:
> Hi all, successfully got a dovecot/postfix/LDAP/sogo2.04 server up and 
> running on Ubuntu 12.04 but having some problems getting the cron jobs 
> setup. Specifically the sogo-tool expire-autoreply script.
>
> The script appears to require a username:password but I am struggling 
> to understand what that user and password should be. Some 
> documentation says it should be sieve-admin yet only cyrus imap allows 
> the definition of a sieve_admin in its conf file, dovecot sieve config 
> doesn't appear to have this. I have also read somewhere that a dovecot 
> master user should be setup and this should be used, which I have 
> tried by entering u%*master:[password]  but when running manually via 
> /usr/sbin/sogo-tool expire-autoreply %u*master:[password] I just get
errors:
>
> failure. Attempting with a renewed password (no authname supported)
>
> Could not login 'u...@example.com' on Sieve server:
> <0x0x9758288[NGSieveClient]: socket= mode=rw address=<0x0x975e530[NGInternetSocketAddress]:
> host=localhost.localdomain port=36296>
> connectedTo=<0x0x975a6e0[NGInternetSocketAddress]: host=127.0.0.1
> port=4190>>>: (null)
>
> An error occured while removing auto-reply of user u...@example.com 
> <mailto:u...@example.com>
>
> Entering an individual's username and password works but obviously 
> then the script will only work for that particular user.
>
> I am using virtual users located in an ldap directory.
>
> Any help is greatly appreciated!
You need to create a master users password file and configure it as such in
dovecot configuration file.

For example:
   passdb {
   driver = passwd-file
   args = /etc/dovecot/master-users
   master = yes
   pass = yes
   }

Then create the file and add a user:

   htpasswd  -c -s /etc/dovecot/master-users dovmaster

You should then be able to get sogo-tool expire-autoreply to work using user
'dovmaster'.

See http://wiki2.dovecot.org/Authentication/MasterUsers for more details.

>
> Regards, Michael.
>


--
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  www.inverse.ca Inverse inc.
:: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
--
users@sogo.nu
https://inverse.ca/sogo/lists

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

Re: [SOGo] sogo-tool expire-autoreply script

[David Cure]

Hello,

just one question to be sure :

> >u%*master:[password]  but when running manually via /usr/sbin/sogo-tool
> >expire-autoreply %u*master:[password] I just get errors:

Can we use %u in the authname ? (I don't see this in the doc).
Or do we need to write a wrapper to call sogo-tool expire-autoreply for
each user ? (with dovecot as imap/sieve server)

David.

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

Re: [SOGo] Sogo-tool documentation is available

[Kenren Taisho]

Thank you @qhiv...@alinto.eu . This is very helpful for
new SOGo users/administrators like me.

On Fri, Nov 3, 2023 at 12:31 AM qhivert  wrote:

> Hello all,
>
>
>
> The documentation of sogo-tool is finally available in our website here ->
> https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_using_sogo_tool
> You will find more details of each command and how to use them. The
> command sogo-tool alone will also print a link to this documentation.
>
> I’ve checked the code and tested all the commands by myself to write it
> but if you see any irregularities with your own experience, don’t hesitate
> to tell us.
>
> Quentin
>

Re: [SOGo] Sogo-tool documentation is available

[Frank Richter]

Am 02.11.23 um 17:30 schrieb qhivert (qhiv...@alinto.eu):


The documentation of sogo-tool is finally available in our website here -> 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_using_sogo_tool
You will find more details of each command and how to use them. The 
command sogo-tool alone will also print a link to this documentation.



Thanks, Quentin! It’s very useful for me.

I’d also find it useful to eleminate the dangerous bevaviour in
sogo-tool expire-sessions  not_a_number   # remove all current session

This should really print a usage information instead of removing all …

Shall I open a featere enhancement for this?

Regards,
Frank


--
Frank Richter, Chemnitz University of Technology, Germany

RE: [SOGo] Sogo-tool documentation is available

[qhivert]

I’ve added the protection, it will be in the next nightly. The doc online will 
be updated with the next release.

 

https://github.com/Alinto/sogo/commit/bb943e414d3fc8b71ebb169e31c261cd2dcd6d37

Quentin

 

From: users-requ...@sogo.nu  On Behalf Of Frank Richter
Sent: jeudi 16 novembre 2023 11:43
To: users@sogo.nu
Subject: Re: [SOGo] Sogo-tool documentation is available

 

Am 02.11.23 um 17:30 schrieb qhivert (qhiv...@alinto.eu 
<mailto:qhiv...@alinto.eu> ):

 

The documentation of sogo-tool is finally available in our website here -> 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_using_sogo_tool
You will find more details of each command and how to use them. The command 
sogo-tool alone will also print a link to this documentation.

Thanks, Quentin! It’s very useful for me.

I’d also find it useful to eleminate the dangerous bevaviour in 
sogo-tool expire-sessions  not_a_number   # remove all current session

This should really print a usage information instead of removing all …

Shall I open a featere enhancement for this?

Regards,
Frank

 

-- 
Frank Richter, Chemnitz University of Technology, Germany

Re: [SOGo] sogo-tool, restoring calendar subscriptions?

[Wolfgang Sourdeau]

tuomas wrote:

When restoring with /usr/sbin/sogo-tool restore -F ALL $username restore
also users' subscribed calendars? I keep on losing that information.


Hi Tuomas,


For restoring subscriptions, you also need to restore the user 
preferences, with the -p flag. The "-f" flag only restores the folder data.


--
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

Re: [SOGo] sogo-tool backup missing users

[Ludovic Marcotte]

On 2017-05-10 2:41 PM, Gerald Brandt (g...@majentis.com) wrote:

I don't get all the users. However, if I do sogo-tool backup 
/root/sogo alopez, I get the user missed by all. Is this a bug, or is 
there some reason the user is not done when using ALL? 

How many users do you get? Are you using LDAP-based authentication?

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

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

Re: [SOGo] sogo-tool backup missing users

[Gerald Brandt]

On 2017-05-10 07:16 PM, Ludovic Marcotte (lmarco...@inverse.ca) wrote:

On 2017-05-10 2:41 PM, Gerald Brandt (g...@majentis.com) wrote:

I don't get all the users. However, if I do sogo-tool backup 
/root/sogo alopez, I get the user missed by all. Is this a bug, or is 
there some reason the user is not done when using ALL? 

How many users do you get? Are you using LDAP-based authentication?



Hi,

Out of 50 users, I'm missing about 5. I have NethServer authenticating 
against Active Directory (Univention) server. sogo-tool doesn't need to 
authenticate though, does it?


Gerald

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

Re: [SOGo] sogo-tool, modify user preferences

["Christian M. Jensen"]

hi.

This is kinda fun to figure out. Fist do not copy paste my commands 
chack they match your enviroment. and skip step 6.


I have done the following. and it works to a point, the only issue now 
is that all is set up, BUT use ad...@example.com is not subscribed... 
how ever if i run (sogo-tool manage-acl subscribe 
meetingr...@example.com Calendar/personal ad...@example.com 
'["PublicModifier"]') again as the last step it all fall into place. 
(perhaps it's related to changing the name of the Calendar when 
'user-preferences set settings' is run.) but i do not have to much time 
to invest at the moment.


NOTE* i feel this is hacky at best maybe some one from the dev team can 
confirm or deny this. And i hope this will get you further.



1. Get the device we are using at this moment.

 ~# sogo-tool manage-eas listdevices ad...@example.com

2. validate that you are seeing the expected folders [NO share at this 
point] (i do this, you do not need to. BUT the more info/validation of 
entries the better.)


 ~# sogo-tool manage-eas listfolders ad...@example.com 
{DEVICE-ID-FROM-LISTDEVICES}


3. add and subscribe

 ~# sogo-tool manage-acl add meetingr...@example.com Calendar/personal 
ad...@example.com'["PublicModifier"]'
 ~# sogo-tool manage-acl subscribe meetingr...@example.com 
Calendar/personal ad...@example.com '["PublicModifier"]'


4. Check the shares of meetingr...@example.com:Calendar/personal.

 ~# sogo-tool manage-acl get meetingr...@example.com Calendar/personal 
ad...@example.com


 * output of 'manage-acl get' if empty results NO shares is setup, 
anf you need to start over with step 3
 * 2019-07-10 10:56:57.265 sogo-tool[17342:17342] Rights for 
meetingr...@example.com ["PublicModifier"]

 *

5. Update the user settings.

 5.1. get all user settings for key=Calendar.

 ~# sogo-tool user-preferences get settings ad...@example.com Calendar

 5.2. update the output (FULL OUTPUT) with your changes. (for me i took 
the output of 5.1 and added/appended/merged the new calendar settings 
*{,"FolderSynchronize": {}}* )
 ** NOTE: 'sogo-tool user-preferences set settings ad...@example.com 
Calendar -f /path/to/file.json' can be used to load the full json from a 
file.


 ~# sogo-tool user-preferences set settings ad...@example.com Calendar '{
    "FoldersOrder": ["1ADD-5CFD4880-1-41A25A80", "personal"],
    "View": "weekview",
    "FolderColors": {"ad...@example.com:Calendar\/personal": 
"#AA"},
    "FolderDisplayNames": 
{"meetingr...@example.com:Calendar\/personal": "Meetingroom"}
    "NotifyOnPersonalModifications": 
{"ad...@example.com:Calendar\/personal": 0},

    "EventsFilterState": "view_next7",
    "SelectedList": "eventsListView",
    "FreeBusyExclusions": {"ad...@example.com:Calendar\/personal": 0},
    "NotifyOnExternalModifications": 
{"ad...@example.com:Calendar\/personal": 1},
    "NotifyUserOnPersonalModifications": 
{"ad...@example.com:Calendar\/personal": 0},

    "TasksSortingState": ["status", "1"],
    "TasksFilterState": "view_incomplete",
    "PreventInvitationsWhitelist": {},
    "FolderSynchronize": {"ad...@example.com:Calendar\/personal": 
1, "meetingr...@example.com:Calendar\/personal": 1},

    "EventsSortingState": ["start", "1"]
}'


6. [WRONG DO NOT RUN UNLESS YOU GOT BACKUP.] i added this to showcase an 
issue when manipulating the user setting.


 ~# sogo-tool user-preferences set settings ad...@example.com Calendar 
'{"FolderSynchronize": {"meetingr...@example.com:Calendar\/personal": 1}}'
 --- NO NO NO... all my settings for my own calendars and the 
shared calendars are gone.. crying a little. 'sogo-tool manage-acl 
get'==not found back to step 3.


 This happens to be simple we are setting the value of the key 
'*Calendar*' so we need to set the full json/dictionary when 
manipulating this setting.


--
Hilsen/Regards
Christian M. Jensen


On 04-07-2019 15:41, Alexey Dunaev (k...@keir.ru) wrote:

Dear SOGo community,
I'm trying to share a calendar from one mailbox to other users with 
availability through MS Outlook via ActiveSync connection.


I've done with sharing using command
~# sogo-tool manage-acl add meetingr...@example.com 
 Calendar/personal ad...@example.com 
 [\"PublicModifier\"]
~# sogo-tool manage-acl subscribe meetingr...@example.com 
 Calendar/personal ad...@example.com 
 [\"PublicModifier\"]


And now i should add option 'Synchronize (Microsoft Enterprise 
ActiveSync)' with sogo-tool (still unchecked on this screenshot 
http://0x0.st/z2jy.png)
I didn't find exact option names (by google or sogo sources) and have 
tried something like this (of cource it's wrong):
~# sogo-tool user-preferences set settings ad...@example.com 
 '{"Calendar": {"FolderSynchronize": 
{"meetingr...@example.com:Calendar\/personal" 

Re: [SOGo] sogo-tool crashes after sieve login

[Francis Lachapelle]

Hi Kees

> On Jun 28, 2022, at 15:33, Kees van Vloten  wrote:
> 
> I am trying to set mail forwarding with sogo-tool:
> 
> sogo-tool user-preferences set defaults test2 -p /etc/sogo/sieve.creds 
> Forward -f /tmp/fwd
> <0x0x5638face3ec0[SOGoCache]> Cache cleanup interval set every 300.00 
> seconds
> <0x0x5638face3ec0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
> S[0x5638fafb21a0]: "IMPLEMENTATION" "Dovecot"
> S[0x5638fafb21a0]: "SIEVE" "fileinto reject envelope encoded-character 
> vacation subaddress comparator-i;ascii-numeric relational regex imap4flags 
> copy include variables body enotify environment mailbox date index ihave 
> duplicate mime foreverypart extracttext vacation-seconds spamtest imapflags 
> notify imapsieve vnd.dovecot.imapsieve"
> S[0x5638fafb21a0]: "NOTIFY" "mailto"
> S[0x5638fafb21a0]: "SASL" "GSSAPI GSS-SPNEGO PLAIN"
> S[0x5638fafb21a0]: "STARTTLS"
> S[0x5638fafb21a0]: "VERSION" "1.0"
> S[0x5638fafb21a0]: OK "Dovecot ready."
> C: AUTHENTICATE "PLAIN" {%d+}
> LOGIN:PASSWORD
> 
> S[0x5638fafb21a0]: OK "Logged in."
> C: LISTSCRIPTS
> sogo-tool: Uncaught exception NSInvalidArgumentException, reason: 
> NGImap4Client(instance) does not recognize authenticate:authname:password:

Make sure you're using the latest version of libsope-mime.

> The login seems to succeed (a manual test with telnet confirms that) but then 
> Sogo suddenly crashes.
> 
> When I set mail forwarding from the browser it works fine.
> 
> I am using Sogo 5.7.0 on Debian Bullseye.
> 
> How can I fix this issue?
> Or what would be a good approach to debug it?
> 
> - Kees
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool crashes after sieve login

[Kees van Vloten]

Hi Francis,

Op 28-06-2022 om 21:57 schreef Francis Lachapelle (flachape...@inverse.ca):

Hi Kees


On Jun 28, 2022, at 15:33, Kees van Vloten  wrote:

I am trying to set mail forwarding with sogo-tool:

sogo-tool user-preferences set defaults test2 -p /etc/sogo/sieve.creds Forward 
-f /tmp/fwd
<0x0x5638face3ec0[SOGoCache]> Cache cleanup interval set every 300.00 
seconds
<0x0x5638face3ec0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
S[0x5638fafb21a0]: "IMPLEMENTATION" "Dovecot"
S[0x5638fafb21a0]: "SIEVE" "fileinto reject envelope encoded-character vacation 
subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body 
enotify environment mailbox date index ihave duplicate mime foreverypart extracttext 
vacation-seconds spamtest imapflags notify imapsieve vnd.dovecot.imapsieve"
S[0x5638fafb21a0]: "NOTIFY" "mailto"
S[0x5638fafb21a0]: "SASL" "GSSAPI GSS-SPNEGO PLAIN"
S[0x5638fafb21a0]: "STARTTLS"
S[0x5638fafb21a0]: "VERSION" "1.0"
S[0x5638fafb21a0]: OK "Dovecot ready."
C: AUTHENTICATE "PLAIN" {%d+}
LOGIN:PASSWORD

S[0x5638fafb21a0]: OK "Logged in."
C: LISTSCRIPTS
sogo-tool: Uncaught exception NSInvalidArgumentException, reason: 
NGImap4Client(instance) does not recognize authenticate:authname:password:

Make sure you're using the latest version of libsope-mime.



dpkg -l | grep sope-mime
ii  libsope-mime4.9 4.9.r1664  amd64    SOPE 
libraries for MIME processin


There is an interesting thing with this. The version-number of the 
package has not changed since december 2021 (when I compiled 5.3.0), so 
it did not get updated at any time.
However when I look at build results of 5.7.0, all sope components are 
still at version 4.9.r1664 but the binaries are not exactly identical to 
those built with 5.3.0.


At one hand I would not surprise me if that is causing issues, but on 
the hand the versions are the same so there is no way Debian is going to 
upgrade anything. And also an unchanged version-number should indicate 
identical code. What is going on?


And even more: what would be right thing to do?




The login seems to succeed (a manual test with telnet confirms that) but then 
Sogo suddenly crashes.

When I set mail forwarding from the browser it works fine.

I am using Sogo 5.7.0 on Debian Bullseye.

How can I fix this issue?
Or what would be a good approach to debug it?

- Kees

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

Re: [SOGo] sogo-tool crashes after sieve login

[Kees van Vloten]

Op 28-06-2022 om 21:57 schreef Francis Lachapelle (flachape...@inverse.ca):

Hi Kees


On Jun 28, 2022, at 15:33, Kees van Vloten  wrote:

I am trying to set mail forwarding with sogo-tool:

sogo-tool user-preferences set defaults test2 -p /etc/sogo/sieve.creds Forward 
-f /tmp/fwd
<0x0x5638face3ec0[SOGoCache]> Cache cleanup interval set every 300.00 
seconds
<0x0x5638face3ec0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
S[0x5638fafb21a0]: "IMPLEMENTATION" "Dovecot"
S[0x5638fafb21a0]: "SIEVE" "fileinto reject envelope encoded-character vacation 
subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body 
enotify environment mailbox date index ihave duplicate mime foreverypart extracttext 
vacation-seconds spamtest imapflags notify imapsieve vnd.dovecot.imapsieve"
S[0x5638fafb21a0]: "NOTIFY" "mailto"
S[0x5638fafb21a0]: "SASL" "GSSAPI GSS-SPNEGO PLAIN"
S[0x5638fafb21a0]: "STARTTLS"
S[0x5638fafb21a0]: "VERSION" "1.0"
S[0x5638fafb21a0]: OK "Dovecot ready."
C: AUTHENTICATE "PLAIN" {%d+}
LOGIN:PASSWORD

S[0x5638fafb21a0]: OK "Logged in."
C: LISTSCRIPTS
sogo-tool: Uncaught exception NSInvalidArgumentException, reason: 
NGImap4Client(instance) does not recognize authenticate:authname:password:

Make sure you're using the latest version of libsope-mime.

Thanks Francis, creating new sope* packages solved the issue



The login seems to succeed (a manual test with telnet confirms that) but then 
Sogo suddenly crashes.

When I set mail forwarding from the browser it works fine.

I am using Sogo 5.7.0 on Debian Bullseye.

How can I fix this issue?
Or what would be a good approach to debug it?

- Kees

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

Re: [SOGo] sogo-tool check-doubles doesn't works

[Alessio Fattorini]

Il 02/03/2011 18:04, xbgmsharp ha scritto:


I found the same question but with no answer or i am not abble to use the 
archive search of the
mailinglist.


you're right. No answer


--
Alessio Fattorini (alessio.fattor...@nethesis.it)

nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - i...@nethesis.it
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool check-doubles doesn't works

[Ludovic Marcotte]

On 11-03-02 12:04 PM, xbgmsharp wrote:

Hello,

I have a lot of duplicated contacts in Sogo due to a bug in an old 
version of Sogo TB extensions. I have update them.

Now i would like to clean up the duplicate contact.

Looks like sogo-tool have an option to do it but i am unable to use it.
It is not on multi domain system.

As sogo user:
sogo@sogo:~$ /usr/sbin/sogo-tool check-doubles
The warning limit for folder records is set at 1000

sogo@sogo:~$ /usr/sbin/sogo-tool remove-doubles
Usage: remove-doubles USER FOLDER

 USER   the owner of the contact folder
 FOLDER the id of the folder to clean up

How about something like:

/usr/sbin/sogo-tool remove-doubles lmarcotte personal

? It'll remove dupes in my "personal" address book.

sogo=# select * from sogo_folder_info where c_path2 = 'lmarcotte' and 
c_path4 = 'personal' and c_path3 = 'Contacts';
 c_folder_id |   c_path   | c_path1 |  c_path2  
| c_path3  | c_path4  | c_foldername  |  
c_location  |  
c_quick_location  |  
c_acl_location  | c_folder_type

-++-+---+--+--+---+--++--+---
   3 | /Users/lmarcotte/Contacts/personal | Users   | lmarcotte 
| Contacts | personal | Personal Address Book | 
http://sogo:sogo@127.0.0.1:5432/sogo/sogolmarcott0035eedfc6f | 
http://sogo:sogo@127.0.0.1:5432/sogo/sogolmarcott0035eedfc6f_quick | 
http://sogo:sogo@127.0.0.1:5432/sogo/sogolmarcott0035eedfc6f_acl | Contact

(1 row)

sogo=#


I found the same question but with no answer or i am not abble to use 
the archive search of the mailinglist.


https://inverse.ca/sogo/lists/arc/users/2011-02/msg00181.html

The *warning* can be ignored.

--
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] sogo-tool check-doubles doesn't works

[Alessio Fattorini]

Il 02/03/2011 21:56, Ludovic Marcotte ha scritto:


? It'll remove dupes in my "personal" address book.


Yes, remove-dobles works, check-doubles doesn't.


https://inverse.ca/sogo/lists/arc/users/2011-02/msg00181.html

The *warning* can be ignored.



Ok, but the output of check-doubles? Where is it?

--
Alessio Fattorini (alessio.fattor...@nethesis.it)

nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - i...@nethesis.it
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool check-doubles doesn't works

[xbgmsharp]

I wish i could check-doubles before removing them.
Even if i can ignored the warning, it will be nice to get some output  
show which entry it is checking.


The command is pretty fast if you look at the number of duplicated  
contacts i have in the DB.


I have create a bug report.
http://www.sogo.nu/bugs/view.php?id=1164

Ludovic Marcotte  a écrit :


On 11-03-02 12:04 PM, xbgmsharp wrote:

Hello,

I have a lot of duplicated contacts in Sogo due to a bug in an old   
version of Sogo TB extensions. I have update them.

Now i would like to clean up the duplicate contact.

Looks like sogo-tool have an option to do it but i am unable to use it.
It is not on multi domain system.

As sogo user:
sogo@sogo:~$ /usr/sbin/sogo-tool check-doubles
The warning limit for folder records is set at 1000

sogo@sogo:~$ /usr/sbin/sogo-tool remove-doubles
Usage: remove-doubles USER FOLDER

USER   the owner of the contact folder
FOLDER the id of the folder to clean up

How about something like:

/usr/sbin/sogo-tool remove-doubles lmarcotte personal

? It'll remove dupes in my "personal" address book.

sogo=# select * from sogo_folder_info where c_path2 = 'lmarcotte' and
c_path4 = 'personal' and c_path3 = 'Contacts';
 c_folder_id |   c_path   | c_path1 |  c_path2
| c_path3  | c_path4  | c_foldername  |
 c_location  |
c_quick_location  |
c_acl_location  | c_folder_type
-++-+---+--+--+---+--++--+---
   3 | /Users/lmarcotte/Contacts/personal | Users   | lmarcotte
| Contacts | personal | Personal Address Book |
http://sogo:sogo@127.0.0.1:5432/sogo/sogolmarcott0035eedfc6f |
http://sogo:sogo@127.0.0.1:5432/sogo/sogolmarcott0035eedfc6f_quick |
http://sogo:sogo@127.0.0.1:5432/sogo/sogolmarcott0035eedfc6f_acl |
Contact
(1 row)

sogo=#


I found the same question but with no answer or i am not abble to   
use the archive search of the mailinglist.


https://inverse.ca/sogo/lists/arc/users/2011-02/msg00181.html

The *warning* can be ignored.

--
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


--
Thanks for using xbgm# / Devmon / BBwin.
http://xbgm.sourceforge.net/
http://devmon.sourceforge.net/
http://bbwin.sourceforge.net/
Please feedback.
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool not included in rpm package

[Francis Lachapelle]

Hello Marc

On 2012-04-06, at 7:10 AM, Marc Rechté wrote:

> I wondered why is sogo-tool not included in the rpm package ?

sogo-tool has its own rpm package.

yum install sogo-tool

:)

Francis

--
flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca
Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)

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

Re: [SOGo] sogo-tool not included in rpm package

[Marc Rechté]

Thank you Francis.

Le 06/04/2012 14:33, Francis Lachapelle a écrit :

Hello Marc

On 2012-04-06, at 7:10 AM, Marc Rechté wrote:


I wondered why is sogo-tool not included in the rpm package ?

sogo-tool has its own rpm package.

yum install sogo-tool

:)

Francis

--
flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca
Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence 
(http://packetfence.org)




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

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

[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'
> 
> 2

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

[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

Re: [SOGo] sogo-tool adds CTRL-M to events?

[Wolfgang Sourdeau]

Is that on purpose? It looks strange to see those DOS CONTROL characters on a
UNIX system.


That's normal. It's part of the versit standard.

--
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

Re: [SOGo] Sogo-tool mentions error that isnt there ?

[Ludovic Marcotte]

On 05/07/11 12:58, Julian Robbins wrote:
But oddly my OCSFolderInfoURL is configured correctly. Also why does 
it mention [GCSFolderManager defaultFolderManager and then mentions 
OCSFolderInfoURL ??


Also this error never appears in the main sogo log when running either 
 

You have to run sogo-tool as the "sogo" user.

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] Sogo-tool mentions error that isnt there ?

[Julian Robbins]

On 05/07/11 17:59, Ludovic Marcotte wrote:

On 05/07/11 12:58, Julian Robbins wrote:
But oddly my OCSFolderInfoURL is configured correctly. Also why does 
it mention [GCSFolderManager defaultFolderManager and then mentions 
OCSFolderInfoURL ??


Also this error never appears in the main sogo log when running 
either  

You have to run sogo-tool as the "sogo" user.

Regards,


Thanks, yes it works now 

--
Kind Regards,

Julian Robbins


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

Re: [SOGo] Sogo-tool - standard in must be tty

[Pascal Bourdais]

Le Wed, 06 Jul 2011 09:29:05 +0200,
Philipp Strobl  a écrit :

Hi,

> 
> i have a script that execute the sogo-backup tool. For some reason it 
> exits with an error: "standard in must be a tty" ?
> 
> What does this mean ?
> The backup seems to be OK.
> 
> It is not possible to run the sogo-tool from script ?

I run it in a script with
  sudo -u sogo /usr/sbin/sogo-tool  backup /home/sauve ALL
and it works like a charm with the good config of sudo.

I think su -u ... redirects tty and that's why you have this error.

An other way is to run the script as user sogo, but you have to change
the rights of /home/sogo/Backup.

<...>

Regards,

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

Re: [SOGo] sogo-tool rename-user erases all acl's

[Christian Mack]

Hi

When upgrading to Version 4. did you switch from 3 tables per user to 9
tables combined layout?

This error messeges seem to indicate, you did partly.
If you did, you should do it completely first.


Kind regards,
Christian Mack

Am 25.05.20 um 19:31 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
> Hi,
> 
> we recently upgraded our sogo installation from version 2 to version
> 4.3.0 on a debian 10.
> 
> Since the migration worked fine I had a colleague who married and got a
> new surname.
> 
> So I changed all attributes in ldap and used the "sogo-tool rename-user"
> to give him access to his calendar and tasks.
> 
> First thing I noticed was that there were like hundreds of errors
> because the database structure changed and there were no more personal
> tables for each user.
> 
> Here is an example for one of these errors:
> 
> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>  SQL: UPDATE 
> sogosomeposix0014ba520e0_acl SET c_uid = 'newposix' WHERE c_uid = 'oldposix';
> 
> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>ERROR: Table 
> 'sogodb.sogosomeposix0014ba520e0_acl' doesn't exist 
> 
> Since these tables didn't exist anymore I wasn't worried and everything
> looked fine.
> 
> Today I got lots of complaints that people couldn't access other
> calendars so i checked the database and saw that all the entries in
> sogo_acl where wrong.
> 
> Here is a short cutout:
> 
> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someposix   
>  | ConfidentialDAndTViewer |
> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someotherposix  
>  | PrivateDAndTViewer  |
> 
> All 5600 lines in this table looked exactly like this so I took the
> table from my backup and changed the according lines manually since
> everything else lokked ok.
> 
> So I cloned my Setup to see where things went wrong and found the line:
> 
> root@myserver:~# sogo-tool -v rename-user oldposix newposix
> 2020-05-25 18:47:28.915 sogo-tool[21871:21871] MySQL4 connection established 
> 0x0x563777a14170
> ...
> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>  SQL: SELECT 
> c_uid, c_object, c_role FROM sogo_acl WHERE c_folder_id = 424 AND (c_object 
> LIKE '/oldposix/%');
> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>query has 
> results, entering fetch-mode.
> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>  SQL: UPDATE 
> sogo_acl SET c_object = '/newposix/Calendar/5A00-59D22100-1-70F14480';
> ... 
> 
> followed by the errors mentioned above
> 
> Obviously somewhere in this script the update-query is missing the
> where-clause which is used in the query before.
> 
> Is this a known bug and we're just on an old version? Or is this a new
> bug and nobody noticed yet?
> 
> kind regards
> 
> Philipp
> 


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] sogo-tool rename-user erases all acl's

[Philipp Kuehne]

Hi,

We did install version 4 with the 9-table layout. However we did not do
an upgrade, we exported the data with sogo-tool on the SOGo 2 server and
imported with sogo-tool on the SOGo 4 server.

So seems like we missed something.

Does anyone have an idea how to solve that issue?

Kind regards,

Philipp

Am 26.05.20 um 09:15 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Hi
>
> When upgrading to Version 4. did you switch from 3 tables per user to 9
> tables combined layout?
>
> This error messeges seem to indicate, you did partly.
> If you did, you should do it completely first.
>
>
> Kind regards,
> Christian Mack
>
> Am 25.05.20 um 19:31 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
>> Hi,
>>
>> we recently upgraded our sogo installation from version 2 to version
>> 4.3.0 on a debian 10.
>>
>> Since the migration worked fine I had a colleague who married and got a
>> new surname.
>>
>> So I changed all attributes in ldap and used the "sogo-tool rename-user"
>> to give him access to his calendar and tasks.
>>
>> First thing I noticed was that there were like hundreds of errors
>> because the database structure changed and there were no more personal
>> tables for each user.
>>
>> Here is an example for one of these errors:
>>
>> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>>  SQL: UPDATE 
>> sogosomeposix0014ba520e0_acl SET c_uid = 'newposix' WHERE c_uid = 'oldposix';
>>
>> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>>ERROR: Table 
>> 'sogodb.sogosomeposix0014ba520e0_acl' doesn't exist 
>>
>> Since these tables didn't exist anymore I wasn't worried and everything
>> looked fine.
>>
>> Today I got lots of complaints that people couldn't access other
>> calendars so i checked the database and saw that all the entries in
>> sogo_acl where wrong.
>>
>> Here is a short cutout:
>>
>> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someposix  
>>   | ConfidentialDAndTViewer |
>> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someotherposix 
>>   | PrivateDAndTViewer  |
>>
>> All 5600 lines in this table looked exactly like this so I took the
>> table from my backup and changed the according lines manually since
>> everything else lokked ok.
>>
>> So I cloned my Setup to see where things went wrong and found the line:
>>
>> root@myserver:~# sogo-tool -v rename-user oldposix newposix
>> 2020-05-25 18:47:28.915 sogo-tool[21871:21871] MySQL4 connection established 
>> 0x0x563777a14170
>> ...
>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>  SQL: SELECT 
>> c_uid, c_object, c_role FROM sogo_acl WHERE c_folder_id = 424 AND (c_object 
>> LIKE '/oldposix/%');
>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>query has 
>> results, entering fetch-mode.
>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>  SQL: UPDATE 
>> sogo_acl SET c_object = '/newposix/Calendar/5A00-59D22100-1-70F14480';
>> ... 
>>
>> followed by the errors mentioned above
>>
>> Obviously somewhere in this script the update-query is missing the
>> where-clause which is used in the query before.
>>
>> Is this a known bug and we're just on an old version? Or is this a new
>> bug and nobody noticed yet?
>>
>> kind regards
>>
>> Philipp
>>
>
-- 
___

Philipp Kühne | IT Administrator


indurad GmbH| the industrial radar company

Belvedereallee 5 | 52070 Aachen | Germany
phone: +49 241 538070-103 | front desk: +49 241 538070-0
email: philipp.kue...@indurad.com  |
web: www.indurad.com 


signature.asc
Description: OpenPGP digital signature

Re: [SOGo] sogo-tool rename-user erases all acl's

[Christian Mack]

Hello

Check your configuration in sogo.conf.
You need the following new settings for 9 table layout:
OCSStoreURL
OCSAclURL
OCSCacheFolderURL

I assume OCSAclURL is missing.


Kind regards,
Christian Mack

Am 26.05.20 um 14:46 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
> Hi,
> 
> We did install version 4 with the 9-table layout. However we did not do
> an upgrade, we exported the data with sogo-tool on the SOGo 2 server and
> imported with sogo-tool on the SOGo 4 server.
> 
> So seems like we missed something.
> 
> Does anyone have an idea how to solve that issue?
> 
> Kind regards,
> 
> Philipp
> 
> Am 26.05.20 um 09:15 schrieb Christian Mack
> (christian.m...@uni-konstanz.de):
>> Hi
>>
>> When upgrading to Version 4. did you switch from 3 tables per user to 9
>> tables combined layout?
>>
>> This error messeges seem to indicate, you did partly.
>> If you did, you should do it completely first.
>>
>>
>> Kind regards,
>> Christian Mack
>>
>> Am 25.05.20 um 19:31 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
>>> Hi,
>>>
>>> we recently upgraded our sogo installation from version 2 to version
>>> 4.3.0 on a debian 10.
>>>
>>> Since the migration worked fine I had a colleague who married and got a
>>> new surname.
>>>
>>> So I changed all attributes in ldap and used the "sogo-tool rename-user"
>>> to give him access to his calendar and tasks.
>>>
>>> First thing I noticed was that there were like hundreds of errors
>>> because the database structure changed and there were no more personal
>>> tables for each user.
>>>
>>> Here is an example for one of these errors:
>>>
>>> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>>>  SQL: UPDATE 
>>> sogosomeposix0014ba520e0_acl SET c_uid = 'newposix' WHERE c_uid = 
>>> 'oldposix';
>>>
>>> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>>>ERROR: 
>>> Table 'sogodb.sogosomeposix0014ba520e0_acl' doesn't exist 
>>>
>>> Since these tables didn't exist anymore I wasn't worried and everything
>>> looked fine.
>>>
>>> Today I got lots of complaints that people couldn't access other
>>> calendars so i checked the database and saw that all the entries in
>>> sogo_acl where wrong.
>>>
>>> Here is a short cutout:
>>>
>>> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someposix 
>>>    | ConfidentialDAndTViewer |
>>> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | 
>>> someotherposix   | PrivateDAndTViewer  |
>>>
>>> All 5600 lines in this table looked exactly like this so I took the
>>> table from my backup and changed the according lines manually since
>>> everything else lokked ok.
>>>
>>> So I cloned my Setup to see where things went wrong and found the line:
>>>
>>> root@myserver:~# sogo-tool -v rename-user oldposix newposix
>>> 2020-05-25 18:47:28.915 sogo-tool[21871:21871] MySQL4 connection 
>>> established 0x0x563777a14170
>>> ...
>>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>>  SQL: SELECT 
>>> c_uid, c_object, c_role FROM sogo_acl WHERE c_folder_id = 424 AND (c_object 
>>> LIKE '/oldposix/%');
>>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>>query has 
>>> results, entering fetch-mode.
>>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>>  SQL: UPDATE 
>>> sogo_acl SET c_object = '/newposix/Calendar/5A00-59D22100-1-70F14480';
>>> ... 
>>>
>>> followed by the errors mentioned above
>>>
>>> Obviously somewhere in this script the update-query is missing the
>>> where-clause which is used in the query before.
>>>
>>> Is this a known bug and we're just on an old version? Or is this a new
>>> bug and nobody noticed yet?
>>>
>>> kind regards
>>>
>>> Philipp
>>>
>>


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] sogo-tool rename-user erases all acl's

[Philipp Kuehne]

Hi Christian,

we have all these settings in our config.

If you want I can anonymize the data and send it to you so you can have
a look!

Thanks in advance.

Kind regards

Philipp

Am 26.05.20 um 16:18 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Hello
>
> Check your configuration in sogo.conf.
> You need the following new settings for 9 table layout:
> OCSStoreURL
> OCSAclURL
> OCSCacheFolderURL
>
> I assume OCSAclURL is missing.
>
>
> Kind regards,
> Christian Mack
>
> Am 26.05.20 um 14:46 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
>> Hi,
>>
>> We did install version 4 with the 9-table layout. However we did not do
>> an upgrade, we exported the data with sogo-tool on the SOGo 2 server and
>> imported with sogo-tool on the SOGo 4 server.
>>
>> So seems like we missed something.
>>
>> Does anyone have an idea how to solve that issue?
>>
>> Kind regards,
>>
>> Philipp
>>
>> Am 26.05.20 um 09:15 schrieb Christian Mack
>> (christian.m...@uni-konstanz.de):
>>> Hi
>>>
>>> When upgrading to Version 4. did you switch from 3 tables per user to 9
>>> tables combined layout?
>>>
>>> This error messeges seem to indicate, you did partly.
>>> If you did, you should do it completely first.
>>>
>>>
>>> Kind regards,
>>> Christian Mack
>>>
>>> Am 25.05.20 um 19:31 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
 Hi,

 we recently upgraded our sogo installation from version 2 to version
 4.3.0 on a debian 10.

 Since the migration worked fine I had a colleague who married and got a
 new surname.

 So I changed all attributes in ldap and used the "sogo-tool rename-user"
 to give him access to his calendar and tasks.

 First thing I noticed was that there were like hundreds of errors
 because the database structure changed and there were no more personal
 tables for each user.

 Here is an example for one of these errors:

 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
  SQL: UPDATE 
 sogosomeposix0014ba520e0_acl SET c_uid = 'newposix' WHERE c_uid = 
 'oldposix';

 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
ERROR: 
 Table 'sogodb.sogosomeposix0014ba520e0_acl' doesn't exist 

 Since these tables didn't exist anymore I wasn't worried and everything
 looked fine.

 Today I got lots of complaints that people couldn't access other
 calendars so i checked the database and saw that all the entries in
 sogo_acl where wrong.

 Here is a short cutout:

 | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someposix    
     | ConfidentialDAndTViewer |
 | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | 
 someotherposix   | PrivateDAndTViewer  |

 All 5600 lines in this table looked exactly like this so I took the
 table from my backup and changed the according lines manually since
 everything else lokked ok.

 So I cloned my Setup to see where things went wrong and found the line:

 root@myserver:~# sogo-tool -v rename-user oldposix newposix
 2020-05-25 18:47:28.915 sogo-tool[21871:21871] MySQL4 connection 
 established 0x0x563777a14170
 ...
 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
  SQL: SELECT 
 c_uid, c_object, c_role FROM sogo_acl WHERE c_folder_id = 424 AND 
 (c_object LIKE '/oldposix/%');
 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
query has 
 results, entering fetch-mode.
 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
  SQL: UPDATE 
 sogo_acl SET c_object = '/newposix/Calendar/5A00-59D22100-1-70F14480';
 ... 

 followed by the errors mentioned above

 Obviously somewhere in this script the update-query is missing the
 where-clause which is used in the query before.

 Is this a known bug and we're just on an old version? Or is this a new
 bug and nobody noticed yet?

 kind regards

 Philipp

>
-- 
___

Philipp Kühne | IT Administrator


indurad GmbH| the industrial radar company

Belvedereallee 5 | 52070 Aachen | Germany
phone: +49 241 538070-103 | front desk: +49 241 538070-0
email: philipp.kue...@indurad.com  |
web: www.indurad.com 


signature.asc
Description: OpenPGP digital signature

Re: [SOGo] sogo-tool does not backup contacts and agenda?

[Igor Vitorac]

Most probably you have tried the below command as root. Try it as sogo 
user, i.e. the user which is used for running sogo.


Regards,
Igor



John Bieling wrote, On 18/01/2013 21:49:

HI,

I just tried to backup my users using sogo-tool. The created backup 
files do not contain any contact or agenda data, is this as expected 
or did I do something wrong?


I called

sogo-tool backup test_backup ALL

If this is as expected, how do I backup the contacts of my users?

Thanks
John


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

Re: [SOGo] sogo-tool command to clean up contact format

[Stephen Ingram]

On Tue, Jan 17, 2017 at 3:21 PM, Stephen Ingram  wrote:

> I've had several reports from a user who reports contacts not properly
> syncing with iPhone and/or Mac. Since every address book seems to create
> entries differently, and many times in an incompatible fashion, I'm
> wondering if perhaps the format is incorrect. Is there a sub-command for
> sogo-tool that can clean up everything, or perhaps this happens with a
> backup, erase and restore?
>

Looking at this user's access attempts in the logs I see some contact adds
with HTTP 412 responses. I'm not sure what this means within the context of
SOGo, but I would think it can't be good.

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

Re: [SOGo] sogo-tool check-doubles don't use correct mysql password

[Mohit Chawla]

Hi,

On Fri, Nov 12, 2010 at 4:30 PM, Alessio Fattorini <
alessio.fattor...@nethesis.it> wrote:

> Why it use password "sogo" for user "sogo" ?
>
> My password is set above (last note) and it's different. Where sogo-tool
> read password?
>

I don't think SOGo does that. I also have a different password for the sogo
user, and I am not getting any errors.
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool check-doubles don't use correct mysql password

[Alessio Fattorini]

Il 12/11/2010 12:34, Mohit Chawla ha scritto:

Hi,

On Fri, Nov 12, 2010 at 4:30 PM, Alessio Fattorini 
mailto:alessio.fattor...@nethesis.it>> wrote:

Why it use password "sogo" for user "sogo" ?

My password is set above (last note) and it's different. Where sogo-tool 
read password?


I don't think SOGo does that. I also have a different password for the sogo 
user, and I am not
getting any errors.


Thanks but i don't speak about sogo user in passwd, but sogo user in mysql users table. What type of 
password have sogouser into this table?


Fails this command:
mysql://sogo:s...@127.0.0.1:3306/sogo/sogocristian001

sogo:sogo means user:pass, this credential are used for connect tu mysql. They 
are wrong in my case.

--
Alessio Fattorini (alessio.fattor...@nethesis.it)

nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - i...@nethesis.it
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool check-doubles don't use correct mysql password

[Ludovic Marcotte]

On 10-11-12 7:07 AM, Alessio Fattorini wrote:
Thanks but i don't speak about sogo user in passwd, but sogo user in 
mysql users table. What type of password have sogouser into this table?


Fails this command:
mysql://sogo:s...@127.0.0.1:3306/sogo/sogocristian001

sogo:sogo means user:pass, this credential are used for connect tu 
mysql. They are wrong in my case.
Look at the entries in your sogo_folder_info vs. your database 
connection details in your .GNUstepDefaults. sogo-tool will use what's 
in sogo_folder_info to retrieve data (ie., connect remotely if needed, 
etc.). You likely changed over time the username/password/hostname in 
your .GNUstepDefaults and didn't adjust your sogo_folder_info appropriately.


Fix your sogo_folder_info or adjust your MySQL permission so what's 
specified in there will work.


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] sogo-tool check-doubles don't use correct mysql password

[Alessio Fattorini]

Il 12/11/2010 13:18, Ludovic Marcotte ha scritto:

On 10-11-12 7:07 AM, Alessio Fattorini wrote:

Thanks but i don't speak about sogo user in passwd, but sogo user in mysql 
users table. What type
of password have sogouser into this table?

Fails this command:
mysql://sogo:s...@127.0.0.1:3306/sogo/sogocristian001

sogo:sogo means user:pass, this credential are used for connect tu mysql. They 
are wrong in my case.

Look at the entries in your sogo_folder_info vs. your database connection 
details in your
.GNUstepDefaults. sogo-tool will use what's in sogo_folder_info to retrieve 
data (ie., connect
remotely if needed, etc.). You likely changed over time the 
username/password/hostname in your
.GNUstepDefaults and didn't adjust your sogo_folder_info appropriately.

Fix your sogo_folder_info or adjust your MySQL permission so what's specified 
in there will work.


You're right, as always ;-)
I don't understand why I have this dirty situation, only for this user :-|  Now 
I have clean this,

Remove doubles works! like this examples:
remove-doubles alessio C48738B0-B5B0-0001-A2E6-D62518001127
Removing 2 records...
Removed 2 records from 4.

Check doubles, don't check anything :-)
[s...@sogo root]$ sogo-tool check-doubles
The warning limit for folder records is set at 1000

Should I give attention to warning? I don't have folder more big then 1000 records... but I don't 
have results.


--
Alessio Fattorini (alessio.fattor...@nethesis.it)

nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - i...@nethesis.it
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool check-doubles don't use correct mysql password

[Mohit Chawla]

Hi,

On Fri, Nov 12, 2010 at 7:54 PM, Alessio Fattorini <
alessio.fattor...@nethesis.it> wrote:

> You're right, as always ;-)
> I don't understand why I have this dirty situation, only for this user :-|
>
>

So, what exactly had you done wrong ? Did you change the password for the
sogo user in the db, and forgot to change that in the .GNUStepDefaults ?
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Christian Mack]

Am 2014-06-17 16:24, schrieb Charles Marcus:
> I'm re-sending this as a new thread, since it is a new issue.
> 
> These occasional errors only started right after I updated to 2.2.5, and
> are only happening, once, or yesterday, twice per day. I saw not one of
> these in the prior 3 months of using SOGo.
> 
> connect_timeout is set to the default of 10 as it always has.
> 
> Here are the errors in question (these are all of them since we first
> started using SOGo in March, as you can see the first one was on 6/12,
> right after the 2.2.5 update):
> 
> 2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 104
> <0x0x236c140[GCSChannelManager]> could not open channel
>  for URL:
> mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
> <0x0x236c140[GCSChannelManager]>   will prevent opening of this channel
> 5 seconds after 2014-06-12 03:30:01 -0400
> 2014-06-12 03:30:15.531 sogo-tool[31674] Can't aquire channel
> 
> 2014-06-13 03:33:20.201 sogo-tool[6852] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 0
> <0x0x1d5f140[GCSChannelManager]> could not open channel
>  for URL:
> mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
> <0x0x1d5f140[GCSChannelManager]>   will prevent opening of this channel
> 5 seconds after 2014-06-13 03:33:01 -0400
> 2014-06-13 03:33:20.202 sogo-tool[6852] Can't aquire channel
> 
> 2014-06-14 11:09:19.303 sogo-tool[16644] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 0
> <0x0x18c2140[GCSChannelManager]> could not open channel
>  for URL:
> mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
> <0x0x18c2140[GCSChannelManager]>   will prevent opening of this channel
> 5 seconds after 2014-06-14 11:09:01 -0400
> 2014-06-14 11:09:19.304 sogo-tool[16644] Can't aquire channel
> 
> 2014-06-14 19:29:16.259 sogo-tool[4321] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 0
> <0x0x1ff4140[GCSChannelManager]> could not open channel
>  for URL:
> mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
> <0x0x1ff4140[GCSChannelManager]> will prevent opening of this channel 5
> seconds after 2014-06-14 19:29:01 -0400 2014-06-14 19:29:16.260
> sogo-tool[4321] Can't aquire channel
> 
> 2014-06-15 11:36:12.184 sogo-tool[11336] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 0
> <0x0x1534410[GCSChannelManager]> could not open channel
>  for URL:
> mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
> <0x0x1534410[GCSChannelManager]> will prevent opening of this channel 5
> seconds after 2014-06-15 11:36:02 -0400 2014-06-15 11:36:12.185
> sogo-tool[11336] Can't aquire channel
> 
> 2014-06-16 19:29:17.300 sogo-tool[22163] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 0
> <0x0x20a4410[GCSChannelManager]> could not open channel
>  for URL:
> mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
> <0x0x20a4410[GCSChannelManager]>   will prevent opening of this channel
> 5 seconds after 2014-06-16 19:29:01 -0400 2014-06-16 19:29:17.301
> sogo-tool[22163] Can't aquire channel
> 
> 2014-06-17 03:08:22.791 sogo-tool[24540] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 0
> <0x0x282b410[GCSChannelManager]> could not open channel
>  for URL:
> mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
> <0x0x282b410[GCSChannelManager]> will prevent opening of this channel 5
> seconds after 2014-06-17 03:08:01 -0400 2014-06-17 03:08:22.792
> sogo-tool[24540] Can't aquire channel
> 
> 2014-06-17 03:32:14.985 sogo-tool[24652] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 104
> <0x0x172b410[GCSChannelManager]> could not open channel
>  for URL:
> mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
> <0x0x172b410[GCSChannelManager]> will prevent opening of this channel 5
> seconds after 2014-06-17 03:32:01 -0400 2014-06-17 03:32:14.988
> sogo-tool[24652] Can't aquire channel
> 
> Anyone have any ideas? Everything seems to be working fine, and like I
> said, they only happen once per day (except twice today)...
> 

We see more connections to the database since SOGo 2.2.4.

This error says, you lost a connection in mid transport of data and it
can not open a new one.
That is a really generic problem.
Perhaps your network is busy.
Perha

Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Tanstaafl]

Thanks for the reply Christian - more inline below...

On 6/18/2014 4:09 AM, Christian Mack wrote:

Am 2014-06-17 16:24, schrieb Charles Marcus:

2014-06-17 03:32:14.985 sogo-tool[24652] ERROR: could not open MySQL4
connection to database 'sogo': Lost connection to MySQL server at
'reading authorization packet', system error: 104
<0x0x172b410[GCSChannelManager]> could not open channel
 for URL:
mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
<0x0x172b410[GCSChannelManager]> will prevent opening of this channel 5
seconds after 2014-06-17 03:32:01 -0400 2014-06-17 03:32:14.988
sogo-tool[24652] Can't aquire channel

Anyone have any ideas? Everything seems to be working fine, and like I
said, they only happen once per day (except twice today)...



We see more connections to the database since SOGo 2.2.4.


I'm curious, how many more? In other words, is it a lot (double or 
more)? Or just a little (10% increase, etc)...


Also - I'm curious what you and/or others who are using [my][postgre]sql 
or mariadb have set for


max_connections
max_user_connections

Are there any connection tuning (preferably sql related, but I imagine 
the number of connections SOGo requires is similar or the same 
regardless of what backend is used) recommendations for SOGo anywhere? 
Searching the install doc for 'connection' didn't reveal anything.



This error says, you lost a connection in mid transport of data and it
can not open a new one.
That is a really generic problem.
Perhaps your network is busy.


I doubt any of the above. First, the times these happen are outside 
normal business hours. If it had to do with a busy network, it would be 
happening during business hours.


My network is fairly small - 60 or so users - but, they are all using 
shared Calendars & Address Books (at least 3 of each, more in a few 
cases), so maybe I do need to tune the mysql connections.



Perhaps you run out of port numbers.


What do you mean 'run out of port numbers'? This is connecting to 
mariadb over TCP on port 3306 - one port.



Perhaps you have not enough file descriptors.


My SOGo server is on a different box than my SQL server - so, do you 
mean file descriptors on the SOGo box or the SQL box? And wouldn't there 
be other symptoms? And more importantly, again, this happens at odd 
times - the first few times at about 3:00am or so, so when the load on 
the server is at its lowest.


But I'll investigate this further.

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

Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Charles Marcus]

On 6/18/2014 7:00 AM, Tanstaafl  wrote:
Also - I'm curious what you and/or others who are using 
[my][postgre]sql or mariadb have set for


max_connections
max_user_connections

Are there any connection tuning (preferably sql related, but I imagine 
the number of connections SOGo requires is similar or the same 
regardless of what backend is used) recommendations for SOGo anywhere? 
Searching the install doc for 'connection' didn't reveal anything. 


How about a more specific question for the SOGo devs.

How many connections does SOGo use for each user, and how are they counted?

For example, is it one connection per user? Per user per shared resource 
(calendar, address book)?


Thanks,


Charles Marcus
I.T. Director
Media Brokers International, Inc.
678.514.6224 | 678.514.6299 fax

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

Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Charles Marcus]

On 6/17/2014 10:24 AM, Charles Marcus  wrote:
2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 104 


I got a response on the MariaDB list claiming that the mysql4 protocol 
is extremely outdated and no longer supported by mariadb (or mysql5.5), 
so should not be used.


So... why is it trying to use the mysql4 protocol?


Charles

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

Re: [SOGo] sogo-tool 'lost connection' errors after update to SOGo 2.2.5

[Charles Marcus]

On 6/19/2014 8:37 AM, Charles Marcus  wrote:

On 6/17/2014 10:24 AM, Charles Marcus  wrote:
2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 104 


I got a response on the MariaDB list claiming that the mysql4 protocol 
is extremely outdated and no longer supported by mariadb (or 
mysql5.5), so should not be used.


So... why is it trying to use the mysql4 protocol? I was told that 
this is why it is failing.


Anyone?

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

Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Charles Marcus]

On 6/18/2014 4:17 PM, Charles Marcus  wrote:
How many connections does SOGo use for each user, and how are they 
counted?


For example, is it one connection per user? Per user per shared 
resource (calendar, address book)?


Would appreciate a response to this very simple question.

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

Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Ludovic Marcotte]

On 2014-06-25, 11:58 AM, Charles Marcus wrote:
How many connections does SOGo use for each user, and how are they 
counted?


For example, is it one connection per user? Per user per shared 
resource (calendar, address book)?


Would appreciate a response to this very simple question.
2 db connections per sogod processes will be used and most likely not 
more than 2 for sogo-tool either.


--
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] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Charles Marcus]

On 6/25/2014 3:13 PM, Ludovic Marcotte  wrote:

On 2014-06-25, 11:58 AM, Charles Marcus wrote:
How many connections does SOGo use for each user, and how are they 
counted?


2 db connections per sogod processes will be used and most likely not 
more than 2 for sogo-tool either.


Thanks Ludo - but can you elaborate on what is meant by 'sogod process' 
above, so I understand how to determine how many I need to allow for?


Is there one sogod process per user+IP? Or maybe per user+IP+resource?

For example, if a user has access to 3 calendars and 3 address books, 
and they access these from 2 different computers running 
thunderbird+Integrator+Connector, as well as their phone, do they use 3 
sogod process (6 db connections)? Or 18 (36 db connections)? Or 
something else?


Thanks very much...

Charles

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

Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Ludovic Marcotte]

On 2014-06-25, 3:23 PM, Charles Marcus wrote:
For example, if a user has access to 3 calendars and 3 address books, 
and they access these from 2 different computers running 
thunderbird+Integrator+Connector, as well as their phone, do they use 
3 sogod process (6 db connections)? Or 18 (36 db connections)? Or 
something else?

If you have 3 sogod processes, it'll use 6 connections.

--
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] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Tanstaafl]

On 6/25/2014 3:37 PM, Ludovic Marcotte  wrote:

On 2014-06-25, 3:23 PM, Charles Marcus wrote:

For example, if a user has access to 3 calendars and 3 address books,
and they access these from 2 different computers running
thunderbird+Integrator+Connector, as well as their phone, do they use
3 sogod process (6 db connections)? Or 18 (36 db connections)? Or
something else?



If you have 3 sogod processes, it'll use 6 connections.


But what determines how many sogod processes will be used?
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5

[Ludovic Marcotte]

On 2014-06-25, 4:21 PM, Tanstaafl wrote:
But what determines how many sogod processes will be used? 

http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf

Search for WOWorkersCount.

--
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] sogo-tool 'lost connection' errors after update to SOGo 2.2.5

[Charles Marcus]

Still trying to nail this down.

Question: for setups where the mysql server is on a different system 
(but still on the local network), what is the recommended setting in 
mysqld for 'skip-name-resolve'?


I'm thinking that, if 2.2.5 does use more connections as someone else 
said, maybe this problem is being caused by lots of client connections 
from outside from clients with poor reverse DNS resolution, because I do 
(and always have) seen lots of these kinds of warnings from phone based 
clients:


warning: hostname mobile-166-205-065-239.mycingular.net does not resolve 
to address 166.205.65.239: Name or service not known


So... maybe granting the required privileges to my sogo server's IP 
address, and enabling 'skip-name-resolve' on the mysql server would 
resolve this issue?


I have already tried increasing max_connections from 151 (which is what 
it was set to before) to 300, but am still having the occasional 'lost 
connection' error.


I need to get this resolved, because yesterday evening I actually had my 
mysql server start refusing connections from my sogo server with:


ERROR: could not open MySQL4 connection to database 'sogo': Host 
'sogo.media-brokers.com' is blocked because of many connection errors; 
unblock with 'mysqladmin flush-hosts'


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

Re: [SOGo] sogo-tool 'lost connection' errors after update to SOGo 2.2.5

[Tanstaafl]

On 7/2/2014 12:53 PM, Charles Marcus  wrote:

Question: for setups where the mysql server is on a different system
(but still on the local network), what is the recommended setting in
mysqld for 'skip-name-resolve'?

I'm thinking that, if 2.2.5 does use more connections as someone else
said, maybe this problem is being caused by lots of client connections
from outside from clients with poor reverse DNS resolution, because I do
(and always have) seen lots of these kinds of warnings from phone based
clients:


Never mind... forgot that the only client connecting to the mysql server 
is the sogo server, other clients connect to the sogo server...


I'd still like to know why this only started after the update to 2.2.5.

I guess its time to get help from someone who actually knows what they 
are doing to help troubleshoot this, since no one here has any ideas...

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

Re: [SOGo] sogo-tool: subscribe does not show the owner of the calendar

[Christian Mack]

Hello

There is no documentation on sogo-tool, except the help texts you get,
when not using complete sogo-tool commands.


For changing display name of calendars you have to get and set
user-preferences for key "Calendar" with sogo-tool.

1) Subscribe the calendar from owner-user to dest-user.
2) Get current calendar settings from dest-user:

/usr/sbin/sogo-tool user-preferences get settings dest-user Calendar|sed
-e 's/^\([^:]*\): \(.*\)$/{\"\1\": \2}/' |python3 -m json.tool
>dest-userCalendar.json

The sed command is only making the output valid JSON by adding a pair of
double quotes around the first key and a pair of curly braces around the
whole output.
The call of json.tool will pretty print the JSON, in order to make it
more readable.


3) Change display name of subscribed calendar in section
"FolderDisplayNames" in dest-userCalendar.json

e.g. change from
"owner-user:Calendar/personal": "Personal Calendar"
to
"owner-user:Calendar/personal": "Owner-user-Name Personal 
Calendar"


4) Set this change for dest-user:

/usr/sbin/sogo-tool user-preferences set settings dest-user Calendar -f
dest-userCalendar.json


With that approach you can set all preferences for a calendar like
sorting, colour and modification notifications etc.
Just see the dest-userCalendar.json for possible settings.


The ACLs (Access Control Lists) settable to calendars are equal to the
ones in webinterface.
You can set privileges based on the confidentiality levels "Public",
Confidential" and "Private".
Those privileges in ascending order are: "DAndTViewer", "Viewer",
"Responder", "Modifier".
Each privilege contains all lesser privileges.
This means privilege "Responder" also includes privileges "DAndTViewer"
and "Viewer".
So if you want to allow someone to read, respond and modify all existing
public events in a calendar, you have to give this someone the privilege
"PublicModifier" on that calendar.

There are also 2 privileges, which are not influenced by confidentiality
levels.
Those are "ObjectCreator" and "ObjectEraser".
With those someone can create new events and delete existing events.

That*s all ;-)
Hope this makes it a bit clearer.


Kind regards,
Christian Mack

Am 17.12.21 um 12:03 schrieb Claus (c3...@mail77.eu):
> 
> Hello,
> 
> I want to share a personal calendar of a user to somebody else. I can do
> this via the webinterface as superuser. However, I cannot add the
> subscription for somebody else. For this, I can use the sogo tool e.g.:
> 
> sudo -u sogo sogo-tool manage-acl subscribe owner-user Calendar/personal
> dest-user
> 
> I also tried with "AuthorizedSubscriber":
> sudo -u sogo sogo-tool manage-acl subscribe owner-user Calendar/personal
> dest-user AuthorizedSubscriber
> 
> The personal calendar of the owner shows up at the destination user,
> however it does not add the owner information. This means that the
> destination user has 2 calendars which are called the same "Personal
> Calendar".
> 
> If the destination user searches and subscribes the calendar of the
> owner via the webinterface, the shared calendar shows up correctly with
> name. (however, I want that for users the new calendar shows up
> automatically, most users will not know how to find those calendars,
> even with the webinterface).
> 
> Please find the example attached. (I'm using the latest 5.3 of 2 days ago).
> 
> Can somebody explain me if this can be fixed with more complete/correct
> sogo-tool parameters?
> 
> I would also like to know if there is more documentation (or more
> examples) available for sogo-tool? I didn't find anything, and I'm not
> sure I completely understand the different rights described here
> https://github.com/inverse-inc/sogo/blob/master/SoObjects/Appointments/product.plist
> or the general usage here
> https://github.com/inverse-inc/sogo/blob/master/Tools/SOGoToolManageACL.m
> Also via google I do find very little information on examples of other
> users using sogo-tool.
> 
> 
> thank you, and kind regards,


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] sogo-tool remove-changes: Is there a way to force a thunderbird address book reload?

[Luca Olivetti]

Al 08/08/2011 15:16, En/na Luca Olivetti ha escrit:

Summary:

the address book in thunderbird still shows the entries removed by
"sogo-tool remove-changes".


G, that's obviously "sogo-tool remove-doubles"

Bye
--
Luca Olivetti
Wetron Automation Technology http://www.wetron.es
Tel. +34 935883004 (Ext.133)  Fax +34 935883007
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool remove-changes: Is there a way to force a thunderbird address book reload?

[Luca Olivetti]

Al 08/08/2011 15:16, En/na Luca Olivetti ha escrit:

Summary:

the address book in thunderbird still shows the entries removed by
"sogo-tool remove-changes".


(remove-doubles)


So it seems that it only syncs changes (no way to re-read the whole
address book), but it doesn't pick up changes made by "sogo-tool
remove-doubles".

Removing the abook file gives me an empty address book (though changes
made in the web interface are synchronized).

The only way I found is to edit prefs.js to remove all references to the
address book, then it recreates and re-reads it.

Is there an easier/better way?


I guess there isn't a simple way to force a complete reload/sync of the 
address book?


Bye
--
Luca Olivetti
Wetron Automation Technology http://www.wetron.es
Tel. +34 935883004 (Ext.133)  Fax +34 935883007
--
users@sogo.nu
https://inverse.ca/sogo/lists