[SOGo] BTS activities for Sunday, February 12 2017

2017-02-12 Thread SOGo reporter 
Title: BTS activities for Sunday, February 12 2017





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Sunday, February 12 2017

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
4024
	2017-02-12 09:40:45
	updated (open)
	ActiveSync
	Samsung Mail doesn´t sync contacts with AtiveSync

Re: [SOGo] Automatic subscription to calendars for web interface

2017-02-12 Thread mgwebm...@fastmail.fm 
Hi,

First post here.

Sorry for resuscitating this old thread. Does those instruction apply to the 
current version of Sogo (3.2) ? It looks like the UI has changed, and it looks 
like nothing useful can be achieved when opening the administration / rights 
page : when clicking on a user’s resource, the right pane stays empty.

Thanks for helping,

Matthieu
 
> On 08 Jan 2016, at 15:45, Christian Mack  
> wrote:
> 
> Hello
> 
> Am 06.01.2016 um 13:29 schrieb Jan Baumgart:
>> Hi all,
>> 
>> Is it possible to automatically add calendar subscriptions to new users,
>> who are using the web interface?
>> 
>> We have three public resource calendars for room booking, which every
>> user should have as "default" subscriptions.
>> 
>> I haven't found anything in the configuration manual, so this feature is
>> probably not implemented.
>> 
>> Maybe there is a safe way for the admin to manually add subscriptions
>> into the sql database for every user?
>> 
> 
> 1) You need a user which is listed in SOGoSuperUsernames for the needed
> privileges.
> 2) Login as this super user into the webinterface.
> 3) Go to menu "Administration".
> 4) in the search field at the top right corner type the account name of
> your resource.
> 5) in the result list open the resource account by pressing the plus
> sign before it.
> 6) double click on the resource calendar you want to add the additional
> user.
> 7) in the opening preferences list press the "Add..." icon (the green
> plus one).
> 8) search for the user to add in the user search window
> 9) Select the one you want and press the "Add" button
> 10) close the user search window
> 11) double click the before added user in the privileges list.
> 12) set the privileges for that user
> 13) close the privileges window
> 14) set "subscribe user" for that user
> 15) close the priviliges list window
> 
> When the user now logs in, he will have the resources calendar in his list.
> 
> 
> Kind regards,
> Christian Mack
> 
> -- 
> Christian Mack
> Universität Konstanz
> Kommunikations-, Informations-, Medienzentrum (KIM)
> Abteilung Basisdienste
> 78457 Konstanz
> +49 7531 88-4416
> 

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

[SOGo] WebMail / Creating New Massage shortcut

2017-02-12 Thread Andreas 
Hi,

our users frequently use WebMail. Some times ago there has been added a
new feature: When clicking on the "create new email" button two options
are shown: create new email/create new email in a new window. I
understand that some users need this feature, but it makes it necessary
to click twice to start writing a new mail. Is there any possibility to
disable it or to set a default option?


Thanks,

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

[SOGo] Calendar can't cannot to mysql database, strange configuration error

2017-02-12 Thread imfromtheh...@gmail.com 
Hi everyone,
I have sogo 3.2a installed on my server1 and mail server2 (postfix, dovecot
etc) on another server2
everything works fine except Calendar, i cant save anything to calendar
(event, to-do etc).

The part of error log is:

2017-02-12 15:59:05.481 sogod[100573] ERROR: could not open MySQL4
connection to database 'sogo': Access denied for user 'sogo'@'localhost'
(using password: YES)
Feb 12 15:59:05 sogod [100573]: [ERROR]
<0x0x7fcafbbfc640[GCSChannelManager]> could not open channel
<MySQL4Channel[0x0x7fcafc7e26f0] connection=0x(null)> for mysql://
127.0.0.1/sogo/sogouser.asen0016f56fcd8
Feb 12 15:59:05 sogod [100573]: [WARN]
<0x0x7fcafbbfc640[GCSChannelManager]>   will prevent opening of this
channel 5 seconds after 2017-02-12 15:59:05 +0300
Feb 12 15:59:05 sogod [100573]: [ERROR] <0x0x7fcafc8bdf60[GCSFolder]>
 could not open storage channel!
