Re: [SOGo] Mass export to ldif and ics

[Chris Coleman]

On 4/20/17 2:01 PM, Paul van der Vlis (p...@vandervlis.nl) wrote:

Hello,

I am looking for a way to do a mass export to ldif and ics for many
users, without knowing the password of the user.

Everything seems to be in the file what you get with "sogo-tool backup
username", but how to convert this file to ldif and ics?

Or is there another way? Maybe the SOGo admin-account can access
everything, like in Cyrus IMAP?

With regards,
Paul van der Vlis






What are you trying to export to LDIF and ICS?  All the personal 
information associated with mailbox usernames on the SOGo server? All 
the contacts related to every username on the SOGo server? Or all the 
contents of the LDAP server relevant to SOGo usernames?


--
Chris Coleman
 


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

Re: [SOGo] Feature Request

[Chris Coleman]

Letting a user upload their own profile picture, resize it, crop it, and 
save it, from inside SOGo, would be great.


Gravatar doesn't work for the EU, the privacy laws in the EU ban 
Gravatar because Gravatar logs user IP, email and geographical location, 
which isn't allowed by EU internet privacy regulations, so a feature to 
allow you to disable Gravatar had to be added to SOGo, see here: 
https://sogo.nu/bugs/view.php?id=3600


SOGo should probably save the user photo to the LDAP directory, or 
Active Directory, in the attributes "jpegPhoto" and "thumbnailPhoto".


Here's a PERL script to let you save your own JPEG photo to your user 
entry in LDAP.


http://cpansearch.perl.org/src/GBARR/perl-ldap-0.39/contrib/jpegLoad.pl

It's available in the PERL package "perl-jpeg", install it by doing:

# cpan install /perl-jpeg/

Leaving it as an exercise to connect "jpegLoad.pl" to SOGo for the 
purpose of letting users upload their own profile picture.


More information:

* jpegPhoto: "This attribute is used to store one or more images of a 
person using the JPEG File Interchange Format" - no maximum size, yet 
probably SOGo should reduce size until less than 100KB.


https://msdn.microsoft.com/en-us/library/cc221100.aspx

* thumbnailPhoto: "Picture" - maximum size 102400. Attribute field is 
created when Exchange is installed to the domain, or schema for 
ActiveDirectory is updated to 2008 R2.


https://msdn.microsoft.com/en-us/library/cc221395.aspx


On 2/15/2017 3:07 PM, "Ivan Gonzalez" (iva...@nocroom.com) wrote:

Correct, not many users use it would be nice to see option to upload your own

Ivan Gonzalez Jr. x101
NocRoom | ceo | e: iva...@nocroom.com w: NocRoom.com
West Coast/Las Vegas 702-789-0409 | East Coast/Miami 786-802-7666 [ social tw | 
fb | in | g+ ]

Turnkey Solution | Virtualization Kings – Dedicated Servers – Cloud Email 
Servers – Cloud PBX Hosted Systems - Bitcoin ok

All emails from NocRoom.com are encrypted

IMPORTANT: This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they are 
addressed. If the reader is not the intended recipient, please notify us 
immediately by return e-mail and delete the original message from your e-mail 
system. Any dissemination, distribution or copying of the communication is 
strictly prohibited. This correspondence is being transmitted for informational 
purposes only and the views, opinions and any electronic signatures of the 
sender are not intended to bind NocRoom LLC.​

-Original Message-
From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of 
Guillaume ANDRÉ
Sent: Wednesday, February 15, 2017 8:12 AM
To: users@sogo.nu
Subject: RE: [SOGo] Feature Request

If I'm not mistaken, any Gravatar associated with your email address should 
show up in SOGO. And of course it works others across different domains. Quite 
a nice feature.

Cheers,
Guillaume

-Message d'origine-
De : users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] De la part de Grouchy 
Sysadmin Envoyé : mardi 14 février 2017 17:18 À : users@sogo.nu Objet : Re: 
[SOGo] Feature Request


Quoting Ivan Gonzalez <users@sogo.nu>:


I will love to see this on sogo

1.  Allow users to “upload” their own photo image (admin panel on/off)
2.  Live Chat with users within the same domain, see who is online
(admin on/off)


For chat, check out https://www.jsxc.org/installation.html. They have a Sogo 
plugin.

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



--
---
Chris Coleman
Espace LLC
860-576-9526

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

Re: [SOGo] appointments from iPhone with emoticons

[Chris Coleman]

UTF-8 encoding fully supports emoticons; however, MySQL’s limited 
version of utf8 does not support emoticons!


MySQL’s utf8 can only store 3 byte characters, which are characters from 
the Basic Multilingual Plane - characters from the majority of modern 
languages and some symbols.  Emoticon characters exist in the 
Supplementary Multilingual Plane for which we need 4 bytes and so must 
use utf8mb4.


To save emoticons to a MySQL database we need to change the character 
set and collation properties, on the database connection, the database, 
the tables, and the columns, to use utf8mb4. Not necessarily all the 
columns, a minimal solution has utf8mb4 on only the columns containing 
user-entered text.


Below find commands to change the character set and collation 
properties.  For pro users only.   Warning, backup your entire database 
before trying this because the risk of data loss is real:


SET NAMES utf8mb4;
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = 
utf8mb4_unicode_ci;


ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE 
utf8mb4_unicode_ci;


ALTER TABLE table_name CHANGE column_name column_name VARCHAR(140) 
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;


** Bear in mind that changing from utf8 to utfmb4 affects the maximum 
lengths of columns and index keys. The maximum lengths of columns will 
be unchanged when modifying the tables with the commands discussed here; 
but in terms of actual characters the amount that can be stored is 
reduced. This is a consequence of changing from being able to store only 
3 bytes up to 4! You may need to update these lengths. **


REPAIR TABLE table_name;
OPTIMIZE TABLE table_name;

$ mysqlcheck -u root -p --auto-repair --optimize --all-databases

Finally to change the character set of the connection, that setting must 
be changed inside the SOGo application.


Hope this helps.


On 2/10/2017 9:21 AM, "Andreas Blaha" (andr...@blaha.at) wrote:


Hi all,

strange request from a user:

when an appointment created on the iphone/ipad contains an emoticon 
(wherever: title, notes, location etc.) the appointment is visible and 
manageable on the iphone/ipad, but not in the web gui. It can be seen 
but does not give any details, cannot be edited or deleted from there, 
I cannot view the source text of the appointment, but I get the 
according reminders. The appointment is not visible at all in Outlook 
201x/ActiveSync. This behaviour I can reproduce, both in 2.3.19 and 
3.2.6a.


I only found an open bug referring to UTF8, not sure if this has 
anything to do with it.


I have no Android device at hand to check whether it is the same there 
or not.


Has anyone experienced this as well?

Best regards

Andy

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

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

Re: [SOGo] problem with sieve

[Chris Coleman]

On 1/4/2017 9:22 AM, Paweł Stankiewicz (p.stankiew...@pwr.edu.pl) wrote:

Hi guys,
I stuck on sieve features support. I would appreciate any help !!
Right now we are using Oracle Communications Messaging Server ,Oracle
LDAP (Oracle Internet Direcotry) and Web interface from Oracle.
I want to start using SOGo in production for around 20k users. The thing
is I can't deal with Sieve features - holiday,filters and forwarding. In
Oracle when standard user(from ldap) is creating  e-mail filter via web
interface it's actually creating a new field in LDAP and saving there
appropriate rules (for example if e-mail is from example.com ->formward
e-mail to folder example).
  I know I can't map Oracle LDAP fields to fields in SOGO so how should I
configure Sieve Server (for example Dovecot) to keep using our Oracle
IMAP Server, process sieve features on my virtual machine where SOGO is
installed and save values in Oracle LDAP. I add that all E-mail
components like IMAP,LDAP,SOGo and so on are on different virtual
machines. Any clue will be appreciate!
Kind Regards
Pawel


Here's a thread with similar question from a month ago.  It appears 
RoundCube works correctly for editing the Seive email filter rules.

https://lists.inverse.ca/sogo/arc/users/2016-12/msg8.html
You should try it, and then post your results here.

---
Chris Coleman
Espace LLC

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

Re: [SOGo] time-zone dependencies

[Chris Coleman]

Thomas,

Very cool patch.  Would you be able to submit the patch as a pull 
request to the github for sogo-Activesync ?


https://github.com/inverse-inc/sogo/blob/master/ActiveSync/iCalRecurrenceRule%2BActiveSync.m#fork-destination-box

Best,
Chris


On 9/13/2016 11:42 AM, "Thomas Fuehrer" (t...@aon.at) wrote:

Hi Andreas!

I cannot reproduce the time shift, but see the same problem with recurring 
events.
The problem is the RRULE:FREQ=YEARLY.

According to https://msdn.microsoft.com/en-us/library/dn292994(v=exchg.80).aspx
MonthOfYear  and DayOfMonth are required for Type=5 but this elements are not 
generated for above rrule.

If you are compiling from source you can test attached patch.

Regards,
Thomas

-Original Message-
From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of "Andreas 
Blaha"
Sent: Dienstag, 13. September 2016 11:50
To: users@sogo.nu
Subject: AW: [SOGo] time-zone dependencies

Hello,
similar problem here:
running SOGo 2.3.14,
in sogo.conf and on the system (centOS 7, tzselect) TZ is set to Europe/Vienna, 
same on the client web interface and on the client system settings (Windows 10, 
Outlook 2016) in the web interface all is fine, in Outlook /EAS all all day 
appointments are either shifted backwards by one day or by 23 hours, see 
enclosed screenshots (I trust you don't use the appointments against me ;-)  ). 
The shown example is from an additional calendar created in this mailbox but 
the effect ist he same fort he default personal calendar.
Also, as you can see from the screenshots, not all appointments are 
synchronized with EAS. If I change some of them to non-all-day events, they 
show up immediately.

I have exported the calendar, it looks normal to me, one example that SHOWS up:

BEGIN:VEVENT
UID:753E-57D2BE00-1B-32A6CA8
SUMMARY:Fritz S... GEBURTSTAG
CLASS:PRIVATE
DTSTART;VALUE=DATE:19610916
DTEND;VALUE=DATE:19610917
LAST-MODIFIED:20160912T070207Z
PRIORITY:5
CATEGORIES:Geburtstag
BEGIN:VALARM
TRIGGER;VALUE=DURATION:-P1D
ACTION:DISPLAY
END:VALARM
RRULE:FREQ=YEARLY
TRANSP:TRANSPARENT
SEQUENCE:1
END:VEVENT
-
And one that DOES NOT SHOW up
:
BEGIN:VEVENT
UID:7542-57D2BE00-9-3AB43E40
SUMMARY:Gyula S GEBURTSTAG
CLASS:PRIVATE
DTSTART;VALUE=DATE:20160916
DTEND;VALUE=DATE:20160917
LAST-MODIFIED:20160912T065157Z
PRIORITY:5
CATEGORIES:Geburtstag
BEGIN:VALARM
TRIGGER;VALUE=DURATION:-P1D
ACTION:DISPLAY
END:VALARM
RRULE:FREQ=YEARLY
TRANSP:TRANSPARENT
END:VEVENT

Here the sequence is missing in the ones that do not show.
If I check their content in the web interface (view raw source) they are 
identical entirely except the sequence number.

Any ideas?


-Ursprüngliche Nachricht-
Von: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Im Auftrag
von Christian Mack
Gesendet: Donnerstag, 8. September 2016 10:33
An: users@sogo.nu
Betreff: Re: [SOGo] time-zone dependencies

Hello

Am 07.09.2016 um 18:07 schrieb Alex Gogan (a...@fbi.ie):

I have double checked everything and the Time on my server is
correct, the time on my configuration is correct but when I great
invites

it will be correct unless I have and use invite attendees, then it
ALWAYS in the body of the email change the time (this happens in
outlook and gmail calendaring as well)... in the actual calendar it is correct.

Just wondering is there a way to vary this work correctly?


Which timezone have you set in sogo.conf?
Which timezone is set in SOGo webinterface for that account?
Does the client use the same timezone on his machine?
Is the clock on the client set correctly?
How do you synchronize Outlook?


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


---
Chris Coleman
Espace LLC
+1-860-576-9526

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

Re: [SOGo] How to build the packages for Debian

[Chris Coleman]

Yes, it would be most convenient to make one automated build script 
which would do all these steps, and produce the rpms and debs.  So, 
anyone could run the script on their machine, it downloads openchange 
source, samba, and sogo source, it makes the build environment, and it 
builds openchange, samba, and sogo properly from source fully.  The 
script outputs the deb and rpm packages.  Minimal to no human 
intervention required.



On 8/4/2016 8:00 PM, Slávek Banko (slavek.ba...@axis.cz) wrote:

I can say that building OpenChange packages is more complicated. The first
obstacle was that on a clean build system occurred FTBFS. Another
obstacle is the dependence on a newer version of Samba... and Samba
brings the need for additional dependencies. And after build are
necessary additional python modules.

Do you really want to go through this again, when is already available
alternative repository of packages for Debian and Ubuntu?



--
Chris Coleman
Espace LLC
860-576-9526

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

Re: [SOGo] How to build the packages for Debian

[Chris Coleman]

Alain, merci beaucoup.  Is it possible you could add the openchange 
build steps, it's optional yet necessary for many organizations.



On 7/30/2016 12:52 PM, "Alain Abbas" (alain.ab...@libertech.fr) wrote:

Hello
i wrote the steps to build the packages for debian in the Wiki 
( http://wiki.sogo.nu/Packaging)  for all peoples who want to build them.

This article decribes the process for that without openchange building.

Regards


--
*Alain Abbas*
3 rue des Violettes
54 410 Laneveuville-Devant-Nancy
Tel : +333 83 18 02 70
skype: alain.abbas
--
users@sogo.nu
https://inverse.ca/sogo/lists


---
Chris Coleman
Espace LLC
860-576-9526


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

Re: [SOGo] OTP ( one time password ) for SOGo

[Chris Coleman]

I suggest you look to implement PrivacyIdea it's great for one time 
passwords and works with many hardware and software keys and 
communication channels.


https://github.com/privacyidea

https://www.howtoforge.com/manage-yubikeys-for-luks-encryption-with-privacyidea



On 8/3/2016 2:01 PM, devteam (devt...@alpeinsoft.ch) wrote:

p.s. no answer: https://sogo.nu/bugs/view.php?id=2722

On 08/03/2016 08:56 PM, devteam (devt...@alpeinsoft.ch) wrote:

Hi. Somebody integrated OTP (One Time Password) authorization in SOGo?
May be have ideas/solutions?
Thx!



---
Chris Coleman
Espace LLC
860-576-9526

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

Re: [SOGo] vacation message goes to spam

[Chris Coleman]

from;

  s=dkim; t=1469561237; x=1470425238; bh=ED/WteS3/nRYBKhF/D5WVXdV

f8s43g0e6Jth4G/+mVo=; b=YwmZzxCGtp5MzQAs5b1R31Jp9XJcnox+7fgxHag+

aHq+QHPfrZcHGNgI57B99hhPAoUeqSgPRqaRrkg62IjzSb39gUCaRFS9SlsC9be1

7ISi7xkvkH0vTUQd+87ff9Yv51VOfA0ItGiD1cPWOVQc5ut5StOByR5dacYUJCWr

ZCAYRqmN74rPBknV4Dspx8BI/c7+nYok+BLCfFcPQtl9+HKepJ4uhchOqpggeq9b

Aj68hmRu2B4RqmSP7y68NLlDWzAoEUpaAyq0C77rY/PsHvqLJtvDizgcyvj8CSIW

GG4Digz+wocY4gNNOqKLLWd2JGE8B2ih6lfGcnRXqRF0Gg==

X-Virus-Scanned: Debian amavisd-new at my.sogo.server

Received: from my.sogo.server ([127.0.0.1])

  by my.sogo.server (my.sogo.server [127.0.0.1]) (amavisd-new, port 10024)

  with ESMTP id j0UwAOXzILj4 for <mygmailu...@gmail.com>;

  Tue, 26 Jul 2016 14:27:17 -0500 (ECT)

Received: from my.sogo.server (my.sogo.server [127.0.0.1])

  by my.sogo.server (Postfix) with ESMTP id 8E28F103158

  for <mygmailu...@gmail.com>; Tue, 26 Jul 2016 14:27:17 -0500 (ECT)

Return-Receipt-To: "Fernando Salas" <user@sogo.server>

From: Fernando Salas =?utf-8?q?=5BNovanet=5D?= <user@sogo.server>

To: <mygmailu...@gmail.com>

Subject: foto

Date: Tue, 26 Jul 2016 14:26:20 -0500

Message-ID: 



MIME-Version: 1.0

Content-Type: multipart/mixed;

boundary="=_NextPart_000_0186_01D1E749.AE13D820"

X-Mailer: Microsoft Outlook 16.0

thread-index: AdHnc5VXa0ovfY4ARsScPGVzPZPhnQ==

Content-Language: es-ec

Disposition-Notification-To: "Fernando Salas" <user@sogo.server>

This is a multipart message in MIME format.

--=_NextPart_000_0186_01D1E749.AE13D820

Content-Type: multipart/related;

boundary="=_NextPart_001_0187_01D1E749.AE13D820"

--=_NextPart_001_0187_01D1E749.AE13D820

Content-Type: multipart/alternative;

boundary="=_NextPart_002_0188_01D1E749.AE13D820"

--=_NextPart_002_0188_01D1E749.AE13D820

Content-Type: text/plain;

  charset="us-ascii"

Content-Transfer-Encoding: 7bit

Kind regards,

*Fernando Salas*

*De:*users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] *En nombre 
de *Chris Coleman (ch...@espacenetworks.com)

*Enviado el:* martes, 26 de julio de 2016 15:57
*Para:* users@sogo.nu
*Asunto:* Re: [SOGo] vacation message goes to spam

Fernando,

To help your Vacation message to be delivered into the user's Inbox, 
you should add the following to your domain's DNS: 1) an SPF record, 
2) DKIM records, and 3) a Reverse-PTR record.


