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/
use...@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/
use...@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:mypassw...@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/use...@example.ru/Calendar/personal | Users |
use...@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)
Where he found 127.0.0.1 in my config, and how it hit into my mysql db?
--
users@sogo.nu
https://inverse.ca/sogo/lists
