Hello Your problem is, that SOGo stores the database link into its database. Therefore it says in the Installation manual: https://sogo.nu/files/docs/SOGoInstallationGuide.html#_database_configuration
" SOGo stores the database hostname together with table references inside several database tables. To prevent possible future issues when moving the database to another host, it is best practice to add a local alias name to your /etc/hosts file, and using this in /etc/sogo/sogo.conf instead of the actual name of your server or localhost. When the database host name changes, you can now simply change the hosts file instead of updating several table columns replacing the old hostname. An example entry for /etc/hosts when running the database on the same host, registering 127.0.0.1 not only for localhost, but also the db-alias alias: 127.0.0.1 localhost db-alias In the SOGo configuration, use the alias name instead of the real IP address or host name, for example SOGoProfileURL = "postgresql://sogo:sogo@db-alias:5432/sogo/sogo_user_profile"; " Kind regards, Christian Mack Am 25.02.2017 um 23:31 schrieb Никита (imfromtheh...@gmail.com): > 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? >> -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature