Topic: SOGo 2.0.5 issue with Cyrillic content in calendar

[miroj]

Hi, I have successfully installed SOGo 2.0.5 on SME 8 with all updates. I was using the wiki guidance on SOGo contrib. Everything went well, in the mails I can use Cyrillic but I can't within the calendar. Everything in Cyrillic goes in ????. The browser char set is set to UTF-8, as well I was adding the AddDefaultCharset UTF-8 as proposed in http://forums.contribs.org/index.php?topic=48792.0

All other is working like a charm, integration with Thunderbird+Lightning+Connector+Integrator, the same is with Evolution 3.4.2, but in all cases I do have issues with Cyrillic support within the calendar.

What I'm missing?

[Daniel B.]

You should probably ask on sogo mailing list (see http://www.sogo.nu/fr/support/community.html). You can also take a look at the upstream bug tracker (http://www.sogo.nu/bugs/)

Regards, Daniel

[miroj]

Thanks Daniel, I'm looking at SOGo support sites as well. I'm hoping that someone here with similar setup/deployment  (SME 8 + SOGo) might have the right solution.

Regards,

Miroslav

[miroj]

I have tried the ZEG-2.0.5a.ova, appliance of SOGO within VirtualBox, this issue doesn't exists. Cyrillic content in the calendar is presented properly. My problem is not directly connected with SOGO.

[Stefano]

ok but did you ask in SOGo ml?

[miroj]

Yes, I have opened ticket in SOGo Mantis bug reporting tool. I'll investigate furhter my setup during the weekend. Thank you.

[miroj]

Finally I have found the source of my Cyrillic issues. It's the database charset. The SOGo db creation part from smeserver-sogo-0.6-1.el5.nh.noarch.rpm from nethesis repo is creating the database in latin1 charset.

-- SOGo Database Creation

CREATE DATABASE IF NOT EXISTS `sogo`;

CONNECT `sogo`;

CREATE TABLE IF NOT EXISTS `sogo_folder_info` (
  `c_folder_id` bigint(20) unsigned NOT NULL auto_increment,
  `c_path` varchar(255) NOT NULL,
  `c_path1` varchar(255) NOT NULL,
  `c_path2` varchar(255) default NULL,
  `c_path3` varchar(255) default NULL,
  `c_path4` varchar(255) default NULL,
  `c_foldername` varchar(255) NOT NULL,
  `c_location` varchar(2048) NOT NULL,
  `c_quick_location` varchar(2048) default NULL,
  `c_acl_location` varchar(2048) default NULL,
  `c_folder_type` varchar(255) NOT NULL,
  PRIMARY KEY  (`c_path`),
  UNIQUE KEY `c_folder_id` (`c_folder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `sogo_user_profile` (
  `c_uid` varchar(255) NOT NULL,
  `c_defaults` text,
  `c_settings` text,
  PRIMARY KEY  (`c_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[nicolatiana]

Good
Please raise a bug in http://bugs.contribs.org/
 
Nicola