[SOGo] BTS activities for Monday, March 20 2017

[SOGo reporter]

Title: BTS activities for Monday, March 20 2017





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Monday, March 20 2017

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
1205
	2017-03-20 08:17:10
	updated (open)
	Backend Address Book
	update the vcard handling to VCARD 4 spec
	
	  
	
4091
	2017-03-20 08:17:10
	updated (open)
	Backend Address Book
	only one postal address of the same type gets stored in the database
	
	  
	
3988
	2017-03-20 05:14:37
	updated (open)
	Backend Calendar
	Subscription to calendars deleted when database is unreachable
	
	  
	
4083
	2017-03-20 07:27:14
	updated (open)
	Backend Calendar
	too many database connections
	
	  
	
4090
	2017-03-20 06:12:59
	updated (open)
	Web Address Book
	incomplete informations after exporting contacts
	
	  
	
4012
	2017-03-20 04:19:59
	feedback (reopened)
	Backend Calendar
	All subscribed calendars are "Included in free-busy"
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] Preferred patch process

[Gordon Messmer]

On 03/20/2017 10:45 AM, Francis Lachapelle" (flachape...@inverse.ca) wrote:

Opening a PR is sufficient. Just be patient



I've got a handful of PRs to the rpm spec that have been open since Dec 10.

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

Re: [SOGo] Installing SOGo in an mutliserver environment

["Roland Wolters"]

Hi Michael,

my setup is:
- PostgreSQL DB
- OpenLDAP
- Dovecot (IMAP)
- Postfix (SMTP)
- SOGo Webfrontend
- nginx reverse proxy

Each service is running in its own Docker container and thus on its own 
instance. So no need to run the Apache web server on the IMAP server. Actually 
the SOGo server is just an IMAP client to Dovecot. Works pretty smooth.

Cheers,
Roland

Am 20.03.2017 1:37 nachm. schrieb "michael.goldfin...@inhouse.wko.at" 
:
Hello,
 
I try to achieve the goal to install SOGo in an multiserver environment.
I have 3 Servers available
1)Database-Server
2)Web-Server
3)Mail-Server
Al Servers running CentOS in the current version.
The Database Server is running MariaDB and Postgresql, the Webserver is running 
nginx with php-fpm, the Mail-Server is a minimal setup of CentOS 7.
 
I want to install SOGo in a way that the DB is hold on the Database Server, the 
Website is delivered through the Webserver and the rest is running on the 
Email-Server.
Is that kind of setup even possible and is there a documentation about that?
 
Since I found no documentation about this setup on the internet I started with 
the installation of the nightly build rpm package on the email server. I 
noticed that apache got installed as requirement, but I do not want an apache 
running on the Email-server that’s what the Webserver is for.
 
Regards
Michael Goldfinger
 
-- 
users@sogo.nu
https://inverse.ca/sogo/lists--
Roland Wolters
mobile: +49 173 294 678 6
e-mail: r...@bayz.de
blog: https://liquidat.wordpress.com
twitter: @liquidat
jabber: liqui...@jabber.de
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Preferred patch process

[Francis Lachapelle]

Hello Gordon

> On Mar 20, 2017, at 1:10 PM, Gordon Messmer (gordon.mess...@gmail.com) 
>  wrote:
> 
> When submitting changes to SOGo, should we be filing bugs at 
> https://sogo.nu/bugs/ in addition to pull requests, or is a pull request on 
> github sufficient?

Opening a PR is sufficient. Just be patient :)

Thanks,

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

[SOGo] Preferred patch process

[Gordon Messmer]

When submitting changes to SOGo, should we be filing bugs at 
https://sogo.nu/bugs/ in addition to pull requests, or is a pull request 
on github sufficient?


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

Re: [SOGo] A few questions about Calendars

[Christian Mack]

Hello

Am 20.03.2017 um 17:44 schrieb "Sten Anderson" (s...@mooncascade.com):
> 
> I guess that's better than nothing. Maybe it would be possible to modify 
> something straight in the database?
> 
> On Monday, March 20, 2017 16:57 EET, "mgwebm...@fastmail.fm"  
> wrote:
>2. Is it possible to automatically subscribe new users to certain 
> calendars? It would be very helpful to add room calendars automatically for 
> new employees.
>   Christian suggested to follow this procedure : 
>  * You need a user which is listed in SOGoSuperUsernames for the needed * 
> privileges. * Login as this super user into the webinterface. * Go to menu 
> "Administration”. In the search field at the top right corner type the 
> account name in the middle column. * Click on it. This will show you her 
> calendars and addressbooks below her name in the middle column. * Select the 
> calendar or addressbook you want to change privileges on. * In the right most 
> pane you will get the list of privileged users already defined for that 
> resource. * Now you can add a new user by typing his account in the right 
> most panes "Add User" field. * Select this new user and change her 
> privileges. Unfortunately it doesn’t cover your need (which is also ours) 
> since Christian, the user still has to subscribe manually to the resource. I 
> wanted them (all users) to be subscribed as soon as they log in. That would 
> be useful for a corporate calendar and/or shared company or department 
> address book. Matthieu 

SOGo 2.3.20 has a new sogo-tool option:
sogo-tool manage-acl

This will come in the next version 3 too.


Kind regards,
Christian Mack

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



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] A few questions about Calendars

["Sten Anderson"]

I guess that's better than nothing. Maybe it would be possible to modify 
something straight in the database?

On Monday, March 20, 2017 16:57 EET, "mgwebm...@fastmail.fm"  
wrote:
   2. Is it possible to automatically subscribe new users to certain calendars? 
It would be very helpful to add room calendars automatically for new employees.
  Christian suggested to follow this procedure : 
 * You need a user which is listed in SOGoSuperUsernames for the needed * 
privileges. * Login as this super user into the webinterface. * Go to menu 
"Administration”. In the search field at the top right corner type the account 
name in the middle column. * Click on it. This will show you her calendars and 
addressbooks below her name in the middle column. * Select the calendar or 
addressbook you want to change privileges on. * In the right most pane you will 
get the list of privileged users already defined for that resource. * Now you 
can add a new user by typing his account in the right most panes "Add User" 
field. * Select this new user and change her privileges. Unfortunately it 
doesn’t cover your need (which is also ours) since Christian, the user still 
has to subscribe manually to the resource. I wanted them (all users) to be 
subscribed as soon as they log in. That would be useful for a corporate 
calendar and/or shared company or department address book. Matthieu 
--
users@sogo.nu
https://inverse.ca/sogo/lists--
users@sogo.nu
https://inverse.ca/sogo/lists


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

Re: [SOGo] Installing SOGo in an mutliserver environment

[Christian Mack]

Am 20.03.2017 um 16:08 schrieb michael.goldfin...@inhouse.wko.at:
>> Am 20.03.2017 um 13:37 schrieb michael.goldfin...@inhouse.wko.at:
>>> Hello,
>>>
>>> I try to achieve the goal to install SOGo in an multiserver
>>> environment. I have 3 Servers available
>>>
>>> 1)Database-Server
>>>
>>> 2)Web-Server
>>>
>>> 3)Mail-Server Al Servers running CentOS in the current version. 
>>> The Database Server is running MariaDB and Postgresql, the Webserver
>>> is running nginx with php-fpm, the Mail-Server is a minimal setup of
>>> CentOS 7.
>>>
>>> I want to install SOGo in a way that the DB is hold on the Database
>>> Server, the Website is delivered through the Webserver and the rest
>>> is running on the Email-Server. Is that kind of setup even possible
>>> and is there a documentation about that?
>>>
>>
>> Sure, this is a simple setup.
>> But why MariaDB and Postgresql?
> 
> We use some software that runs exclusively on MariaDB or Postgesql.
> Currently we try reduce this to the most common base, so you can assume that 
> in the near future
> MariaDB ist the only Database on the server left.
> 

