RE: [SOGo] ActiveSync Question ** Update **

["Robert Himics"]

And Here is another Block with errors

2024-01-22 23:06:25.279 sogod[16188:16188]  SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d';

2024-01-22 23:06:25.280 sogod[16188:16188]query has results, entering fetch-mode.

2024-01-22 23:06:25.281 sogod[16188:16188]  SQL: INSERT INTO sogo_cache_folder  (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified,   c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'HAJkaXNwbGF5TmFtZQAGSU5CT1gAAA==');

2024-01-22 23:06:25.281 sogod[16188:16188]ERROR: Field 'c_uid' doesn't have a default
value

Jan 22 23:06:25 sogod [16188]: [ERROR]
<0x5609af8ed9b0[SOGoCacheGCSObject]:641E1A9E3AD644BC89A235F3906A60F5+folder8
79a9b26eb22ac65c60ea739561d> could not insert/update record for record
'/641E1A9E3AD644BC89A235F3906A60F5+folder879a9b26eb22ac65c60ea739561d'
in sogo_cache_folder:  NAME:ExecutionFailed
REASON:Field 'c_uid' doesn't have a default value

2024-01-22 23:06:25.283 sogod[16188:16188]  SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d';

2024-01-22 23:06:25.283 sogod[16188:16188]query has results, entering fetch-mode.

2024-01-22 23:06:25.284 sogod[16188:16188]  SQL: INSERT INTO sogo_cache_folder  (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified,   c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'HQJkaXNwbGF5TmFtZQAHRHJhZnRzAAA=');

2024-01-22 23:06:25.285 sogod[16188:16188]ERROR: Field 'c_uid' doesn't have a default
value

Jan 22 23:06:25 sogod [16188]: [ERROR]
<0x5609af748410[SOGoCacheGCSObject]:641E1A9E3AD644BC89A235F3906A60F5+folder7
65ed91e067dac65b416a739561d> could not insert/update record for record
'/641E1A9E3AD644BC89A235F3906A60F5+folder765ed91e067dac65b416a739561d'
in sogo_cache_folder:  NAME:ExecutionFailed
REASON:Field 'c_uid' doesn't have a default value

2024-01-22 23:06:25.286 sogod[16188:16188]  SQL: SELECT * FROM sogo_cache_folder WHERE
c_path =
'/641E1A9E3AD644BC89A235F3906A60F5+folder5871c02a067dac65b416a739561d';

2024-01-22 23:06:25.287 sogod[16188:16188]query has results, entering fetch-mode.

2024-01-22 23:06:25.287 sogod[16188:16188]  SQL: INSERT INTO sogo_cache_folder  (c_path,
c_parent_path, c_type, c_creationdate, c_lastmodified,   c_deleted,
c_version, c_content) VALUES
('/641E1A9E3AD644BC89A235F3906A60F5+folder5871c02a067dac65b416a739561d',
NULL, 201, 1705982785, 1705982785, 0, 0,
'GwJkaXNwbGF5TmFtZQAFU2VudAAA');


Is Something missing in the Database Cofiguration

or Due to the First Error c_uid is Not being Retrieved right 


My sogo User table is a View Based on the Dovecot users table

++--+--+-+-+---+

| Field  | Type | Null | Key | Default | Extra |

++--+--+-+-+---+

| c_uid  | varchar(100) | NO   | | NULL|   |

| c_name | varchar(100) | NO   | | NULL|   |

| c_cn   | varchar(120) | NO   | | NULL|   |

| c_password | varchar(64)  | NO   | | NULL|   |

| mail   | varchar(100) | NO   | | NULL|   |

++--+--+-+-+---+

 

 

Robert Himics 
  r...@himicsfamily.com

 

From: "Robert Himics"
 
Sent: Monday, January 22, 2024 11:26 PM
To: users@sogo.nu
Subject: RE: ActiveSync Question ** Update **

 

After turning on active Sync Logging I see an Error that Repeats

2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[2]

2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[1]

2024-01-22 23:04:28.734 sogod[16189:16189] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[2]

2024-01-22 23:04:28.739 sogod[16188:16188] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[1]

Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri
'/SOGo/Microsoft-Server-ActiveSync'

2024-01-22 23:06:23.005 sogod[16188:16188] MySQL4 connection established
0x0x5609af69d250

2024-01-22 23:06:23.005 sogod[16188:16188] -- -[MySQL4Channel
openChannel]: 
opens channel count[0]

2024-01-22 23:06:23.006 sogod[16188:16188] MySQL4 channel 0x0x5609af7ff600
opened (connection=0x0x5609af69d250,grpware)

2024-01-22 23:06:23.009 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_domain WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.011 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error

RE: [SOGo] ActiveSync Question ** Update **

["Robert Himics"]

After turning on active Sync Logging I see an Error that Repeats

2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[2]

2024-01-22 23:04:28.722 sogod[16190:16190] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[1]

2024-01-22 23:04:28.734 sogod[16189:16189] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[2]

2024-01-22 23:04:28.739 sogod[16188:16188] -- -[MySQL4Channel
primaryCloseChannel]:  close channel count[1]

Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri
'/SOGo/Microsoft-Server-ActiveSync'

2024-01-22 23:06:23.005 sogod[16188:16188] MySQL4 connection established
0x0x5609af69d250

2024-01-22 23:06:23.005 sogod[16188:16188] -- -[MySQL4Channel
openChannel]: 
opens channel count[0]

2024-01-22 23:06:23.006 sogod[16188:16188] MySQL4 channel 0x0x5609af7ff600
opened (connection=0x0x5609af69d250,grpware)

2024-01-22 23:06:23.009 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_domain WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.011 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key 'em...@domain.net+attributes': "SERVER
HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"

Jan 22 23:06:23 sogod [16188]: |SOGo| request took 0.009757 seconds to
execute

Jan 22 23:06:23 sogod [16188]: 000.000.000.000 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.013 - - 256K - 11

Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'OPTIONS' on uri
'/SOGo/Microsoft-Server-ActiveSync'

2024-01-22 23:06:23.122 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_familyhome WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.123 sogod[16188:16188]query has results, entering fetch-mode.

2024-01-22 23:06:23.123 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_dmfamilyhome
WHERE (c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.124 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key 'em...@domain.net+attributes': "SERVER
HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"

Jan 22 23:06:23 sogod [16188]: |SOGo| request took 0.004947 seconds to
execute

Jan 22 23:06:23 sogod [16188]: 000.000.000.000 "OPTIONS
/SOGo/Microsoft-Server-ActiveSync HTTP/1.0" 200 0/0 0.007 - - 0 - 11

Jan 22 23:06:23 sogod [16188]: |SOGo| starting method 'POST' on uri
'/SOGo/Microsoft-Server-ActiveSync?Cmd=FolderSync=em...@domain.net
ceId=641E1A9E3AD644BC89A235F3906A60F5=WindowsOutlook15'

2024-01-22 23:06:23.141 sogod[16188:16188]  SQL: SELECT * FROM sogo_users_domaine WHERE
(c_uid = 'em...@domain.net') OR (mail = 'em...@domain.net');

2024-01-22 23:06:23.143 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609af0cf610[SOGoCache]> an error
occurred when caching value for key 'em...@domain.net+attributes': "SERVER
HAS FAILED AND IS DISABLED UNTIL TIMED RETRY"

2024-01-22 23:06:23.145 sogod[16188:16188]  SQL: SELECT count(*) FROM
sogo_cache_folder_email_A_domain_D_net;

2024-01-22 23:06:23.146 sogod[16188:16188]query has results, entering fetch-mode.

Jan 22 23:06:23 sogod [16188]: <0x0x5609aef83ac0[SOGoActiveSyncDispatcher]>
EAS - request for device 641E1A9E3AD644BC89A235F3906A60F5: 

http://www.microsoft.com/>



0



 

 

I have scrubbed any IP Addresses / Email Addresses from Log Extract

 

Robert Himics 
  r...@himicsfamily.com

 

From: "Robert Himics"
 
Sent: Monday, January 22, 2024 10:39 PM
To: users@sogo.nu
Subject: RE: ActiveSync Question

 

Question:

 

Trying to Configure ActiveSync to connect Through Microsoft Office 365.

 

I don't see any outright Errors in the Log



I Can Connect to the SOGo ActiveSync But I am Not getting any Emails Listed
from the inbox.

I know there are Email Present can Log into the web UI to see emails.

 

I have tried on Multiple PCs Running Microsoft Office 365.

 

Using the nightly build - sogo-activesync-5.9.1.20231220-1.el9.x86_64.rpm

 

Robert Himics 
  r...@himicsfamily.com

 

RE: [SOGo] ActiveSync Question

["Robert Himics"]

Question:

 

Trying to Configure ActiveSync to connect Through Microsoft Office 365.

 

I don't see any outright Errors in the Log



I Can Connect to the SOGo ActiveSync But I am Not getting any Emails Listed
from the inbox.

I know there are Email Present can Log into the web UI to see emails.

 

I have tried on Multiple PCs Running Microsoft Office 365.

 

Using the nightly build - sogo-activesync-5.9.1.20231220-1.el9.x86_64.rpm

 

Robert Himics 
  r...@himicsfamily.com

 

[SOGo] CalDav question

[William Bowden]

I have an installation of iRedmail with SOGo happily working, my question is 
about inviting in the calendar.

1   Can you invite outside of domain?
2.When in a shared calendar the ability to invite is missing I need this 
have I made a mistake?

Thank you

William Bowden | JMRIT Consultants
Consultant Engineer | m:07525 645105 | e:will...@jmrit.co.uk






smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] docs question: native outlook

[mj]

On 08/12/2017 01:04 PM, mj (li...@merit.unu.edu) wrote:
How can you do last thing? Restrict access to an ip to a specific 
process only? Does anyone know?


Just to share my own findings:

The only thing I came up with, is to try something like:

iptables -A OUTPUT -i lo --dport 143 -m owner --uid-owner 999 -j ACCEPT
iptables -A OUTPUT -i lo --dport 143 -j DROP

On our system: id sogo
uid=999(sogo) gid=999(sogo) groups=999(sogo)

(According to the man page -m owner is only valid in the OUTPUT chain)

But even if this would work, I'm unsure about potential unwanted 
side-effects, plus it seems suboptimal to me...


Since the SOGo docs recommend to restrict access only to the sogo 
process, I hope someone here has another tip/idea for us?


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

[SOGo] docs question: native outlook

[mj]

Hi,

I realise that the modern way of using outlook is over ActiveSync, 
rather then OpenChange. But nevertheless I a small question on the 
SOGoNativeOutlookConfigurationGuide:


Create a dovecot password-less imap listener with:
  args = nopassword=y allow_nets=127.0.0.1/32

And then:

"You should also make sure that you restrain this only to the SOGo 
processes"


How can you do last thing? Restrict access to an ip to a specific 
process only? Does anyone know?


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

Re: [SOGo] General Question

[Steve Ankeny]

On 10/09/2015 08:17 AM, Christian Eichert wrote:

OK, so it looks like I need a example of using SogoUserSources with Mysql
Can someone help please?


Am 09-10-2015 um 13:29 schrieb Christian Eichert:

I am a bit confused about SOGo
It looks to be a nice combination of webmail calendar and addressbook.

I have installed it and configured it as best I can, (of course its 
not working yet, else everybody would use it) and now I reached the 
point where it comes to the user configuration. I am using Dovecot 
with Postfix and virtual users in a MySQL database.


Now SOG is demanding a LDAP usermanagement.
Is there a way to access this already existing user database I am 
using with dovecot?


mfg
Christian Eichert



Have you looked in '/etc/sogo/sogo.conf'?

  /* SQL authentication example */
  /*  These database columns MUST be present in the view/table:
   *c_uid - will be used for authentication -  it's the username or 
usern...@domain.tld)
   *c_name - which can be identical to c_uid -  will be used to 
uniquely identify entries
   *c_password - password of the user, plain-text, md5 or sha 
encoded for now

   *c_cn - the user's common name - such as "John Doe"
   *mail - the user's mail address
   *  See the installation guide for more details
   */
  //SOGoUserSources =
  //  (
  //{
  //  type = sql;
  //  id = directory;
  //  viewURL = "mysql://sogo:$Isaiah53@127.0.0.1:3306/sogo/sogo_view";
  //  canAuthenticate = YES;
  //  isAddressBook = YES;
  //  userPasswordAlgorithm = md5;
  //}
  //  );

That plus the Installation guide should walk you through it.


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

Re: [SOGo] General Question

[Kai-Uwe Rommel]

users-requ...@sogo.nu wrote on 09.10.2015 14:17:06:
> 
> OK, so it looks like I need a example of using SogoUserSources with 
Mysql
> Can someone help please?

I installed such a setup a few months ago (using MySQL for authentication
for both Postfix/Dovecot and SOGo). I used this as a (german) guideline:

https://www.foteviken.de/?p=1247

It is not perfect but I was able to get my server up and running this way.

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

[SOGo] General Question

[Christian Eichert]

I am a bit confused about SOGo
It looks to be a nice combination of webmail calendar and addressbook.

I have installed it and configured it as best I can, (of course its not 
working yet, else everybody would use it) and now I reached the point 
where it comes to the user configuration. I am using Dovecot with 
Postfix and virtual users in a MySQL database.


Now SOG is demanding a LDAP usermanagement.
Is there a way to access this already existing user database I am using 
with dovecot?


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

Re: [SOGo] General Question

[Christian Eichert]

OK, so it looks like I need a example of using SogoUserSources with Mysql
Can someone help please?


Am 09-10-2015 um 13:29 schrieb Christian Eichert:

I am a bit confused about SOGo
It looks to be a nice combination of webmail calendar and addressbook.

I have installed it and configured it as best I can, (of course its 
not working yet, else everybody would use it) and now I reached the 
point where it comes to the user configuration. I am using Dovecot 
with Postfix and virtual users in a MySQL database.


Now SOG is demanding a LDAP usermanagement.
Is there a way to access this already existing user database I am 
using with dovecot?


mfg
Christian Eichert


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

Re: [SOGo] General Question

[Sven Schwedas]

Installation handbook, page 31, "Authentication using SQL" …

On 2015-10-09 13:29, Christian Eichert wrote:
> I am a bit confused about SOGo
> It looks to be a nice combination of webmail calendar and addressbook.
> 
> I have installed it and configured it as best I can, (of course its not
> working yet, else everybody would use it) and now I reached the point
> where it comes to the user configuration. I am using Dovecot with
> Postfix and virtual users in a MySQL database.
> 
> Now SOG is demanding a LDAP usermanagement.
> Is there a way to access this already existing user database I am using
> with dovecot?
> 
> mfg
> Christian Eichert

-- 
Mit freundlichen Grüßen, / Best Regards,
Sven Schwedas
Systemadministrator
TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz
Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167
http://software.tao.at



signature.asc
Description: OpenPGP digital signature

Re: [SOGo] General Question

[Christian M. Jensen]

Hello.

Den 09-10-2015 kl. 13:29 skrev Christian Eichert:

I am a bit confused about SOGo
It looks to be a nice combination of webmail calendar and addressbook.

I have installed it and configured it as best I can, (of course its 
not working yet, else everybody would use it) and now I reached the 
point where it comes to the user configuration. I am using Dovecot 
with Postfix and virtual users in a MySQL database.


Now SOG is demanding a LDAP usermanagement.
Is there a way to access this already existing user database I am 
using with dovecot?


yes read authentication using sql
https://github.com/inverse-inc/sogo/blob/master/Documentation/SOGoInstallationGuide.asciidoc#authentication-using-sql
i use it for multiple domains all stored in MySQL

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

Re: [SOGo] General Question

[Peter Beck]

On 10/09/2015 01:29 PM, Christian Eichert wrote:

I am a bit confused about SOGo
It looks to be a nice combination of webmail calendar and addressbook.

I have installed it and configured it as best I can, (of course its 
not working yet, else everybody would use it) and now I reached the 
point where it comes to the user configuration. I am using Dovecot 
with Postfix and virtual users in a MySQL database.


