Re: [SOGo] SOGo and PostfixAdmin - is there a list of additional fields like telephone number, screen name?

2014-04-03 Thread Christian Mack
Am 2014-03-29 02:50, schrieb Thomas Harold:
 We have what is a pretty common setup: Postfix  Dovecot both
 authenticating against a PostfixAdmin database (called mails) stored
 in PostgreSQL running on the localhost.
 
 For SOGo to authenticate against a database, we setup the following view
 against the mailbox table in our mails database.
 
 ... 
 I have figured out that if I add the following field to the mailbox
 table and export in the view without the x_sogo_ prefix, it shows up
 in the SOGo Web client address book as the work number.
 
 x_sogo_c_telephonenumber character varying(255) - c_telephonenumber (in
 the VIEW)
 
 The question I have is this, if we want to add other fields to the
 mailbox table (and the sogo_authentication view), is there a list
 somewhere of what field name and data type that SOGo is expecting for
 each new field?
 

I don't use SQL auth.

I only know of the LDAP Attribute Mapping list in the SOGo
Installation Guide page 25.
But perhaps you can use these attribute names with a c_ prefix.
You could try to use e.g. c_mozillanickname for the nickname.
As for the data type, with the c_ prefix it should be character
varying(255).

But as I said, you have to test this yourself.


Kind regards,
Christian Mack

-- 
Christian Mack
Abteilung Basisdienste
KIM IT-Services
Universität Konstanz



smime.p7s
Description: S/MIME Cryptographic Signature


Re: [SOGo] free/busy time off by 23 h

2014-04-03 Thread Christian Mack
Hello Pavel Cahyna

Am 2014-03-31 15:07, schrieb Pavel Cahyna:
 
 when I tried to invite people/resources to a meeting, I noted that their
 free/busy information is off by 23 h. E.g. if I have a meeting on the
 1st of April at 14:00, I am being shown as occupied on the 2nd of April
 at 13:00. This happens consistently for all events and only in the web
 interface. In Thunderbird/Ligthning the free/busy time is shown
 correctly.
 
 It started happening recently but I do not know if it is due to SOGo
 upgrade to 2.2.2 (from 2.1.1b ) or by the daylight saving time which
 started on the 30th.
 
 Does this happen for anyone else? It is quite a serious problem.
 

Did you perhaps change the preferences setting for Preferences --
General -- Current Time Zone ?

Kind regards,
Christian Mack

-- 
Christian Mack
Abteilung Basisdienste
KIM IT-Services
Universität Konstanz



smime.p7s
Description: S/MIME Cryptographic Signature


Re: [SOGo] Apple iCal 7.0, DAV property .... has no matching SQL field and Apple Internet-Accounts OS X 10.9.2

2014-04-03 Thread Christian Mack
Hello Götz Reinicke


Am 2014-04-01 14:07, schrieb Götz Reinicke - IT Koordinator:
 
 I added my sogo account to a new mac book with os x 10.9.2 and iCal 7
 using the Internet Account systemprefs tool.
 
 All sogo calenders show up and looks good so far.
 
 On the sogo-2.2.2-1.centos6.x86_64 server I do get some Errors in the logs:
 
 Apr 01 13:56:34 sogod [15521]: [ERROR]
 0x432536E8[SOGoAppointmentFolder]:4B7-51C1B080-3-72BFEC00 DAV property
 '{http://calendarserver.org/ns/}created-by' has no matching SQL field,
 response could be incomplete
 
 Apr 01 13:56:34 sogod [15521]: [ERROR]
 0x432536E8[SOGoAppointmentFolder]:4B7-51C1B080-3-72BFEC00 DAV property
 '{http://calendarserver.org/ns/}updated-by' has no matching SQL field,
 response could be incomplete
 
 Apr 01 13:56:34 sogod [15521]: [ERROR]
 0x432536E8[SOGoAppointmentFolder]:4B7-51C1B080-3-72BFEC00 DAV property
 '{urn:ietf:params:xml:ns:caldav}schedule-tag' has no matching SQL field,
 response could be incomplete
 
 
 Is this a known issue with some workaround or without harm anyway?
 
 
   Any suggestions? Hints etc :) are welcome . Regards Götz
 

These errors are normal, and can be ignored.
They simply say, that apple tries to get some new information fields,
which are not there in SOGo.


Kind regards,
Christian Mack

-- 
Christian Mack
Abteilung Basisdienste
KIM IT-Services
Universität Konstanz



smime.p7s
Description: S/MIME Cryptographic Signature


[SOGo] ActiveSync sync period

2014-04-03 Thread Szládovics Péter

Dear Gents,

I don't know it's AS standard or not, but the old mails are shows on my 
Android device.
My sync period is 1 week, but I find elements in folders what are older 
than a week. When I do a manual sync, the old mails stay in the box/folder.
Other AS boxes (real Exchange, PHP-Push2) work different, they are 
removes the old mails (what are older than sync period) from the device 
cache, and they are disappeared from the phone (only the phone, the 
mails stay the mailbox folder physically).