OK, that makes sense.
It sounded as if you want to use both for SOGo :-)

>>
>> Documentation:
>> https://sogo.nu/files/docs/SOGoInstallationGuide.html
>> https://sogo.nu/nc/support/faq/article/how-to-install-sogo-and-sope-through-yum-2.html
>> http://wiki.sogo.nu/nginxSettings
>>
>> You will also need an IMAP server. I recommend dovecot:
>> http://wiki2.dovecot.org/FrontPage?action=show=StartSeite
>>
> Thanks for the Information I will look into it.
>>
>>> Since I found no documentation about this setup on the internet I
>>> started with the installation of the nightly build rpm package on the
>>> email server. I noticed that apache got installed as requirement, but
>>> I do not want an apache running on the Email-server that’s what the
>>> Webserver is for.
>>>
>>
>> I do not understand, what you installed, or what you wanted to achieve.
>> Please be more precise.
> 
> I followed the instuctions on https://sogo.nu/download.html
> 
> sudo rpm --import 
> 'http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C'
> sudo rpm -ivh 
> http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
> sudo cat >/etc/yum.repos.d/SOGo.repo < [sogo]
> name=SOGo Repository
> baseurl=https://packages.inverse.ca/SOGo/nightly/3/rhel/7/\$basearch
> gpgcheck=1
> EOF
> sudo yum install sogo
> 

You do not want to install that on the email server.
Install an IMAP server of your choice (dovecot or cyrus ...) and perhaps
an SMTP server like postfix or exim on the email server.
As you already have MariaDB installed, you only need to create a sogo
database on it with matching user.
Then you install nginx and sogod on the webserver.
For sogod you need the above steps to prepare the necessary repos.


Kind regards,
Christian Mack

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



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Installing SOGo in an mutliserver environment

[Andreas Haumer]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi!

Am 20.03.2017 um 16:08 schrieb michael.goldfin...@inhouse.wko.at:
>> Am 20.03.2017 um 13:37 schrieb michael.goldfin...@inhouse.wko.at:
>>> Hello,
>>> 
>>> I try to achieve the goal to install SOGo in an multiserver environment. I 
>>> have 3 Servers available
>>> 
>>> 1)Database-Server
>>> 
>>> 2)Web-Server
>>> 
>>> 3)Mail-Server Al Servers running CentOS in the current version. The 
>>> Database Server is running MariaDB and Postgresql, the Webserver is running 
>>> nginx with php-fpm, the Mail-Server is a minimal setup of CentOS 7.
>>> 
>>> I want to install SOGo in a way that the DB is hold on the Database Server, 
>>> the Website is delivered through the Webserver and the rest is running on 
>>> the Email-Server. Is that kind of setup even possible and is there a 
>>> documentation about that?
>>> 
>> 
>> Sure, this is a simple setup. But why MariaDB and Postgresql?
> 
> We use some software that runs exclusively on MariaDB or Postgesql. Currently 
> we try reduce this to the most common base, so you can assume that in the 
> near future MariaDB ist the only Database on the server left.
> 

We run several SOGo installations with DB-Server (PostgreSQL),
Mail-Server (Cyrus IMAP) and SOGo-Server separated on different machines.
On the SOGo server we always have apache installed (as proxy to SOGo on
port 2/tcp)

On some installations we additionally have a public webserver
(apache) in front (as reverse-proxy, in a DMZ).

On our installations we have CentOS and OpenSUSE running.

Works and scales quite well!

Especially with SOGo you have any freedom to choose your setup
in a way it optimally fits your requirements.

- - andreas

- -- 
Andreas Haumer | mailto:andr...@xss.co.at
*x Software + Systeme  | http://www.xss.co.at/
Karmarschgasse 51/2/20 | Tel: +43-1-6060114-0
A-1100 Vienna, Austria | Fax: +43-1-6060114-71
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.22 (GNU/Linux)