Now SOG is demanding a LDAP usermanagement.
Is there a way to access this already existing user database I am 
using with dovecot?

Hi Christian,

I don't think SOGo is demanding LDAP, you can also use SQL for example. 
(see manual page 31).
But I wouldn't try to extend an existing database with the needed tables 
as if there are sql updates in newer versions of SOGo


There is another thread [1] from 2012 regarding the similar issue and 
Christian Mack mentioned creating a view which collects the data from 
existing tables.


Regards
Peter

[1] https://lists.inverse.ca/sogo/arc/users/2012-09/msg00288.html


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

Re: [SOGo] Outlook question . . .

[Martin Simovic]

Hi,

> On 25 Sep 2015, at 18:46, Steve Ankeny  wrote:
> 
> On 09/25/2015 12:16 PM, Martin Simovic wrote:
>> Hi
>> 
>>> On 25 Sep 2015, at 16:43, Steve Ankeny < 
>>> stev...@cinergymetro.net 
>>> > wrote:
>>> 
>>> I am using MariaDB 10.0.21, Ubuntu Trusty 14.04, Dovecot & Postfix, 
>>> OpenChange/OCSManager 2.4
>>> 
>>> What can I do to troubleshoot or resolve this problem?  
>>> OpenChange/OCSManager installed after the recent upgrade but when they're 
>>> initiated by DCERPC calls, they shutdown my Samba AD DC server.
>> 
>> Two questions:
>> 
>> 1. What version of Samba do you use?
>> 2. Have you EVER had working Openchange setup?
>> 
>> Best Regards
>> Martin.
> 
> 1 --
> 
> adam@sogo:~$ sudo apt-cache policy samba
> samba:
>   Installed: 2:4.1.18+dfsg-3~inverse1
>   Candidate: 2:4.1.18+dfsg-3~inverse1
>   Version table:
>  *** 2:4.1.18+dfsg-3~inverse1 0
> 600 http://inverse.ca/ubuntu/  
> trusty/trusty amd64 Packages
> 100 /var/lib/dpkg/status
>  2:4.1.6+dfsg-1ubuntu2.14.04.9 0
> 500 http://us.archive.ubuntu.com/ubuntu/ 
>  trusty-updates/main amd64 Packages
>  2:4.1.6+dfsg-1ubuntu2.14.04.7 0
> 500 http://security.ubuntu.com/ubuntu/ 
>  trusty-security/main amd64 Packages
>  2:4.1.6+dfsg-1ubuntu2 0
> 500 http://us.archive.ubuntu.com/ubuntu/ 
>  trusty/main amd64 Packages
> adam@sogo:~$ 
> 
> 2 --
> 
> I have NEVER had a working OpenChange setup.
> 
> As I said previously, it ran fine all day yesterday until someone attempted 
> to use Outlook.  And, what I mean by that is, "All the appropriate servers 
> and services ran together until I attempted to setup Outlook."
> 
> 

1.This Samba version is not very stable when used together with openchange. 
Version 4.1.17 packaged by Zentyal seems to have much less problems.
2. Does not surprise me. I believe that openchange is not production ready, 
especially not with large mailboxes. Could not get it to sync my 3,5GB mailbox 
reliably ever.

Regards
Martin.


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

Re: [SOGo] Outlook question . . .

[Steve Ankeny]

On 09/28/2015 07:40 AM, Martin Simovic wrote:

Hi,

On 25 Sep 2015, at 18:46, Steve Ankeny > wrote:


On 09/25/2015 12:16 PM, Martin Simovic wrote:

Hi

On 25 Sep 2015, at 16:43, Steve Ankeny  
wrote:


I am using MariaDB 10.0.21, Ubuntu Trusty 14.04, Dovecot & Postfix, 
OpenChange/OCSManager 2.4


*What can I do to troubleshoot or resolve this 
problem?*OpenChange/OCSManager installed after the recent upgrade 
but when they're initiated by DCERPC calls, they shutdown my Samba 
AD DC server.


Two questions:

1. What version of Samba do you use?
2. Have you EVER had working Openchange setup?

Best Regards
Martin.


1 --

adam@sogo:~$ sudo apt-cache policy samba
samba:
  Installed: 2:4.1.18+dfsg-3~inverse1
  Candidate: 2:4.1.18+dfsg-3~inverse1
  Version table:
 *** 2:4.1.18+dfsg-3~inverse1 0
600 http://inverse.ca/ubuntu/ trusty/trusty amd64 Packages
100 /var/lib/dpkg/status
 2:4.1.6+dfsg-1ubuntu2.14.04.9 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main 
amd64 Packages

 2:4.1.6+dfsg-1ubuntu2.14.04.7 0
500 http://security.ubuntu.com/ubuntu/ trusty-security/main 
amd64 Packages

 2:4.1.6+dfsg-1ubuntu2 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 
Packages

adam@sogo:~$

2 --

I have NEVER had a working OpenChange setup.

As I said previously, it ran fine all day yesterday until someone 
attempted to use Outlook.  And, what I mean by that is, "All the 
appropriate servers and services ran together until I attempted to 
setup Outlook."





1.This Samba version is not very stable when used together with 
openchange. Version 4.1.17 packaged by Zentyal seems to have much less 
problems.
2. Does not surprise me. I believe that openchange is not production 
ready, especially not with large mailboxes. Could not get it to sync 
my 3,5GB mailbox reliably ever.


Regards
Martin.




Samba is updating their documentation wiki --

https://wiki.samba.org/index.php/Operating_system_requirements

On the list of Operating system requirements/Dependencies, I found I am 
missing 'xattr' & 'setproctitle'


The last is interesting, because I've had an error in my 'log.samba' 
from the first regarding 'setproctitle,' and the first in interesting, 
because the standard 'domain provision' utilizes 'xattr'  I'll install 
both libraries.


And, I will make sure I have these two installed before I try any "new" 
Samba AD DC configurations.


Many have had problems with OpenChange, so I'm not surprised by your 
observation.  I am not ready to remove my existing Samba 4.1.18 lest I 
go through the same problems I had installing it.


Ludovic tells me they build the ZEG after each upgrade from the 
repositories with no problem.  I am waiting for his response to my 
earlier questions.  Meanwhile, I am preparing to "build from scratch" 
yet again.


I want to get this right.  Thx for your response.

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

Re: [SOGo] Outlook question . . .

[Steve Ankeny]

On 09/25/2015 08:38 PM, Ludovic Marcotte wrote:

On 25/09/2015 15:40, Steve Ankeny wrote:
(1) What are the differences between Ubuntu Samba 4.1.6 and Inverse 
Samba 4.1.18 in terms of libraries?  Could there be some library or 
package from 4.1.6 which if removed would cause 4.1.18 to work properly?


It seems to me this might be the source of my problems, as I 
originally installed 4.1.6
If you use our repository for Samba packages, all should be 
up-to-date. Here is the bash Samba/OpenChancge function used in the 
script to prepare the ZEG:


