View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003645SOGowith SOGopublic2016-04-26 14:002016-04-26 19:55
ReporterKeith Assigned Toludovic  
PrioritynormalSeveritymajorReproducibilityhave not tried
Status resolvedResolutionno change required 
Platform[Server] LinuxOSRHEL/CentOSOS Version7
Product Versionnightly v2 
Summary0003645: SOGo Connection to MySQL
Description

Testing latest git/nightly. (26 April 3:54pm SAST)

After compiling and upgrading to latest git. Login to SOGo via web interface and ActiveSync devices (Outlook 2016 & IOS 9.3.1) fails.

ActiveSync devices pop-up password dialogs.

Web interface does not load login screen (blank).

The following is noted in the logs:

Apr 26 15:44:41 sogod [1084]: [ERROR] <0x0x7f99419029f0[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x7f99417db720] connection=0x(null)> for mysql://localhost/sogo/sogo_user_profile
Apr 26 15:44:41 sogod [1084]: [WARN] <0x0x7f99419029f0[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2016-04-26 15:44:40 +0200
2016-04-26 15:44:41.137 sogod[1086] ERROR: could not open MySQL4 connection to database 'sogo': Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Apr 26 15:44:41 sogod [1086]: [ERROR] <0x0x7f9941866b10[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x7f9941780be0] connection=0x(null)> for mysql://localhost/sogo/sogo_user_profile
Apr 26 15:44:41 sogod [1086]: [WARN] <0x0x7f9941866b10[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2016-04-26 15:44:40 +0200

Can confirm that socket is available for MariaDB/MySQL.

Nothing changed from previous setup (MySQL/configs) only SOGo/Sope was updated to latest.

Reverting to previous git source resolves the issue.

Additional Information

CentOS 7 64bit (all latest updates) as server and build host.

TagsNo tags attached.

Activities

ludovic

ludovic

2016-04-26 15:43

administrator   ~0010014

What previous git source?

NOTHING in the backend has changed yesterday.
Keith

Keith

2016-04-26 16:03

reporter   ~0010018

My apologies,

I have only recently been building SOGo. Between builds I leave it for at least a week or more so more bugs are resolved before I make another build.

The git version I have working is from the 16 April 2016.
ludovic

ludovic

2016-04-26 16:04

administrator   ~0010019

Does your password to the db contain any non-alphanumeric character?
Keith

Keith

2016-04-26 16:07

reporter   ~0010020

It does indeed.

I have a exclamation mark in there (!)
ludovic

ludovic

2016-04-26 16:08

administrator   ~0010021

URL-encode it.
Keith

Keith

2016-04-26 16:08

reporter   ~0010022

I will report back asap.
ludovic

ludovic

2016-04-26 19:55

administrator   ~0010024

Reopen if necessary.

Issue History

Date Modified Username Field Change
2016-04-26 14:00 Keith New Issue
2016-04-26 15:43 ludovic Note Added: 0010014
2016-04-26 16:03 Keith Note Added: 0010018
2016-04-26 16:04 ludovic Note Added: 0010019
2016-04-26 16:07 Keith Note Added: 0010020
2016-04-26 16:08 ludovic Note Added: 0010021
2016-04-26 16:08 Keith Note Added: 0010022
2016-04-26 19:55 ludovic Note Added: 0010024
2016-04-26 19:55 ludovic Status new => resolved
2016-04-26 19:55 ludovic Resolution open => no change required
2016-04-26 19:55 ludovic Assigned To => ludovic