SOGo should also add "Precedence: Bulk" to the message header for 
Notification messages, so that Gmail will not sort the message into 
"Junk".


Reference: RFC3834, https://tools.ietf.org/search/rfc3834

On 7/26/2016 3:46 PM, Fernando Salas [Novanet] (fsalas@novanet.network 
<mailto:fsalas@novanet.network>) wrote:


Dear Friends,

After enabling the vacation message on the webmail and testing it,
I receive on Gmail the auto response on the "spam folder".

This is the header of the auto response that I get in Gmail:

Delivered-To: mygmailu...@gmail.com <mailto:mygmailu...@gmail.com>

Received: by 10.103.122.141 with SMTP id v135csp893887vsc;

Wed, 13 Jul 2016 04:17:28 -0700 (PDT)

X-Received: by 10.66.117.105 with SMTP id
kd9mr12589484pab.40.1468408648637;

Wed, 13 Jul 2016 04:17:28 -0700 (PDT)

Return-Path: <>

Received: from my.sogo.server (my.sogo.server. [A.B.C.D])

by mx.google.com with ESMTPS id
o6si4948924pac.39.2016.07.13.04.17.28

for <mygmailu...@gmail.com> <mailto:mygmailu...@gmail.com>

(version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);

Wed, 13 Jul 2016 04:17:28 -0700 (PDT)

As you can see the variable "Return-Path" is empty and I think
this is the reason why Gmail send it to spam folder.

This is the header of a mail that goes normally to the "Inbox
Folder" in Gmail:

Delivered-To: mygmailu...@gmail.com <mailto:mygmailu...@gmail.com>

Received: by 10.103.122.130 with SMTP id v124csp1814641vsc;

Tue, 26 Jul 2016 12:27:20 -0700 (PDT)

X-Received: by 10.66.138.74 with SMTP id
qo10mr42243733pab.135.1469561240400;

Tue, 26 Jul 2016 12:27:20 -0700 (PDT)

Return-Path: <user@sogo.server> <mailto:user@sogo.server>

Received: from my.sogo.server (my.sogo.server. [A.B.C.D])

by mx.google.com with ESMTPS id
x184si1983910pfb.210.2016.07.26.12.27.19

for <mygmailu...@gmail.com> <mailto:mygmailu...@gmail.com>

(version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);

Tue, 26 Jul 2016 12:27:20 -0700 (PDT)

I’m running SOgo 3.1.3 and iRedMail 0.9.4 with MySQL

Any idea about this issue?

Kind regards,

Fernando Salas

-- 
users@sogo.nu <mailto:users@sogo.nu>

https://inverse.ca/sogo/lists



--
Chris Coleman
Espace LLC
860-576-9526

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

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


--
---
Chris Coleman
Espace LLC
860-576-9526

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

Re: [SOGo] vacation message goes to spam

[Chris Coleman]

Fernando,
Details on exactly how to add these SPF, DKIM, Reverse-PTR, DNS records :
*http://www.iredmail.org/docs/setup.dns.html

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

[SOGo] Feature request: Precedence header for Notification emails

[Chris Coleman]

This is a feature request (maybe a bug fix depending on how you look at 
it), to improve the Notifications.


In Google's Bulk Senders Guidelines, they mention:

"Messages should indicate that they are bulk mail, using the 'Precedence: bulk' 
header field."

https://support.google.com/mail/answer/81126?hl=en

This triggers Google's Smart Labels feature to label the messages as 
bulk. Because SOGo currently fails to label bulk emails with this 
header, it's more likely that Google will send SOGo's Notification 
messages to the recipient's Spam folder.


The solution: You need to add a new field in the Notification messages 
headers:


Precedence: bulk

Reference: RFC3834, http://tools.ietf.org/search/rfc3834


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

Re: [SOGo] vacation message goes to spam

[Chris Coleman]

Fernando,

To help your Vacation message to be delivered into the user's Inbox, you 
should add the following to your domain's DNS: 1) an SPF record, 2) DKIM 
records, and 3) a Reverse-PTR record.


SOGo should also add "Precedence: Bulk" to the message header for 
Notification messages, so that Gmail will not sort the message into "Junk".


Reference: RFC3834, https://tools.ietf.org/search/rfc3834



On 7/26/2016 3:46 PM, Fernando Salas [Novanet] (fsalas@novanet.network) 
wrote:


Dear Friends,

After enabling the vacation message on the webmail and testing it, I 
receive on Gmail the auto response on the "spam folder".


This is the header of the auto response that I get in Gmail:

Delivered-To: mygmailu...@gmail.com

Received: by 10.103.122.141 with SMTP id v135csp893887vsc;

Wed, 13 Jul 2016 04:17:28 -0700 (PDT)

X-Received: by 10.66.117.105 with SMTP id 
kd9mr12589484pab.40.1468408648637;


Wed, 13 Jul 2016 04:17:28 -0700 (PDT)

Return-Path: <>

Received: from my.sogo.server (my.sogo.server. [A.B.C.D])

by mx.google.com with ESMTPS id 
o6si4948924pac.39.2016.07.13.04.17.28


for <mygmailu...@gmail.com>

(version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);

Wed, 13 Jul 2016 04:17:28 -0700 (PDT)

As you can see the variable "Return-Path" is empty and I think this is 
the reason why Gmail send it to spam folder.


This is the header of a mail that goes normally to the "Inbox Folder" 
in Gmail:


Delivered-To: mygmailu...@gmail.com

Received: by 10.103.122.130 with SMTP id v124csp1814641vsc;

Tue, 26 Jul 2016 12:27:20 -0700 (PDT)

X-Received: by 10.66.138.74 with SMTP id 
qo10mr42243733pab.135.1469561240400;


Tue, 26 Jul 2016 12:27:20 -0700 (PDT)

Return-Path: <user@sogo.server>

Received: from my.sogo.server (my.sogo.server. [A.B.C.D])

by mx.google.com with ESMTPS id 
x184si1983910pfb.210.2016.07.26.12.27.19


for <mygmailu...@gmail.com>

(version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);

Tue, 26 Jul 2016 12:27:20 -0700 (PDT)

I’m running SOgo 3.1.3 and iRedMail 0.9.4 with MySQL

Any idea about this issue?

Kind regards,

Fernando Salas

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


--
Chris Coleman
Espace LLC
860-576-9526

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

Re: [SOGo] AD avatar

[Chris Coleman]

On 7/13/2016 3:26 PM, Alexandre Zuotoski Neto (t...@csmcalderaria.com.br) 
wrote:

Do you mean from jpegPhoto and/or thumbnailPhoto attribute?
I'm interested in this method too :)

If isn't any way for set it, then it should be a fancy feature request (like 
the LDAP Attributes Mapping method).


Yes, that's what I mean. It works for Roundcube, Openfire, GLPI, etc.



Similar to a feature request I made, which was added to sogo, to show 
the public gravatar.com thumbnail photo, associated with any email 
address found in the header of any email message...


As I said, there's open source code for getting and displaying the 
jpegPhoto and thumbnailPhoto from the AD / LDAP attributes.  This should 
be easily added to sogo.  Every email address should show the small 
picture of the person next to it, it's a great way to make messaging 
more user-friendly today.


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

Re: [SOGo] SOGo with Virtualmin

[Chris Coleman]

On 6/8/2016 7:56 AM, Jan Runhart (j...@runhart.it) wrote:

Hello,

Does anyone have experience with installing Sogo combined with 
Virtualmin?


Regards,

Jan

Hello Jan,

I've begun work on looking at what it'd take to get SOGo working great 
on virtualmin virtual servers.
I suppose you want SOGo to take over and run as the web mail groupware 
for the entire virtualmin machine?  Which would make sense, as users 
continue to have access through their mail client apps eg thunderbird 
via smtp and imap.
Obviously you should disable pop3 in virtualmin as pop3 defaults to 
remove mail from the server, which defeats the entire purpose of webmail 
groupware which is to leave the mail on the server for others to read, 
comment on, and reply to etc.


The trick obviously is to have a virutalmin module configure settings 
which achieve automatic seamless configuration while respecting the 
multi tenant nature of virtualmin, so that users can...

1. autocomplete from the LDAP directories present on their virtual server,
2. share calendars as specified by admins of their virtual server,
3. share contacts as specified by admins and users,
4. share inboxes as specified by admins,
5. bar users from seeing outside their virtual server (other virtual 
server LDAP directories, calendars, contacts, etc).


Feel free also to share your experiences

---
Chris Coleman
Espace LLC
860-576-9526

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

Re: [SOGo] Auto update status of Invitees when an invitation is accepted?

[Chris Coleman]

It's unfortunate Microsoft didn't make these external meeting and 
appointment requests and responses, sent to a unified inbox with a name 
that SOGo would auto-generate, for example, meetings-0bf8cd1@ (your 
domain . com), appointments-d9fvjke2@ ... and then simply let SOGo 
have the IMAP passwords to those inboxes, and check them every 1-2 
minutes for external requests and responses.


A filter expression for procmail and maildrop to intercept those 
incoming external requests and responses would probably be acceptable in 
most instances.




On 2/3/2016 7:44 PM, Johnny Sketcho wrote:
Thanks for the responses. The gist of this I'm getting is, for 
invitees outside of SOGo responding to event invitations, this would 
require SOGo acting as a sieve for incoming mail to parse the messages 
and determine if one was an Accepted notification. I can see how that 
might be a bit intrusive.



On Wed, Feb 3, 2016 at 4:14 PM, Ludovic Marcotte <lmarco...@inverse.ca 
<mailto:lmarco...@inverse.ca>> wrote:


On 2016-02-03 19:04, Chris Coleman wrote:

This feature should be added to SOGo, because it already
exists in Exchange, called "Process external meeting requests
and responses."

It won't work. SOGo would need to have all user's passwords in
clear text (or an IMAP trust) to log in and access user's
messages. Not to mention that users could have filters moving
messages around in other mailboxes. It would be wiser to have this
integrated at the LDA level.

-- 
Ludovic Marcotte