function setupSambaOpenChange {
  mv /etc/samba/smb.conf /etc/samba/smb.conf.bak || true

  apt-get -y install samba openchangeserver sogo-openchange \
 openchangeproxy python-ocsmanager 
openchange-ocsmanager openchange-rpcproxy python-sievelib python-spyne 
python-rpclib python-mysqldb


  ln -s /etc/apache2/conf.d/ocsmanager.conf 
/etc/apache2/conf-available/ocsmanager.conf
  ln -s /etc/apache2/conf.d/rpcproxy.conf 
/etc/apache2/conf-available/rpcproxy.conf

  cat >/etc/apache2/conf.d/rpcproxy.conf <

Order deny,allow
Allow from all

= 2.4>
Require all granted


  SetEnv RPCPROXY_LOGLEVEL INFO
  SetEnv NTLMAUTHHANDLER_WORKDIR /var/cache/ntlmauthhandler
  SetEnv SAMBA_HOST 127.0.0.1
  WSGIPassAuthorization On
  WSGIProcessGroup %{GLOBAL}


WSGIScriptAlias /rpc/rpcproxy.dll 
/usr/lib/openchange/web/rpcproxy/rpcproxy.wsgi
WSGIScriptAlias /rpcwithcert/rpcproxy.dll 
/usr/lib/openchange/web/rpcproxy/rpcproxy.wsgi

EOF



My 'rpcproxy.conf' was not EXACTLY the same as here, but I've changed it.

It was missing the 'IfVersion' lines and specifically, 'Order, 
deny,allow' 'Allow from all'


THAT may or may not make a difference but I've modified mine to match 
your script.



  # ocsmanager
  cat >/etc/ocsmanager/ocsmanager.ini /etc/samba/smb.conf <

Again, the Configuration guide lists ONLY 'dcerpc endpoint servers = 
+epmapper, +mapiproxy'


I have been using 'dcerpc endpoint servers = +mapiproxy'

How important are these DCERPC calls when Samba AD includes 'epmapper' & 
'dnsserver' natively?


adam@sogo:~$ samba-tool testparm -v | grep 'dcerpc endpoint servers'

dcerpc endpoint servers = epmapper, wkssvc, rpcecho, samr, 
netlogon, lsarpc, spoolss, drsuapi, dssetup, unixinfo, browser, 
eventlog6, backupkey, dnsserver

adam@sogo:~$

It is my understanding that invoking 'epmapper' & 'dnsserver' through 
DCERPC calls disables --


wkssvc, rpcecho, samr, netlogon, lsarpc, spoolss, drsuapi, dssetup, 
unixinfo, browser, eventlog6, backupkey


Are we sure we want to "turn off" those endpoint servers?


dcerpc_mapiproxy:server = true
  dcerpc_mapiproxy:interfaces = exchange_emsmdb, exchange_nsp, 

Re: [SOGo] Outlook question . . .

[Martin Simovic]

Hi

> On 25 Sep 2015, at 16:43, Steve Ankeny  wrote:
> 
> I am using MariaDB 10.0.21, Ubuntu Trusty 14.04, Dovecot & Postfix, 
> OpenChange/OCSManager 2.4
> 
> What can I do to troubleshoot or resolve this problem?  OpenChange/OCSManager 
> installed after the recent upgrade but when they're initiated by DCERPC 
> calls, they shutdown my Samba AD DC server.

Two questions:

1. What version of Samba do you use?
2. Have you EVER had working Openchange setup?

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

Re: [SOGo] Outlook question . . .

[Steve Ankeny]

On 09/24/2015 04:12 PM, Steve Ankeny wrote:
Setting up "new" Outlook 2010 account following the "Outlook 
Configuration" guide (pg 18)


It's giving me the following error --





"The action cannot be completed.  The name cannot be matched to a name 
in the address list."


Is this a server error or an Outlook error?  It appears to me to be an 
Outlook error.


Should the account be setup within Outlook as well as under "Control 
Panel | Mail"?


I am using all the suggestions on pg 18  Thx



update ---

DCERPC calls "still" shutdown Samba AD DC (on my system)

Samba AD DC with OpenChange ran perfectly yesterday for almost 12 
hours.  However, it should be noted that no one was attempting to use 
Outlook until myself after 4PM EDT  That's when things went screwy.


I worked my way through the suggestions in the Configuration Guide 
(i.e., enabling Apache2 mods & confs, disabling 'reqtimeout' then 
querying 'rpcproxy.dll' over https/http from Firefox -- everything worked)


However, I was also not able to setup an Outlook 2010 account as 
evidenced above.


It was the querying 'rpcproxy.dll' that gave me suspicion.  It said 
"more data needed"


After those attempts, I found that OpenChange had "shutdown" Samba AD DC 
logins.


Amazingly, 'ocsmanager' continued to run in daemon mode.  Relevant 
errors are reproduced below.


'apache2 error.log' --

[Thu Sep 24 18:11:38.117806 2015] [:error] [pid 2110] RPCProxy started
[Thu Sep 24 18:11:38.118432 2015] [:error] [pid 2110] 
INFO:openchange.web.auth.NTLMAuthHandler:client did not pass auth cookie

[Thu Sep 24 18:11:50.651197 2015] [:error] [pid 2110] RPCProxy started
[Thu Sep 24 18:11:50.651672 2015] [:error] [pid 2110] 
INFO:openchange.web.auth.NTLMAuthHandler:client did not pass auth cookie
[Thu Sep 24 18:11:50.680363 2015] [:error] [pid 2110] 
INFO:openchange.web.auth.NTLMAuthHandler:acquiring lock 
/var/cache/ntlmauthhandler/ntlm-127.0.0.1.lock (2110)
[Thu Sep 24 18:11:50.763411 2015] [:error] [pid 2229] 
INFO:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler daemon spawned 
with pid 2229
[Thu Sep 24 18:11:51.265125 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 1
[Thu Sep 24 18:11:52.267209 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 2
[Thu Sep 24 18:11:53.269349 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 3
[Thu Sep 24 18:11:54.271378 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 4
[Thu Sep 24 18:11:55.273437 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 5
[Thu Sep 24 18:11:56.275497 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 6
[Thu Sep 24 18:11:57.277639 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 7
[Thu Sep 24 18:11:58.279731 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 8
[Thu Sep 24 18:11:59.281756 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 9
[Thu Sep 24 18:12:00.283799 2015] [:error] [pid 2229] 
ERROR:openchange.web.auth.NTLMAuthHandler:NTLMAuthHandler: caught 
exception when connecting to samba host: attempt 10
[Thu Sep 24 18:12:01.291685 2015] [:error] [pid 2229] 
CRITICAL:openchange.web.auth.NTLMAuthHandler:Uncaught exception: 
NTLMAuthHandler: unable to connect to samba host aborting after 10$
[Thu Sep 24 18:12:01.291770 2015] [:error] [pid 2229] Traceback (most 
recent call last):
[Thu Sep 24 18:12:01.291815 2015] [:error] [pid 2229]   File 
"/usr/lib/python2.7/dist-packages/openchange/web/auth/NTLMAuthHandler.py", 
line 155, in _daemonize

[Thu Sep 24 18:12:01.291848 2015] [:error] [pid 2229] self._run_as_daemon()
[Thu Sep 24 18:12:01.291858 2015] [:error] [pid 2229]   File 
"/usr/lib/python2.7/dist-packages/openchange/web/auth/NTLMAuthHandler.py", 
line 228, in _run_as_daemon

[Thu Sep 24 18:12:01.291869 2015] [:error] [pid 2229] now)):
[Thu Sep 24 18:12:01.291878 2015] [:error] [pid 2229]   File 
"/usr/lib/python2.7/dist-packages/openchange/web/auth/NTLMAuthHandler.py", 
line 294, in _process_client_request
[Thu Sep 24 18:12:01.291888 2015] [:error] [pid 2229] = 
self._handle_negotiate(client_id, ntlm_payload)
[Thu Sep 24 18:12:01.291898 2015] [:error] [pid 2229]   File 
"/usr/lib/python2.7/dist-packages/openchange/web/auth/NTLMAuthHandler.py", 
line 396, in 

Re: [SOGo] Outlook question . . .

[Steve Ankeny]

On 09/25/2015 12:46 PM, Steve Ankeny wrote:

On 09/25/2015 12:16 PM, Martin Simovic wrote:

Hi


On 25 Sep 2015, at 16:43, Steve Ankeny  wrote:

I am using MariaDB 10.0.21, Ubuntu Trusty 14.04, Dovecot & Postfix, 
OpenChange/OCSManager 2.4


*What can I do to troubleshoot or resolve this 
problem?*OpenChange/OCSManager installed after the recent upgrade 
but when they're initiated by DCERPC calls, they shutdown my Samba 
AD DC server.


Two questions:

1. What version of Samba do you use?
2. Have you EVER had working Openchange setup?

Best Regards
Martin.


1 --

adam@sogo:~$ sudo apt-cache policy samba
samba:
  Installed: 2:4.1.18+dfsg-3~inverse1
  Candidate: 2:4.1.18+dfsg-3~inverse1
  Version table:
 *** 2:4.1.18+dfsg-3~inverse1 0
600 http://inverse.ca/ubuntu/ trusty/trusty amd64 Packages
100 /var/lib/dpkg/status
 2:4.1.6+dfsg-1ubuntu2.14.04.9 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main 
amd64 Packages

 2:4.1.6+dfsg-1ubuntu2.14.04.7 0
500 http://security.ubuntu.com/ubuntu/ trusty-security/main 
amd64 Packages

 2:4.1.6+dfsg-1ubuntu2 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 
Packages

adam@sogo:~$

2 --

I have NEVER had a working OpenChange setup.

As I said previously, it ran fine all day yesterday until someone 
attempted to use Outlook.  And, what I mean by that is, "All the 
appropriate servers and services ran together until I attempted to 
setup Outlook."




Here are a couple of questions --

(1) What are the differences between Ubuntu Samba 4.1.6 and Inverse 
Samba 4.1.18 in terms of libraries?  Could there be some library or 
package from 4.1.6 which if removed would cause 4.1.18 to work properly?


It seems to me this might be the source of my problems, as I originally 
installed 4.1.6


(2) Could there be an issue with 'NTLMAuthHandler.py' such as was 
experienced in Bug 0002732?


http://www.sogo.nu/bugs/view.php?id=2732

thx again for consideration

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

Re: [SOGo] Outlook question . . .

[Steve Ankeny]

On 09/25/2015 12:16 PM, Martin Simovic wrote:

Hi

On 25 Sep 2015, at 16:43, Steve Ankeny > wrote:


I am using MariaDB 10.0.21, Ubuntu Trusty 14.04, Dovecot & Postfix, 
OpenChange/OCSManager 2.4


*What can I do to troubleshoot or resolve this problem?*  
OpenChange/OCSManager installed after the recent upgrade but when 
they're initiated by DCERPC calls, they shutdown my Samba AD DC server.


Two questions:

1. What version of Samba do you use?
2. Have you EVER had working Openchange setup?

Best Regards
Martin.


1 --

adam@sogo:~$ sudo apt-cache policy samba
samba:
  Installed: 2:4.1.18+dfsg-3~inverse1
  Candidate: 2:4.1.18+dfsg-3~inverse1
  Version table:
 *** 2:4.1.18+dfsg-3~inverse1 0
600 http://inverse.ca/ubuntu/ trusty/trusty amd64 Packages
100 /var/lib/dpkg/status
 2:4.1.6+dfsg-1ubuntu2.14.04.9 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main 
amd64 Packages

 2:4.1.6+dfsg-1ubuntu2.14.04.7 0
500 http://security.ubuntu.com/ubuntu/ trusty-security/main 
amd64 Packages

 2:4.1.6+dfsg-1ubuntu2 0
500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages
adam@sogo:~$

2 --

I have NEVER had a working OpenChange setup.

As I said previously, it ran fine all day yesterday until someone 
attempted to use Outlook.  And, what I mean by that is, "All the 
appropriate servers and services ran together until I attempted to setup 
Outlook."



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

Re: [SOGo] Outlook question . . .

[Ludovic Marcotte]

On 25/09/2015 15:40, Steve Ankeny wrote:
(1) What are the differences between Ubuntu Samba 4.1.6 and Inverse 
Samba 4.1.18 in terms of libraries?  Could there be some library or 
package from 4.1.6 which if removed would cause 4.1.18 to work properly?


It seems to me this might be the source of my problems, as I 
originally installed 4.1.6
If you use our repository for Samba packages, all should be up-to-date. 
Here is the bash Samba/OpenChancge function used in the script to 
prepare the ZEG:


function setupSambaOpenChange {
  mv /etc/samba/smb.conf /etc/samba/smb.conf.bak || true

  apt-get -y install samba openchangeserver sogo-openchange \
 openchangeproxy python-ocsmanager 
openchange-ocsmanager openchange-rpcproxy python-sievelib python-spyne 
python-rpclib python-mysqldb


  ln -s /etc/apache2/conf.d/ocsmanager.conf 
/etc/apache2/conf-available/ocsmanager.conf
  ln -s /etc/apache2/conf.d/rpcproxy.conf 
/etc/apache2/conf-available/rpcproxy.conf

  cat >/etc/apache2/conf.d/rpcproxy.conf <

Order deny,allow
Allow from all

= 2.4>
Require all granted


  SetEnv RPCPROXY_LOGLEVEL INFO
  SetEnv NTLMAUTHHANDLER_WORKDIR /var/cache/ntlmauthhandler
  SetEnv SAMBA_HOST 127.0.0.1
  WSGIPassAuthorization On
  WSGIProcessGroup %{GLOBAL}


WSGIScriptAlias /rpc/rpcproxy.dll 
/usr/lib/openchange/web/rpcproxy/rpcproxy.wsgi
WSGIScriptAlias /rpcwithcert/rpcproxy.dll 
/usr/lib/openchange/web/rpcproxy/rpcproxy.wsgi

EOF

  # ocsmanager
  cat >/etc/ocsmanager/ocsmanager.ini /etc/samba/smb.conf <  dcerpc_mapiproxy:interfaces = exchange_emsmdb, exchange_nsp, 
exchange_ds_rfr


  mapistore:namedproperties = mysql
  namedproperties:mysql_user = openchange-user
  namedproperties:mysql_pass = openchange123
  namedproperties:mysql_host = localhost
  namedproperties:mysql_db = openchange

  mapistore:indexing_backend = 
mysql://openchange-user:openchange123@localhost/openchange
  mapiproxy:openchangedb = 
mysql://openchange-user:openchange123@localhost/openchange

  ### Configuration required by OpenChange server ###

[netlogon]
  path = /var/lib/samba/sysvol/$DOMAINNAME.$TLD/scripts
  read only = No

[sysvol]
  path = /var/lib/samba/sysvol
  read only = No
EOF

  # sogo config link since samba is started as root
  rm -rf /root/GNUstep || true
  ln -s ~sogo/GNUstep /root/

  # OpenChange MySQL indexing db
  mysql -uroot > /etc/init/nmbd.conf
  echo "manual" >> /etc/init/smbd.conf
  service slapd stop
  update-rc.d slapd disable
  sed -i s/'start on (local-filesystems and net-device-up)'/'start on 
(started mysql)'/ /etc/init/samba-ad-dc.conf

  start samba-ad-dc

  a2enmod proxy proxy_http
  /etc/init.d/apache2 restart

  echo "supersede domain-name-servers 127.0.0.1;" >>/etc/dhcp/dhclient.conf
}



(2) Could there be an issue with 'NTLMAuthHandler.py' such as was 
experienced in Bug 

[SOGo] Outlook question . . .

[Steve Ankeny]

Setting up "new" Outlook 2010 account following the "Outlook 
Configuration" guide (pg 18)


It's giving me the following error --





"The action cannot be completed.  The name cannot be matched to a name 
in the address list."


Is this a server error or an Outlook error?  It appears to me to be an 
Outlook error.


Should the account be setup within Outlook as well as under "Control 
Panel | Mail"?


I am using all the suggestions on pg 18  Thx

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

Re: [SOGo] SOGo, Postgres - question about users - better explanation

[Mirosław Sławiński]

Hi Daniel,

thanks you for help, it works great :)

Best,
Mirek

W dniu 2015-07-01 o 20:21, Daniel van Ham Colchete pisze:

Hi Mirek,

here what you will need to do is to create a VIEW on your PostgreSQL 
database that Sogo will access. In my case (MySQL) the create view 
command is:


create or replace view sogo as select domain, email as mail, email 
as c_uid, email as c_mail, email as c_name, password as c_password, 
name as c_cn from accounts;


Then, on my sogo.conf I have:
  SOGoUserSources =
(
  {
type = sql;
id = publicmav;
viewURL = mysql://user:password@hostname/database/sogo;
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = crypt;
displayName = Global;
DomainFieldName = domain;
  }
);

I recommend that you read the installation guide, there are a lot of 
important parameters for you sogo.conf file that you need to 
understand: 
http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf .


Best,
Daniel Colchete

On Wed, Jul 1, 2015 at 1:48 PM, Mirek miros...@slawinski.net.pl 
mailto:miros...@slawinski.net.pl wrote:


Hi.

I have already installed Postfix and Dovecot supported with PostgreSQL
database. In my DB i keep users, domain and aliases. Now i want to
add SOGo
but i have a problem with users because i don't want create new
database and
tables for sogo but use my previouse DB with my users. Can I
connect SOGo to
another database ? and can I create own SELECT scripts ?

Best regards
Mirek
--
users@sogo.nu mailto:users@sogo.nu
https://inverse.ca/sogo/lists




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

Re: [SOGo] SOGo, Postgres - question about users - better explanation

[Daniel van Ham Colchete]

Hi Mirek,

here what you will need to do is to create a VIEW on your PostgreSQL
database that Sogo will access. In my case (MySQL) the create view command
is:

create or replace view sogo as select domain, email as mail, email as
c_uid, email as c_mail, email as c_name, password as c_password, name as
c_cn from accounts;

Then, on my sogo.conf I have:
  SOGoUserSources =
(
  {
type = sql;
id = publicmav;
viewURL = mysql://user:password@hostname/database/sogo;
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = crypt;
displayName = Global;
DomainFieldName = domain;
  }
);

I recommend that you read the installation guide, there are a lot of
important parameters for you sogo.conf file that you need to understand:
http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf .

Best,
Daniel Colchete

On Wed, Jul 1, 2015 at 1:48 PM, Mirek miros...@slawinski.net.pl wrote:

 Hi.

 I have already installed Postfix and Dovecot supported with PostgreSQL
 database. In my DB i keep users, domain and aliases. Now i want to add SOGo
 but i have a problem with users because i don't want create new database
 and
 tables for sogo but use my previouse DB with my users. Can I connect SOGo
 to
 another database ? and can I create own SELECT scripts ?

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

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

ODP: [SOGo] SOGo, Postgres - question about users - betterexplanation

[Mirosław Sławiński]

Thanks Daniel for answers.

So I have to create new table VIEW where Sogo have access and there create the 
users? I don't can't use my existing table?

-Wiadomość oryginalna-
Od: Daniel van Ham Colchete daniel.colch...@gmail.com
Wysłano: ‎2015-‎07-‎01 20:42
Do: users@sogo.nu users@sogo.nu
Temat: Re: [SOGo] SOGo, Postgres - question about users - betterexplanation

Hi Mirek,


here what you will need to do is to create a VIEW on your PostgreSQL database 
that Sogo will access. In my case (MySQL) the create view command is:


create or replace view sogo as select domain, email as mail, email as 
c_uid, email as c_mail, email as c_name, password as c_password, name as c_cn 
from accounts;



Then, on my sogo.conf I have:
  SOGoUserSources =
(
  {
type = sql;
id = publicmav;
viewURL = mysql://user:password@hostname/database/sogo;
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = crypt;
displayName = Global;
DomainFieldName = domain;
  }

);


I recommend that you read the installation guide, there are a lot of important 
parameters for you sogo.conf file that you need to understand: 
http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf .


Best,
Daniel Colchete


On Wed, Jul 1, 2015 at 1:48 PM, Mirek miros...@slawinski.net.pl wrote:

Hi.

I have already installed Postfix and Dovecot supported with PostgreSQL
database. In my DB i keep users, domain and aliases. Now i want to add SOGo
but i have a problem with users because i don't want create new database and
tables for sogo but use my previouse DB with my users. Can I connect SOGo to
another database ? and can I create own SELECT scripts ?

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

[SOGo] SOGo, Postgres - question about users - better explanation

[Mirek]

Hi.

I have already installed Postfix and Dovecot supported with PostgreSQL
database. In my DB i keep users, domain and aliases. Now i want to add SOGo
but i have a problem with users because i don't want create new database and
tables for sogo but use my previouse DB with my users. Can I connect SOGo to
another database ? and can I create own SELECT scripts ?

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

[SOGo] AS question

[Szládovics Péter]

I have found that there is no push email support in SOGo  AS.
If I set it on my phone, the new mails not arrive in time, just when I 
do a refresh manually in AS client.

Is it normal?
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] AS question

[Ludovic Marcotte]

On 30/12/2014 15:43, Szládovics Péter wrote:

I have found that there is no push email support in SOGo  AS.

Push email *is* supported.
If I set it on my phone, the new mails not arrive in time, just when I 
do a refresh manually in AS client.
Is it normal? 
What phone are you using? What are the EAS related setting values in 
your sogo.conf?


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

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

Re: [SOGo] AS question

[Szládovics Péter]

2014-12-30 22:05 keltezéssel, Ludovic Marcotte írta:

On 30/12/2014 15:43, Szládovics Péter wrote:

I have found that there is no push email support in SOGo  AS.

Push email *is* supported.


Sounds good :)
Perhaps the problem there is on my side.

If I set it on my phone, the new mails not arrive in time, just when 
I do a refresh manually in AS client.
Is it normal? 
What phone are you using? What are the EAS related setting values in 
your sogo.conf?


Android 4.4.2 stock EAS client.
I think all EAS related parameters are in default. I'm affraid it is my 
problem.

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

Re: [SOGo] [Activesync question] sogo 2.2.10 - openchange 2.2 - samba 4.1.6 -

[hh]

Hi Maxime RUBINO,

i wonder how did you get openchange running on Ubuntu 14.04.1 LTS?

When i try to install openchange-ocsmanager or openchange-rpcproxy, which is
neccessary for Outlook, i get an error like packet not found.

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

Re: [SOGo] [Activesync question] sogo 2.2.10 - openchange 2.2 - samba 4.1.6 -

[Maxime RUBINO]

Ok i have investigated, so :
*
BAD Error in IMAP command SETANNOTATION: Unknown command.

*get/setannotation is from imap_annotatemore_plugin in 
/usr/lib/dovecot/modules/ from the file imap_annotatemore_plugin.so but 
the version is incorrect :


/var/log/sogo/sogo.log :
Dec  8 00:01:09 sogo dovecot: imap: Error: Module is for different ABI 
version 2.1.7 (we have 2.2.ABIv7(2.2.9)): 
/usr/lib/dovecot/modules/lib90_imap_annotatemore_plugin.so

Dec  8 00:01:09 sogo dovecot: imap: Fatal: Couldn't load required plugins

I try with metadata plugin, the code of annotatemore is include, but, 
same error in sogo.log :
Dec  8 00:04:37 sogo dovecot: imap: Error: Module is for different ABI 
version 2.1.7 (we have 2.2.ABIv7(2.2.9)): 
/usr/lib/dovecot/modules/lib90_imap_metadata_plugin.so

Dec  8 00:04:37 sogo dovecot: imap: Fatal: Couldn't load required plugins

I'm afraid to see an old plugin version isn't compatible with new 
version of dovecot, beurk...


I'm going to try with dovecot 2.1.7 source if i found them.

Le 06/12/2014 14:01, Maxime RUBINO a écrit :

Hi all,

I use Ubuntu 14.04.1 LTS with sogo 2.2.10 openchange 2.2 samba 4.1.6 
dovecot 2.2.9, postfix 2.11


It works with Outlook 2013, and a Windows Phone 8.1 without SSL for 
the moment.


So, i can view/send my mail on my Windows phone which use ActiveSync 
connexion from my sogo server, i can view calendar, not tested for 
contact.


in sogo.log, i have this :
C[0x7fe2f3021eb8]: 189 setannotation Courrier indAOk-sirable 
/comment (value.priv sogo_e6c_1a332ebb_7d)
*S[0x7fe2f2ef7108]: 189 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 190 status Courrier indAOk-sirable (x-guid)
S[0x7fe2f2ef7108]: * STATUS Courrier indAOk-sirable (X-GUID 
8d5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 190 OK Status completed.
C[0x7fe2f3021eb8]: 191 setannotation ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur /comment (value.priv 
sogo_e6c_1a332ebb_7e)
*S[0x7fe2f2ef7108]: 191 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*
C[0x7fe2f3021eb8]: 192 status ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur (X-GUID 
8b5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 192 OK Status completed.
C[0x7fe2f3021eb8]: 193 setannotation Drafts /comment (value.priv 
sogo_e6c_1a332ebb_7f)
*S[0x7fe2f2ef7108]: 193 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 194 status Drafts (x-guid)
S[0x7fe2f2ef7108]: * STATUS Drafts (X-GUID 
05b53b3947688254b86b25aa4168)

S[0x7fe2f2ef7108]: 194 OK Status completed.
C[0x7fe2f3021eb8]: 195 setannotation Spam /comment (value.priv 
sogo_e6c_1a332ebb_80)
*S[0x7fe2f2ef7108]: 195 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 196 status Spam (x-guid)
S[0x7fe2f2ef7108]: * STATUS Spam (X-GUID ad1a81104a688254c76b25aa4168)
S[0x7fe2f2ef7108]: 196 OK Status completed.
C[0x7fe2f3021eb8]: 197 setannotation Trash /comment (value.priv 
sogo_e6c_1a332ebb_81)
*S[0x7fe2f2ef7108]: 197 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 198 status Trash (x-guid)
S[0x7fe2f2ef7108]: * STATUS Trash (X-GUID 
a8a82f2049688254c16b25aa4168)

S[0x7fe2f2ef7108]: 198 OK Status completed.
C[0x7fe2f3021eb8]: 199 setannotation ProblAOg-mes de 
synchronisation.Conflits /comment (value.priv sogo_e6c_1a332ebb_82)
*S[0x7fe2f2ef7108]: 199 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*
C[0x7fe2f3021eb8]: 200 status ProblAOg-mes de 
synchronisation.Conflits (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes de 
synchronisation.Conflits (X-GUID 8a5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 200 OK Status completed.
C[0x7fe2f3021eb8]: 201 getannotation * /comment value.priv
*S[0x7fe2f2ef7108]: 201 BAD Error in IMAP command GETANNOTATION: 
Unknown command.*
C[0x7fe2f3021eb8]: 202 setannotation INBOX /comment (value.priv 
sogo_e6c_1a332ebb_83)
*S[0x7fe2f2ef7108]: 202 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 203 status INBOX (x-guid)
S[0x7fe2f2ef7108]: * STATUS INBOX (X-GUID 
0cd6322144688254b06b25aa4168)

S[0x7fe2f2ef7108]: 203 OK Status completed.
C[0x7fe2f3021eb8]: 204 setannotation ProblAOg-mes de 
synchronisation.DAOk-faillances locales /comment (value.priv 
sogo_e6c_1a332ebb_84)
*S[0x7fe2f2ef7108]: 204 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*
C[0x7fe2f3021eb8]: 205 status ProblAOg-mes de 
synchronisation.DAOk-faillances locales (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes de 
synchronisation.DAOk-faillances locales (X-GUID 
8c5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 205 OK Status completed.
C[0x7fe2f3021eb8]: 206 setannotation Sent /comment (value.priv 
sogo_e6c_1a332ebb_85)
*S[0x7fe2f2ef7108]: 206 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 207 status Sent (x-guid)
S[0x7fe2f2ef7108]: 

Re: [SOGo] [Activesync question] sogo 2.2.10 - openchange 2.2 - samba 4.1.6 -

[Maxime RUBINO]

Ok all, i want to say more : ACTIVESYNC NOW RUNS WITHOUT ANY PROBLEM AND 
WITHOUT ANY BAD SYNC ERRORS ON MY WINDOWS PHONE 8.1 !


You have just to compile Dovecot 2.1.7 if you use Ubuntu Server 14.04.1 
LTS and purge Dovecot 2.2.9


set/get annotation will work and Windows Phone don't say Sync problem 
or similar.



Le 08/12/2014 00:13, Maxime RUBINO a écrit :

Ok i have investigated, so :
*
BAD Error in IMAP command SETANNOTATION: Unknown command.

*get/setannotation is from imap_annotatemore_plugin in 
/usr/lib/dovecot/modules/ from the file imap_annotatemore_plugin.so 
but the version is incorrect :


/var/log/sogo/sogo.log :
Dec  8 00:01:09 sogo dovecot: imap: Error: Module is for different ABI 
version 2.1.7 (we have 2.2.ABIv7(2.2.9)): 
/usr/lib/dovecot/modules/lib90_imap_annotatemore_plugin.so

Dec  8 00:01:09 sogo dovecot: imap: Fatal: Couldn't load required plugins

I try with metadata plugin, the code of annotatemore is include, but, 
same error in sogo.log :
Dec  8 00:04:37 sogo dovecot: imap: Error: Module is for different ABI 
version 2.1.7 (we have 2.2.ABIv7(2.2.9)): 
/usr/lib/dovecot/modules/lib90_imap_metadata_plugin.so

Dec  8 00:04:37 sogo dovecot: imap: Fatal: Couldn't load required plugins

I'm afraid to see an old plugin version isn't compatible with new 
version of dovecot, beurk...


I'm going to try with dovecot 2.1.7 source if i found them.

Le 06/12/2014 14:01, Maxime RUBINO a écrit :

Hi all,

I use Ubuntu 14.04.1 LTS with sogo 2.2.10 openchange 2.2 samba 4.1.6 
dovecot 2.2.9, postfix 2.11


It works with Outlook 2013, and a Windows Phone 8.1 without SSL for 
the moment.


So, i can view/send my mail on my Windows phone which use ActiveSync 
connexion from my sogo server, i can view calendar, not tested for 
contact.


in sogo.log, i have this :
C[0x7fe2f3021eb8]: 189 setannotation Courrier indAOk-sirable 
/comment (value.priv sogo_e6c_1a332ebb_7d)
*S[0x7fe2f2ef7108]: 189 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 190 status Courrier indAOk-sirable (x-guid)
S[0x7fe2f2ef7108]: * STATUS Courrier indAOk-sirable (X-GUID 
8d5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 190 OK Status completed.
C[0x7fe2f3021eb8]: 191 setannotation ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur /comment (value.priv 
sogo_e6c_1a332ebb_7e)
*S[0x7fe2f2ef7108]: 191 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*
C[0x7fe2f3021eb8]: 192 status ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur (X-GUID 
8b5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 192 OK Status completed.
C[0x7fe2f3021eb8]: 193 setannotation Drafts /comment 
(value.priv sogo_e6c_1a332ebb_7f)
*S[0x7fe2f2ef7108]: 193 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 194 status Drafts (x-guid)
S[0x7fe2f2ef7108]: * STATUS Drafts (X-GUID 
05b53b3947688254b86b25aa4168)

S[0x7fe2f2ef7108]: 194 OK Status completed.
C[0x7fe2f3021eb8]: 195 setannotation Spam /comment (value.priv 
sogo_e6c_1a332ebb_80)
*S[0x7fe2f2ef7108]: 195 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 196 status Spam (x-guid)
S[0x7fe2f2ef7108]: * STATUS Spam (X-GUID 
ad1a81104a688254c76b25aa4168)

S[0x7fe2f2ef7108]: 196 OK Status completed.
C[0x7fe2f3021eb8]: 197 setannotation Trash /comment (value.priv 
sogo_e6c_1a332ebb_81)
*S[0x7fe2f2ef7108]: 197 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 198 status Trash (x-guid)
S[0x7fe2f2ef7108]: * STATUS Trash (X-GUID 
a8a82f2049688254c16b25aa4168)

S[0x7fe2f2ef7108]: 198 OK Status completed.
C[0x7fe2f3021eb8]: 199 setannotation ProblAOg-mes de 
synchronisation.Conflits /comment (value.priv 
sogo_e6c_1a332ebb_82)
*S[0x7fe2f2ef7108]: 199 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*
C[0x7fe2f3021eb8]: 200 status ProblAOg-mes de 
synchronisation.Conflits (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes de 
synchronisation.Conflits (X-GUID 8a5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 200 OK Status completed.
C[0x7fe2f3021eb8]: 201 getannotation * /comment value.priv
*S[0x7fe2f2ef7108]: 201 BAD Error in IMAP command GETANNOTATION: 
Unknown command.*
C[0x7fe2f3021eb8]: 202 setannotation INBOX /comment (value.priv 
sogo_e6c_1a332ebb_83)
*S[0x7fe2f2ef7108]: 202 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*

C[0x7fe2f3021eb8]: 203 status INBOX (x-guid)
S[0x7fe2f2ef7108]: * STATUS INBOX (X-GUID 
0cd6322144688254b06b25aa4168)

S[0x7fe2f2ef7108]: 203 OK Status completed.
C[0x7fe2f3021eb8]: 204 setannotation ProblAOg-mes de 
synchronisation.DAOk-faillances locales /comment (value.priv 
sogo_e6c_1a332ebb_84)
*S[0x7fe2f2ef7108]: 204 BAD Error in IMAP command SETANNOTATION: 
Unknown command.*
C[0x7fe2f3021eb8]: 205 status ProblAOg-mes de 
synchronisation.DAOk-faillances locales (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes 

[SOGo] [Activesync question] sogo 2.2.10 - openchange 2.2 - samba 4.1.6 -

[Maxime RUBINO]

Hi all,

I use Ubuntu 14.04.1 LTS with sogo 2.2.10 openchange 2.2 samba 4.1.6 
dovecot 2.2.9, postfix 2.11


It works with Outlook 2013, and a Windows Phone 8.1 without SSL for the 
moment.


So, i can view/send my mail on my Windows phone which use ActiveSync 
connexion from my sogo server, i can view calendar, not tested for contact.


in sogo.log, i have this :
C[0x7fe2f3021eb8]: 189 setannotation Courrier indAOk-sirable 
/comment (value.priv sogo_e6c_1a332ebb_7d)
*S[0x7fe2f2ef7108]: 189 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*

C[0x7fe2f3021eb8]: 190 status Courrier indAOk-sirable (x-guid)
S[0x7fe2f2ef7108]: * STATUS Courrier indAOk-sirable (X-GUID 
8d5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 190 OK Status completed.
C[0x7fe2f3021eb8]: 191 setannotation ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur /comment (value.priv 
sogo_e6c_1a332ebb_7e)
*S[0x7fe2f2ef7108]: 191 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*
C[0x7fe2f3021eb8]: 192 status ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes de 
synchronisation.DAOk-faillances du serveur (X-GUID 
8b5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 192 OK Status completed.
C[0x7fe2f3021eb8]: 193 setannotation Drafts /comment (value.priv 
sogo_e6c_1a332ebb_7f)
*S[0x7fe2f2ef7108]: 193 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*

C[0x7fe2f3021eb8]: 194 status Drafts (x-guid)
S[0x7fe2f2ef7108]: * STATUS Drafts (X-GUID 05b53b3947688254b86b25aa4168)
S[0x7fe2f2ef7108]: 194 OK Status completed.
C[0x7fe2f3021eb8]: 195 setannotation Spam /comment (value.priv 
sogo_e6c_1a332ebb_80)
*S[0x7fe2f2ef7108]: 195 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*

C[0x7fe2f3021eb8]: 196 status Spam (x-guid)
S[0x7fe2f2ef7108]: * STATUS Spam (X-GUID ad1a81104a688254c76b25aa4168)
S[0x7fe2f2ef7108]: 196 OK Status completed.
C[0x7fe2f3021eb8]: 197 setannotation Trash /comment (value.priv 
sogo_e6c_1a332ebb_81)
*S[0x7fe2f2ef7108]: 197 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*

C[0x7fe2f3021eb8]: 198 status Trash (x-guid)
S[0x7fe2f2ef7108]: * STATUS Trash (X-GUID a8a82f2049688254c16b25aa4168)
S[0x7fe2f2ef7108]: 198 OK Status completed.
C[0x7fe2f3021eb8]: 199 setannotation ProblAOg-mes de 
synchronisation.Conflits /comment (value.priv sogo_e6c_1a332ebb_82)
*S[0x7fe2f2ef7108]: 199 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*
C[0x7fe2f3021eb8]: 200 status ProblAOg-mes de 
synchronisation.Conflits (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes de synchronisation.Conflits 
(X-GUID 8a5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 200 OK Status completed.
C[0x7fe2f3021eb8]: 201 getannotation * /comment value.priv
*S[0x7fe2f2ef7108]: 201 BAD Error in IMAP command GETANNOTATION: Unknown 
command.*
C[0x7fe2f3021eb8]: 202 setannotation INBOX /comment (value.priv 
sogo_e6c_1a332ebb_83)
*S[0x7fe2f2ef7108]: 202 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*

C[0x7fe2f3021eb8]: 203 status INBOX (x-guid)
S[0x7fe2f2ef7108]: * STATUS INBOX (X-GUID 0cd6322144688254b06b25aa4168)
S[0x7fe2f2ef7108]: 203 OK Status completed.
C[0x7fe2f3021eb8]: 204 setannotation ProblAOg-mes de 
synchronisation.DAOk-faillances locales /comment (value.priv 
sogo_e6c_1a332ebb_84)
*S[0x7fe2f2ef7108]: 204 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*
C[0x7fe2f3021eb8]: 205 status ProblAOg-mes de 
synchronisation.DAOk-faillances locales (x-guid)
S[0x7fe2f2ef7108]: * STATUS ProblAOg-mes de 
synchronisation.DAOk-faillances locales (X-GUID 
8c5e42083dea8254d00b25aa4168)

S[0x7fe2f2ef7108]: 205 OK Status completed.
C[0x7fe2f3021eb8]: 206 setannotation Sent /comment (value.priv 
sogo_e6c_1a332ebb_85)
*S[0x7fe2f2ef7108]: 206 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*

C[0x7fe2f3021eb8]: 207 status Sent (x-guid)
S[0x7fe2f2ef7108]: * STATUS Sent (X-GUID b434bd2f48688254bc6b25aa4168)
S[0x7fe2f2ef7108]: 207 OK [CLIENTBUG] Status on selected mailbox completed.
C[0x7fe2f3021eb8]: 208 setannotation ProblAOg-mes de synchronisation 
/comment (value.priv sogo_e6c_1a332ebb_86)
*S[0x7fe2f2ef7108]: 208 BAD Error in IMAP command SETANNOTATION: Unknown 
command.*

C[0x7fe2f3021eb8]: 209 status ProblAOg-mes de synchronisation (x-guid)

Windows Phone indicated an update error, but it works, do you have 
idea for SET/GET ANNOTATION ? i have installed dovecot metadata plugin, 
same error...


--
Cordialement,
Maxime RUBINO

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

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Charles Marcus]

On 6/10/2014 1:22 PM, Ludovic Marcotte lmarco...@inverse.ca wrote:

site.js is use for 'initial preference values'.

This is documented in 
http://www.sogo.nu/files/docs/SOGo%20Mozilla%20Thunderbird%20Configuration.pdf 
:


Settings that pushed are pushed *during initial configuration* are 
controlled by the

./defaults/preferences/site.js fle from SOGo Integrator.

Preferences that *are forced upon every restart* of Thunderbird are 
controlled from the
./chrome/content/general/custom-preferences.js confguration file. 


Thanks Ludo - working on implementing this now, but...

How do I specify values that are neither integers (assuming 'int' stands 
for 'integer') or boolean (true/false)?


For example, how would I specify:

user_pref(mail.addr_book.quicksearchquery.format, 
?(or(Company,c,@V)(PrimaryEmail,c,@V)(DisplayName,c,@V)(FirstName,c,@V)(LastName,c,@V)));


or

user_pref(browser.cache.disk.capacity, 40960);

Just use force_bool_pref?

Thanks,


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

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Ludovic Marcotte]

On 2014-06-23, 4:30 PM, Charles Marcus wrote:

For example, how would I specify:

user_pref(mail.addr_book.quicksearchquery.format, 
?(or(Company,c,@V)(PrimaryEmail,c,@V)(DisplayName,c,@V)(FirstName,c,@V)(LastName,c,@V)));


force_char_pref(mail.addr_book.quicksearchquery.format, 
?(or(Company,c,@V)(PrimaryEmail,c,@V)(DisplayName,c,@V)(FirstName,c,@V)(LastName,c,@V)));

or

user_pref(browser.cache.disk.capacity, 40960);



force_int_pref(browser.cache.disk.capacity, 40960);

Cheers,

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

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

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Tanstaafl]

On 6/23/2014 4:44 PM, Ludovic Marcotte lmarco...@inverse.ca wrote:

On 2014-06-23, 4:30 PM, Charles Marcus wrote:

For example, how would I specify:

user_pref(mail.addr_book.quicksearchquery.format,
?(or(Company,c,@V)(PrimaryEmail,c,@V)(DisplayName,c,@V)(FirstName,c,@V)(LastName,c,@V)));



force_char_pref(mail.addr_book.quicksearchquery.format,
?(or(Company,c,@V)(PrimaryEmail,c,@V)(DisplayName,c,@V)(FirstName,c,@V)(LastName,c,@V)));


Thanks


or

user_pref(browser.cache.disk.capacity, 40960);



force_int_pref(browser.cache.disk.capacity, 40960);


Lol - thx - dunno what I was thinking (40960 is still an integer)...
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Charles Marcus]

Anyone? It is a simple/straight forward enough question.

Thanks...

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

Hi all,

My goal is to simply prevent Thunderbird from auto-updating Lightning, 
while allowing all other extensions to continue to auto-update, and 
I've figured out how to do this, by simply adding the following pref 
to the user.js file in each users Thunderbird profile folder:


user_pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


My question is - can I simply add this into the site.js file in the 
Integrator extension as:


user_pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


and accomplish the same thing?

Or, would I need to change 'user_pref' to just 'pref' (like the other 
entries already in there), like this:


pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


?

Last - can I push out other config options that I am setting in the 
user.js file in the same way, thus doing away completely with the 
user.js file, quickly and easily pushing out pref changes this way?


Thanks!

Charles




Best regards,

Charles

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

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Charles Marcus]

Well, figured I may as well give it a try, and apparently this does not 
work.


Ludo? Is it supposed to work?

It would be really nice to be able to do away with the user.js file 
(that I have to manually keep updated on each users system) and just 
apply these mods in the site.js file...



On 6/10/2014 6:27 AM, Charles Marcus cmar...@media-brokers.com wrote:

Anyone? It is a simple/straight forward enough question.

Thanks...

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

Hi all,

My goal is to simply prevent Thunderbird from auto-updating 
Lightning, while allowing all other extensions to continue to 
auto-update, and I've figured out how to do this, by simply adding 
the following pref to the user.js file in each users Thunderbird 
profile folder:


user_pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


My question is - can I simply add this into the site.js file in the 
Integrator extension as:


user_pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


and accomplish the same thing?

Or, would I need to change 'user_pref' to just 'pref' (like the other 
entries already in there), like this:


pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


?

Last - can I push out other config options that I am setting in the 
user.js file in the same way, thus doing away completely with the 
user.js file, quickly and easily pushing out pref changes this way?


Thanks!

Charles




Best regards,

Charles





Best regards,

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

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

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Ludovic Marcotte]

On 2014-06-10, 12:52 PM, Charles Marcus wrote:
Ludo? Is it supposed to work? 

If you want to force prefs, you must use:

chrome/content/general/custom-preferences.js

site.js is use for 'initial preference values'.

This is documented in 
http://www.sogo.nu/files/docs/SOGo%20Mozilla%20Thunderbird%20Configuration.pdf 
:


Settings that pushed are pushed *during initial configuration* are 
controlled by the

./defaults/preferences/site.js fle from SOGo Integrator.

Preferences that *are forced upon every restart* of Thunderbird are 
controlled from the

./chrome/content/general/custom-preferences.js confguration file.

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

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

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Sean M. Pappalardo]

On 06/10/2014 09:52 AM, Charles Marcus wrote:

It would be really nice to be able to do away with the user.js file
(that I have to manually keep updated on each users system) and just
apply these mods in the site.js file...


You might want to ask this on Mozilla's Thunderbird Enterprise list: 
https://wiki.mozilla.org/Thunderbird/Enterprise


Sincerely,
Sean M. Pappalardo
Sr. Networks Engineer
Renegade Technologies
spappala...@renegadetech.com
Office: (630) 631-6188
http://www.renegadetech.com



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Márcio Merlone]

Em 10-06-2014 07:27, Charles Marcus escreveu:

Anyone? It is a simple/straight forward enough question.

I use this on my site.js:

cat  EOF  defaults/preferences/site.js
pref(network.dns.disableIPv6,true);
pref(network.enableIDN,false);
pref(network.enablePad,true);
pref(update_notifications.enabled,false);
pref(extensions.update.enabled,false);
pref(mailnews.start_page.override_url,'http://news.local');
pref(mailnews.start_page.url,'http://news.local');
pref(mail.server.default.check_all_folders_for_new,true);
pref(mail.server.server1.spamLevel, 0);
pref(mail.server.default.spamLevel, 0);
pref(mail.chat.enabled,false);
lockPref(app.update.auto, false);
lockPref(app.update.enabled, false);
lockPref(autoupdate.enabled,false);
defaultPref(calendar.timezone.local,'Amercia/Sao_Paulo');
EOF

Haven't yet checked if all got applied or if doing the right way but 
seems to work.




Thanks...

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

Hi all,

My goal is to simply prevent Thunderbird from auto-updating 
Lightning, while allowing all other extensions to continue to 
auto-update, and I've figured out how to do this, by simply adding 
the following pref to the user.js file in each users Thunderbird 
profile folder:


user_pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


My question is - can I simply add this into the site.js file in the 
Integrator extension as:


user_pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


and accomplish the same thing?

Or, would I need to change 'user_pref' to just 'pref' (like the other 
entries already in there), like this:


pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


?

Last - can I push out other config options that I am setting in the 
user.js file in the same way, thus doing away completely with the 
user.js file, quickly and easily pushing out pref changes this way?


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

Re: [SOGo] Integrator Question re: adding prefs to site.js?

[Charles Marcus]

On 6/10/2014 1:22 PM, Ludovic Marcotte lmarco...@inverse.ca wrote:

On 2014-06-10, 12:52 PM, Charles Marcus wrote:
Ludo? Is it supposed to work? 

If you want to force prefs, you must use:

chrome/content/general/custom-preferences.js

site.js is use for 'initial preference values'.

This is documented in 
http://www.sogo.nu/files/docs/SOGo%20Mozilla%20Thunderbird%20Configuration.pdf 
:


Settings that pushed are pushed *during initial configuration* are 
controlled by the

./defaults/preferences/site.js fle from SOGo Integrator.

Preferences that *are forced upon every restart* of Thunderbird are 
controlled from the

./chrome/content/general/custom-preferences.js confguration file.


Ah, missed that... thanks Ludovic!


Best regards,

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

[SOGo] Integrator Question re: adding prefs to site.js?

[Charles Marcus]

Hi all,

My goal is to simply prevent Thunderbird from auto-updating Lightning, 
while allowing all other extensions to continue to auto-update, and I've 
figured out how to do this, by simply adding the following pref to the 
user.js file in each users Thunderbird profile folder:


user_pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


My question is - can I simply add this into the site.js file in the 
Integrator extension as:


user_pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


and accomplish the same thing?

Or, would I need to change 'user_pref' to just 'pref' (like the other 
entries already in there), like this:


pref(extensions.{e2fda1a4-762b-4020-b5ad-a41df1933103}.update.enabled, 
false);


?

Last - can I push out other config options that I am setting in the 
user.js file in the same way, thus doing away completely with the 
user.js file, quickly and easily pushing out pref changes this way?


Thanks!

Charles

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

Re: [SOGo] Licencing question

[ABBAS Alain]

Hello
Yes this license is because ActiveSync is Pattented and in Europe it cannot  be 
 (European law about patents).
Article 52 of EPC :
http://en.wikipedia.org/wiki/Software_patents_under_the_European_Patent_Convention

Regards




Le Lundi 10 Février 2014 13:24 CET, Michel EKIMIA cont...@ekimia.fr a écrit:
 Hi, I don't really have the answer but for Europe , I think this cannot be 
applied because these kind of protocol patents  cannot be applied currently, 
although it's still not clear in most projects what need to be paid in such 
cases. Regards 2014-02-10 11:12 GMT+01:00 Fabio Onorini onofa...@gmail.com: 
In SOGO installation guide v 2.2.0 I read this text: In order to use the SOGo 
Active Sync support code in production environments, you need to get a proper 
usage license from Microsoft. Please contact them directly to negotiate the 
fees associated to your user base.
To contact Microsoft, please visit:
http://www.microsoft.com/en-us/legal/intellectualproperty/IPLicensing/Programs/exchangeactivesyncprotocol.aspx
and send an email to iplic...@microsoft.com
Inverse inc. provides this software for free, but is not responsible for 
anything related to its usage. So if I want to install SOGo environment with 
ActiveSync support for my customers,  I must negotiate licence plan? --
---
Fabio Onorini  
--Michel
 Memeteau  - Directeur.
Notre Boutique Ordinateurs GNU/Linux : http://shop.ekimia.fr49 chemin de 
l'union 13720 La Bouilladisse - France.Fixe :  +33 (0) 974763294    Mobile : 
+33(0) 
624808051--
  
--
Alain Abbas
11 rue Robert Schumann
54500 Vandoeuvre
Tel : +333 83 18 02 70
skype: alain.abbas-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Licencing question

[Fabio Onorini]

In SOGO installation guide v 2.2.0

I read this text:

In order to use the SOGo Active Sync support code in production
environments, you need to get a proper usage license from Microsoft. Please
contact them directly to negotiate the fees associated to your user base.

To contact Microsoft, please visit:

http://www.microsoft.com/en-us/legal/intellectualproperty/IPLicensing/Programs/exchangeactivesyncprotocol.aspx

and send an email to iplic...@microsoft.com

Inverse inc. provides this software for free, but is not responsible for
anything related to its usage.

So if I want to install SOGo environment with ActiveSync support for my
customers,  I must negotiate licence plan?

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

Re: [SOGo] Licencing question

[Szládovics Péter]

2014-02-10 11:12 keltezéssel, Fabio Onorini írta:


In SOGO installation guide v 2.2.0

I read this text:

In order to use the SOGo Active Sync support code in production 
environments, you need to get a proper usage license from Microsoft. 
Please contact them directly to negotiate the fees associated to your 
user base.


To contact Microsoft, please visit:

http://www.microsoft.com/en-us/legal/intellectualproperty/IPLicensing/Programs/exchangeactivesyncprotocol.aspx 



and send an email to iplic...@microsoft.com 
mailto:iplic...@microsoft.com


Inverse inc. provides this software for free, but is not responsible 
for anything related to its usage.



So if I want to install SOGo environment with ActiveSync support for 
my customers,  I must negotiate licence plan?


AFAIK outside of EU yes, but not.
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Licencing question

[Michel EKIMIA]

Hi, I don't really have the answer but for Europe , I think this cannot be
applied because these kind of protocol patents  cannot be applied
currently, although it's still not clear in most projects what need to be
paid in such cases.

Regards


2014-02-10 11:12 GMT+01:00 Fabio Onorini onofa...@gmail.com:


 In SOGO installation guide v 2.2.0

 I read this text:

 In order to use the SOGo Active Sync support code in production
 environments, you need to get a proper usage license from Microsoft. Please
 contact them directly to negotiate the fees associated to your user base.

 To contact Microsoft, please visit:


 http://www.microsoft.com/en-us/legal/intellectualproperty/IPLicensing/Programs/exchangeactivesyncprotocol.aspx

 and send an email to iplic...@microsoft.com

 Inverse inc. provides this software for free, but is not responsible for
 anything related to its usage.

 So if I want to install SOGo environment with ActiveSync support for my
 customers,  I must negotiate licence plan?

 --
 ---
 Fabio Onorini




--
Michel Memeteau  - Directeur.
http://shop.ekimia.fr/

Notre Boutique Ordinateurs GNU/Linux : http://shop.ekimia.fr
49 chemin de l'union 13720 La Bouilladisse - France.
Fixe :  +33 (0) 974763294Mobile : +33(0) 624808051
--
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Christian Mack]

hello Heiner Markert

Am 2013-10-20 20:45, schrieb Heiner Markert:
 
 ... 
 
 Someone really should update the SOGo wiki (unfortunately I am unable to
 create an account: I fail with the TextCha...). It still links to
 sogosync, which is totally outdated.
 

try:   You better ask the right guy to have an account in this wiki.

:-)


Kind regards,
Christian Mack

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

Re: [SOGo] ActiveSync question

[boyd yang]

Yes, please share your guide on configure with sogo.

I get this error after some time trying..

Combined-Logon() failed on BackendCalDAV

27/10/2013 10:44:45 [21665] [ INFO]  AuthenticationRequiredException:
Access denied. Username or password incorrect - code: 0


IMAP successfully log, bug caldal logon failed.
Thanks!


On Wed, Oct 23, 2013 at 4:53 PM, Davide Bozzelli bu...@olografix.orgwrote:

 Il 10/23/13 1:38 AM, Corrado Fiore ha scritto:
  On Oct 22, 2013, at 14:19 , boyd yang wrote:
 
  Can this solution work well for mail,calendar,contacts at the same
 time？ No need to configure calendar,contacts differently?
  Yup, exactly.  All like a real Exchange account.  Plus, you get push
 email, which is a definite bonus for business users.
 
  The downside - which might apply or not to your case - is that push mail
 via Z-push (which is a PHP application) requires way more resources per
 user than SOGo itself since the TCP connection underlying the HTTP protocol
 must remain in open state.
 
  As the author of Z-push-contrib suggests, the rule of thumb is:  1.5 PHP
 processes per email user, so 1,000 users would translate to 1,500 active
 PHP processes.  Of course you can set up a balanced pool of servers, but
 the point here is:  don't expect Z-Push (which I love, don't get me wrong)
 to scale beautifully as SOGo does.
 
  In this light, I can understand one of the reasons why the SOGo team is
 looking for a native implementation instead.
 
  Best,
  Corrado
 
 
 
 Hi Corrado

 Would be wonderful if you could write a concise guide on how to
 configure the activesync support for Sogo with this Z-push fork.

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

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

Re: [SOGo] ActiveSync question

[boyd yang]

Hi Corrado Fiore,

I have tried few days, I cannot get it work smoothly except IMAP.

Please see what's wrong with the caldav and carddav configuration?

/
// 
//  BackendCalDAV settings
// 
// Server address
define('CALDAV_SERVER', 'http://sogo.xxx');
// Port
define('CALDAV_PORT', '80');
// Path
define('CALDAV_PATH', '/SOGo/dav/%u/Calendar');///caldav.php/%u/');
// Personal CalDAV folder (calendar folder/principal)
//define('CALDAV_PERSONAL', 'home');

?

// 
//  BackendCardDAV settings
// 
// Server protocol: http or https
define('CARDDAV_PROTOCOL', 'http');
// Server name
define('CARDDAV_SERVER', 'sogo.x');
// Server port
define('CARDDAV_PORT', '80');
// Server path to the addressbook
// %u: replaced with the username
// %d: replaced with the domain
//   Add the trailing /
define('CARDDAV_PATH',
'/SOGo/dav/%u/Contacts/');///caldav.php/%u/addresses/');
// Addressbook display name
// %u: replaced with the username
// %d: replaced with the domain
define('CARDDAV_CONTACTS_FOLDER_NAME', '%u Addressbook');

// If the CardDAV server support the sync-collection operation
// DAViCal supports it, but SabreDav/Owncloud doesn't
// Setting this to false will work with most servers, but it will be pretty
slow: 1 petition for the href of vcards, and 1 petition for each vcard
define('CARDDAV_SUPPORTS_SYNC', true);



On Wed, Oct 23, 2013 at 7:38 AM, Corrado Fiore mail...@corradofiore.itwrote:

 On Oct 22, 2013, at 14:19 , boyd yang wrote:

  Can this solution work well for mail,calendar,contacts at the same time？
 No need to configure calendar,contacts differently?

 Yup, exactly.  All like a real Exchange account.  Plus, you get push
 email, which is a definite bonus for business users.

 The downside - which might apply or not to your case - is that push mail
 via Z-push (which is a PHP application) requires way more resources per
 user than SOGo itself since the TCP connection underlying the HTTP protocol
 must remain in open state.

 As the author of Z-push-contrib suggests, the rule of thumb is:  1.5 PHP
 processes per email user, so 1,000 users would translate to 1,500 active
 PHP processes.  Of course you can set up a balanced pool of servers, but
 the point here is:  don't expect Z-Push (which I love, don't get me wrong)
 to scale beautifully as SOGo does.

 In this light, I can understand one of the reasons why the SOGo team is
 looking for a native implementation instead.

 Best,
 Corrado



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

Re: [SOGo] ActiveSync question

[Davide Bozzelli]

Il 10/23/13 1:38 AM, Corrado Fiore ha scritto:
 On Oct 22, 2013, at 14:19 , boyd yang wrote:

 Can this solution work well for mail,calendar,contacts at the same time？ No 
 need to configure calendar,contacts differently?
 Yup, exactly.  All like a real Exchange account.  Plus, you get push email, 
 which is a definite bonus for business users.

 The downside - which might apply or not to your case - is that push mail via 
 Z-push (which is a PHP application) requires way more resources per user than 
 SOGo itself since the TCP connection underlying the HTTP protocol must remain 
 in open state.

 As the author of Z-push-contrib suggests, the rule of thumb is:  1.5 PHP 
 processes per email user, so 1,000 users would translate to 1,500 active PHP 
 processes.  Of course you can set up a balanced pool of servers, but the 
 point here is:  don't expect Z-Push (which I love, don't get me wrong) to 
 scale beautifully as SOGo does.

 In this light, I can understand one of the reasons why the SOGo team is 
 looking for a native implementation instead.

 Best,
 Corrado



Hi Corrado

Would be wonderful if you could write a concise guide on how to
configure the activesync support for Sogo with this Z-push fork.

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

Re: [SOGo] ActiveSync question

[boyd yang]

Can this solution work well for mail,calendar,contacts at the same time？ No
need to configure calendar,contacts differently?

iPhone can use the same configuration for mail,contacts,calendar.

在 2013年10月21日星期一，Heiner Markert 写道：

 Am 03.09.2013 17:12, schrieb Corrado Fiore:

 Dear All,

 I've been in touch in the past days with Francisco Miguel Biete, author
 of Z-Push-contrib, a fork from the original Z-Push that is working well (at
 least, in our tests) with SOGo:

  
 https://github.com/fmbiete/Z-**Push-contribhttps://github.com/fmbiete/Z-Push-contrib

 What's important here is that Francisco Miguel has been very responsive
 in fixing the bugs we submitted (one for CardDAV, the other for the IMAP
 backend).  I must say I'm quite impressed.

 ActiveSync seems to be working very well, and so far seems to be solid
 enough that we can use it in production.  However, documentation could be a
 bit more organized, so here's the idea:  I'll try to sum all the usual
 mistakes on a page in the SOGo wiki.  Allow me some days for this, I'll try
 my best.

 On the other hand, I agree that the SOGo community needs a point of
 reference for Z-Push just like Inverse is for SOGo.

 Best,
 Corrado Fiore



 Thank you very much for the link! Seems to be working perfectly!

 Someone really should update the SOGo wiki (unfortunately I am unable to
 create an account: I fail with the TextCha...). It still links to sogosync,
 which is totally outdated.

 Best,
 Heiner



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

attachment: photo.jpg

Re: [SOGo] ActiveSync question

[Corrado Fiore]

On Oct 22, 2013, at 14:19 , boyd yang wrote:

 Can this solution work well for mail,calendar,contacts at the same time？ No 
 need to configure calendar,contacts differently?

Yup, exactly.  All like a real Exchange account.  Plus, you get push email, 
which is a definite bonus for business users.

The downside - which might apply or not to your case - is that push mail via 
Z-push (which is a PHP application) requires way more resources per user than 
SOGo itself since the TCP connection underlying the HTTP protocol must remain 
in open state.

As the author of Z-push-contrib suggests, the rule of thumb is:  1.5 PHP 
processes per email user, so 1,000 users would translate to 1,500 active PHP 
processes.  Of course you can set up a balanced pool of servers, but the point 
here is:  don't expect Z-Push (which I love, don't get me wrong) to scale 
beautifully as SOGo does.

In this light, I can understand one of the reasons why the SOGo team is looking 
for a native implementation instead.

Best,
Corrado



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

Re: [SOGo] ActiveSync question

[Heiner Markert]

Am 03.09.2013 17:12, schrieb Corrado Fiore:

Dear All,

I've been in touch in the past days with Francisco Miguel Biete, author of 
Z-Push-contrib, a fork from the original Z-Push that is working well (at least, 
in our tests) with SOGo:

 https://github.com/fmbiete/Z-Push-contrib

What's important here is that Francisco Miguel has been very responsive in 
fixing the bugs we submitted (one for CardDAV, the other for the IMAP backend). 
 I must say I'm quite impressed.

ActiveSync seems to be working very well, and so far seems to be solid enough 
that we can use it in production.  However, documentation could be a bit more 
organized, so here's the idea:  I'll try to sum all the usual mistakes on a 
page in the SOGo wiki.  Allow me some days for this, I'll try my best.

On the other hand, I agree that the SOGo community needs a point of reference 
for Z-Push just like Inverse is for SOGo.

Best,
Corrado Fiore




Thank you very much for the link! Seems to be working perfectly!

Someone really should update the SOGo wiki (unfortunately I am unable to 
create an account: I fail with the TextCha...). It still links to 
sogosync, which is totally outdated.


Best,
Heiner



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

Re: Have to make CardDav work too - was: Re: [SOGo] ActiveSync question

[Corrado Fiore]

Dear Marcio,

sorry for the late reply.  Please set CARDDAV_SUPPORTS_SYNC = FALSE.  SOGo 
doesn't implement the SYNC function yet.

Best,
Corrado

_
On Sep 12, 2013, at 16:28 , Marcio Merlone wrote:

 As I sayd before, IMAP and CalDav are working great. But could not make 
 CardDav work, can you assist me? CardDav backend config is as follows:
 
 // http://YOURSOGOINSTALL/dav/YOURUSERNAME/Contacts/personal
 define('CARDDAV_PROTOCOL', 'https');
 define('CARDDAV_SERVER', 'sogo.domain.tld');
 define('CARDDAV_PORT', '443');
 define('CARDDAV_PATH', '/SOGo/dav/%u/Contacts/personal/');
 define('CARDDAV_CONTACTS_FOLDER_NAME', '');
 define('CARDDAV_SUPPORTS_SYNC', true);
 
 Have tested on my real Defy CM10 (Android 4.1) and a virtual Galaxy S4 from 
 Genymotion, both (did not) worked the same. Also tried:
 
 define('CARDDAV_PATH', '/SOGo/dav/%u/Contacts/');
 define('CARDDAV_CONTACTS_FOLDER_NAME', 'personal');
 
 Thank you, best regards.
 
 -- 
 Marcio Merlone
 TI - Administrador de redes
 
 A1 Engenharia - Unidade Corporativa
 Fone: +55 41 3616-3797
 Cel:  +55 41 9689-0036http://www.a1.ind.br/

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

Re: Have to make CardDav work too - was: Re: [SOGo] ActiveSync question

[Marcio Merlone]

Em 18-09-2013 06:04, Corrado Fiore escreveu:

sorry for the late reply.

No regrets :)


Please set CARDDAV_SUPPORTS_SYNC = FALSE.  SOGo doesn't implement the SYNC 
function yet.
That's it. I got some attention on github regarding that and Francisco 
pointed it aready. It works smooth now for imap, caldav *and* carddav.


https://github.com/fmbiete/Z-Push-contrib/issues/4

Thank you and best regards.

--
*Marcio Merlone*
TI - Administrador de redes

*A1 Engenharia - Unidade Corporativa*
Fone:   +55 41 3616-3797
Cel:+55 41 9689-0036

http://www.a1.ind.br/ http://www.a1.ind.br
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Steven Swarts]

I am interested, very much so just haven't go around to it.
Sounds like you put a lot of effort in, so please hold on out :)

*/Regards,/*

*/Steven Swarts/*

On 14/09/2013 10:59 PM, Szládovics Péter wrote:

2013-09-04 08:37 keltezéssel, Anna Christina Naß írta:

Am 03.09.2013 21:19, schrieb Szládovics Péter:

Hallo,


CalDAV and CardDAV work fine and are not very complicated to set up
for the users (except when using Lightning/SOGo Connector where the
full paths seem to be needed).


Did you try the SOGo Integrator?
If you build it for yourself, and set up an update site next to SOGo,
the set up will be very simple, and you can use the share/subscribe
features on the pages of Lightning and Addressbook apps.

If more people interested in this method, I can create and present a
short doc about easy set up these things on your site for you.


I looked at the documentation (SOGo Mozilla Thunderbird 
Configuration.pdf), decided that this documentation is far from 
complete and ignored the Integrator for now.


It would be great if you could provide some more documentation on it, 
especially on:


- what do the options in the files
   defaults/preferences/*.js
   chrome/content/extensions.rdf
  mean?
- what does the directory custom/sogo-demo do?

Some examples (and a overall documentation on the options) of 
update.php also would be great.


I created the site what can generate a script for correct update site, 
and share the link, but no one interested in it since more than a 
week. :(

I though some people need it...


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

Re: [SOGo] ActiveSync question

[Szládovics Péter]

2013-09-16 01:08 keltezéssel, Steven Swarts írta:

I am interested, very much so just haven't go around to it.
Sounds like you put a lot of effort in, so please hold on out :)


Yes, not seems 'zero effort' :)
But I did a mistake: the webpage was protected - but I now make it 
available for public access.

This is the link: http://www.onlinedemo.hu/136-update-site-generation



*/Regards,/*

*/Steven Swarts/*

On 14/09/2013 10:59 PM, Szládovics Péter wrote:

2013-09-04 08:37 keltezéssel, Anna Christina Naß írta:

Am 03.09.2013 21:19, schrieb Szládovics Péter:

Hallo,


CalDAV and CardDAV work fine and are not very complicated to set up
for the users (except when using Lightning/SOGo Connector where the
full paths seem to be needed).


Did you try the SOGo Integrator?
If you build it for yourself, and set up an update site next to SOGo,
the set up will be very simple, and you can use the share/subscribe
features on the pages of Lightning and Addressbook apps.

If more people interested in this method, I can create and present a
short doc about easy set up these things on your site for you.


I looked at the documentation (SOGo Mozilla Thunderbird 
Configuration.pdf), decided that this documentation is far from 
complete and ignored the Integrator for now.


It would be great if you could provide some more documentation on 
it, especially on:


- what do the options in the files
   defaults/preferences/*.js
   chrome/content/extensions.rdf
  mean?
- what does the directory custom/sogo-demo do?

Some examples (and a overall documentation on the options) of 
update.php also would be great.


I created the site what can generate a script for correct update 
site, and share the link, but no one interested in it since more than 
a week. :(

I though some people need it...




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

Re: [SOGo] ActiveSync question

[Szládovics Péter]

2013-09-04 08:37 keltezéssel, Anna Christina Naß írta:

Am 03.09.2013 21:19, schrieb Szládovics Péter:

Hallo,


CalDAV and CardDAV work fine and are not very complicated to set up
for the users (except when using Lightning/SOGo Connector where the
full paths seem to be needed).


Did you try the SOGo Integrator?
If you build it for yourself, and set up an update site next to SOGo,
the set up will be very simple, and you can use the share/subscribe
features on the pages of Lightning and Addressbook apps.

If more people interested in this method, I can create and present a
short doc about easy set up these things on your site for you.


I looked at the documentation (SOGo Mozilla Thunderbird 
Configuration.pdf), decided that this documentation is far from 
complete and ignored the Integrator for now.


It would be great if you could provide some more documentation on it, 
especially on:


- what do the options in the files
   defaults/preferences/*.js
   chrome/content/extensions.rdf
  mean?
- what does the directory custom/sogo-demo do?

Some examples (and a overall documentation on the options) of 
update.php also would be great.


I created the site what can generate a script for correct update site, 
and share the link, but no one interested in it since more than a week. :(

I though some people need it...
--
users@sogo.nu
https://inverse.ca/sogo/lists

Have to make CardDav work too - was: Re: [SOGo] ActiveSync question

[Marcio Merlone]

Em 06-09-2013 15:53, Corrado Fiore escreveu:

I could not make it work with SOGo. I commented all but BackendImap, caldav and 
carddav on combined/config.php, edited each config.php for each enabled 
backend, and yet only imap works. When I try to list available calendars on my 
account it shows nothing.

Could you please post the relevant lines in the CardDAV / CalDAV backends' conf 
to a pastebin?  It's likely that the paths you specified are the culprit here.

Hi Corrado and list,

As I sayd before, IMAP and CalDav are working great. But could not make 
CardDav work, can you assist me? CardDav backend config is as follows:


// http://YOURSOGOINSTALL/dav/YOURUSERNAME/Contacts/personal
define('CARDDAV_PROTOCOL', 'https');
define('CARDDAV_SERVER', 'sogo.domain.tld');
define('CARDDAV_PORT', '443');
define('CARDDAV_PATH', '/SOGo/dav/%u/Contacts/personal/');
define('CARDDAV_CONTACTS_FOLDER_NAME', '');
define('CARDDAV_SUPPORTS_SYNC', true);

Have tested on my real Defy CM10 (Android 4.1) and a virtual Galaxy S4 
from Genymotion, both (did not) worked the same. Also tried:


define('CARDDAV_PATH', '/SOGo/dav/%u/Contacts/');
define('CARDDAV_CONTACTS_FOLDER_NAME', 'personal');

Thank you, best regards.

--
*Marcio Merlone*
TI - Administrador de redes

*A1 Engenharia - Unidade Corporativa*
Fone:   +55 41 3616-3797
Cel:+55 41 9689-0036

http://www.a1.ind.br/ http://www.a1.ind.br
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Marcio Merlone]

Em 06-09-2013 15:53, Corrado Fiore escreveu:

I could not make it work with SOGo. I commented all but BackendImap, caldav and 
carddav on combined/config.php, edited each config.php for each enabled 
backend, and yet only imap works. When I try to list available calendars on my 
account it shows nothing.

Could you please post the relevant lines in the CardDAV / CalDAV backends' conf 
to a pastebin?  It's likely that the paths you specified are the culprit here.

Hi,

Indeed. I managed to find out what was wrong by try-and-miss some days 
ago, just could not yet give it back. In order to caldav backend work 
with SOGo, I had to fiddle with its config.php to dismember the whole 
caldav url into its correct defines, as follows:


define('CARDDAV_PROTOCOL', 'https');
define('CARDDAV_SERVER', 'sogo.domain.tld');
define('CARDDAV_PORT', '443');
define('CARDDAV_PATH', '/SOGo/dav/%u/');
define('CARDDAV_CONTACTS_FOLDER_NAME', 'Contacts/personal');

For instance, if you define('CARDDAV_PATH', '/SOGo/dav/%u/Contacts') 
taking Contacts off from below, it wont work. At the end, ActiveSync 
is working smooth for imap and caldav, have not tested contacts, dont 
miss that, but I assume is working :P


Best regards.

--
*Marcio Merlone*
TI - Administrador de redes

*A1 Engenharia - Unidade Corporativa*
Fone:   +55 41 3616-3797
Cel:+55 41 9689-0036

http://www.a1.ind.br/ http://www.a1.ind.br
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Marcio Merlone]

Em 05-09-2013 16:24, Corrado Fiore escreveu:

could not find the relevant options to set on it - imap server, caldav and 
carddav server, path, etc

Each backend has its own config file, located at
   /backend/$backendName/config.php
For instance, the IMAP config file is
   /backend/imap/config.php


Very nice and cleaner filesystem layout, have managed to find that 
afterwards. But I could not make it work with SOGo. I commented all but 
BackendImap, caldav and carddav on combined/config.php, edited each 
config.php for each enabled backend, and yet only imap works. When I try 
to list available calendars on my account it shows nothing. Enabled 
debug and no information seemed to help me. Any other backend should be 
enabled?


Have tested on a custom ROM CM10 (Android 4.1) defy and a stock ROM 
Samsung Galaxy S4 with different accounts, none worked. Any hint? Is 
there how to contact fmbiete?


Best regards.

--
*Marcio Merlone*
TI - Administrador de redes

*A1 Engenharia - Unidade Corporativa*
Fone:   +55 41 3616-3797
Cel:+55 41 9689-0036

http://www.a1.ind.br/ http://www.a1.ind.br
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Corrado Fiore]

Hi Marcio,

 I could not make it work with SOGo. I commented all but BackendImap, caldav 
 and carddav on combined/config.php, edited each config.php for each enabled 
 backend, and yet only imap works. When I try to list available calendars on 
 my account it shows nothing.

Could you please post the relevant lines in the CardDAV / CalDAV backends' conf 
to a pastebin?  It's likely that the paths you specified are the culprit here.

-- 
Corrado




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

Re: [SOGo] ActiveSync question

[Corrado Fiore]

Hi Marcio,

 could not find the relevant options to set on it - imap server, caldav and 
 carddav server, path, etc

Each backend has its own config file, located at 

  /backend/$backendName/config.php

For instance, the IMAP config file is

  /backend/imap/config.php

Best,
Corrado


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

Re: [SOGo] ActiveSync question

[Anna Christina Naß]

Am 03.09.2013 21:19, schrieb Szládovics Péter:

Hallo,


CalDAV and CardDAV work fine and are not very complicated to set up
for the users (except when using Lightning/SOGo Connector where the
full paths seem to be needed).


Did you try the SOGo Integrator?
If you build it for yourself, and set up an update site next to SOGo,
the set up will be very simple, and you can use the share/subscribe
features on the pages of Lightning and Addressbook apps.

If more people interested in this method, I can create and present a
short doc about easy set up these things on your site for you.


I looked at the documentation (SOGo Mozilla Thunderbird 
Configuration.pdf), decided that this documentation is far from complete 
and ignored the Integrator for now.


It would be great if you could provide some more documentation on it, 
especially on:


- what do the options in the files
   defaults/preferences/*.js
   chrome/content/extensions.rdf
  mean?
- what does the directory custom/sogo-demo do?

Some examples (and a overall documentation on the options) of update.php 
also would be great.


Thank you!

Kind regards,
Anna Christina Naß
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Martin Rabl]

Hi,

Am 04.09.13 08:37, schrieb Anna Christina Naß:

It would be great if you could provide some more documentation on it,
especially on:

- what do the options in the files
defaults/preferences/*.js
chrome/content/extensions.rdf
   mean?

Ignore them. ;-)
If not:
- default/preferences holds all default preferences a TB-Plugin use when 
it starts the first time - nice for preconfiguration, but not often 
needed, I think. This preferences will be overridden after set the user 
settings.
(the *.js files will all be read and interpreted from the gecko/XUL 
machine, I think, alphabetically)


- extensions.rdf: Pls. have a look at
https://developer.mozilla.org/en-US/docs/Install_Manifests
https://developer.mozilla.org/en-US/docs/Extension_Versioning,_Update_and_Compatibility


Greetings,
   Martin

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

Re: [SOGo] ActiveSync question

[Szládovics Péter]

2013-09-04 13:42 keltezéssel, Martin Rabl írta:

Hi,

Am 04.09.13 08:37, schrieb Anna Christina Naß:

It would be great if you could provide some more documentation on it,
especially on:

- what do the options in the files
defaults/preferences/*.js
chrome/content/extensions.rdf
   mean?

Ignore them. ;-)
If not:
- default/preferences holds all default preferences a TB-Plugin use 
when it starts the first time - nice for preconfiguration, but not 
often needed, I think. This preferences will be overridden after set 
the user settings.
(the *.js files will all be read and interpreted from the gecko/XUL 
machine, I think, alphabetically)


- extensions.rdf: Pls. have a look at
https://developer.mozilla.org/en-US/docs/Install_Manifests
https://developer.mozilla.org/en-US/docs/Extension_Versioning,_Update_and_Compatibility 



It's not enough...
You need an update site too for correct functionality. I'm working on a 
self-configured build site:


You give some parameters on a web form, and will receive a script in 
email. You save the script to the server what is hosted the SOGo WebUI, 
and just run it with normal user privileges.
It will configure your update site (if needed), download the most fresh 
git sources from Inverse, set up the Integrator parameters, build the 
xpi files (Integrator and Connector too) and set up the update site code 
for fresh builds (file names, versions, etc.).


If you run it again at the future, it will refresh the plugins - do not 
run it under cron, because it will need the password for sudo. Only use 
it with commandline.


So, please a little patience :)
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Marcio Merlone]

Em 03-09-2013 12:12, Corrado Fiore escreveu:

I've been in touch in the past days with Francisco Miguel Biete, author of 
Z-Push-contrib, a fork from the original Z-Push that is working well (at least, 
in our tests) with SOGo:

 https://github.com/fmbiete/Z-Push-contrib


Hi,

I am giving this a try, file system structure seems cleaner, only one 
config.php, which is nice. But could not find the relevant options to 
set on it - imap server, caldav and carddav server, path, etc -  should 
I copy them from the other project? Any hint?


Best regards.

--
*Marcio Merlone*
TI - Administrador de redes

*A1 Engenharia - Unidade Corporativa*
Fone:   +55 41 3616-3797
Cel:+55 41 9689-0036

http://www.a1.ind.br/ http://www.a1.ind.br
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Don L]

I look forward to seeing this, right now I find the updater very 
confusing.  A question though, if run as root under cron would it still 
need the sudo password?



On 9/4/2013 9:09 AM, Szládovics Péter wrote:

2013-09-04 13:42 keltezéssel, Martin Rabl írta:

Hi,

Am 04.09.13 08:37, schrieb Anna Christina Naß:

It would be great if you could provide some more documentation on it,
especially on:

- what do the options in the files
defaults/preferences/*.js
chrome/content/extensions.rdf
   mean?

Ignore them. ;-)
If not:
- default/preferences holds all default preferences a TB-Plugin use 
when it starts the first time - nice for preconfiguration, but not 
often needed, I think. This preferences will be overridden after set 
the user settings.
(the *.js files will all be read and interpreted from the gecko/XUL 
machine, I think, alphabetically)


- extensions.rdf: Pls. have a look at
https://developer.mozilla.org/en-US/docs/Install_Manifests
https://developer.mozilla.org/en-US/docs/Extension_Versioning,_Update_and_Compatibility 



It's not enough...
You need an update site too for correct functionality. I'm working on 
a self-configured build site:


You give some parameters on a web form, and will receive a script in 
email. You save the script to the server what is hosted the SOGo 
WebUI, and just run it with normal user privileges.
It will configure your update site (if needed), download the most 
fresh git sources from Inverse, set up the Integrator parameters, 
build the xpi files (Integrator and Connector too) and set up the 
update site code for fresh builds (file names, versions, etc.).


If you run it again at the future, it will refresh the plugins - do 
not run it under cron, because it will need the password for sudo. 
Only use it with commandline.


So, please a little patience :)


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

Re: [SOGo] ActiveSync question

[Szládovics Péter]

2013-09-04 19:35 keltezéssel, Don L írta:
I look forward to seeing this, right now I find the updater very 
confusing.  A question though, if run as root under cron would it 
still need the sudo password?


No, it won't need. But I not recommend it - by a simply reason.
If you run it under cron, the site contents will update automatically, 
and your clients (Thunderbird) will upgrade automatically too. It's a 
problem!


Never upgrade anything before you not try it correctly!

You can decline it, and use it by root (but you need to edit the script, 
because it exits if you have root privileges. :)

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

[SOGo] ActiveSync question

[alge]

Hi,

just wanted to bring back to attention that SOGo still lacks working ActiveSync 
connectivity.

My question is, are there any plans that inverse will be working on this?

I had to switch away from sogo to zarafa 2 years ago (after some unsuccessful 
tests with z-push / sogosync, see it mentioned in the Sogo Wiki) because more 
and more devices stopped working with SyncML and ActiveSync was the only 
alternative way to sync on them.

Now my zarafa installation died (database died by hard disk error) and I wanted 
to check out SOGo again.

After successfully setting up Samba4, SOGo, OpenChange I sadly had to regognize 
that the current z-push implementation (PHP-Push2) still is far from working. 

Meanwhile I'm installing horde3 (before falling back to a new zarafa 
installation) because they claim at least some ActiveSync support 
(http://wiki.horde.org/ActiveSync) while keeping a modular setup (reusing an 
existing IMAP server).

I have to admit that zarafa's z-push really worked for all my devices (Android, 
iOS, webOS, S60, BBOS 10, WM 6.*, WP 7.*, WP8, PlayBook OS 2.*), so why does 
(almost) the same PHP code fail for SOGo? (I know, it uses a different backend, 
the DAV access from PHP to SOGo is the difference).

I'm not sure if my situation with ActiveSync beeing a show stopper for 
deploying SOGo is generalizable enough, what do other people think of it? Did I 
miss something?


Best regards,

Albrecht



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

Re: [SOGo] ActiveSync question

[Jan-Frode Myklebust]

On Tue, Sep 03, 2013 at 10:54:52AM +0200, alge wrote:
 
 I'm not sure if my situation with ActiveSync beeing a show stopper for
 deploying SOGo is generalizable enough, what do other people think of
 it? Did I miss something?

I completely agree (except we didn't let it stop the show). Configuring
mobile clients without ActiveSync is too cumbersome, and my little
exposure to z-push didn't convince me it was production ready..

Is there anything we can do to get Inverse to focus on ActiveSync
support? Does it need funding? Is it a big difficult feature, or ..?



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

Re: [SOGo] ActiveSync question

[Martin Rabl]

I think, the problem is ActiveSync itself, because it is not a free 
solution. We are able to implement it, because of thousand pages of 
documentation, but have to license using our implementation by Microsoft 
- theoretically.
SOGo sets only on free interfaces like CALDAV etc. And it integrates the 
free Openchange (which implements the IMHO non-free MAPI from Microsoft).


Ok, it would be nice to have a built-in ActiveSync solution in SOGo. But 
IMHO the better way is to set on third party software, when there are 
CALDAV-Interfaces (or SMTP/IMAP ...) available.


So, PHP-Push2 seems for me the only way for integrating AS with SOGo, 
but its not a Inverse project, so they are not responsible for it.


The problem of PHP-Push is the big less:
- less developers
- less testing users (!!!)
- less money

I'm sure, with more developer and more testing users it will do a step 
forward making ActiveSync usable. And THAT would be for me a solution - 
instead of grumbling to Inverse.



Greetings,
   Martin

Am 03.09.13 12:54, schrieb Jan-Frode Myklebust:

On Tue, Sep 03, 2013 at 10:54:52AM +0200, alge wrote:


I'm not sure if my situation with ActiveSync beeing a show stopper for
deploying SOGo is generalizable enough, what do other people think of
it? Did I miss something?


I completely agree (except we didn't let it stop the show). Configuring
mobile clients without ActiveSync is too cumbersome, and my little
exposure to z-push didn't convince me it was production ready..

Is there anything we can do to get Inverse to focus on ActiveSync
support? Does it need funding? Is it a big difficult feature, or ..?



   -jf



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

Re: [SOGo] ActiveSync question

[Albrecht Gebhardt]

Jan-Frode Myklebust schrieb:
 ...
 mobile clients without ActiveSync is too cumbersome, and my little
 exposure to z-push didn't convince me it was production ready..
but only the SOGo specific derived z-push variants, z-push combined with
zarafa is production ready.



Albrecht

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

Re: [SOGo] ActiveSync question

[Corrado Fiore]

Dear All,

I've been in touch in the past days with Francisco Miguel Biete, author of 
Z-Push-contrib, a fork from the original Z-Push that is working well (at least, 
in our tests) with SOGo:

https://github.com/fmbiete/Z-Push-contrib

What's important here is that Francisco Miguel has been very responsive in 
fixing the bugs we submitted (one for CardDAV, the other for the IMAP backend). 
 I must say I'm quite impressed.

ActiveSync seems to be working very well, and so far seems to be solid enough 
that we can use it in production.  However, documentation could be a bit more 
organized, so here's the idea:  I'll try to sum all the usual mistakes on a 
page in the SOGo wiki.  Allow me some days for this, I'll try my best.

On the other hand, I agree that the SOGo community needs a point of reference 
for Z-Push just like Inverse is for SOGo.

Best,
Corrado Fiore


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

Re: [SOGo] ActiveSync question

[Albrecht Gebhardt]

You may be correct with your guess regarding the licensing situation, if for 
that reason such a project has to stay outside the base SOGo distribution it 
will be ok.

My intention was not to grumble about something, I just wanted to bring some 
attention to this problem. It seems to me that  over the last years several 
trials of implementing ActiveSync have been started by community members, which 
after some time more or less stopped their experiments (at least correct for my 
trial some years ago).

Good to know that there is even another project as mentioned by Corrado Fiore 
in this thread, I will give this also a try.

Another question is: Have these projects all to be based on z-push? What if 
hordes ActiveSync interface also could be used as starting point? Or with 
Openchange: can z-push directly access the MAPI stores as it does when used 
with zarafa (I can be completely wrong here)?

But again it shows the need for better collaboration between ActiveSync 
interested SOGo users.

Best regards,

Albrecht

Am 03.09.2013 um 14:20 schrieb Martin Rabl martin.r...@rablnet.de:

 I think, the problem is ActiveSync itself, because it is not a free solution. 
 We are able to implement it, because of thousand pages of documentation, but 
 have to license using our implementation by Microsoft - theoretically.
 SOGo sets only on free interfaces like CALDAV etc. And it integrates the free 
 Openchange (which implements the IMHO non-free MAPI from Microsoft).
 
 Ok, it would be nice to have a built-in ActiveSync solution in SOGo. But IMHO 
 the better way is to set on third party software, when there are 
 CALDAV-Interfaces (or SMTP/IMAP ...) available.
 
 So, PHP-Push2 seems for me the only way for integrating AS with SOGo, but its 
 not a Inverse project, so they are not responsible for it.
 
 The problem of PHP-Push is the big less:
 - less developers
 - less testing users (!!!)
 - less money
 
 I'm sure, with more developer and more testing users it will do a step 
 forward making ActiveSync usable. And THAT would be for me a solution - 
 instead of grumbling to Inverse.
 
 
 Greetings,
   Martin
 
 Am 03.09.13 12:54, schrieb Jan-Frode Myklebust:
 On Tue, Sep 03, 2013 at 10:54:52AM +0200, alge wrote:
 
 I'm not sure if my situation with ActiveSync beeing a show stopper for
 deploying SOGo is generalizable enough, what do other people think of
 it? Did I miss something?
 
 I completely agree (except we didn't let it stop the show). Configuring
 mobile clients without ActiveSync is too cumbersome, and my little
 exposure to z-push didn't convince me it was production ready..
 
 Is there anything we can do to get Inverse to focus on ActiveSync
 support? Does it need funding? Is it a big difficult feature, or ..?
 
 
 
   -jf
 
 
 -- 
 users@sogo.nu
 https://inverse.ca/sogo/lists

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

Re: [SOGo] ActiveSync question

[Corrado Fiore]

Dear Albrecht,

 Another question is: Have these projects all to be based on z-push? What if 
 hordes ActiveSync interface also could be used as starting point?

Actually, Horde's ActiveSync module is based on Z-Push:

The code that handles the protocol level is essentially the same, though it 
has been heavily refactored and cleaned.

Ref.:  http://wiki.horde.org/ActiveSync#toc24

Best,
Corrado


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

Re: [SOGo] ActiveSync question

[Anna Christina Naß]

On 03.09.2013 18:59, Corrado Fiore wrote:

Hallo,


Another question is: Have these projects all to be based on z-push? What if 
hordes ActiveSync interface also could be used as starting point?


Actually, Horde's ActiveSync module is based on Z-Push:

The code that handles the protocol level is essentially the same, though it has 
been heavily refactored and cleaned.

Ref.:  http://wiki.horde.org/ActiveSync#toc24


And it is very limited -- all Horde calendars (that are selected to be 
synced) are mixed together into one virual calendar which is shown to 
the device.
I've pointed to this bug several times, I was told that this is by 
design.


I am using z-Push now with IMAP backend only for my SOGo installation, 
CalDAV and CardDAV work fine and are not very complicated to set up for 
the users (except when using Lightning/SOGo Connector where the full 
paths seem to be needed).


Regards
Anna Christina Naß

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

Re: [SOGo] ActiveSync question

[Geoff Nordli]

On 13-09-03 09:59 AM, Corrado Fiore wrote:

Dear Albrecht,


Another question is: Have these projects all to be based on z-push? What if 
hordes ActiveSync interface also could be used as starting point?

Actually, Horde's ActiveSync module is based on Z-Push:

The code that handles the protocol level is essentially the same, though it has 
been heavily refactored and cleaned.

Ref.:  http://wiki.horde.org/ActiveSync#toc24

Best,
Corrado





As a note Kolab 3 switched from z-push to syncroton.

http://www.syncroton.org/wiki/Main_Page

My perception is they have invested a lot of energy into that product 
and it is licensed LGPL.


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

Re: [SOGo] ActiveSync question

[Steven Swarts]

Not being a programmer forgive my ignorance, but could that code be 
used? They have a done a fantastic job so far in my opinion.


*/Regards,/*

*/Steven Swarts/*


On 4/09/2013 12:59 AM, Corrado Fiore wrote:

Dear Albrecht,


Another question is: Have these projects all to be based on z-push? What if 
hordes ActiveSync interface also could be used as starting point?

Actually, Horde's ActiveSync module is based on Z-Push:

The code that handles the protocol level is essentially the same, though it has 
been heavily refactored and cleaned.

Ref.:  http://wiki.horde.org/ActiveSync#toc24

Best,
Corrado




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

Re: [SOGo] ActiveSync question

[Marcio Merlone]

Em 03-09-2013 07:54, Jan-Frode Myklebust escreveu:

On Tue, Sep 03, 2013 at 10:54:52AM +0200, alge wrote:

I'm not sure if my situation with ActiveSync beeing a show stopper for
deploying SOGo is generalizable enough, what do other people think of
it? Did I miss something?

I completely agree (except we didn't let it stop the show). Configuring
mobile clients without ActiveSync is too cumbersome, and my little
exposure to z-push didn't convince me it was production ready..


OTOH, z-push made me meet Zarafa, and consider Zimbra too. SOGo is 
great, but mobile support in the pos-pc era is a must for enterprises. 
Looking for alternatives.


Best regards.

--
*Marcio Merlone*
TI - Administrador de redes

*A1 Engenharia - Unidade Corporativa*
Fone:   +55 41 3616-3797
Cel:+55 41 9689-0036

http://www.a1.ind.br/ http://www.a1.ind.br
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Szládovics Péter]

2013-09-03 19:55 keltezéssel, Anna Christina Naß írta:
CalDAV and CardDAV work fine and are not very complicated to set up 
for the users (except when using Lightning/SOGo Connector where the 
full paths seem to be needed).


Did you try the SOGo Integrator?
If you build it for yourself, and set up an update site next to SOGo, 
the set up will be very simple, and you can use the share/subscribe 
features on the pages of Lightning and Addressbook apps.


If more people interested in this method, I can create and present a 
short doc about easy set up these things on your site for you.

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

Re: [SOGo] SOGo Sieve Question

[Marc Patermann]

Marco,

Marco Benecke schrieb (12.08.2013 14:57 Uhr):


it seems i found a sieve Issue, but i am not sure.
Maybe you could confirm this.

Version:
ii  sogo 2.0.7-1

Settings:
:~# sogo-tool dump-defaults all|grep -i sieve
SOGoSieveScriptsEnabled = YES;
SOGoSieveServer = sieve://198.19.219.18:4190;

I managed my Mails in Subfolders:
lists
  |
  +--- SOGo Users
  |
  +--- and so on

Now i try to set a sieve filter, with the WebInterface.
Result in the sogo.sieve:

if anyof (header :contains List-Id users.sogo.nu, header :contains 
subject [SOGo]) {

fileinto lists/SOGo;
}

LogMessage:
sieve: info: started log at Aug 12 11:27:20.
error: msgid=...: failed to store into mailbox 'lists/SOGo': Invalid 
mailbox name.

sieve: info: started log at Aug 12 11:46:41.
error: msgid=...: failed to store into mailbox 'lists/SOGo': Invalid 
mailbox name.


proper sieve rule:
if anyof (header :contains List-Id users.sogo.nu, header :contains 
subject [SOGo]) {

fileinto lists.SOGo;
}

Did i miss a configuration option or is this a small Bug.


My sieve filters (Cyrus IMAPd) start with INXBOX for folders in my 
mailbox:


if header :contains List-Id users.sogo.nu {
fileinto INBOX.sogo;
stop;
}

Do you really want to store the messages in a folder under top level 
mailbox lists?


Does your file work with an upload by sieveshell directly to the sieve 
server?



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

[SOGo] SOGo Sieve Question

[Marco Benecke]

Hi,

it seems i found a sieve Issue, but i am not sure.
Maybe you could confirm this.

Version:
ii  sogo 2.0.7-1

Settings:
:~# sogo-tool dump-defaults all|grep -i sieve
SOGoSieveScriptsEnabled = YES;
SOGoSieveServer = sieve://198.19.219.18:4190;

I managed my Mails in Subfolders:
lists
  |
  +--- SOGo Users
  |
  +--- and so on

Now i try to set a sieve filter, with the WebInterface.
Result in the sogo.sieve:

if anyof (header :contains List-Id users.sogo.nu, header :contains 
subject [SOGo]) {

fileinto lists/SOGo;
}

LogMessage:
sieve: info: started log at Aug 12 11:27:20.
error: msgid=...: failed to store into mailbox 'lists/SOGo': Invalid 
mailbox name.

sieve: info: started log at Aug 12 11:46:41.
error: msgid=...: failed to store into mailbox 'lists/SOGo': Invalid 
mailbox name.


proper sieve rule:
if anyof (header :contains List-Id users.sogo.nu, header :contains 
subject [SOGo]) {

fileinto lists.SOGo;
}

Did i miss a configuration option or is this a small Bug.

fine Regards
Marco B.

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

[SOGo] Simple Question re Events ....

[steve_a]

When a user receives a GoToMeeting event notification in ICS format, can it be
saved or imported to the SOGo Calendar, and if so, how?
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Simple Question re Events ....

[Christian Mack]

Hello Steve


Am 2013-04-16 16:58, schrieb stev...@cinergymetro.net:
 When a user receives a GoToMeeting event notification in ICS format, can it be
 saved or imported to the SOGo Calendar, and if so, how?
 

I don't know GoToMeeting.
How does an event notification look like?

If it is a valid *.ics file, you can simply import it into the desired
calendar.


Kind regards,
Christian Mack

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

Re: [SOGo] Simple Question re Events ....

[Steve Ankeny]

Thanks for the response, Christian!

I figured it out for myself by simply right-clicking and choosing 
Convert | Event


That launched it in Thunderbird where I could Save and Close

GoToMeeting is a facilitator many companies use to sponsor webinars via 
a Citrix environment.


In other words, when someone wants to conduct an online seminar, they 
invite people to attend, and when the webinar launches, it installs a 
Citrix extension in the browser, and attendees can watch and listen as 
the presenter presents his subject matter.  In this case, it's a field 
office training their reps.


On 04/16/2013 12:15 PM, Christian Mack wrote:

Hello Steve


Am 2013-04-16 16:58, schrieb stev...@cinergymetro.net:

When a user receives a GoToMeeting event notification in ICS format, can it be
saved or imported to the SOGo Calendar, and if so, how?


I don't know GoToMeeting.
How does an event notification look like?

If it is a valid *.ics file, you can simply import it into the desired
calendar.


Kind regards,
Christian Mack



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

[SOGo] Printing question (font) ....

[Steve Ankeny]

  
  
When printing the calendar, we get a font error:




This is a screenshot of a PDF printed from the Weekly Planner
layout.

I've tried editing the 'Advanced' printing options, but it would
appear it's picking up the wrong font on the server side (i.e.,
within the ZEG) Would installing other fonts correct the error?

It's being printed from within a Windows Remote Desktop, so it
should be using Windows fonts.

  

Re: [SOGo] Newby question

[Ronald J. Yacketta]

 Ops!! should refrain from posting when tired *lol*

Scientific Linux 6.3
 
 
On Tuesday, 12 February, 2013 08:46 EST, Ronald J. Yacketta 
yacke...@potsdam.edu wrote: 
 
 We use Slackware 6.3 (Spin off of RedHat / Centos) , its pretty much a breeze 
 to install and maintain. 
 Simple to add the SOGo repo and install SOGo / DB (MySQL or PSQL)
  
  
 On Tuesday, 12 February, 2013 07:16 EST, gia...@compulogics.com.au wrote: 
  
  Hi all,
  I am new here and at Sogo.  I am looking for a linux distro which is easy to
  maintain and onto which sogo installs properly.  Some distros do not support
  samba4 and ldap needed.
  
  I have tried ubuntu, but it is too daunting..maybe it's just me.
  
  Any help would be greatly appreciated.
  gb
  -- 
  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] Newby question

[Ronald J. Yacketta]

 
 
 
On Wednesday, 13 February, 2013 01:52 EST, vordoo vor...@yahoo.com wrote: 
 
 
 
 On 2013-02-13 03:46, Ronald J. Yacketta
   wrote:
 
 
   We use Slackware 6.3 (Spin off of RedHat / Centos) , its pretty much a 
 breeze to install and maintain. 
 Simple to add the SOGo repo and install SOGo / DB (MySQL or PSQL)
  
 
 
 ROFLOL
 
 :-)
 
yup and major ROFL *sigh*

Should have been Scientific Linux (https://www.scientificlinux.org/)
 

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

RE: [SOGo] Newby question

[Gianni Boscarino]

HI there and thanks...So it's scientific linux??

-Original Message-
From: Ronald J. Yacketta [mailto:yacke...@potsdam.edu] 
Sent: Wednesday, 13 February 2013 7:48 PM
To: users@sogo.nu
Subject: Re: [SOGo] Newby question

 
 
 
On Wednesday, 13 February, 2013 01:52 EST, vordoo vor...@yahoo.com wrote: 
 
 
 
 On 2013-02-13 03:46, Ronald J. Yacketta
   wrote:
 
 
   We use Slackware 6.3 (Spin off of RedHat / Centos) , its pretty much a 
 breeze to install and maintain. 
 Simple to add the SOGo repo and install SOGo / DB (MySQL or PSQL)
  
 
 
 ROFLOL
 
 :-)
 
yup and major ROFL *sigh*

Should have been Scientific Linux (https://www.scientificlinux.org/)
 

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

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

Re: [SOGo] Newby question

[Ludovic Marcotte]

On 13/02/13 08:38, Gianni Boscarino wrote:

HI there and thanks...So it's scientific linux??

I think he meant Scientific Pangolin.

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

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

RE: [SOGo] Newby question

[Gianni Boscarino]

OK so we are going to have one armor-plated four legged pengo!!

-Original Message-
From: Ludovic Marcotte [mailto:lmarco...@inverse.ca] 
Sent: Wednesday, 13 February 2013 9:48 PM
To: users@sogo.nu
Subject: Re: [SOGo] Newby question

On 13/02/13 08:38, Gianni Boscarino wrote:
 HI there and thanks...So it's scientific linux??
I think he meant Scientific Pangolin.

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

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

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

Re: [SOGo] Newby question

[mourik jan heupink]

I think he meant Scientific Pangolin.

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

RE: [SOGo] Newby question

[Gianni Boscarino]

That's Ubuntu anyway...

-Original Message-
From: mourik jan heupink [mailto:heup...@gmail.com] 
Sent: Wednesday, 13 February 2013 9:51 PM
To: users@sogo.nu
Subject: Re: [SOGo] Newby question

 I think he meant Scientific Pangolin.
Precisely
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

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

Re: [SOGo] Newby question

[Gert Karpelin]

Hi,

I plan install sogo. It is difficult to install sogo on ubuntu 12.04???

And it is easier to install sogo on Scientific Linux???




13.02.2013 15:53, Gianni Boscarino kirjutas:

That's Ubuntu anyway...

-Original Message-
From: mourik jan heupink [mailto:heup...@gmail.com]
Sent: Wednesday, 13 February 2013 9:51 PM
To: users@sogo.nu
Subject: Re: [SOGo] Newby question


I think he meant Scientific Pangolin.

Precisely



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

Re: [SOGo] Newby question

[Marc Patermann]

Gianni,

gia...@compulogics.com.au schrieb (13.02.2013 01:16 Uhr):


I am new here and at Sogo.  I am looking for a linux distro which is easy to
maintain and onto which sogo installs properly.  Some distros do not support
samba4 and ldap needed.

I have tried ubuntu, but it is too daunting..maybe it's just me.

Yes.

All in all it's your choice.
Everything that feels easy at start can become hard later on.


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

Re: [SOGo] Newby question

[Buddy Butterfly]

Hi,

I would go with the appliance given.
You can run it in VMWare, Xenserver or Virtualbox.
There should be everything installed. Though,
there is no documentation on how to configure this
to your needs. For example, it involves creating
a new ldap root etc.

Cheers,
Matt


Am 13.02.2013 01:16, schrieb gia...@compulogics.com.au:
 Hi all,
 I am new here and at Sogo.  I am looking for a linux distro which is easy to
 maintain and onto which sogo installs properly.  Some distros do not support
 samba4 and ldap needed.

 I have tried ubuntu, but it is too daunting..maybe it's just me.

 Any help would be greatly appreciated.
 gb

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

Re: [SOGo] Newby question

[Steve Ankeny]

For our use, we chose to go with the ZEG appliance!

We had some familiarity with Linux on desktops, but we purchased 4 hours 
of paid support from Inverse, and they configured the initial 
installation.  We mounted it on VMware.


1-1/2 years later, we were faced with upgrading both the underlying 
Ubuntu (11.04 to 12.04) and 'sogo,' 'sope and 'cyrus'  We had some 
problems with 'cyrus' that required help from Inverse.


However, most of the updates/upgrades went well, and I was able to work 
through them.


We've been very happy with the ZEG appliance!  I found that 'webmin' 
helped with the initial configuration, and I suspect it will help even 
further when we decide to install 'samba4'


I recommend using the ZEG appliance (but would agree that documentation 
would help)


On 02/13/2013 11:04 AM, Buddy Butterfly wrote:

Hi,

I would go with the appliance given.
You can run it in VMWare, Xenserver or Virtualbox.
There should be everything installed. Though,
there is no documentation on how to configure this
to your needs. For example, it involves creating
a new ldap root etc.

Cheers,
Matt


Am 13.02.2013 01:16, schrieb gia...@compulogics.com.au:

Hi all,
I am new here and at Sogo.  I am looking for a linux distro which is easy to
maintain and onto which sogo installs properly.  Some distros do not support
samba4 and ldap needed.

I have tried ubuntu, but it is too daunting..maybe it's just me.

Any help would be greatly appreciated.
gb


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

Re: [SOGo] Newby question

[Gert Karpelin]

I've never heard  about scientific linux :) , but  I will try it .
And I must use same yum repostories as for redhat6 (including [rpmforge-extras]
and [epel]) ?

Gert



2013/2/13 Ronald J. Yacketta yacke...@potsdam.edu




 On Wednesday, 13 February, 2013 08:47 EST, Ludovic Marcotte 
 lmarco...@inverse.ca wrote:

  On 13/02/13 08:38, Gianni Boscarino wrote:
   HI there and thanks...So it's scientific linux??
  I think he meant Scientific Pangolin.

 *lol* how about https://www.scientificlinux.org/
 
  --
  Ludovic Marcotte
  +1.514.755.3630  ::  www.inverse.ca
  Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (
 www.packetfence.org)
 
  --
  users@sogo.nu
  https://inverse.ca/sogo/lists



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

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