Koozali.org: home of the SME Server

Obsolete Releases => SME 8.x Contribs => Topic started by: miroj on April 15, 2013, 09:45:05 PM

Title: SOGo 2.0.5 issue with Cyrillic content in calendar
Post by: miroj on April 15, 2013, 09:45:05 PM

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?

Title: Re: SOGo 2.0.5 issue with Cyrillic content in calendar
Post by: Daniel B. on April 16, 2013, 01:07:33 PM

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

Title: Re: SOGo 2.0.5 issue with Cyrillic content in calendar
Post by: miroj on April 16, 2013, 08:05:03 PM

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

Title: Re: SOGo 2.0.5 issue with Cyrillic content in calendar
Post by: miroj on May 08, 2013, 11:01:13 PM

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.

Title: Re: SOGo 2.0.5 issue with Cyrillic content in calendar
Post by: Stefano on May 09, 2013, 08:14:36 AM

ok but did you ask in SOGo ml?

Title: Re: SOGo 2.0.5 issue with Cyrillic content in calendar
Post by: miroj on May 09, 2013, 08:41:02 PM

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

Title: Re: SOGo 2.0.5 issue with Cyrillic content in calendar
Post by: miroj on May 13, 2013, 08:39:21 PM

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;

Title: Re: SOGo 2.0.5 issue with Cyrillic content in calendar
Post by: nicolatiana on May 14, 2013, 07:43:56 AM

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