What is the truth?
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] free/busy time off by 23 h

2014-04-03 Thread Pavel Cahyna



Hello Christian Mack,

On Thu, Apr 03, 2014 at 08:48:16AM +0200, Christian Mack wrote:
 Hello Pavel Cahyna
 
 Am 2014-03-31 15:07, schrieb Pavel Cahyna:
  
  when I tried to invite people/resources to a meeting, I noted that their
  free/busy information is off by 23 h. E.g. if I have a meeting on the
  1st of April at 14:00, I am being shown as occupied on the 2nd of April
  at 13:00. This happens consistently for all events and only in the web
  interface. In Thunderbird/Ligthning the free/busy time is shown
  correctly.
  
  It started happening recently but I do not know if it is due to SOGo
  upgrade to 2.2.2 (from 2.1.1b ) or by the daylight saving time which
  started on the 30th.
  
  Does this happen for anyone else? It is quite a serious problem.
  
 
 Did you perhaps change the preferences setting for Preferences --
 General -- Current Time Zone ?

I checked, and no. The timezone is Europe/Prague, as it should be.

I can not reproduce the problem anymore for newly created events. However the
events created in the time frame when the problem was there are still being
displayed incorrectly.

Moreover I discovered that the events created by SOGo 2.1.1b are displayed
correctly (could be due to the daylight saving time start though as I upgraded
SOGo at about the same time as the DST started) and even the events created by
some users in SOGo 2.2.2 are displayed correctly (although they are created at
the time when I could reproduce the problem, so for different users the problem
went away at different times). I don't know what the difference between the
users is, but it seems to depend on the user that created the event rather than
on the user who views the information (that is, I can look at the free/busy
time of an user who does not suffer from the problem and it is displayed
correctly although for my events it is incorrect). 

I've looked at the raw source of the events in the web interface and I do not
see any obvious difference. The timezone information is identical
(Europe/Prague). Is there some more information about the events in the SQL
database?

It is only the free/busy display in the Invite attendees dialog that is off
by 23h, in the calendar view it is correct. It is really a mystery...

Pavel Cahyna


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


[SOGo] Problem about SOGo accessibility

2014-04-03 Thread Vincent Lucas

Hello,

I am looking for advices on how to configure SOGo in order to enhance 
its accessibility.


For example, I know a partially-sighted person which needs to configure 
its browser with a white text on a dark-blue background. Most of the 
texts (i.e. when reading emails) are correctly rendered using white 
color, but some (the most important one when writing an email) are 
displayed in black (which makes it not readable at all on a dark-blue 
background).


Do you have any suggestions in order to:
- Configure SOGo in order to correct this problem?
- Maybe planning a correction taking into account this issue?
- Or at least, giving me an hint in order to determine if I can produce 
a fix for this issue?


Best regards,
Vincent Lucas
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Problem about SOGo accessibility

2014-04-03 Thread Sven Schwedas
Hi,

On 2014-04-03 16:12, Vincent Lucas wrote:
 Hello,
 
 I am looking for advices on how to configure SOGo in order to enhance
 its accessibility.
 
 For example, I know a partially-sighted person which needs to configure
 its browser with a white text on a dark-blue background. Most of the
 texts (i.e. when reading emails) are correctly rendered using white
 color, but some (the most important one when writing an email) are
 displayed in black (which makes it not readable at all on a dark-blue
 background).

Wouldn't a user CSS style enforcing the colour scheme be the easiest
solution? Greasemonkey or equivalent extensions should do the trick.

 Do you have any suggestions in order to:
 - Configure SOGo in order to correct this problem?
 - Maybe planning a correction taking into account this issue?
 - Or at least, giving me an hint in order to determine if I can produce
 a fix for this issue?
 
 Best regards,
 Vincent Lucas

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


[SOGo] ANN: SOGo v2.2.3

2014-04-03 Thread Francis Lachapelle
The Inverse Team is pleased to announce the immediate availability of SOGo 
2.2.3. 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, Apple Calendar 
and Address Book (OSX and iOS) and Microsoft Outlook.

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
Native compatibility for Microsoft Outlook 2003, 2007 and 2010
Two-way synchronization support with any Microsoft ActiveSync-capable device 
(Apple iOS, Android, Windows Phone, BlackBerry 10) or Outlook 2013
Excellent native integration with Apple software (OSX and iOS) and 
Android-based devices
and many more! SOGo and our connectors are completely free.


Changes from the previous release

Enhancements

