General discussion on installation and configuration of SOGo

Text archives Help


[SOGo] Calendar can't cannot to mysql database, strange configuration error


Chronological Thread 
  • From: Никита ( ) < >
  • To:
  • Subject: [SOGo] Calendar can't cannot to mysql database, strange configuration error
  • Date: Sun, 12 Feb 2017 16:13:21 +0300
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca 83E61CA8D9A

Hi everyone,
I have sogo 3.2a 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/ /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!

I know about OCSFolderInfoURL:
In my sogo.conf itis  look's like:

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 rows in set (0.00 sec)

Where he found 127.0.0.1 in my config, and how it hit into my mysql db?



Archive powered by MHonArc 2.6.18.

Top of page