lmarco...@inverse.ca <mailto:lmarco...@inverse.ca> ::
+1.514.755.3630 <tel:%2B1.514.755.3630>  :: http://inverse.ca
Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and
PacketFence (http://packetfence.org)

-- 
users@sogo.nu <mailto:users@sogo.nu>

https://inverse.ca/sogo/lists




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

[SOGo] Inverse/SOGo collaboration with Zentyal on OpenChange

[Chris Coleman]

A couple of questions about Inverse, SOGo, Zentyl, and OpenChange

1. How active is the collaboration between Inverse and Zentyal to fix 
bugs, add features, and improve performance of OpenChange and its 
implementation of Microsoft's Exchange ActiveSync (EAS) and Exchange Web 
Services (EWS) ?


I ask because there are some bugs in OpenChange having to do with EAS, 
which prevent SOGo's OpenChange ActiveSync features from working as a 
full replacement for Exchange server.   Outlook users see some missing 
features, some performance problems and some bugs.


2. Also, what's the roadmap or status on implementing Exchange Web 
Services as discussed on the zentyal openchange github repo?

https://github.com/openchange/openchange/issues/314

Many say EWS is a better bet than EAS and much less trouble to debug 
than the popular yet arcane and overly complicated EAS.


Also Outlook 2013 and newer use EWS to talk to exchange server so 
this EWS code would be a smart addition to OpenChange and SOGo.



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

Re: [SOGo] creating event on mouse drag

[Chris Coleman]

I have tried it and get success, when dragging the mouse to create a new 
event, the time is correct, and the form pops up and is automatically 
filled in (start and end time and days).

Browser is Firefox 44.0 on windows 7.


On 1/26/2016 3:00 PM, Hugo wrote:

nope, sorry, still no joy on linux and firefox 43.0.4, same behaviour

On 26.01.2016 15:36, Francis Lachapelle wrote:
On Jan 26, 2016, at 6:00 AM, VILLEMUR Jacques 
 wrote:


Hi,
I have same bug with v3, safari 9.0.3
Jacques


Le Vendredi 22 Janvier 2016 11:56 CET, Hugo  a écrit:

sorry, forgot to mention, it happens on firefox 43.0.4 on ubuntu 
15.10,

sogo 3 interface

On 22.01.2016 09:38, Christian Mack wrote:

Am 21.01.2016 um 14:01 schrieb Hugo:
.. is not possible. I get NaN/NaN/NaN as date and NaN:NaN as time 
field.

if I try to set a date, first it shows me the year 1932 (!) and if I
scroll down aaall the way to the current year and pick a date, 
the field

still stays the same and the save button is greyed out.
if created with the green button, it's all ok, even if I change the
date. (see attached screenshots)

sogo version is latest from git (master branch), pulled today and
compiled on an ARM (Odroid-XU)



Android Version?


I just pushed a fix: 
https://github.com/inverse-inc/sogo/commit/8a177bea47925108ad8495da387abd355a840ca0


I also updated the online demo (http://demo.sogo.nu/SOGo) so you can 
quickly confirm that the problem is really resolve.


Thanks!

Francis



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

Re: [SOGo] Addressbook

[Chris Coleman]

On 12/15/2015 9:37 AM, sti wrote:

looking for a groupware solution I looked at SOGO

I could not find any functions  for filtering address books before exporting.

How does a postprocessing of an exported addressbook look like, for example
create serial letters with a wordprocessing software ?

Is it possible to add own fields ?

best regards
sti


Hello sti,

You should try SuiteCRM, a highly rated open source software, for 
filtering an address book, and creating serial letters.


Best to you

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

Re: [SOGo] Mini Admin Panel Survey

[Chris Coleman]

You should also try iRedMail for administration of Sogo users.

Post your findings back to the list for others to read!




On 12/11/2015 12:15 PM, Michel Memeteau - EKIMIA wrote:

Hi,

this might be slightly off-topic 

We are in the process of selecting a panel for the administration of
the Sogo users, so far we've tested :

- Sogxmail
- Zentyal


I was wondering what people usually use and I'm open for suggestion
with a preference for simplicity over features.

Best regards

Michel Memeteau
Directeur, Ekimia SAS
+33 (0)9 72 30 83 34 | m...@ekimia.fr | Notre WebBoutique :
http://shop.ekimia.fr | 49 chemin union 13720 La bouilladisse
  FRANCE


Contactez nous directement par Tchat sur http://bit.ly/ekichat


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

Re: [SOGo] Mini Admin Panel Survey

[Chris Coleman]

Also try out ClearOS 7 this is another admin panel which supports web 
based administering of your Sogo users




On 12/11/2015 12:48 PM, Chris Coleman wrote:

You should also try iRedMail for administration of Sogo users.

Post your findings back to the list for others to read!




On 12/11/2015 12:15 PM, Michel Memeteau - EKIMIA wrote:

Hi,

this might be slightly off-topic 

We are in the process of selecting a panel for the administration of
the Sogo users, so far we've tested :

- Sogxmail
- Zentyal


I was wondering what people usually use and I'm open for suggestion
with a preference for simplicity over features.

Best regards

Michel Memeteau
Directeur, Ekimia SAS
+33 (0)9 72 30 83 34 | m...@ekimia.fr | Notre WebBoutique :
http://shop.ekimia.fr | 49 chemin union 13720 La bouilladisse
  FRANCE


Contactez nous directement par Tchat sur http://bit.ly/ekichat




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

Re: [SOGo] SOGo 2.3.3 issue: iOS 9 Activesync - Calendar sync only "Personal calendar"

[Chris Coleman]

Yes, read the thread "[SOGo] ANN: SOGo v2.3.3", Ian McMichael had the 
same issue, and shares the solution.



On 11/13/2015 3:32 AM, giova...@neweden.uk.to wrote:

Hello,

I have an issue with SOGo 2.3.3 opening the iOS 9 using Activesync 
only one calendar "Personal Calendar" is synced (which is the 
default). The second calendar called "Default"  was synced without 
issues from the Version 2.3.2 but from SOGo 2.3.3 it isn't accessible 
anymore.


Does anybody of you have the same behaviour with Multiple Calendar and 
ActiveSync?


Giovanni


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

Re: [SOGo] Installproblem

[Chris Coleman]

On 11/4/2015 7:41 PM, Robert Rott wrote:

Hello,
I'm installing Sogo on Debian Jessie an i got a bug.

When I use this code:

openchange_provision --openchangedb --openchangedb-uri 'mysql://openchange-
user[:openchange$123]@localhost/openchange'

I get:

Setting up openchange db
Traceback (most recent call last):
   File "/usr/sbin/openchange_provision", line 128, in 
 openchange.openchangedb_provision(provisionnames, lp,
opts.openchangedb_uri)
   File "/usr/lib/python2.7/dist-packages/openchange/provision.py", line 1312,
in openchangedb_provision
 openchangedb = mailbox.OpenChangeDBWithMysqlBackend(uri, find_setup_dir())
   File "/usr/lib/python2.7/dist-packages/openchange/mailbox.py", line 375, in
__init__
 self._connect_to_mysql()
   File "/usr/lib/python2.7/dist-packages/openchange/mailbox.py", line 300, in
_connect_to_mysql
 host, user, passwd, self.db_name, port = self._parse_mysql_url()
   File "/usr/lib/python2.7/dist-packages/openchange/mailbox.py", line 306, in
_parse_mysql_url
 conn_url = urlparse(self.url)
   File "/usr/lib/python2.7/urlparse.py", line 143, in urlparse
 tuple = urlsplit(url, scheme, allow_fragments)
   File "/usr/lib/python2.7/urlparse.py", line 214, in urlsplit
 raise ValueError("Invalid IPv6 URL")
ValueError: Invalid IPv6 URL

Can someone help me please?

Thanks.

[% user.email %]


Robert,

"ValueError: Invalid IPv6 URL".

The python script sees your two square brackets [ ] in the mysql URL, 
and expects the brackets to contain an IPv6 address, but there is no 
valid IPv6 address in there.


Instead of :

openchange_provision --openchangedb --openchangedb-uri 
'mysql://openchange-user[:openchange$123]@localhost/openchange'

Try:

openchange_provision --openchangedb --openchangedb-uri 
'mysql://openchange-user:openchange-password@localhost/openchange'

Note: your openchange password is best to contain only alphanumeric 
characters because symbols, !@#$%^&*()-_=+[]{}\|;:'",<.>/?`~  etc, could 
cause unexpected errors.


-Chris

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

Re: [SOGo] OpenChange/Samba crashes during folder sync (logs included)

[Chris Coleman]

On 11/4/2015 9:25 AM, Harold Fines wrote:
Bug confirmed, sixstone found it in 
https://github.com/openchange/openchange/blob/master/mapiproxy/servers/default/emsmdb/emsmdbp_object.c#L3603


The lack of chunking in processing client uploads means that the 
process runs out of memory and crashes.


I've made a backtrace with debugoc.py (instructions from sixstone):

[2015-10-29 16:13:24,020] INFO: Retrieving the list of Samba process
[2015-10-29 16:13:24,042] INFO:  3875 ?00:00:00 samba
[2015-10-29 16:13:24,045] INFO:  3876 ?00:00:00 samba
[2015-10-29 16:13:24,047] INFO:  3877 ?00:00:00 samba
GNU gdb (Debian 7.7.1+dfsg-5) 7.7.1
Copyright (C) 2014 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later

This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show
copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
>.
Find the GDB manual and other documentation resources online at:
>.
For help, type "help".
Type "apropos word" to search for commands related to "word".
Attaching to process 3877
Reading symbols from /usr/sbin/samba...Reading symbols from

/usr/lib/debug/.build-id/b2/a767673fffef27fef3e50431ff6ee021c74a48.debug...done.
done.
Reading symbols from
/lib/x86_64-linux-gnu/libpthread.so.0...Reading symbols from
/usr/lib/debug//lib/x86_64-linux-gnu/libpthread-2.19.so...done.
done.
[Thread debugging using libthread_db enabled]
Using host libthread_db library
"/lib/x86_64-linux-gnu/libthread_db.so.1".
Loaded symbols for /lib/x86_64-linux-gnu/libpthread.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/libsamba-util.so.0...Reading symbols
from

/usr/lib/debug/.build-id/3f/d97b13fdebb08b451f89ecc46c9d39d358d3ac.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/libsamba-util.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/samba/libcluster.so.0...Reading symbols
from

/usr/lib/debug/.build-id/75/851ac23b9dde8e9c529ed61dd80dd2109c5ce9.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/samba/libcluster.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/libsamba-credentials.so.0...Reading
symbols from

/usr/lib/debug/.build-id/f3/5f6316588d41b654f6a1cbc017a7fca4353acb.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/libsamba-credentials.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/libsamba-hostconfig.so.0...Reading
symbols from

/usr/lib/debug/.build-id/9a/0047f68d0dbdbced7985d07f7f5146111b95cb.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/libsamba-hostconfig.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/samba/libldbsamba.so.0...Reading symbols
from

/usr/lib/debug/.build-id/1b/c98857cd27e2be39107f841cabc7b7167ac116.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/samba/libldbsamba.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/samba/libcliauth.so.0...Reading symbols
from

/usr/lib/debug/.build-id/6d/88faa7bbcd3cf1c07fbf9919f23312af5d394e.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/samba/libcliauth.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/samba/libservice.so.0...Reading symbols
from

/usr/lib/debug/.build-id/d0/ee23f3d5b5952514bbe2e8b60e814652185e03.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/samba/libservice.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/samba/libauth4.so.0...Reading symbols
from

/usr/lib/debug/.build-id/2b/03fad749dd7a5ee9d3af9a818200282eff6427.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/samba/libauth4.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/samba/libntvfs.so.0...Reading symbols
from

/usr/lib/debug/.build-id/fc/470df7bc302eeb50eb004a30bcd1b799def8d3.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/samba/libntvfs.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/libndr.so.0...Reading symbols from

/usr/lib/debug/.build-id/9c/d176912f6d3fce50519c54b300e7e7e802661d.debug...done.
done.
Loaded symbols for /usr/lib/x86_64-linux-gnu/libndr.so.0
Reading symbols from
/usr/lib/x86_64-linux-gnu/samba/libprocess_model.so.0...Reading
symbols from

/usr/lib/debug/.build-id/2d/3f9094065e92cb6f14b6b524ad9769f44589ed.debug...done.
done.
Loaded symbols for

Re: [SOGo] rpcproxy not working with outlook 2007 / 2010

[Chris Coleman]

On 10/23/2015 4:13 PM, Steve Ankeny wrote:

On 10/23/2015 09:32 AM, Chris Coleman wrote:

And this tip:
"If you face strange issues from Microsoft Outlook, you might want to 
remove any data associated with the user from the SOGo server and 
recreate a Microsoft Outlook profile. To remove any data associated 
to a user, use the openchange_cleanup.py script distributed with 
sogo. The script can be found in |/usr/share/doc/sogo/| 
(|/usr/share/sogo-VERSION/| on |RHEL|). To reset a user, run the 
script as root: |python openchange_cleanup.py username|. See the 
usage output for additional options."


Chris . . .

What is meant by "strange issues?"  Can you give examples?

For instance, I'm receiving, "The name cannot be resolved.  The 
requested operation failed because no search criteria were given to 
the Microsoft Exchange Address Book." -- with errors in 
'/ocsmanager.log' --


Starting server in PID 1885.
serving on http://127.0.0.1:5000
2015-10-17 07:44:28,313 INFO [openchange.web.auth.NTLMAuthHandler] 
[worker 0] client did not pass auth cookie
2015-10-17 07:44:28,321 INFO [openchange.web.auth.NTLMAuthHandler] 
[worker 1] client did not pass auth cookie
2015-10-17 07:44:28,358 INFO [openchange.web.auth.NTLMAuthHandler] 
[worker 1] acquiring lock 
/var/cache/ntlmauthhandler/ntlm-127.0.0.1.lock (1885)
2015-10-17 07:44:29,019 INFO [openchange.web.auth.NTLMAuthHandler] 
[worker 2] acquiring lock 
/var/cache/ntlmauthhandler/ntlm-127.0.0.1.lock (1885)


Would clearing out any existing data and recreating an Outlook profile 
benefit my users?




Steve,

* That quote ("If you face strange issues from Microsoft Outlook, you 
might want to [...] run the script as root: openchange_cleanup.py 
username See the usage output for additional options.") comes from 
openchange 2.0 release notes at this URL:

http://www.openchange.org/developers/relnotes/2.0-quadrant.html
in the section "Known Issues from SOGo backend".
You can and certainly should try it out, clear out and recreate an 
Outlook profile.
I'd test it first.  Make new Outlook user profile, send it some email, 
then use that command line to clear it out (openchange_cleanup.py 
username), see what that does. Recreate the user profile it if the user 
profile for that username was truly removed completely.  Just to be 
totally sure that script works properly, before trying to run the script 
on your real user profile.


* Here is another quote from the same 2.0 release notes, explaining 
exactly how openchange and sogo interoperate.



   "Benefits of SOGo collaboration

OpenChange server and SOGo ( http://www.sogo.nu ) are both groupware 
servers sharing mutual interest in collaborating for the greatest 
benefits of end users. The cement of this cooperation lies in a backend 
developed by Inverse Inc on top of OpenChange API that plugs SOGo 
storage to OpenChange server through SOGo libraries. From a general 
perspective, it can be described as:


 * *OpenChange uses SOGo libraries to store Outlook data*
 * *SOGo uses OpenChange to serve Outlook clients*

In practice, it means that users primarily interested in an Exchange 
compatible server interoperable with Microsoft Outlook clients don't 
need anything but Samba4 and OpenChange. There is no need to run SOGo 
server.


In the meanwhile, as soon as users are looking for Webmail access, 
synchronization with Mozilla Thunderbird/Lighning, Apple iPhone or 
Blackberry, then SOGo server is needed."


* Here is yet another page well worth reading because it explains in 
more detail how OpenChange uses SOGo to store the user's Outlook (MAPI) 
information in what it calls a "MAPIStore".

http://www.openchange.org/documentation/programming/mapistore_python/concepts.html

* I highly suggest having a good read of this series of pages because 
they provide a more in depth look at how OpenChange and SOGo talk to one 
another.


** Did you know the "realm", which you provide in the configuration, 
(for example: mycompany.local which is 15 characters in length ) must be 
14 characters or less in length, to satisfy a Microsoft realm name 
length limit, otherwise strange and/or unpredictable results may occur? 
I didn't know that.  And it's undocumented in the SOGo documentation for 
Native Outlook aka OpenChange, 
http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf 
. Now I know, after having read this openchange "docs" and "cookbook"!

Here is the reference explaining this (it's in the first section):
http://www.openchange.org/cookbook/configuring.html
"For the purpose of this documentation, arbitrary domain (|OC|) and 
realm (|OC.LOCAL|) and passwords (|adminpass| and |user password|) have 
been chosen. Feel free to adjust values to match your requirements.


However, when configuring the domain name during OS installation, it is 
very important *NOT* to choose a realm

Re: [SOGo] ANN: SOGo v3.0 beta 3

[Chris Coleman]

On 10/25/2015 3:25 AM, Christian Naumer wrote:

I have question regarding v3. What are the plans in using the v2 and v3 
interfaces in parallel? I like the new interface a lot on tablets and 
smartphones but on a large screen it does waste some space.

Then as a small bug report in v3 some buttons (vertical dots on calendars and 
mail folders) do not work with Firefox. They do work with chrome.

Regards

If you're sure a reproducible bug, you might want to register on the 
official bug tracker and post the steps to recreate it:

http://www.sogo.nu/bugs/view_all_bug_page.php

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

Re: [SOGo] rpcproxy not working with outlook 2007 / 2010

[Chris Coleman]

On 10/23/2015 7:29 AM, DurgaPrasad - DatasoftComnet wrote:


Hi all,

Can someone respond on this please.

Regards

DP

*From:*DurgaPrasad - DatasoftComnet [mailto:d...@datasoftcomnet.com]
*Sent:* 20 October 2015 20:55
*To:* 'users@sogo.nu'
*Subject:* RE: [SOGo] rpcproxy not working with outlook 2007 / 2010

Hello all,

I have  installed sogo using apt-get.

Followed the guide below. SOGo Native Microsoft Outlook 
Configuration.pdf 
 
(PDF)


Can someone analyse and let me know. I have tried installing from 
scratch (formatting and installing) 2 or 3 times same situation.


Outlook 2007/2010 is not able to connect either through IP or name 
(via hosts file) using native MAPI.

Outlook 2007/2010 not connecting using Outlook Anywhere either.
The certificate is a valid paid cert

Activesync in 2013 works but I don’t want that.

Regards

DP

*From:*users-requ...@sogo.nu  
[mailto:users-requ...@sogo.nu] *On Behalf Of *Martin Simovic

*Sent:* 05 October 2015 15:59
*To:* users@sogo.nu 
*Subject:* Re: [SOGo] rpcproxy not working with outlook 2007 / 2010

Hi,

On 04 Oct 2015, at 16:13, > > wrote:

Hello all,
Ive checked thoroughly that outlook is not able to wotj with sogo
using native
mode.
below are the facts.

Environment
Ubuntu LTS trusty, Samba4 native mode., dovecot, postfix,sogo,
ocsmanager with
rpcproxy installed.
Webmail  - working
Activesync - working
IMAP/POP3 - working.

Outlook 2007/2010 is not able to connect either through IP or name
(via hosts
file) using native MAPI. (does this work on LAN only)
Outlook 2007/2010 not connecting using Outlook Anywhere either.
The certificate is a valid paid cert
this is what I get in the access.log of apache2

[04/Oct/2015:19:34:51 +0530] "RPC_IN_DATA /rpc/rpcproxy.dll?
mail.mydomain.com :6004 HTTP/1.1" 401
5757 "-" "MSRPC"
[04/Oct/2015:19:34:52 +0530] "RPC_OUT_DATA /rpc/rpcproxy.dll?
mail.mydomain.com :6004 HTTP/1.1" 401
5757 "-" "MSRPC"

mail.mydomain.com  is a placeholder. the
6004 used to be 6002 an hour back so
it might not be relavent.

when I use activesync the username is seen
POST /Microsoft-Server-ActiveSync?
User=x...@mydomain.com

=JF48EU1D7D0LL5QBAWWS3EVDQ0=iPhone=Ping
HTTP/1.1" 200 825 "-" "Apple-iPhone7C1/1301.404"

Can someone through some light on this?

I order to help you please post your smb.conf and ocsmanager.ini 
files. It’d also help if you stated how you installed your environment 
(compiling from source, installing from packages - if so, wha is 
package source (sogo , zentyal?)


Regards

Martin.


Durga,

I think the documentation is not perfect.

If you are having trouble logging in with native Outlook clients (MAPI), 
and same trouble with Outlook Anywhere, then you are missing the 
OpenChange part.  This OpenChange talks to SOGo for storing Outlook 
data, and talks to users Outlook clients with the outlook/exchange 
specific microsoft protocols.


Read more here:
http://www.openchange.org/developers/relnotes/2.0-quadrant.html

See section "Benefits of SOGo collaboration".

And this tip:
"If you face strange issues from Microsoft Outlook, you might want to 
remove any data associated with the user from the SOGo server and 
recreate a Microsoft Outlook profile. To remove any data associated to a 
user, use the openchange_cleanup.py script distributed with sogo. The 
script can be found in |/usr/share/doc/sogo/| 
(|/usr/share/sogo-VERSION/| on |RHEL|). To reset a user, run the script 
as root: |python openchange_cleanup.py username|. See the usage output 
for additional options."


The current release notes May 2015:
http://www.openchange.org/developers/relnotes/2.3-vulcan.html

If you have an issue with openchange, then click New Issue on the 
openchange github.

https://github.com/openchange/openchange/issues

If you want an easy solution for outlook compatible email server, based 
on samba4, sogo and openchange, you could try the free zentyal community 
server, it manages the configuration files for you, so you don't have to 
learn how to set them manually.


Good luck. Post back your results.

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

Re: [SOGo] SOGo installation with Apache2

[Chris Coleman]

What does the SOGo acronym stand for?

*OGo = O*pen*G*roupware.*o*rg
http://www.opengroupware.org/en/about/index.html

"MDlink GmbH, the original author of the OpenGroupware.org reference 
server, was founded as an Internet service provider (ISP) in Germany in 
1994. The company started development on the LSOffice application server 
in about 1996 to extend it's Internet offerings with a powerful 
collaboration platform usable over the Internet.


Some years later LSOffice was renamed to SKYRiX 3 and finally in 2000 a 
separate company, SKYRIX Software AG , was 
forked to concentrate on the further development of the product.


The SKYRiX Groupware Server is certainly one of the earliest GNU/Linux 
based groupware solutions (being now, in [2015], about [nineteen] years 
old).


The OpenGroupware.org source code initially includes the technology 
SKYRIX Software AG  has been developing for the 
future versions of the SKYRiX groupware server. *The source is mainly 
written in Objective-C and delivers language-neutral and scriptable 
functionality, including XML interfaces.*


/Differences between OpenGroupware.org and SKYRiX/

Starting with the launch of OpenGroupware.org, SKYRiX becomes an 
enterprise *distribution* of the OpenGroupware.org software. That is, 
SKYRiX is a maintained selection of stable parts of the OGo sources.
The SKYRiX distribution also includes some additional software which is 
not available as part of the OpenGroupware.org project, like:


 * Application Level Load Balancer (snsd)
 * Various other SKYRiX 5 User Interface Themes
 * Support for Oracle and Sybase databases
 * CTI Support for CSTA based telephone switches
 * Outlook Support for ZideStore"


*SOGo = S*calable*O*pen*G*roupware.*o*rg
http://www.scalableogo.org/
http://www.sogo.nu/
Developed today by inverse (Canada).
SOGo uses OpenChange to provide native Outlook/Exchange protocol 
compatibility, which is developed by Zentyal (Spain).





On 10/20/2015 11:25 AM, Michael Angelozzi wrote:

Hi All,

Firstly, what does SOGo stand for? I have googled intensively and only 
come up with Society Of  Gas Operators, which I am i sure it does not 
stand for.

My guess would be: Super Openexchange Groupware O???

So I am trying to install SOGo on Ubuntu server 14.04.

I installed Apache2 which used to serve up a very simple page (as you 
will see below it is now broken).

I installed mysql-server.
I installed Postfix with Dovecot using: sudo apt-get -y install 
mail-stack-delivery
I did not install OpenLDAP because at the moment there is just myself 
in my company. I would rather use a the MySQL database to store the users.


Then I installed SOGo, and I noticed towards the end of the 
installation Apache2 fell over:

Setting up sogo:amd64 (2.3.2-1) ...
apache2_invoke: Enable configuration SOGo
Action 'configtest' failed.
The Apache error log may have more information.
apache2_reload: Your configuration is broken. Not reloading Apache 2
 * Starting SOGo 
sogo [ OK ]*

*
I checked the Apache log and there was nothing helpful.

This is what is in the SOGo conf file:
sudo nano /etc/apache2/conf-enabled/SOGo.conf
shows:
Line 47: ProxyRequests Off
Line 48: SetEnv proxy-nokeepalive 1
Line 49: ProxyPreserveHost On

I ran the following command:
apachectl configtest

And got:
AH00526: Syntax error on line 47 of /etc/apache2/conf-enabled/SOGo.conf:
Invalid command 'ProxyRequests', perhaps misspelled or defined by a 
module not included in the server configuration

Action 'configtest' failed.
So Commented out line 47, because Off is the default value in the 
Apache documentation anyway.


Then I tried again and this time the same error but for line 49:
AH00526: Syntax error on line 49 of /etc/apache2/conf-enabled/SOGo.conf:
Invalid command 'ProxyPreserveHost', perhaps misspelled or defined by 
a module not included in the server configuration

Action 'configtest' failed.

I figured it would be unwise to just keep commenting out stuff.
Any suggestions?

The SOGO Installation Guide.pdf page 45 says:
/"The SOGo configuration for Apache is located in 
/etc/httpd/conf.d/SOGo.conf"/

But I dont have a file there?

Not sure how to proceed.

Kind Regards
Michael


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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/16/2015 9:18 AM, Martin Simovic wrote:



On 15 Oct 2015, at 18:13, Chris Coleman <ch...@espacenetworks.com 
<mailto:ch...@espacenetworks.com>> wrote:




On 10/15/2015 10:32 AM, Martin Simovic wrote:



On 14 Oct 2015, at 21:06, Chris Coleman <ch...@espacenetworks.com> 
wrote:


You can try:
sudo openchange_provision --standalone --ignore_already_exists


This command line switch seems to be unimplemented: 
openchange_provision: error: no such option: —ignore_already_exists


I am using openchange 3:2.4-zentyal6 package from inverse 
repository. Maybe the way to go is to delete 
the CN=ms-Exch-Access-Control-Map attribute directly from directory? 
I am going to find out the hard way ..


Regards
Martin.
Sorry, try --ignore-already-exists (instead of 
--ignore_already_exists), e.g.

sudo openchange_provision --standalone --ignore-already-exists


Yes, that works, Thanks. Now I get further but:

root@pdc:~# openchange_provision --standalone --ignore-already-exists
NOTE: This operation can take several minutes
[+] Step 1: Register Exchange OIDs
[+] Step 2: Add Exchange attributes to Samba schema
[+] Step 3: Add Exchange auxiliary classes to Samba schema
[+] Step 4: Add Exchange objectCategory to Samba schema
[+] Step 5: Add Exchange containers to Samba schema
[+] Step 6: Add Exchange *sub* containers to Samba schema
[+] Step 7: Add Exchange CfgProtocol subcontainers to Samba schema
[+] Step 8: Add Exchange mailGateway subcontainers to Samba schema
[+] Step 9: Add Exchange classes to Samba schema
[+] Step 10: Add possSuperior attributes to Exchange classes
No elements to add found in 
/usr/share/samba/setup/AD/oc_provision_schema_possSuperior.ldif

[+] Step 11: Extend existing Samba classes and attributes
No elements to add found in 
/usr/share/samba/setup/AD/oc_provision_schema_modify.ldif

[+] Step 12: Generic Exchange configuration objects
[+] Step 13: Exchange Organization objects
Error: "(64, 'structural objectClass msExchAdminGroup is not a valid 
child class for CN=Administrative Groups,CN=First 
Organization,CN=Microsoft 
Exchange,CN=Services,CN=Configuration,DC=example,DC=com')" when adding 
element:


And I continue stuck. Still unable to provision entirely or 
deprovision either.


Best Regards
Martin.



1. You could play around with it, try to manually deprovision everything 
(users, groups, organizations) before doing the openchange_provision.

sudo openchange_newuser --deprovision 
sudo openchange_group --delete 
sudo openchange_neworganization --deprovision 
sudo openchange_provision --standalone


2. And... would you kindly report this as a new issue on github and 
include all the details in the above post for javier to look over, 
because your "openchange_provision --standalone --ignore-already-exists" 
really should've worked, and if not, that's a bug.  At the very least, 
it should've told you a better error message, and explain to you what 
when wrong, what you need to do, and why.

https://github.com/openchange/openchange/issues/new


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

Re: [SOGo] Openchange creating distribution group

[Chris Coleman]

On 10/15/2015 3:43 PM, Gerald Brandt wrote:



On 2015-10-15 02:33 PM, Gerald Brandt wrote:



On 2015-10-15 12:37 PM, Chris Coleman wrote:

On 10/15/2015 11:37 AM, Gerald Brandt wrote:
If I create a distribution group using OpenChange, do standard IMAP 
users also get access to that group?


I'm a bit confused on how tightly integrated everything is with 
OpenChnage/SOGo/IMAP/SMTP, etc.




In creating a distribution list you are supposed to assign an email 
address to it either explicitly or the system auto-assigns one. From 
that point any email sent to that email address is forwarded to all 
members of the distribution list. Try sending an email and see if it 
works.


Also Zentyal which is built on openchange and sogo, supports 
distribution lists, see here:
https://wiki.zentyal.org/wiki/En/4.1/OpenChange_%28Microsoft%28R%29_Exchange_Server_protocol_implementation%29 




Hi,

I've managed to create a distribution group, with an email address, 
but the mail bounces 'no valid user'.


Gerald

There's gotta be something I'm missing.  It can't be this complex to 
add users and distribution groups to openchnage.  Does anyone else do it?


Gerald


Here is some more info on groups in sogo!

http://www.sogo.nu/nc/support/faq/article/how-are-groups-handled-in-sogo.html
"

From the version 1.0.2 of SOGo, groups are now supported. Groups *have* 
to be defined in an LDAP server and *must* have an email address. They 
can be used in SOGo when :


 * defining ACLs on calendars and address books
 * scheduling meetings

When either settings ACLs or scheduling a meeting, a resource (person, 
group, room, etc.) has to be specified. Upon save, SOGo will lookup the 
LDAP entry of that particular resource in order to detect if a group was 
specified. To detect if a group was specified, SOGo will look at the 
/objectClass/ attributes of the returned entry. If one of the 
/objectClass/ attribute is equal to /group/, /groupOfNames/, 
/groupOfUniqueNames/ or /posixGroup/, the entry is considered to be a group.


When scheduling a meeting with a group, SOGo will decompose the group as 
soon as the event is saved. Groups decomposition consist of fetching the 
members of the groups - replacing groups with their members in the 
attendees list.


As an exemple, if you have a "management" group defined in your LDAP 
server as :


dn: cn=management,ou=groups,dc=inverse,dc=ca
objectClass: top
objectClass: groupOfNames
cn: management
mail: managem...@inverse.ca
member: cn=bob,ou=people,dc=inverse,dc=ca
member: cn=alice,ou=people,dc=inverse,dc=ca

When you actually add "/managem...@inverse.ca/" in the attendee list 
while creating an event, Bob and Alice will actually receive the 
invitation and will be present in the attendee list.


Note that the groups support is a work in progress. Support for dynamic 
groups needs to be added.


June 08 2009 16:12"

You should post a bug about creating distribution groups for sogo, on 
command line with openchange commands, mail addresses expanding 
incorrectly, with full details. It's a too essential of a feature for it 
not to be working smoothly.

http://www.sogo.nu/bugs/my_view_page.php

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

Re: [SOGo] Openchange creating distribution group

[Chris Coleman]

On 10/15/2015 3:33 PM, Gerald Brandt wrote:



On 2015-10-15 12:37 PM, Chris Coleman wrote:

On 10/15/2015 11:37 AM, Gerald Brandt wrote:
If I create a distribution group using OpenChange, do standard IMAP 
users also get access to that group?


I'm a bit confused on how tightly integrated everything is with 
OpenChnage/SOGo/IMAP/SMTP, etc.




In creating a distribution list you are supposed to assign an email 
address to it either explicitly or the system auto-assigns one. From 
that point any email sent to that email address is forwarded to all 
members of the distribution list.  Try sending an email and see if it 
works.


Also Zentyal which is built on openchange and sogo, supports 
distribution lists, see here:
https://wiki.zentyal.org/wiki/En/4.1/OpenChange_%28Microsoft%28R%29_Exchange_Server_protocol_implementation%29 




Hi,

I've managed to create a distribution group, with an email address, 
but the mail bounces 'no valid user'.


Gerald

I would suggest to create a new Issue here, because it should work, and 
since not, either you've made a minor omission with the undocumented 
command line commands, or maybe it's a bug. Please post back your 
results to the list.

https://github.com/openchange/openchange/issues

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

Re: [SOGo] Documentation on OpenChange tools?

[Chris Coleman]

On 10/15/2015 1:13 PM, Gerald Brandt wrote:



On 2015-10-15 11:19 AM, Chris Coleman wrote:



On 10/15/2015 11:15 AM, Gerald Brandt wrote:

Hi,

Where would I find docs on the OpenChange tools (openchange_newuser, 
openchange_group, etc)?  I can't seem to find anything on the 
openchange site.


I understand I can user RSAT to do most of the management (except 
adding a new user, see my previous emails), but I'd still like info 
on the local tools.  I hate having to go to two different places to 
get work done.


Thanks,
Gerald


Gerald, all,

After some search engine, I believe there is no documentation online 
for these openchange command line tools!


Here is the list of them direct from the source:
https://github.com/openchange/openchange/tree/master/setup

openchange_group
openchange_migrate
openchange_neworganization
openchange_newuser
openchange_provision

To find the options I dug into the python source.

What I discovered is, you Invoke each command without options and it 
will print the help/usage.


-Chris



Hi,

The online help is slim at best.  For example, when creating a group, 
how do I differentiate between a security and a distribution group?  
Is it by adding the --mail address?


I dunno.

Gerald

From reading the comments in the source, I believe you're right about 
that, the mail attribute creates a distribution group.

https://github.com/openchange/openchange/blob/master/python/openchange/provision.py
Line 772
search for keyword "newgroup"

Who knows, maybe distribution groups failing to send mail to their 
members could be a known openchange bug/limitation. But, unsure about 
that, because Zentyal runs on openchange and supports distribution groups:

http://www.zentyal.org/server/

So, I highly recommend creating a github "issue" on openchange, with 
full details so the dev can take a look and give you his official answer.

https://github.com/openchange/openchange/issues/new


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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/15/2015 10:32 AM, Martin Simovic wrote:



On 14 Oct 2015, at 21:06, Chris Coleman <ch...@espacenetworks.com 
<mailto:ch...@espacenetworks.com>> wrote:


You can try:
sudo openchange_provision --standalone --ignore_already_exists


This command line switch seems to be unimplemented: 
openchange_provision: error: no such option: —ignore_already_exists


I am using openchange 3:2.4-zentyal6 package from inverse repository. 
Maybe the way to go is to delete the CN=ms-Exch-Access-Control-Map 
attribute directly from directory? I am going to find out the hard way ..


Regards
Martin.
Sorry, try --ignore-already-exists (instead of --ignore_already_exists), 
e.g.

sudo openchange_provision --standalone --ignore-already-exists


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

Re: [SOGo] Documentation on OpenChange tools?

[Chris Coleman]

On 10/15/2015 11:15 AM, Gerald Brandt wrote:

Hi,

Where would I find docs on the OpenChange tools (openchange_newuser, 
openchange_group, etc)?  I can't seem to find anything on the 
openchange site.


I understand I can user RSAT to do most of the management (except 
adding a new user, see my previous emails), but I'd still like info on 
the local tools.  I hate having to go to two different places to get 
work done.


Thanks,
Gerald


Gerald, all,

After some search engine, I believe there is no documentation online for 
these openchange command line tools!


Here is the list of them direct from the source:
https://github.com/openchange/openchange/tree/master/setup

openchange_group
openchange_migrate
openchange_neworganization
openchange_newuser
openchange_provision

To find the options I dug into the python source.

What I discovered is, you Invoke each command without options and it 
will print the help/usage.


-Chris

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

Re: [SOGo] Openchange creating distribution group

[Chris Coleman]

On 10/15/2015 11:37 AM, Gerald Brandt wrote:
If I create a distribution group using OpenChange, do standard IMAP 
users also get access to that group?


I'm a bit confused on how tightly integrated everything is with 
OpenChnage/SOGo/IMAP/SMTP, etc.




In creating a distribution list you are supposed to assign an email 
address to it either explicitly or the system auto-assigns one. From 
that point any email sent to that email address is forwarded to all 
members of the distribution list.  Try sending an email and see if it works.


Also Zentyal which is built on openchange and sogo, supports 
distribution lists, see here:

https://wiki.zentyal.org/wiki/En/4.1/OpenChange_%28Microsoft%28R%29_Exchange_Server_protocol_implementation%29

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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/14/2015 7:56 AM, Steve Ankeny wrote:

On 10/14/2015 12:25 AM, Chris Coleman wrote:
It appears that the openchange.org documentation page is showing an 
example of how to setup a zentyal server for an openchange developer 
to run code against the server, with python scripts included to help 
get it going for the tutorial. It seems in a different order but 
really all it means is you should do all the things in the sogo PDF 
setup document for openchange (native outlook client compatibility 
PDF) first, which initializes certain data inside the databases, so 
that their openchange developer server setup doesn't produce errors 
due to uninitialized data.


I'm stuck!  Running, 'sudo openchange_provision --standalone' FAILS

This is after I successfully ran 'sudo openchange_provision --deprovision'

It fails with the following errors --

adam@sogo:~$ sudo openchange_provision --standalone
NOTE: This operation can take several minutes
[+] Step 1: Register Exchange OIDs
[+] Step 2: Add Exchange attributes to Samba schema
Error: "(68, 'Entry 
CN=ms-Exch-Access-Control-Map,CN=Schema,CN=Configuration,DC=smbdomain,DC=com 
*already exists*')" when adding element:

#
# ms-Exch-Access-Control-Map
# Contains the mapping for the access controls.
#
dn: 
CN=ms-Exch-Access-Control-Map,CN=Schema,CN=Configuration,DC=smbdomain,DC=com

objectClass: top
objectClass: attributeSchema
cn: ms-Exch-Access-Control-Map
distinguishedName: 
CN=ms-Exch-Access-Control-Map,CN=Schema,CN=Configuration,DC=smbdomain,DC=com

attributeID: 1.2.840.113556.1.4.7000.102.64
attributeSyntax: 2.5.5.12
isSingleValued: TRUE
showInAdvancedViewOnly: TRUE
adminDisplayName: ms-Exch-Access-Control-Map
adminDescription: ms-Exch-Access-Control-Map
oMSyntax: 64
searchFlags: 0
lDAPDisplayName: msExchAccessControlMap
name: ms-Exch-Access-Control-Map
#schemaIDGUID: 8ff54464-b093-11d2-aa06-00c04f8eedd8
isMemberOfPartialAttributeSet: FALSE
objectCategory: 
CN=Attribute-Schema,CN=Schema,CN=Configuration,DC=smbdomain,DC=com


[!] error while provisioning the Exchange schema classes (68): Entry 
CN=ms-Exch-Access-Control-Map,CN=Schema,CN=Configuration,DC=smbdomain,DC=com 
*already exists*

Traceback (most recent call last):
  File "/usr/sbin/openchange_provision", line 115, in 
*ignore_already_exists*=opts.ignore_already_exists)
  File "/usr/lib/python2.7/dist-packages/openchange/provision.py", 
line 1062, in provision

*ignore_already_exists*=ignore_already_exists)
  File "/usr/lib/python2.7/dist-packages/openchange/provision.py", 
line 470, in install_schemas

*ignore_already_exists*=ignore_already_exists)
  File "/usr/lib/python2.7/dist-packages/openchange/provision.py", 
line 251, in provision_schema

ldif_apply_method(el, ['relax:0'])
  File "/usr/lib/python2.7/dist-packages/samba/__init__.py", line 224, 
in add_ldif

self.add(msg, controls)
_*ldb.LdbError*: (68, 'Entry 
CN=ms-Exch-Access-Control-Map,CN=Schema,CN=Configuration,DC=smbdomain,DC=com 
*already exists*')

adam@sogo:~$

Are there any switches I can use with the command to provision that 
EXCEPTS these errors?


And, where can I find this stuff on my own?  Documentation is SCARCE 
with OpenChange, IMO


Thanks for all your help!  I know it's not your responsibility but 
it's appreciated.




Steve
I provided you that previous tip by reading the openchange source and 
determining what commands and options it really needed from you at that 
point.
Try posting this issue at the following github repo, with full details, 
this is the developer of openchange:

https://github.com/openchange/openchange
Click Issues / New Issue.
Paste in this thread.
And post back your results!
Agreed that openchange and sogo documentation is less clear and concise 
than it should be for the end user to be able to quickly and simply 
accomplish all the usual administrative setup tasks.  There seems to be 
no documentation at all on the command line commands.
The openchange_provision error messages, and all the error messages, 
could/should be more helpful in terms of explaining what you need to do, 
why, and how.

-Chris

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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/14/2015 7:58 AM, Steve Ankeny wrote:

On 10/14/2015 12:25 AM, Chris Coleman wrote:
It appears that the openchange.org documentation page is showing an 
example of how to setup a zentyal server for an openchange developer 
to run code against the server, with  python scripts included to help 
get it going for the tutorial.  It seems in a different order but 
really all it means is you should do all the things in the sogo PDF 
setup document for openchange (native outlook client compatibility 
PDF) first, which initializes certain data inside the databases, so 
that their openchange developer server setup doesn't produce errors 
due to uninitialized data.


forgot to say, I am considering removing ALL of OpenChange (maybe even 
purging) and starting again


Would this be the best way around my problem?



You can try:
sudo openchange_provision --standalone --ignore_already_exists

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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/13/2015 3:37 PM, Steve Ankeny wrote:

On 10/13/2015 02:52 PM, Chris Coleman wrote:



On 10/13/2015 1:55 PM, Steve Ankeny wrote:

On 10/13/2015 07:12 AM, Steve Ankeny wrote:

On 10/12/2015 05:36 PM, Chris Coleman wrote:



On 10/12/2015 12:20 PM, Steve Ankeny wrote:

On 10/12/2015 10:28 AM, Chris Coleman wrote:
You have to deactivate each of your 8 user mailboxes before the 
command to deprovision the server will work.
Try to devprovision the users with the commands shown at the 
bottom of this page:
http://www.openchange.org/documentation/howto/zentyal_developer.html 



on the site listed above, I see the following --

"You MUST create the OpenChange user and log into its mailbox once 
with Outlook prior following this guide."


I've never seen documentation telling me to login with Outlook using 
the 'openchange-user' account.  I've tested the account in MySQL by 
logging in as 'openchange-user' but never using Outlook, Dovecot, etc.


Could this be why so many are having issues with OpenChange? What is 
the purpose of this login?



Yes, it's probable that using Outlook, as documented, to do a first 
login as "openchange-user", will create/initialize some basic 
required data, which will be needed for the proper running openchange.


You should try and do that first login as openchange-user, and see if 
the issues with OpenChange are resolved, and post your results back 
to the list.



will do . . .

I'm in the midst of provisioning OpenChange (after hours)

Am I reading it correctly, "Login as 'openchange-user' with Outlook 
AFTER following the guide?"


In other words, speaking the language of the SOGo Outlook 
Configuration guide --


(1) install the OpenChange packages
(2) create the 'openchange-user'
(3) provision the server as '--standalone' and '--openchangedb 
--openchangedb-uri', etc.
(4) THEN login as 'openchange-user' FIRST before attempting to 
configure any other user


There's a typo in the instructions on that page if I'm reading it right.


It appears that the openchange.org documentation page is showing an 
example of how to setup a zentyal server for an openchange developer to 
run code against the server, with  python scripts included to help get 
it going for the tutorial.  It seems in a different order but really all 
it means is you should do all the things in the sogo PDF setup document 
for openchange (native outlook client compatibility PDF) first, which 
initializes certain data inside the databases, so that their openchange 
developer server setup doesn't produce errors due to uninitialized data.


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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/14/2015 4:15 PM, Steve Ankeny wrote:

On 10/14/2015 03:06 PM, Chris Coleman wrote:



On 10/14/2015 7:58 AM, Steve Ankeny wrote:

On 10/14/2015 12:25 AM, Chris Coleman wrote:
It appears that the openchange.org documentation page is showing an 
example of how to setup a zentyal server for an openchange 
developer to run code against the server, with  python scripts 
included to help get it going for the tutorial.  It seems in a 
different order but really all it means is you should do all the 
things in the sogo PDF setup document for openchange (native 
outlook client compatibility PDF) first, which initializes certain 
data inside the databases, so that their openchange developer 
server setup doesn't produce errors due to uninitialized data.


forgot to say, I am considering removing ALL of OpenChange (maybe 
even purging) and starting again


Would this be the best way around my problem?



You can try:
sudo openchange_provision --standalone --ignore_already_exists


thx, Chris . . .

I'll try this, and if not successful, post my errors on the 
developer's list as you suggest.



Great Steve, I wager that posting issues to github regarding this 
command line stuff, would help the openchange devs realize that the 
openchange documentation is in need of improvement.  A full list of all 
commands and their parameters and explain what they are intended for 
would be great.


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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/13/2015 1:55 PM, Steve Ankeny wrote:

On 10/13/2015 07:12 AM, Steve Ankeny wrote:

On 10/12/2015 05:36 PM, Chris Coleman wrote:



On 10/12/2015 12:20 PM, Steve Ankeny wrote:

On 10/12/2015 10:28 AM, Chris Coleman wrote:
You have to deactivate each of your 8 user mailboxes before the 
command to deprovision the server will work.
Try to devprovision the users with the commands shown at the 
bottom of this page:

http://www.openchange.org/documentation/howto/zentyal_developer.html


on the site listed above, I see the following --

"You MUST create the OpenChange user and log into its mailbox once 
with Outlook prior following this guide."


I've never seen documentation telling me to login with Outlook using 
the 'openchange-user' account.  I've tested the account in MySQL by 
logging in as 'openchange-user' but never using Outlook, Dovecot, etc.


Could this be why so many are having issues with OpenChange?  What is 
the purpose of this login?



Yes, it's probable that using Outlook, as documented, to do a first 
login as "openchange-user", will create/initialize some basic required 
data, which will be needed for the proper running openchange.


You should try and do that first login as openchange-user, and see if 
the issues with OpenChange are resolved, and post your results back to 
the list.


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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/12/2015 10:07 AM, Steve Ankeny wrote:

On 10/07/2015 11:23 PM, Chris Coleman wrote:



On 10/7/2015 4:46 PM, Mario Gruenwald wrote:

Unfortunately this issue is still open. Nobody here who can help me?

kindly regards
Mario

On Fri, Aug 21, 2015 at 10:15:39AM +0200, Mario Gruenwald wrote:

Hi

I guess my openchange config is broken. Therefore i want to cleanup and
restart from beginning. Problem is:

# openchange_provision --deprovision
[!] Unable to unregister this server, it's being used for: handling 2 mailboxes

I already searched in documentation and forums without success. There are a
lot of commands (openchangeclient, mapiprofile, sogo-tool, ...). I don't know
which to use and/or doesn't find the correct options.

I am even not able to list which users are in openchange and which mailboxes
are handled.

Anyone out there, who can help me?

regards
Mario


Mario,
Zentyal are the maintainers of openchange.
The exact instructions to deprovision openchange, with explanation, 
are here:

http://labs.zentyal.org/zentyal-openchange-as-an-additional-exchange-server/
Search in the page for keyword "Step 6".
Here is the text, without the screenshots.


"Step 6 – Undo the traveled road

If for any reason, you want to uninstall the openchange service, one 
of the features added with Zentyal 3.4 is a way to do that. However, 
to be able to do it, you should not be using any resource from that 
server. Basically, you need to move, disable or remove all mailboxes 
hosted on it.


OpenChange deprovision fails because there is an active mailbox

Zentyal does not support yet any way to move mailboxes from one 
server to other server, so you would need to use Microsoft Exchange 
tools if you want to keep those mailboxes. In this guide we are going 
to just disable it.


OpenChange mailbox deactivation

We are now ready to deprovision OpenChange:

OpenChange deprovision is successful

And we can see that this server is not available anymore from Windows"



Was the original poster Mario able to complete the '--deprovision' 
operation?


I've not been able to --

adam@sogo:~$ sudo openchange_provision --deprovision
[!] Unable to unregister this server, it's being used for: handling 8 
mailboxes

adam@sogo:~$


You have to deactivate each of your 8 user mailboxes before the command 
to deprovision the server will work.
Try to devprovision the users with the commands shown at the bottom of 
this page:

http://www.openchange.org/documentation/howto/zentyal_developer.html

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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/12/2015 12:20 PM, Steve Ankeny wrote:

On 10/12/2015 10:28 AM, Chris Coleman wrote:
You have to deactivate each of your 8 user mailboxes before the 
command to deprovision the server will work.
Try to devprovision the users with the commands shown at the bottom 
of this page:

http://www.openchange.org/documentation/howto/zentyal_developer.html


ok . . .

first of all, there is no 'backends' folder at 
'/usr/lib/python2.7/dist-packages/openchange/'


secondly, the only 'sample.py' is found at 
'/usr/lib/python2.7/dist-packages/twisted/trial/test/sample.py'


using THAT 'sample.py' to '--deprovision' results in the following --

adam@sogo:~$ sudo python 
/usr/lib/python2.7/dist-packages/twisted/trial/test/sample.py -d0 
--deprovision --username=michael

adam@sogo:~$

ran it for each of 8 users, then reran the 'openchange_provision 
--deprovision" command --


adam@sogo:~$ sudo openchange_provision --deprovision
[!] Unable to unregister this server, it's being used for: handling 8 
mailboxes

adam@sogo:~$





Do this:
sudo openchange_newuser --disable 
sudo openchange_newuser --disable 
sudo openchange_newuser --disable 
etc...
sudo openchange_provision --deprovision

If that doesn't work, do this:
sudo openchange_newuser --delete 
sudo openchange_newuser --delete 
etc...
sudo openchange_provision --deprovision


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

Re: [SOGo] Deprovision openchange

[Chris Coleman]

On 10/7/2015 4:46 PM, Mario Gruenwald wrote:

Unfortunately this issue is still open. Nobody here who can help me?

kindly regards
Mario

On Fri, Aug 21, 2015 at 10:15:39AM +0200, Mario Gruenwald wrote:

Hi

I guess my openchange config is broken. Therefore i want to cleanup and
restart from beginning. Problem is:

# openchange_provision --deprovision
[!] Unable to unregister this server, it's being used for: handling 2 mailboxes

I already searched in documentation and forums without success. There are a
lot of commands (openchangeclient, mapiprofile, sogo-tool, ...). I don't know
which to use and/or doesn't find the correct options.

I am even not able to list which users are in openchange and which mailboxes
are handled.

Anyone out there, who can help me?

regards
Mario


Mario,
Zentyal are the maintainers of openchange.
The exact instructions to deprovision openchange, with explanation, are 
here:

http://labs.zentyal.org/zentyal-openchange-as-an-additional-exchange-server/
Search in the page for keyword "Step 6".
Here is the text, without the screenshots.


   "Step 6 – Undo the traveled road

If for any reason, you want to uninstall the openchange service, one of 
the features added with Zentyal 3.4 is a way to do that. However, to be 
able to do it, you should not be using any resource from that server. 
Basically, you need to move, disable or remove all mailboxes hosted on it.


OpenChange deprovision fails because there is an active mailbox

Zentyal does not support yet any way to move mailboxes from one server 
to other server, so you would need to use Microsoft Exchange tools if 
you want to keep those mailboxes. In this guide we are going to just 
disable it.


OpenChange mailbox deactivation

We are now ready to deprovision OpenChange:

OpenChange deprovision is successful

And we can see that this server is not available anymore from Windows"

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

Re: R: R: R: [SOGo] sogo configuration file

[Chris Coleman]

What version of sogo are you on ?

On 9/17/2015 2:27 AM, Daniele Borini wrote:

Trying with:
su - sogo -s /bin/bash
and
defaults write sogod SOGoSieveScriptsEnabled "YES"

worked fine, it writes config statements in
/home/sogo/GNUstep/Defaults/sogod.plist
sogo uses that configuration file which is in "XML" format:
...
SOGoMailAuxiliaryUserAccountsEnabled
 NO
...

Now, i'll try to change that file for my need even if it's quite strange
we're not able to use /etc/sogo/sogo.conf.

thanks



Daniele Borini


Via Provinciale per Sacca, 55 - 43052 - Colorno - Italy
tel +39 0521319316
fax +39 0521319322
borini-effegidi.it
e-mail d.bor...@effegidi.it
www.effegidi.it
Prima di stampare,pensa all'ambiente ** Think about the environment before
printing


-Messaggio originale-
Da: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Per conto di Chris
Coleman
Inviato: mercoledì 16 settembre 2015 17:36
A: users@sogo.nu
Oggetto: Re: R: R: [SOGo] sogo configuration file



On 9/16/2015 2:13 AM, Daniele Borini wrote:

I did,
firstly i dumped sogo con into sogo.conf file:
sudo -u sogo sogo-tool dump-defaults > /etc/sogo/sogo.conf

then i changed something into /etc/sogo/sogo.conf file like
WOWorkersCount from 10 to 11 and WOLogFile from sogo.log to sogoo.log.
restarting sogo with /etc/init.d/sogo restart checked running sogo
configuration with sudo -u sogo sogo-tool dump-defaults but nothing
changed from the original configuration.



Daniele Borini


Via Provinciale per Sacca, 55 - 43052 - Colorno - Italy tel +39
0521319316 fax +39 0521319322 borini-effegidi.it e-mail
d.bor...@effegidi.it www.effegidi.it Prima di stampare,pensa
all'ambiente ** Think about the environment before printing


-Messaggio originale-
Da: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Per conto di
Chris Coleman
Inviato: martedì 15 settembre 2015 17:00
A: users@sogo.nu
Oggetto: Re: R: [SOGo] sogo configuration file

On 9/15/2015 3:48 AM, Daniele Borini wrote:

No way,
i tried to change /usr/.GNUStepDefaults rebooting server but sogo
doesn't accept changes i really don't know where configuration file is.

Daniele Borini


Via Provinciale per Sacca, 55 - 43052 - Colorno - Italy tel +39
0521319316 fax +39 0521319322 borini-effegidi.it e-mail
d.bor...@effegidi.it www.effegidi.it Prima di stampare,pensa
all'ambiente ** Think about the environment before printing


-Messaggio originale-
Da: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Per conto di
Christian Mack
Inviato: lunedì 14 settembre 2015 16:46
A: users@sogo.nu
Oggetto: Re: [SOGo] sogo configuration file

Hello

Am 11.09.2015 um 14:01 schrieb Daniele Borini:

i’m changing sogo configuration, expecially user sourcers part due
to mailserver changes.

I need to swtich from ldap auth to mysql auth.

I’m really not able to find where configuration file is.

In /etc/sogo/sogo.conf  almost everything is commented.

In /home/sogo/GNUstep/Defaults/ there isn’t .GNUstepDefaults file

I’ve found .GNUstepDefaults in /usr but i can’t see changes i’ve
made from sogo webmin module configuration.




Can someone help me please?


Which version of SOGo are you using?

What does the following command give you?
sudo -u sogo /usr/sbin/sogo-tool dump-defaults

What is uncommented in your sogo.conf file?


Kind regards,
Christian Mack


The GNUstep defaults is for the old version of SOGo.
The SOGo webmin module is changing settings in the old place, in the
"GNUstep defaults" location.
The new versions of SOGo use /etc/sogo/sogo.conf text file.
Assuming you're using a recent version of SOGo, this should explain
why your settings seem to be having no effect.
You need to edit the file /etc/sogo/sogo.conf !
Try and reply to the list with your results.

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

Hello Daniele,


If you look at the Installation Guide, Upgrading section, page 61

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

"2.0.5
The configuration is now stored in /etc/sogo/sogo.conf. Perform the
following commands as root to migrate your previous user defaults:

install -d -m 750 -o sogo -g sogo /etc/sogo sudo -u sogo sogo-tool
dump-defaults > /etc/sogo/sogo.conf chown root:sogo /etc/sogo/sogo.conf
chmod 640 /etc/sogo/sogo.conf sudo -u sogo mv
~/GNUstep/Defaults/.GNUstepDefaults \
 ~/GNUstep/Defaults/GNUstepDefaults.old
"

See if that works. Reply back to list with results.

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



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

Re: R: R: [SOGo] sogo configuration file

[Chris Coleman]

On 9/16/2015 2:13 AM, Daniele Borini wrote:

I did,
firstly i dumped sogo con into sogo.conf file:
sudo -u sogo sogo-tool dump-defaults > /etc/sogo/sogo.conf

then i changed something into /etc/sogo/sogo.conf file like WOWorkersCount
from 10 to 11 and WOLogFile from sogo.log to sogoo.log.
restarting sogo with /etc/init.d/sogo restart
checked running sogo configuration with sudo -u sogo sogo-tool dump-defaults
but nothing changed from the original configuration.



Daniele Borini


Via Provinciale per Sacca, 55 - 43052 - Colorno - Italy
tel +39 0521319316
fax +39 0521319322
borini-effegidi.it
e-mail d.bor...@effegidi.it
www.effegidi.it
Prima di stampare,pensa all'ambiente ** Think about the environment before
printing


-Messaggio originale-
Da: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Per conto di Chris
Coleman
Inviato: martedì 15 settembre 2015 17:00
A: users@sogo.nu
Oggetto: Re: R: [SOGo] sogo configuration file

On 9/15/2015 3:48 AM, Daniele Borini wrote:

No way,
i tried to change /usr/.GNUStepDefaults rebooting server but sogo
doesn't accept changes i really don't know where configuration file is.

Daniele Borini


Via Provinciale per Sacca, 55 - 43052 - Colorno - Italy tel +39
0521319316 fax +39 0521319322 borini-effegidi.it e-mail
d.bor...@effegidi.it www.effegidi.it Prima di stampare,pensa
all'ambiente ** Think about the environment before printing


-Messaggio originale-
Da: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Per conto di
Christian Mack
Inviato: lunedì 14 settembre 2015 16:46
A: users@sogo.nu
Oggetto: Re: [SOGo] sogo configuration file

Hello

Am 11.09.2015 um 14:01 schrieb Daniele Borini:

i’m changing sogo configuration, expecially user sourcers part due to
mailserver changes.

I need to swtich from ldap auth to mysql auth.

I’m really not able to find where configuration file is.

In /etc/sogo/sogo.conf  almost everything is commented.

In /home/sogo/GNUstep/Defaults/ there isn’t .GNUstepDefaults file

I’ve found .GNUstepDefaults in /usr but i can’t see changes i’ve made
from sogo webmin module configuration.

   


Can someone help me please?


Which version of SOGo are you using?

What does the following command give you?
sudo -u sogo /usr/sbin/sogo-tool dump-defaults

What is uncommented in your sogo.conf file?


Kind regards,
Christian Mack


The GNUstep defaults is for the old version of SOGo.
The SOGo webmin module is changing settings in the old place, in the
"GNUstep defaults" location.
The new versions of SOGo use /etc/sogo/sogo.conf text file.
Assuming you're using a recent version of SOGo, this should explain why your
settings seem to be having no effect.
You need to edit the file /etc/sogo/sogo.conf !
Try and reply to the list with your results.

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


Hello Daniele,


If you look at the Installation Guide, Upgrading section, page 61

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

"2.0.5
The configuration is now stored in /etc/sogo/sogo.conf. Perform the 
following commands as

root to migrate your previous user defaults:

install -d -m 750 -o sogo -g sogo /etc/sogo
sudo -u sogo sogo-tool dump-defaults > /etc/sogo/sogo.conf
chown root:sogo /etc/sogo/sogo.conf
chmod 640 /etc/sogo/sogo.conf
sudo -u sogo mv ~/GNUstep/Defaults/.GNUstepDefaults \
   ~/GNUstep/Defaults/GNUstepDefaults.old
"

See if that works. Reply back to list with results.

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

Re: [SOGo] Undelivered Mail return to sender - SPF Failure for domain

[Chris Coleman]

You must configure SPF in your domain's DNS records.  SPF is a TXT type 
record.  It is meant to reduce spam.  In existence since about 2010.  
You should ask your domain administrator to configure it for you.  More 
info... https://en.wikipedia.org/wiki/Sender_Policy_Framework




On 9/15/2015 9:51 PM, Lou Albert Laurel wrote:

Hi everyone,

Hope you can help me with this error. Emails to some of my clients 
cannot be send because of some SPF error.


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

Re: [SOGo] Security issues with multiple log ins?

[Chris Coleman]

On 9/15/2015 10:14 AM, Rick Larson wrote:

Thanks for your help.

Just for a little more clarification.

By "push access" I mean that 150+ users will add the details of one account to 
their iPhones, Android or Windows phones, to which one address book will be pushed. No 
one except one Admin will have write access.  When he/she changes an address this will be 
pushed immediately to all of the devices and the same changes will be reflected on their 
devices.

Below you write about everyone with read access only accessing a URL to the 
address book and reading it there.  We were not interested in this so much but 
interested in setting up an extra account in our mobile phones which will be an 
additional address book to our own personal one in the phone.

Thanks again




On Sep 14, 2015, at 9:25 PM, Christian Mack  
wrote:

Hello


Am 14.09.2015 um 16:14 schrieb Kcir:

New here, so be patient with me if I am in the wrong place.

I have 150 people with whom I would like to share one address book, on their
mobile phones. We set up a gmail account, but with gmail's security settings
when someone logs into an account on their mobile phone in Canada, US,
Germany, South Africa, India, Australia, etc, all on the same day it locks the
system out.  It believes the account has been hacked. We need to keep changing
the password all the time to make this work for a little while.

If we were to use SOGo would we be free of this problem? Would it allow us to
sign up 150+ people from 35+ counties around the globe and all freely use the
push contacts without locking us out?

By "push access" do you mean write privileges for all of your users?
If yes, they all need an account at your SOGo server.
Then you can share your address book with them and give them write access.

If no, then you can give public read only access.
This means everyone who knows the URL to the address book can access and
read it.

Access to one account is not limited in itself.
You can access it from all countries, with multiple client systems and
different clients at the same time.




Why would you give 150+ users the one login/password?
Why wouldn't you just personally administer the "shared" address book, 
on a separate sogo account, and "share" it out to the 150+ people?
This way you could control for example, when one person leaves your 
organization, you can suspend their account only, and not disrupt the 
other 149 people!
With one shared account, you would have to reissue that one account's 
password, and force 149 people change their password in their device!!!


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

Re: R: [SOGo] sogo configuration file

[Chris Coleman]

On 9/15/2015 3:48 AM, Daniele Borini wrote:

No way,
i tried to change /usr/.GNUStepDefaults rebooting server but sogo doesn't
accept changes i really don't know where configuration file is.

Daniele Borini


Via Provinciale per Sacca, 55 - 43052 - Colorno - Italy
tel +39 0521319316
fax +39 0521319322
borini-effegidi.it
e-mail d.bor...@effegidi.it
www.effegidi.it
Prima di stampare,pensa all'ambiente ** Think about the environment before
printing


-Messaggio originale-
Da: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] Per conto di
Christian Mack
Inviato: lunedì 14 settembre 2015 16:46
A: users@sogo.nu
Oggetto: Re: [SOGo] sogo configuration file

Hello

Am 11.09.2015 um 14:01 schrieb Daniele Borini:

i’m changing sogo configuration, expecially user sourcers part due to
mailserver changes.

I need to swtich from ldap auth to mysql auth.

I’m really not able to find where configuration file is.

In /etc/sogo/sogo.conf  almost everything is commented.

In /home/sogo/GNUstep/Defaults/ there isn’t .GNUstepDefaults file

I’ve found .GNUstepDefaults in /usr but i can’t see changes i’ve made from
sogo webmin module configuration.

  


Can someone help me please?


Which version of SOGo are you using?

What does the following command give you?
sudo -u sogo /usr/sbin/sogo-tool dump-defaults

What is uncommented in your sogo.conf file?


Kind regards,
Christian Mack


The GNUstep defaults is for the old version of SOGo.
The SOGo webmin module is changing settings in the old place, in the 
"GNUstep defaults" location.

The new versions of SOGo use /etc/sogo/sogo.conf text file.
Assuming you're using a recent version of SOGo, this should explain why 
your settings seem to be having no effect.

You need to edit the file /etc/sogo/sogo.conf !
Try and reply to the list with your results.

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

Re: [SOGo] ANN: SOGo v3.0 beta 1

[Chris Coleman]

On 8/31/2015 9:12 PM, Francis Lachapelle wrote:

Hello all


On Aug 31, 2015, at 3:51 PM, Ludovic Marcotte  wrote:

While v3 brings a lot, we decided to postpone the development of some of 
existing v2 features so we could get an initial release out. These were 
available in v2 and will be reappear in the upcoming weeks:
• DnD (moving components, attaching files, etc.)
• advanced email search
• email threading
• calendar printing - we need to finish polishing the calendar views 
before adding printing support
• multiday view
• admin module - we need to add more features in this module

We're also coming up with a simplified theme, which will make it easier to 
develop more themes in the future.


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


Excellent choice to use the single solution universal device agnostic 
Angular Material framework.  User interface that adapts to work the same 
on phone tablet and desktop will save time and energy, otherwise split 
by maintaining multiple forks of the user interface, to make 
improvements in the functionality of areas of the application that need 
attention, solve bugs, and performance improvements.


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

Re: [SOGo] Again: Migration from old to new SOGo server

[Chris Coleman]

On 8/20/2015 1:19 PM, Hartmut Raithel wrote:

Am 20.08.2015 um 13:48 schrieb Ludovic Marcotte:
If you're moving entirely to a new server - I would suggest to 
backup/restore the SQL database itself. If you need to, you can 
adjust the location values from the sogo_folder_info. Using 
sogo-tool backup/restore will modify the c_lastmodified for all 
entries, which means the collection tag will change for every single 
addressbook and calendar. That means the CUA will usually force a 
full refresh of each collection. For 4,000 users, that might put some 
stress on your server.


Hi Ludovic,

ok, I'll try it with sql backup and restore. Regarding modification of 
the location tables in sogo_folder_info: Do you mean to change the 
servername in the values? So there ist 127.0.0.1 in my sogo.conf and 
the postgresql db is still on local machine, i asume there is nothing 
to modify. Isn't it? For example: 
postgresql://user:password@127.0.0.1:5432/sogo/sogohraithel0011d7a000d 
- nothing to change, from my point of view.
Regarding stress on my server, we have vacation time at moment, and 
all our systems are bored...
...but on 1st of October, semester startup, i'm sure all red lights 
will raise - as usual. ;-)


I can imagine many scenario where a user wishes to migrate from an old 
server to a new server.
A migrator script that just works and migrates sogo fully 
automatically, would be very cool !


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

Re: Aw: [SOGo] ANN: SOGo v2.3.0

[Chris Coleman]

On 8/4/2015 6:53 AM, Kai-Uwe Rommel wrote:

Hello,

please see below. May I ask again? Or does nobody have any idea how to 
solve

this?

Otherwise I'm stuck ... thanks!

Kai-Uwe Rommel

kai-uwe.rom...@ars.de
Telefon+Mobil +49 89 32468-120


__

users-requ...@sogo.nu wrote on 02.06.2015 14:59:37:
 On 02/06/2015 08:26, Daniel Müller wrote:
 /usr/sbin/sogod: error while loading shared libraries:
 libmemcached.so.11: cannot open shared object file: No such file or 
directory


I have the same problem when I attempt to upgrade to 2.3.1.

 Make sure you pull the libmemcached 1.0.18 packages from our repo.

How do I do this?

When I check for newest package:

[root@srv sogo-2.3.1]# yum list installed libmemcached
Installed Packages
libmemcached.x86_64 0.49-1   @SOGo
[root@srv sogo-2.3.1]# yum list libmemcached
Installed Packages
libmemcached.x86_64  0.49-1@SOGo
Available Packages
libmemcached.i6860.31-1.1.el6  base

I have:

[root@srv sogo-2.3.1]# cat /etc/yum.repos.d/inverse.repo
[SOGo]
name=Inverse SOGo Repository
baseurl=http://inverse.ca/downloads/SOGo/RHEL6/$basearch
gpgcheck=0
priority=7
enabled=1

(This is on CentOS 6.6 x86_64)

When I browse the repo with a web browser, I see that there is a 1.0.18
version of it together with 0.49 but why does my yum not pull it?

Kai-Uwe Rommel

kai-uwe.rom...@ars.de
Telefon+Mobil +49 89 32468-120



*
Veranstaltungshinweis:*
ARS Konferenz ARScon – Strategien von morgen am 15.10.2015 in der 
Allianz Arena Muenchen

http://www.ars.de/konferenz

ARS Computer und Consulting GmbH, http://www.ars.de http://www.ars.de/
Ridlerstrasse 37, 80339 Muenchen, Deutschland

Individuelle Softwareentwicklung, Beratung und Projekte
IBM Software, IBM Lizenzmanagement
IT-Infrastrukturservices

Handelsregister Muenchen, HRB 101829, USt-ID: DE 155 068 909
Geschaeftsfuehrer: Michael Arbesmeier, Kai-Uwe Rommel, Roland Schock, 
Joachim Gucker


I had the same problem on debian 7.
Sogo would not start, it was missing the expected cusomized libmemcached 
version from inverse repo.
The way I solved it , if I remember correctly, was to manually download 
the package, and force install using the package installer, in your 
case: yum.

It was tricky, several expected ways to do it wouldn't work.
These packages should auto install from repo without that trouble.
If this is still happening from the standard scripted installations onto 
a fresh operating system, It should be added the the bug tracker for 
fixing...


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

Re: [SOGo] Calendar name changed to non-readable

[Chris Coleman]

On 7/31/2015 8:08 AM, Steve Ankeny wrote:

On 07/31/2015 07:36 AM, Khapare Joshi wrote:
My SOGo version is 2.2.16 (root@shiva.inverse 201502121141). 
Something has changed in this version, some reason in my calendar 
names are not recognizable, instead it prints as : 147F-4Dcc 


But if I create a new calendar i.e test it is normal.

I have attached the screen-shot. anybody has an opinion on this ?

K


Are the alpha-numeric-named calendars shared calendars from other 
users?


If so, that would seem to indicate the issue has to do with the 
authentication of users -- a scrambling of usernames -- i.e., LDAP, 
SQL, Samba-AD, Microsoft-AD, etc.  How are you authenticating users?


Where is user data stored?  It may also simply require a fresh 
sharing from the original user.


It might also be helpful to know your OS, etc.


Shouldn't the sogo web user interface display a sensible, detailed error 
message to the user, if it's indeed encountered a problem when 
attempting to authenticate/authorize the user's access to some shared 
calendars.  Because displaying 64 digit GUID numbers to the user instead 
of calendar names, with no explanation, doesn't work.


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

Re: [SOGo] Updates in LDAP directory not reflected in SOGo

[Chris Coleman]

On 7/31/2015 9:12 AM, Christian Mack wrote:

Hello

Am 31.07.2015 um 13:26 schrieb Hardy Flor:

I have a field with a single value for the emailaddess. When I change
this field, is the change not displayed in the adressbook. In the
database no field contain the old emailaddess.
Restart of the server work also not.

Where does the wrong emailaddress?


Sorry, but your question confused me a bit.
First you change an email address in LDAP, then you search for it in the
database?
How should it get there?
Why should a server restart change that?

Perhaps it would be better to give us step by step instructions on what
you did and what didn't work.


Kind regards,
Christian Mack



I think what Hardy means to say is, when updating (side-loading) an 
email address stored in the database, the updated email address data 
isn't shown in the web interface address book.
Where is the web interface caching the outdated version of the email 
address.
Ultimately, how to modify/side-load  data in the database, and trigger a 
refresh / cache invalidate, in the sogo web interface.
Side note: Is there a soap or rest interface available in sogo for doing 
data extract and load ?


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

Re: [SOGo] Calendar name changed to non-readable

[Chris Coleman]

On 7/31/2015 9:27 AM, Steve Ankeny wrote:

On 07/31/2015 09:08 AM, Chris Coleman wrote:



On 7/31/2015 8:08 AM, Steve Ankeny wrote:

On 07/31/2015 07:36 AM, Khapare Joshi wrote:
My SOGo version is 2.2.16 (root@shiva.inverse 201502121141). 
Something has changed in this version, some reason in my calendar 
names are not recognizable, instead it prints as : 147F-4Dcc 


But if I create a new calendar i.e test it is normal.

I have attached the screen-shot. anybody has an opinion on this ?

K


Are the alpha-numeric-named calendars shared calendars from other 
users?


If so, that would seem to indicate the issue has to do with the 
authentication of users -- a scrambling of usernames -- i.e., LDAP, 
SQL, Samba-AD, Microsoft-AD, etc.  How are you authenticating users?


Where is user data stored?  It may also simply require a fresh 
sharing from the original user.


It might also be helpful to know your OS, etc.


Shouldn't the sogo web user interface display a sensible, detailed 
error message to the user, if it's indeed encountered a problem when 
attempting to authenticate/authorize the user's access to some shared 
calendars.  Because displaying 64 digit GUID numbers to the user 
instead of calendar names, with no explanation, doesn't work.




Have you checked the relevant log file?




Good idea, but normal users don't have access to global system log files!
Users still need to know what when wrong (for example, unable to display 
certain shared calendars) and why (authorization failure on server xxx 
with username yyy) and how to fix it by themselves (go to whatever 
settings page on some menu and try entering correct username/password), 
or who to contact for help (sogo mail sys admin).


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

Re: [SOGo] Calendar name changed to non-readable

[Chris Coleman]

On 7/31/2015 11:38 AM, Steve Ankeny wrote:

On 07/31/2015 10:03 AM, Chris Coleman wrote:



On 7/31/2015 9:27 AM, Steve Ankeny wrote:

On 07/31/2015 09:08 AM, Chris Coleman wrote:



On 7/31/2015 8:08 AM, Steve Ankeny wrote:

On 07/31/2015 07:36 AM, Khapare Joshi wrote:
My SOGo version is 2.2.16 (root@shiva.inverse 201502121141). 
Something has changed in this version, some reason in my calendar 
names are not recognizable, instead it prints as : 147F-4Dcc 


But if I create a new calendar i.e test it is normal.

I have attached the screen-shot. anybody has an opinion on this ?

K


Are the alpha-numeric-named calendars shared calendars from 
other users?


If so, that would seem to indicate the issue has to do with the 
authentication of users -- a scrambling of usernames -- i.e., 
LDAP, SQL, Samba-AD, Microsoft-AD, etc.  How are you 
authenticating users?


Where is user data stored?  It may also simply require a fresh 
sharing from the original user.


It might also be helpful to know your OS, etc.


Shouldn't the sogo web user interface display a sensible, detailed 
error message to the user, if it's indeed encountered a problem 
when attempting to authenticate/authorize the user's access to some 
shared calendars.  Because displaying 64 digit GUID numbers to the 
user instead of calendar names, with no explanation, doesn't work.




Have you checked the relevant log file?




Good idea, but normal users don't have access to global system log 
files!
Users still need to know what when wrong (for example, unable to 
display certain shared calendars) and why (authorization failure on 
server xxx with username yyy) and how to fix it by themselves (go to 
whatever settings page on some menu and try entering correct 
username/password), or who to contact for help (sogo mail sys admin).




That's a different issue than fixing the problem.

Sorry!  I was under the impression the OP wanted to fix his 
calendars.  What you're suggesting may be a feature request but may 
have little to do with actually fixing the problem.  The questions I 
asked may help.





Right!  My point is, the app should contain informative error messages 
for every foreseeable error condition, that guide the user to fix their 
own error most of the time, get help from their sogo mail sys admin some 
of the time, and finally resort to the mailing list in very rare 
situations when an unforeseen error occurs and the app doesn't have a 
built-in informative error message to guide the user to fix it 
themselves.  Without this, basic level 1 help requests flood the mailing 
list...


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

Re: [SOGo] ANN: SOGo v2.3.1

[Chris Coleman]

On 7/30/2015 8:57 AM, Christian Mack wrote:

Hello

Am 30.07.2015 um 14:24 schrieb Márcio Merlone:

On 24-07-2015 08:07, Steve Ankeny wrote:

The only issues I remember with the running of the script were --

(1) users fail to run it
(2) or, they run the wrong script

Instructions are *always* at the back pages of the Installation Guide --

http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf (pg 58)

Since I run Ubuntu, I assume the install/upgrade procedure from apt
already does that, is this correct?


No!
You have to do that manually.


Kind regards,
Christian Mack

I nominate adding the database schema upgrade script to the deb and rpm 
install/upgrade scripts. It would need to detect the current db schema 
version and apply the appropriate db updates. Which it surely does 
already...

That automation alone would probably reduce friction by 5%.

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

Re: [SOGo] ANN: SOGo v2.3.1

[Chris Coleman]

On 7/30/2015 9:09 AM, Sven Schwedas wrote:

On 2015-07-30 15:05, Chris Coleman wrote:

On 7/30/2015 8:57 AM, Christian Mack wrote:

Hello

Am 30.07.2015 um 14:24 schrieb Márcio Merlone:

On 24-07-2015 08:07, Steve Ankeny wrote:

The only issues I remember with the running of the script were --

(1) users fail to run it
(2) or, they run the wrong script

Instructions are *always* at the back pages of the Installation
Guide --

http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf (pg 58)

Since I run Ubuntu, I assume the install/upgrade procedure from apt
already does that, is this correct?


No!
You have to do that manually.


Kind regards,
Christian Mack


I nominate adding the database schema upgrade script to the deb and rpm
install/upgrade scripts. It would need to detect the current db schema
version and apply the appropriate db updates. Which it surely does
already...
That automation alone would probably reduce friction by 5%.


Assuming it doesn't have any bugs and blows up your whole database. You
should read the notes anyway, because schema migrations aren't the only
changes between versions.

Reading notes is good, the upgrade script could and probably should take 
an automatic backup of the database (similar to a system restore 
point) before applying schema updates.

mysqldump.  pg_dump.
The upgrade script including the schema upgrades, would minimize the 
human element of errors, forgetfulness, typing error, copy/paste error, 
leading to blowing up the database.


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

Re: [SOGo] ANN: SOGo v2.3.1

[Chris Coleman]

On 7/30/2015 9:14 AM, Christian Mack wrote:

Am 30.07.2015 um 15:05 schrieb Chris Coleman:


On 7/30/2015 8:57 AM, Christian Mack wrote:

Hello

Am 30.07.2015 um 14:24 schrieb Márcio Merlone:

On 24-07-2015 08:07, Steve Ankeny wrote:

The only issues I remember with the running of the script were --

(1) users fail to run it
(2) or, they run the wrong script

Instructions are *always* at the back pages of the Installation
Guide --

http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf (pg 58)

Since I run Ubuntu, I assume the install/upgrade procedure from apt
already does that, is this correct?


No!
You have to do that manually.


Kind regards,
Christian Mack


I nominate adding the database schema upgrade script to the deb and rpm
install/upgrade scripts. It would need to detect the current db schema
version and apply the appropriate db updates. Which it surely does
already...
That automation alone would probably reduce friction by 5%.


It is not that easy.
It first would have to scan your config, in order to find which DBMS you
use.
Some are even using multiple DBs.


Kind regards,
Christian Mack

Yes, but when these deb/rpm scripts install SOGo for the first time, 
don't they rely on classes which create the db with whichever supported 
DBMS the admin has chosen (mysql postrgres or oracle), install the 
latest schema, and from then onward, interact with the db using classes?
Upgrading existing schema should mean query the db class for schema 
version, and invoke the schema upgrader by supplying path names for the 
relevant differential schema upgrade files.

This is how many/most application projects handle db schema upgrades.

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

Re: [SOGo] ANN: SOGo v2.3.1

[Chris Coleman]

On 7/30/2015 11:59 AM, Christian Mack wrote:

Am 30.07.2015 um 15:32 schrieb Chris Coleman:


On 7/30/2015 9:14 AM, Christian Mack wrote:

Am 30.07.2015 um 15:05 schrieb Chris Coleman:

On 7/30/2015 8:57 AM, Christian Mack wrote:

Hello

Am 30.07.2015 um 14:24 schrieb Márcio Merlone:

On 24-07-2015 08:07, Steve Ankeny wrote:

The only issues I remember with the running of the script were --

(1) users fail to run it
(2) or, they run the wrong script

Instructions are *always* at the back pages of the Installation
Guide --

http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf (pg 58)

Since I run Ubuntu, I assume the install/upgrade procedure from apt
already does that, is this correct?


No!
You have to do that manually.


Kind regards,
Christian Mack


I nominate adding the database schema upgrade script to the deb and rpm
install/upgrade scripts. It would need to detect the current db schema
version and apply the appropriate db updates. Which it surely does
already...
That automation alone would probably reduce friction by 5%.


It is not that easy.
It first would have to scan your config, in order to find which DBMS you
use.
Some are even using multiple DBs.


Kind regards,
Christian Mack


Yes, but when these deb/rpm scripts install SOGo for the first time,
don't they rely on classes which create the db with whichever supported
DBMS the admin has chosen (mysql postrgres or oracle), install the
latest schema, and from then onward, interact with the db using classes?

No, there is no DB creation rpm/deb.
SOGo creates the tables on startup after configuration and creation of
the databases through the admin.

And an admin can choose to use different DBs for different parts.
E.g. use a MySQL with memory backend for sessions, an oracle for user
data and an postgresql for user authentication data.
With that you have all the connectors for those DBMS installed.
Which one to upgrade is only defined in sogo.conf.


Upgrading existing schema should mean query the db class for schema
version, and invoke the schema upgrader by supplying path names for the
relevant differential schema upgrade files.
This is how many/most application projects handle db schema upgrades.


Partly this is possible, but as I said needs to parse the SOGo config first.
Therefore this is not as trivial as it seems.


Kind regards,
Christian Mack



It sounds what's needed is to add a generalized class to parse a 
standard .conf or .ini file.
The good news is, many working classes have already been developed, 
ready to be reused, in many languages, python, php, C, perl, you name it.

http://stackoverflow.com/questions/20708627/parsing-a-config-file
Which language would SGOo invoke this code from?  Is it the admin 
section of the SOGo web based gui, which is written in Objective-C ?


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

Re: [SOGo] ANN: SOGo v2.3.1

[Chris Coleman]

On 7/30/2015 9:30 AM, Steve Ankeny wrote:

On 07/30/2015 09:14 AM, Christian Mack wrote:

Am 30.07.2015 um 15:05 schrieb Chris Coleman:


On 7/30/2015 8:57 AM, Christian Mack wrote:

Hello

Am 30.07.2015 um 14:24 schrieb Márcio Merlone:

On 24-07-2015 08:07, Steve Ankeny wrote:

The only issues I remember with the running of the script were --

(1) users fail to run it
(2) or, they run the wrong script

Instructions are *always* at the back pages of the Installation
Guide --

http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf (pg 
58)

Since I run Ubuntu, I assume the install/upgrade procedure from apt
already does that, is this correct?


No!
You have to do that manually.


Kind regards,
Christian Mack


I nominate adding the database schema upgrade script to the deb and rpm
install/upgrade scripts. It would need to detect the current db schema
version and apply the appropriate db updates. Which it surely does
already...
That automation alone would probably reduce friction by 5%.


It is not that easy.
It first would have to scan your config, in order to find which DBMS you
use.
Some are even using multiple DBs.


Kind regards,
Christian Mack



I nominate a having a warning PLEASE READ INSTRUCTIONS before upgrading!

It's very clearly spelled out in the instructions (as well as in 
various places on this mailing list)





Yes, but I believe the goal is (and needs to be) zero-effort upgrades, 
to whatever extent possible within reason.


For the admins using 3 different database engines, to provide separate 
login (microsoft ldap), session (mysql in memory), and data storage 
(postgres) , to achieve extreme high performance, maybe we can let them 
risk manually running db schema upgrade scripts (and run the wrong 
versions of the schema scripts, or completely forget to run them), but 
even then, a config file parser class should automatically extract those 
3 sets of db credentials from sogo.conf and perform automated schema 
upgrades.


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

Re: [SOGo] Choose login domain based on DNS domain used to access the server.

[Chris Coleman]

What you want to do is possible (auto select from a set of Sogo login 
domains, on a multi tenant multi DNS domain Sogo webmail server, based 
on http host header).  The .WOX template file is a template based on 
Objective-C and with Objective-C you should be able to do anything, such 
as, in this case, get the http headers from the http request.  Look for 
the http header called Host. Verify that it's a valid dns domain that 
you're hosting the Sogo webmail for, and then set the login domain to 
that Host value.


Have a look here:
http://sope.opengroupware.org/en/docs/snippets/wox.html



On 7/27/2015 7:26 AM, Steve Ankeny wrote:

On 07/27/2015 05:42 AM, Nils Fredrik Gjerull wrote:

Hi,

Any thoughts please. Would appreciate at least an acknowledgement 
that the e-mail was read, so I know I am not sending e-mails into the 
void :)


