[SOGo] sogo-tool Uncaught exception NSInvalidArgumentException, reason: SoHTTPException(instance) does not recognize setContext:

[Marco Moock]

Hello!

updating vacation is currently faulty at our site, so I ran it manually.

 sudo -u sogo /usr/sbin/sogo-tool update-autoreply -p /etc/sogo/sieve.creds

It gives
/usr/sbin/sogo-tool: Uncaught exception NSInvalidArgumentException,
reason: SoHTTPException(instance) does not recognize setContext:

What ca be the reason for that?

-- 
kind regards
Marco

Spam und Werbung bitte an ichwillgesperrtwer...@nirvana.admins.ws

RE: [SOGo] Sogo-tool documentation is available

[qhivert]

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

 

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

Quentin

 

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

 

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

 

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

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

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

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

Shall I open a featere enhancement for this?

Regards,
Frank

 

-- 
Frank Richter, Chemnitz University of Technology, Germany

Re: [SOGo] Sogo-tool documentation is available

[Frank Richter]

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


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



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

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

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

Shall I open a featere enhancement for this?

Regards,
Frank


--
Frank Richter, Chemnitz University of Technology, Germany

Re: [SOGo] Sogo-tool documentation is available

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

[SOGo] Sogo-tool documentation is available

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

[Kees van Vloten]

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

Hi Kees


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

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

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

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

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

Thanks Francis, creating new sope* packages solved the issue



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

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

I am using Sogo 5.7.0 on Debian Bullseye.

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

- Kees

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

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

[Kees van Vloten]

Hi Francis,

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

Hi Kees


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

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

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

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

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



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


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


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


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




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

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

I am using Sogo 5.7.0 on Debian Bullseye.

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

- Kees

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

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

