Still no responce? 2017-02-12 16:13 GMT+03:00 Никита <imfromtheh...@gmail.com>:
> 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: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/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