I also had a proposal/question about using a http header to set the 
login domain. I guess that it is not supported so I should create a 
proposal for it?



Den 22. juli 2015 15:32, skrev Nils Fredrik Gjerull:

Hi,

I have a use case were I want to make the SOGo webmail client 
accessible through different DNS domains, and based on which DNS 
domain is used a login domain is automatically chosen. I want to use 
SOGo as a multi-tenant system without users having to choose a login 
domain.


Let say that SOGo is available on mail.domain1.com and 
mail.domain2.com, and in SOGo I have domain1 and domain2 as separate 
login domains. If a user access the SOGo webmail client through 
mail.domain1.com, domain1 will be used as the login domain. That way 
the user do not have to select the domain or append it to the username.


I am primarily thinking about the SOGo webmail client and not 
CardDAV and CalDAV, but I would not mind if it were possible to do 
it for them as well. I understand that there is some kind of 
template overriding system for the .wox templates. Would I be able 
to get the current URL/domain and be able to set a login domain 
within such a template?


I appreciate any suggestions.

Regards



It sounds to me like you're mixing technologies --

domain login (whether Windows or Samba AD) and SOGo webmail

Perhaps no one has responded simply because they are unsure what 
you're trying to do.


IF you already have SOGo webmail available via two domains, are you 
running two instances of SOGo and two instances of your mail server 
(Dovecot/Postfix, etc.) or have you configured one instance to work 
for both?