iD8DBQFYz/W7xJmyeGcXPhERAvLgAKCFSrkuDo/pSK0Yc9vOQe4ncass6ACeKDks
Lcpu1H365DLowa27vqXLrhM=
=L5DV
-END PGP SIGNATURE-
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

AW: [SOGo] Installing SOGo in an mutliserver environment

[michael.goldfin...@inhouse.wko.at]

>Am 20.03.2017 um 13:37 schrieb michael.goldfin...@inhouse.wko.at:
>> Hello,
>> 
>> I try to achieve the goal to install SOGo in an multiserver
>> environment. I have 3 Servers available
>> 
>> 1)Database-Server
>> 
>> 2)Web-Server
>> 
>> 3)Mail-Server Al Servers running CentOS in the current version. 
>> The Database Server is running MariaDB and Postgresql, the Webserver
>> is running nginx with php-fpm, the Mail-Server is a minimal setup of
>> CentOS 7.
>> 
>> I want to install SOGo in a way that the DB is hold on the Database
>> Server, the Website is delivered through the Webserver and the rest
>> is running on the Email-Server. Is that kind of setup even possible
>> and is there a documentation about that?
>> 
>
>Sure, this is a simple setup.
>But why MariaDB and Postgresql?

We use some software that runs exclusively on MariaDB or Postgesql.
Currently we try reduce this to the most common base, so you can assume that in 
the near future
MariaDB ist the only Database on the server left.

>
>Documentation:
>https://sogo.nu/files/docs/SOGoInstallationGuide.html
>https://sogo.nu/nc/support/faq/article/how-to-install-sogo-and-sope-through-yum-2.html
>http://wiki.sogo.nu/nginxSettings
>
>You will also need an IMAP server. I recommend dovecot:
>http://wiki2.dovecot.org/FrontPage?action=show=StartSeite
>
Thanks for the Information I will look into it.
>
>> Since I found no documentation about this setup on the internet I
>> started with the installation of the nightly build rpm package on the
>> email server. I noticed that apache got installed as requirement, but
>> I do not want an apache running on the Email-server that’s what the
>> Webserver is for.
>> 
>
>I do not understand, what you installed, or what you wanted to achieve.
>Please be more precise.

I followed the instuctions on https://sogo.nu/download.html

sudo rpm --import 
'http://pgp.mit.edu/pks/lookup?op=get=0xCB2D3A2AA0030E2C'
sudo rpm -ivh 
http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
sudo cat >/etc/yum.repos.d/SOGo.repo 
>
>Kind regards,
>Christian Mack

Kind regards,
Michael Goldfinger
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] A few questions about Calendars

[mgwebm...@fastmail.fm]

> 
> 2. Is it possible to automatically subscribe new users to certain calendars? 
> It would be very helpful to add room calendars automatically for new 
> employees.
> 

Christian suggested to follow this procedure : 
You need a user which is listed in SOGoSuperUsernames for the needed
privileges.
Login as this super user into the webinterface.
Go to menu "Administration”. In the search field at the top right corner type 
the account name in the middle column.
Click on it. This will show you her calendars and addressbooks below her name 
in the middle column.
Select the calendar or addressbook you want to change privileges on.
In the right most pane you will get the list of privileged users already 
defined for that resource.
Now you can add a new user by typing his account in the right most panes "Add 
User" field.
Select this new user and change her privileges.

Unfortunately it doesn’t cover your need (which is also ours) since Christian, 
the user still has to subscribe manually to the resource. I wanted them (all 
users) to be subscribed as soon as they log in. That would be useful for a 
corporate calendar and/or shared company or department address book.

Matthieu

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

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

[SOGo] A few questions about Calendars

[Sten Anderson]

1. Is it possible to check the availability of attendees when booking 
events from the phone (iOS, Android) using CalDAV?