Feb 12 15:59:05 sogod [100573]: [ERROR] <0x0x7fcafc8bdf60[GCSFolder]>
 could not open storage channel!
Feb 12 15:59:05 sogod [100573]: [ERROR]
<0x7fcafc80b530[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder
fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]):
fetch failed!
Feb 12 15:59:05 sogod [100573]: 5.18.62.183 "GET /SOGo/so/
use...@example.ru/Calendar/eventsblocks?ed=20170212=20170212=multicolumndayview
HTTP/1.1" 200 567/0 0.008 - - 0
Feb 12 15:59:05 sogod [100574]: [ERROR] <0x0x7fcafc684770[GCSFolder]>
 could not open storage channel!
Feb 12 15:59:05 sogod [100574]: [ERROR] <0x0x7fcafc684770[GCSFolder]>
 could not open storage channel!
Feb 12 15:59:05 sogod [100574]: [ERROR]
<0x7fcafc7bc1d0[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder
fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]):
fetch failed!
Feb 12 15:59:05 sogod [100574]: 5.18.62.183 "GET /SOGo/so/
use...@example.ru/Calendar/eventslist?asc=1=20170212=view_next7=title_Category_Location=start=
HTTP/1.1" 200 439/0 0.014 - - 0

I know about OCSFolderInfoURL:
In my sogo.conf itis  look's like:
OCSFolderInfoURL = "mysql://
sogo:mypassw...@mail.mydomainname.ru:3306/sogo/sogo_folder_info";

And strange thing is:

mysql> select * from sogo_folder_info;
+-++-+---+--+--+-+---+-+---+---+
| c_folder_id | c_path | c_path1 |
c_path2   | c_path3  | c_path4  | c_foldername
   | c_location
   | c_quick_location
 | c_acl_location
 | c_folder_type |
+-++-+---+--+--+-+---+-+---+---+
|   5 | /Users/use...@example.ru/Calendar/personal  | Users   |
use...@example.ru  | Calendar | personal | Персональный календарь
   | mysql://sogo:userpassword@127.0.0.1:3306/sogo/usera00169e4bfb4
| mysql://sogo:userpassword@127.0.0.1:3306/sogo/usera00169e4bfb4_quick |
mysql://sogo:userpassword@127.0.0.1:3306/sogo/usera00169e4bfb4_acl |
Appointment   |

+-++-+---+--+--+-+---+-+---+---+
5 rows in set (0.00 sec)

Where he found 127.0.0.1 in my config, and how it hit into my mysql db?
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Got incomplete multibyte sequence. ToEncode: UTF-16LE FromEncode: UTF-8 SOGo 3.2.6a

2017-02-12 Thread imfromtheh...@gmail.com 
Hello,
You mean  about email sender adress?
I guess it's is not sogo issue, email address wich we recieving icorrect
headers used for automatic annocement's posting.
But on rouncube we dont have such error's.

2017-02-12 14:47 GMT+03:00 André Schild :

> Hello,
>
>
> have you a way to track it down to a specific email?
>
>
> André
>
> Am 10.02.2017 um 18:30 schrieb Никита (imfromtheh...@gmail.com):
>
> Hello everyone,
> I have sogo version 3.2.6a sogo installed, The problem is sometimes i
> have wrong character encodings in a mail topic (incorrect sender name). Here
> is a part of my sogo.log Feb 10 20:19:26 sogod [100573]:
> <0x0x7fcaf7350bc0[NSString]> Got incomplete multibyte sequence. ToEncode:
> UTF-16LE FromEncode: UTF-8 Feb 10 20:19:26 sogod [100573]:
> <0x0x7fcaf7350bc0[NSString]> Got invalid multibyte sequence. ToEncode:
> UTF-16LE FromEncode: UTF-8. I tried to find any information, and i dont
> found anything.
> -- 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] appointments from iPhone with emoticons