And, IF you have two domain logins are you running two AD servers?

Does domain login come before webmail login, etc?  I may be totally 
off-base (sorry)





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

Re: [SOGo] Webmin module

[Chris Coleman]

I see the same error on that Webmin SOGo module. The reason is because, 
that version of the Webmin module was written about 3 years ago the 
previous major version of SOGo which used GNUstep defaults binary to 
save settings somewhere in the GNUstep settings location. The current 
version of SOGO expects settings to be saved to a regular conf file 
/etc/sogo/sogo.conf


Maybe the original module author could update that Webmin module's perl 
code to write the settings to the proper location.  Added features in 
that webmin module would be nice to have.




On 3/24/2015 12:38 PM, Piotr Kowalczyk wrote:


Hi,

I’m trying to get webmine module (latest version) running and 
unfortunately every time when I save changes the error “Error while 
saving the following parameter :”. Could you advise how to configure 
it please? I’ve also noticed the recent version is quite old, is any 
plan to update it? If so when can it be expected?


Thank you.

Kind Regards

Piotr



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

Re: [SOGo] Would you have a webmin sogo module configuration, and setup?

[Chris Coleman]

The webmin SOGo module is outdated, it's using the old GNUstep defaults 
binary for saving settings to the old location, instead of the saving to 
the new conf file.