2. Is it possible to automatically subscribe new users to certain 
calendars? It would be very helpful to add room calendars automatically 
for new employees.



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

Re: [SOGo] Installing SOGo in an mutliserver environment

[slavek.ba...@axis.cz]

On Monday 20 of March 2017 13:37:23 michael.goldfin...@inhouse.wko.at 
wrote:
> Hello,
>
> I try to achieve the goal to install SOGo in an multiserver
> environment. I have 3 Servers available
>
> 1)Database-Server
>
> 2)Web-Server
>
> 3)Mail-Server
> Al Servers running CentOS in the current version.
> The Database Server is running MariaDB and Postgresql, the Webserver is
> running nginx with php-fpm, the Mail-Server is a minimal setup of
> CentOS 7.
>
> I want to install SOGo in a way that the DB is hold on the Database
> Server, the Website is delivered through the Webserver and the rest is
> running on the Email-Server. Is that kind of setup even possible and is
> there a documentation about that?
>
> Since I found no documentation about this setup on the internet I
> started with the installation of the nightly build rpm package on the
> email server. I noticed that apache got installed as requirement, but I
> do not want an apache running on the Email-server that’s what the
> Webserver is for.
>
> Regards
> Michael Goldfinger

You can install SOGo on web-server. SOGo works like a regular imap client 
so can access to the separate mail-server.

Cheers
-- 
Slávek
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Installing SOGo in an mutliserver environment

[Christian Mack]

Am 20.03.2017 um 13:37 schrieb michael.goldfin...@inhouse.wko.at:
> Hello,
> 
> I try to achieve the goal to install SOGo in an multiserver
> environment. I have 3 Servers available
> 
> 1)Database-Server
> 
> 2)Web-Server
> 
> 3)Mail-Server Al Servers running CentOS in the current version. 
> The Database Server is running MariaDB and Postgresql, the Webserver
> is running nginx with php-fpm, the Mail-Server is a minimal setup of
> CentOS 7.
> 
> I want to install SOGo in a way that the DB is hold on the Database
> Server, the Website is delivered through the Webserver and the rest
> is running on the Email-Server. Is that kind of setup even possible
> and is there a documentation about that?
> 

Sure, this is a simple setup.
But why MariaDB and Postgresql?

Documentation:
https://sogo.nu/files/docs/SOGoInstallationGuide.html
https://sogo.nu/nc/support/faq/article/how-to-install-sogo-and-sope-through-yum-2.html
http://wiki.sogo.nu/nginxSettings

You will also need an IMAP server. I recommend dovecot:
http://wiki2.dovecot.org/FrontPage?action=show=StartSeite


> Since I found no documentation about this setup on the internet I
> started with the installation of the nightly build rpm package on the
> email server. I noticed that apache got installed as requirement, but
> I do not want an apache running on the Email-server that’s what the
> Webserver is for.
> 

I do not understand, what you installed, or what you wanted to achieve.
Please be more precise.


Kind regards,
Christian Mack

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



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] Installing SOGo in an mutliserver environment

[michael.goldfin...@inhouse.wko.at]

Hello,

I try to achieve the goal to install SOGo in an multiserver environment.
I have 3 Servers available

1)Database-Server

2)Web-Server

3)Mail-Server
Al Servers running CentOS in the current version.
The Database Server is running MariaDB and Postgresql, the Webserver is running 
nginx with php-fpm, the Mail-Server is a minimal setup of CentOS 7.

I want to install SOGo in a way that the DB is hold on the Database Server, the 
Website is delivered through the Webserver and the rest is running on the 
Email-Server.
Is that kind of setup even possible and is there a documentation about that?

Since I found no documentation about this setup on the internet I started with 
the installation of the nightly build rpm package on the email server. I 
noticed that apache got installed as requirement, but I do not want an apache 
running on the Email-server that’s what the Webserver is for.

Regards
Michael Goldfinger

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