0003699: New db sturcture documenation - OCSSessionsFolderURL change - SOGo

ID	Project	Category	View Status	Date Submitted	Last Update

0003699	SOGo	Documentation	public	2016-05-26 18:35	2016-05-31 15:43

Reporter	cwright	Assigned To	plevesque
Priority	normal	Severity	minor	Reproducibility	N/A
Status	resolved	Resolution	fixed
Product Version	3.1.0
Fixed in Version	nightly v2

Summary	0003699: 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.
Tags	No tags attached.

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 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,

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