View Issue Details

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

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@127.0.0.1:3306/sogo/sogo_sessions_folder";

New Config
OCSSessionsFolderURL = "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_sessions_info";

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

TagsNo tags attached.

Activities

cwright

cwright

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.

plevesque

plevesque

2016-05-31 15:43

reporter   ~0010274

Excellent suggestion; applied to the master branch.

https://github.com/inverse-inc/sogo/commit/0d507ff0382fb4a6d402781ae02194a6252a75e7

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