View Issue Details

IDProjectCategoryView StatusLast Update
0004056SOGoWeb Calendarpublic2017-02-26 11:31
ReporterIlin Nikita Assigned Toludovic  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Product Version3.2.6 
Summary0004056: Calendar can't cannot to mysql database, strange configuration error
Description

Hi everyone,
I have sogo 3.26a installed on my server1 and mail server2 (postfix, dovecot etc) on another server2
everything works fine except Calendar, i cant save anything to calendar (event, to-do etc).

The part of error log is:

2017-02-12 15:59:05.481 sogod[100573] ERROR: could not open MySQL4 connection to database 'sogo': Access denied for user 'sogo'@'localhost' (using password: YES)
Feb 12 15:59:05 sogod [100573]: [ERROR] <0x0x7fcafbbfc640[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x7fcafc7e26f0] connection=0x(null)> for mysql://127.0.0.1/sogo/sogouser.asen0016f56fcd8
Feb 12 15:59:05 sogod [100573]: [WARN] <0x0x7fcafbbfc640[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2017-02-12 15:59:05 +0300
Feb 12 15:59:05 sogod [100573]: [ERROR] <0x0x7fcafc8bdf60[GCSFolder]> could not open storage channel!
Feb 12 15:59:05 sogod [100573]: [ERROR] <0x0x7fcafc8bdf60[GCSFolder]> could not open storage channel!
Feb 12 15:59:05 sogod [100573]: [ERROR] <0x7fcafc80b530[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed!
Feb 12 15:59:05 sogod [100573]: 5.18.62.183 "GET /SOGo/so/user.a@example.ru/Calendar/eventsblocks?ed=20170212&sd=20170212&view=multicolumndayview HTTP/1.1" 200 567/0 0.008 - - 0
Feb 12 15:59:05 sogod [100574]: [ERROR] <0x0x7fcafc684770[GCSFolder]> could not open storage channel!
Feb 12 15:59:05 sogod [100574]: [ERROR] <0x0x7fcafc684770[GCSFolder]> could not open storage channel!
Feb 12 15:59:05 sogod [100574]: [ERROR] <0x7fcafc7bc1d0[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed!
Feb 12 15:59:05 sogod [100574]: 5.18.62.183 "GET /SOGo/so/user.a@example.ru/Calendar/eventslist?asc=1&day=20170212&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 439/0 0.014 - - 0

I know about OCSFolderInfoURL:
In my sogo.conf itis look's like:
OCSFolderInfoURL = "mysql://sogo:mypassword@mail.mydomainname.ru:3306/sogo/sogo_folder_info";

And strange thing is:

mysql> select * from sogo_folder_info;
+-------------+------------------------------------------------+---------+-----------------------+----------+----------+---------------------------------------------+-------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------+---------------+
| c_folder_id | c_path | c_path1 | c_path2 | c_path3 | c_path4 | c_foldername | c_location | c_quick_location | c_acl_location | c_folder_type |
+-------------+------------------------------------------------+---------+-----------------------+----------+----------+---------------------------------------------+-------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------+---------------+
| 5 | /Users/user.a@example.ru/Calendar/personal | Users | user.a@example.ru | Calendar | personal | ???????????? ????????? | mysql://sogo:userpassword@127.0.0.1:3306/sogo/usera00169e4bfb4 | mysql://sogo:userpassword@127.0.0.1:3306/sogo/usera00169e4bfb4_quick | mysql://sogo:userpassword@127.0.0.1:3306/sogo/usera00169e4bfb4_acl | Appointment |

+-------------+------------------------------------------------+---------+-----------------------+----------+----------+---------------------------------------------+-------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------+---------------+
5 rows in set (0.00 sec)

How 127.0.0.1 hit in my mysq db?

TagsNo tags attached.

Activities

ludovic

ludovic

2017-02-26 11:31

reporter   ~0011381

Config issue - you did set your DB config to 127.0.0.1 in your sogo.conf and you have entries pointing to that in the sogo_folder_info table. Update those entries if you want.

Issue History

Date Modified Username Field Change
2017-02-25 22:48 Ilin Nikita New Issue
2017-02-26 11:31 ludovic Note Added: 0011381
2017-02-26 11:31 ludovic Status new => closed
2017-02-26 11:31 ludovic Assigned To => ludovic
2017-02-26 11:31 ludovic Resolution open => no change required