[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

[SOGo] sogo-tool crashes after sieve login

[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

[SOGo] sogo-tool update-autoreply and IMAP4 socket was shut down by server

[goetz.reini...@filmakademie.de]

Hi,

we notice some strange errors when the „ sogo-tool update-autoreply“ sieve is 
executed.

For the same 20 accounts regularly an auto reply is enabled - which shouldn’t 
be. And we get the error:

<0x0x43dc920[NGImap4Client]> ERROR(-[NGImap4Client 
_handleShutdownDuringCommandException:]): IMAP4 socket was shut down by server 
NGSocketShutdownDuringReadException: the socket was shutdown
2022-02-17 00:00:08.528 sogo-tool[24535] ERROR(-[NSException(NGMiscellaneous) 
initWithFormat:]): missing format!
2022-02-17 00:00:08.798 sogo-tool[24535] Enabled auto-reply of user 
blabla_username


Any hints/ideas/suggestion? Thanks & best . Götz




smime.p7s
Description: S/MIME cryptographic signature

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

[Christian Mack]

Hello

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


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

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

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

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


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

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


4) Set this change for dest-user:

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


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


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

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

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


Kind regards,
Christian Mack

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


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



smime.p7s
Description: S/MIME Cryptographic Signature

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

[Claus]

Hello,

I want to share a personal calendar of a user to somebody else. I can do 
this via the webinterface as superuser. However, I cannot add the 
subscription for somebody else. For this, I can use the sogo tool e.g.:


sudo -u sogo sogo-tool manage-acl subscribe owner-user Calendar/personal 
dest-user


I also tried with "AuthorizedSubscriber":
sudo -u sogo sogo-tool manage-acl subscribe owner-user Calendar/personal 
dest-user AuthorizedSubscriber


The personal calendar of the owner shows up at the destination user, 
however it does not add the owner information. This means that the 
destination user has 2 calendars which are called the same "Personal 
Calendar".


If the destination user searches and subscribes the calendar of the 
owner via the webinterface, the shared calendar shows up correctly with 
name. (however, I want that for users the new calendar shows up 
automatically, most users will not know how to find those calendars, 
even with the webinterface).


Please find the example attached. (I'm using the latest 5.3 of 2 days ago).

Can somebody explain me if this can be fixed with more complete/correct 
sogo-tool parameters?


I would also like to know if there is more documentation (or more 
examples) available for sogo-tool? I didn't find anything, and I'm not 
sure I completely understand the different rights described here 
https://github.com/inverse-inc/sogo/blob/master/SoObjects/Appointments/product.plist 
or the general usage here 
https://github.com/inverse-inc/sogo/blob/master/Tools/SOGoToolManageACL.m
Also via google I do find very little information on examples of other 
users using sogo-tool.



thank you, and kind regards,
--
users@sogo.nu
https://inverse.ca/sogo/lists

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

[Philipp Kuehne]

Hi Christian,

we have all these settings in our config.

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

Thanks in advance.

Kind regards

Philipp

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

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

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

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

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

 Here is an example for one of these errors:

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

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

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

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

 Here is a short cutout:

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

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

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

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

 followed by the errors mentioned above

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

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

 kind regards

 Philipp

>
-- 
___

Philipp Kühne | IT Administrator


indurad GmbH| the industrial radar company

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


signature.asc
Description: OpenPGP digital signature

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

[Christian Mack]

Hello

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

I assume OCSAclURL is missing.


Kind regards,
Christian Mack

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


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



smime.p7s
Description: S/MIME Cryptographic Signature

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

[Philipp Kuehne]

Hi,

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

So seems like we missed something.

Does anyone have an idea how to solve that issue?

Kind regards,

Philipp

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

Philipp Kühne | IT Administrator


indurad GmbH| the industrial radar company

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


signature.asc
Description: OpenPGP digital signature

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

[Christian Mack]

Hi

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

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


Kind regards,
Christian Mack

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


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



smime.p7s
Description: S/MIME Cryptographic Signature

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

[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, modify user preferences

["Christian M. Jensen"]

hi.

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


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


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



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

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

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


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


3. add and subscribe

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


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

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


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

 *

5. Update the user settings.

 5.1. get all user settings for key=Calendar.

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

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


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

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

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

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


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


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


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


--
Hilsen/Regards
Christian M. Jensen


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

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


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


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

[SOGo] sogo-tool, modify user preferences

[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, modify user preferences

[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 remove explained ... :) I do remove, tables deleted, user get's Data

[goetz.reini...@filmakademie.de]

Hi,

I removed an user with „ sogo-tool remove username“. The mysql shows no tables 
for that user any more.

When that user logs in again, Calendar subscriptions and e-mail signature do 
still exist ….

II thought, that the user and his data is removed immediately from the DB …

Can someone explain that behavior? Cahcing? Memcached ….

Regards . Götz



smime.p7s
Description: S/MIME cryptographic signature

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

[Thomas Winterstein]

Hello,

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


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


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


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


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


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

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

Re: [SOGo] sogo-tool backup missing users

[Gerald Brandt]

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

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

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

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



Hi,

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


Gerald

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

Re: [SOGo] sogo-tool backup missing users

[Ludovic Marcotte]

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

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

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

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

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

[SOGo] sogo-tool backup missing users

[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

Re: [SOGo] sogo-tool rename

[Ludovic Marcotte]

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


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

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

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

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


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

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

[SOGo] sogo-tool rename

[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

Re: [SOGo] sogo-tool restore

[Hubert Gilch]

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


Mit freundlichem Gruß
i. A. Hubert Gilch

Systemadministrator

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


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

Aufsichtsratsvorsitzender Michael Pelzer

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


Good morning,

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


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


Thank you.


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

Systemadministrator

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


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

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


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

[SOGo] sogo-tool restore

[Hubert Gilch]

Good morning,

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


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


Thank you.


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

Systemadministrator

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


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

Aufsichtsratsvorsitzender Michael Pelzer

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

[SOGo] sogo-tool restore core dumps

[Philip Jocks]

Hej,

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

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

Cheers,

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

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

[Stephen Ingram]

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

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

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

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

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

[Stephen Ingram]

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

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

[SOGo] sogo-tool argument 'expire-autoreply' changed to 'update-autoreply'?

[Zhang Huangbin]

Dear developers,

I noticed sogo-tool argument 'expire-autoreply' has been changed to 
'update-autoreply'. this causes cron sent out many notification emails due to 
invalid argument.

This change is not mentioned in SOGo document "Installation and Configuration 
Guide" (the "Upgrading" section), or the "NEWS" file in SOGo github repo.

It might be a good idea to notify all SOGo users about this change. Even 
better, keep old 'expire-autoreply' (but not shown in 'sogo-tool --help') for 
backward-compatible (for some releases).


Zhang Huangbin, founder of iRedMail project: http://www.iredmail.org/
Time zone: GMT+8 (China/Beijing).

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

[SOGo] sogo-tool backup errors

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

[SOGo] sogo-tool back and AME:ExecutionFailed REASON:Unknown column 'mail' in 'where clause'

[rene]

I use MySQL as store and like to create a backup of all users preferences and
calenders. However the sogo-backup.sh script and sogo-tool backup command
throw the following error for each user account:
<0x0x2500c78[SQLSource]> could not run SQL 'SELECT * FROM sogo_user_profile
WHERE (c_uid = 'x') OR (mail = 'x')': 
NAME:ExecutionFailed REASON:Unknown column 'mail' in 'where clause'

The sogo_user_profile schema does indeed miss the mail column:
+--+--+-+-+---+
| Field  | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| c_uid  | varchar(255) | NO   | PRI | NULL|   |
| c_defaults | text | YES  | | NULL|   |
| c_settings | text | YES  | | NULL|   |
++--+--+-+-+---+

I am using version 2.3.6 of Sogo.

Does anybody known how to solve this problem and why the mail column has not
been created by sogo when run for the first time?

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

Re: [SOGo] sogo-tool remove-doubles

[Christian Mack]

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

No, there is no such feature in SOGo.


Kind regards,
Christian Mack

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



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] sogo-tool remove-doubles

[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 hangs forever

[Christian Mack]

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

Do you execute this command as user sogo?


Kind regards,
Christian Mack

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



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] sogo-tool hangs forever

[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

Re: [SOGo] sogo-tool hangs forever

[Khapare Joshi]

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

Am 08.10.2015 um 11:00 schrieb Khapare Joshi:

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

sogo-tool remove khapare

nothing happens

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

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


Do you execute this command as user sogo?

yes I execute this as a sogo user




Kind regards,
Christian Mack



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

Re: [SOGo] sogo-tool hangs forever

[Christian Mack]

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

Good.

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


Kind regards,
Christian Mack

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



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] sogo-tool hangs forever

[Khapare Joshi]

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

Re: [SOGo] sogo-tool hangs forever

[Khapare Joshi]

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

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

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

Re: [SOGo] sogo-tool list users

[Márcio Merlone]

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

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

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


Hi,

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


Regards.

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

Re: [SOGo] sogo-tool list users

[Steve Ankeny]

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

Greetings!

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


Regards,

--
*Marcio Merlone*


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

'sudo samba-tool user list'


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

[SOGo] sogo-tool list users

[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

Re: [SOGo] sogo-tool list users

[Ludovic Marcotte]

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

sogo-tool doesn't have this feature.

Doing the following SQL request will tell you:

select distinct(c_path2) from sogo_folder_info;

Thanks,

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

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

[SOGo] sogo-tool rename-user mess

[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 us...@example.net)}, 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 'lost connection' errors after update to SOGo 2.2.5

[Charles Marcus]

Still trying to nail this down.

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


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


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


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


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


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


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


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

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

[Charles Marcus]

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


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


Would appreciate a response to this very simple question.

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

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

[Ludovic Marcotte]

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


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


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


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

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

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

[Charles Marcus]

On 6/25/2014 3:13 PM, Ludovic Marcotte lmarco...@inverse.ca wrote:

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


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


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


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

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


Thanks very much...

Charles

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

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

[Ludovic Marcotte]

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

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

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

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

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

[Ludovic Marcotte]

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

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

Search for WOWorkersCount.

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

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

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

[Charles Marcus]

On 6/19/2014 8:37 AM, Charles Marcus cmar...@media-brokers.com wrote:

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


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


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


Anyone?

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

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

[Charles Marcus]

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


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


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


Charles

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

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

[Christian Mack]

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

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

[Tanstaafl]

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

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

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

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

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



We see more connections to the database since SOGo 2.2.4.


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


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


max_connections
max_user_connections

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



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


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


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



Perhaps you run out of port numbers.


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



Perhaps you have not enough file descriptors.


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


But I'll investigate this further.

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

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

[Charles Marcus]

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


max_connections
max_user_connections

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


How about a more specific question for the SOGo devs.

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

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


Thanks,


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

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

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

[Charles Marcus]

I'm re-sending this as a new thread, since it is a new issue.

These occasional errors only started right after I updated to 2.2.5, and 
are only happening, once, or yesterday, twice per day. I saw not one of 
these in the prior 3 months of using SOGo.


connect_timeout is set to the default of 10 as it always has.

Here are the errors in question (these are all of them since we first 
started using SOGo in March, as you can see the first one was on 6/12, 
right after the 2.2.5 update):


2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 104
0x0x236c140[GCSChannelManager] could not open channel 
MySQL4Channel[0x0x22241b0] connection=0x(null) for URL: 
mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
0x0x236c140[GCSChannelManager]   will prevent opening of this channel 
5 seconds after 2014-06-12 03:30:01 -0400

2014-06-12 03:30:15.531 sogo-tool[31674] Can't aquire channel

2014-06-13 03:33:20.201 sogo-tool[6852] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 0
0x0x1d5f140[GCSChannelManager] could not open channel 
MySQL4Channel[0x0x1c171b0] connection=0x(null) for URL: 
mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
0x0x1d5f140[GCSChannelManager]   will prevent opening of this channel 
5 seconds after 2014-06-13 03:33:01 -0400

2014-06-13 03:33:20.202 sogo-tool[6852] Can't aquire channel

2014-06-14 11:09:19.303 sogo-tool[16644] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 0
0x0x18c2140[GCSChannelManager] could not open channel 
MySQL4Channel[0x0x177a1b0] connection=0x(null) for URL: 
mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder
0x0x18c2140[GCSChannelManager]   will prevent opening of this channel 
5 seconds after 2014-06-14 11:09:01 -0400

2014-06-14 11:09:19.304 sogo-tool[16644] Can't aquire channel

2014-06-14 19:29:16.259 sogo-tool[4321] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 0 
0x0x1ff4140[GCSChannelManager] could not open channel 
MySQL4Channel[0x0x1eac1b0] connection=0x(null) for URL: 
mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 
0x0x1ff4140[GCSChannelManager] will prevent opening of this channel 5 
seconds after 2014-06-14 19:29:01 -0400 2014-06-14 19:29:16.260 
sogo-tool[4321] Can't aquire channel


2014-06-15 11:36:12.184 sogo-tool[11336] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 0 
0x0x1534410[GCSChannelManager] could not open channel 
MySQL4Channel[0x0x13ec1b0] connection=0x(null) for URL: 
mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 
0x0x1534410[GCSChannelManager] will prevent opening of this channel 5 
seconds after 2014-06-15 11:36:02 -0400 2014-06-15 11:36:12.185 
sogo-tool[11336] Can't aquire channel


2014-06-16 19:29:17.300 sogo-tool[22163] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 0 
0x0x20a4410[GCSChannelManager] could not open channel 
MySQL4Channel[0x0x1f5c1b0] connection=0x(null) for URL: 
mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 
0x0x20a4410[GCSChannelManager]   will prevent opening of this channel 
5 seconds after 2014-06-16 19:29:01 -0400 2014-06-16 19:29:17.301 
sogo-tool[22163] Can't aquire channel


2014-06-17 03:08:22.791 sogo-tool[24540] ERROR: could not open MySQL4 
connection to database 'sogo': Lost connection to MySQL server at 
'reading authorization packet', system error: 0 
0x0x282b410[GCSChannelManager] could not open channel 
MySQL4Channel[0x0x26e31b0] connection=0x(null) for URL: 
mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 
0x0x282b410[GCSChannelManager] will prevent opening of this channel 5 
seconds after 2014-06-17 03:08:01 -0400 2014-06-17 03:08:22.792 
sogo-tool[24540] Can't aquire channel


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


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


Best regards,

Charles

--
users@sogo.nu

[SOGo] sogo-tool and upgrades

[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

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

[David Cure]

Hello,

just one question to be sure :

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

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

David.

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

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

[michael]

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

Regards, Michael. 

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

Hi,

On 13-02-06 3:40 AM, mich...@los-pollos.co wrote:
 Hi all, successfully got a dovecot/postfix/LDAP/sogo2.04 server up and 
 running on Ubuntu 12.04 but having some problems getting the cron jobs 
 setup. Specifically the sogo-tool expire-autoreply script.

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

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

 Could not login 'u...@example.com' on Sieve server:
 0x0x9758288[NGSieveClient]: socket=NGActiveSocket[0x0x975cd88]:
 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

[SOGo] sogo-tool expire-autoreply script

[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=NGActiveSocket[0x0x975cd88]: 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

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

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

[Florian GRUEL]

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

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


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

ly the sogo-tool expire-autoreply script.

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


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

[SOGo] sogo-tool expire-autoreply script

[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=NGActiveSocket[0x0x975cd88]: 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

 

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

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

[Jean Raby]

Hi,

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

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

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

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

Could not login 'u...@example.com' on Sieve server:
0x0x9758288[NGSieveClient]: socket=NGActiveSocket[0x0x975cd88]:
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

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

[Igor Vitorac]

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


Regards,
Igor



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

HI,

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


I called

sogo-tool backup test_backup ALL

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

Thanks
John


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

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

[John Bieling]

HI,

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


I called

sogo-tool backup test_backup ALL

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

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

[SOGo] sogo-tool

[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 check-doubles warning

[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 sieve rule creation

[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

Re: [SOGo] sogo-tool

[Jérôme]

Hi Benjamin,

Have you succeeded ?
Has someone else done this work ?

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

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

Someone can help me ?

Pierrot Benjamin benjamin.pierrot@... writes:


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

[SOGo] sogo-tool expire-autoreply

[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

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

[Christian Mack]

Hello Hartmut Raithel


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

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

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


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

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

[J. Echter]

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


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

 The SW Versions (prebuild from Ubuntu repository)are:

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

 sogo1.3.16-1 
  

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

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

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

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


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

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

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

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

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

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

 2012-06-14 15:12:46.422 sogo-tool[15238] PG0x0x832d680 SQL: SELECT
 c_folder_id, c_path, c_location, c_quick_location, c_acl_location,
 c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2
 = 'aaasys08' AND c_path3 = 'Calendar' AND c_path4 = 'personal'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 Speicherzugriffsfehler

 

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

[Hartmut Raithel (Rechenzentrum)]

Hello Christian,


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


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

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

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

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

Many thanks for your help!

Kind regards
Hartmut


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

Alfons-Goppel-Platz 1

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

[SOGo] sogo-tool sessions cleanup

[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

Re: [SOGo] sogo-tool sessions cleanup

[Jean Raby]

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

Hi,

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

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

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

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


Can you show your config? (OCSSessionsFolderURL parameter)


Thanks in advance

-Christian Rößner

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




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

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

Re: [SOGo] sogo-tool sessions cleanup

[Christian Rößner]

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

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

-Christian Rößner

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



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] sogo-tool sessions cleanup

[Jean Raby]

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

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

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


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


Can you show your config? (OCSSessionsFolderURL parameter)


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

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



-Christian Rößner

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




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

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

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

[Marc Rechté]

Thank you Francis.

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

Hello Marc

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


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

sogo-tool has its own rpm package.

yum install sogo-tool

:)

Francis

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




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

[SOGo] sogo-tool not included in rpm package

[Marc Rechté]

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

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

[Francis Lachapelle]

Hello Marc

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

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

sogo-tool has its own rpm package.

yum install sogo-tool

:)

Francis

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

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

[SOGo] sogo-tool

[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

Re: [SOGo] sogo-tool

[Christian Mack]

Hello Benjamin Pierrot


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

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


Kind regards,
Christian Mack

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

Re: [SOGo] sogo-tool

[Benjamin Pierrot]

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


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

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


cordially

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


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

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

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

Re: [SOGo] sogo-tool

[Christian Mack]

Hello Benjamin Pierrot


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

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

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

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


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


Kind regards,
Christian Mack

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

Re: [SOGo] sogo-tool

[Pierrot Benjamin]

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

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


Le Jeudi 5 Avril 2012 17:49 CEST, Christian Mack 
christian.m...@uni-konstanz.de 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
  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 remove-doubles

[Christian Mack]

Hello Donny Brooks


On 2012-03-22 19:38, Donny Brooks wrote:
 I am trying to remove some duplicate entries in my address book by using
 sogo-tool. However this is what I get when I try to do so:
 
 -bash-3.2$ /usr/sbin/sogo-tool remove-doubles dbrooks personal
 Mar 22 13:36:43 sogo-tool [16656]: [ERROR] 0x0x808fa98[GCSFolder]
 -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot
 execute quick-fetch SQL 'SELECT
 b.c_name,a.c_givenname,a.c_cn,a.c_sn,a.c_screenname,a.c_l,a.c_mail,a.c_o,a.c_ou,b.c_telephoneNumber,b.c_content,b.c_version,b.c_creationdate,b.c_lastmodified
 FROM sogodbrooks0022dd33700_quick a, sogodbrooks0022dd33700 b WHERE
 (c_component = 'vcard') AND a.c_name = b.c_name AND (c_deleted != 1 OR
 c_deleted IS NULL)': MySQL4Exception: 0x7f8bb38 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

[SOGo] sogo-tool remove-doubles

[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): MySQL4Exception: 0x7f8bb38 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

[Donny Brooks]

On Friday, March 16, 2012 04:22 PM CDT, Donny Brooks dbro...@mdah.state.ms.us 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=NGActiveSocket[0x0x1f044fe8]: mode=rw address=0x0x1f047a98[NGInternetSocketAddress]: host=webmail.mdah.state.ms.us port=33279 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 expire

[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=NGActiveSocket[0x0x1f044fe8]: mode=rw address=0x0x1f047a98[NGInternetSocketAddress]: host=webmail.mdah.state.ms.us port=33279 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

[Ludovic Marcotte]

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


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


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

Run it as the sogo user, not root.

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

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

Re: [SOGo] sogo-tool script

[Philipp v. Strobl-Albeg]

Hi,

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


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

Sorry for that.

Best Regards
Philipp

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

## DEBUG
#set -x

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

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

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

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

fi


#su sogo -c sogo-tool backup ./ ALL  /dev/null 21
#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 21
fi
else
if [ $1 = -i ]; then
su sogo -c $STOOL -v backup ./ ALL
else
su sogo -c $STOOL backup ./ ALL  output 21
fi

fi


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

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

cd ..
rm -rf tmp_$DATE
--


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

Re: [SOGo] sogo-tool script

[Julian Robbins]

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

Hi,

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

Hello Philipp

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


Julian




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

Sorry for that.

Best Regards
Philipp

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

## DEBUG
#set -x

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

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

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

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

fi


#su sogo -c sogo-tool backup ./ ALL  /dev/null 21
#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 21
fi
else
if [ $1 = -i ]; then
su sogo -c $STOOL -v backup ./ ALL
else
su sogo -c $STOOL backup ./ ALL  output 21
fi

fi


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

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

cd ..
rm -rf tmp_$DATE
--





--
Kind Regards,

Julian Robbins
Web Marketing and IT Manager

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

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

IDEAS ENGINEERED - SPECIALISTS IN MICROWAVE and RF ENGINEERING

(Registered office)
Incorporated in England No 1826221



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

Re: [SOGo] sogo-tool script

[Philipp Strobl]

Hi,

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

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

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

Best regards
Philipp

Ps: sorry for spelling

Am 25.11.2011 um 19:27 schrieb Julian Robbins julian.robb...@q-par.com:

 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 21
fi
 else
if [ $1 = -i ]; then
su sogo -c $STOOL -v backup ./ ALL
else
su sogo -c $STOOL backup ./ ALL  output 21
fi
 
fi
 
 
 #su sogo -c sogo-tool backup ./ ALL  /dev/null 21
 #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 21
fi
 else
if [ $1 = -i ]; then
su sogo -c $STOOL -v backup ./ ALL
else
su sogo -c $STOOL backup ./ ALL  output 21
fi
 
fi
 
 
 #su sogo -c sogo-tool backup ./ ALL  /dev/null 21
 #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 script

[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 21
fi
else
if [ $1 = -i ]; then
su sogo -c $STOOL -v backup ./ ALL
else
su sogo -c $STOOL backup ./ ALL  output 21
fi

fi


#su sogo -c sogo-tool backup ./ ALL  /dev/null 21
#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

[SOGo] sogo-tool with domain

[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 remove-changes: Is there a way to force a thunderbird address book reload?

[Luca Olivetti]

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

Summary:

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


(remove-doubles)


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

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

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

Is there an easier/better way?


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


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