updated Dutch, Hungarian, Russian and Spanish (Argentina) translations
initial support for ActiveSync event reminders support (#2681)
updated CKEditor to version 4.3.4
Bug fixes

fixed possible exception when retrieving the default event reminder value on 
64bit architectures (#2678)
fixed calling unescapeHTML on null variables to avoid JavaScript exceptions in 
Contacts module
fixed detection of IMAP flags support on the client side (#2664)
fixed the ActiveSync issue marking all mails as read when downloading them
fixed ActiveSync's move operations not working for multiple selections (#2691)
fixed email validation regexp to allow gTLDs
improved all-day events support for ActiveSync (#2686)
See http://www.sogo.nu/bugs/changelog_page.php?project_id=1 for closed tickets 
and https://github.com/inverse-inc/sogo/commits/SOGo-2.2.3 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 
the native Microsoft Outlook compatibility layer 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 v2.2.3

No special measure needs to be taken when upgrading from v2.2.2.


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 to 
supp...@inverse.ca

Customer support packages for SOGo are available from 
http://inverse.ca/support.html-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] AS problem both in v2.2.2 and v2.2.3

2014-04-03 Thread Szládovics Péter

Dear Gents,

In the following situation:
1 - HTML mail sent from Thunderbird or SOGo webapp with UTF-8 characters 
in the subject and the body

2 - message read in the AS client perfectly, and immediately answered in it
3 - the answer has the following errors when arrived:
a) The subject is broken (=?utf-8?q?)
b) Mail body has clear UTF-8 characters (e.g. SzlĂĄdovics PĂŠter as 
my name)

c) The answered mail is in attachment like a kind of forward

I don't know that problems are depend with each other. Could you check 
them please?


About v2.2.3: When a mail arrived on AS device (but not opened it on), 
in the Thunderbird stay unread while not opened it anywhere. Thank you!


--

Üdvözlettel,

Szládovics Péter
informatikus mérnök

Mobiltelefon: +36 20 92 68 098
Onlinedemo.HU http://www.onlinedemo.hu

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

Re: [SOGo] ANN: SOGo v2.2.3

2014-04-03 Thread Ludovic Marcotte

Hello,

For those interested, we also offer since v2.2.3 packages for Ubuntu 
Trusty Tahr.


Use:

deb http://inverse.ca/ubuntu trusty trusty

if you want to install them.

Thanks,

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

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


[SOGo] BTS activities for Thursday, April 03 2014

2014-04-03 Thread SOGo reporter
Title: BTS activities for Thursday, April 03 2014





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Thursday, April 03 2014

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
2654
	2014-04-03 15:15:00
	updated (open)
	ActiveSync
	Calendars are OK through CalDav but are buggy through ActiveSync
	
	  
	
2680
	2014-04-03 15:09:16
	updated (open)
	ActiveSync
	Mobile reply to Blank body
	
	  
	
2700
	2014-04-03 15:08:28
	updated (open)
	ActiveSync
	Outlook folder changes (create/delete/rename/move) not synced correclty
	
	  
	
2489
	2014-04-03 15:13:51
	updated (open)
	Apple iCal.app
	Apple iCal - OS X 10.9 - Delegated Calendars Show Error
	
	  
	
2581
	2014-04-03 16:40:26
	updated (open)
	Apple iCal.app
	ical 7.0 does not work
	
	  
	
2699
	2014-04-03 15:09:42
	updated (open)
	Backend General
	test_parsing unit test fails
	
	  
	
2697
	2014-04-03 08:47:35
	updated (open)
	Web Address Book
	Web address Book - multiple books and many contacts buugged view and filter
	
	  
	
2698
	2014-04-03 04:08:47
	updated (open)
	Web Calendar
	Event added by the administrator for public calendar is not seen for a normal user who has full privileges to the same public ca
	
	  
	
2670
	2014-04-03 12:24:19
	updated (open)
	Web Mail
	Sogo Webmail global search
	
	  
	
2675
	2014-04-03 17:31:26
	updated (open)
	Web Mail
	Error adding a second attachment
	
	  
	
2695
	2014-04-03 15:10:39
	assigned (open)
	ActiveSync
	Outlook events with ampersand in title
	
	  
	
1636
	2014-04-03 16:33:55
	assigned (open)
	Web Address Book
	birth date validity check missing
	
	  
	
2612
	2014-04-03 16:34:05
	assigned (open)
	Web General
	Display version number while logged in, eg. in preferences
	
	  
	
2616
	2014-04-03 16:34:55
	assigned (open)
	Web General
	URLs contain double slashes
	
	  
	
2622
	2014-04-03 15:14:24
	assigned (open)
	Web Preferences
	Wrong UTF-7 encoding names of mail folders in Sieve filters
	
	  
	
2267
	2014-04-03 11:37:42
	resolved (fixed)
	Backend Mail
	Wrong UTF-8-coding of From in the header when comma is used
	
	  
	
2120
	2014-04-03 11:37:49
	resolved (fixed)
	Web Mail
	SOGo webmail puts utf-8 characters in from field when accent is present
	
	  
	
2533
	2014-04-03 11:38:11
	resolved (fixed)
	Web Mail
	comma in name results in splitting addres when is utf-8 encoded