View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003447SOGoBackend Generalpublic2016-01-19 20:462017-05-31 00:04
Reporterandre.peters Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionsuspended 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Product Version2.3.6 
Summary0003447: MAPIStoreIOException with table name >= 65 chars
Description

Hi,

Using MySQL, got a customer with a long domain name. He sets up a mail address with full.name@superlongdomain.com - result:

EXCEPTION: <NSException: 0x7fbf399c0d00> NAME:MAPIStoreIOException REASON:could not create special table 'sogo_cache_folder_aaaaaaa_a_aaaaaaaa_A_aaaaaaaaaaaaa_aaaaaaa_aaaaaaaaaaa_D_aaa' INFO:(null)

Replaced the chars by "a" (obviously :)

André

TagsNo tags attached.

Activities

andre.peters

andre.peters

2016-01-19 21:01

reporter   ~0009302

Last edited: 2016-01-20 07:18

ocFSTableName = [ocFSTableName substringToIndex: MIN(64, [ocFSTableName length])];

I wonder if my Stackoverflowskills helped me with this one.

Edit: Title should be >=65.
Christian Mack

Christian Mack

2016-01-20 14:14

developer   ~0009304

Title changed as requested
kuadhual

kuadhual

2016-08-08 23:58

reporter   ~0010592

Debian Jessie 8.5
SOGo 3.1.4.20160808-1
MySql 5.5

email format: firstname.lastname@an-22-character-domain.org in live environment.

some user are able to access, but some with long name cannot.

in /var/log/sogo/sogo.log

EXCEPTION: <NSException: 0x7f57fcff8a60> NAME:MAPIStoreIOException REASON:could not create special table 'sogo_cache_folder_firstname_D_lastname_A_an-22-character-domain_D_org' INFO:(null)

I think this is quite critical.
ludovic

ludovic

2017-05-31 00:04

administrator   ~0011888

Suspending all OpenChange tickets.

Issue History

Date Modified Username Field Change
2016-01-19 20:46 andre.peters New Issue
2016-01-19 21:01 andre.peters Note Added: 0009302
2016-01-20 07:18 andre.peters Note Edited: 0009302
2016-01-20 14:14 Christian Mack Note Added: 0009304
2016-01-20 14:14 Christian Mack Summary MAPIStoreIOException with table name >= 64 chars => MAPIStoreIOException with table name >= 65 chars
2016-08-08 23:58 kuadhual Note Added: 0010592
2017-05-31 00:04 ludovic Note Added: 0011888
2017-05-31 00:04 ludovic Status new => closed
2017-05-31 00:04 ludovic Assigned To => ludovic
2017-05-31 00:04 ludovic Resolution open => suspended