View Issue Details

IDProjectCategoryView StatusLast Update
0003699SOGoDocumentationpublic2016-05-31 15:43
Reportercwright Assigned Toplevesque  
Status resolvedResolutionfixed 
Product Version3.1.0 
Fixed in Versionnightly v2 
Summary0003699: New db sturcture documenation - OCSSessionsFolderURL change

After setting up a new SOGo 3.1.0 installation with MySQL configured to use the new db structure (nine tables), I noticed the following error in sogo.log:

<MySQL4Exception: 0x7f6de5824250> NAME:ExecutionFailed REASON:Table 'sogo.sogo_sessions_folder' doesn't exist

After looking at the sogo.conf in the ZEG, I saw the resolution was to adjust the OCSSessionsFolderURL setting in sogo.conf.

Old Config
OCSSessionsFolderURL = "mysql://sogo:sogo@";

New Config
OCSSessionsFolderURL = "mysql://sogo:sogo@";

Perhaps the documentation could be edited to note this change when the new db structure is configured.

TagsNo tags attached.




2016-05-31 13:44

reporter   ~0010271

Looking at my notes, I realize during setup I ran the script in Scripts/mysql-utf8mb4.sql to give MySQL full UTF-8 compliance.

From the notes in that script:

-- This schema assumes the SOGo table names are configured
-- like the following; adjust if needed:
-- OCSSessionsFolderURL -> sogo_sessions_info

Obviously I missed that.

The only suggestion I have is that the mysql-utf8mb4.sql script continue to use the formerly documented table name for OCSSessionsFolderURL, if possible.



2016-05-31 15:43

reporter   ~0010274

Excellent suggestion; applied to the master branch.

Thanks for your report,

Issue History

Date Modified Username Field Change
2016-05-26 18:35 cwright New Issue
2016-05-31 13:44 cwright Note Added: 0010271
2016-05-31 13:45 ludovic Assigned To => plevesque
2016-05-31 13:45 ludovic Status new => assigned
2016-05-31 15:43 plevesque Note Added: 0010274
2016-05-31 15:43 plevesque Status assigned => resolved
2016-05-31 15:43 plevesque Fixed in Version => nightly v2
2016-05-31 15:43 plevesque Resolution open => fixed