Re: [SOGo] Akamai Technologies, Inc. Acquires Inverse

[Frank Pauxberger]

Congratulations, Ludo! I hope for you and the Inverse team things move 
into the direction you want them to! For 'us' I hope some things stay 
unchanged ;-)


All the best
Frank



 Original-Message 
Subject: [SOGo] Akamai Technologies, Inc. Acquires Inverse
From: Ludovic Marcotte" (Lmarcotte) 
To: Users 
CC:
Date:  Montag, 1. Feb. 2021, 14:10 (MN +0100)


Dear Valued Community Member,

We have exciting news to share with you. Today, _Akamai Technologies 
_ of Cambridge, Massachusetts announced its 
acquisition of Inverse. Akamai is a global content delivery network, 
cybersecurity and cloud service company, providing web and internet 
security services.


The Inverse team is looking forward to becoming part of Akamai’s 
Enterprise security group. We plan to continue to support Inverse’s 
current offerings and open source community as we unite the businesses.


Learn more about this news by viewing the _press release 
_and_blog 
post 
_that 
went out moments ago. Thank you again for your ongoing support and 
loyalty as a community member. We look forward to continuing to 
improve our open source software solutions.


Regards,

Ludo

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

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

Re: [SOGo] Thunderbird Status

[Frank Pauxberger]

Hi Christian,

I have started with SOGo some time back in 2011 and still love it after 
about 10 years. It does everything I need and look for and I keep 
recommending it! Great work once more and once again!!


This time though I have to admit I am slightly disappointed on whatever 
happens around the Plugin for TB78. I have tested it over and over again 
with varying results, always using the latest versions of the SW 
required. And with various comments here in the mailing list.

But I fully agree, it is not production ready.

So for now I stay on TB68 in Prod and have a test instance with TB78 
using TbSync/provider for CalDAV and CardDAV/Category Manager. That is 
sort of ok but nothing I would recommend in larger scenarios. I am 
really (really really, Ludovic) looking forward to having a reliably 
working SOGo Connector for Thunderbird 78.


What is the bottle neck?

Kind regards
Frank




 Original-Message 
Subject: [SOGo] Thunderbird Status
From: Cn 
To: Users 
CC:
Date:  Mittwoch, 13. Jan. 2021, 14:09 (MN +0100)

Hello all,
I wanted to ask what the current plan/status is of the TB Plugin for 
78. It is not really ready for production yet.

So what are the plans?
Is there a timeline?
What are other doing in the meantime? Stay on 68 ?

Regards


Christian

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

Re: [SOGo] Thunderbird 78 Connector

[Frank Pauxberger]

Hi Greg,

I followed the steps at https://github.com/inverse-inc/sogo-connector 
which are the ones you will find in the README.md.
The copy cmd generates the config for your site so yes, my lucky guess 
was I renamed it to my SOGo server's public URL.