2017-02-12 Thread Andreas Blaha 
Hello Chris,
Many thanks for this and the detailed description!
I will have to consider if this is worth the effort. Could you by any chance 
let me know the parameter responsible for this in SOGo?

Best regards 

Andy

> Am 11.02.2017 um 21:02 schrieb Chris Coleman :
> 
> UTF-8 encoding fully supports emoticons; however, MySQL’s limited version of 
> utf8 does not support emoticons!
> MySQL’s utf8 can only store 3 byte characters, which are characters from the 
> Basic Multilingual Plane - characters from the majority of modern languages 
> and some symbols.  Emoticon characters exist in the Supplementary 
> Multilingual Plane for which we need 4 bytes and so must use utf8mb4.
> 
> To save emoticons to a MySQL database we need to change the character set and 
> collation properties, on the database connection, the database, the tables, 
> and the columns, to use utf8mb4.  Not necessarily all the columns, a minimal 
> solution has utf8mb4 on only the columns containing user-entered text.
> 
> Below find commands to change the character set and collation properties.  
> For pro users only.   Warning, backup your entire database before trying this 
> because the risk of data loss is real:
> SET NAMES utf8mb4;
> ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = 
> utf8mb4_unicode_ci;
> 
> ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE 
> utf8mb4_unicode_ci;
> 
> ALTER TABLE table_name CHANGE column_name column_name VARCHAR(140) CHARACTER 
> SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
> 
> ** Bear in mind that changing from utf8 to utfmb4 affects the maximum lengths 
> of columns and index keys. The maximum lengths of columns will be unchanged 
> when modifying the tables with the commands discussed here; but in terms of 
> actual characters the amount that can be stored is reduced. This is a 
> consequence of changing from being able to store only 3 bytes up to 4! You 
> may need to update these lengths. **
> 
> REPAIR TABLE table_name;
> OPTIMIZE TABLE table_name;
> 
> $ mysqlcheck -u root -p --auto-repair --optimize --all-databases
> 
> Finally to change the character set of the connection, that setting must be 
> changed inside the SOGo application.
> 
> Hope this helps.
> 
> 
>> On 2/10/2017 9:21 AM, "Andreas Blaha" (andr...@blaha.at) wrote:
>> Hi all,
>> strange request from a user:
>> when an appointment created on the iphone/ipad contains an emoticon 
>> (wherever: title, notes, location etc.) the appointment is visible and 
>> manageable on the iphone/ipad, but not in the web gui. It can be seen but 
>> does not give any details, cannot be edited or deleted from there, I cannot 
>> view the source text of the appointment, but I get the according reminders. 
>> The appointment is not visible at all in Outlook 201x/ActiveSync. This 
>> behaviour I can reproduce, both in 2.3.19 and 3.2.6a.
>> I only found an open bug referring to UTF8, not sure if this has anything to 
>> do with it.
>> I have no Android device at hand to check whether it is the same there or 
>> not.
>>  
>> Has anyone experienced this as well?
>>  
>> Best regards
>> Andy
>> -- 
>> users@sogo.nu
>> https://inverse.ca/sogo/lists
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Got incomplete multibyte sequence. ToEncode: UTF-16LE FromEncode: UTF-8 SOGo 3.2.6a

2017-02-12 Thread an...@schild.ws 

Hello,


have you a way to track it down to a specific email?


André


Am 10.02.2017 um 18:30 schrieb Никита (imfromtheh...@gmail.com):

Hello everyone,
I have sogo version 3.2.6a sogo installed, The problem is sometimes i 
have wrong character encodings in a mail topic (incorrect sender 
name). Here is a part of my sogo.log Feb 10 20:19:26 sogod [100573]: 
<0x0x7fcaf7350bc0[NSString]> Got incomplete multibyte sequence. 
ToEncode: UTF-16LE FromEncode: UTF-8 Feb 10 20:19:26 sogod [100573]: 
<0x0x7fcaf7350bc0[NSString]> Got invalid multibyte sequence. ToEncode: 
UTF-16LE FromEncode: UTF-8. I tried to find any information, and i 
dont found anything.

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

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