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