In the file
custom//chrome/content/sogo-connector/general/custom-preferences.js
I did the following

  demo: force_char_pref("sogo-connector.baseURL", 
"https://demo.sogo.nu/SOGo;);
  mySOGoserver: force_char_pref("sogo-connector.baseURL", 
"https://www./SOGo");


then I ran the build commands and zipped the stuff back into the XPI file.

For that worked in the sense that Thunderbird found my calendars and my 
address book. What didn't work though:


- Not the full address book was synced (according to Ludovic that is due 
to a bug in Thunderbird; there is a workaround using SOGo 5.0.1 and the 
latest SOPE version. That *did not* fix it for me!)
- I cannot edit calendar entries in Thunderbird; when saving an entry I 
get the message that it recently was changed on the server and if I want 
to reload or safe anyways. Saving does not work after either.


So for now I stick with T68 and the working environment, happy to test 
the "new" stuff though as well.


Frank



Am 05.11.20 um 20:44 schrieb Greg Miller (gmil...@conley-inc.com):

Pardon the newbie questions...

What are the steps involved to create an XPI from the Connector code 
currently available on Github?  I'm used to modifying the "demo" XPI 
to suit our environment, but this appears to be a completely different 
process than I have done in the past.  I cloned the repo (pretty 
standard), but where do I go from there? The instructions in README.md 
state that I should "cp -a custom/sogo-demo custom/mysite".  Does 
"mysite" need to be set to something specific?  Does it need to be the 
fully-qualified URL of my SOGo server, or something else?  The 
instructions also state that I should "customize the 
sogo-connector.baseURL value" in 
"custom/mysite//chrome/content/sogo-connector/general/custom-preferences.js". 
However, I do not see "sogo-connector.baseURL" in this file.  I see 
compilation instructions for SOGo itself in the Wiki, but I can't find 
instructions for compiling the Thunderbird Connector.


Thanks for any direction you can provide to me!


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

Re: [SOGo] Thunderbird78 + address book sync

[Frank Pauxberger]

Am 03.11.20 um 15:18 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2020-11-03 9:10 a.m., Frank Pauxberger (fr...@pauxberger.de) wrote:

with Fedora 33 and Ubuntu 20.10 shipping Thunderbird 78 now as 
default I looked into migrating to the latest version available for 
each. I tried both ways, the auto-update along with updating the 
system and a fresh install. Then followed the steps at 
https://github.com/inverse-inc/sogo-connector to build my personal 
.xpi. Calendars seem ok, I haven't found anything missing there. But 
very fancy, I only get 162 out of 249 contacts with my address book.
Looking into the details it does look fine but I cannot get more 
contacts synced. Plus it seems when I change a contact in Thunderbird 
it is not synced back to the server, changes are not visible in the 
web UI. Any ideas? 


That's because of a Thunderbird bug. You must use the latest version 
(5.0.1 and +) of SOGo *and* SOPE.


Hi Ludovic,
thanks for your quick reply.  I am using a cloud server with Ubuntu 
16.04.7. The latest packages I am offered are:


sogo 5.0.1.20201103-1
sope 4.9.r1664.20201103

So in my case is sope causing the issue?

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

[SOGo] Thunderbird78 + address book sync

[Frank Pauxberger]

Hi all,

with Fedora 33 and Ubuntu 20.10 shipping Thunderbird 78 now as default I 
looked into migrating to the latest version available for each. I tried 
both ways, the auto-update along with updating the system and a fresh 
install. Then followed the steps at 
https://github.com/inverse-inc/sogo-connector to build my personal .xpi. 
Calendars seem ok, I haven't found anything missing there. But very 
fancy, I only get 162 out of 249 contacts with my address book.
Looking into the details it does look fine but I cannot get more 
contacts synced. Plus it seems when I change a contact in Thunderbird it 
is not synced back to the server, changes are not visible in the web UI. 
Any ideas?


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

Re: [SOGo] Unknown column 'c_hascertificate' in 'field list'

[Frank Pauxberger]

Hi,

same issue here. I found the change in the GIT log

https://github.com/inverse-inc/sogo/commit/f66278131267ecc67363e303a8edabf5f2d780fb#diff-f7d02c1fd40d613920753ef1dc49b3c3L36

Plus a script which included the changes

root@localhost:/usr/share/doc/sogo# grep c_hascertificate *
sql-update-3.2.10_to_4.0.0-mysql.sh:# 3- add the c_hascertificate column 
to contact quick table
sql-update-3.2.10_to_4.0.0-mysql.sh:    part="`echo -e \"ALTER TABLE 
$table ADD c_hascertificate INT4 DEFAULT 0;\\n\"`";
sql-update-3.2.10_to_4.0.0.sh:# 2- add the c_hascertificate column to 
contact quick table
sql-update-3.2.10_to_4.0.0.sh:    part="`echo -e \"ALTER TABLE $table 
ADD c_hascertificate INT4 DEFAULT 0;\\n\"`";

root@localhost:/usr/share/doc/sogo#
root@localhost:/usr/share/doc/sogo# ./sql-update-3.2.10_to_4.0.0-mysql.sh
Username (root): X
Hostname (127.0.0.1):
Database (sogo): X
This script will ask for the database password twice
Converting c_content from TEXT to LONGTEXT in the sogo_user_profile table
Converting c_mail from VARCHAR(255) to TEXT in Contacts quick tables
Enter password:
Enter password:
root@localhost:/usr/share/doc/sogo#

Though I as well did not find a trace of an announcement. Or did I miss 
something?


BR
Frank


 Original-Message 
Subject: Re: [SOGo] Unknown column 'c_hascertificate' in 'field list'
From: Michael Doerner | Technologywise" (Michael) 
To: Users 
CC:
Date:  Dienstag, 9. Januar 2018 10:12:28 (GMT +0100)


Thanks a lot for your help with this. It is now fixed although I am
still a little surprised to find this being added without announcement
(?) or I am searching for documentation in the wrong areas.

Thanks again.

On 09/01/18 00:40, "MicTieMix" (mictie...@gmail.com) wrote:

Had the same issue a couple of days ago...

It seems that a new column 'c_hascertificate' was added to the 
SoGo-mysql-database around Dec 25th.

I was able to resolve this issue by manually adding a column 'c_hascertificate' 
(as INT) to the relevant database.

Hope it helps!


-Original Message-
From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of Michael 
Doerner | Technologywise
Sent: Monday, 8 January 2018 04:56
To: users@sogo.nu
Subject: [SOGo] Unknown column 'c_hascertificate' in 'field list'

Hi all

I have just updated our SOGo to the very latest SOGo nightly build (for 
CentOS6), 3.2.10.20180107, hoping to fix a problem that must have started 
recently but I am unsure when exactly.

When trying to look at the address book in the SOGo web interface (tested with 
various users), the screen will show you the total amount of contacts but 
underneath, where the list of contacts should be seen, it looks like it is 
trying to refresh but not been able to show any entry.

The SOGo log shows the following:

Jan 08 09:47:03 sogod [3637]: [ERROR] <0x0x7fa98f65f468[GCSFolder]> -[GCSFolder 
fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 
'SELECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, c_mail, 
c_telephonenumber, c_categories, c_component, c_hascertificate FROM . (cut)...
ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'

We have not in any way tried to do something manually with the MySQL database 
so I wonder what might be the reason for this?

Any idea or help?

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


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

Re: [SOGo] ANN: SOGo v1.3.17

[Frank Pauxberger]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Congrats, folks! Good job there, thank you very much.

All the best,
Frank


schrieb Francis Lachapelle:
 = ANN: SOGo v1.3.17 =
 
 The Inverse Team is pleased to announce the immediate availability
 of SOGo 1.3.17. This is a minor release of SOGo which focuses on
 improved stability over previous versions.
 
 === What is SOGo ===
 
 SOGo is a free and modern scalable groupware server. It offers
 shared calendars, address books and emails through your favorite
 Web browser or by using a native client such as Mozilla Thunderbird
 and Lightning.
 
 SOGo is standard-compliant and supports CalDAV, CardDAV, GroupDAV
 and reuses existing IMAP, SMTP and database servers - making the
 solution easy to deploy and interoperable with many applications.
 
 SOGo features :
 
 * Scalable architecture suitable for deployments from dozen to many
 thousand users * Rich Web-based interface that shares the look and
 feel, the features and the data of Mozilla Thunderbird and
 Lightning * Improved integration with Mozilla Thunderbird and
 Lightning by using the SOGo Connector and the SOGo Integrator *
 Two-way synchronization support with any SyncML-capable devices
 (BlackBerry, Palm, Windows CE, etc.) by using the Funambol SOGo
 Connector * Excellent integration with Apple iCal, Apple iOS and
 Android-based devices
 
 and many more! SOGo and our connectors are completely free.
 
 === Changes from the previous release ===
 
 New Features * new contextual menu to view the raw content of
 events, tasks and contacts * send and/or receive email
 notifications when a calendar is modified (new domain defaults
 SOGoNotifyOnPersonalModifications and
 SOGoNotifyOnExternalModifications) * added the
 SOGoSearchMinimumWordLength domain default which controls the
 minimal length required before trigging server-side search
 operations for attendee completion, contact searches, etc. The
 default value is 2, which means search operations are trigged once
 the 3rd character is typed.
 
 Enhancements * updated BrazilianPortuguese, Czech, Dutch, French,
 German, Italian, Spanish (Argentina), Spanish (Spain) translations 
 * all addresses from a contact are displayed in the Web interface
 (no longer limited to one additional address) * improved Sieve
 script: vacation message is now sent after evaluating the mail
 filters * updated CKEditor to version 3.6.4
 
 Bug Fixes * fixed a crash when multiple mail headers of the same
 type were encountered * fixed logrotate script for Debian * fixed
 linking of libcurl on Ubuntu 12.04 * fixed parsing of timezones
 when importing .ics files * fixed resource reservation for
 recurring events * fixed display of text attachments in messages *
 fixed contextual menu on newly created address books * fixed
 missing sender in mail notifications to removed attendees *
 improved invitations handling in iCal
 
 New extensions for Mozilla Thunderbird 3.1 and 10 ESR have also
 been generated.
 
 See http://www.sogo.nu/bugs/changelog_page.php?project_id=1 for
 closed tickets and
 http://sogo.nu/files/downloads/SOGo/Sources/ChangeLog for the
 complete change log.
 
 === Getting SOGo ===
 
 SOGo is free software and is distributed under the GNU GPL. As
 such, you are free to download and try it by visiting the following
 page :
 
 http://www.sogo.nu/downloads/backend.html
 
 You can also download the sources by following the instructions on
 this page:
 
 http://www.sogo.nu/development/source_code.html
 
 Frontend clients such as Mozilla Thunderbird, Mozilla Lightning
 (Inverse Edition), SOGo Connector and SOGo Integrator extensions
 are available for download from :
 
 http://www.sogo.nu/downloads/frontends.html
 
 Documentation about the installation and configuration of SOGo,
 Thunderbird or mobile devices is available from :
 
 http://www.sogo.nu/downloads/documentation.html
 
 You can also try our online SOGo demo at :
 
 http://www.sogo.nu/tour/online_demo.html
 
 === Upgrading to v1.3.17 ===
 
 Run the shell script sql-update-1.3.16_to_1.3.17.sh or sql-update-
 1.3.16_to_1.3.17-mysql.sh (if you use MySQL). This will grow the
 “cycle info” field of calendar tables to a larger size.
 
 === How can I help ? ===
 
 SOGo is a collaborative effort in order to create the best Free and
 Open Source groupware solution.
 
 There are multiple ways you can contribute to the project :
 
 * Documentation reviews, enhancements and translations * Write test
 cases - if you know Python, join in! * Feature requests or by
 sharing your ideas (see the roadmap) * Participate to the
 discussion in mailing lists * Patches for bugs or enhancements
 (http://www.sogo.nu/bugs) * Provide new translations
 (http://sogo.nu/english/support/faq/article/how-to-translate-sogo-in-another-language-2.html)

  Feel free to send us your questions. You can also post them to the
 SOGo mailing list: http://sogo.nu/lists/
 
 === Getting Support ===
 
 For any questions, do not hesitate to contact us by writing 

Re: [SOGo] Error processing message Funambol + SOGo

[Frank Pauxberger]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Just filed a bug report. Thanks Christian.

Frank



-  Original-Nachricht 
Betreff: Re: [SOGo] Error processing message Funambol + SOGo
Von: Christian Mack christian.m...@uni-konstanz.de
An: users@sogo.nu, Frank fr...@pauxberger.de
Datum: Dienstag, 10. April 2012 10:54:49

 Hello Frank
 
 
 On 2012-04-09 18:02, Frank wrote:
 
 I am having a sync error, using funambol 10.0.3 and SOGo 1.3.14.
 Currently I am fooling around with two user accounts, paux and
 cathrin. The sync works quite well, but now I ran into a
 problem, that a calendar item which has been marked as private
 in paux's calendar causes the entire calendar sync to for user
 cathrin (who has got read permissions on that calendar) to fail.
 
 I am not seeing any issues in the SOGo log, but the funambol log
 shows the following entry (previous calendar items are synced
 well):
 
 ... [2012-04-09 17:46:41,949] [funambol.sogo] [INFO] 
 [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [sogo-event] getSyncItemFromId( {
 keyValue: 360-4F53C180-783-7197DE00 } ) [2012-04-09 17:46:41,950]
 [funambol.sogo] [INFO] [2D6A8F3AEFD453A9E60CF2BFFA4FD10A]
 [192.168.178.25] [fac-356357045958331] [cathrin] [sogo-event]
 Preferred item type: 1 [2012-04-09 17:46:41,950] [funambol.sogo]
 [INFO] [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [sogo-event] Getting
 classification for key: 360-4F53C180-783-7197DE00 in location:
 sogopaux0047bc5bc56 [2012-04-09 17:46:41,950] [funambol.sogo]
 [INFO] [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [sogo-event] Item found, returned
 role: 16 [2012-04-09 17:46:41,950] [funambol.sogo] [INFO] 
 [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [sogo-event] Looking up roles for
 cathrin object: /paux/Calendar/personal tablename:
 sogopaux0047bc5bc56_acl [2012-04-09 17:46:41,950] [funambol.sogo]
 [INFO] [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [sogo-event] Found role:
 ConfidentialDAndTViewer [2012-04-09 17:46:41,950] [funambol.sogo]
 [INFO] [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [sogo-event] Found role:
 PublicViewer [2012-04-09 17:46:41,950] [funambol.sogo] [INFO] 
 [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [sogo-event] Found role:
 ObjectCreator [2012-04-09 17:46:41,950] [funambol.sogo] [INFO] 
 [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [sogo-event] classification: 16
 role: 80 roles: 1 [2012-04-09 17:46:41,950] [funambol.handler]
 [ERROR] [2D6A8F3AEFD453A9E60CF2BFFA4FD10A] [192.168.178.25]
 [fac-356357045958331] [cathrin] [] Error processing message 
 java.lang.NullPointerException at 
 com.funambol.server.engine.Sync4jEngine.completeItemInfo(Sync4jEngine.java:1922)

 
at
 com.funambol.server.session.SyncSessionHandler.splitSyncCommand(SyncSessionHandler.java:2675)

 
at
 com.funambol.server.session.SyncSessionHandler.commandsToSend(SyncSessionHandler.java:2592)

 
at
 com.funambol.server.session.SyncSessionHandler.processInitSyncMapMessage(SyncSessionHandler.java:1064)

 
at
 com.funambol.server.session.SyncSessionHandler.processMessage(SyncSessionHandler.java:544)

 
at
 com.funambol.server.engine.SyncAdapter.processInputMessage(SyncAdapter.java:491)

 
at
 com.funambol.server.engine.SyncAdapter.processMessage(SyncAdapter.java:442)

 
at
 com.funambol.server.engine.SyncAdapter.processWBXMLMessage(SyncAdapter.java:265)

 
at
 com.funambol.transport.http.server.LocalSyncHolder.processWBXMLMessage(LocalSyncHolder.java:118)

 
at
 com.funambol.transport.http.server.Sync4jServlet.doPost(Sync4jServlet.java:398)

 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 
 at 
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

 
at
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 
at
 com.funambol.transport.http.server.LogContextFilter.doFilter(LogContextFilter.java:137)

 
at
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 
at
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 
at
 com.funambol.transport.http.server.SyncResponseTimeFilter.doFilter(SyncResponseTimeFilter.java:151)

 
at
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

 
at
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 
at
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

 
at
 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

 
at