It's due for an update to be compatible with the current version of SOGo.
https://github.com/inverse-inc/sogo-webmin



On 3/7/2015 12:43 AM, heat...@trans-world.org wrote:

Would you have a webmin sogo module configuration, and setup?
I have the webmin module installed on my server but have no 
documentation on how to use sogo with webmin,
would you have a full users guide on how to make work sogo with webmin 
then?

THANKS HEATHER


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

Re: [SOGo] Download SOGo Connector for Thunderbird

[Chris Coleman]

Gustave,
It's a common confusion, because Firefox and Thunderbird extensions both 
end in .xpi

The solution:
Right click on the link: 
http://www.sogo.nu/files/downloads/extensions/sogo-connector-31.0.1.xpi

Click Save target as...
Save it on your Downloads folder.
Go into Thunderbird.
Click Tools / Add-ons / (Gear) / Install add-on from file...
Browse to Downloads and select your file sogo-connector-31.0.1.xpi


On 2/28/2015 9:18 AM, gustave.ba...@gmail.com wrote:

Hello,

First, sorry for may very basic english ...

When I try to download the SOGo Connector Thunderbird Extension (from
http://www.sogo.nu/fr/downloads/frontends.html), I receive the following
message (translated from french) Inverse SOGo Connector cannot be installed
because it is not compatible witj Firefox 35.0.1

Strange message because SOGo is for Thunderbird and not for Firefox, no ?

My versions :
Thunderbird 31.4.0
Lightning 3.3.3
Mozilla 35.0.1

I thank you in advance for any help

Best regard

Gustave Barre


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

Re: [SOGo] disable auto-complete for certain external ldap address books

[Chris Coleman]

Here's some pretty good pages on how to speed up your AD server.
http://www.frickelsoft.net/blog/?p=246
https://msdn.microsoft.com/en-us/library/ms808539.aspx
http://blogs.technet.com/b/ad/archive/2008/04/01/how-to-create-a-mosiac-of-user-thumbnails-in-aduc-dsa-msc.aspx


On 2/27/2015 3:39 AM, mourik jan heupink wrote:

Hi Christian,


If it is an address book in SOGo, then it is used for auto completion.

It is easy to speed up an LDAP. Just give it more memory.
We have our openLDAP servers set up, so that they run their complete
database in memory (~18000 accounts).
Ok, clear. However, the ldap is an external AD server, with *many* 
records. (I guess 20.000 or so)


Looking up a single email address (over port 3268) works *instantly*, 
but the ldap query that is generated by SOGo webaccess takes 5 to 8 
seconds to complete.


Searching the archives here, I guess the actual query will look 
something like


ldapsearch -x -LLL -P 3 -h a.b.c.d:3268 -D 
CN=login,DC=Company,DC=COM -W -b DC=company,DC=com -s sub 
(|(sn=heupink*)(displayName=heupink*)(telephoneNumber=heupink*)(mail=heupink*)(cn=heupink*)) 
cn userprincipalname mail sn manager sAMAccountName


And testing this on cli, confirms that this takes 5 to 8 seconds to 
complete.


This takes too log to be practical.

Then perhaps... is there a way to *adjust* the outgoing query for this 
particular ldap usersource to make it quicker?


Or... do you guys here have some tips (adding some indexes perhaps?) 
that I could request to the admins on the external AD side, to make 
our SOGo query complete faster?


Thanks!


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

Re: [SOGo] Apache modules?

[Chris Coleman]

Excellent.  These 10 additional modules should be added to the 
documentation with the 4 already listed.



On 2/25/2015 11:10 AM, Kai-Uwe Rommel wrote:

users-requ...@sogo.nu wrote on 22.02.2015 22:54:02:

 From here:
 https://wiki.debian.org/SOGo
 and here:
 http://www.openchange.org/cookbook/backends/sogo/webui.html

 These 4 apache modules required:
 # add some apache modules
 a2enmod proxy
 a2enmod proxy_http
 a2enmod headers
 a2enmod rewrite

This list seems to be far from being complete. By trial and error I found
that on my CentOS 6.6 server I also had to keep those additional modules
enabled:

alias
version
authz_host
env
mime
dir
log_config
setenvif
autoindex
negotiation

Otherwise Apache would not start.


Kai-Uwe Rommel

kai-uwe.rom...@ars.de
Telefon+Mobil +49 89 32468-120




ARS Computer und Consulting GmbH, http://www.ars.de http://www.ars.de/
Ridlerstrasse 55, 80339 Muenchen, Deutschland

Application Development Services, Business Transformation Services, IT 
Infrastruktur Services

Beratung und Vertrieb zu IBM Software, System x, POWER Systems, Storage
License Management Services, IBM Passport Advantage Lizenzierung

Handelsregister Muenchen, HRB 101829, USt-ID: DE 155 068 909
Geschaeftsfuehrer: Michael Arbesmeier, Kai-Uwe Rommel, Roland Schock, 
Joachim Gucker




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

Re: [SOGo] using nginx

[Chris Coleman]

Did you use the config from this page?
http://wiki.sogo.nu/nginxSettings


Make sure you have both X-Real-IP and X-Forwarded-For headers.
Like these:

# set headers
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forward-For $proxy_add_x_forwarded_for;

# Optional:
# Let the web service know that we're using HTTPS, otherwise
# it will generate URL using http:// and not https://
# proxy_set_header X-Forwarded-Proto https;






On 2/22/2015 12:43 PM, Infoomatic wrote:

hi,
I wanted to use nginx with sogo and apply the fail2ban rules. Basically, 
everything is working fine with nginx, but:
with the suggested nginx config (including proxy_set_header X-Real-IP 
$remote_addr; from the sogo wiki) and nginx version 1.6.2, the
logfile only creates entries like:
SOGoRootPage Login from '127.0.0.1' for user 'afd' might not have worked - 
password policy: 65535  grace: -1  expire: -1  bound: 0

The same host, with the suggested apache2 configuration gives me:
SOGoRootPage Login from 'XXX.XX.XX.XXX' for user 'aasd' might not have worked - 
password policy: 65535  grace: -1  expire: -1  bound: 0

with my real IP and thus fail2ban working.

Is there a workaround or some variables to change in source and recompile to 
have this working? Or better: a configuration option I did not see?

regards,
infoomatic



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

Re: [SOGo] Apache modules?

[Chris Coleman]

From here:
https://wiki.debian.org/SOGo
and here:
http://www.openchange.org/cookbook/backends/sogo/webui.html

These 4 apache modules required:

# add some apache modules
a2enmod proxy
a2enmod proxy_http
a2enmod headers
a2enmod rewrite
# restart apache
/etc/init.d/apache2 restart



On 2/22/2015 3:56 PM, Kai-Uwe Rommel wrote:

No response so far ... did nobody explore this yet?

Kai-Uwe Rommel

kai-uwe.rom...@ars.de
Telefon+Mobil +49 89 32468-120


__

Hello,

I would like to harden my SOGo server a bit since it is accessible 
on the Internet.
Is there some documentation available which Apache modules are 
required for SOGo and
which modules can be disabled? The SOGo configuration guide does not 
mention anything

about this topic. Thanks!

Kai-Uwe Rommel

kai-uwe.rom...@ars.de
Telefon+Mobil +49 89 32468-120




ARS Computer und Consulting GmbH, http://www.ars.de http://www.ars.de/
Ridlerstrasse 55, 80339 Muenchen, Deutschland

Application Development Services, Business Transformation Services, IT 
Infrastruktur Services

Beratung und Vertrieb zu IBM Software, System x, POWER Systems, Storage
License Management Services, IBM Passport Advantage Lizenzierung

Handelsregister Muenchen, HRB 101829, USt-ID: DE 155 068 909
Geschaeftsfuehrer: Michael Arbesmeier, Kai-Uwe Rommel, Roland Schock, 
Joachim Gucker




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

Re: [SOGo] New Installation

[Chris Coleman]

Carl: Nice Centos Sogo Openchange Dovecot Samba4 install script!

You should make a github page for it.


On 2/18/2015 11:16 AM, Carl Byington wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Wed, 2015-02-18 at 09:08 +0300, Mihamina RAKOTOMANDIMBY wrote:

On 02/17/2015 05:48 PM, gtilli...@mwdist.com wrote:

Just for additional information, I am using CentOS and I have
followed the instructions on the website and I did add the
Inverse SOGo Repository.

For Centos6, you might want to look at

http://www.five-ten-sg.com/mapper/blog/openchange


-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.14 (GNU/Linux)

iEYEARECAAYFAlTkuu0ACgkQL6j7milTFsGrDgCeNMLGCYt4bf6ZJH59C/FtwVcC
Q/oAnAqJP3ZSOMQni0lhEL0bUgNyrNCp
=NCaL
-END PGP SIGNATURE-




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

Re: [SOGo] libmemcached10 dependency issue on ubuntu 14.10

[Chris Coleman]

I experienced the same/similar bug, sogo needed libmemcached10.
I reported the bug and solved it.
Here are the detailed steps.
http://www.sogo.nu/bugs/view.php?id=3041


On 2/16/2015 1:32 PM, robav...@yahoo.com wrote:

I have been trying to install sogo version trusty on ubuntu 14.10.  I have
libmemcached11 installed.  Has anyone been able to install with
libmemcached11?


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

Re: [SOGo] Updated Samba4/OpenChange/Sogo tutorial

[Chris Coleman]

Olivier,
Very fun tutorial! Thanks for sharing that.

Read through it and it's stimulated a thought on an existing Virtualmin 
server.


What would be the difficulty level to create a modified version of your 
tutorial, to install Samba4, OpenChange, Sogo, smoothly onto a running 
Debian 7 wheezy which is managed by Virtualmin.  Existing users are in 
OpenLDAP users and groups.  Existing user mailboxes in Dovecot.  
Existing config of Apache (websites).  Nginx (SSL proxy for Apache 
sites), MySQL (some sites), PostgreSQL (some sites), Bind9 (dns for all 
sites), Postfix... ?


The goal is to add on these groupware features to the existing IMAP 
email users, by adding Samba4, OpenChange and Sogo.  Calendar sharing, 
Free/busy, Contact list sharing, Tasks, Inbox sharing controlled by ACL 
for read/write.


Congrats again on the tuto.

Chris C.



On 2/13/2015 8:53 AM, Olivier Bitsch wrote:

Dear SOGo users,

After long time without any update, I finally manage to update my 
tutorial regarding the installation of Samba4, OpenChange and Sogo. We 
still having a lot of visits on our website, so we cannot imagine to 
let the tutorial outdated.


As reminder, the tutorial page link is:
http://iabsis.com/en/community/tuto/openchange-samba4-debian

Please let me a comment in my mail, or you can ask any question on our 
new forum.


I hope we will take fun to read my tutorial.

Have a nice weekend.

Regards

Olivier B.


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