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

[SOGo] sogo-tool

2012-04-05 Thread Benjamin Pierrot


Hello,
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.

Thank you for your answers.

Benjamin Pierrot

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

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

[SOGo] sogo-tool

2012-12-23 Thread mayak-cq

hi all,

i have an issue with sogo-tool on centos-6 x64 ...

when i run sogo-tool as user sogo (or root), it crashes with:

[sogo@web ~]$ sogo-tool 
sogo-tool: NSThread.m:339: GSCurrentThread: Assertion `(id)0 != thr &&
"No main thread"' failed.
Aborted


thanks

M



[root@web cron.d]# yum list installed | grep sogo
gnustep-base.x86_64  1.23.0-1
@sogo-rhel6 
lasso.x86_64 2.3.6-1.centos6
@sogo-rhel6 
libffi.x86_643.0.10-1
@sogo-rhel6 
sogo.x86_64  2.0.3a-1.centos6
@sogo-rhel6 
sogo-ealarms-notify.x86_64   2.0.3a-1.centos6
@sogo-rhel6 
sogo-tool.x86_64 2.0.3a-1.centos6
@sogo-rhel6 
sope49-appserver.x86_64  4.9-20121206_1664.el6.1
@sogo-rhel6 
sope49-cards.x86_64  2.0.3a-1.centos6
@sogo-rhel6 
sope49-core.x86_64   4.9-20121206_1664.el6.1
@sogo-rhel6 
sope49-gdl1.x86_64   4.9-20121206_1664.el6.1
@sogo-rhel6 
sope49-gdl1-contentstore.x86_64  2.0.3a-1.centos6
@sogo-rhel6 
sope49-gdl1-mysql.x86_64 4.9-20121206_1664.el6.1
@sogo-rhel6 
sope49-ldap.x86_64   4.9-20121206_1664.el6.1
@sogo-rhel6 
sope49-mime.x86_64   4.9-20121206_1664.el6.1
@sogo-rhel6 
sope49-sbjson.x86_64 2.3.1-20121206_1664.el6.1
@sogo-rhel6 
sope49-xml.x86_644.9-20121206_1664.el6.1
@sogo-rhel6 

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

[SOGo] sogo-tool

2011-02-15 Thread Jakob Lenfers

Hey guys,

still having problems (<4d526f36.6000...@bigsss-bremen.de>), but I'm
trying to check if a clean installation can help. I always wanted away
from the rpms and since there are good debs out there now (thanks!) I
set up a sogo server on ubuntu 10.04. I copied the sogo config (and
changed it to work with mysql) and wanted to migrate the user data with
sogo-tool: sogo-tool backup migration/ ALL

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?

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

[SOGo] SOGO-Tool

2011-02-27 Thread 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?


Thanks,

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

[SOGo] sogo-tool

2011-12-19 Thread Dominique


Hi,

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.


Any hint welcome.

Thanks,

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

[SOGo] sogo-tool expire

2012-03-16 Thread Donny Brooks

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.

Re: [SOGo] sogo-tool

2012-04-05 Thread 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

2012-04-05 Thread 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

2012-04-05 Thread 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

2012-04-05 Thread 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

2012-10-04 Thread 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

2011-02-15 Thread 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

[SOGo] sogo-tool fix?

2011-02-16 Thread Patrick Ben Koetter

Good morning,

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

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

2011-02-21 Thread 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

2011-02-21 Thread 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

2011-02-27 Thread 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

2011-02-28 Thread 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

2011-03-08 Thread 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

[SOGo] sogo-tool script

2011-11-24 Thread 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

2011-12-19 Thread 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

[SOGo] sogo-tool restore

2017-03-28 Thread Hubert Gilch


Good morning,

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


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


Thank you.


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

Systemadministrator

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


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

Aufsichtsratsvorsitzender Michael Pelzer

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

[SOGo] sogo-tool rename

2017-04-11 Thread Paul van der Vlis

Hello list,

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?

With regards,
Paul van der Vlis



-- 
Paul van der Vlis Linux systeembeheer Groningen
https://www.vandervlis.nl/

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

[SOGo] sogo-tool remove-doubles

2012-03-22 Thread Donny Brooks

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?

--
Donny B.

Re: [SOGo] sogo-tool expire

2012-03-22 Thread 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.

[SOGo] sogo-tool sessions cleanup

2012-05-14 Thread Christian Rößner

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

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



smime.p7s
Description: S/MIME cryptographic signature

[SOGo] sogo-tool expire-autoreply

2012-08-03 Thread Khapare Joshi

I am starting to get following :

Jul 29 16:00:02 sogo-tool [29805]: <0x0x6f8c808[SOGoCache]> Cache cleanup
interval set every 60.00 seconds
Jul 29 16:00:02 sogo-tool [29805]: <0x0x6f8c808[SOGoCache]> Using host(s)
'127.0.0.1' as server(s)
2012-07-29 16:00:02.555 sogo-tool[29805] Sieve generation failure: Test
'all' used without any specified rule
2012-07-29 16:00:02.559 sogo-tool[29805] An error occured while removing
auto-reply of user sighsig

what does Sieve generation failure: Test 'all' used without any specified
rule actually mean ?

This was working until last week

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

[SOGo] sogo-tool and upgrades

2013-03-18 Thread MJ Ray

I've been a fairly happy test user for a while but now it's time to
replace my server, so I've installed the new sogo on the new server.
I am having trouble restoring my data from 1.3.18 to 2.0.4b - what
have I got wrong?

On the old host, I ran "sudo -u sogo sogo-tool backup /tmp/sogo/ ALL"
then I copied the folder to the new host and ran
"sudo -u sogo sogo-tool restore -p /tmp/sogo mjr" and
"sudo -u sogo sogo-tool restore -f ALL /tmp/sogo mjr"
just to restore my contacts and calendar.

There are a couple of lines like
2013-03-18 15:31:29.351 sogo-tool[13249] <0x0x18a7ce0[PostgreSQL72Channel]: 
connection=<0x0x18a83b0[PGConnection]:  connection=0x0x18a8560>>: message: 
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"sogomjr00271735693_pkey" for table "sogomjr00271735693"

with each one followed by lots of lines like
2013-03-18 15:31:29.318 sogo-tool[13249] restoring record '487'

However, when I log in to 2.0.4b, my calendar and contacts are empty.

I've had a bit of a search around the manual (not much in there on
upgrading, but I have changed the configuration as suggested), the
mailing list archives, the bug tracker and the wiki, but I doubt
whether I've discovered a bug.

Am I doing something obvious wrong?

Thanks for any tips,
-- 
MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op.
http://koha-community.org supporter, web and library systems developer.
In My Opinion Only: see http://mjr.towers.org.uk/email.html
Available for hire (including development) at http://www.software.coop/
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] sogo-tool list users

2015-09-23 Thread Márcio Merlone


Greetings!

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


Regards,

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

[SOGo] sogo-tool hangs forever

2015-10-08 Thread 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
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] sogo-tool remove-doubles

2016-01-20 Thread 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)

Thanks


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

Re: [SOGo] sogo-tool fix?

2011-02-16 Thread 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?

2011-02-16 Thread 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

[SOGo] sogo-tool - not avilable

2011-03-03 Thread Anil Thapa

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

[SOGo] sogo-tool: LDAPSource -dealloc

2011-04-18 Thread Patrick Ben Koetter

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?

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

[SOGo] sogo-tool with domain

2011-11-02 Thread Albert Shih

Hi all

I'm trying to making sogo-tool working with domain.

>From a fresh install of sogo-1.3.9 I'm trying to make a bakcup using

sogo-tool backup /tmp/sogo ALL

and it's not really working with multi-domain. 

I'got only one domain (I've got 3 domains) event I put

login@domain_name

at place of user I got some wrong backup, the ldif_record is not the good
one. (I've got three with same login account in the three domain). 

And I don't get the calendar backup in any situation. I've check in the
postgresql database and the event of my test calendar is correct.

Regards.

JAS


-- 
Albert SHIH
DIO batiment 15
Observatoire de Paris
5 Place Jules Janssen
92195 Meudon Cedex
Téléphone : 01 45 07 76 26/06 86 69 95 71
Heure local/Local time:
mer 2 nov 2011 15:42:23 CET
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool script

2011-11-25 Thread 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

2011-11-25 Thread 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

2011-11-25 Thread 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

[SOGo] sogo-tool backup errors

2016-03-30 Thread "Neil Romig"

I am getting the following errors when I run sogo-tool backup for a user:

<0x0x19b0c10[GCSFolder]> -[GCSFolder fetchAclWithSpecification:]: cannot
execute acl-fetch SQL 'SELECT c_uid, c_object, c_role FROM
sogonick00846ab1fc7_quick':  NAME:ExecutionFailed
REASON:Unknown column 'c_object' in 'field list'
<0x0x19b6190[GCSFolder]> -[GCSFolder fetchAclWithSpecification:]: cannot
execute acl-fetch SQL 'SELECT c_uid, c_object, c_role FROM
sogonick00751d0b209_quick':  NAME:ExecutionFailed
REASON:Unknown column 'c_uid' in 'field list'

Why would this happen, as these tables are created and maintained by SOGo. Do
I have a version mismatch or some other sofware conflict?

I am running SOGo version 2.2.9+git20141017-1 on Debian 8, using MySQL
database for user authentication and address/calendar storage.

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

Re: [SOGo] sogo-tool restore

2017-03-29 Thread Hubert Gilch

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


Mit freundlichem Gruß
i. A. Hubert Gilch

Systemadministrator

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


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

Aufsichtsratsvorsitzender Michael Pelzer

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


Good morning,

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


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


Thank you.


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

Systemadministrator

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


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

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


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

Re: [SOGo] sogo-tool rename

2017-04-11 Thread 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

2012-03-23 Thread 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

2012-05-15 Thread 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

2012-05-15 Thread 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

2012-05-15 Thread 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

[SOGo] sogo-tool sieve rule creation

2012-11-01 Thread Ron Yacketta

We are currently working on migrating from squirrel mail with Avelsieve 
to SOGo and have hit a stumble block.


One issue that we currently face is that users do not exist in SOGo and 
thus would need to be created prior to converting sieve scripts. Is it 
possible to create SOGo users using sogo-tool or another tool / script?


Regards,

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

[SOGo] sogo-tool check-doubles warning

2012-11-30 Thread Giovanni Bechis

Hi,
I am trying to check for double contacts for a user but if I run sogo-tool 
(with sogo user) I have this warning:
"The warning limit for folder records is set at 1000"
I try to increase the warning limit but nothing happens.
If I try to remove the double contacts sogo-tool remove 2 contacts; shouldn't 
it display my double contacts ?
Another question: is there a way do check for double entries in my calendar ?
At the moment I am using SOGo-2.0.2a.
 Cheers & Thanks
  Giovanni Bechis
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] sogo-tool expire-autoreply script

2013-02-06 Thread michael

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!

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

[SOGo] sogo-tool expire-autoreply script

2013-02-06 Thread michael

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!

 

Regards, Michael.

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

[SOGo] sogo-tool rename-user mess

2015-03-20 Thread Ian McMichael

I have recently changed the authentication of our SOGo instance 
(together with Dovecot and Postfix) to use e-mail addresses (in the form 
"u...@example.net") instead of account names (in the form "user").  
Sadly I made a mistake whilst doing this (which I have done before on 
other systems successfully).  I restarted the SOGo daemons and logged 
into a few accounts via webmail before running "sogo-tool rename-user" 
commands.


When I realised my mistake I shut everything down and immediately ran:

"sogo-tool rename-user user u...@example.net"

for each user on the system.

Sadly this was too late and I seem to have broken the settings for 
several users who now have duplicate entries for their calendar and 
contacts.


"sogo-tool user-preferences get settings usera Contacts" gives:

Contacts: {"FolderShowAlarms": 
{"us...@example.net:Contacts\/3E92-539F0080-1-5AAFDB80": 0, 
"userb:Contacts\/personal": 0, "us...@example.net:Contacts\/personal": 
0}, "FolderDisplayNames": {"us...@example.net:Contacts\/personal": 
"Userb Address Book (Userb )"}, "DragHandleVertical": 
"365", "SubscribedFolders": ["us...@example.net:Contacts\/personal"]}


I have checked the folder_info table in MySQL and only one version of 
each address book/calendar actually exists and is correct with the new 
u...@example.net format in both the c_path and c_path2 columns.


Can anyone suggest an easy way for me to fix the mess I have made? I 
could unsubscribe from all the calendar/address books and stop sharing 
them.  This may help but wouldn't fix the personal ones. I'm afraid that 
if I try and edit them manually I will make a typo somewhere and cause a 
bigger mess!


All suggestions very gratefully received...


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

Re: [SOGo] sogo-tool list users

2015-09-23 Thread 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

2015-09-23 Thread 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

2015-09-24 Thread 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

2015-10-08 Thread 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

2015-10-08 Thread 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

2015-10-08 Thread 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

2015-10-08 Thread 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

2015-10-08 Thread 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

2016-01-21 Thread 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

[SOGo] sogo-tool, restoring calendar subscriptions?

2010-10-20 Thread tuomas

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

.tuomas


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

Re: [SOGo] sogo-tool - not avilable

2011-03-03 Thread 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

2011-03-03 Thread 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

2011-04-18 Thread 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

2011-04-18 Thread 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

[SOGo] sogo-tool to remove Addressbook

2011-10-19 Thread Khapare Joshi

one of my user has created addressbook called Test via web interface. then
he deleted from the webinterface. But he synchronized his address book in
his iphone. however his addressbook test appears in his iphone. this might
be in sogo database, but can i delete this test from the database using
sogo-tool ?

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

[SOGo] sogo-tool restore core dumps

2017-02-22 Thread Philip Jocks

Hej,

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

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

Cheers,

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

[SOGo] sogo-tool backup missing users

2017-05-10 Thread Gerald Brandt


Hi,

If I do:

sogo-tool backup /root/sogo ALL

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?


Gerald

SOGo 3.2.7 on Nethserver


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

[SOGo] sogo-tool, modify user preferences

2019-06-24 Thread Alexey Dunaev


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 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:
~# sogo-tool user-preferences set settings ad...@example.com 
'{"Calendar": {"FolderSynchronize": 
{"meetingr...@example.com:Calendar\/personal": 1}}}'
after i've inspect mysql database with user settings and changing 
preferences via web interface but have no luck.


Can someone explain right syntax to use sogo-tool user-preferences?

P.S. even built-in help message with command 'sogo-tool user-preferences 
get defaults janedoe SOGoLanguage' for my mailbox returns "Value for key 
"SOGoLanguage" not found in settings"


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

[SOGo] sogo-tool, modify user preferences

2019-07-04 Thread Alexey Dunaev

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"
: 1}}}'
after i've inspect mysql database with user settings and changing
preferences via web interface but have no luck.
Also i've tried a 'hack' - via my external script i've added
'FolderSynchronize' parameter into mysql sogo_user_profile table,
c_settings row, exactly (except an order of parameters in array) like SOGo
doing this after parameter checked in web-interface, but this doesn't help.

Can someone explain right syntax to use sogo-tool user-preferences or any
other ways how to enable ActiveSync Synchronize from 'admin' side, without
necessity to user side actions?

Thank you.

P.S. even built-in help message with command 'sogo-tool user-preferences
get defaults janedoe SOGoLanguage' for my mailbox returns "Value for key
"SOGoLanguage" not found in settings"
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Sogo-tool documentation is available

2023-11-02 Thread qhivert

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 expire-autoreply script

2013-02-06 Thread 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

2013-02-06 Thread 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

2013-02-08 Thread 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

2013-02-18 Thread 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, restoring calendar subscriptions?

2010-10-20 Thread 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

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

2011-02-09 Thread Alessio Fattorini


 [sogo@sogo root]$ sogo-tool check-doubles alessio personal
 The warning limit for folder records is set at 1000

Any parameter i use for check-doubles, output is the same.

 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

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

2011-03-02 Thread xbgmsharp


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

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

I am using Sogo-1.3.5a and Debian-5.0.8 Lenny

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

Re: [SOGo] sogo-tool backup missing users

2017-05-10 Thread 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

2017-05-10 Thread 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

2019-07-10 Thread "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"

[SOGo] sogo-tool crashes after sieve login

2022-06-28 Thread Kees van Vloten


Hi all,


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:


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 documentation is available

2023-11-04 Thread 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

2023-11-16 Thread 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

2023-11-17 Thread 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

[SOGo] sogo-tool not included in rpm package

2012-04-06 Thread Marc Rechté


Hello,
I wondered why is sogo-tool not included in the rpm package ?
Thanks
--
users@sogo.nu
https://inverse.ca/sogo/lists

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

2012-06-14 Thread Hartmut Raithel

Hello, 

 

Im 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.94.9.r1664.20120601
SOPE application server libraries

libsope-core4.9 4.9.r1664.20120601
Core libraries of the SOPE application serve

libsope-gdl1-4.94.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-runtime1.19.3-1ubuntu1
GNUstep Base library

gnustep-common  2.2.0-1
Common files for the core GNUstep environmen

gnustep-make2.2.0-1
Basic GNUstep Makefiles

libgnustep-base1.19 1.19.3-1ubuntu1
GNUstep Base library

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

 

 

When Im doing a sogo-tool backup, and restore of a user afterwards, without
changing/deleting anything in the users calendar, for example, all looks
well:

 

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

Jun 14 14:56:39 sogo-tool [14699]: <0x0x8df0948[SOGoCache]> Cache cleanup
interval set every 1.00 seconds

Jun 14 14:56:39 sogo-tool [14699]: <0x0x8df0948[SOGoCache]> Using host(s)
'localhost' as server(s)

2012-06-14 14:56:39.327 sogo-tool[14699] PostgreSQL72 connection
established: <0x0x8ccfa58[PGConnection]:  connection=0x0x8e7ea50>

2012-06-14 14:56:39.328 sogo-tool[14699] PostgreSQL72 channel 0x0x8e42680
opened (connection=<0x0x8ccfa58[PGConnection]:  connection=0x0x8e7ea50>)

2012-06-14 14:56:39.328 sogo-tool[14699] PG0x0x8e42680 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 14:56:39.338 sogo-tool[14699] PG0x0x8e42680 SQL: UPDATE
sogo_folder_info SET c_foldername = 'Persönlicher Kalender' WHERE c_path =
'/Users/aaasys08/Calendar/personal'

2012-06-14 14:56:39.340 sogo-tool[14699] PG0x0x8e42680 SQL: BEGIN
TRANSACTION

2012-06-14 14:56:39.341 sogo-tool[14699] PG0x0x8e42680 SQL: DELETE FROM
sogoaaasys08004000ea9ed_acl

2012-06-14 14:56:39.342 sogo-tool[14699] PG0x0x8e42680 SQL: COMMIT
TRANSACTION

2012-06-14 14:56:39.343 sogo-tool[14699] PG0x0x8e42680 SQL: BEGIN
TRANSACTION

2012-06-14 14:56:39.343 sogo-tool[14699] PG0x0x8e42680 SQL: INSERT INTO
sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
('/aaasys08/Calendar/personal', 'sx', 'PublicViewer')

2012-06-14 14:56:39.344 sogo-tool[14699] PG0x0x8e42680 SQL: INSERT INTO
sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
('/aaasys08/Calendar/personal', 'sx', 'ConfidentialDAndTViewer')

2012-06-14 14:56:39.344 sogo-tool[14699] PG0x0x8e42680 SQL: INSERT INTO
sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
('/aaasys08/Calendar/personal', 'sx', 'ObjectCreator')

2012-06-14 14:56:39.344 sogo-tool[14699] PG0x0x8e42680 SQL: INSERT INTO
sogoaaasys08004000ea9ed_acl (c_object, c_uid, c_role) VALUES
('/aaasys08/Calendar/personal', 'sx', 'ObjectEraser')

2012-06-14 14:56:39.345 sogo-tool[14699] PG0x0x8e42680 SQL: COMMIT
TRANSACTION

2012-06-14 14:56:39.345 sogo-tool[14699] PG0x0x8e42680 SQL: SELECT c_name
FROM sogoaaasys08004000ea9ed WHERE (c_deleted != 1 OR c_deleted IS NULL)

 

 

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_

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

2010-07-30 Thread Patrick Ben Koetter

I've imported a non-DOS ICS file to a calendar and did a backup with
sogo-tool. The backup file adds CTRL-M only to events like this:

BEGIN:VTODO^M
CREATED:20090627T112251Z^M
LAST-MODIFIED:20090709T124124Z^M
DTSTAMP:20090709T124124Z^M
UID:4E71-4C533A80-2CD-64796380^M
SUMMARY:Schilder montieren^M
STATUS:COMPLETED^M
X-MOZ-LASTACK:20090627T112313Z^M
DTSTART;TZID=Europe/Berlin;VALUE=DATE:20090627^M
COMPLETED:20090709T124124Z^M
X-MOZ-GENERATION:3^M
PERCENT-COMPLETE:100^M
BEGIN:VALARM^M
ACTION:DISPLAY^M
TRIGGER;VALUE=DURATION:-PT1H^M
DESCRIPTION:Mozilla Alarm: Schilder montieren^M
END:VALARM^M

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

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

2011-03-02 Thread 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

2011-03-02 Thread 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

2011-03-03 Thread 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

2011-03-03 Thread 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

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

2011-07-05 Thread Julian Robbins


Hi

Using Sogo 1.3.7a, Lightning 1.0.b2.105i and Sogo Connector 3.105, Sogo 
Integrator 3.105


If I run sogo-tool I get the message below:-
2011-07-05 17:52:16.157 sogo-tool[26868] ERROR(+[GCSFolderManager 
defaultFolderManager]): default 'OCSFolderInfoURL' is not configured.
<0x0x2063af0[SOGoStartupLogger]> No configuration found. SOGo will not 
work properly.
2011-07-05 17:52:16.163 sogo-tool[26868] sogo-tool [-v|--verbose] 
[-h|--help] command [argument1] ...

  -v, --verboseenable verbose mode
  -h, --helpdisplay this help information

  argument1, ...arguments passed to the specified command

  Available commands:
restore-- restore user folders
backup-- backup user folders
check-doubles-- check user addressbooks with duplicate contacts
remove-- remove user data and settings from the db
remove-doubles-- remove duplicate contacts from the specified 
user addressbook
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 

--
Kind Regards,

Julian Robbins


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

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

2011-07-06 Thread Philipp Strobl


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 ?

Here is the script (for all, who want to participate, you are welcome) :

==
#! /bin/sh

## DEBUG
#set -x

DATE="`date +'%Y%m%d_%H%M%S'`"

cd /home/sogo/Backup

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

if [ "$1" = "-i" ]; then
su sogo -c "sogo-tool -v backup ./ ALL"
else
#su sogo -c "sogo-tool backup ./ ALL" > /dev/null 2>&1
su sogo -c "sogo-tool backup ./ ALL" > output 2>&1

fi

#echo "Exit-Code: $?"
#exit 1

if [ "$?" != "0" ];then
echo "!"
echo "Fehler beim Backup mit sogo-tool"
echo ""
cat output
else
mkdir ../STORE/$DATE
chmod -R 770 ../STORE/$DATE
mv * ../STORE/$DATE/
fi

cd ..
rm -rf tmp_$DATE

==

Best Regards
Philipp

Philipp v. Strobl-Albeg
- PILARKTO NETWORKS -

http://www.pilarkto.net


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

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

2020-05-25 Thread Philipp Kuehne

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 crashes after sieve login

2022-06-28 Thread 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

2022-06-28 Thread 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

2022-06-30 Thread 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 not included in rpm package

2012-04-06 Thread 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

2012-04-10 Thread 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

2012-06-15 Thread Christian Mack

Hello Hartmut Raithel


On 2012-06-14 17:03, Hartmut Raithel wrote:
> 
> I’m running SOGo version 1.3.16-1 on a Ubuntu 10.04.4 LTS System and
> sogo is running well, in general.
> 
> The SW Versions (prebuild from Ubuntu repository)are:
> 
> sogo@sh-sogodev01:~/backup/2012-06-14_1455$ dpkg -l |grep sogo
>
> sogo1.3.16-1  
> 
> 
> libsope-appserver4.9  4.9.r1664.20120601  SOPE application server 
> libraries
> libsope-core4.9   4.9.r1664.20120601  Core libraries of the 
> SOPE application serve
> libsope-gdl1-4.9  4.9.r1664.20120601  GNUstep database 
> libraries for SOPE
> libsope-ldap4.9   4.9.r1664.20120601  SOPE libraries for LDAP 
> access
> libsope-mime4.9   4.9.r1664.20120601  SOPE libraries for MIME 
> processing
> libsope-xml4.94.9.r1664.20120601  SOPE libraries for XML 
> processing
> sope4.9-gdl1-mysql4.9.r1664.20120601  MySQL connector for 
> SOPE's fork of the GNUst
> sope4.9-gdl1-postgresql   4.9.r1664.20120601  ̇̇̇PostgreSQL connector 
> for SOPE's fork of the 
> sope4.9-libxmlsaxdriver   4.9.r1664.20120601  XML Parser for SOPE's 
> SAX engine
> 
> gnustep-base-common   1.19.3-1ubuntu1 GNUstep Base library - 
> common files
> gnustep-base-runtime  1.19.3-1ubuntu1 GNUstep Base library
> gnustep-common2.2.0-1 Common files for the 
> core GNUstep environmen
> gnustep-make  2.2.0-1 Basic GNUstep Makefiles
> libgnustep-base1.19   1.19.3-1ubuntu1 GNUstep Base library
> 
> libsope-gdl1-4.9  4.9.r1664.20120601  GNUstep database 
> libraries for SOPE
> 

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


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

1 2 >

1 - 100 of 147 matches

Mail list logo